CREATE TABLE MVNFORUMCATEGORY(CATEGORYID INTEGER NOT NULL IDENTITY PRIMARY KEY,PARENTCATEGORYID INTEGER NOT NULL,CATEGORYNAME VARCHAR(250) NOT NULL,CATEGORYDESC LONGVARCHAR NOT NULL,CATEGORYCREATIONDATE TIMESTAMP NOT NULL,CATEGORYMODIFIEDDATE TIMESTAMP NOT NULL,CATEGORYORDER SMALLINT NOT NULL,CATEGORYOPTION INTEGER NOT NULL,CATEGORYSTATUS INTEGER NOT NULL,CONSTRAINT SYS_CT_1 UNIQUE(CATEGORYNAME))
CREATE TABLE MVNFORUMFORUM(FORUMID INTEGER NOT NULL IDENTITY PRIMARY KEY,CATEGORYID INTEGER NOT NULL,LASTPOSTMEMBERNAME VARCHAR(30) NOT NULL,FORUMNAME VARCHAR(250) NOT NULL,FORUMDESC LONGVARCHAR NOT NULL,FORUMCREATIONDATE TIMESTAMP NOT NULL,FORUMMODIFIEDDATE TIMESTAMP NOT NULL,FORUMLASTPOSTDATE TIMESTAMP NOT NULL,FORUMORDER SMALLINT NOT NULL,FORUMTYPE INTEGER NOT NULL,FORUMFORMATOPTION INTEGER NOT NULL,FORUMOPTION INTEGER NOT NULL,FORUMSTATUS INTEGER NOT NULL,FORUMMODERATIONMODE INTEGER NOT NULL,FORUMPASSWORD VARCHAR(40) NOT NULL,FORUMTHREADCOUNT INTEGER NOT NULL,FORUMPOSTCOUNT INTEGER NOT NULL,CONSTRAINT SYS_CT_3 UNIQUE(FORUMNAME,CATEGORYID))
CREATE INDEX INDEX_2 ON MVNFORUMFORUM(CATEGORYID)
CREATE TABLE MVNFORUMGROUPFORUM(GROUPID INTEGER NOT NULL,FORUMID INTEGER NOT NULL,PERMISSION INTEGER NOT NULL,CONSTRAINT SYS_PK_MVNFORUMGROUPFORUM PRIMARY KEY(GROUPID,FORUMID,PERMISSION))
CREATE INDEX INDEX_17 ON MVNFORUMGROUPFORUM(GROUPID)
CREATE INDEX INDEX_18 ON MVNFORUMGROUPFORUM(FORUMID)
CREATE TABLE MVNFORUMGROUPPERMISSION(GROUPID INTEGER NOT NULL,PERMISSION INTEGER NOT NULL,CONSTRAINT SYS_PK_MVNFORUMGROUPPERMISSION PRIMARY KEY(GROUPID,PERMISSION))
CREATE INDEX INDEX_19 ON MVNFORUMGROUPPERMISSION(GROUPID)
CREATE TABLE MVNFORUMGROUPS(GROUPID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUPOWNERID INTEGER NOT NULL,GROUPOWNERNAME VARCHAR(30) NOT NULL,GROUPNAME VARCHAR(250) NOT NULL,GROUPDESC LONGVARCHAR NOT NULL,GROUPOPTION INTEGER NOT NULL,GROUPCREATIONDATE TIMESTAMP NOT NULL,GROUPMODIFIEDDATE TIMESTAMP NOT NULL,CONSTRAINT SYS_CT_5 UNIQUE(GROUPNAME))
CREATE TABLE MVNFORUMMEMBER(MEMBERID INTEGER NOT NULL IDENTITY PRIMARY KEY,MEMBERNAME VARCHAR_IGNORECASE(30) NOT NULL,MEMBERPASSWORD VARCHAR(40) NOT NULL,MEMBERFIRSTEMAIL VARCHAR(60) NOT NULL,MEMBEREMAIL VARCHAR(60) NOT NULL,MEMBEREMAILVISIBLE SMALLINT NOT NULL,MEMBERNAMEVISIBLE SMALLINT NOT NULL,MEMBERFIRSTIP VARCHAR(20) NOT NULL,MEMBERLASTIP VARCHAR(20) NOT NULL,MEMBERVIEWCOUNT INTEGER NOT NULL,MEMBERPOSTCOUNT INTEGER NOT NULL,MEMBERCREATIONDATE TIMESTAMP NOT NULL,MEMBERMODIFIEDDATE TIMESTAMP NOT NULL,MEMBERLASTLOGON TIMESTAMP NOT NULL,MEMBEROPTION INTEGER NOT NULL,MEMBERSTATUS INTEGER NOT NULL,MEMBERACTIVATECODE VARCHAR(40) NOT NULL,MEMBERTEMPPASSWORD VARCHAR(40) NOT NULL,MEMBERMESSAGECOUNT INTEGER NOT NULL,MEMBERMESSAGEOPTION INTEGER NOT NULL,MEMBERPOSTSPERPAGE SMALLINT NOT NULL,MEMBERWARNCOUNT SMALLINT NOT NULL,MEMBERVOTECOUNT INTEGER NOT NULL,MEMBERVOTETOTALSTARS INTEGER NOT NULL,MEMBERREWARDPOINTS INTEGER NOT NULL,MEMBERTITLE VARCHAR(250) NOT NULL,MEMBERTIMEZONE INTEGER NOT NULL,MEMBERSIGNATURE VARCHAR(250) NOT NULL,MEMBERAVATAR VARCHAR(200) NOT NULL,MEMBERSKIN VARCHAR(70) NOT NULL,MEMBERLANGUAGE VARCHAR(70) NOT NULL,MEMBERFIRSTNAME VARCHAR(70) NOT NULL,MEMBERLASTNAME VARCHAR(70) NOT NULL,MEMBERGENDER SMALLINT NOT NULL,MEMBERBIRTHDAY DATE NOT NULL,MEMBERADDRESS VARCHAR(150) NOT NULL,MEMBERCITY VARCHAR(70) NOT NULL,MEMBERSTATE VARCHAR(70) NOT NULL,MEMBERCOUNTRY VARCHAR(70) NOT NULL,MEMBERPHONE VARCHAR(40) NOT NULL,MEMBERMOBILE VARCHAR(40) NOT NULL,MEMBERFAX VARCHAR(40) NOT NULL,MEMBERCAREER VARCHAR(50) NOT NULL,MEMBERHOMEPAGE VARCHAR(200) NOT NULL,MEMBERYAHOO VARCHAR(70) NOT NULL,MEMBERAOL VARCHAR(70) NOT NULL,MEMBERICQ VARCHAR(70) NOT NULL,MEMBERMSN VARCHAR(70) NOT NULL,MEMBERCOOLLINK1 VARCHAR(200) NOT NULL,MEMBERCOOLLINK2 VARCHAR(200) NOT NULL,CONSTRAINT SYS_CT_7 UNIQUE(MEMBEREMAIL),CONSTRAINT SYS_CT_8 UNIQUE(MEMBERNAME))
CREATE TABLE MVNFORUMMEMBERGROUP(GROUPID INTEGER NOT NULL,MEMBERID INTEGER NOT NULL,MEMBERNAME VARCHAR(30) NOT NULL,PRIVILEGE INTEGER NOT NULL,CREATIONDATE TIMESTAMP NOT NULL,MODIFIEDDATE TIMESTAMP NOT NULL,CONSTRAINT SYS_PK_MVNFORUMMEMBERGROUP PRIMARY KEY(GROUPID,MEMBERID))
CREATE INDEX INDEX_20 ON MVNFORUMMEMBERGROUP(MEMBERID)
CREATE INDEX INDEX_21 ON MVNFORUMMEMBERGROUP(GROUPID)
CREATE TABLE MVNFORUMMEMBERPERMISSION(MEMBERID INTEGER NOT NULL,PERMISSION INTEGER NOT NULL,CONSTRAINT SYS_PK_MVNFORUMMEMBERPERMISSION PRIMARY KEY(MEMBERID,PERMISSION))
CREATE INDEX INDEX_22 ON MVNFORUMMEMBERPERMISSION(MEMBERID)
CREATE TABLE MVNFORUMMESSAGEFOLDER(FOLDERNAME VARCHAR(30) NOT NULL,MEMBERID INTEGER NOT NULL,FOLDERORDER SMALLINT NOT NULL,FOLDERCREATIONDATE TIMESTAMP NOT NULL,FOLDERMODIFIEDDATE TIMESTAMP NOT NULL,CONSTRAINT SYS_PK_MVNFORUMMESSAGEFOLDER PRIMARY KEY(FOLDERNAME,MEMBERID))
CREATE INDEX INDEX_32 ON MVNFORUMMESSAGEFOLDER(MEMBERID)
CREATE TABLE MVNFORUMPOST(POSTID INTEGER NOT NULL IDENTITY PRIMARY KEY,PARENTPOSTID INTEGER NOT NULL,FORUMID INTEGER NOT NULL,THREADID INTEGER NOT NULL,MEMBERID INTEGER NOT NULL,MEMBERNAME VARCHAR(30) NOT NULL,LASTEDITMEMBERNAME VARCHAR(30) NOT NULL,POSTTOPIC VARCHAR(250) NOT NULL,POSTBODY LONGVARCHAR NOT NULL,POSTCREATIONDATE TIMESTAMP NOT NULL,POSTLASTEDITDATE TIMESTAMP NOT NULL,POSTCREATIONIP VARCHAR(20) NOT NULL,POSTLASTEDITIP VARCHAR(20) NOT NULL,POSTEDITCOUNT SMALLINT NOT NULL,POSTFORMATOPTION INTEGER NOT NULL,POSTOPTION INTEGER NOT NULL,POSTSTATUS INTEGER NOT NULL,POSTICON VARCHAR(10) NOT NULL,POSTATTACHCOUNT SMALLINT NOT NULL)
CREATE INDEX INDEX_7 ON MVNFORUMPOST(FORUMID)
CREATE INDEX INDEX_8 ON MVNFORUMPOST(THREADID)
CREATE INDEX INDEX_9 ON MVNFORUMPOST(MEMBERID)
CREATE INDEX INDEX_37 ON MVNFORUMPOST(PARENTPOSTID)
CREATE TABLE MVNFORUMTHREAD(THREADID INTEGER NOT NULL IDENTITY PRIMARY KEY,FORUMID INTEGER NOT NULL,MEMBERNAME VARCHAR(30) NOT NULL,LASTPOSTMEMBERNAME VARCHAR(30) NOT NULL,THREADTOPIC VARCHAR(250) NOT NULL,THREADBODY LONGVARCHAR NOT NULL,THREADVOTECOUNT INTEGER NOT NULL,THREADVOTETOTALSTARS INTEGER NOT NULL,THREADCREATIONDATE TIMESTAMP NOT NULL,THREADLASTPOSTDATE TIMESTAMP NOT NULL,THREADTYPE INTEGER NOT NULL,THREADOPTION INTEGER NOT NULL,THREADSTATUS INTEGER NOT NULL,THREADHASPOLL INTEGER NOT NULL,THREADVIEWCOUNT INTEGER NOT NULL,THREADREPLYCOUNT INTEGER NOT NULL,THREADICON VARCHAR(10) NOT NULL,THREADDURATION INTEGER NOT NULL)
CREATE INDEX INDEX_4 ON MVNFORUMTHREAD(FORUMID)
CREATE TABLE MVNFORUMWATCH(WATCHID INTEGER NOT NULL IDENTITY PRIMARY KEY,MEMBERID INTEGER NOT NULL,CATEGORYID INTEGER NOT NULL,FORUMID INTEGER NOT NULL,THREADID INTEGER NOT NULL,WATCHTYPE INTEGER NOT NULL,WATCHOPTION INTEGER NOT NULL,WATCHSTATUS INTEGER NOT NULL,WATCHCREATIONDATE TIMESTAMP NOT NULL,WATCHLASTSENTDATE TIMESTAMP NOT NULL,WATCHENDDATE TIMESTAMP NOT NULL,CONSTRAINT SYS_CT_1 UNIQUE(MEMBERID,CATEGORYID,FORUMID,THREADID))
CREATE INDEX WATCH_MEMBERID_IDX ON MVNFORUMWATCH(MEMBERID)
CREATE INDEX WATCH_CATEGORYID_IDX ON MVNFORUMWATCH(CATEGORYID)
CREATE INDEX WATCH_FORUMID_IDX ON MVNFORUMWATCH(FORUMID)
CREATE INDEX WATCH_THREADID_IDX ON MVNFORUMWATCH(THREADID)
CREATE TABLE MVNFORUMATTACHMENT(ATTACHID INTEGER NOT NULL IDENTITY PRIMARY KEY,POSTID INTEGER NOT NULL,MEMBERID INTEGER NOT NULL,ATTACHFILENAME VARCHAR(250) NOT NULL,ATTACHFILESIZE INTEGER NOT NULL,ATTACHMIMETYPE VARCHAR(70) NOT NULL,ATTACHDESC VARCHAR(250) NOT NULL,ATTACHCREATIONIP VARCHAR(20) NOT NULL,ATTACHCREATIONDATE TIMESTAMP NOT NULL,ATTACHMODIFIEDDATE TIMESTAMP NOT NULL,ATTACHDOWNLOADCOUNT INTEGER NOT NULL,ATTACHOPTION INTEGER NOT NULL,ATTACHSTATUS INTEGER NOT NULL)
CREATE INDEX ATTACHMENT_POSTID_IDX ON MVNFORUMATTACHMENT(POSTID)
CREATE INDEX ATTACHMENT_MEMBERID_IDX ON MVNFORUMATTACHMENT(MEMBERID)
CREATE TABLE MVNFORUMMEMBERFORUM(MEMBERID INTEGER NOT NULL,FORUMID INTEGER NOT NULL,PERMISSION INTEGER NOT NULL,CONSTRAINT SYS_PK_MVNFORUMMEMBERFORUM PRIMARY KEY(MEMBERID,FORUMID,PERMISSION))
CREATE INDEX MEMBERFORUM_1_IDX ON MVNFORUMMEMBERFORUM(MEMBERID)
CREATE INDEX MEMBERFORUM_2_IDX ON MVNFORUMMEMBERFORUM(FORUMID)
CREATE TABLE MVNFORUMFAVORITETHREAD(MEMBERID INTEGER NOT NULL,THREADID INTEGER NOT NULL,FORUMID INTEGER NOT NULL,FAVORITECREATIONDATE TIMESTAMP NOT NULL,FAVORITETYPE INTEGER NOT NULL,FAVORITEOPTION INTEGER NOT NULL,FAVORITESTATUS INTEGER NOT NULL,CONSTRAINT SYS_PK_MVNFORUMFAVORITETHREAD PRIMARY KEY(MEMBERID,THREADID))
CREATE INDEX FAVORTHREAD_1_IDX ON MVNFORUMFAVORITETHREAD(MEMBERID)
CREATE INDEX FAVORTHREAD_2_IDX ON MVNFORUMFAVORITETHREAD(THREADID)
CREATE TABLE MVNFORUMRANK(RANKID INTEGER NOT NULL IDENTITY PRIMARY KEY,RANKMINPOSTS INTEGER NOT NULL,RANKLEVEL INTEGER NOT NULL,RANKTITLE VARCHAR(250) NOT NULL,RANKIMAGE VARCHAR(250) NOT NULL,RANKTYPE INTEGER NOT NULL,RANKOPTION INTEGER NOT NULL,CONSTRAINT SYS_CT_1 UNIQUE(RANKMINPOSTS),CONSTRAINT SYS_CT_2 UNIQUE(RANKTITLE))
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"
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 MVNFORUMGROUPPERMISSION VALUES(1,109)
INSERT INTO MVNFORUMGROUPPERMISSION VALUES(2,110)
INSERT INTO MVNFORUMGROUPPERMISSION VALUES(3,100)
INSERT INTO MVNFORUMGROUPPERMISSION VALUES(4,105)
INSERT INTO MVNFORUMGROUPPERMISSION VALUES(5,106)
INSERT INTO MVNFORUMGROUPS VALUES(1,0,'','Guest','All anonymous users belong to this group.',0,'2003-02-05 14:50:11.031','2003-02-05 14:50:11.031')
INSERT INTO MVNFORUMGROUPS VALUES(2,0,'','Member','All registered users belong to this group.',0,'2003-02-05 14:50:11.031','2003-02-05 14:50:11.031')
INSERT INTO MVNFORUMGROUPS VALUES(3,1,'admin','Admin','This group have SystemAdmin permission by default.',0,'2003-02-05 14:50:11.031','2003-02-05 14:50:11.031')
INSERT INTO MVNFORUMGROUPS VALUES(4,1,'admin','Forum Admin','This group have ForumAdmin permission by default.',0,'2003-02-05 14:50:11.041','2003-02-05 14:50:11.041')
INSERT INTO MVNFORUMGROUPS VALUES(5,1,'admin','Forum Moderator','This group have ForumModerator permission by default.',0,'2003-02-05 14:50:11.041','2003-02-05 14:50:11.041')
INSERT INTO MVNFORUMMEMBER VALUES(1,'admin','ISMvKXpXpadDiUoOSoAfww==','admin@yourdomain.com','admin@yourdomain.com',0,1,'127.0.0.1','127.0.0.1',0,0,'2003-02-05 14:50:11.011','2003-02-05 14:50:11.011','2003-02-05 14:50:11.011',0,0,'','',0,0,10,0,0,0,0,'',0,'','','','','','',1,'2003-02-05','','','','','','','','','','','','','','','')
INSERT INTO MVNFORUMMEMBERGROUP VALUES(3,1,'admin',0,'2003-02-05 14:50:11.041','2003-02-05 14:50:11.041')
INSERT INTO MVNFORUMMEMBERPERMISSION VALUES(1,100)
INSERT INTO MVNFORUMMESSAGEFOLDER VALUES('Inbox',1,0,'2003-02-05 14:50:11.031','2003-02-05 14:50:11.031')
INSERT INTO MVNFORUMMESSAGEFOLDER VALUES('Sent',1,0,'2003-02-05 14:50:11.031','2003-02-05 14:50:11.031')
INSERT INTO MVNFORUMRANK VALUES(0,0,0,'Stranger','',0,0)
INSERT INTO MVNFORUMRANK VALUES(1,20,0,'Newbie','',0,0)
INSERT INTO MVNFORUMRANK VALUES(2,50,0,'Member','',0,0)
INSERT INTO MVNFORUMRANK VALUES(3,100,0,'Advanced Member','',0,0)