[cvs] expresso commit by mtraum: update with new ISOCountryCode values

JCorporate Ltd jcorp at jcorp2.servlets.net
Tue Nov 9 14:25:46 PST 2004 

Log Message:
-----------
update with new ISOCountryCode values

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.30
retrieving revision 1.31
diff -Lexpresso-web/WEB-INF/db/default/default.script -Lexpresso-web/WEB-INF/db/default/default.script -u -r1.30 -r1.31
--- expresso-web/WEB-INF/db/default/default.script
+++ expresso-web/WEB-INF/db/default/default.script
@@ -1,46 +1,51 @@
-CREATE TABLE APPINTEGRATE(INTEGRATIONID INTEGER NOT NULL,FROMSCHEMA VARCHAR NOT NULL,TOSCHEMA VARCHAR NOT NULL,FROMOBJ VARCHAR NOT NULL,TOOBJ VARCHAR NOT NULL,FROMKEY VARCHAR NOT NULL,TOKEY VARCHAR NOT NULL,UNIQUE(INTEGRATIONID))
-CREATE TABLE DOWNLOADFILES(FILENUMBER INTEGER NOT NULL,FILEPATHNAME VARCHAR NOT NULL,DISPLAYNAME VARCHAR,FILEURL VARCHAR,DESCRIP VARCHAR NOT NULL,PROJECT CHAR,GROUPNAME CHAR NOT NULL,LASTUPDATED TIMESTAMP,DLNOTES VARCHAR,MIMENUMBER INTEGER NOT NULL,ISACTIVE CHAR NOT NULL,ISRESTRICTED BIT NOT NULL,UNIQUE(FILENUMBER))
+CREATE TABLE APPINTEGRATE(INTEGRATIONID INTEGER NOT NULL,FROMSCHEMA VARCHAR NOT NULL,TOSCHEMA VARCHAR NOT NULL,FROMOBJ VARCHAR NOT NULL,TOOBJ VARCHAR NOT NULL,FROMKEY LONGVARCHAR NOT NULL,TOKEY LONGVARCHAR NOT NULL,UNIQUE(INTEGRATIONID))
+CREATE TABLE AUDITLOG(AUDITLOG_ID INTEGER NOT NULL,AUDITLOG_CODE CHAR NOT NULL,EXPUID INTEGER NOT NULL,AUDITLOG_DATE TIMESTAMP NOT NULL,AUDITLOG_DES VARCHAR,UNIQUE(AUDITLOG_ID))
+CREATE TABLE AUDITLOG_L(AUDITLOG_CODE CHAR NOT NULL,AUDITLOG_DES VARCHAR NOT NULL,UNIQUE(AUDITLOG_CODE))
+CREATE TABLE DOWNLOADFILES(FILENUMBER INTEGER NOT NULL,FILEPATHNAME LONGVARCHAR NOT NULL,DISPLAYNAME VARCHAR,FILEURL LONGVARCHAR,DESCRIP VARCHAR NOT NULL,PROJECT CHAR,GROUPNAME CHAR NOT NULL,LASTUPDATED TIMESTAMP,DLNOTES LONGVARCHAR,MIMENUMBER INTEGER NOT NULL,ISACTIVE CHAR NOT NULL,ISRESTRICTED BIT NOT NULL,UNIQUE(FILENUMBER))
 CREATE TABLE DOWNLOADLOG(LOGENTRY INTEGER NOT NULL,FILENUMBER INTEGER NOT NULL,EXPUID INTEGER NOT NULL,DOWNLOADED TIMESTAMP,FILEPATHNAME VARCHAR NOT NULL,IPNUMBER CHAR NOT NULL,UNIQUE(LOGENTRY))
 CREATE TABLE ISOCOUNTRYCODES(ISOCODE VARCHAR NOT NULL,COUNTRY VARCHAR NOT NULL,POSTALREGEXP VARCHAR,UNIQUE(ISOCODE))
 CREATE UNIQUE INDEX COUNTRYNAMES ON ISOCOUNTRYCODES(COUNTRY)
 CREATE TABLE PTESTSET(SETNUMBER INTEGER NOT NULL,DESCRIP VARCHAR NOT NULL,HEALTHCHECK CHAR NOT NULL,UNIQUE(SETNUMBER))
 CREATE TABLE PTESTSETDET(SETNUMBER INTEGER NOT NULL,SEQUENCENUMBER INTEGER NOT NULL,TESTNUMBER INTEGER NOT NULL,UNIQUE(SETNUMBER,SEQUENCENUMBER))
 CREATE TABLE PTESTSTAT(TESTNUMBER INTEGER NOT NULL,RUNWHEN TIMESTAMP NOT NULL,RUNTIME INTEGER NOT NULL,USERCOUNT INTEGER,UNIQUE(TESTNUMBER,RUNWHEN))
-CREATE TABLE PTESTS(TESTNUMBER INTEGER NOT NULL,URLTOTEST VARCHAR NOT NULL,DESCRIP VARCHAR NOT NULL,NORMTIME INTEGER,WARNTIME INTEGER,MAXTIME INTEGER,LASTTIME INTEGER,TESTCOUNT INTEGER,TOTALTIME INTEGER,EXPECTSTRING VARCHAR,SUCCESSFULTESTS INTEGER,LASTTESTSUCCEEDED CHAR,LASTRUN TIMESTAMP,LASTFAILUREREASON VARCHAR,HTTPMETHOD CHAR NOT NULL,GETSESSION CHAR NOT NULL,UNIQUE(TESTNUMBER))
-CREATE TABLE USERREGISTER(EXPUID INTEGER NOT NULL,FIRSTNAME VARCHAR NOT NULL,LASTNAME VARCHAR NOT NULL,FULLNAME VARCHAR,COMPANYNAME VARCHAR,URL VARCHAR,ADDRESS VARCHAR NOT NULL,CITY VARCHAR NOT NULL,STATEPROVINCE VARCHAR NOT NULL,POSTALCODE VARCHAR,COUNTRY VARCHAR NOT NULL,USERCOMMENT VARCHAR,INDUSTRY CHAR NOT NULL,EMPLOYEES CHAR NOT NULL,JOBTITLE CHAR,SUBSCRIBE CHAR,CONTRIBUTING CHAR,PROJECTS CHAR,ISACTIVE CHAR,INTERNALCOMMENT VARCHAR,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,EMAILPRIVATE CHAR,OCCUPATION VARCHAR,LOCATION VARCHAR,EXPERTISE VARCHAR,CONTRIBUTIONS VARCHAR,OTHERPROJECTS VARCHAR,PHONE VARCHAR,TESTIMONIAL VARCHAR,IPADDRESS VARCHAR,UNIQUE(EXPUID))
+CREATE TABLE PTESTS(TESTNUMBER INTEGER NOT NULL,URLTOTEST LONGVARCHAR NOT NULL,DESCRIP VARCHAR NOT NULL,NORMTIME INTEGER,WARNTIME INTEGER,MAXTIME INTEGER,LASTTIME INTEGER,TESTCOUNT INTEGER,TOTALTIME INTEGER,EXPECTSTRING LONGVARCHAR,SUCCESSFULTESTS INTEGER,LASTTESTSUCCEEDED CHAR,LASTRUN TIMESTAMP,LASTFAILUREREASON LONGVARCHAR,HTTPMETHOD CHAR NOT NULL,GETSESSION CHAR NOT NULL,UNIQUE(TESTNUMBER))
+CREATE TABLE USERREGISTER(EXPUID INTEGER NOT NULL,FIRSTNAME VARCHAR NOT NULL,LASTNAME VARCHAR NOT NULL,FULLNAME VARCHAR,COMPANYNAME VARCHAR,URL VARCHAR,ADDRESS LONGVARCHAR NOT NULL,CITY VARCHAR NOT NULL,STATEPROVINCE VARCHAR NOT NULL,POSTALCODE VARCHAR,COUNTRY VARCHAR NOT NULL,USERCOMMENT LONGVARCHAR,INDUSTRY CHAR NOT NULL,EMPLOYEES CHAR NOT NULL,JOBTITLE CHAR,SUBSCRIBE CHAR,CONTRIBUTING CHAR,PROJECTS CHAR,ISACTIVE CHAR,INTERNALCOMMENT LONGVARCHAR,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,EMAILPRIVATE CHAR,OCCUPATION LONGVARCHAR,LOCATION LONGVARCHAR,EXPERTISE LONGVARCHAR,CONTRIBUTIONS LONGVARCHAR,OTHERPROJECTS LONGVARCHAR,PHONE VARCHAR,TESTIMONIAL LONGVARCHAR,IPADDRESS VARCHAR,UNIQUE(EXPUID))
 CREATE TABLE RESTRICTCNTRY(RESTRICTEDID INTEGER NOT NULL,DOMAINID VARCHAR NOT NULL,UNIQUE(RESTRICTEDID))
 CREATE TABLE RESTRICTOVRRIDE(EXPUID INTEGER NOT NULL,ISALLOWED BIT NOT NULL,UNIQUE(EXPUID))
 CREATE TABLE REVERSEDOMAINS(DOMAINCODE VARCHAR NOT NULL,DOMAINDESCRIP VARCHAR NOT NULL,DOMAINNOTES VARCHAR,UNIQUE(DOMAINCODE))
