📄 easyjforum_hsqldb.sql
字号:
replyID INT DEFAULT 0,
boardID INT NOT NULL,
boardName VARCHAR(20) NOT NULL,
topicTitle VARCHAR(100) NOT NULL,
userID VARCHAR(15) NOT NULL,
deleteUser VARCHAR(15) NOT NULL,
createTime DATETIME,
PRIMARY KEY(topicID,replyID));
-- ************************************************
-- * ejf_short_msg table
-- * Outflag: N - Normal, D - Deleted
-- * State: N - New, R - Read, D - Deleted
-- ************************************************
CREATE CACHED TABLE ejf_short_msg(
msgID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
title VARCHAR(100) NOT NULL,
message VARCHAR(200) ,
userID VARCHAR(15) NOT NULL,
fromUser VARCHAR(15) NOT NULL,
outflag CHAR(1) DEFAULT 'N',
state CHAR(1) DEFAULT 'N',
createTime DATETIME,
updateTime TIMESTAMP,
PRIMARY KEY(msgID),
FOREIGN KEY(userID)
REFERENCES ejf_user(userID) ON DELETE CASCADE);
-- ************************************************
-- * ejf_bookmark table
-- ************************************************
CREATE CACHED TABLE ejf_bookmark(
markID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) NOT NULL,
url VARCHAR(100) NOT NULL,
title VARCHAR(100) NOT NULL,
boardName VARCHAR(20) ,
createTime DATETIME,
PRIMARY KEY(markID),
FOREIGN KEY(userID)
REFERENCES ejf_user(userID) ON DELETE CASCADE);
-- ************************************************
-- * ejf_friend table
-- ************************************************
CREATE CACHED TABLE ejf_friend(
userID VARCHAR(15) NOT NULL,
friendID VARCHAR(15) NOT NULL,
remark VARCHAR(50) ,
createTime DATETIME,
PRIMARY KEY(userID,friendID),
FOREIGN KEY(userID)
REFERENCES ejf_user(userID) ON DELETE CASCADE);
-- ************************************************
-- * ejf_visit_stat table
-- ************************************************
CREATE CACHED TABLE ejf_visit_stat (
statDate VARCHAR(10) NOT NULL,
topics INT DEFAULT 0,
replies INT DEFAULT 0,
users INT DEFAULT 0,
visits INT DEFAULT 0,
PRIMARY KEY(statDate));
-- ************************************************
-- * ejf_moderator_log table
-- ************************************************
CREATE CACHED TABLE ejf_moderator_log (
logID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) NOT NULL,
groupName VARCHAR(15) NOT NULL,
remoteIP VARCHAR(25) ,
boardID INT NOT NULL,
boardName VARCHAR(20) NOT NULL,
topicID INT NOT NULL,
topicTitle VARCHAR(100) NOT NULL,
replyID INT DEFAULT 0,
action VARCHAR(10) NOT NULL,
reason VARCHAR(40) NOT NULL,
createTime DATETIME,
PRIMARY KEY(logID));
-- ************************************************
-- * ejf_report_log table
-- ************************************************
CREATE CACHED TABLE ejf_report_log (
logID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) ,
reportedUser VARCHAR(15) ,
boardID INT NOT NULL,
boardName VARCHAR(20) NOT NULL,
topicID INT NOT NULL,
topicTitle VARCHAR(100) NOT NULL,
replyID INT DEFAULT 0,
reason VARCHAR(40) NOT NULL,
createTime DATETIME,
PRIMARY KEY(logID));
-- ************************************************
-- * ejf_censor_log table
-- ************************************************
CREATE TABLE ejf_censor_log (
logID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) ,
boardID INT NOT NULL,
boardName VARCHAR(20) NOT NULL,
topicID INT NOT NULL,
topicTitle VARCHAR(100) NOT NULL,
replyID INT DEFAULT 0,
reason VARCHAR(40) NOT NULL,
createTime DATETIME,
PRIMARY KEY(logID));
-- ************************************************
-- * ejf_credits_log table
-- ************************************************
CREATE CACHED TABLE ejf_credits_log (
logID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) NOT NULL,
fromUser VARCHAR(15) ,
credits SMALLINT DEFAULT 0,
action VARCHAR(10) NOT NULL,
createTime DATETIME,
PRIMARY KEY(logID));
-- ************************************************
-- * ejf_admin_log table
-- ************************************************
CREATE CACHED TABLE ejf_admin_log (
logID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) NOT NULL,
groupName VARCHAR(15) NOT NULL,
remoteIP VARCHAR(25) ,
action VARCHAR(10) NOT NULL,
remark VARCHAR(40) ,
createTime DATETIME,
PRIMARY KEY(logID));
-- ************************************************
-- * ejf_error_log table
-- ************************************************
CREATE CACHED TABLE ejf_error_log (
logID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
userID VARCHAR(15) NOT NULL,
remoteIP VARCHAR(25) ,
action VARCHAR(10) NOT NULL,
errorInfo VARCHAR(100) ,
createTime DATETIME,
PRIMARY KEY(logID));
-- ************************************************
-- * ejf_backup_task table
-- * runAt: N - Now, D - Daily, W - Weekly
-- * runMode: A - All, I - Increasely
-- ************************************************
CREATE TABLE ejf_backup_task (
taskID INT GENERATED BY DEFAULT AS IDENTITY(START WITH 1),
inputFile VARCHAR(255) NOT NULL,
outputFile VARCHAR(255) NOT NULL,
runAt CHAR(1) DEFAULT 'N',
sendmail CHAR(1) DEFAULT 'T',
runMode CHAR(1) DEFAULT 'A',
isOnlyFile CHAR(1) DEFAULT 'T',
runStamp VARCHAR(20) ,
remark VARCHAR(50) ,
createTime DATETIME,
PRIMARY KEY(taskID));
SET WRITE_DELAY 100 MILLIS;
-- ************************************************
-- *
-- * Insert init data into tables
-- *
-- ************************************************
--
-- Groups
--
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('A', '管理员', 'S', 0, 9, 'ABCDEFGWHIJKLMNOPQRSTUV', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('S', '超级版主', 'S', 0, 8, 'ABCDEFGWHIJKLMNOQRST', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('M', '版主', 'S', 0, 7, 'ABCDEFGWHJKLMNOQRST', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('G', '游客', 'S', 0, 0, 'ABCJ', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('1', '乞丐', 'M', -999999, 0, 'ACG', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('2', '贫民', 'M', -50, 1, 'ACFG', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('3', '新手上路', 'M', 0, 1, 'ABCEFGJK', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('4', '初级会员', 'M', 50, 2, 'ABCEFGWJK', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('5', '中级会员', 'M', 500, 3, 'ABCEFGWHJK', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('6', '高级会员', 'M', 1500, 4, 'ABCDEFGWHJK', NOW());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('7', '论坛元老', 'M', 3000, 5, 'ABCDEFGWHJKT', NOW());
--
-- Sections & Boards
--
INSERT INTO ejf_section(sectionName,seqno,createTime) VALUES ('默认分区', 1, NOW());
INSERT INTO ejf_board(sectionID,boardName,seqno,brief,allowGroups,acl,createTime) VALUES(IDENTITY(), '默认版块', 1, '', 'AMSG1234567','', NOW());
INSERT INTO ejf_section(sectionName,seqno,createTime) VALUES ('站务管理', 2, NOW());
INSERT INTO ejf_board(sectionID,boardName,seqno,brief,allowGroups,acl,createTime) VALUES(IDENTITY(), '论坛公告', 1, '论坛公告发布，版主任免，管理与奖惩决定公布等', 'AMSG1234567', 'F_AMS', NOW());
INSERT INTO ejf_board(sectionID,boardName,seqno,brief,allowGroups,acl,createTime) VALUES(IDENTITY(), '站务管理', 2, '意见、建议发表，系统BUG报告等', 'AMSG1234567', '', NOW());
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -