lb.script

来自「雷霆论坛是用J2EE技术开发的功能强大、扩展性强、易于定制」· SCRIPT 代码 · 共 95 行

CREATE TABLE LB_FORUM(F_ORDER INTEGER NOT NULL,F_ID INTEGER NOT NULL PRIMARY KEY,F_NAME VARCHAR(40) NOT NULL,F_INFO VARCHAR(100) NOT NULL,F_U_ID INTEGER NOT NULL,F_TOPICS INTEGER NOT NULL,F_MESSAGES INTEGER NOT NULL,F_U_ID2 INTEGER NOT NULL,F_LASTTIME TIMESTAMP NOT NULL)
CREATE TABLE LB_TOPIC(T_ORDER INTEGER NOT NULL,T_LOCKED INTEGER NOT NULL,T_ICONID INTEGER NOT NULL,T_F_ID INTEGER NOT NULL,T_ID INTEGER NOT NULL PRIMARY KEY,T_NAME VARCHAR(100) NOT NULL,T_U_ID INTEGER NOT NULL,T_REPLIES INTEGER NOT NULL,T_VIEWS INTEGER NOT NULL,T_U_ID2 INTEGER NOT NULL,T_LASTTIME TIMESTAMP NOT NULL)
CREATE TABLE LB_MESSAGE(M_ICONID INTEGER NOT NULL,M_T_ID INTEGER NOT NULL,M_ID INTEGER NOT NULL PRIMARY KEY,M_CONTENT VARCHAR(1000) NOT NULL,M_U_ID INTEGER NOT NULL,M_TIME TIMESTAMP NOT NULL)
CREATE TABLE LB_USER(U_ID INTEGER NOT NULL PRIMARY KEY,U_R_ID INTEGER NOT NULL,U_NAME VARCHAR(20) NOT NULL,U_AVATAR_ID INTEGER NOT NULL,U_PASSWORD VARCHAR(20) NOT NULL,U_EMAIL VARCHAR(40) NOT NULL,U_REGTIME TIMESTAMP NOT NULL,U_ADDRESS VARCHAR(40) NOT NULL,U_SIGN VARCHAR(100) NOT NULL,U_POST INTEGER NOT NULL,U_LASTTIME TIMESTAMP NOT NULL,U_LASTIP VARCHAR(15) NOT NULL)
CREATE TABLE LB_ID(I_ID INTEGER NOT NULL PRIMARY KEY,I_NUMBER INTEGER NOT NULL)
CREATE TABLE LB_ROLE(R_ID INTEGER NOT NULL PRIMARY KEY,R_NAME VARCHAR(20) NOT NULL)
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"
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 LB_FORUM VALUES(1,1,'General Support(English only)','LightningBoard general support forum.',1,1,1,1,'2002-09-03 09:16:48.0')
INSERT INTO LB_FORUM VALUES(5,5,'Feedback & Announcements','Post suggestions/comments here. Announcements will also be posted here.',1,0,0,1,'1970-01-01 00:00:00.0')
INSERT INTO LB_FORUM VALUES(11,11,'General Java Programming','Discussion general java  programming.',2,0,0,2,'1970-01-01 00:00:00.0')
INSERT INTO LB_FORUM VALUES(12,12,'Database Discussion','Discussion oracle, db2, mysql, hsqldb...',2,0,0,2,'1970-01-01 00:00:00.0')
INSERT INTO LB_FORUM VALUES(13,13,'JSP & Servlet Programming','Discuss JSP, Servlet programming.',2,0,0,2,'1970-01-01 00:00:00.0')
INSERT INTO LB_TOPIC VALUES(0,0,2,1,1,'dfdsf',1,0,1,1,'2002-09-03 09:16:48.0')
INSERT INTO LB_MESSAGE VALUES(2,1,1,'dfdsfasf',1,'2002-09-03 09:16:48.0')
INSERT INTO LB_USER VALUES(1,9,'admin',0,'123456','[e-mail]','2002-08-03 20:00:00.0','dalian china','I am the administrator!',1,'2002-09-03 09:16:48.0','127.0.0.1')
INSERT INTO LB_USER VALUES(2,8,'xiaobo_liu',0,'123456','[e-mail]','2002-08-03 20:00:00.0','dalian china','I am Xiaobo Liu!',0,'2002-08-03 20:00:00.0','')
INSERT INTO LB_ID VALUES(0,5)
INSERT INTO LB_ID VALUES(1,1)
INSERT INTO LB_ID VALUES(2,1)
INSERT INTO LB_ID VALUES(3,2)
INSERT INTO LB_ROLE VALUES(0,'Common User')
INSERT INTO LB_ROLE VALUES(8,'Moderator')
INSERT INTO LB_ROLE VALUES(9,'Administrator')
/*C1*/CONNECT USER sa PASSWORD ""