📄 cwbbs.sql
字号:
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cwbbs`;
USE `cwbbs`;
CREATE TABLE `bc` (
`ID` int(11) NOT NULL auto_increment,
`bc` varchar(50) default NULL,
`count` int(11) default NULL,
`todays` int(11) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `blog` (
`id` int(11) NOT NULL default '0',
`blogCount` int(11) NOT NULL default '0',
`newBlogUserName` varchar(20) default NULL,
`topicCount` int(11) NOT NULL default '0',
`postCount` int(11) NOT NULL default '0',
`todayCount` int(11) NOT NULL default '0',
`todayDate` varchar(15) NOT NULL default '',
`yestodayCount` int(11) NOT NULL default '0',
`maxCount` int(11) NOT NULL default '0',
`maxDate` varchar(15) NOT NULL default '',
`star` varchar(20) default NULL,
`homeClasses` varchar(255) default NULL,
`recommandBlogs` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `blog` (`id`,`blogCount`,`newBlogUserName`,`topicCount`,`postCount`,`todayCount`,`todayDate`,`yestodayCount`,`maxCount`,`maxDate`,`star`,`homeClasses`,`recommandBlogs`) VALUES (1,0,'',0,0,0,'2006-01-12',0,0,'2005-10-02','','wx,keji,yishu,trap,teach,movie,sport','');
CREATE TABLE `blog_directory` (
`code` varchar(50) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`isHome` tinyint(1) NOT NULL default '0',
`description` varchar(100) default NULL,
`parent_code` varchar(20) NOT NULL default '',
`root_code` varchar(20) NOT NULL default '',
`orders` int(11) NOT NULL default '1',
`child_count` int(11) default '0',
`add_date` varchar(15) NOT NULL default '',
`islocked` tinyint(1) default NULL,
`type` tinyint(3) unsigned default NULL,
`layer` int(11) NOT NULL default '0',
`doc_id` int(11) default NULL,
`template_id` int(11) NOT NULL default '-1',
`pluginCode` varchar(50) NOT NULL default 'N''default''',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `blog_directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`) VALUES ('cuzhong','初中',0,'','teach','root',2,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('dance','舞蹈',0,'','yishu','root',1,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('daxue','大学',0,'','teach','root',4,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('dianzi','电子',0,'','keji','root',1,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('donghua','动画',0,'','movie','root',3,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('football','足球',0,'','sport','root',1,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('gaozhong','高中',0,'','teach','root',3,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('gc','歌唱',0,'','yishu','root',2,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('keji','科技博客',1,'','root','root',2,3,'0',NULL,0,2,NULL,-1,'N\'default\''),('lanqiu','篮球',0,'','sport','root',2,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('movie','电影博客',0,'','root','root',6,5,'0',NULL,0,2,NULL,-1,'N\'default\''),('msdc','名山大川',0,'','trap','root',1,0,'0',NULL,2,3,NULL,-1,'N\'default\'');
INSERT INTO `blog_directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`) VALUES ('paint','绘画',0,'','yishu','root',5,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('paiqiu','排球',0,'','sport','root',3,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('pinpangqiu','乒乓球',0,'','sport','root',4,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('program','程序',0,'','keji','root',3,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('qiangzhan','枪战',0,'','movie','root',5,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('root','全部分类',0,NULL,'-1','root',1,7,'0',NULL,0,1,NULL,-1,'N\'default\''),('sanwen','散文',1,'','wx','root',1,0,'0',NULL,2,3,0,-1,'N\'default\''),('sheji','射击',0,'','sport','root',6,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('sheyin','摄影',0,'','yishu','root',4,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('shige','诗歌',1,'','wx','root',2,0,'0',NULL,2,3,0,-1,'N\'default\''),('shougong','手工',0,'','yishu','root',3,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('shuma','数码',0,'','keji','root',2,0,'0',NULL,2,3,NULL,-1,'N\'default\'');
INSERT INTO `blog_directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`) VALUES ('sport','体育博客',0,'','root','root',7,7,'0',NULL,0,2,NULL,-1,'N\'default\''),('sport_other','其它',0,'','sport','root',7,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('teach','教育博客',0,'','root','root',5,4,'0',NULL,0,2,NULL,-1,'N\'default\''),('trap','旅游博客',0,'','root','root',4,3,'0',NULL,0,2,NULL,-1,'N\'default\''),('tyfg','田园风光',0,'','trap','root',3,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('war','战争',0,'','movie','root',2,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('wuda','武打',0,'','movie','root',4,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('wx','文学博客',0,'','root','root',1,3,'0',NULL,0,2,0,-1,'N\'default\''),('xiaoshuo','小说',0,'','wx','root',3,0,'0',NULL,2,3,0,-1,'N\'default\''),('xiaoxue','小学',0,'','teach','root',1,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('xtrq','乡土人情',0,'','trap','root',2,0,'0',NULL,2,3,NULL,-1,'N\'default\'');
INSERT INTO `blog_directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`) VALUES ('yanqin','言情',0,'','movie','root',1,0,'0',NULL,2,3,NULL,-1,'N\'default\''),('yishu','艺术博客',0,'','root','root',3,5,'0',NULL,0,2,NULL,-1,'N\'default\''),('youyong','游泳',0,'','sport','root',5,0,'0',NULL,2,3,NULL,-1,'N\'default\'');
CREATE TABLE `blog_user_config` (
`userName` varchar(50) NOT NULL default '',
`title` varchar(50) NOT NULL default '',
`subtitle` varchar(50) default NULL,
`penName` varchar(50) NOT NULL default '',
`skin` varchar(50) NOT NULL default 'default',
`notice` text NOT NULL,
`addDate` varchar(15) NOT NULL default '',
`isValid` tinyint(1) NOT NULL default '1',
`viewCount` int(11) NOT NULL default '0',
`msgCount` int(11) NOT NULL default '0',
`replyCount` int(11) NOT NULL default '0',
`kind` varchar(50) NOT NULL default '',
PRIMARY KEY (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `blog_user_dir` (
`code` varchar(50) NOT NULL default '',
`userName` varchar(50) NOT NULL default '',
`dirName` varchar(250) NOT NULL default '',
`catalogCode` varchar(50) NOT NULL default 'N''default''',
`sort` int(11) NOT NULL default '0',
`color` varchar(20) default NULL,
`addDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`code`),
KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cms_images` (
`id` int(11) NOT NULL default '0',
`path` varchar(255) NOT NULL default '',
`mainkey` varchar(20) NOT NULL default '',
`kind` varchar(20) NOT NULL default '',
`subkey` int(11) NOT NULL default '1',
`visualPath` varchar(200) default NULL,
PRIMARY KEY (`id`),
KEY `IX_images` (`mainkey`),
KEY `IX_images_1` (`kind`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `cms_images` (`id`,`path`,`mainkey`,`kind`,`subkey`,`visualPath`) VALUES (10,'upfile/webeditimg/2006/8/2357ddd8a4354a8b82292978ec6821f6.jpg','1','document',1,NULL),(11,'upfile/webeditimg/2006/8/528e140122ca4930a85d31ca942a0ab3.jpg','2','document',1,NULL),(12,'upfile/webeditimg/2006/8/96ede6606c104816bc9f7a6722929a9c.jpg','3','document',1,NULL);
CREATE TABLE `comment` (
`id` bigint(11) NOT NULL default '0',
`content` text NOT NULL,
`add_date` varchar(15) NOT NULL default '',
`doc_id` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`nick` varchar(50) default NULL,
`link` varchar(100) default NULL,
PRIMARY KEY (`id`),
KEY `IX_comment` (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `count` (
`ID` int(11) NOT NULL default '0',
`PageCount` int(11) default NULL,
`DayMax` int(11) default NULL,
`AllCount` int(11) default NULL,
`ToDayCount` int(11) default NULL,
`LogDate` datetime default NULL,
`StartDate` date default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `count` (`ID`,`PageCount`,`DayMax`,`AllCount`,`ToDayCount`,`LogDate`,`StartDate`) VALUES (0,0,0,0,0,'2006-10-27 10:44:54','0000-00-00');
CREATE TABLE `daycount` (
`ID` int(11) NOT NULL default '0',
`0` int(11) default NULL,
`1` int(11) default NULL,
`2` int(11) default NULL,
`3` int(11) default NULL,
`4` int(11) default NULL,
`5` int(11) default NULL,
`6` int(11) default NULL,
`7` int(11) default NULL,
`8` int(11) default NULL,
`9` int(11) default NULL,
`10` int(11) default NULL,
`11` int(11) default NULL,
`12` int(11) default NULL,
`13` int(11) default NULL,
`14` int(11) default NULL,
`15` int(11) default NULL,
`16` int(11) default NULL,
`17` int(11) default NULL,
`18` int(11) default NULL,
`19` int(11) default NULL,
`20` int(11) default NULL,
`21` int(11) default NULL,
`22` int(11) default NULL,
`23` int(11) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `dir_priv` (
`id` int(11) NOT NULL auto_increment,
`dir_code` varchar(50) NOT NULL default '',
`see` tinyint(1) NOT NULL default '1',
`append` tinyint(1) NOT NULL default '0',
`del` tinyint(1) NOT NULL default '0',
`modify` tinyint(1) NOT NULL default '0',
`examine` tinyint(1) NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`type` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `IX_dir_priv` (`dir_code`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `dir_priv` (`id`,`dir_code`,`see`,`append`,`del`,`modify`,`examine`,`name`,`type`) VALUES (1,'blog_ad',1,0,0,0,0,'Everyone',0),(2,'blog_ad1',1,0,0,0,0,'Everyone',0),(3,'blog_ad2',1,0,0,0,0,'Everyone',0),(4,'blog_ad3',1,0,0,0,0,'Everyone',0),(5,'blog_ad4',1,0,0,0,0,'Everyone',0),(13,'z',1,0,0,0,0,'Everyone',0);
CREATE TABLE `directory` (
`code` varchar(20) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`isHome` tinyint(1) NOT NULL default '0',
`description` varchar(100) default NULL,
`parent_code` varchar(20) NOT NULL default '',
`root_code` varchar(20) NOT NULL default '',
`orders` int(11) NOT NULL default '0',
`child_count` int(11) default NULL,
`add_date` varchar(15) NOT NULL default '',
`islocked` tinyint(1) default NULL,
`type` tinyint(3) unsigned default NULL,
`layer` int(11) NOT NULL default '0',
`doc_id` int(11) default NULL,
`template_id` int(11) NOT NULL default '-1',
`pluginCode` varchar(50) NOT NULL default 'default',
`price` decimal(19,2) default NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`price`) VALUES ('article','文章系统',0,'','root','root',3,0,'1154857963109',NULL,0,2,0,-1,'default','0.00'),('blog','博客',0,'','root','root',4,2,'1154857963109',NULL,0,2,NULL,-1,'default',NULL),('blog_ad','广告',0,'','blog','root',2,4,'1154857963109',NULL,0,3,NULL,-1,'default','0.00'),('blog_ad1','公告旁的广告',0,'公告旁的广告','blog_ad','root',1,0,'1154857963109',NULL,1,4,1,-1,'default','0.00'),('blog_ad2','首页中部横幅',0,'','blog_ad','root',2,0,'1154857963109',NULL,1,4,2,-1,'default','0.00'),('blog_ad3','首页底部横幅',0,'','blog_ad','root',3,0,'1154857963109',NULL,1,4,3,-1,'default','0.00'),('blog_ad4','首页右下角部',0,'','blog_ad','root',4,0,'1154857963109',NULL,1,4,NULL,-1,'default','0.00'),('blog_notice','博客公告',0,'','blog','root',1,0,'1154857963109',NULL,2,3,NULL,-1,'default',NULL),('bmfu','便民服务',0,'','shop','root',8,0,'1154857963109',NULL,1,4,NULL,-1,'default','0.00');
INSERT INTO `directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`price`) VALUES ('email','邮件',0,'','template','root',1,0,'1154857963109',NULL,2,3,0,-1,'default','0.00'),('home','首页',0,'首页','root','root',1,1,'1154857963109',NULL,0,2,NULL,-1,'default',NULL),('photo','社区推荐图片',0,'','shop','root',7,0,'1154857963109',NULL,1,4,NULL,-1,'default',NULL),('recommandAuction1','推荐商品1',0,'','shop','root',3,0,'1154857963109',NULL,1,4,NULL,-1,'default',NULL),('recommandAuction2','推荐商品2',0,'','shop','root',4,0,'1154857963109',NULL,1,4,NULL,-1,'default',NULL),('recommandAuction3','推荐商品3',0,'','shop','root',5,0,'1154857963109',NULL,1,4,NULL,-1,'default',NULL),('recommandShop','推荐商店',0,'','shop','root',1,0,'1154857963109',NULL,1,4,5,-1,'default','0.00'),('root','全部栏目',0,NULL,'-1','root',1,4,'1154857963109',0,0,1,NULL,-1,'default',NULL),('shop','商店',0,'','home','root',1,8,'1154857963109',NULL,0,3,NULL,-1,'default',NULL);
INSERT INTO `directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`price`) VALUES ('star','社区之星',0,'','shop','root',6,0,'1154857963109',NULL,1,4,NULL,-1,'default',NULL),('starShop','明星店铺',0,'','shop','root',2,0,'1154857963109',NULL,1,4,NULL,-1,'default',NULL),('template','模板',0,'','root','root',2,1,'1154857963109',NULL,0,2,0,-1,'default','0.00'),('z','z',0,'z','dd','root',1,0,'1159243676546',NULL,2,5,0,-1,'default','0.00');
CREATE TABLE `doc_content` (
`doc_id` int(11) NOT NULL default '0',
`content` longtext NOT NULL,
`page_num` int(11) NOT NULL default '1',
UNIQUE KEY `IX_doc_content_1` (`doc_id`,`page_num`),
KEY `IX_doc_content` (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `doc_content` (`doc_id`,`content`,`page_num`) VALUES (1,'<IMG height=150 src=\"upfile/webeditimg/2006/8/2357ddd8a4354a8b82292978ec6821f6.jpg\" width=554>',1),(2,'<IMG height=104 src=\"upfile/webeditimg/2006/8/528e140122ca4930a85d31ca942a0ab3.jpg\" width=879>',1),(3,'<IMG height=104 src=\"upfile/webeditimg/2006/8/96ede6606c104816bc9f7a6722929a9c.jpg\" width=879>',1),(4,' ',1);
CREATE TABLE `document` (
`id` int(11) NOT NULL default '0',
`keywords` varchar(50) default NULL,
`isrelateshow` tinyint(1) default '1',
`title` varchar(100) NOT NULL default '',
`class1` varchar(50) NOT NULL default '',
`author` varchar(100) default NULL,
`modifiedDate` varchar(15) NOT NULL default '',
`can_comment` tinyint(1) NOT NULL default '0',
`summary` text,
`isHome` tinyint(1) NOT NULL default '0',
`voteoption` varchar(250) default NULL,
`voteresult` varchar(50) default NULL,
`type` tinyint(3) unsigned NOT NULL default '0',
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -