/* $Id: vkc_db_interbase_testdata.sql,v 1.2 2004/02/21 10:08:17 bigmac Exp $*/

/* $Log: vkc_db_interbase_testdata.sql,v $
/* Revision 1.2  2004/02/21 10:08:17  bigmac
/* *** empty log message ***
/*
/* Revision 1.30  2003/10/06 08:09:15  jonyp
/* *** empty log message ***
/*
/* Revision 1.29  2003/09/18 15:53:24  jonyp
/* addition to sysparameters
/*
/* Revision 1.28  2003/09/15 22:05:22  koppy
/* ShowCountCatDocs added in SYSPARAMETERS
/*
/* Revision 1.27  2003/09/15 12:44:27  jonyp
/* changes due to new permission "d" in context "category"
/*
/* Revision 1.26  2003/09/09 18:42:32  koppy
/* bugfix: templatefile --> mailfile usw.
/*
/* Revision 1.25  2003/09/08 11:29:54  jonyp
/* changes to template table
/*
/* Revision 1.24  2003/09/01 16:11:53  jonyp
/* changes to table languages
/*
/* Revision 1.23  2003/08/27 12:12:08  jonyp
/* *** empty log message ***
/*
/* Revision 1.22  2003/08/27 10:30:46  jonyp
/* neue testdaten aufgrund änderungen in der tabelle sysparameters
/*
/* Revision 1.21  2003/08/07 16:22:49  marbobo
/* - Title aus Categories entfernt
/*
/* Revision 1.20  2003/07/31 09:18:19  marbobo
/* Admin Passwort: AdminPwd und für User1-User8 : clabauter
/*
/* Revision 1.19  2003/07/30 14:03:01  jonyp
/* table users: new attributes accountvalid/passwdchangedts
/*
/* Revision 1.18  2003/07/30 11:58:02  jonyp
/* several changes
/* */

/* index on categorydocuments */
/* linked documents */
delete from ADDITIONALDOCUMENTFORMATS;
delete from USERREGISTEREDCATEGORIES;
delete from USERREGISTEREDKEYWORDS;
delete from ADDUSERATTRVALUES;
delete from ADDGROUPATTRVALUES;
delete from ADDCATATTRVALUES;
delete from ADDDOCATTRVALUES;
delete from CATEGORYKEYWORDS;
delete from USERGROUPS;
delete from GROUPS;
delete from GROUPACLS;
delete from DOCUMENTACLS;
delete from DOCUMENTKEYWORDS;
delete from ALLOWEDDOCUMENTTYPES;
delete from CATEGORYDOCUMENTS;
delete from DOCUMENTRELATIONS;
delete from DOCUMENTS;
delete from DOCUMENTSTATI;
delete from CATEGORYKEYWORDS;
delete from CATEGORIES where CATEGORYID = 15;
delete from CATEGORYACLS where ACLID = 15;
delete from CATEGORIES where CATEGORYID = 14;
delete from CATEGORYACLS where ACLID = 14;
delete from CATEGORIES where CATEGORYID = 13;
delete from CATEGORYACLS where ACLID = 13;
delete from CATEGORIES where CATEGORYID = 12;
delete from CATEGORYACLS where ACLID = 12;
delete from CATEGORIES where CATEGORYID = 11;
delete from CATEGORYACLS where ACLID = 11;
delete from CATEGORIES where CATEGORYID = 10;
delete from CATEGORYACLS where ACLID = 10;
delete from CATEGORIES where CATEGORYID = 9;
delete from CATEGORYACLS where ACLID = 9;
delete from CATEGORIES where CATEGORYID = 8;
delete from CATEGORYACLS where ACLID = 8;
delete from CATEGORIES where CATEGORYID = 7;
delete from CATEGORYACLS where ACLID = 7;
delete from CATEGORIES where CATEGORYID = 6;
delete from CATEGORYACLS where ACLID = 6;
delete from CATEGORIES where CATEGORYID = 5;
delete from CATEGORYACLS where ACLID = 5;
delete from CATEGORIES where CATEGORYID = 4;
delete from CATEGORYACLS where ACLID = 4;
delete from CATEGORIES where CATEGORYID = 3;
delete from CATEGORYACLS where ACLID = 3;
delete from CATEGORIES where CATEGORYID = 2;
delete from CATEGORYACLS where ACLID = 2;
delete from CATEGORIES where CATEGORYID = 1;
delete from CATEGORYACLS where ACLID = 1;

/* acl types */
delete from ACLTYPES;

insert into ACLTYPES
            (ACLTYPEID, NAME, RANK, DESCRIPTION, DEFACLONLY, IDREQUIRED)
     values (1, 'user', 1, 'acl type user', 0, 1);

insert into ACLTYPES
            (ACLTYPEID, NAME, RANK, DESCRIPTION, DEFACLONLY, IDREQUIRED)
     values (2, 'group', 2, 'acl type group', 0, 1);

insert into ACLTYPES
            (ACLTYPEID, NAME, RANK, DESCRIPTION, DEFACLONLY, IDREQUIRED)
     values (3, 'anyother', 3, 'acl type anyother', 0, 0);

insert into ACLTYPES
            (ACLTYPEID, NAME, RANK, DESCRIPTION, DEFACLONLY, IDREQUIRED)
     values (4, 'mask', 4, 'acl type mask', 0, 0);

insert into ACLTYPES
            (ACLTYPEID, NAME, RANK, DESCRIPTION, DEFACLONLY, IDREQUIRED)
     values (5, 'owner', 0, 'acl type owner', 1, 0);



/* documentflags */
delete from DOCUMENTFLAGS;

insert into DOCUMENTFLAGS
            (FLAG, DESCRIPTION)
     values (0, 'published');

insert into DOCUMENTFLAGS
            (FLAG, DESCRIPTION)
     values (1, 'expired');

insert into DOCUMENTFLAGS
            (FLAG, DESCRIPTION)
     values (2, 'deleted');


/* documentstati */
insert into DOCUMENTSTATI
            (STATUS, DESCRIPTION, REMARK)
     values (0, 'created', null);

insert into DOCUMENTSTATI
            (STATUS, DESCRIPTION, REMARK)
     values (1, 'changed', null);

insert into DOCUMENTSTATI
            (STATUS, DESCRIPTION, REMARK)
     values (2, 'wait for response', null);

insert into DOCUMENTSTATI
            (STATUS, DESCRIPTION, REMARK)
     values (3, 'deleted', null);


