📄 discuz.sql
字号:
DROP TABLE IF EXISTS cdb_buddys;
CREATE TABLE cdb_buddys (
uid mediumint(8) unsigned NOT NULL default '0',
buddyid mediumint(8) unsigned NOT NULL default '0',
grade tinyint(3) unsigned NOT NULL default '1',
dateline int(10) unsigned NOT NULL default '0',
description char(255) NOT NULL default '',
KEY uid (uid)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_buddys`
--
-- --------------------------------------------------------
--
-- 表的结构 `cdb_creditslog`
--
DROP TABLE IF EXISTS cdb_creditslog;
CREATE TABLE cdb_creditslog (
uid mediumint(8) unsigned NOT NULL default '0',
fromto char(15) NOT NULL default '',
sendcredits tinyint(1) NOT NULL default '0',
receivecredits tinyint(1) NOT NULL default '0',
send int(10) unsigned NOT NULL default '0',
receive int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
operation char(3) NOT NULL default '',
KEY uid (uid,dateline)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_creditslog`
--
-- --------------------------------------------------------
--
-- 表的结构 `cdb_crons`
--
DROP TABLE IF EXISTS cdb_crons;
CREATE TABLE cdb_crons (
cronid smallint(6) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '0',
`type` enum('user','system') NOT NULL default 'user',
`name` char(50) NOT NULL default '',
filename char(50) NOT NULL default '',
lastrun int(10) unsigned NOT NULL default '0',
nextrun int(10) unsigned NOT NULL default '0',
weekday tinyint(1) NOT NULL default '0',
`day` tinyint(2) NOT NULL default '0',
`hour` tinyint(2) NOT NULL default '0',
`minute` char(36) NOT NULL default '',
PRIMARY KEY (cronid),
KEY nextrun (available,nextrun)
) TYPE=MyISAM AUTO_INCREMENT=12;
--
-- 导出表中的数据 `cdb_crons`
--
INSERT INTO cdb_crons VALUES (1, 1, 'system', '清空今日发帖数', 'todayposts_daily.inc.php', 0, 1150357741, -1, -1, 0, '0');
INSERT INTO cdb_crons VALUES (2, 1, 'system', '清空本月在线时间', 'onlinetime_monthly.inc.php', 0, 1150357741, -1, 1, 0, '0');
INSERT INTO cdb_crons VALUES (3, 1, 'system', '每日数据清理', 'cleanup_daily.inc.php', 0, 1150357741, -1, -1, 5, '30');
INSERT INTO cdb_crons VALUES (4, 1, 'system', '生日统计与邮件祝福', 'birthdays_daily.inc.php', 0, 1150357741, -1, -1, 0, '0');
INSERT INTO cdb_crons VALUES (5, 1, 'system', '主题回复通知', 'notify_daily.inc.php', 0, 1150357741, -1, -1, 5, '00');
INSERT INTO cdb_crons VALUES (6, 1, 'system', '每日公告清理', 'announcements_daily.inc.php', 0, 1150357741, -1, -1, 0, '0');
INSERT INTO cdb_crons VALUES (7, 1, 'system', '限时操作清理', 'threadexpiries_daily.inc.php', 0, 1150357741, -1, -1, 5, '0');
INSERT INTO cdb_crons VALUES (8, 1, 'system', '论坛推广清理', 'promotions_hourly.inc.php', 0, 1150357741, -1, -1, 0, '00');
INSERT INTO cdb_crons VALUES (9, 1, 'system', '每月主题清理', 'cleanup_monthly.inc.php', 0, 1150357741, -1, 1, 6, '00');
INSERT INTO cdb_crons VALUES (10, 1, 'system', '每日热门 X-Space 用户', 'supe_daily.inc.php', 0, 1150357741, -1, -1, 0, '0');
INSERT INTO cdb_crons VALUES (11, 1, 'system', '每周主题更新', 'pushthreads_weekly.inc.php', 0, 1150357741, 1, -1, 4, '0');
-- --------------------------------------------------------
--
-- 表的结构 `cdb_failedlogins`
--
DROP TABLE IF EXISTS cdb_failedlogins;
CREATE TABLE cdb_failedlogins (
ip char(15) NOT NULL default '',
count tinyint(1) unsigned NOT NULL default '0',
lastupdate int(10) unsigned NOT NULL default '0',
PRIMARY KEY (ip)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_failedlogins`
--
-- --------------------------------------------------------
--
-- 表的结构 `cdb_favorites`
--
DROP TABLE IF EXISTS cdb_favorites;
CREATE TABLE cdb_favorites (
uid mediumint(8) unsigned NOT NULL default '0',
tid mediumint(8) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
KEY uid (uid)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_favorites`
--
-- --------------------------------------------------------
--
-- 表的结构 `cdb_forumfields`
--
DROP TABLE IF EXISTS cdb_forumfields;
CREATE TABLE cdb_forumfields (
fid smallint(6) unsigned NOT NULL default '0',
description text NOT NULL,
`password` varchar(12) NOT NULL default '',
icon varchar(255) NOT NULL default '',
postcredits varchar(255) NOT NULL default '',
replycredits varchar(255) NOT NULL default '',
getattachcredits varchar(255) NOT NULL default '',
postattachcredits varchar(255) NOT NULL default '',
digestcredits varchar(255) NOT NULL default '',
redirect varchar(255) NOT NULL default '',
attachextensions varchar(255) NOT NULL default '',
moderators text NOT NULL,
rules text NOT NULL,
threadtypes text NOT NULL,
viewperm text NOT NULL,
postperm text NOT NULL,
replyperm text NOT NULL,
getattachperm text NOT NULL,
postattachperm text NOT NULL,
supe_pushsetting text NOT NULL,
PRIMARY KEY (fid)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_forumfields`
--
INSERT INTO cdb_forumfields VALUES (1, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO cdb_forumfields VALUES (2, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- 表的结构 `cdb_forumlinks`
--
DROP TABLE IF EXISTS cdb_forumlinks;
CREATE TABLE cdb_forumlinks (
id smallint(6) unsigned NOT NULL auto_increment,
displayorder tinyint(3) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
url varchar(100) NOT NULL default '',
note varchar(200) NOT NULL default '',
logo varchar(100) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_forumlinks`
--
INSERT INTO cdb_forumlinks VALUES (1, 0, 'Discuz! 官方论坛', 'http://www.discuz.com', '提供最新 Discuz! 产品新闻、软件下载与技术交流', 'images/logo.gif');
-- --------------------------------------------------------
--
-- 表的结构 `cdb_forums`
--
DROP TABLE IF EXISTS cdb_forums;
CREATE TABLE cdb_forums (
fid smallint(6) unsigned NOT NULL auto_increment,
fup smallint(6) unsigned NOT NULL default '0',
`type` enum('group','forum','sub') NOT NULL default 'forum',
`name` char(50) NOT NULL default '',
`status` tinyint(1) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
threads mediumint(8) unsigned NOT NULL default '0',
posts mediumint(8) unsigned NOT NULL default '0',
todayposts mediumint(8) unsigned NOT NULL default '0',
lastpost char(110) NOT NULL default '',
allowsmilies tinyint(1) NOT NULL default '0',
allowhtml tinyint(1) NOT NULL default '0',
allowbbcode tinyint(1) NOT NULL default '0',
allowimgcode tinyint(1) NOT NULL default '0',
allowanonymous tinyint(1) NOT NULL default '0',
allowshare tinyint(1) NOT NULL default '0',
allowpostspecial tinyint(1) NOT NULL default '15',
alloweditrules tinyint(1) NOT NULL default '0',
recyclebin tinyint(1) NOT NULL default '0',
modnewposts tinyint(1) NOT NULL default '0',
jammer tinyint(1) NOT NULL default '0',
disablewatermark tinyint(1) NOT NULL default '0',
inheritedmod tinyint(1) NOT NULL default '0',
autoclose smallint(6) NOT NULL default '0',
forumcolumns tinyint(3) unsigned NOT NULL default '0',
threadcaches tinyint(1) NOT NULL default '0',
allowpaytoauthor tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (fid),
KEY forum (`status`,`type`,displayorder),
KEY fup (fup)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_forums`
--
INSERT INTO cdb_forums VALUES (1, 0, 'group', 'Discuz!', 1, 0, 0, 0, 0, 0, '', 0, 0, 1, 1, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO cdb_forums VALUES (2, 1, 'forum', '默认论坛', 1, 0, 0, 0, 0, 0, '', 1, 0, 1, 1, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
-- --------------------------------------------------------
--
-- 表的结构 `cdb_medals`
--
DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_medals (
medalid smallint(6) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
available tinyint(1) NOT NULL default '0',
image varchar(30) NOT NULL default '',
PRIMARY KEY (medalid)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_medals`
--
INSERT INTO cdb_medals VALUES (1, 'Medal No.1', 0, 'medal1.gif');
INSERT INTO cdb_medals VALUES (2, 'Medal No.2', 0, 'medal2.gif');
INSERT INTO cdb_medals VALUES (3, 'Medal No.3', 0, 'medal3.gif');
INSERT INTO cdb_medals VALUES (4, 'Medal No.4', 0, 'medal4.gif');
INSERT INTO cdb_medals VALUES (5, 'Medal No.5', 0, 'medal5.gif');
INSERT INTO cdb_medals VALUES (6, 'Medal No.6', 0, 'medal6.gif');
INSERT INTO cdb_medals VALUES (7, 'Medal No.7', 0, 'medal7.gif');
INSERT INTO cdb_medals VALUES (8, 'Medal No.8', 0, 'medal8.gif');
INSERT INTO cdb_medals VALUES (9, 'Medal No.9', 0, 'medal9.gif');
INSERT INTO cdb_medals VALUES (10, 'Medal No.10', 0, 'medal10.gif');
-- --------------------------------------------------------
--
-- 表的结构 `cdb_memberfields`
--
DROP TABLE IF EXISTS cdb_memberfields;
CREATE TABLE cdb_memberfields (
uid mediumint(8) unsigned NOT NULL default '0',
nickname varchar(30) NOT NULL default '',
site varchar(75) NOT NULL default '',
alipay varchar(50) NOT NULL default '',
icq varchar(12) NOT NULL default '',
qq varchar(12) NOT NULL default '',
yahoo varchar(40) NOT NULL default '',
msn varchar(40) NOT NULL default '',
taobao varchar(40) NOT NULL default '',
location varchar(30) NOT NULL default '',
customstatus varchar(30) NOT NULL default '',
medals varchar(255) NOT NULL default '',
avatar varchar(255) NOT NULL default '',
avatarwidth tinyint(3) unsigned NOT NULL default '0',
avatarheight tinyint(3) unsigned NOT NULL default '0',
bio text NOT NULL,
signature text NOT NULL,
sightml text NOT NULL,
ignorepm text NOT NULL,
groupterms text NOT NULL,
authstr varchar(20) NOT NULL default '',
PRIMARY KEY (uid)
) TYPE=MyISAM;
--
-- 导出表中的数据 `cdb_memberfields`
--
INSERT INTO cdb_memberfields VALUES (1, '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- 表的结构 `cdb_members`
--
DROP TABLE IF EXISTS cdb_members;
CREATE TABLE cdb_members (
uid mediumint(8) unsigned NOT NULL auto_increment,
username char(15) NOT NULL default '',
`password` char(32) NOT NULL default '',
secques char(8) NOT NULL default '',
gender tinyint(1) NOT NULL default '0',
adminid tinyint(1) NOT NULL default '0',
groupid smallint(6) unsigned NOT NULL default '0',
groupexpiry int(10) unsigned NOT NULL default '0',
extgroupids char(60) NOT NULL default '',
regip char(15) NOT NULL default '',
regdate int(10) unsigned NOT NULL default '0',
lastip char(15) NOT NULL default '',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
posts mediumint(8) unsigned NOT NULL default '0',
digestposts smallint(6) unsigned NOT NULL default '0',
oltime smallint(6) unsigned NOT NULL default '0',
pageviews mediumint(8) unsigned NOT NULL default '0',
credits int(10) NOT NULL default '0',
extcredits1 int(10) NOT NULL default '0',
extcredits2 int(10) NOT NULL default '0',
extcredits3 int(10) NOT NULL default '0',
extcredits4 int(10) NOT NULL default '0',
extcredits5 int(10) NOT NULL default '0',
extcredits6 int(10) NOT NULL default '0',
extcredits7 int(10) NOT NULL default '0',
extcredits8 int(10) NOT NULL default '0',
avatarshowid int(10) unsigned NOT NULL default '0',
email char(50) NOT NULL default '',
bday date NOT NULL default '0000-00-00',
sigstatus tinyint(1) NOT NULL default '0',
tpp tinyint(3) unsigned NOT NULL default '0',
ppp tinyint(3) unsigned NOT NULL default '0',
styleid smallint(6) unsigned NOT NULL default '0',
dateformat char(10) NOT NULL default '',
timeformat tinyint(1) NOT NULL default '0',
pmsound tinyint(1) NOT NULL default '0',
showemail tinyint(1) NOT NULL default '0',
newsletter tinyint(1) NOT NULL default '0',
invisible tinyint(1) NOT NULL default '0',
timeoffset char(4) NOT NULL default '',
newpm tinyint(1) NOT NULL default '0',
accessmasks tinyint(1) NOT NULL default '0',
editormode tinyint(1) unsigned NOT NULL default '2',
customshow tinyint(1) unsigned NOT NULL default '26',
xspacestatus tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid),
UNIQUE KEY username (username),
KEY email (email)
) TYPE=MyISAM;
--
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -