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_LGROUP (
  CATEGORYID, 
  LDAPGROUPID
) 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;
