
ALTER TABLE Files MODIFY COLUMN FileType TEXT;

ALTER TABLE MetadataFields ADD COLUMN UpdateMethod
        ENUM("NoAutoUpdate","OnRecordCreate","Button","OnRecordEdit",
                "OnRecordChange") DEFAULT "NoAutoUpdate";

UPDATE SystemConfiguration SET DescriptionField = -2 WHERE DescriptionField = -1;
UPDATE SystemConfiguration SET UrlField = -2 WHERE UrlField = -1;
UPDATE SystemConfiguration SET FileField = -2 WHERE FileField = -1;
UPDATE SystemConfiguration SET ScreenshotField = -2 WHERE ScreenshotField = -1;