/* documenttypes */
delete from DOCUMENTTYPES;

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (0, '?', 'undefined', 'undefined', 1, '?', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (1, 'TXT', 'Generic ASCII Text', 'ASCII document', 0, 'text/plain', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (2, 'PDF', 'Adobe Portable Document Format', 'PDF document', 0, 'application/pdf', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (3, 'DOC', 'Microsoft Winword Document', 'Winword document', 0, 'application/msword', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (4, 'HTML', 'Hypertext Markup Language Document', 'HTML document', 0, 'text/html', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (5, 'PS', 'Postscript Document', 'Postscript document', 0, 'application/postscript', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (6, 'PPT', 'Microsoft Powerpoint Document', 'PPT document', 0, 'application/vnd.ms-powerpoint', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (7, 'XLS', 'Microsoft Excel Document', 'Excel document', 0, 'application/vnd.ms-excel', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (8, 'RTF', 'Rich Text Format Document', 'RTF document', 0, 'application/rtf', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (9, 'WPD', 'Word Perfect Document', 'WPD document', 0, 'application/wordperfect5.1', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (10, 'TDF', 'Typography Description Format Document', 'TDF document', 1, 'application/tdf', null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (11, 'NOTE', 'Note', 'Note', 0, null, null, null, null);

insert into DOCUMENTTYPES
            (DOCTYPEID, EXTENSION, DESCRIPTION, DESCRIPTION_SHORT, INTERNAL, MIMETYPE, IMGPATH_ENABLED, IMGPATH_DISABLED, IMGPATH_SHADED)
     values (12, 'LINK', 'Link', 'Link', 0, null, null, null, null);



/* document classes */
delete from DOCUMENTCLASSES;

insert into DOCUMENTCLASSES
            (DOCCLASSID, NAME, DESCRIPTION)
     values (0, 'none', '');

insert into DOCUMENTCLASSES
            (DOCCLASSID, NAME, DESCRIPTION)
     values (1, 'report', '');

insert into DOCUMENTCLASSES
            (DOCCLASSID, NAME, DESCRIPTION)
     values (2, 'memo', '');

insert into DOCUMENTCLASSES
            (DOCCLASSID, NAME, DESCRIPTION)
     values (3, 'protocol', '');

insert into DOCUMENTCLASSES
            (DOCCLASSID, NAME, DESCRIPTION)
     values (4, 'status', '');


/* permission contexts */
delete from PERMCONTEXTS;

insert into PERMCONTEXTS
            (PERMCTXID, NAME, DESCRIPTION)
     values (1, 'category', 'permission context category');

insert into PERMCONTEXTS
            (PERMCTXID, NAME, DESCRIPTION)
     values (2, 'document', 'permission context document');

insert into PERMCONTEXTS
            (PERMCTXID, NAME, DESCRIPTION)
     values (3, 'group', 'permission context group');


/* permissions */
delete from PERMISSIONS;

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (1, 'category', 'c', '1', 'change ACL', 'Context CATEGORY: change ACL permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (2, 'category', 'r', '2', 'read category', 'Context CATEGORY: Read category permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (3, 'category', 'w', '4', 'write category', 'Context CATEGORY: write category permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (4, 'category', 'd', '8', 'delete documents', 'Context Category: delete documents permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (5, 'category', 'D', '16', 'delete category', 'Context CATEGORY: delete category permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (6, 'category', 'C', '32', 'create subcategory', 'Context CATEGORY: create subcategory permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (7, 'category', 'L', '64', 'create link to category', 'Context CATEGORY: create link to category permission', 0);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (8, 'category', 'F', '128', 'follow link to category', 'Context CATEGORY: follow link to category permission', 0);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (9, 'category', 'l', '256', 'create link to document', 'Context CATEGORY: create link to document permission', 0);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (10, 'category', 'f', '512', 'follow link to document', 'Context CATEGORY: follow link to document permission', 0);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (11, 'document', 'c', '1', 'change ACL', 'Context DOCUMENT: change ACL permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (12, 'document', 'r', '2', 'read document', 'Context DOCUMENT: read document permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (13, 'document', 'w', '4', 'write document', 'Context DOCUMENT: write document permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (14, 'document', 'M', '8', 'move document', 'Context DOCUMENT: move document permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (15, 'document', 'D', '16', 'delete document', 'Context DOCUMENT: delete document permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (16, 'group', 'c', '1', 'change ACL', 'Context GROUP: change ACL permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (17, 'group', 'a', '2', 'add member', 'Context GROUP: add member permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (18, 'group', 'd', '4', 'delete member', 'Context GROUP: delete member permission', 1);

insert into PERMISSIONS
            (PERMISSIONID, CONTEXT, TOKEN, NUMVALUE, PRINTSTRING, DESCRIPTION, ENABLED)
     values (19, 'group', 'D', '8', 'delete group', 'Context GROUP: delete group permission', 1);


/* dynamic attributes */
delete from DYNATTRIBUTES;

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (1, 1, 'UserDynAttr1', 'User Dynamical Attribute #1 for USER1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (2, 1, 'UserDynAttr2', 'User Dynamical Attribute #2 for USER1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (3, 1, 'UserDynAttr3', 'User Dynamical Attribute #3 for USER1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (4, 2, 'UserDynAttr1', 'User Dynamical Attribute #1 for USER2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (5, 2, 'UserDynAttr2', 'User Dynamical Attribute #2 for USER2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (6, 2, 'UserDynAttr3', 'User Dynamical Attribute #3 for USER2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (7, 3, 'CatDynAttr1', 'Category Dynamical Attribute #1 for CAT1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (8, 3, 'CatDynAttr2', 'Category Dynamical Attribute #2 for CAT1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (9, 3, 'CatDynAttr3', 'Category Dynamical Attribute #3 for CAT1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (10, 4, 'CatDynAttr1', 'Category Dynamical Attribute #1 for CAT2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (11, 4, 'CatDynAttr2', 'Category Dynamical Attribute #2 for CAT2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (12, 4, 'CatDynAttr3', 'Category Dynamical Attribute #3 for CAT2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (13, 5, 'DocDynAttr1', 'Document Dynamical Attribute #1 for DOC1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (14, 5, 'DocDynAttr2', 'Document Dynamical Attribute #2 for DOC1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (15, 5, 'DocDynAttr3', 'Document Dynamical Attribute #3 for DOC1');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (16, 6, 'DocDynAttr1', 'Document Dynamical Attribute #1 for DOC2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (17, 6, 'DocDynAttr2', 'Document Dynamical Attribute #2 for DOC2');

insert into DYNATTRIBUTES
            (DAENTYRID, DYNATTRID, NAME, VALUESTRING)
     values (18, 6, 'DocDynAttr3', 'Document Dynamical Attribute #3 for DOC2');


/* additional user attributes */
insert into ADDUSERATTRS
            (USERATTRID, NAME, ALLOWNULL)
     values (1, 'UserAttr#1', 0);

insert into ADDUSERATTRS
            (USERATTRID, NAME, ALLOWNULL)
     values (2, 'UserAttr#2', 1);


/* users */
/* admin: hat implizit alle rechte */
delete from USERS;

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (1, 'Admin', 'Administrator', 'VKC-Administrator', '...', 'f89SqyHAVp5mPUirW+wHzA==', 1, null, 'admin@abc.de', 0, 1, 1, 'Company1', 'Department1', '00000', 'City1', 'Street1', '00000/00001', '00000/00001', '00000/00001', 'http://www.homepage1.de', 'http://www.contacturl1.de', 1, 1, 1, 1, null, null, null, null, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (1, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (2, 'User1', 'UserFirst1', 'UserLast1', '...', 'Hq71JZ3BVxwfnntzEowTbA==', 0, null, 'xyz1@abc.de', 1, 1, 1, 'Company1', 'Department1', '00001', 'City1', 'Street1', '00000/00001', '00000/00001', '00000/00001', 'http://www.homepage1.de', 'http://www.contacturl1.de', 0, 0, 2, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, 1);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (2, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (3, 'User2', 'UserFirst2', 'UserLast2', '...', 'xEkXaUAbeu0Q5bxhFEV63Q==', 0, null, 'xyz2@abc.de', 1, 1, 1, 'Company2', 'Department2', '00002', 'City2', 'Street2', '00000/00002', '00000/00002', '00000/00002', 'http://www.homepage2.de', 'http://www.contacturl2.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, 2);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (3, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (4, 'User3', 'UserFirst3', 'UserLast3', '...', 'cu4ZlIBJfAr5APlUxVbm/A==', 0, null, 'xyz3@abc.de', 1, 1, 1, 'Company3', 'Department3', '00003', 'City3', 'Street3', '00000/00003', '00000/00003', '00000/00003', 'http://www.homepage3.de', 'http://www.contacturl3.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (4, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (5, 'User4', 'UserFirst4', 'UserLast4', '...', 'Q7k/BMkiSunc5DtXfClicw==', 0, null, 'xyz4@abc.de', 1, 1, 1, 'Company4', 'Department4', '00004', 'City4', 'Street4', '00000/00004', '00000/00004', '00000/00004', 'http://www.homepage4.de', 'http://www.contacturl4.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (5, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (6, 'User5', 'UserFirst5', 'UserLast5', '...', 'rBA2cNMwt6c6U4ZAjCUMLA==', 0, null, 'xyz5@abc.de', 1, 1, 1, 'Company5', 'Department5', '00005', 'City5', 'Street5', '00000/00005', '00000/00005', '00000/00005', 'http://www.homepage5.de', 'http://www.contacturl5.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (6, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (7, 'User6', 'UserFirst6', 'UserLast6', '...', 'dlz5FaNA3zMUhymI239fMA==', 0, null, 'xyz6@abc.de', 1, 1, 1, 'Company6', 'Department6', '00006', 'City6', 'Street6', '00000/00006', '00000/00006', '00000/00006', 'http://www.homepage6.de', 'http://www.contacturl6.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (7, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (8, 'User7', 'UserFirst7', 'UserLast7', '...', '/7pLkGy4JFi16Vs9vkff2A==', 0, null, 'xyz7@abc.de', 1, 1, 1, 'Company7', 'Department7', '00006', 'City6', 'Street6', '00000/00007', '00000/00007', '00000/00007', 'http://www.homepage7.de', 'http://www.contacturl7.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (8, 1, 'User Dynamical Attr#1 Value');

insert into USERS
            (USERID, USERNAME, FIRSTNAME, LASTNAME, TITLE, PASSWD, PASSWDCHANGED, PASSWDCHANGEDTS, EMAIL, SHOWEMAIL, ENABLEMESSAGING, MESSAGINGTIMEPERIOD, COMPANY, DEPARTMENT, ZIP, CITY, STREET, PHONE, FAX, MOBILE, HOMEPAGEURL, CONTACTURL, ADMINPRIVILEGES, CREATEGROUPS, LANGUAGEID, ACCOUNTVALID, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, DYNATTRSID)
     values (9, 'User8', 'UserFirst8', 'UserLast8', '...', 'UHdhKVIg8ZQizd4b1E8cYQ==', 0, null, 'xyz8@abc.de', 1, 1, 1, 'Company8', 'Department8', '00008', 'City8', 'Street8', '00000/00008', '00000/00008', '00000/00008', 'http://www.homepage8.de', 'http://www.contacturl8.de', 0, 0, 1, 1, null, null, CURRENT_TIMESTAMP, 1, null, null, null);

insert into ADDUSERATTRVALUES
            (USERID, USERATTRID, VALUESTRING)
     values (9, 1, 'User Dynamical Attr#1 Value');



/* groups */
/* additional user attributes */
insert into ADDGROUPATTRS
            (GROUPATTRID, NAME, ALLOWNULL)
     values (1, 'GroupAttr#1', 0);

insert into ADDGROUPATTRS
            (GROUPATTRID, NAME, ALLOWNULL)
     values (2, 'GroupAttr#2', 1);

delete from GROUPS;

insert into GROUPS
            (GROUPID, ACLID, NAME, DESCRIPTION, ADMINPRIVILEGES, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID)
     values (1, null, 'AdminGroup', 'AdminGroup1', 1, null, null, null, null, null, null);

insert into ADDGROUPATTRVALUES
            (GROUPID, GROUPATTRID, VALUESTRING)
     values (1, 1, 'Group Dynamical Attr#1 Value');

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (1, 1, 1, 2, 16, CURRENT_TIMESTAMP, 2);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (2, 1, 1, 2, 17, CURRENT_TIMESTAMP, 2);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (3, 1, 1, 2, 18, CURRENT_TIMESTAMP, 2);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (4, 1, 1, 2, 19, CURRENT_TIMESTAMP, 2);

insert into GROUPS
            (GROUPID, ACLID, NAME, DESCRIPTION, ADMINPRIVILEGES, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID)
     values (2, 1, 'Group1', 'Group1', 0, null, null, CURRENT_TIMESTAMP, 2, null, null);

insert into ADDGROUPATTRVALUES
            (GROUPID, GROUPATTRID, VALUESTRING)
     values (2, 1, 'Group Dynamical Attr#1 Value');

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (5, 2, 1, 3, 16, CURRENT_TIMESTAMP, 3);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (6, 2, 1, 3, 17, CURRENT_TIMESTAMP, 3);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (7, 2, 1, 3, 18, CURRENT_TIMESTAMP, 3);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (8, 2, 1, 3, 19, CURRENT_TIMESTAMP, 3);

insert into GROUPS
            (GROUPID, ACLID, NAME, DESCRIPTION, ADMINPRIVILEGES, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID)
     values (3, 2, 'Group2', 'Group2', 0, null, null, CURRENT_TIMESTAMP, 3, null, null);

insert into ADDGROUPATTRVALUES
            (GROUPID, GROUPATTRID, VALUESTRING)
     values (3, 1, 'Group Dynamical Attr#1 Value');

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (9, 3, 1, 4, 16, CURRENT_TIMESTAMP, 4);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (10, 3, 1, 4, 17, CURRENT_TIMESTAMP, 4);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (11, 3, 1, 4, 18, CURRENT_TIMESTAMP, 4);

insert into GROUPACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (12, 3, 1, 4, 19, CURRENT_TIMESTAMP, 4);

insert into GROUPS
            (GROUPID, ACLID, NAME, DESCRIPTION, ADMINPRIVILEGES, VALIDFROM, VALIDUNTIL, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID)
     values (4, 3, 'public', 'Default group', 0, null, null, CURRENT_TIMESTAMP, 4, null, null);

insert into ADDGROUPATTRVALUES
            (GROUPID, GROUPATTRID, VALUESTRING)
     values (4, 1, 'Group Dynamical Attr#1 Value');


/* registered keywords */
/* user 1 */
insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (1, 'Keyword1', 'Keyword1', 1.0, 0);

insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (1, 'Keyword2', 'Keyword2', 1.0, 0);

insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (1, 'Keyword3', 'Keyword3', 1.0, 0);

/* user 2 */
insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'Keyword2', 'Keyword2', 1.0, 0);

insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'Keyword3', 'Keyword3', 1.0, 0);

insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'Keyword4', 'Keyword4', 1.0, 0);

/* user 3 */
insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'Keyword5', 'Keyword5', 1.0, 0);

insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'Keyword6', 'Keyword6', 1.0, 0);

insert into USERREGISTEREDKEYWORDS
            (USERID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'Keyword7', 'Keyword7', 1.0, 0);


/* usergroups */
/* group1 (admingroup): user2, user3 */
/* group2             : user4, user5 */
/* group3             : user6, user7 */
/* group4             : user8, user9 */
insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (1, 2, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (1, 3, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (2, 4, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (2, 5, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (3, 6, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (3, 7, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (4, 8, CURRENT_TIMESTAMP, 1);

insert into USERGROUPS
            (GROUPID, USERID, CREATED, CREATORID)
     values (4, 9, CURRENT_TIMESTAMP, 1);


/* additional category attributes */
insert into ADDCATATTRS
            (CATATTRID, NAME, ALLOWNULL)
     values (1, 'CatAttr#1', 0);

insert into ADDCATATTRS
            (CATATTRID, NAME, ALLOWNULL)
     values (2, 'CatAttr#2', 1);

/* additional document attributes */
insert into ADDDOCATTRS
            (DOCATTRID, NAME, ALLOWNULL)
     values (1, 'DocAttr#1', 0);

insert into ADDDOCATTRS
            (DOCATTRID, NAME, ALLOWNULL)
     values (2, 'DocAttr#2', 1);


/* default category acl */
/* owner:    crwdDCLFlf */
/* anyother: -r-------  */
insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (1, 1, 5, 0, 1, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (2, 1, 5, 0, 2, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (3, 1, 5, 0, 3, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (4, 1, 5, 0, 4, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (5, 1, 5, 0, 5, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (6, 1, 5, 0, 6, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (7, 1, 5, 0, 7, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (8, 1, 5, 0, 8, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (9, 1, 5, 0, 9, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (10, 1, 5, 0, 10, CURRENT_TIMESTAMP, 1);

insert into DEFAULTCATACLS
            (ACLENTRYID, STARTCATID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (11, 1, 3, 0, 2, CURRENT_TIMESTAMP, 1);


/* root cat            */
/* anyother: -r------- */
/* doc1                */
/* doc2                */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (1, 1, 3, 0, 2, CURRENT_TIMESTAMP, 1);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (1, null, 1, null, 1, 'VKC-Root://', 'Root-Category', 1, null, null, null, null, null, null, null, null);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (1, 1, 'Value1');

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (1, null, 'document11', 'Document11.txt', 'Document1 describes data', 1, 1, 0, 1, 1, 0, 'document1 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0, 1, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (1, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (1, 'DocumentKeyword1', 'DocumentKeyword1', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY)
     values (1, 1, 1, 1);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (2, null, 'document12', 'Document12.txt', 'Document2 describes data', 1, 1, 0, 1, 1, 0, 'document2 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0, 2, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (2, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'DocumentKeyword2', 'DocumentKeyword2', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (2, 1, 2, 1, CURRENT_TIMESTAMP, 1);

insert into DOCUMENTACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (1, 1, 3, 1, 10, CURRENT_TIMESTAMP, 1);

insert into DOCUMENTACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (2, 2, 3, 1, 11, CURRENT_TIMESTAMP, 1);


/* cat 1: creator Admin   */
/* anyother: -rwdC-----   */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (2, 2, 3, 0, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (3, 2, 3, 0, 3, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (4, 2, 3, 0, 4, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (5, 2, 3, 0, 5, CURRENT_TIMESTAMP, 2);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (2, 1, 2, 3, 1, 'Category1', 'Category1 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (2, 1, 'Value2');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'CategoryKeyword1', 'CategoryKeyword1', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'CategoryKeyword2', 'CategoryKeyword2', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (2, 'CategoryKeyword3', 'CategoryKeyword3', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (2, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (2, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (2, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (2, 4);

/* cat 11: creator USER1 */
/* anyother: -r--------   */
/* user1   : crwdCDLFlf   */
/* documenttypes: all    */
/* registered users: 2,3,4 */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (6, 3, 3, 0, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (7, 3, 1, 2, 1, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (8, 3, 1, 2, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (9, 3, 1, 2, 3, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (10, 3, 1, 2, 4, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (11, 3, 1, 2, 5, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (12, 3, 1, 2, 6, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (13, 3, 1, 2, 7, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (14, 3, 1, 2, 8, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (15, 3, 1, 2, 9, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (16, 3, 1, 2, 10, CURRENT_TIMESTAMP, 2);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (3, 2, 3, null, 1, 'Category11', 'Category1 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 2, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (3, 1, 'Value3');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'CategoryKeyword4', 'CategoryKeyword4', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'CategoryKeyword5', 'CategoryKeyword5', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'CategoryKeyword6', 'CategoryKeyword6', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (3, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (3, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (3, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (3, 4);

insert into USERREGISTEREDCATEGORIES
            (CATEGORYID, USERID)
     values (3, 3);

insert into USERREGISTEREDCATEGORIES
            (CATEGORYID, USERID)
     values (3, 4);

insert into USERREGISTEREDCATEGORIES
            (CATEGORYID, USERID)
     values (3, 5);


/* cat 111: creator USER1 */
/* anyother: -r-------    */
/* user1   : crwCDLFlf    */
/* documenttypes: all     */
/* doc1111                */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (17, 4, 3, 0, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (18, 4, 1, 2, 1, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (19, 4, 1, 2, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (20, 4, 1, 2, 3, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (21, 4, 1, 2, 4, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (22, 4, 1, 2, 5, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (23, 4, 1, 2, 6, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (24, 4, 1, 2, 7, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (25, 4, 1, 2, 8, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (26, 4, 1, 2, 9, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (27, 4, 1, 2, 10, CURRENT_TIMESTAMP, 2);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (4, 3, 4, null, 1, 'Category111', 'Categroy111 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (4, 1, 'Value4');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (4, 'CategoryKeyword7', 'CategoryKeyword7', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (4, 'CategoryKeyword8', 'CategoryKeyword8', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (4, 'CategoryKeyword9', 'CategoryKeyword9', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (4, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (4, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (4, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (4, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (3, null, 'document1111', 'Document1111.pdf', 'Document1111 describes data', 2, 1, 0, 1, 1, 0, 'document1111 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0, null, 1000000);

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (3, 'DocumentKeyword3', 'DocumentKeyword3', 1.0, 0);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (3, 1, 'Document Dynamical Attr#1 Value');

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (3, 3, 3, 1, CURRENT_TIMESTAMP, 2);

/* additional documentsformats for this document */
/* original: pdf */
/* additional: html, txt */
insert into ADDITIONALDOCUMENTFORMATS
            (ADDDOCFORMATID, DOCUMENTID, DOCTYPEID, ARCHIVEID)
     values (1, 3,  4, 0);

insert into ADDITIONALDOCUMENTFORMATS
            (ADDDOCFORMATID, DOCUMENTID, DOCTYPEID, ARCHIVEID)
     values (2, 3,  1, 0);

/* cat 112: creator USER1 */
/* anyother: -r-------    */
/* user1   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (28, 5, 3, 0, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (29, 5, 1, 2, 1, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (30, 5, 1, 2, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (31, 5, 1, 2, 3, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (32, 5, 1, 2, 4, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (33, 5, 1, 2, 5, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (34, 5, 1, 2, 6, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (35, 5, 1, 2, 7, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (36, 5, 1, 2, 8, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (37, 5, 1, 2, 9, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (38, 5, 1, 2, 10, CURRENT_TIMESTAMP, 2);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (5, 3, 5, null, 1, 'Category112', 'Categroy112 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 2, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (5, 1, 'Value5');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (5, 'CategoryKeyword10', 'CategoryKeyword10', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (5, 'CategoryKeyword11', 'CategoryKeyword11', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (5, 'CategoryKeyword12', 'CategoryKeyword12', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (5, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (5, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (5, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (5, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (4, null, 'document1112', 'Document1112.pdf', 'Document1112 describes data', 2, 1, 0, 1, 1, 0, 'document1112 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 2, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (4, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (4, 'DocumentKeyword4', 'DocumentKeyword4', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (4, 5, 4, 1, CURRENT_TIMESTAMP, 2);

/* additional documentsformats for this document */
/* original: pdf */
/* additional: html, txt */
insert into ADDITIONALDOCUMENTFORMATS
            (ADDDOCFORMATID, DOCUMENTID, DOCTYPEID, ARCHIVEID)
     values (3, 4,  4, 0);

insert into ADDITIONALDOCUMENTFORMATS
            (ADDDOCFORMATID, DOCUMENTID, DOCTYPEID, ARCHIVEID)
     values (4, 4,  1, 0);


/* cat 113: creator USER1 */
/* anyother: -r-------    */
/* user1   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (39, 6, 3, 0, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (40, 6, 1, 2, 1, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (41, 6, 1, 2, 2, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (42, 6, 1, 2, 3, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (43, 6, 1, 2, 4, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (44, 6, 1, 2, 5, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (45, 6, 1, 2, 6, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (46, 6, 1, 2, 7, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (47, 6, 1, 2, 8, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (48, 6, 1, 2, 9, CURRENT_TIMESTAMP, 2);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (49, 6, 1, 2, 10, CURRENT_TIMESTAMP, 2);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (6, 3, 6, null, 1, 'Category113', 'Categroy113 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (6, 1, 'Value6');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (6, 'CategoryKeyword12', 'CategoryKeyword12', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (6, 'CategoryKeyword13', 'CategoryKeyword13', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (6, 'CategoryKeyword14', 'CategoryKeyword14', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (6, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (6, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (6, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (6, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (5, null, 'document1113', 'Document1113.txt', 'Document1112 describes data', 1, 1, 0, 1, 1, 0, 'document1113 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 2, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (5, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (5, 'DocumentKeyword5', 'DocumentKeyword5', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (5, 6, 5, 1, CURRENT_TIMESTAMP, 2);



/* cat 12: creator USER2  */
/* anyother: -r-------    */
/* user2   : crwdCDLFlf    */
/* documenttypes: all     */

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (50, 7, 3, 0, 2, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (51, 7, 1, 3, 1, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (52, 7, 1, 3, 2, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (53, 7, 1, 3, 3, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (54, 7, 1, 3, 4, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (55, 7, 1, 3, 5, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (56, 7, 1, 3, 6, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (57, 7, 1, 3, 7, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (58, 7, 1, 3, 8, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (59, 7, 1, 3, 9, CURRENT_TIMESTAMP, 3);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (60, 7, 1, 3, 10, CURRENT_TIMESTAMP, 3);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (7, 2, 7, null, 1, 'Category12', 'Categroy12 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 3, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (7, 1, 'Value7');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (7, 'CategoryKeyword15', 'CategoryKeyword15', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (7, 'CategoryKeyword16', 'CategoryKeyword16', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (7, 'CategoryKeyword17', 'CategoryKeyword17', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (7, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (7, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (7, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (7, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (6, null, 'document112', 'Document112.txt', 'Document112 describes data', 1, 1, 0, 1, 1, 0, 'document112 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 3, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (6, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (6, 'DocumentKeyword6', 'DocumentKeyword6', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (6, 7, 6, 1, CURRENT_TIMESTAMP, 3);



/* cat 13: creator USER3  */
/* anyother: -r-------    */
/* user3   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (61, 8, 3, 0, 2, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (62, 8, 1, 4, 1, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (63, 8, 1, 4, 2, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (64, 8, 1, 4, 3, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (65, 8, 1, 4, 4, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (66, 8, 1, 4, 5, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (67, 8, 1, 4, 6, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (68, 8, 1, 4, 7, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (69, 8, 1, 4, 8, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (70, 8, 1, 4, 9, CURRENT_TIMESTAMP, 4);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (71, 8, 1, 4, 10, CURRENT_TIMESTAMP, 4);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (8, 2, 8, null, 1, 'Category13', 'Categroy13 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 4, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (8, 1, 'Value8');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (8, 'CategoryKeyword18', 'CategoryKeyword18', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (8, 'CategoryKeyword19', 'CategoryKeyword19', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (8, 'CategoryKeyword20', 'CategoryKeyword20', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (8, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (8, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (8, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (8, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (7, null, 'document113', 'Document113.txt', 'Document113 describes data', 1, 1, 0, 1, 1, 0, 'document113 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 4, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (7, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (7, 'DocumentKeyword7', 'DocumentKeyword7', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (7, 8, 7, 1, CURRENT_TIMESTAMP, 4);



/* cat 2: creator Admin   */
/* anyother: -rwdC-----   */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (72, 9, 3, 0, 2, CURRENT_TIMESTAMP, 1);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (73, 9, 3, 0, 3, CURRENT_TIMESTAMP, 1);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (74, 9, 3, 0, 4, CURRENT_TIMESTAMP, 1);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (75, 9, 3, 0, 5, CURRENT_TIMESTAMP, 1);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (9, 1, 9, 4, 1, 'Category2', 'Categroy2 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (9, 1, 'Value9');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (9, 'CategoryKeyword21', 'CategoryKeyword21', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (9, 'CategoryKeyword22', 'CategoryKeyword22', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (9, 'CategoryKeyword23', 'CategoryKeyword23', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (9, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (9, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (9, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (9, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (8, null, 'document21', 'Document21.txt', 'Document21 describes data', 1, 1, 0, 1, 1, 0, 'document21 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (8, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (8, 'DocumentKeyword8', 'DocumentKeyword8', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (8, 9, 8, 1, CURRENT_TIMESTAMP, 1);


/* cat 21: creator USER4  */
/* anyother: -r-------    */
/* user4   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (76, 10, 3, 0, 2, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (77, 10, 1, 5, 1, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (78, 10, 1, 5, 2, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (79, 10, 1, 5, 3, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (80, 10, 1, 5, 4, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (81, 10, 1, 5, 5, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (82, 10, 1, 5, 6, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (83, 10, 1, 5, 7, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (84, 10, 1, 5, 8, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (85, 10, 1, 5, 9, CURRENT_TIMESTAMP, 5);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (86, 10, 1, 5, 10, CURRENT_TIMESTAMP, 5);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (10, 9, 10, null, 1, 'Category21', 'Categroy21 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 5, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (10, 1, 'Value10');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (10, 'CategoryKeyword24', 'CategoryKeyword24', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (10, 'CategoryKeyword25', 'CategoryKeyword25', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (10, 'CategoryKeyword26', 'CategoryKeyword26', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (10, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (10, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (10, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (10, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (9, null, 'document211', 'Document211.txt', 'Document211 describes data', 1, 1, 0, 1, 1, 0, 'document211 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 5, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (9, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (9, 'DocumentKeyword9', 'DocumentKeyword9', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (9, 10, 9, 1, CURRENT_TIMESTAMP, 5);



/* cat 22: creator USER5  */
/* anyother: -r-------    */
/* user5   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (87, 11, 3, 0, 2, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (88, 11, 1, 6, 1, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (89, 11, 1, 6, 2, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (90, 11, 1, 6, 3, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (91, 11, 1, 6, 4, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (92, 11, 1, 6, 5, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (93, 11, 1, 6, 6, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (94, 11, 1, 6, 7, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (95, 11, 1, 6, 8, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (96, 11, 1, 6, 9, CURRENT_TIMESTAMP, 6);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (97, 11, 1, 6, 10, CURRENT_TIMESTAMP, 6);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (11, 9, 11, null, 1, 'Category22', 'Categroy22 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 6, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (11, 1, 'Value11');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (11, 'CategoryKeyword27', 'CategoryKeyword27', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (11, 'CategoryKeyword28', 'CategoryKeyword28', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (11, 'CategoryKeyword29', 'CategoryKeyword29', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (11, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (11, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (11, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (11, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (10, null, 'document222', 'Document222.txt', 'Document222 describes data', 1, 1, 0, 1, 1, 0, 'document222 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 6, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (10, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (10, 'DocumentKeyword10', 'DocumentKeyword10', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (10, 11, 10, 1, CURRENT_TIMESTAMP, 6);



/* cat 3: creator Admin   */
/* anyone: -rwdC------     */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (98, 12, 3, 0, 2, CURRENT_TIMESTAMP, 1);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (99, 12, 3, 0, 3, CURRENT_TIMESTAMP, 1);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (100, 12, 3, 0, 4, CURRENT_TIMESTAMP, 1);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (101, 12, 3, 0, 5, CURRENT_TIMESTAMP, 1);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (12, 1, 12, null, 1, 'Category3', 'Categroy3 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 1, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (12, 1, 'Value12');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (12, 'CategoryKeyword30', 'CategoryKeyword130', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (12, 'CategoryKeyword31', 'CategoryKeyword31', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (12, 'CategoryKeyword32', 'CategoryKeyword32', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (12, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (12, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (12, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (12, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (11, null, 'document31', 'Document31.txt', 'Document31 describes data', 1, 1, 0, 1, 1, 0, 'document31 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 7, null, null, null, null, 0, null, 1000000);

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (11, 'DocumentKeyword11', 'DocumentKeyword11', 1.0, 0);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (11, 1, 'Document Dynamical Attr#1 Value');

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (11, 12, 11, 1, CURRENT_TIMESTAMP, 6);



/* cat 31: creator USER6  */
/* anyother: -r-------    */
/* user6   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (102, 13, 3, 0, 2, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (103, 13, 1, 7, 1, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (104, 13, 1, 7, 2, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (105, 13, 1, 7, 3, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (106, 13, 1, 7, 4, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (107, 13, 1, 7, 5, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (108, 13, 1, 7, 6, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (109, 13, 1, 7, 7, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (110, 13, 1, 7, 8, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (111, 13, 1, 7, 9, CURRENT_TIMESTAMP, 7);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (112, 13, 1, 7, 10, CURRENT_TIMESTAMP, 7);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (13, 12, 13, null, 1, 'Cat31', 'Categroy311 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 7, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (13, 1, 'Value13');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (13, 'CategoryKeyword33', 'CategoryKeyword33', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (13, 'CategoryKeyword34', 'CategoryKeyword34', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (13, 'CategoryKeyword35', 'CategoryKeyword35', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (13, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (13, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (13, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (13, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (12, null, 'document311', 'Document311.txt', 'Document311 describes data', 1, 1, 0, 1, 1, 0, 'document311 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 7, null, null, null, null, 0, null, 1000000);

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (12, 'DocumentKeyword12', 'DocumentKeyword12', 1.0, 0);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (12, 1, 'Document Dynamical Attr#1 Value');

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (12, 13, 12, 1, CURRENT_TIMESTAMP, 7);



/* cat 32: creator USER7  */
/* anyother: -r-------    */
/* user7   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (113, 14, 3, 0, 2, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (114, 14, 1, 8, 1, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (115, 14, 1, 8, 2, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (116, 14, 1, 8, 3, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (117, 14, 1, 8, 4, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (118, 14, 1, 8, 5, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (119, 14, 1, 8, 6, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (120, 14, 1, 8, 7, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (121, 14, 1, 8, 8, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (122, 14, 1, 8, 9, CURRENT_TIMESTAMP, 8);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (123, 14, 1, 8, 10, CURRENT_TIMESTAMP, 8);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (14, 12, 14, null, 1, 'Cat32', 'Categroy32 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 8, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (14, 1, 'Value14');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (14, 'CategoryKeyword36', 'CategoryKeyword36', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (14, 'CategoryKeyword37', 'CategoryKeyword37', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (14, 'CategoryKeyword38', 'CategoryKeyword38', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (14, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (14, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (14, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (14, 4);

insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (13, null, 'document31', 'Document321.txt', 'Document31 describes data', 1, 1, 0, 1, 1, 0, 'document321 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 8, null, null, null, null, 0, null, 1000000);

insert into ADDDOCATTRVALUES
            (DOCUMENTID, DOCATTRID, VALUESTRING)
     values (13, 1, 'Document Dynamical Attr#1 Value');

insert into DOCUMENTKEYWORDS
            (DOCUMENTID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (13, 'DocumentKeyword13', 'DocumentKeyword13', 1.0, 0);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (13, 14, 13, 1, CURRENT_TIMESTAMP, 8);



/* cat 33: creator USER8  */
/* anyother: -r-------    */
/* user8   : crwdCDLFlf    */
/* documenttypes: all     */
insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (124, 15, 3, 0, 2, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (125, 15, 1, 9, 1, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (126, 15, 1, 9, 2, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (127, 15, 1, 9, 3, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (128, 15, 1, 9, 4, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (129, 15, 1, 9, 5, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (130, 15, 1, 9, 6, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (131, 15, 1, 9, 7, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (132, 15, 1, 9, 8, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (133, 15, 1, 9, 9, CURRENT_TIMESTAMP, 9);

insert into CATEGORYACLS
            (ACLENTRYID, ACLID, ACLTYPEID, ACCESSORID, PERMISSIONID, CREATED, CREATORID)
     values (134, 15, 1, 9, 10, CURRENT_TIMESTAMP, 9);

insert into CATEGORIES
            (CATEGORYID, PARENTCATEGORYID, ACLID, DYNATTRSID, INITIALCATEGORY, NAME, DESCRIPTION, SHOWDESCRIPTION, TEMPLATEID, CREATED, CREATORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER)
     values (15, 12, 15, null, 1, 'Cat33', 'Categroy33 holds data for other categories', 1, null, CURRENT_TIMESTAMP, 9, null, null, null, null, 0);

insert into ADDCATATTRVALUES 
            (CATEGORYID, CATATTRID, VALUESTRING)
     values (15, 1, 'Value15');

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (14, 'CategoryKeyword39', 'CategoryKeyword39', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (14, 'CategoryKeyword40', 'CategoryKeyword40', 1.0, 0 );

insert into CATEGORYKEYWORDS
            (CATEGORYID, TERM, TERMDESCRIPTOR, WEIGHT, INTERNAL)
     values (14, 'CategoryKeyword41', 'CategoryKeyword41', 1.0, 0 );

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (15, 1);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (15, 2);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (15, 3);

insert into ALLOWEDDOCUMENTTYPES
            (CATEGORYID, DOCTYPEID)
     values (15, 4);

/* test with predoc documents */
/* doc v1.0 */
insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (14, null, 'document331', 'Document331.txt', 'Document331 describes data', 1, 1, 0, 1, 1, 0, 'document331 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 9, null, null, null, null, 0, null, 1000000);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (14, 15, 14, 1, CURRENT_TIMESTAMP, 9);

/* doc v1.1 */
insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (15, 14, 'document331', 'Document331.txt', 'Document331 describes data', 1, 1, 0, 2, 1, 1, 'document331 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 9, null, null, null, null, 0, null, 1000000);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (15, 15, 15, 1, CURRENT_TIMESTAMP, 9);

/* doc v1.2 */
insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (16, 15, 'document331', 'Document331.txt', 'Document331 describes data', 1, 1, 0, 3, 1, 2, 'document331 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 9, null, null, null, null, 0, null, 1000000);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (16, 15, 16, 1, CURRENT_TIMESTAMP, 9);

/* doc v2.0 */
insert into DOCUMENTS
            (DOCUMENTID, PREDOCID, NAME, TITLE, DESCRIPTION, TYPEID, DOCCLASSID, ARCHIVEID, VERSION_NO, VERSION_HIGH, VERSION_LOW, SUMMARY, STATUS, FLAG, ACLID, EXPIRES, PUBLISHED, AUTHORID, LASTCHANGED, LASTCHANGERID, LASTACCESSED, LASTACCESSORID, ACCESSCOUNTER, DYNATTRSID, DOCSIZE)
     values (17, 16, 'document331', 'Document331.txt', 'Document331 describes data', 1, 1, 0, 4, 2, 0, 'document331 describes data', 0, 0, null, null, CURRENT_TIMESTAMP, 9, null, null, null, null, 0, null, 1000000);

insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (17, 15, 17, 1, CURRENT_TIMESTAMP, 9);

/* linked documents */
/* link to doc1111 (of category111) */
insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (18, 15, 3, 0, CURRENT_TIMESTAMP, 9);

/* link to doc211 (of category21) */
insert into CATEGORYDOCUMENTS
            (CATDOCID, CATEGORYID, DOCUMENTID, INITIALCATEGORY, CREATED, CREATORID)
     values (19, 15, 9, 0, CURRENT_TIMESTAMP, 9);

/* related documents */
insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (1, 1, 17, 'document331 (v2.0) is related to doc11');

insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (2, 1, 16, 'document331 (v1.2) is related to doc11');

insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (3, 1, 15, 'document331 (v1.1) is related to doc11');

insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (4, 1, 14, 'document331 (v1.0) is related to doc11');

insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (5, 2, 13, 'document321 (v1.0) is related to doc12');

insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (6, 2, 12, 'document311 (v1.0) is related to doc12');

insert into DOCUMENTRELATIONS
            (DOCRELID, DOCID, RELDOCID, VALUESTRING)
     values (7, 2, 11, 'document31 (v1.0) is related to doc12');


/* searchengines */
delete from SEARCHENGINES;

insert into SEARCHENGINES
            (SEARCHENGINEID, NAME, URL, PARAMETERS, DESCRIPTION)
     values (1, 'Google', 'http://www.google.de', '', 'Google Search Engine');

insert into SEARCHENGINES
            (SEARCHENGINEID, NAME, URL, PARAMETERS, DESCRIPTION)
     values (2, 'Lycos', 'http://www.lycos.de', '', 'Lycos Search Engine');

insert into SEARCHENGINES
            (SEARCHENGINEID, NAME, URL, PARAMETERS, DESCRIPTION)
     values (3, 'Altavista', 'http://www.altavista.de', '', 'Altavista Search Engine');


/* sysparameters */
delete from SYSPARAMETERS;

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (1, 'SYSTEMINFO', 'DBName', 'VKC.GDB', 'Name of the VKC database', 0, 1, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (2, 'SYSTEMINFO', 'DBMS', 'Interbase', 'VKC database management system', 0, 1, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (3, 'SYSTEMINFO', 'DBCopyright', 'C-LAB', 'Owner of the db schema', 0, 1, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (4, 'SYSTEMINFO', 'DBVersionHigh', '1', 'Database Version High Number', 0, 1, 0, 1);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (5, 'SYSTEMINFO', 'DBVersionLow', '0', 'Database Version Low Number', 0, 1, 0, 1);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (6, 'SYSTEMINFO', 'DBCreationDate', '2003-09-15 00:00:00', 'Database Creation Date', 0, 1, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (7, 'CATEGORYVIEW', 'ShowCountCatDocs', '1', 'Show Count of Subcategories & Documents', 0, 0, 0, 2);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (8, 'CATEGORYVIEW', 'ShowDisplayAscii', '1', 'Show link to display document in ascii format', 0, 0, 0, 2);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (9, 'CATEGORYVIEW', 'ListAccessibleCategoriesOnly', '1', 'List only accessible categories', 0, 0, 0, 2);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (10, 'MAIL', 'AdminEmail', 'admin@company.com', 'EMail adress of the administrator', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (11, 'MAIL', 'MailServer', 'mailserver.company.com', 'Mailservers adress', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (12, 'MAIL', 'RootURL', 'http://localhost:8080', 'URL of ', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (13, 'MAIL', 'DeleteDocumentPeriod', '28', 'Period of days when document should be deleted', 0, 0, 0, 1);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (14, 'MAIL', 'CheckExpirationTime', '00:00:00', 'Time, when the expiration thread should be called', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (15, 'MAIL', 'EnableMail', '1', 'Enable Mail', 0, 0, 0, 2);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (16, 'LOGGING', 'AccessLogFile', 'c:/temp/vkc_access.log', 'File for logging access of VKC', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (17, 'LOGGING', 'ServerLogFile', 'c:/temp/vkc_server.log', 'File for logging server of VKC', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (18, 'LOGGING', 'InfoLogFile', 'c:/temp/vkc_info.log', 'File for logging infos of VKC', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (19, 'LOGGING', 'ErrorLogFile', 'c:/temp/vkc_error.log', 'File for logging errors of VKC', 0, 0, 0, 0);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (20, 'LOGGING', 'MaxLogFileCount', '1', '', 0, 0, 0, 1);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (21, 'LOGGING', 'MaxLogFileSize', '1000000', '', 0, 0, 0, 1);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (22, 'LOGGING', 'EnableLogging', '1', '', 0, 0, 0, 2);

insert into SYSPARAMETERS
            (SYSPARAMETERID, CONTEXT, NAME, VALUESTRING, DESCRIPTION, ALLOWNULL, READONLY, HIDE, DATATYPE)
     values (23, 'LOGGING', 'LoggingLevel', '1', '', 0, 0, 0, 1);

/* languages */
delete from LANGUAGES;

insert into LANGUAGES
            (LANGUAGEID, NAME, SHORTNAME, ISOCODE, MAILFILE, MAILIMAGEPATH, EXPDOCFILE, HELPFILE)
     values (1, 'Deutsch', 'de', 'ISO8859-1', 'templates/default/vkcmailtemplates/de/mail_benachrichtigung', 'templates/default/vkcmailtemplates/de/images/', '', 'templates/default/help/de/help.html');

insert into LANGUAGES
            (LANGUAGEID, NAME, SHORTNAME, ISOCODE, MAILFILE, MAILIMAGEPATH, EXPDOCFILE, HELPFILE)
     values (2, 'English', 'en', 'ISO8859-1', 'templates/default/vkcmailtemplates/en/mail_notification', 'templates/default/vkcmailtemplates/en/images/', '', 'templates/default/help/en/help.html');

/* language packs */
delete from languagepacks;

insert into LANGUAGEPACKS
            (LANGPACKID, COUNTRYCODE, NAME, DESCRIPTION, CLASSNAME, CLASSPATH, ENABLED)
     values (0, '', 'Language Pack: unkown', 'unkown', '', '', 1);

insert into LANGUAGEPACKS
            (LANGPACKID, COUNTRYCODE, NAME, DESCRIPTION, CLASSNAME, CLASSPATH, ENABLED)
     values (1, 'de', 'Language Pack: German', 'Analyser Language Pack German', 'vkc.analyse.Analyser_de', 'vkc/analyse', 1);
     
insert into LANGUAGEPACKS
            (LANGPACKID, COUNTRYCODE, NAME, DESCRIPTION, CLASSNAME, CLASSPATH, ENABLED)
     values (2, 'es', 'Language Pack: Spanish', 'Analyser Language Pack Spanish', 'vkc.analyse.Analyser_es', 'vkc/analyse', 1);
     
insert into LANGUAGEPACKS
            (LANGPACKID, COUNTRYCODE, NAME, DESCRIPTION, CLASSNAME, CLASSPATH, ENABLED)
     values (3, 'gb', 'Language Pack: English', 'Analyser Language Pack English', 'vkc.analyse.Analyser_gb', 'vkc/analyse', 1);
     

/* templates */
delete from templates;

insert into TEMPLATES
            (TEMPLATEID, NAME, PATH, DESCRIPTION, PREVIEWPIC, ENABLED)
     values (1, 'default', '/templates/default', 'default template', '/templates/default/gfx/defaultlayout.jpg', 1); 
     
     