[cvs] expresso commit by mtraum: regenerate database to include new MAILPort

[JCorporate Ltd]

Log Message:
-----------
regenerate database to include new MAILPort setup value

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.35
retrieving revision 1.36
diff -Lexpresso-web/WEB-INF/db/default/default.script -Lexpresso-web/WEB-INF/db/default/default.script -u -r1.35 -r1.36
--- expresso-web/WEB-INF/db/default/default.script
+++ expresso-web/WEB-INF/db/default/default.script
@@ -57,8 +57,8 @@
 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 LONGVARCHAR,PARAMCODE VARCHAR,UNIQUE(VALID,PARAMNUM))
-GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
 GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
+GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
 CREATE USER SA PASSWORD "" ADMIN
 CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
 CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
@@ -910,9 +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 USERSTABLE VALUES(1,'Anonymous',NULL,'none',1,'D','N','2005-04-12 00:28:14.0','2005-04-12 00:28:14.0',NULL,'Anonymous User')
-INSERT INTO USERSTABLE VALUES(2,'NONE',NULL,'none',1,'D','N','2005-04-12 00:28:14.0','2005-04-12 00:28:14.0',NULL,'Default user before login')
-INSERT INTO USERSTABLE VALUES(3,'Admin',NULL,'none',1,'A','N','2005-04-12 00:28:14.0','2005-04-12 00:28:14.0',NULL,'Administrative User')
+INSERT INTO USERSTABLE VALUES(1,'Anonymous',NULL,'none',1,'D','N','2005-07-05 10:39:58.0','2005-07-05 10:39:58.0',NULL,'Anonymous User')
+INSERT INTO USERSTABLE VALUES(2,'NONE',NULL,'none',1,'D','N','2005-07-05 10:39:58.0','2005-07-05 10:39:58.0',NULL,'Default user before login')
+INSERT INTO USERSTABLE VALUES(3,'Admin',NULL,'none',1,'A','N','2005-07-05 10:39:58.0','2005-07-05 10:39:58.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')
@@ -928,7 +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 JOBQUEUE VALUES(1,3,'2005-04-12 00:28:21.0','com.jcorporate.expresso.services.job.ClearOldValidation','A',3,0,'any','0,0,-1,-1,7,-1')
+INSERT INTO JOBQUEUE VALUES(1,3,'2005-07-05 10:40:05.0','com.jcorporate.expresso.services.job.ClearOldValidation','A',3,0,'any','0,0,-1,-1,7,-1')
 INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.ext.job.SendNotice','Admin','*')
 INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ClearOldValidation','Admin','*')
 INSERT INTO JOBSECURITY VALUES('com.jcorporate.expresso.services.job.ControllerJob','Admin','*')
@@ -1041,6 +1041,7 @@
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','HomePageURL','Home Page URL',NULL)
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','MAILFrom','Value for From field in Event E-Mails',NULL)
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','MAILPassword','Password for sending e-mail (if required)',NULL)
+INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','MAILPort','SMTP Server Port for sending E-Mails','25')
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','MAILServer','SMTP Server Name for sending E-Mails',NULL)
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','MAILUserName','User Name for sending e-mail (if required)',NULL)
 INSERT INTO SETUP VALUES('com.jcorporate.expresso.core.ExpressoSchema','MailList','Mailing List Address','opensource at servlets.net')
Index: default.properties
===================================================================
RCS file: /home/javacorp/.cvs/expresso/expresso/expresso-web/WEB-INF/db/default/default.properties,v
retrieving revision 1.30
retrieving revision 1.31
diff -Lexpresso-web/WEB-INF/db/default/default.properties -Lexpresso-web/WEB-INF/db/default/default.properties -u -r1.30 -r1.31
--- expresso-web/WEB-INF/db/default/default.properties
+++ expresso-web/WEB-INF/db/default/default.properties
@@ -1,4 +1,4 @@
 #HSQL database
-#Tue Apr 12 00:28:38 EDT 2005
+#Tue Jul 05 10:40:39 EDT 2005
 version=1.6
 modified=no