update SYSPARAMETERS set VALUESTRING = '1'  where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionHigh'
/
update SYSPARAMETERS set VALUESTRING = '131' where CONTEXT = 'SYSTEMINFO' and name = 'DBVersionLow'
/
update SYSPARAMETERS set VALUESTRING = '2004-12-09' where CONTEXT = 'SYSTEMINFO' and name = 'DBCreationDate'
/
CREATE VIEW CATEGORIES_READABLE_BY_GROUP (
  CATEGORYID,
  GROUPID
) AS SELECT
  CATEGORIES.CATEGORYID,
  CATEGORYACLS.ACCESSORID
FROM
  CATEGORIES, CATEGORYACLS, LDAPGROUPS
WHERE CATEGORIES.ACLID = CATEGORYACLS.ACLID
  AND CATEGORYACLS.ACLTYPEID=7
  AND CATEGORYACLS.PERMISSIONID = 2
  AND CATEGORYACLS.ACCESSORID = LDAPGROUPS.LDAPGROUPID
/
commit
/