update SYSPARAMETERS set VALUESTRING = '1'  where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionHigh'
/
update SYSPARAMETERS set VALUESTRING = '149' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow'
/
update SYSPARAMETERS set VALUESTRING = '2005-07-14' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate'
/
update DOCUMENTTYPES set CONVERTIBLE = 0  where EXTENSION = 'SXW'
/
update DOCUMENTTYPES set CONVERTIBLE = 0  where EXTENSION = 'SXI'
/
update DOCUMENTTYPES set CONVERTIBLE = 0  where EXTENSION = 'SXC'
/
alter table DOCUMENTTYPES add EDITABLE integer
/
update DOCUMENTTYPES set EDITABLE = 0
/
update DOCUMENTTYPES set EDITABLE = 1 where EXTENSION = 'DOC'
/
update DOCUMENTTYPES set EDITABLE = 1 where EXTENSION = 'PPT'
/
update DOCUMENTTYPES set EDITABLE = 1 where EXTENSION = 'XLS'
/
update DOCUMENTTYPES set EDITABLE = 1 where EXTENSION = 'RTF'
/
insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH, ICON_EXTENSION, CONVERTIBLE, EDITABLE)
     values (27, 'FH8', 'Bildformat für "Free Hand"', 'FH8 Document', 0, 'application/fh8', '/gfx/documenttype/fh8', 'gif', 0, 0)
/
insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH, ICON_EXTENSION, CONVERTIBLE, EDITABLE)
     values (28, 'FH11', 'Bildformat für "Free Hand"', 'FH11 Document', 0, 'application/fh11', '/gfx/documenttype/fh11', 'gif', 0, 0)
/
insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH, ICON_EXTENSION, CONVERTIBLE, EDITABLE)
     values (29, 'ODT', 'OpenOffice Textdatei', 'OpenOffice Textdatei', 0, 'application/odt', '/gfx/documenttype/odt', 'gif', 0, 0)
/
commit
/