?? easyjforum_sqlserver.sql
字號:
topicID INT NOT NULL,
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
-- ************************************************
CREATE TABLE ejf_short_msg(
msgID INT NOT NULL IDENTITY,
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 DATETIME,
PRIMARY KEY(msgID),
FOREIGN KEY(userID)
REFERENCES ejf_user(userID) ON DELETE CASCADE);
-- ************************************************
-- * ejf_bookmark table
-- ************************************************
CREATE TABLE ejf_bookmark(
markID INT NOT NULL IDENTITY,
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 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 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 TABLE ejf_moderator_log (
logID INT NOT NULL IDENTITY,
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 TABLE ejf_report_log (
logID INT NOT NULL IDENTITY,
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 NOT NULL IDENTITY,
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 TABLE ejf_credits_log (
logID INT NOT NULL IDENTITY,
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 TABLE ejf_admin_log (
logID INT NOT NULL IDENTITY,
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 TABLE ejf_error_log (
logID INT NOT NULL IDENTITY,
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 NOT NULL IDENTITY,
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));
-- ************************************************
-- *
-- * Insert init data into tables
-- *
-- ************************************************
--
-- Groups
--
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('A', '管理員', 'S', 0, 9, 'ABCDEFGWHIJKLMNOPQRSTUV', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('S', '超級版主', 'S', 0, 8, 'ABCDEFGWHIJKLMNOQRST', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('M', '版主', 'S', 0, 7, 'ABCDEFGWHJKLMNOQRST', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('G', '游客', 'S', 0, 0, 'ABCJ', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('1', '乞丐', 'M', -999999, 0, 'ACG', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('2', '貧民', 'M', -50, 1, 'ACFG', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('3', '新手上路', 'M', 0, 1, 'ABCEFGJK', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('4', '初級會員', 'M', 50, 2, 'ABCEFGWJK', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('5', '中級會員', 'M', 500, 3, 'ABCEFGWHJK', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('6', '高級會員', 'M', 1500, 4, 'ABCDEFGWHJK', GETDATE());
INSERT INTO ejf_group(groupID,groupName,groupType,minCredits,stars,rights,createTime)
VALUES('7', '論壇元老', 'M', 3000, 5, 'ABCDEFGWHJKT', GETDATE());
--
-- Sections & Boards
--
INSERT INTO ejf_section(sectionName,seqno,createTime) VALUES ('默認分區', 1, GETDATE());
INSERT INTO ejf_board(sectionID,boardName,seqno,brief,allowGroups,acl,createTime) VALUES(@@IDENTITY, '默認版塊', 1, '', 'AMSG1234567', '', GETDATE());
INSERT INTO ejf_section(sectionName,seqno,createTime) VALUES ('站務管理', 2, GETDATE());
INSERT INTO ejf_board(sectionID,boardName,seqno,brief,allowGroups,acl,createTime) VALUES(@@IDENTITY, '論壇公告', 1, '論壇公告發布，版主任免，管理與獎懲決定公布等', 'AMSG1234567', 'F_AMS', GETDATE());
INSERT INTO ejf_board(sectionID,boardName,seqno,brief,allowGroups,acl,createTime) VALUES(@@IDENTITY, '站務管理', 2, '意見、建議發表，系統BUG報告等', 'AMSG1234567', '', GETDATE());?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -