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