-CREATE TABLE USERSTABLE(EXPUID INTEGER NOT NULL,LOGINNAME CHAR NOT NULL,PASSWD VARCHAR,EMAIL VARCHAR NOT NULL,REGDOMID INTEGER NOT NULL,ACCOUNTSTATUS CHAR NOT NULL,REGCOMPLETE CHAR NOT NULL,CREATEDATE TIMESTAMP NOT NULL,UPDATEDATE TIMESTAMP NOT NULL,EMAILVALCODE VARCHAR,USERNAME VARCHAR,UNIQUE(EXPUID))
-CREATE UNIQUE INDEX LOGINNAMES ON USERSTABLE(LOGINNAME)
-CREATE INDEX EMAILS ON USERSTABLE(EMAIL)
 CREATE TABLE SMPREGAD(ADDRESSID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,STREET1 VARCHAR NOT NULL,STREET2 VARCHAR,CITY VARCHAR NOT NULL,STATE VARCHAR NOT NULL,ZIP VARCHAR NOT NULL,COUNTRY VARCHAR NOT NULL,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,UNIQUE(ADDRESSID,EXPUID))
-CREATE TABLE SMPREGCT(CONTACTID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,CONTACTTYPE VARCHAR NOT NULL,CONTACT VARCHAR NOT NULL,INSTRUCTIONS VARCHAR,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,UNIQUE(CONTACTID,EXPUID))
+CREATE TABLE SMPREGCT(CONTACTID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,CONTACTTYPE VARCHAR NOT NULL,CONTACT VARCHAR NOT NULL,INSTRUCTIONS LONGVARCHAR,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,UNIQUE(CONTACTID,EXPUID))
 CREATE TABLE SMPREGPR(EXPUID INTEGER NOT NULL,SALUTATION CHAR,FIRSTNAME VARCHAR NOT NULL,MIDDLENAME VARCHAR,LASTNAME VARCHAR NOT NULL,BIRTHDATE TIMESTAMP,ADDEDON TIMESTAMP,UPDATEDON TIMESTAMP,UNIQUE(EXPUID))
 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 VARCHAR NOT NULL,MATCHSEQ INTEGER NOT NULL,GROUPNAME VARCHAR NOT NULL,XSLFILENAME VARCHAR NOT NULL,USERAGENT INTEGER NOT NULL,PARAM VARCHAR NOT NULL,UNIQUE(MATCHNUMBER))
-CREATE TABLE USERAGENT(USERAGENT INTEGER NOT NULL,MATCHSEQ INTEGER NOT NULL,DESCRIP VARCHAR NOT NULL,UAPATTERN VARCHAR NOT NULL,UNIQUE(USERAGENT))
-CREATE TABLE CTLDEFAULT(CONTROLLERCLASS CHAR NOT NULL,STYLE CHAR NOT NULL,STATECODE CHAR NOT NULL,PARAMS VARCHAR,UNIQUE(CONTROLLERCLASS,STYLE,STATECODE))
-CREATE TABLE CONTROLLERSECURITY(CONTROLLERCLASS CHAR NOT NULL,GROUPNAME CHAR NOT NULL,STATES VARCHAR NOT NULL,UNIQUE(CONTROLLERCLASS,GROUPNAME))
+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 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))
 CREATE TABLE DBOBJLIMIT(DBOBJECTNAME VARCHAR NOT NULL,PAGELIMIT INTEGER NOT NULL,CACHESIZE INTEGER NOT NULL,TTL INTEGER,UNIQUE(DBOBJECTNAME))
 CREATE TABLE DBOBJSECURITY(DBOBJECTNAME VARCHAR NOT NULL,GROUPNAME CHAR NOT NULL,METHODCODE CHAR NOT NULL,UNIQUE(DBOBJECTNAME,METHODCODE,GROUPNAME))
 CREATE TABLE DBOTHERMAP(DBOBJNAME VARCHAR NOT NULL,DBCONNNAME CHAR NOT NULL,DESCRIP VARCHAR,UNIQUE(DBOBJNAME))
+CREATE TABLE USERSTABLE(EXPUID INTEGER NOT NULL,LOGINNAME CHAR NOT NULL,PASSWD VARCHAR,EMAIL VARCHAR NOT NULL,REGDOMID INTEGER NOT NULL,ACCOUNTSTATUS CHAR NOT NULL,REGCOMPLETE CHAR NOT NULL,CREATEDATE TIMESTAMP NOT NULL,UPDATEDATE TIMESTAMP NOT NULL,EMAILVALCODE VARCHAR,USERNAME VARCHAR,UNIQUE(EXPUID))
+CREATE UNIQUE INDEX LOGINNAMES ON USERSTABLE(LOGINNAME)
+CREATE INDEX EMAILS ON USERSTABLE(EMAIL)
+CREATE INDEX ACCT_STATUS_IDX ON USERSTABLE(ACCOUNTSTATUS)
 CREATE TABLE EVENT(EVENT CHAR NOT NULL,DESCRIP VARCHAR NOT NULL,UNIQUE(EVENT))
 CREATE TABLE EVENTMAIL(EVENT CHAR NOT NULL,EXPUID INTEGER NOT NULL,SUCCESS CHAR NOT NULL,UNIQUE(EVENT,EXPUID,SUCCESS))
 CREATE TABLE GROUPMEMBERS(GROUPNAME CHAR NOT NULL,EXPIRES DATE,EXPUID INTEGER NOT NULL,UNIQUE(EXPUID,GROUPNAME))
+CREATE INDEX GROUPNAME_IDX ON GROUPMEMBERS(GROUPNAME)
 CREATE TABLE GROUPNEST(GROUPNAME CHAR NOT NULL,MEMBEROF CHAR NOT NULL,UNIQUE(GROUPNAME,MEMBEROF))
 CREATE TABLE JOBHANDLERCONTROL(COMMANDID INTEGER NOT NULL,STATUS VARCHAR NOT NULL,COMMAND VARCHAR NOT NULL,SERVERID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,REQUESTTIME TIMESTAMP NOT NULL,UNIQUE(COMMANDID))
 CREATE TABLE JOBHANDLERREGISTRY(LOADAVERAGE INTEGER,CURRENTJOBS INTEGER,TIMSTAMP TIMESTAMP,STATUS VARCHAR,POWERFACTOR DOUBLE,TOTALMEM INTEGER,FREEMEM INTEGER,USEDMEM INTEGER,SERVERID INTEGER NOT NULL,HOSTNAME VARCHAR NOT NULL,OSNAME VARCHAR NOT NULL,CONTROLCOMMAND VARCHAR,UNIQUE(SERVERID,HOSTNAME))
 CREATE TABLE JOBQUEUE(JOBNUMBER INTEGER NOT NULL,EXPUID INTEGER NOT NULL,REQUESTTIME TIMESTAMP,JOBCODE VARCHAR NOT NULL,STATUSCODE CHAR NOT NULL,PRIORITY INTEGER NOT NULL,SERVERID INTEGER NOT NULL,JOBOSNAME VARCHAR NOT NULL,JOBCRONPARAMS VARCHAR,UNIQUE(JOBNUMBER))
-CREATE TABLE JOBQUEUEPARAM(JOBNUMBER INTEGER NOT NULL,PARAMNUMBER SMALLINT NOT NULL,PARAMVALUE VARCHAR,PARAMCODE VARCHAR,UNIQUE(JOBNUMBER,PARAMNUMBER))
-CREATE TABLE JOBSECURITY(JOBCLASS VARCHAR NOT NULL,GROUPNAME CHAR NOT NULL,FUNCTIONS VARCHAR NOT NULL,UNIQUE(JOBCLASS,GROUPNAME))
-CREATE TABLE SYSLOG(LOGTIME TIMESTAMP NOT NULL,MESSAGETEXT VARCHAR NOT NULL,OBJECTNAME VARCHAR NOT NULL,MESSAGEID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,JOBNUMBER VARCHAR NOT NULL,MESSAGELEVEL INTEGER NOT NULL,MESSAGECOLOR CHAR,LOGCHANNEL VARCHAR,UNIQUE(LOGTIME,OBJECTNAME,MESSAGEID))
+CREATE TABLE JOBQUEUEPARAM(JOBNUMBER INTEGER NOT NULL,PARAMNUMBER SMALLINT NOT NULL,PARAMVALUE LONGVARCHAR,PARAMCODE VARCHAR,UNIQUE(JOBNUMBER,PARAMNUMBER))
+CREATE TABLE JOBSECURITY(JOBCLASS VARCHAR NOT NULL,GROUPNAME CHAR NOT NULL,FUNCTIONS LONGVARCHAR NOT NULL,UNIQUE(JOBCLASS,GROUPNAME))
+CREATE TABLE SYSLOG(LOGTIME TIMESTAMP NOT NULL,MESSAGETEXT LONGVARCHAR NOT NULL,OBJECTNAME VARCHAR NOT NULL,MESSAGEID INTEGER NOT NULL,EXPUID INTEGER NOT NULL,JOBNUMBER VARCHAR NOT NULL,MESSAGELEVEL INTEGER NOT NULL,MESSAGECOLOR CHAR,LOGCHANNEL VARCHAR,UNIQUE(LOGTIME,OBJECTNAME,MESSAGEID))
 CREATE TABLE MIMETYPES(MIMENUMBER INTEGER NOT NULL,MIMETYPE VARCHAR NOT NULL,MIMEDESCRIPTION VARCHAR,MIMEICON VARCHAR,MIMEFILEEXTENSIONS VARCHAR,UNIQUE(MIMENUMBER))
 CREATE UNIQUE INDEX MIMEINDEX ON MIMETYPES(MIMETYPE)
-CREATE TABLE REGDOMAIN(REGDOMID INTEGER NOT NULL,NAME VARCHAR NOT NULL,DESCRIPTION VARCHAR NOT NULL,GROUPNAME CHAR NOT NULL,CONTROLLERCLASS VARCHAR,REGREQUIRED CHAR,APPROVE CHAR,USERPASSWD CHAR,EMAILVALIDATE CHAR,EMAILASLOGIN CHAR,APPROVERS VARCHAR,NOTREGGRP CHAR,NOTAPPROVEDGRP CHAR,UNIQUE(REGDOMID))
+CREATE TABLE REGDOMAIN(REGDOMID INTEGER NOT NULL,NAME VARCHAR NOT NULL,DESCRIPTION VARCHAR NOT NULL,GROUPNAME CHAR NOT NULL,CONTROLLERCLASS VARCHAR,REGREQUIRED CHAR,APPROVE CHAR,USERPASSWD CHAR,EMAILVALIDATE CHAR,EMAILASLOGIN CHAR,APPROVERS LONGVARCHAR,NOTREGGRP CHAR,NOTAPPROVEDGRP CHAR,UNIQUE(REGDOMID))
 CREATE UNIQUE INDEX REGDOMAINNAME ON REGDOMAIN(NAME)
-CREATE TABLE REGOBJMAP(REGDOMID INTEGER NOT NULL,REGOBJ VARCHAR NOT NULL,UIDFIELD CHAR NOT NULL,RECMIN INTEGER,RECMAX INTEGER,REGFIELDS VARCHAR,REGORDER INTEGER,ALLOWEDIT CHAR,ALLOWDEL CHAR,UNIQUE(REGDOMID,REGOBJ))
+CREATE TABLE REGOBJMAP(REGDOMID INTEGER NOT NULL,REGOBJ VARCHAR NOT NULL,UIDFIELD CHAR NOT NULL,RECMIN INTEGER,RECMAX INTEGER,REGFIELDS LONGVARCHAR,REGORDER INTEGER,ALLOWEDIT CHAR,ALLOWDEL CHAR,UNIQUE(REGDOMID,REGOBJ))
 CREATE TABLE ROW_GRP_PERMS(TARGET_TABLE VARCHAR NOT NULL,ROW_KEY VARCHAR NOT NULL,PERM_GROUP CHAR NOT NULL,PERMISSIONS INTEGER,UNIQUE(TARGET_TABLE,ROW_KEY,PERM_GROUP))
 CREATE INDEX TABLEROW ON ROW_GRP_PERMS(TARGET_TABLE,ROW_KEY)
 CREATE TABLE ROW_PERMISSIONS(TARGET_TABLE VARCHAR NOT NULL,ROW_KEY VARCHAR NOT NULL,OWNER_ID INTEGER,PERMISSIONS INTEGER,UNIQUE(TARGET_TABLE,ROW_KEY))
@@ -51,12 +56,9 @@
 CREATE TABLE USERPREFDEF(CLASSNAME VARCHAR NOT NULL,PREFCODE VARCHAR NOT NULL,DESCRIP VARCHAR,DEFAULTVAL VARCHAR,UNIQUE(CLASSNAME,PREFCODE))
 CREATE TABLE USERPREFVAL(CLASSNAME CHAR NOT NULL,PREFCODE CHAR NOT NULL,PREFVALUE CHAR NOT NULL,DESCRIP VARCHAR NOT NULL,UNIQUE(CLASSNAME,PREFCODE,PREFVALUE))
 CREATE TABLE VALQUEUE(VALID INTEGER NOT NULL,STATUSCODE CHAR NOT NULL,ADDEDON TIMESTAMP NOT NULL,EXPIRESAT TIMESTAMP NOT NULL,PROCESSEDON TIMESTAMP,EXPUID INTEGER,VALCODE VARCHAR NOT NULL,VALHANDLER VARCHAR NOT NULL,UNIQUE(VALID))
-CREATE TABLE VALQUEUEPARAM(VALID INTEGER NOT NULL,PARAMNUM SMALLINT NOT NULL,PARAMVAL VARCHAR,PARAMCODE VARCHAR,UNIQUE(VALID,PARAMNUM))
-CREATE TABLE AUDITLOG(AUDITLOG_ID INTEGER NOT NULL,AUDITLOG_CODE CHAR NOT NULL,EXPUID INTEGER NOT NULL,AUDITLOG_DATE TIMESTAMP NOT NULL,AUDITLOG_DES VARCHAR,UNIQUE(AUDITLOG_ID))
-CREATE TABLE AUDITLOG_L(AUDITLOG_CODE CHAR NOT NULL,AUDITLOG_DES VARCHAR NOT NULL,UNIQUE(AUDITLOG_CODE))
-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))
-GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
+CREATE TABLE VALQUEUEPARAM(VALID INTEGER NOT NULL,PARAMNUM SMALLINT NOT NULL,PARAMVAL LONGVARCHAR,PARAMCODE VARCHAR,UNIQUE(VALID,PARAMNUM))
 GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
+GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
 CREATE USER SA PASSWORD "" ADMIN
 CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
 CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
@@ -124,8 +126,12 @@
 CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
 CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
 CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
+INSERT INTO AUDITLOG_L VALUES('ADD','ADD')
+INSERT INTO AUDITLOG_L VALUES('DEL','DELETE')
+INSERT INTO AUDITLOG_L VALUES('UPT','UPDATE')
 INSERT INTO ISOCOUNTRYCODES VALUES('US','United States',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('AF','Afghanistan',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('AX','Aland Islands',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('AL','Albania',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('DZ','Algeria',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('AS','American Samoa',NULL)
@@ -174,7 +180,7 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('CO','Colombia',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('KM','Comoros',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('CG','Congo',NULL)
-INSERT INTO ISOCOUNTRYCODES VALUES('CD','Congo, The Democratic RepubliC Of The',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('CD','Congo, The Democratic Republic Of The',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('CK','Cook Islands',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('CR','Costa Rica',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('CI','Cote D''Ivoire',NULL)
@@ -186,7 +192,6 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('DJ','Djibouti',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('DM','Dominica',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('DO','Dominican Republic',NULL)
-INSERT INTO ISOCOUNTRYCODES VALUES('TP','East Timor',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('EC','Ecuador',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('EG','Egypt',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('SV','El Salvador',NULL)
@@ -234,7 +239,7 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('JM','Jamaica',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('JP','Japan',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('JO','Jordan',NULL)
-INSERT INTO ISOCOUNTRYCODES VALUES('KZ','Kazakstan',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('KZ','Kazakhstan',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('KE','Kenya',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('KI','Kiribati',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('KP','North Korea',NULL)
@@ -250,7 +255,7 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('LI','Liechtenstein',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('LT','Lithuania',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('LU','Luxembourg',NULL)
-INSERT INTO ISOCOUNTRYCODES VALUES('MO','Macau',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('MO','Macao',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('MK','Macedonia',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('MG','Madagascar',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('MW','Malawi',NULL)
@@ -287,7 +292,7 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('MP','Northern Mariana Islands',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('NO','Norway',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('OM','Oman',NULL)
-INSERT INTO ISOCOUNTRYCODES VALUES('PK','PakistaN',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('PK','Pakistan',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('PW','Palau',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('PS','Palestinian Territory',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('PA','Panama',NULL)
@@ -314,6 +319,7 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('ST','Sao Tome And Principe',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('SA','Saudi Arabia',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('SN','Senegal',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('CS','Serbia And Montenegro',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('SC','Seychelles',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('SL','Sierra Leone',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('SG','Singapore',NULL)
@@ -336,6 +342,7 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('TJ','Tajikistan',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('TZ','Tanzania',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('TH','Thailand',NULL)
+INSERT INTO ISOCOUNTRYCODES VALUES('TL','Timor-Leste',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('TG','Togo',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('TK','Tokelau',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('TO','Tonga',NULL)
@@ -360,11 +367,11 @@
 INSERT INTO ISOCOUNTRYCODES VALUES('WF','Wallis And Futuna',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('EH','Western Sahara',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('YE','Yemen',NULL)
-INSERT INTO ISOCOUNTRYCODES VALUES('YU','Yugoslavia',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('ZM','Zambia',NULL)
 INSERT INTO ISOCOUNTRYCODES VALUES('ZW','Zimbabwe',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('us','United States',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('af','Afghanistan',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('ax','Aland Islands',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('al','Albania',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('dz','Algeria',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('as','American Samoa',NULL)
@@ -413,7 +420,7 @@
 INSERT INTO REVERSEDOMAINS VALUES('co','Colombia',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('km','Comoros',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('cg','Congo',NULL)
-INSERT INTO REVERSEDOMAINS VALUES('cd','Congo, The Democratic RepubliC Of The',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('cd','Congo, The Democratic Republic Of The',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ck','Cook Islands',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('cr','Costa Rica',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ci','Cote D''Ivoire',NULL)
@@ -425,7 +432,6 @@
 INSERT INTO REVERSEDOMAINS VALUES('dj','Djibouti',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('dm','Dominica',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('do','Dominican Republic',NULL)
-INSERT INTO REVERSEDOMAINS VALUES('tp','East Timor',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ec','Ecuador',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('eg','Egypt',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('sv','El Salvador',NULL)
@@ -473,7 +479,7 @@
 INSERT INTO REVERSEDOMAINS VALUES('jm','Jamaica',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('jp','Japan',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('jo','Jordan',NULL)
-INSERT INTO REVERSEDOMAINS VALUES('kz','Kazakstan',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('kz','Kazakhstan',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ke','Kenya',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ki','Kiribati',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('kp','North Korea',NULL)
@@ -489,7 +495,7 @@
 INSERT INTO REVERSEDOMAINS VALUES('li','Liechtenstein',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('lt','Lithuania',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('lu','Luxembourg',NULL)
-INSERT INTO REVERSEDOMAINS VALUES('mo','Macau',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('mo','Macao',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('mk','Macedonia',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('mg','Madagascar',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('mw','Malawi',NULL)
@@ -526,7 +532,7 @@
 INSERT INTO REVERSEDOMAINS VALUES('mp','Northern Mariana Islands',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('no','Norway',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('om','Oman',NULL)
-INSERT INTO REVERSEDOMAINS VALUES('pk','PakistaN',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('pk','Pakistan',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('pw','Palau',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ps','Palestinian Territory',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('pa','Panama',NULL)
@@ -553,6 +559,7 @@
 INSERT INTO REVERSEDOMAINS VALUES('st','Sao Tome And Principe',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('sa','Saudi Arabia',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('sn','Senegal',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('cs','Serbia And Montenegro',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('sc','Seychelles',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('sl','Sierra Leone',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('sg','Singapore',NULL)
@@ -575,6 +582,7 @@
 INSERT INTO REVERSEDOMAINS VALUES('tj','Tajikistan',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('tz','Tanzania',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('th','Thailand',NULL)
+INSERT INTO REVERSEDOMAINS VALUES('tl','Timor-Leste',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('tg','Togo',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('tk','Tokelau',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('to','Tonga',NULL)
@@ -599,7 +607,6 @@
 INSERT INTO REVERSEDOMAINS VALUES('wf','Wallis And Futuna',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('eh','Western Sahara',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('ye','Yemen',NULL)
-INSERT INTO REVERSEDOMAINS VALUES('yu','Yugoslavia',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('zm','Zambia',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('zw','Zimbabwe',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('com','Commercial Company',NULL)
@@ -617,9 +624,6 @@
 INSERT INTO REVERSEDOMAINS VALUES('mil','US Military',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('int','International Treaty Organization',NULL)
 INSERT INTO REVERSEDOMAINS VALUES('uk','United Kingdom',NULL)
-INSERT INTO USERSTABLE VALUES(1,'Anonymous',NULL,'none',1,'D','N','2004-03-05 20:05:40.0','2004-03-05 20:05:40.0',NULL,'Anonymous User')
-INSERT INTO USERSTABLE VALUES(2,'NONE',NULL,'none',1,'D','N','2004-03-05 20:05:40.0','2004-03-05 20:05:40.0',NULL,'Default user before login')
-INSERT INTO USERSTABLE VALUES(3,'Admin',NULL,'none',1,'A','N','2004-03-05 20:05:40.0','2004-03-05 20:05:40.0',NULL,'Administrative User')
 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','*')
@@ -657,7 +661,7 @@
 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)
@@ -665,6 +669,7 @@
 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)
@@ -674,13 +679,13 @@
 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.SingleDBUserInfo',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)
@@ -690,6 +695,7 @@
 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)
@@ -700,13 +706,18 @@
 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 DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AuditLog',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.ext.dbobj.AuditLogL',50,50,10)
-INSERT INTO DBOBJLIMIT VALUES('com.jcorporate.expresso.services.dbobj.ChangeLog',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')
@@ -751,10 +762,6 @@
 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.SingleDBUserInfo','Admin','A')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.SingleDBUserInfo','Admin','U')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.SingleDBUserInfo','Admin','S')
-INSERT INTO DBOBJSECURITY VALUES('com.jcorporate.expresso.ext.dbobj.SingleDBUserInfo','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')
@@ -779,6 +786,10 @@
 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')
@@ -899,18 +910,9 @@
 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 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.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 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')
@@ -926,13 +928,7 @@
 INSERT INTO GROUPMEMBERS VALUES('Everybody',NULL,1)
 INSERT INTO GROUPMEMBERS VALUES('Nobody',NULL,2)
 INSERT INTO GROUPMEMBERS VALUES('Admin',NULL,3)
-INSERT INTO JOBHANDLERREGISTRY VALUES(1,1,'2004-09-21 23:19:53.0','Enabled',1.0,24548,12143,12405,1,'tdesktop','Linux',NULL)
-INSERT INTO JOBQUEUE VALUES(1,3,'2004-03-05 20:05:46.0','com.jcorporate.expresso.services.job.ClearOldValidation','R',3,1,'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 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')
@@ -1055,10 +1051,10 @@
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','TimerInterval','Scan Job Queue and directories how often?','30')
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','defaultCSS','Default CSS Extension',NULL)
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','defaultRegDomain','Default Registration Domain','default')
-INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','enableGlobalExceptions','Allow all Expresso Controllers to pass unhandled exception to  GlobalExceptions','N')
+INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','enableGlobalExceptions','Allow all Expresso Controllers to pass unhandled exception to GlobalExceptions a','N')
 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','privacyPolicy','URL To Website Privacy Policy',NULL)
 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)
@@ -1071,6 +1067,3 @@
 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 AUDITLOG_L VALUES('ADD','ADD')
-INSERT INTO AUDITLOG_L VALUES('DEL','DELETE')
-INSERT INTO AUDITLOG_L VALUES('UPT','UPDATE')
Index: default.properties
===================================================================
RCS file: /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/db/default/default.properties,v
retrieving revision 1.25
retrieving revision 1.26
diff -Lexpresso-web/WEB-INF/db/default/default.properties -Lexpresso-web/WEB-INF/db/default/default.properties -u -r1.25 -r1.26
--- expresso-web/WEB-INF/db/default/default.properties
+++ expresso-web/WEB-INF/db/default/default.properties
@@ -1,4 +1,4 @@
 #HSQL database
-#Tue Sep 21 23:20:14 EDT 2004
+#Tue Nov 09 17:21:47 EST 2004
 version=1.6
 modified=no

More information about the cvs mailing list