jive.script

jive的源码

CREATE TABLE JIVEFORUM(FORUMID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(4000),MODDEFAULTTHREADVAL INTEGER NOT NULL,MODMINTHREADVAL INTEGER NOT NULL,MODDEFAULTMSGVAL INTEGER NOT NULL,MODMINMSGVAL INTEGER NOT NULL,CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL,CATEGORYID BIGINT NOT NULL,CATEGORYINDEX INTEGER NOT NULL)
CREATE INDEX JIVEFORUM_CAT_IDX ON JIVEFORUM(CATEGORYID)
CREATE TABLE JIVEFORUMPROP(FORUMID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEFORUMPROP_PK PRIMARY KEY(FORUMID,NAME))
CREATE TABLE JIVETHREAD(THREADID BIGINT NOT NULL PRIMARY KEY,FORUMID BIGINT NOT NULL,ROOTMESSAGEID BIGINT NOT NULL,MODVALUE INTEGER NOT NULL,REWARDPOINTS INTEGER NOT NULL,CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL)
CREATE INDEX JIVETHREAD_FORUMID_IDX ON JIVETHREAD(FORUMID)
CREATE INDEX JIVETHREAD_MODVALUE_IDX ON JIVETHREAD(MODVALUE)
CREATE INDEX JIVETHREAD_CDATE_IDX ON JIVETHREAD(CREATIONDATE)
CREATE INDEX JIVETHREAD_MDATE_IDX ON JIVETHREAD(MODIFICATIONDATE)
CREATE TABLE JIVETHREADPROP(THREADID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVETHREADPROP_PK PRIMARY KEY(THREADID,NAME))
CREATE TABLE JIVEMESSAGE(MESSAGEID BIGINT NOT NULL PRIMARY KEY,PARENTMESSAGEID BIGINT,THREADID BIGINT NOT NULL,FORUMID BIGINT NOT NULL,USERID BIGINT,SUBJECT VARCHAR(255),BODY LONGVARCHAR,MODVALUE INTEGER NOT NULL,REWARDPOINTS INTEGER NOT NULL,CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL)
CREATE INDEX JIVEMESSAGE_THREADID_IDX ON JIVEMESSAGE(THREADID)
CREATE INDEX JIVEMESSAGE_USERID_IDX ON JIVEMESSAGE(USERID)
CREATE INDEX JIVEMESSAGE_FORUMID_MODVAL_IDX ON JIVEMESSAGE(FORUMID,MODVALUE)
CREATE INDEX JIVEMESSAGE_CDATE_IDX ON JIVEMESSAGE(CREATIONDATE)
CREATE INDEX JIVEMESSAGE_MDATE_IDX ON JIVEMESSAGE(MODIFICATIONDATE)
CREATE TABLE JIVEMESSAGEPROP(MESSAGEID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEMESSAGEPROP_PK PRIMARY KEY(MESSAGEID,NAME))
CREATE TABLE JIVEUSER(USERID BIGINT NOT NULL PRIMARY KEY,USERNAME VARCHAR(30) NOT NULL,PASSWORDHASH VARCHAR(32) NOT NULL,NAME VARCHAR(100),NAMEVISIBLE INTEGER NOT NULL,EMAIL VARCHAR(100) NOT NULL,EMAILVISIBLE INTEGER NOT NULL,CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL)
CREATE INDEX JIVEUSER_CDATE_IDX ON JIVEUSER(CREATIONDATE)
CREATE TABLE JIVEUSERPERM(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,USERID BIGINT NOT NULL,PERMISSION INTEGER NOT NULL)
CREATE INDEX JIVEUSERPERM_OBJECT_IDX ON JIVEUSERPERM(OBJECTTYPE,OBJECTID)
CREATE INDEX JIVEUSERPERM_USERID_IDX ON JIVEUSERPERM(USERID)
CREATE TABLE JIVEUSERPROP(USERID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEUSERPROP_PK PRIMARY KEY(USERID,NAME))
CREATE TABLE JIVEGROUP(GROUPID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL)
CREATE INDEX JIVEGROUP_CDATE_IDX ON JIVEGROUP(CREATIONDATE)
CREATE TABLE JIVEGROUPPERM(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,PERMISSION INTEGER NOT NULL)
CREATE INDEX JIVEGROUPPERM_OBJECT_IDX ON JIVEGROUPPERM(OBJECTTYPE,OBJECTID)
CREATE INDEX JIVEGROUPPERM_GROUPID_IDX ON JIVEGROUPPERM(GROUPID)
CREATE TABLE JIVEGROUPPROP(GROUPID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEGROUPPROP_PK PRIMARY KEY(GROUPID,NAME))
CREATE TABLE JIVEGROUPUSER(GROUPID BIGINT NOT NULL,USERID BIGINT NOT NULL,ADMINISTRATOR INTEGER NOT NULL,CONSTRAINT JIVEGROUPUSER_PK PRIMARY KEY(GROUPID,USERID,ADMINISTRATOR))
CREATE INDEX JIVEGROUPUSER_USERID_IDX ON JIVEGROUPUSER(USERID)
CREATE TABLE JIVEID(IDTYPE BIGINT NOT NULL PRIMARY KEY,ID BIGINT NOT NULL)
CREATE TABLE JIVEMODERATION(OBJECTID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,USERID BIGINT,MODDATE VARCHAR(15) NOT NULL,MODVALUE INTEGER NOT NULL)
CREATE INDEX JIVEMODERATION_OBJECTID_IDX ON JIVEMODERATION(OBJECTID)
CREATE INDEX JIVEMODERATION_OBJECTTYPE_IDX ON JIVEMODERATION(OBJECTTYPE)
CREATE INDEX JIVEMODERATION_USERID_IDX ON JIVEMODERATION(USERID)
CREATE TABLE JIVEWATCH(USERID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,WATCHTYPE INTEGER NOT NULL,EXPIRABLE INTEGER NOT NULL)
CREATE INDEX JIVEWATCH_USERID_IDX ON JIVEWATCH(USERID)
CREATE INDEX JIVEWATCH_OBJECTID_IDX ON JIVEWATCH(OBJECTID)
CREATE INDEX JIVEWATCH_OBJECTTYPE_IDX ON JIVEWATCH(OBJECTTYPE)
CREATE TABLE JIVEREWARD(USERID BIGINT NOT NULL,CREATIONDATE VARCHAR(15) NOT NULL,REWARDPOINTS INTEGER NOT NULL,MESSAGEID BIGINT,THREADID BIGINT)
CREATE INDEX JIVEREWARD_USERID_IDX ON JIVEREWARD(USERID)
CREATE INDEX JIVEREWARD_CREATIONDATE_IDX ON JIVEREWARD(CREATIONDATE)
CREATE INDEX JIVEREWARD_MESSAGEID_IDX ON JIVEREWARD(MESSAGEID)
CREATE INDEX JIVEREWARD_THREADID_IDX ON JIVEREWARD(THREADID)
CREATE TABLE JIVEUSERREWARD(USERID BIGINT NOT NULL,REWARDPOINTS INTEGER NOT NULL,CONSTRAINT JIVEUSERREWARD_PK PRIMARY KEY(USERID,REWARDPOINTS))
CREATE TABLE JIVEATTACHMENT(ATTACHMENTID BIGINT NOT NULL PRIMARY KEY,MESSAGEID BIGINT NOT NULL,FILENAME VARCHAR(255) NOT NULL,FILESIZE INTEGER NOT NULL,CONTENTTYPE VARCHAR(50) NOT NULL,CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL)
CREATE INDEX JIVEATTACHMENT_MESSAGEID_IDX ON JIVEATTACHMENT(MESSAGEID)
CREATE TABLE JIVEATTACHMENTPROP(ATTACHMENTID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEATTACHMENTPROP_PK PRIMARY KEY(ATTACHMENTID,NAME))
CREATE TABLE JIVECATEGORY(CATEGORYID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(4000),CREATIONDATE VARCHAR(15) NOT NULL,MODIFICATIONDATE VARCHAR(15) NOT NULL,LFT INTEGER NOT NULL,RGT INTEGER NOT NULL)
CREATE INDEX JIVECATEGORY_LFT_IDX ON JIVECATEGORY(LFT)
CREATE INDEX JIVECATEGORY_RGT_IDX ON JIVECATEGORY(RGT)
CREATE TABLE JIVECATEGORYPROP(CATEGORYID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVECATEGORYPROP_PK PRIMARY KEY(CATEGORYID,NAME))
CREATE TABLE JIVEUSERROSTER(USERID BIGINT NOT NULL,SUBUSERID BIGINT NOT NULL,CONSTRAINT SYS_PK_JIVEUSERROSTER PRIMARY KEY(USERID,SUBUSERID))
CREATE TABLE JIVEREADTRACKER(USERID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,READDATE VARCHAR(15) NOT NULL,CONSTRAINT SYS_PK_JIVEREADTRACKER PRIMARY KEY(USERID,OBJECTTYPE,OBJECTID))
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
CREATE USER SA PASSWORD jiverocks ADMIN
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
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 DATABASE FOR "org.hsqldb.Library.database"
CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
CREATE ALIAS USER FOR "org.hsqldb.Library.user"
CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
CREATE ALIAS RAND FOR "java.lang.Math.random"
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 JIVEUSER VALUES(1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrator',1,'[e-mail]',1,'0','0')
INSERT INTO JIVEUSERPERM VALUES(17,-1,1,59)
INSERT INTO JIVEUSERPERM VALUES(17,-1,-1,0)
INSERT INTO JIVEUSERPERM VALUES(17,-1,0,1)
INSERT INTO JIVEUSERPERM VALUES(17,-1,0,2)
INSERT INTO JIVEID VALUES(0,1)
INSERT INTO JIVEID VALUES(1,1)
INSERT INTO JIVEID VALUES(2,1)
INSERT INTO JIVEID VALUES(3,2)
INSERT INTO JIVEID VALUES(4,1)
INSERT INTO JIVEID VALUES(13,1)
INSERT INTO JIVEID VALUES(14,2)
INSERT INTO JIVECATEGORY VALUES(1,'root',' ','0','0',1,2)