update SYSPARAMETERS set VALUESTRING = '1'  where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionHigh'
/
update SYSPARAMETERS set VALUESTRING = '195' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow'
/
update SYSPARAMETERS set VALUESTRING = '2008-02-12' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate'
/
alter table users add EnableHtmlNotification integer
/
update users set EnableHtmlNotification = 1
/
alter table userregisteredcategories add SubjectForNotification varchar2(320 CHAR)
/
update userregisteredcategories set SubjectForNotification = ''
/
alter table userregistereddocuments add SubjectForNotification varchar2(320 char)
/
update userregistereddocuments set SubjectForNotification = ''
/
alter table userregsearchqueries add SubjectForNotification varchar2(320 char)
/
update userregistereddocuments set SubjectForNotification = ''
/
alter table USERDOCMAILS add SubjectForNotification varchar2(320 char)
/
update USERDOCMAILS set SubjectForNotification = ''
/
commit
/