/*
    migration script to update a db, which was setup with a version of prior to 1.30
*/
alter table documents alter column archiveid type varchar(36);
alter table additionaldocumentformats alter column archiveid type varchar(36);

update SYSPARAMETERS set VALUESTRING = '31' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow';
update SYSPARAMETERS set VALUESTRING = '2004-02-21' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate';
commit;