I don't know about scripting, but you might be able to manage something via the <installdir>\data\db\subsonic.script (if you're on Windows), or if it isn't that frequent, perhaps manual manipulation via the
http://<server:4040>/db.view SQL query window could be useful. A quick query to identify tables/fields is:
- Code: Select all
SELECT TABLE_NAME, COLUMN_NAME, TYPE_NAME, IS_NULLABLE FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME NOT LIKE 'SYSTEM_%'