📄 easyjforum_sqlserver.sql
字号:
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_backup_task' AND type = 'U') DROP TABLE ejf_backup_task;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_error_log' AND type = 'U') DROP TABLE ejf_error_log;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_admin_log' AND type = 'U') DROP TABLE ejf_admin_log;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_credits_log' AND type = 'U') DROP TABLE ejf_credits_log;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_censor_log' AND type = 'U') DROP TABLE ejf_censor_log;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_report_log' AND type = 'U') DROP TABLE ejf_report_log;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_moderator_log' AND type = 'U') DROP TABLE ejf_moderator_log;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_visit_stat' AND type = 'U') DROP TABLE ejf_visit_stat;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_friend' AND type = 'U') DROP TABLE ejf_friend;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_bookmark' AND type = 'U') DROP TABLE ejf_bookmark;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_short_msg' AND type = 'U') DROP TABLE ejf_short_msg;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_trash_box' AND type = 'U') DROP TABLE ejf_trash_box;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_attach' AND type = 'U') DROP TABLE ejf_attach;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_reply' AND type = 'U') DROP TABLE ejf_reply;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_topic' AND type = 'U') DROP TABLE ejf_topic;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_board' AND type = 'U') DROP TABLE ejf_board;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_section' AND type = 'U') DROP TABLE ejf_section;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_user' AND type = 'U') DROP TABLE ejf_user;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_group' AND type = 'U') DROP TABLE ejf_group;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_archive_reply' AND type = 'U') DROP TABLE ejf_archive_reply;
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'ejf_archive_topic' AND type = 'U') DROP TABLE ejf_archive_topic;
-- **********************************************************
-- * ejf_group table
-- * GroupType: M - Member Group, S - System
-- * GroupID: 1-9 - Normal User, M - Moderator,
-- * S - Super Moderator, A - Admin, G - Guest
-- **********************************************************
CREATE TABLE ejf_group(
groupID CHAR(1) NOT NULL,
groupName VARCHAR(15) NOT NULL,
groupType CHAR(1) DEFAULT 'M',
minCredits INT DEFAULT 0,
stars INT DEFAULT 1,
rights VARCHAR(50) NOT NULL,
createTime DATETIME,
updateTime DATETIME,
PRIMARY KEY(groupID));
-- **********************************************************
-- * ejf_user table
-- * State: N - Normal, P - Seal Posting, S - Sealed,
-- * A - Auditing
-- * GroupID: Admin group ID
-- **********************************************************
CREATE TABLE ejf_user(
userID VARCHAR(15) NOT NULL,
nickname VARCHAR(15) ,
pwd VARCHAR(32) NOT NULL,
email VARCHAR(40) NOT NULL,
icq VARCHAR(40) ,
webpage VARCHAR(60) ,
avatar VARCHAR(50) ,
gender CHAR(1) DEFAULT 'U',
birth VARCHAR(10) ,
city VARCHAR(20) ,
remoteIP VARCHAR(25) ,
brief VARCHAR(200) ,
isMailPub CHAR(1) DEFAULT 'F',
posts INT DEFAULT 0,
unreadSMs INT DEFAULT 0,
credits INT DEFAULT 0,
groupID CHAR(1) DEFAULT '1',
lastVisited DATETIME,
visitCount INT DEFAULT 1,
loginCount TINYINT DEFAULT 0,
loginExpire DATETIME,
setpwdExpire DATETIME,
state CHAR(1) DEFAULT 'N',
createTime DATETIME,
updateTime DATETIME,
PRIMARY KEY(userID),
UNIQUE(email));
-- ************************************************
-- * ejf_section table
-- * State: N - Normal
-- ************************************************
CREATE TABLE ejf_section(
sectionID INT NOT NULL IDENTITY,
sectionName VARCHAR(20) NOT NULL,
seqno INT DEFAULT 1,
cols INT DEFAULT 1,
moderator VARCHAR(60) ,
state CHAR(1) DEFAULT 'N',
createTime DATETIME,
updateTime DATETIME,
PRIMARY KEY(sectionID));
-- ************************************************
-- * ejf_board table
-- * State: N - Normal, I - Invisible
-- ************************************************
CREATE TABLE ejf_board(
boardID INT NOT NULL IDENTITY,
sectionID INT NOT NULL,
boardName VARCHAR(20) NOT NULL,
highColor VARCHAR(6) ,
seqno INT DEFAULT 1,
brief VARCHAR(100) ,
keywords VARCHAR(100) ,
moderator VARCHAR(60) ,
viewStyle VARCHAR(20) ,
sortField VARCHAR(20) ,
isImageOK CHAR(1) DEFAULT 'T',
isMediaOK CHAR(1) DEFAULT 'F',
isGuestPostOK CHAR(1) DEFAULT 'F',
allowGroups VARCHAR(20) ,
acl VARCHAR(100) ,
ruleCode TEXT ,
headAdCode TEXT ,
footAdCode TEXT ,
state CHAR(1) DEFAULT 'N',
createTime DATETIME,
updateTime DATETIME,
PRIMARY KEY(boardID),
FOREIGN KEY(sectionID)
REFERENCES ejf_section(sectionID));
-- *********************************************************
-- * ejf_topic table
-- * State: N - Normal, C - Closed, R - Recycled
-- * TopScope: 1 - Global, 2 - Section, 3 - Board, N - None
-- * AttachIcon: I - Image, F - Flash, A - Attach
-- *********************************************************
CREATE TABLE ejf_topic(
topicID INT NOT NULL IDENTITY,
boardID INT NOT NULL,
sectionID INT DEFAULT 0,
userID VARCHAR(15) NOT NULL,
nickname VARCHAR(15) ,
remoteIP VARCHAR(25) ,
title VARCHAR(100) NOT NULL,
content TEXT ,
reward SMALLINT DEFAULT 0,
visits INT DEFAULT 0,
replies INT DEFAULT 0,
attaches TINYINT DEFAULT 0,
attachIcon VARCHAR(5) ,
lastPostUser VARCHAR(15) NOT NULL,
lastNickname VARCHAR(15) ,
lastPostTime DATETIME ,
isDigest CHAR(1) DEFAULT 'F',
isReplyNotice CHAR(1) DEFAULT 'F',
isHidePost CHAR(1) DEFAULT 'F',
isSolved CHAR(1) DEFAULT 'F',
topScope CHAR(1) DEFAULT 'N',
topExpireDate DATETIME ,
highColor VARCHAR(6) ,
highExpireDate DATETIME ,
state CHAR(1) DEFAULT 'N',
createTime DATETIME ,
updateTime DATETIME ,
updateUser VARCHAR(15) ,
PRIMARY KEY(topicID),
FOREIGN KEY(boardID)
REFERENCES ejf_board(boardID));
SELECT * INTO ejf_archive_topic FROM ejf_topic;
-- ************************************************
-- * ejf_reply table
-- * State: N - Normal, R - Recycled
-- ************************************************
CREATE TABLE ejf_reply(
replyID INT NOT NULL IDENTITY,
topicID INT NOT NULL,
userID VARCHAR(15) NOT NULL,
remoteIP VARCHAR(25) ,
title VARCHAR(100) ,
content TEXT NOT NULL,
attaches TINYINT DEFAULT 0,
isHidePost CHAR(1) DEFAULT 'F',
isBest CHAR(1) DEFAULT 'F',
state CHAR(1) DEFAULT 'N',
createTime DATETIME,
updateTime DATETIME,
PRIMARY KEY(replyID),
FOREIGN KEY(topicID)
REFERENCES ejf_topic(topicID) ON DELETE CASCADE);
SELECT * INTO ejf_archive_reply FROM ejf_reply;
-- *******************************************************
-- * ejf_attach table
-- * State: N - Normal, I - Image, F - Flash, R - Recycled
-- *******************************************************
CREATE TABLE ejf_attach(
attachID INT NOT NULL IDENTITY,
topicID INT NOT NULL,
replyID INT DEFAULT 0,
userID VARCHAR(15) NOT NULL,
localname VARCHAR(50) NOT NULL,
localID SMALLINT DEFAULT 0,
filename VARCHAR(50) NOT NULL,
filesize INT DEFAULT 0,
credits INT DEFAULT 0,
title VARCHAR(50) ,
downloads INT DEFAULT 0,
state CHAR(1) DEFAULT 'N',
createTime DATETIME,
updateTime DATETIME,
PRIMARY KEY(attachID),
FOREIGN KEY(topicID)
REFERENCES ejf_topic(topicID) ON DELETE CASCADE);
-- ************************************************
-- * ejf_trash_box table
-- ************************************************
CREATE TABLE ejf_trash_box(
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -