Reordering and Editing Music Folders

[tnt533]

I need to be able to edit, add to and reorder my servers music folders which I defined when I set the server up and I see there is no way to do this short of erasing and re-adding them all.

After poking around I noticed that within the /var/subsonic/db folder there is a file named subsonic.script which looks to be where the folders are defined and I was curious if I could edit that file to accomplish my goal without hosing the server. They are listed in that file in the order which I defined them. The actual text is pasted below with names withheld to protect the innocent. =)

INSERT INTO MUSIC_FOLDER VALUES(0,'/home/***/Music/Metal','Metal',TRUE,'2014-01-26 10:50:25.544000000')
INSERT INTO MUSIC_FOLDER VALUES(1,'/home/***/Music/Rock','Rock & Roll',TRUE,'2014-01-26 10:50:25.544000000')
INSERT INTO MUSIC_FOLDER VALUES(2,'/home/***/Music/Classic Rock','Classic Rock',TRUE,'2014-01-26 10:50:25.544000000')
INSERT INTO MUSIC_FOLDER VALUES(3,'/home/***/Music/80''s','80''s Music',TRUE,'2014-01-26 10:50:25.544000000')
INSERT INTO MUSIC_FOLDER VALUES(4,'/home/***/Music/Electronic','Electronic',TRUE,'2014-01-26 10:50:25.545000000')
INSERT INTO MUSIC_FOLDER VALUES(5,'/home/***/Music/Rap - R&B - Soul','Rap, R&B and Soul',TRUE,'2014-01-26 10:50:25.545000000')
INSERT INTO MUSIC_FOLDER VALUES(6,'/home/***/Music/*****''s Music','*****''s Music',TRUE,'2014-01-26 10:50:25.545000000')
INSERT INTO MUSIC_FOLDER VALUES(7,'/home/***/Music/Classical','Classical',TRUE,'2014-01-26 10:50:25.545000000')
INSERT INTO MUSIC_FOLDER VALUES(8,'/home/***/Music/Jazz and Blues','Jazz, Blues and Big Band',TRUE,'2014-01-26 10:50:25.545000000')
INSERT INTO MUSIC_FOLDER VALUES(9,'/home/***/Music/Billboard Top 100 1980 - 2010','Billboard 1980 - 2010',TRUE,'2014-01-26 10:50:25.545000000')
INSERT INTO MUSIC_FOLDER VALUES(10,'/home/***/Music/Pop','Pop',TRUE,'2014-01-26 10:50:25.546000000')
INSERT INTO MUSIC_FOLDER VALUES(11,'/home/***/Music/Country and Folk','Country and Folk',TRUE,'2014-01-26 10:50:25.546000000')
INSERT INTO MUSIC_FOLDER VALUES(12,'/home/***/Music/Movie Soundtracks','Movie Soundtracks',TRUE,'2014-01-26 10:50:25.546000000')
INSERT INTO MUSIC_FOLDER VALUES(13,'/home/***/Music/Unsorted','Unsorted',TRUE,'2014-01-26 10:50:25.546000000')

If I reordered these entries, preserving the structure, would this be an acceptable way to accomplish reordering and adding entries mid-list?

[tnt533]

I hate bumping posts but someone has got to know the answer to my question. I can just back up the file and try it but I need to know if there are other unintended consequences I may run into later on or if changing this file will cause changes to be made to other files. I don't want to hose my working system.

Sindre, do you have any input on this? You may very well be the only one who could answer this for me.