UC1.5.1_UCH2.0_DZ7.2_SC_UTF8.zip

-- -------------------------------------------------- -- -- Discuz! SQL file for installation -- $Id: discuz.sql 21303 2009-11-25 23:59:33Z monkey $ -- -- -------------------------------------------------- DROP TABLE IF EXISTS cdb_access; CREATE TABLE cdb_access ( uid mediumint(8) unsigned NOT NULL DEFAULT '0', fid smallint(6) unsigned NOT NULL DEFAULT '0', allowview tinyint(1) NOT NULL DEFAULT '0', allowpost tinyint(1) NOT NULL DEFAULT '0', allowreply tinyint(1) NOT NULL DEFAULT '0', allowgetattach tinyint(1) NOT NULL DEFAULT '0', allowpostattach tinyint(1) NOT NULL DEFAULT '0', adminuser mediumint(8) unsigned NOT NULL DEFAULT '0', dateline int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (uid,fid), KEY listorder (fid,dateline) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_activities; CREATE TABLE cdb_activities ( tid mediumint(8) unsigned NOT NULL DEFAULT '0', uid mediumint(8) unsigned NOT NULL DEFAULT '0', cost mediumint(8) unsigned NOT NULL DEFAULT '0', starttimefrom int(10) unsigned NOT NULL DEFAULT '0', starttimeto int(10) unsigned NOT NULL DEFAULT '0', place char(40) NOT NULL DEFAULT '', class char(20) NOT NULL DEFAULT '', gender tinyint(1) NOT NULL DEFAULT '0', number smallint(5) unsigned NOT NULL DEFAULT '0', expiration int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (tid), KEY uid (uid,starttimefrom) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_activityapplies; CREATE TABLE cdb_activityapplies ( applyid int(10) unsigned NOT NULL AUTO_INCREMENT, tid mediumint(8) unsigned NOT NULL DEFAULT '0', username char(15) NOT NULL DEFAULT '', uid mediumint(8) unsigned NOT NULL DEFAULT '0', message char(200) NOT NULL DEFAULT '', verified tinyint(1) NOT NULL DEFAULT '0', dateline int(10) unsigned NOT NULL DEFAULT '0', payment mediumint(8) NOT NULL DEFAULT '0', contact char(200) NOT NULL, PRIMARY KEY (applyid), KEY uid (uid), KEY tid (tid), KEY dateline (tid,dateline) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_adminactions; CREATE TABLE cdb_adminactions ( admingid smallint(6) unsigned NOT NULL DEFAULT '0', disabledactions text NOT NULL, PRIMARY KEY (admingid) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_admincustom; CREATE TABLE cdb_admincustom ( id smallint(6) unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, url varchar(255) NOT NULL, sort tinyint(1) NOT NULL DEFAULT '0', displayorder tinyint(3) NOT NULL, clicks smallint(6) unsigned NOT NULL DEFAULT '1', uid mediumint(8) unsigned NOT NULL, dateline int(10) unsigned NOT NULL, PRIMARY KEY (id), KEY uid (uid), KEY displayorder (displayorder) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_admingroups; CREATE TABLE cdb_admingroups ( admingid smallint(6) unsigned NOT NULL DEFAULT '0', alloweditpost tinyint(1) NOT NULL DEFAULT '0', alloweditpoll tinyint(1) NOT NULL DEFAULT '0', allowstickthread tinyint(1) NOT NULL DEFAULT '0', allowmodpost tinyint(1) NOT NULL DEFAULT '0', allowdelpost tinyint(1) NOT NULL DEFAULT '0', allowmassprune tinyint(1) NOT NULL DEFAULT '0', allowrefund tinyint(1) NOT NULL DEFAULT '0', allowcensorword tinyint(1) NOT NULL DEFAULT '0', allowviewip tinyint(1) NOT NULL DEFAULT '0', allowbanip tinyint(1) NOT NULL DEFAULT '0', allowedituser tinyint(1) NOT NULL DEFAULT '0', allowmoduser tinyint(1) NOT NULL DEFAULT '0', allowbanuser tinyint(1) NOT NULL DEFAULT '0', allowpostannounce tinyint(1) NOT NULL DEFAULT '0', allowviewlog tinyint(1) NOT NULL DEFAULT '0', allowbanpost tinyint(1) NOT NULL DEFAULT '0', disablepostctrl tinyint(1) NOT NULL DEFAULT '0', supe_allowpushthread tinyint(1) NOT NULL DEFAULT '0', allowhighlightthread tinyint(1) NOT NULL DEFAULT '0', allowdigestthread tinyint(1) NOT NULL DEFAULT '0', allowrecommendthread tinyint(1) NOT NULL DEFAULT '0', allowbumpthread tinyint(1) NOT NULL DEFAULT '0', allowclosethread tinyint(1) NOT NULL DEFAULT '0', allowmovethread tinyint(1) NOT NULL DEFAULT '0', allowedittypethread tinyint(1) NOT NULL DEFAULT '0', allowstampthread tinyint(1) NOT NULL DEFAULT '0', allowcopythread tinyint(1) NOT NULL DEFAULT '0', allowmergethread tinyint(1) NOT NULL DEFAULT '0', allowsplitthread tinyint(1) NOT NULL DEFAULT '0', allowrepairthread tinyint(1) NOT NULL DEFAULT '0', allowwarnpost tinyint(1) NOT NULL DEFAULT '0', allowviewreport tinyint(1) NOT NULL DEFAULT '0', alloweditforum tinyint(1) NOT NULL DEFAULT '0', allowremovereward tinyint(1) NOT NULL DEFAULT '0', allowedittrade tinyint(1) NOT NULL DEFAULT '0', alloweditactivity tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (admingid) ) TYPE=MyISAM; INSERT INTO cdb_admingroups VALUES ('1','1','1','3','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1' ,'1','3','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); INSERT INTO cdb_admingroups VALUES ('2','1','0','2','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0' ,'1','3','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0','0'); INSERT INTO cdb_admingroups VALUES ('3','1','0','1','1','1','0','0','0','1','0','0','1','1','0','1','1','1','0' ,'1','3','1','1','1','1','1','1','1','1','1','1','1','1','1','1','0','0'); DROP TABLE IF EXISTS cdb_adminnotes; CREATE TABLE cdb_adminnotes ( id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, admin varchar(15) NOT NULL DEFAULT '', access tinyint(3) NOT NULL DEFAULT '0', adminid tinyint(3) NOT NULL DEFAULT '0', dateline int(10) unsigned NOT NULL DEFAULT '0', expiration int(10) unsigned NOT NULL DEFAULT '0', message text NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_adminsessions; CREATE TABLE cdb_adminsessions ( uid mediumint(8) unsigned NOT NULL DEFAULT '0', adminid smallint(6) unsigned NOT NULL DEFAULT '0', panel tinyint(1) NOT NULL DEFAULT '0', ip varchar(15) NOT NULL DEFAULT '', dateline int(10) unsigned NOT NULL DEFAULT '0', errorcount tinyint(1) NOT NULL DEFAULT '0', `storage` mediumtext NOT NULL, PRIMARY KEY (uid,panel) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_addons; CREATE TABLE cdb_addons ( `key` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL DEFAULT '', `sitename` varchar(255) NOT NULL DEFAULT '', `siteurl` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `contact` varchar(255) NOT NULL DEFAULT '', `logo` varchar(255) NOT NULL DEFAULT '', `system` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`key`) ) TYPE=MyISAM; INSERT INTO cdb_addons (`key`, `title`, `sitename`, `siteurl`, `description`, `contact`, `logo`, `system`) VALUES ('25z5wh0o00', 'Comsenz', 'Comsenz', 'http://www.comsenz.com', 'Comsenz官方网站推荐的论坛模板与插件', 'ts@comsenz.com', 'http://www.comsenz.com/addon/logo.gif', 1); INSERT INTO cdb_addons (`key`, `title`, `sitename`, `siteurl`, `description`, `contact`, `logo`, `system`) VALUES ('R051uc9D1i', 'DPS', 'DPS', 'http://bbs.7dps.com', '提供 Discuz! 插件与风格，享受一键安装/升级/卸载带来的快感，还提供少量风格。', 'http://bbs.7dps.com/thread-1646-1-1.html', 'http://api.7dps.com/addons/logo.gif', 0); DROP TABLE IF EXISTS cdb_advertisements; CREATE TABLE cdb_advertisements ( advid mediumint(8) unsigned NOT NULL AUTO_INCREMENT, available tinyint(1) NOT NULL DEFAULT '0', `type` varchar(50) NOT NULL DEFAULT '0', displayorder tinyint(3) NOT NULL DEFAULT '0', title varchar(255) NOT NULL DEFAULT '', targets text NOT NULL, parameters text NOT NULL, `code` text NOT NULL, starttime int(10) unsigned NOT NULL DEFAULT '0', endtime int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (advid) ) TYPE=MyISAM; DROP TABLE IF EXISTS cdb_announcements; CREATE TABLE cdb_announcements ( id smallint(6) unsigned NOT NULL AUTO_INCREMENT, author varchar(15