[cvs] expresso commit by mtraum: regenerated database

Sun Dec 5 12:59:33 PST 2004

Log Message:
-----------
regenerated 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.31
retrieving revision 1.32
diff -Lexpresso-web/WEB-INF/db/default/default.script -Lexpresso-web/WEB-INF/db/default/default.script -u -r1.31 -r1.32

--- expresso-web/WEB-INF/db/default/default.script
+++ expresso-web/WEB-INF/db/default/default.script
@@ -19,7 +19,7 @@
 CREATE TABLE SMPREGPH(PHONEID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,PHONETYPE VARCHAR NOT NULL,COUNTRYCODE CHAR NOT NULL,AREACODE CHAR NOT NULL,PHONENUM CHAR NOT NULL,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,UNIQUE(PHONEID,EXPUID))
 CREATE TABLE CTLXSLMAP(MATCHNUMBER INTEGER NOT NULL,CONTROLLERCLASS LONGVARCHAR NOT NULL,MATCHSEQ INTEGER NOT NULL,GROUPNAME VARCHAR NOT NULL,XSLFILENAME LONGVARCHAR NOT NULL,USERAGENT INTEGER NOT NULL,PARAM LONGVARCHAR NOT NULL,UNIQUE(MATCHNUMBER))
 CREATE TABLE USERAGENT(USERAGENT INTEGER NOT NULL,MATCHSEQ INTEGER NOT NULL,DESCRIP VARCHAR NOT NULL,UAPATTERN LONGVARCHAR NOT NULL,UNIQUE(USERAGENT))
-CREATE TABLE CHANGELOG(OBJECTCHANGED VARCHAR NOT NULL,RECORDKEY VARCHAR NOT NULL,OPERATION CHAR NOT NULL,CHANGEDFIELD VARCHAR NOT NULL,CHANGETIME TIMESTAMP NOT NULL,OLDVALUE VARCHAR,NEWVALUE VARCHAR,UNIQUE(OBJECTCHANGED,RECORDKEY,OPERATION,CHANGEDFIELD,CHANGETIME))
+CREATE TABLE CHANGELOGTWO(CHANGEKEY INTEGER NOT NULL,OBJECTCHANGED VARCHAR NOT NULL,RECORDKEY VARCHAR NOT NULL,OPERATION CHAR NOT NULL,CHANGEDFIELD VARCHAR NOT NULL,CHANGETIME TIMESTAMP NOT NULL,OLDVALUE VARCHAR,NEWVALUE VARCHAR,UNIQUE(CHANGEKEY))
 CREATE TABLE CTLDEFAULT(CONTROLLERCLASS CHAR NOT NULL,STYLE CHAR NOT NULL,STATECODE CHAR NOT NULL,PARAMS LONGVARCHAR,UNIQUE(CONTROLLERCLASS,STYLE,STATECODE))
 CREATE TABLE CONTROLLERSECURITY(CONTROLLERCLASS CHAR NOT NULL,GROUPNAME CHAR NOT NULL,STATES LONGVARCHAR NOT NULL,UNIQUE(CONTROLLERCLASS,GROUPNAME))
 CREATE TABLE DBMESSAGE(MESSAGENUMBER INTEGER NOT NULL,INPUTSTRING VARCHAR NOT NULL,OUTPUTSTRING VARCHAR NOT NULL,UNIQUE(MESSAGENUMBER))
@@ -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.hsqldb.Library.substring"
+CREATE ALIAS SUBSTR FOR "org.hsql.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,9 +126,276 @@
 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)
@@ -369,6 +636,7 @@
 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)
@@ -625,294 +893,10 @@
 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.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.JobSecurity',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-11-09 17:21:09.0','2004-11-09 17:21:09.0',NULL,'Anonymous User')
-INSERT INTO USERSTABLE VALUES(2,'NONE',NULL,'none',1,'D','N','2004-11-09 17:21:09.0','2004-11-09 17:21:09.0',NULL,'Default user before login')
-INSERT INTO USERSTABLE VALUES(3,'Admin',NULL,'none',1,'A','N','2004-11-09 17:21:09.0','2004-11-09 17:21:09.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')
@@ -925,10 +909,6 @@
 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-11-09 17:21:24.0','com.jcorporate.expresso.services.job.ClearOldValidation','A',3,0,'any','0,0,-1,-1,7,-1')
 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')
@@ -1009,13 +989,51 @@
 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 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 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 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')
@@ -1055,15 +1073,4 @@
 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 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')
+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')
Index: default.properties
===================================================================
RCS file: /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/db/default/default.properties,v
retrieving revision 1.26
retrieving revision 1.27
diff -Lexpresso-web/WEB-INF/db/default/default.properties -Lexpresso-web/WEB-INF/db/default/default.properties -u -r1.26 -r1.27
--- expresso-web/WEB-INF/db/default/default.properties
+++ expresso-web/WEB-INF/db/default/default.properties
@@ -1,4 +1,4 @@
 #HSQL database
-#Tue Nov 09 17:21:47 EST 2004
+#Sun Dec 05 15:58:05 EST 2004
 version=1.6
-modified=no
+modified=yes
