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 column IMGPATH_ENABLED
/
alter table DOCUMENTTYPES drop column IMGPATH_DISABLED
/
alter table DOCUMENTTYPES drop column IMGPATH_SHADED
/
alter table DOCUMENTTYPES add IMGPATH varchar2(128)
/
alter table DOCUMENTTYPES add ICON_EXTENSION varchar2(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
/