[cvs] expresso commit by mtraum: recreated database

Sun Dec 5 13:02:01 PST 2004

Log Message:
-----------
recreated database

Modified Files:
--------------
    expresso/expresso-web/WEB-INF/db/default:
        default.properties
        default.script

Revision Data
-------------
Index: default.script
===================================================================
RCS file: /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/db/default/default.script,v
retrieving revision 1.32
retrieving revision 1.33
diff -Lexpresso-web/WEB-INF/db/default/default.script -Lexpresso-web/WEB-INF/db/default/default.script -u -r1.32 -r1.33

--- expresso-web/WEB-INF/db/default/default.script
+++ expresso-web/WEB-INF/db/default/default.script
@@ -106,7 +106,7 @@
 CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
 CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
 CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
-CREATE ALIAS SUBSTR FOR "org.hsql.Library.substring"
+CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
 CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
 CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
 CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
@@ -126,276 +126,9 @@
 CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
 CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
 CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
-/*C1*/CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserGroup',0,50,10)
-INSERT INTO USERROLES VALUES('Everybody','All Users',NULL)
-INSERT INTO USERROLES VALUES('Nobody','Unknown Users',NULL)
-INSERT INTO USERROLES VALUES('NotReg','Users Not Yet Registered',NULL)
-INSERT INTO USERROLES VALUES('Admin','Administrative Users',NULL)
-INSERT INTO REGDOMAIN VALUES(1,'default','Default Registration Domain','Everybody','com.jcorporate.expresso.services.controller.SimpleRegistration','N','N','Y','N','N',NULL,'NotReg',NULL)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap',0,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain',0,50,10)
-INSERT INTO REGOBJMAP VALUES(1,'com.jcorporate.expresso.ext.dbobj.RegisteredUser','ExpUid',1,1,'!IsActive,!UserName,!InternalComment,!AddedOn,!UpdatedOn,!URL,!EmailPrivate,!Occupation,!Location,!Expertise,!OtherProjects,!Contributions,!Phone,!Testimonial,!IPAddress',999,'Y','N')
-INSERT INTO REGDOMAIN VALUES(2,'extended','Extended Registration Domain','Everybody','com.jcorporate.expresso.services.controller.Registration','Y','N','Y','Y','N',NULL,'NotReg',NULL)
-INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Person','ExpUid',1,1,'!ExpUid,!AddedOn,!UpdatedOn',999,'Y','N')
-INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Phone','ExpUid',1,0,'!PhoneId,!ExpUid,!AddedOn,!UpdatedOn,+Type',999,'Y','N')
-INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Address','ExpUid',1,1,'!AddressId,!ExpUid,!AddedOn,!UpdatedOn',999,'Y','N')
-INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Contact','ExpUid',0,0,'!ContactId,!ExpUid,!AddedOn,!UpdatedOn,+Type',999,'Y','N')
-INSERT INTO USERSTABLE VALUES(1,'Anonymous',NULL,'none',1,'D','N','2004-12-05 15:58:06.0','2004-12-05 15:58:06.0',NULL,'Anonymous User')
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers',0,50,10)
-INSERT INTO GROUPMEMBERS VALUES('Everybody',NULL,1)
-INSERT INTO USERSTABLE VALUES(2,'NONE',NULL,'none',1,'D','N','2004-12-05 15:58:06.0','2004-12-05 15:58:06.0',NULL,'Default user before login')
-INSERT INTO GROUPMEMBERS VALUES('Nobody',NULL,2)
-INSERT INTO USERSTABLE VALUES(3,'Admin',NULL,'none',1,'A','N','2004-12-05 15:58:06.0','2004-12-05 15:58:06.0',NULL,'Administrative User')
-INSERT INTO GROUPMEMBERS VALUES('Admin',NULL,3)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity',0,50,10)
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','D')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','D')
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity',0,50,10)
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.ComponentManager','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.DataTransfer','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.Download','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.HealthCheck','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.ReportServer','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.RunSQL','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.ServeTextFile','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.Upload','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.xml.controller.XMLController','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.CacheControl','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.Configuration','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.ControllerSecurityMatrix','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.CronController','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.DBMaint','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.DBSecurityMatrix','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.EditUserPreference','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.JobSecurityMatrix','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.Log','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.QueueJob','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleLoginController','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleLoginController','Everybody','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleLoginController','Nobody','promptLogin,processLogin,emailValidate,promptSendPassword,processSendPassword,processRevalidate')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleRegistration','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleRegistration','Everybody','showDBMenu,emailValidate,promptSelfRegister,processSelfRegister,promptAddRecord,processAddRecord,promptUpdateRecord,processUpdateRecord,promptDeleteRecord,processDeleteRecord,processListRecords,processRevalidate')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleRegistration','Nobody','showDBMenu,emailValidate,promptSelfRegister,processSelfRegister,processRevalidate')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.Status','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.ValidationController','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.configuration.CreateSettingsWizard','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.configuration.UpgradeSettingsWizard','Admin','*')
-INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.core.servlet.Test','Admin','*')
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity',0,50,10)
-INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.ext.job.SendNotice','Admin','*')
-INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ClearOldValidation','Admin','*')
-INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ControllerJob','Admin','*')
-INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.TestJob','Admin','*')
-INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ValidationJob','Admin','*')
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL',0,50,10)
 INSERT INTO AUDITLOG_L VALUES('ADD','ADD')
 INSERT INTO AUDITLOG_L VALUES('DEL','DELETE')
 INSERT INTO AUDITLOG_L VALUES('UPT','UPDATE')
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes',0,50,10)
 INSERT INTO ISOCOUNTRYCODES VALUES('US','United States',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('AF','Afghanistan',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('AX','Aland Islands',NULL)
@@ -636,7 +369,6 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('YE','Yemen',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('ZM','Zambia',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('ZW','Zimbabwe',NULL)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains',0,50,10)
 INSERT INTO REVERSEDOMAINS VALUES('us','United States',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('af','Afghanistan',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ax','Aland Islands',NULL)
@@ -893,10 +625,294 @@
 INSERT INTO REVERSEDOMAINS VALUES('int','International Treaty Organization',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('uk','United Kingdom',NULL)
 INSERT INTO USERAGENT VALUES(1,9999,'Default Agent','.*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.ComponentManager','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.DataTransfer','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.Download','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.HealthCheck','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.ReportServer','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.RunSQL','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.ServeTextFile','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.controller.Upload','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.ext.xml.controller.XMLController','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.CacheControl','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.Configuration','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.ControllerSecurityMatrix','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.CronController','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.DBMaint','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.DBSecurityMatrix','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.EditUserPreference','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.JobSecurityMatrix','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.Log','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.QueueJob','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleLoginController','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleLoginController','Everybody','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleLoginController','Nobody','promptLogin,processLogin,emailValidate,promptSendPassword,processSendPassword,processRevalidate')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleRegistration','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleRegistration','Everybody','showDBMenu,emailValidate,promptSelfRegister,processSelfRegister,promptAddRecord,processAddRecord,promptUpdateRecord,processUpdateRecord,promptDeleteRecord,processDeleteRecord,processListRecords,processRevalidate')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.SimpleRegistration','Nobody','showDBMenu,emailValidate,promptSelfRegister,processSelfRegister,processRevalidate')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.Status','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.ValidationController','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.configuration.CreateSettingsWizard','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.services.controller.configuration.UpgradeSettingsWizard','Admin','*')
+INSERT INTO CONTROLLERSECURITY VALUES('com.jcorporate.expresso.core.servlet.Test','Admin','*')
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserGroup',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes',0,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains',0,50,10)
 INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault',50,50,NULL)
 INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo',20,5,30)
 INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.Event',20,5,90)
 INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserPreference',20,5,30)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBMessage',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.EventMail',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.GroupNest',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobQueue',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.LogEntry',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.SchemaList',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.Setup',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue',50,50,10)
+INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam',50,50,10)
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ISOCountryCodes','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.ReverseLookupDomains','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerDefault','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ControllerSecurity','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBMessage','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBObjSecurity','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.DefaultUserInfo','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Event','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.EventMail','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupMembers','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.GroupNest','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueue','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.JobSecurity','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.LogEntry','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationDomain','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RegistrationObjectMap','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.SchemaList','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.Setup','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserGroup','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreference','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue','Admin','D')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','A')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','U')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','S')
+INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam','Admin','D')
+INSERT INTO USERSTABLE VALUES(1,'Anonymous',NULL,'none',1,'D','N','2004-12-05 15:58:06.0','2004-12-05 15:58:06.0',NULL,'Anonymous User')
+INSERT INTO USERSTABLE VALUES(2,'NONE',NULL,'none',1,'D','N','2004-12-05 15:58:06.0','2004-12-05 15:58:06.0',NULL,'Default user before login')
+INSERT INTO USERSTABLE VALUES(3,'Admin',NULL,'none',1,'A','N','2004-12-05 15:58:06.0','2004-12-05 15:58:06.0',NULL,'Administrative User')
 INSERT INTO EVENT VALUES('SYSERROR','System Error')
 INSERT INTO EVENT VALUES('HEALTH','System Health Check')
 INSERT INTO EVENT VALUES('DOWNLOAD','User Download Activity')
@@ -909,6 +925,15 @@
 INSERT INTO EVENTMAIL VALUES('DOWNLOAD',3,'N')
 INSERT INTO EVENTMAIL VALUES('REGISTER',3,'Y')
 INSERT INTO EVENTMAIL VALUES('REGISTER',3,'N')
+INSERT INTO GROUPMEMBERS VALUES('Everybody',NULL,1)
+INSERT INTO GROUPMEMBERS VALUES('Nobody',NULL,2)
+INSERT INTO GROUPMEMBERS VALUES('Admin',NULL,3)
+INSERT INTO JOBQUEUE VALUES(1,3,'2004-12-05 15:58:13.0','com.jcorporate.expresso.services.job.ClearOldValidation','A',3,0,'any','0,0,-1,-1,7,-1')
+INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.ext.job.SendNotice','Admin','*')
+INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ClearOldValidation','Admin','*')
+INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ControllerJob','Admin','*')
+INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.TestJob','Admin','*')
+INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ValidationJob','Admin','*')
 INSERT INTO MIMETYPES VALUES(1,'audio/aiff','Audio File','Speaker.gif','aiff aif')
 INSERT INTO MIMETYPES VALUES(2,'audio/basic','audio/basic','Speaker.gif','au snd')
 INSERT INTO MIMETYPES VALUES(3,'audio/mid','MIDI File','Music.gif','mid midi')
@@ -989,51 +1014,13 @@
 INSERT INTO MIMETYPES VALUES(78,'video/quicktime','Apple Quicktime Video','QuickTime.gif','mov qt')
 INSERT INTO MIMETYPES VALUES(79,'video/x-ms-asf','Microsoft Netshow Video','Movie.gif','asf')
 INSERT INTO MIMETYPES VALUES(80,'video/vnd.rn-realvideo','Real Video','RealPlayer.gif','rm')
-INSERT INTO USERROLES VALUES('Demo','Demonstration Group',NULL)
-INSERT INTO USERPREFDEF VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','Language','Browser')
-INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','Browser','Browser Default')
-INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','es','Spanish')
-INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','fr','French')
-INSERT INTO USERPREFDEF VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','country','Country','default')
-INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','country','default','Default')
-INSERT INTO USERPREFDEF VALUES('*','PrimaryGroupPref','Primary Group','Demo')
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AppIntegration',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.DownloadFiles',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.DownloadLog',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSet',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestSetDet',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTestStat',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.PerfTests',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.RegisteredUser',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedCountries',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.RestrictedOverrides',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Address',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Contact',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Person',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.regobj.Phone',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.xml.dbobj.ControllerXSLMap',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.xml.dbobj.UserAgent',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBMessage',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBObjLimit',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.DBOtherMap',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.EventMail',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.GroupNest',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerControl',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobHandlerRegistry',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobQueue',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.JobQueueParam',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.LogEntry',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.MimeTypes',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RowGroupPerms',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.RowPermissions',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.SchemaList',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.Setup',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceDef',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.UserPreferenceVal',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueue',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ValidationQueueParam',50,50,10)
+INSERT INTO REGDOMAIN VALUES(1,'default','Default Registration Domain','Everybody','com.jcorporate.expresso.services.controller.SimpleRegistration','N','N','Y','N','N',NULL,'NotReg',NULL)
+INSERT INTO REGDOMAIN VALUES(2,'extended','Extended Registration Domain','Everybody','com.jcorporate.expresso.services.controller.Registration','Y','N','Y','Y','N',NULL,'NotReg',NULL)
+INSERT INTO REGOBJMAP VALUES(1,'com.jcorporate.expresso.ext.dbobj.RegisteredUser','ExpUid',1,1,'!IsActive,!UserName,!InternalComment,!AddedOn,!UpdatedOn,!URL,!EmailPrivate,!Occupation,!Location,!Expertise,!OtherProjects,!Contributions,!Phone,!Testimonial,!IPAddress',999,'Y','N')
+INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Person','ExpUid',1,1,'!ExpUid,!AddedOn,!UpdatedOn',999,'Y','N')
+INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Phone','ExpUid',1,0,'!PhoneId,!ExpUid,!AddedOn,!UpdatedOn,+Type',999,'Y','N')
+INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Address','ExpUid',1,1,'!AddressId,!ExpUid,!AddedOn,!UpdatedOn',999,'Y','N')
+INSERT INTO REGOBJMAP VALUES(2,'com.jcorporate.expresso.ext.dbobj.regobj.Contact','ExpUid',0,0,'!ContactId,!ExpUid,!AddedOn,!UpdatedOn,+Type',999,'Y','N')
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','AdminEmail','Email address of Administrative / Support Contact',NULL)
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','AdminName','Name of Administrative / Support Contact for Site','webmaster')
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','AsyncClaimTimeout','Claim Timeout for Asynchronous processes','30000')
@@ -1073,4 +1060,15 @@
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','insecureDBMaint','Allow DBMaint to Edit Unsecured DBObjects','N')
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','isNotifyOnJobSuccess','Boolean flag for whether to send an e-mail notification when a job completes suc','N')
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','privacyPolicy','URL To Website Privacy Policy',NULL)
-INSERT INTO JOBQUEUE VALUES(1,3,'2004-12-05 15:58:13.0','com.jcorporate.expresso.services.job.ClearOldValidation','A',3,0,'any','0,0,-1,-1,7,-1')
+INSERT INTO USERROLES VALUES('Everybody','All Users',NULL)
+INSERT INTO USERROLES VALUES('Nobody','Unknown Users',NULL)
+INSERT INTO USERROLES VALUES('NotReg','Users Not Yet Registered',NULL)
+INSERT INTO USERROLES VALUES('Admin','Administrative Users',NULL)
+INSERT INTO USERROLES VALUES('Demo','Demonstration Group',NULL)
+INSERT INTO USERPREFDEF VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','Language','Browser')
+INSERT INTO USERPREFDEF VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','country','Country','default')
+INSERT INTO USERPREFDEF VALUES('*','PrimaryGroupPref','Primary Group','Demo')
+INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','Browser','Browser Default')
+INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','es','Spanish')
+INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','language','fr','French')
+INSERT INTO USERPREFVAL VALUES('com.jcorporate.expresso.core.servlet.CheckLogin','country','default','Default')
Index: default.properties
===================================================================
RCS file: /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/db/default/default.properties,v
retrieving revision 1.27
retrieving revision 1.28
diff -Lexpresso-web/WEB-INF/db/default/default.properties -Lexpresso-web/WEB-INF/db/default/default.properties -u -r1.27 -r1.28
--- expresso-web/WEB-INF/db/default/default.properties
+++ expresso-web/WEB-INF/db/default/default.properties
@@ -1,4 +1,4 @@
 #HSQL database
-#Sun Dec 05 15:58:05 EST 2004
+#Sun Dec 05 16:00:01 EST 2004
 version=1.6
-modified=yes
+modified=no
