CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE JIVECATEGORY(CATEGORYID BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(4000),CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,LFT INTEGER NOT NULL,RGT INTEGER NOT NULL,LOCALECODE VARCHAR(32),CONSTRAINT JIVECATEGORY_PK PRIMARY KEY(CATEGORYID))
CREATE INDEX JIVECAT_LFT_IDX ON JIVECATEGORY(LFT)
CREATE INDEX JIVECAT_RGT_IDX ON JIVECATEGORY(RGT)
CREATE MEMORY TABLE JIVECATEGORYPROP(CATEGORYID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVECATPROP_PK PRIMARY KEY(CATEGORYID,NAME))
CREATE MEMORY TABLE JIVEFORUM(FORUMID BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,NNTPNAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(4000),MODDEFAULTTHREADVAL INTEGER NOT NULL,MODDEFAULTMSGVAL INTEGER NOT NULL,CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,CATEGORYID BIGINT NOT NULL,CATEGORYINDEX INTEGER NOT NULL,FORUMINDEXCOUNTER INTEGER NOT NULL,LOCALECODE VARCHAR(32),CONSTRAINT JIVEFORUM_PK PRIMARY KEY(FORUMID))
CREATE INDEX JIVEFORUM_CAT_IDX ON JIVEFORUM(CATEGORYID)
CREATE INDEX JIVEFORUM_FORUMIDXCTR_IDX ON JIVEFORUM(FORUMINDEXCOUNTER)
CREATE UNIQUE INDEX JIVEFORUM_NNTPNAME_IDX ON JIVEFORUM(NNTPNAME)
CREATE MEMORY TABLE JIVEFORUMPROP(FORUMID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEFORUMPROP_PK PRIMARY KEY(FORUMID,NAME))
CREATE MEMORY TABLE JIVETHREAD(THREADID BIGINT NOT NULL,FORUMID BIGINT NOT NULL,ROOTMESSAGEID BIGINT NOT NULL,MODVALUE INTEGER NOT NULL,REWARDPOINTS INTEGER NOT NULL,CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,CONSTRAINT JIVETHREAD_PK PRIMARY KEY(THREADID))
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 INDEX JIVETHREAD_FORUMID_MODVAL_IDX ON JIVETHREAD(FORUMID,MODVALUE)
CREATE UNIQUE INDEX JIVETHREAD_THD_FRM_IDX ON JIVETHREAD(THREADID, FORUMID);
CREATE MEMORY TABLE JIVETHREADPROP(THREADID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVETHREADPROP_PK PRIMARY KEY(THREADID,NAME))
CREATE MEMORY TABLE JIVEMESSAGE(MESSAGEID BIGINT NOT NULL,PARENTMESSAGEID BIGINT,THREADID BIGINT NOT NULL,FORUMID BIGINT NOT NULL,FORUMINDEX INTEGER NOT NULL,USERID BIGINT,SUBJECT VARCHAR(255),BODY LONGVARCHAR,MODVALUE INTEGER NOT NULL,REWARDPOINTS INTEGER NOT NULL,CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,CONSTRAINT JIVEMESSAGE_PK PRIMARY KEY(MESSAGEID))
CREATE INDEX JIVEMESSAGE_FORUM_IDX ON JIVEMESSAGE(FORUMID,FORUMINDEX)
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 INDEX JIVEMESSAGE_PARENTID_IDX ON JIVEMESSAGE(PARENTMESSAGEID)
CREATE UNIQUE INDEX JIVEMESSAGE_MSG_THD_IDX ON JIVEMESSAGE (MESSAGEID, THREADID);
CREATE MEMORY TABLE JIVEMESSAGEPROP(MESSAGEID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEMSGPROP_PK PRIMARY KEY(MESSAGEID,NAME))
CREATE MEMORY TABLE JIVEANNOUNCE(ANNOUNCEMENTID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT,USERID BIGINT NOT NULL,SUBJECT VARCHAR(255) NOT NULL,BODY LONGVARCHAR NOT NULL,STARTDATE BIGINT NOT NULL,ENDDATE BIGINT,CONSTRAINT JIVEANNOUNCE_PK PRIMARY KEY(ANNOUNCEMENTID))
CREATE INDEX JIVEANN_SD_IDX ON JIVEANNOUNCE(STARTDATE)
CREATE INDEX JIVEANN_ED_IDX ON JIVEANNOUNCE(ENDDATE)
CREATE INDEX JIVEANN_CNTR_IDX ON JIVEANNOUNCE(OBJECTTYPE,OBJECTID)
CREATE INDEX JIVEANN_U_IDX ON JIVEANNOUNCE(USERID)
CREATE MEMORY TABLE JIVEANNOUNCEPROP(ANNOUNCEMENTID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEANNPROP_PK PRIMARY KEY(ANNOUNCEMENTID,NAME))
CREATE MEMORY TABLE JIVEPMESSAGE(PMESSAGEID BIGINT NOT NULL,OWNERID BIGINT NOT NULL,SENDERID BIGINT,RECIPIENTID BIGINT,SUBJECT VARCHAR(255),BODY LONGVARCHAR,READSTATUS INTEGER NOT NULL,FOLDERID INTEGER NOT NULL,PMESSAGEDATE BIGINT NOT NULL,CONSTRAINT JIVEPMSG_PMID_PK PRIMARY KEY(PMESSAGEID))
CREATE INDEX JIVEPMSG_RID_IDX ON JIVEPMESSAGE(RECIPIENTID)
CREATE MEMORY TABLE JIVEPMESSAGEPROP(PMESSAGEID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEPMP_PMID_NIDX PRIMARY KEY(PMESSAGEID,NAME))
CREATE MEMORY TABLE JIVEPMESSAGEFLDR(FOLDERID INTEGER NOT NULL,USERID BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,CONSTRAINT JIVEPF_PK PRIMARY KEY(FOLDERID,USERID))
CREATE MEMORY TABLE JIVEUSER(USERID BIGINT NOT NULL,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 BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,CONSTRAINT JIVEUSER_PK PRIMARY KEY(USERID))
CREATE INDEX JIVEUSER_CD_IDX ON JIVEUSER(CREATIONDATE)
CREATE INDEX JIVEUSER_HASH_IDX ON JIVEUSER(PASSWORDHASH)
CREATE INDEX JIVEUSER_UN_IDX ON JIVEUSER(USERNAME)
CREATE MEMORY TABLE JIVEUSERPERM(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,USERID BIGINT NOT NULL,PERMISSIONTYPE INTEGER NOT NULL,PERMISSION INTEGER NOT NULL)
CREATE INDEX JIVEUSRPERM_OIDX ON JIVEUSERPERM(OBJECTTYPE,OBJECTID)
CREATE INDEX JIVEUSRP_UID_IDX ON JIVEUSERPERM(USERID)
CREATE MEMORY TABLE JIVEUSERPROP(USERID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEUSERPROP_PK PRIMARY KEY(USERID,NAME))
CREATE MEMORY TABLE JIVEGROUP(GROUPID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,CONSTRAINT JIVEGROUP_PK PRIMARY KEY(GROUPID))
CREATE INDEX JIVEGROUP_CD_IDX ON JIVEGROUP(CREATIONDATE)
CREATE MEMORY TABLE JIVEGROUPPERM(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,GROUPID BIGINT NOT NULL,PERMISSIONTYPE INTEGER NOT NULL,PERMISSION INTEGER NOT NULL)
CREATE INDEX JIVEGP_O_IDX ON JIVEGROUPPERM(OBJECTTYPE,OBJECTID)
CREATE INDEX JIVEGP_GID_IDX ON JIVEGROUPPERM(GROUPID)
CREATE MEMORY TABLE JIVEGROUPPROP(GROUPID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEGROUPPROP_PK PRIMARY KEY(GROUPID,NAME))
CREATE MEMORY TABLE JIVEGROUPUSER(GROUPID BIGINT NOT NULL,USERID BIGINT NOT NULL,ADMINISTRATOR INTEGER NOT NULL,CONSTRAINT JIVEGROUPUSER_PK PRIMARY KEY(GROUPID,USERID,ADMINISTRATOR))
CREATE INDEX JIVEGU_UID_IDX ON JIVEGROUPUSER(USERID)
CREATE MEMORY TABLE JIVEID(IDTYPE INTEGER NOT NULL,ID BIGINT NOT NULL,CONSTRAINT JIVEID_PK PRIMARY KEY(IDTYPE))
CREATE MEMORY TABLE JIVEPROPERTY(NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEPROPERTY_PK PRIMARY KEY(NAME))
CREATE MEMORY TABLE JIVEMODERATION(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,USERID BIGINT,MODDATE BIGINT NOT NULL,MODVALUE INTEGER NOT NULL)
CREATE INDEX JIVEMOD_OID_IDX ON JIVEMODERATION(OBJECTID)
CREATE INDEX JIVEMOD_OT_IDX ON JIVEMODERATION(OBJECTTYPE)
CREATE INDEX JIVEMOD_UID_IDX ON JIVEMODERATION(USERID)
CREATE MEMORY TABLE JIVEWATCH(USERID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,WATCHTYPE INTEGER NOT NULL,EXPIRABLE INTEGER NOT NULL,CONSTRAINT JIVEWATCH_PK PRIMARY KEY(USERID,OBJECTID,OBJECTTYPE,WATCHTYPE))
CREATE INDEX JIVEWATCH_UID_IDX ON JIVEWATCH(USERID)
CREATE INDEX JIVEWCH_OID_IDX ON JIVEWATCH(OBJECTID)
CREATE INDEX JIVEW_OTYPE_IDX ON JIVEWATCH(OBJECTTYPE)
CREATE INDEX JIVEWATCH_ALL_IDX ON JIVEWATCH(OBJECTTYPE,OBJECTID,WATCHTYPE)
CREATE MEMORY TABLE JIVEREWARD(USERID BIGINT NOT NULL,CREATIONDATE BIGINT NOT NULL,REWARDPOINTS INTEGER NOT NULL,MESSAGEID BIGINT,THREADID BIGINT)
CREATE INDEX JIVEREWARD_UID_IDX ON JIVEREWARD(USERID)
CREATE INDEX JIVER_CD_IDX ON JIVEREWARD(CREATIONDATE)
CREATE INDEX JIVER_MSGID_IDX ON JIVEREWARD(MESSAGEID)
CREATE INDEX JIVERWD_TID_IDX ON JIVEREWARD(THREADID)
CREATE MEMORY TABLE JIVEUSERREWARD(USERID BIGINT NOT NULL,REWARDPOINTS INTEGER NOT NULL,CONSTRAINT JIVEUSERREWARD_PK PRIMARY KEY(USERID))
CREATE MEMORY TABLE JIVEATTACHMENT(ATTACHMENTID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT,FILENAME VARCHAR(255) NOT NULL,FILESIZE INTEGER NOT NULL,CONTENTTYPE VARCHAR(100) NOT NULL,CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,CONSTRAINT JIVEATTACHMENT_PK PRIMARY KEY(ATTACHMENTID))
CREATE INDEX JIVEATTACHMENT_OBJECTID_IDX ON JIVEATTACHMENT(OBJECTTYPE,OBJECTID)
CREATE MEMORY TABLE JIVEATTACHDATA(ATTACHMENTID BIGINT NOT NULL,ATTACHMENTDATA LONGVARBINARY NOT NULL,CONSTRAINT JIVEATTACHDATA_PK PRIMARY KEY(ATTACHMENTID))
CREATE MEMORY TABLE JIVEATTACHMENTPROP(ATTACHMENTID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEATTPROP_PK PRIMARY KEY(ATTACHMENTID,NAME))
CREATE MEMORY TABLE JIVEUSERROSTER(USERID BIGINT NOT NULL,SUBUSERID BIGINT NOT NULL,CONSTRAINT JIVEUSERROSTER_PK PRIMARY KEY(USERID,SUBUSERID))
CREATE MEMORY TABLE JIVEREADTRACKER(USERID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,READDATE BIGINT NOT NULL,CONSTRAINT JIVERT_PK PRIMARY KEY(USERID,OBJECTTYPE,OBJECTID))
CREATE MEMORY TABLE JIVERATINGTYPE(SCORE INTEGER NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,CONSTRAINT JIVERATINGTYPE_PK PRIMARY KEY(SCORE))
CREATE MEMORY TABLE JIVERATING(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,USERID BIGINT,SCORE INTEGER NOT NULL)
CREATE INDEX JIVERATE_UID_IDX ON JIVERATING(USERID)
CREATE INDEX JIVER_OID_OT_IDX ON JIVERATING(OBJECTID,OBJECTTYPE)
CREATE MEMORY TABLE JIVEPOLL(POLLID BIGINT NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,USERID BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(4000),POLLMODE INTEGER NOT NULL,CREATIONDATE BIGINT NOT NULL,MODIFICATIONDATE BIGINT NOT NULL,STARTDATE BIGINT NOT NULL,ENDDATE BIGINT NOT NULL,EXPIREDATE BIGINT NOT NULL,CONSTRAINT JIVEPOLL_PK PRIMARY KEY(POLLID))
CREATE INDEX JIVEP_OID_OT_IDX ON JIVEPOLL(OBJECTID,OBJECTTYPE)
CREATE INDEX JIVEPOLL_CD_IDX ON JIVEPOLL(CREATIONDATE)
CREATE INDEX JIVEPOLL_MD_IDX ON JIVEPOLL(MODIFICATIONDATE)
CREATE INDEX JIVEPOLL_SD_IDX ON JIVEPOLL(STARTDATE)
CREATE INDEX JIVEPOLL_ED_IDX ON JIVEPOLL(ENDDATE)
CREATE MEMORY TABLE JIVEPOLLOPTION(POLLID BIGINT NOT NULL,OPTIONINDEX INTEGER NOT NULL,OPTIONTEXT VARCHAR(255) NOT NULL,CONSTRAINT JIVEPOLLOPTION_PK PRIMARY KEY(POLLID,OPTIONINDEX))
CREATE MEMORY TABLE JIVEPOLLVOTE(POLLID BIGINT NOT NULL,USERID BIGINT,GUESTID VARCHAR(255),OPTIONINDEX INTEGER NOT NULL,VOTEDATE BIGINT NOT NULL)
CREATE INDEX JIVEPV_PID_IDX ON JIVEPOLLVOTE(POLLID)
CREATE MEMORY TABLE JIVESEARCH(SEARCHID BIGINT NOT NULL,SEARCHTYPE INTEGER NOT NULL,USERID BIGINT,QUERY VARCHAR(1000) NOT NULL,SEARCHDURATION INTEGER NOT NULL,NUMRESULTS INTEGER NOT NULL,SEARCHDATE BIGINT NOT NULL,CONSTRAINT JIVESEARCH_PK PRIMARY KEY(SEARCHID))
CREATE INDEX JIVESRCH_UID_IDX ON JIVESEARCH(USERID)
CREATE INDEX JIVESRCH_TYPE_IDX ON JIVESEARCH(SEARCHTYPE)
CREATE MEMORY TABLE JIVESEARCHCRITERIA(SEARCHID BIGINT NOT NULL,CRITERIANAME VARCHAR(100) NOT NULL,CRITERIAVALUE VARCHAR(4000) NOT NULL)
CREATE INDEX JIVESRCHCR_SID_IDX ON JIVESEARCHCRITERIA(SEARCHID)
CREATE MEMORY TABLE JIVESEARCHCLICK(SEARCHID BIGINT NOT NULL,MESSAGEID BIGINT NOT NULL,CLICKDATE BIGINT NOT NULL,CONSTRAINT JIVESEARCHCLK_PK PRIMARY KEY(SEARCHID,MESSAGEID,CLICKDATE))
CREATE MEMORY TABLE JIVEVIEWCOUNT(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,PARENTOBJECTID BIGINT,VIEWCOUNT INTEGER DEFAULT 0,CONSTRAINT JIVEVIEWCOUNT_PK PRIMARY KEY(OBJECTTYPE,OBJECTID))
CREATE INDEX JIVEVC_VC_IDX ON JIVEVIEWCOUNT(VIEWCOUNT)
CREATE INDEX JIVEVC_PO_IDX ON JIVEVIEWCOUNT(PARENTOBJECTID)
CREATE MEMORY TABLE JIVEREADSTAT(READSTATID BIGINT NOT NULL,USERID BIGINT,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,CREATIONDATE BIGINT NOT NULL,SESSIONID BIGINT NOT NULL,CONSTRAINT JIVEREADSTAT_PK PRIMARY KEY(READSTATID))
CREATE INDEX JIVERS_CD_IDX ON JIVEREADSTAT(CREATIONDATE)
CREATE INDEX JIVERS_UID_IDX ON JIVEREADSTAT(USERID)
CREATE INDEX JIVERS_OT_IDX ON JIVEREADSTAT(OBJECTTYPE)
CREATE INDEX JIVERS_OID_IDX ON JIVEREADSTAT(OBJECTID)
CREATE INDEX JIVERS_SESSID_IDX ON JIVEREADSTAT(SESSIONID)
CREATE MEMORY TABLE JIVEREADSTATSESSION(SESSIONID BIGINT NOT NULL,VISITORID VARCHAR(32),CREATIONDATE BIGINT NOT NULL,CONSTRAINT JIVERSS_PK PRIMARY KEY(SESSIONID))
CREATE INDEX JIVERSS_CD_IDX ON JIVEREADSTATSESSION(CREATIONDATE)
CREATE MEMORY TABLE JIVEHTTPREADSTATSESSION(REFERRER VARCHAR(255),USERAGENT VARCHAR(255),IP VARCHAR(16),COUNTRY VARCHAR(4),BYTESSENT INTEGER DEFAULT 0,SESSIONID BIGINT NOT NULL)
CREATE INDEX JIVEHRSS_SID_IDX ON JIVEHTTPREADSTATSESSION(SESSIONID)
CREATE INDEX JIVEHRSS_BS_IDX ON JIVEHTTPREADSTATSESSION(BYTESSENT)
CREATE INDEX JIVEHRSS_IP_IDX ON JIVEHTTPREADSTATSESSION(IP)
CREATE INDEX JIVEHRSS_C_IDX ON JIVEHTTPREADSTATSESSION(COUNTRY)
CREATE MEMORY TABLE JIVENNTPREADSTATSESSION(CREATIONDATE BIGINT NOT NULL,ENDDATE BIGINT,BYTESRECEIVED INTEGER DEFAULT 0,BYTESSENT INTEGER DEFAULT 0,IP VARCHAR(16),COUNTRY VARCHAR(4),SESSIONID BIGINT NOT NULL)
CREATE INDEX JIVENRSS_CD_IDX ON JIVENNTPREADSTATSESSION(CREATIONDATE)
CREATE INDEX JIVENRSS_ED_IDX ON JIVENNTPREADSTATSESSION(ENDDATE)
CREATE INDEX JIVENRSS_IP_IDX ON JIVENNTPREADSTATSESSION(IP)
CREATE INDEX JIVENRSS_C_IDX ON JIVENNTPREADSTATSESSION(COUNTRY)
CREATE MEMORY TABLE JIVESTATUSLEVEL(STATUSLEVELID BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(2000),IMAGEPATH VARCHAR(255) NOT NULL,LARGEIMAGEPATH VARCHAR(255),MINPOINTS INTEGER NOT NULL,MAXPOINTS INTEGER NOT NULL,GROUPID BIGINT NOT NULL,CONSTRAINT JIVESTATLVL_PK PRIMARY KEY(STATUSLEVELID),CONSTRAINT JIVESTATUSLEVEL_NAME_UNQ UNIQUE(NAME))
CREATE MEMORY TABLE JIVESTATUSLEVELPROP(STATUSLEVELID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(2000) NOT NULL,CONSTRAINT JIVESTATLVLPROP_PK PRIMARY KEY(STATUSLEVELID,NAME))
CREATE MEMORY TABLE JIVEAVATAR(AVATARID BIGINT NOT NULL,MODVALUE INTEGER NOT NULL,OWNERID INTEGER,CONSTRAINT JIVEAVATAR_PK PRIMARY KEY(AVATARID))
CREATE INDEX JIVEAV_OID_IDX ON JIVEAVATAR(OWNERID)
CREATE MEMORY TABLE JIVEAVATARPROP(AVATARID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEAVATARPROP_PK PRIMARY KEY(AVATARID,NAME))
CREATE MEMORY TABLE JIVEAVATARUSER(AVATARID BIGINT NOT NULL,USERID BIGINT NOT NULL,CONSTRAINT JIVEAVATARUSER_PK PRIMARY KEY(AVATARID,USERID))
CREATE MEMORY TABLE JIVEQUESTION(THREADID BIGINT NOT NULL,FORUMID BIGINT NOT NULL,USERID BIGINT NOT NULL,CREATIONDATE BIGINT NOT NULL,RESOLUTIONDATE BIGINT,RESOLUTIONSTATE INTEGER NOT NULL,CONSTRAINT JIVEQUESTION_PK PRIMARY KEY(THREADID))
CREATE INDEX JIVEQ_CD_IDX ON JIVEQUESTION(CREATIONDATE)
CREATE INDEX IVEQ_RD_IDX ON JIVEQUESTION(RESOLUTIONDATE)
CREATE INDEX JIVEQ_ST_IDX ON JIVEQUESTION(RESOLUTIONSTATE)
CREATE MEMORY TABLE JIVEQUESTIONPROP(THREADID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEQSTPROP_PK PRIMARY KEY(THREADID,NAME))
CREATE MEMORY TABLE JIVEANSWER(THREADID BIGINT NOT NULL,MESSAGEID BIGINT NOT NULL,FORUMID BIGINT NOT NULL,USERID BIGINT NOT NULL,HELPFULANSWER INTEGER NOT NULL,CORRECTANSWER INTEGER NOT NULL,CONSTRAINT JIVEANSWER_PK PRIMARY KEY(THREADID,MESSAGEID))
CREATE INDEX JIVEANS_UID_IDX ON JIVEANSWER(USERID)
CREATE MEMORY TABLE JIVETHEMEMAP(THEME VARCHAR(32) NOT NULL,MAPTYPE VARCHAR(16) NOT NULL,NUMVALUE BIGINT,STRINGVALUE VARCHAR(100))
CREATE MEMORY TABLE JIVELOCALIZEDPROP(NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,LOCALE VARCHAR(100) NOT NULL,CONSTRAINT JIVELOCPROP_PK PRIMARY KEY(NAME,LOCALE))
CREATE MEMORY TABLE JIVEGATEWAY(GATEWAYID BIGINT NOT NULL,FORUMID BIGINT NOT NULL,TYPE VARCHAR(10) NOT NULL,IMPORTENABLED INTEGER NOT NULL,EXPORTENABLED INTEGER NOT NULL,DISABLECUTOFFDATE INTEGER,CONSTRAINT JIVEGATEWAY_PK PRIMARY KEY(GATEWAYID))
CREATE MEMORY TABLE JIVEGATEWAYPROP(GATEWAYID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEGTWYPROP_PK PRIMARY KEY(GATEWAYID,NAME))
CREATE MEMORY TABLE JIVEBAN(BANID BIGINT NOT NULL,BANTYPE INTEGER NOT NULL,BANNEDUSERID BIGINT,IPADDRESS VARCHAR(15),ADMINID BIGINT NOT NULL,BANLEVEL INTEGER NOT NULL,CREATIONDATE BIGINT NOT NULL,EXPIRATIONDATE BIGINT,COMMENTS VARCHAR(50),CONSTRAINT JIVEBAN_PK PRIMARY KEY(BANID))
CREATE MEMORY TABLE JIVEABUSE(ABUSEID BIGINT NOT NULL,ABUSETYPE INTEGER NOT NULL,MESSAGEID BIGINT NOT NULL,USERID BIGINT NOT NULL,REPORTDATE BIGINT NOT NULL,COMMENTS VARCHAR(500),RESOLVED INTEGER,CONSTRAINT JIVEABUSE_PK PRIMARY KEY(ABUSEID))
CREATE MEMORY TABLE JIVEWATCHSETTINGS(USERID BIGINT NOT NULL,AUTOWATCHNEWTOPICS INTEGER NOT NULL,AUTOWATCHREPLIES INTEGER NOT NULL,RECEIVEEMAILS INTEGER NOT NULL,BATCHFREQUENCY INTEGER NOT NULL,LASTBATCHEMAIL BIGINT,CONSTRAINT JIVEWCHSETT_PK PRIMARY KEY(USERID))
CREATE MEMORY TABLE JIVEPROFILEFIELD(FIELDID BIGINT NOT NULL,NAME VARCHAR(255) NOT NULL,DESCRIPTION VARCHAR(4000),REQUIRED INTEGER NOT NULL,FILTERABLE INTEGER NOT NULL,SEARCHABLE INTEGER NOT NULL,VISIBLE INTEGER NOT NULL,EDITABLE INTEGER NOT NULL,FIELDTYPE INTEGER NOT NULL,IDX INTEGER NOT NULL,CONSTRAINT JIVEPROFLD_PK PRIMARY KEY(FIELDID))
CREATE MEMORY TABLE JIVEPROFILEFIELDOPTION(FIELDID BIGINT NOT NULL,VALUE VARCHAR(255) NOT NULL,IDX INTEGER NOT NULL,DEFAULTOPTION INTEGER NOT NULL)
CREATE MEMORY TABLE JIVEUSERPROFILE(USERID BIGINT NOT NULL,FIELDID BIGINT NOT NULL,VALUE VARCHAR(3500))
CREATE MEMORY TABLE JIVEEMAILTOKEN(USERID BIGINT NOT NULL,TOKENVALUE INTEGER NOT NULL,TIMESTAMP BIGINT NOT NULL,CONSTRAINT JIVEEMAILTOKEN_PK PRIMARY KEY(USERID,TOKENVALUE,TIMESTAMP))
CREATE MEMORY TABLE JIVEDRAFT(DRAFTID BIGINT NOT NULL,DRAFTTYPE INTEGER NOT NULL,OBJECTTYPE INTEGER,OBJECTID BIGINT NOT NULL,USERID BIGINT,SUBJECT VARCHAR(255),BODY LONGVARCHAR,MODIFICATIONDATE BIGINT NOT NULL,CONSTRAINT JIVEDRAFT_PK PRIMARY KEY(DRAFTID))
CREATE INDEX JIVEDRAFT_UID_IDX ON JIVEDRAFT(USERID)
CREATE INDEX JIVEDRAFT_MD_IDX ON JIVEDRAFT(MODIFICATIONDATE)
CREATE INDEX JIVEDRFT_OID_IDX ON JIVEDRAFT(OBJECTID)
CREATE MEMORY TABLE JIVEDRAFTPROP(DRAFTID BIGINT NOT NULL,NAME VARCHAR(100) NOT NULL,PROPVALUE VARCHAR(4000) NOT NULL,CONSTRAINT JIVEDRAFTPROP_PK PRIMARY KEY(DRAFTID,NAME))
CREATE MEMORY TABLE JIVELINKOBJECT(LINKKEY VARCHAR(255) NOT NULL,OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,CONSTRAINT JIVELINKOBJECT_PK PRIMARY KEY(LINKKEY))
CREATE MEMORY TABLE JIVEVERSION(NAME VARCHAR(50) NOT NULL,VERSION INTEGER NOT NULL,CONSTRAINT JIVEVERSION_PK PRIMARY KEY(NAME))
CREATE MEMORY TABLE JIVETAG(TAGID BIGINT NOT NULL PRIMARY KEY,TAGNAME VARCHAR(100) NOT NULL,CREATIONDATE BIGINT NOT NULL)
CREATE MEMORY TABLE JIVEOBJECTTAG(OBJECTTYPE INTEGER NOT NULL,OBJECTID BIGINT NOT NULL,TAGID BIGINT NOT NULL,CREATIONDATE BIGINT NOT NULL)
CREATE INDEX JIVEOBJECTTAG_IDX ON JIVEOBJECTTAG(OBJECTTYPE,TAGID)
CREATE INDEX JIVEOBJECTTAG_PK_IDX ON JIVEOBJECTTAG (TAGID, OBJECTID, OBJECTTYPE);
CREATE USER SA PASSWORD "jiverocks"
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO JIVECATEGORY VALUES(1,'root',NULL,0,0,1,2,NULL)
INSERT INTO JIVEUSER VALUES(1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrator',1,'admin@example.com',1,0,0)
INSERT INTO JIVEUSERPERM VALUES(17,-1,1,1,59)
INSERT INTO JIVEUSERPERM VALUES(17,-1,-1,1,0)
INSERT INTO JIVEUSERPERM VALUES(17,-1,0,1,1)
INSERT INTO JIVEUSERPERM VALUES(17,-1,0,1,2)
INSERT INTO JIVEUSERPERM VALUES(17,-1,0,1,5)
INSERT INTO JIVEUSERPERM VALUES(17,-1,0,1,10)
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 JIVEID VALUES(18,1)
INSERT INTO JIVEID VALUES(19,1)
INSERT INTO JIVEID VALUES(20,1)
INSERT INTO JIVEID VALUES(22,1)
INSERT INTO JIVEID VALUES(23,1)
INSERT INTO JIVEID VALUES(24,1)
INSERT INTO JIVEID VALUES(25,1)
INSERT INTO JIVEID VALUES(26,1)
INSERT INTO JIVEID VALUES(36,1)
INSERT INTO JIVEID VALUES(201,1)
INSERT INTO JIVEID VALUES(202,1)
INSERT INTO JIVEID VALUES(500,5)
INSERT INTO JIVEID VALUES(501,2)
INSERT INTO JIVEID VALUES(502,6)
INSERT INTO JIVEPROFILEFIELD VALUES(1,'Location',NULL,0,0,0,1,1,9,0)
INSERT INTO JIVEPROFILEFIELD VALUES(2,'Occupation',NULL,0,0,0,1,1,9,1)
INSERT INTO JIVEPROFILEFIELD VALUES(3,'Homepage',NULL,0,0,0,1,1,10,2)
INSERT INTO JIVEPROFILEFIELD VALUES(4,'Biography',NULL,0,0,0,1,1,6,3)
INSERT INTO JIVEVERSION VALUES('community',5521001)