update SYSPARAMETERS set VALUESTRING = '1'  where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionHigh';
update SYSPARAMETERS set VALUESTRING = '144' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow';
update SYSPARAMETERS set VALUESTRING = '2005-06-23' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate';

alter table DOCUMENTTYPES drop IMGPATH_ENABLED;
alter table DOCUMENTTYPES drop IMGPATH_DISABLED;
alter table DOCUMENTTYPES drop IMGPATH_SHADED;

alter table DOCUMENTTYPES add IMGPATH varchar(128);
alter table DOCUMENTTYPES add ICON_EXTENSION varchar(10);

update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/document' where EXTENSION = '?';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/txt' where EXTENSION = 'TXT';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/pdf' where EXTENSION = 'PDF';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/doc' where EXTENSION = 'DOC';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/html' where EXTENSION = 'HTML';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/ps' where EXTENSION = 'PS';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/ppt' where EXTENSION = 'PPT';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/xls' where EXTENSION = 'XLS';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/rtf' where EXTENSION = 'RTF';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/wpd' where EXTENSION = 'WPD';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/tdf' where EXTENSION = 'TDF';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/note' where EXTENSION = 'NOTE';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/link' where EXTENSION = 'LINK';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/gif' where EXTENSION = 'GIF';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/jpg' where EXTENSION = 'JPG';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/bmp' where EXTENSION = 'BMP';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/png' where EXTENSION = 'PNG';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/exe' where EXTENSION = 'EXE';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/zip' where EXTENSION = 'ZIP';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/xml' where EXTENSION = 'XML';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/eml' where EXTENSION = 'EML';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/msg' where EXTENSION = 'MSG';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/htm' where EXTENSION = 'HTM';
update DOCUMENTTYPES set IMGPATH = '/gfx/documenttype/tex' where EXTENSION = 'TEX';

update DOCUMENTTYPES set ICON_EXTENSION = 'gif' where doctypeid > -1;
commit;