?? 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 + -