📄 cwbbs.sql
字号:
`frendSalary` varchar(20) default NULL,
`frendRequire` text,
`manager` varchar(50) default NULL,
`isChecked` tinyint(1) NOT NULL default '0',
`member` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `privilege` (
`priv` varchar(20) NOT NULL default '',
`description` varchar(50) NOT NULL default '',
`isSystem` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`priv`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `privilege` (`priv`,`description`,`isSystem`) VALUES ('admin','管理员权限',1),('auction','拍卖管理',0),('backup','备份操作',1),('chat','聊天管理',1),('email','Email 群发',1),('forum','论坛总管理',1),('forum.bak','论坛数据备份',1),('forum.boardmanager','分配版主',1),('forum.message','论坛贴子操作',1),('forum.plugin','论坛插件管理',1),('forum.user','论坛用户管理',1),('user','管理用户',1);
CREATE TABLE `sq_board` (
`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 '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',
`add_id` int(11) default NULL,
`logo` varchar(50) default NULL,
`today_count` int(11) NOT NULL default '0',
`today_date` varchar(15) NOT NULL default '',
`topic_count` int(11) NOT NULL default '0',
`post_count` int(11) NOT NULL default '0',
`theme` varchar(20) default 'N''default''',
`skin` varchar(20) default NULL,
`boardRule` text,
`color` varchar(15) default NULL,
`webeditAllowType` int(11) NOT NULL default '2',
`plugin2Code` varchar(20) default NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_board` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`add_id`,`logo`,`today_count`,`today_date`,`topic_count`,`post_count`,`theme`,`skin`,`boardRule`,`color`,`webeditAllowType`,`plugin2Code`) VALUES ('alipay','支付宝交易',1,'支付宝交易','dssh','root',6,0,'1154847835015',0,1,3,0,'11548480623432099878744.gif',0,'1160955855062',0,0,'','','','',2,'alipay'),('blog','博客',0,'','hidden','root',1,0,'0',0,1,3,0,'',0,'1161823780234',0,0,'default','default','','',2,''),('bzjl','版主交流',1,'斑竹聚会，讨论交流。','社区管理','root',2,1,'0',0,1,3,0,'1154826091734217518162.gif',0,'1160955855718',0,0,'default','default','asdfsafd','',2,''),('bzjlsecret','版主议事厅',1,'只有版主才能进入','bzjl','root',1,0,'0',0,1,4,0,'',0,'1154445401359',2,9,'default','default','','',2,NULL),('dssh','都市生活',1,'缤纷都市，多彩生活。','root','root',1,8,'0',0,0,2,0,'',0,'1154445401359',0,0,'default','default','','',2,'alipay'),('hidden','隐藏版块区',0,'','root','root',3,1,'0',0,0,2,0,'',0,'1154445401359',0,0,'default','default',NULL,'',2,NULL);
INSERT INTO `sq_board` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`add_id`,`logo`,`today_count`,`today_date`,`topic_count`,`post_count`,`theme`,`skin`,`boardRule`,`color`,`webeditAllowType`,`plugin2Code`) VALUES ('info','百姓信息',1,'分类信息列表，方便百姓生活','dssh','root',5,0,'0',0,1,3,0,'11548267085931412002470.gif',0,'1160955854953',0,0,'default','default','','',2,''),('master','总版主议事厅',1,'暂时公开，过段时间加密本版','sqzw','root',1,0,'0',0,1,4,0,'',0,'1154445401359',4,9,'default','default','','',2,NULL),('qrl','佳人有约',1,'特色版块，虚拟家园','dssh','root',3,0,'0',0,1,3,0,'11548260147962138883725.gif',0,'1160955854328',0,0,'sweet','sweet','','',2,''),('reward','悬赏解决问题',1,'悬赏解决问题','dssh','root',7,0,'1160798528484',0,1,3,0,'',0,'1161916542593',0,0,'','','','',2,''),('root','全部版块',1,'','-1','root',1,3,'0',0,0,1,0,NULL,0,'1154445401359',0,0,'default','default',NULL,NULL,2,NULL),('sqzw','社区站务',1,'社区站务，欢迎大家来讨论社区建设','社区管理','root',1,1,'0',0,1,3,0,'1154825978859468072104.gif',0,'1161823780312',0,0,'','','<STRONG><FONT color=#e9397f>请大家在此提出对“云网论坛”的意见和建议！本论坛目前尚处于测试期，欢迎大家多多批评和指导！</FONT></STRONG>','',4,'');
INSERT INTO `sq_board` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`add_id`,`logo`,`today_count`,`today_date`,`topic_count`,`post_count`,`theme`,`skin`,`boardRule`,`color`,`webeditAllowType`,`plugin2Code`) VALUES ('test','test',1,'test','dssh','root',8,0,'1160891958500',0,1,3,0,'',0,'1160955855281',0,0,'','','','',2,''),('trade','同城交易',1,'同城交易，安全放心','dssh','root',4,0,'0',0,1,3,0,'1154826755984210275085.gif',0,'1160955854843',0,0,'','','<P><STRONG><FONT style=\"BACKGROUND-COLOR: #ffffff\" color=#875dc4>1、开店方法：点击<U><FONT color=#ff0000>我要开店</FONT></U>，填写简单的信息提交，建好店后，在版块中发贴，就可以发布商品，并且同步在店铺的首页中显示出来。<FONT style=\"BACKGROUND-COLOR: #ff0000\" color=#eeeeee>注意：一个贴子对应一件商品</FONT>。管理店铺的入口，在您的小店的首页面上。<BR>2、如果您的店铺要发布公告，请在百姓信息版块中发贴，发贴以后会自动显示在您的店面上。<BR>3、另外，店铺支持二级域名，您可以在其它地方通过二级域名做友情链接</FONT></STRONG></P>','#ee0005',2,''),('社区管理','社区管理',1,'','root','root',2,2,'0',NULL,0,2,0,NULL,0,'1154445401359',0,0,'default','default',NULL,NULL,2,NULL);
CREATE TABLE `sq_board_entrance` (
`boardCode` varchar(50) NOT NULL default '',
`entranceCode` varchar(50) NOT NULL default '',
UNIQUE KEY `IX_sq_board_entrance` (`boardCode`,`entranceCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_board_score` (
`boardCode` varchar(50) NOT NULL default '',
`scoreCode` varchar(50) NOT NULL default '',
UNIQUE KEY `IX_sq_board_score` (`boardCode`,`scoreCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_boardmanager` (
`name` varchar(20) NOT NULL default '',
`boardcode` varchar(20) NOT NULL default '',
`sort` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`name`,`boardcode`),
KEY `name` (`name`),
CONSTRAINT `sq_user_name` FOREIGN KEY (`name`) REFERENCES `sq_user` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_boardrender` (
`boardCode` varchar(20) NOT NULL default '',
`renderCode` varchar(20) NOT NULL default '',
KEY `IX_render` (`boardCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_boardrender` (`boardCode`,`renderCode`) VALUES ('qrl','sweet');
CREATE TABLE `sq_chatroom` (
`id` int(11) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`description` varchar(255) default NULL,
`expire` varchar(15) default NULL,
`sort` int(11) NOT NULL default '0',
`topic` varchar(250) default NULL,
`peopleNum` int(11) NOT NULL default '100',
`playMusic` tinyint(1) NOT NULL default '0',
`isopen` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`name`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_chatroom` (`id`,`name`,`description`,`expire`,`sort`,`topic`,`peopleNum`,`playMusic`,`isopen`) VALUES (25,'一网情深',NULL,NULL,0,'一网情深',100,0,1),(11,'不见不散',NULL,NULL,0,'不见不散',100,0,1),(28,'佳人有约',NULL,NULL,0,'佳人有约',100,1,1),(22,'南国红豆屋',NULL,NULL,0,'南国红豆屋',100,1,1),(21,'天若有情',NULL,NULL,0,'天若有情',100,1,1),(18,'开心小屋',NULL,NULL,0,'开心小屋',100,1,1),(20,'情人酒吧',NULL,NULL,0,'情人酒吧',100,1,1),(19,'生于七十年代',NULL,NULL,0,'生于七十年代',100,1,1),(29,'相思网络中',NULL,NULL,0,'相思网络中',100,1,1),(26,'红粉知己',NULL,NULL,0,'红粉知己',100,1,1),(16,'缘份的天空',NULL,NULL,0,'缘份的天空',100,1,1),(14,'英语聊天室',NULL,NULL,0,'英语聊天室',100,1,1),(17,'菁菁校园',NULL,NULL,0,'菁菁校园',100,1,1),(27,'菩提树下',NULL,NULL,0,'菩提树下',100,1,1);
CREATE TABLE `sq_classmaster` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`classcode` varchar(20) NOT NULL default '',
`sort` int(11) NOT NULL default '0',
PRIMARY KEY (`name`),
KEY `id` (`id`),
CONSTRAINT `sq_classmaster_ibfk_2` FOREIGN KEY (`name`) REFERENCES `sq_user` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_forbid_ip` (
`ip` varchar(15) NOT NULL default '',
`user_name` varchar(20) default NULL,
`add_date` varchar(15) default NULL,
`reason` varchar(255) default NULL,
PRIMARY KEY (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_forbid_ip_range` (
`id` int(11) NOT NULL default '0',
`begin` varchar(15) NOT NULL default '',
`end` varchar(15) NOT NULL default '',
`user_name` varchar(20) default NULL,
`add_date` varchar(15) default NULL,
`reason` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_forum` (
`id` int(11) NOT NULL default '1',
`userCount` int(11) NOT NULL default '0',
`userNew` varchar(20) default '0',
`createDate` varchar(15) 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 '',
`maxOnlineCount` int(11) NOT NULL default '0',
`maxOnlineDate` varchar(15) NOT NULL default '',
`notices` varchar(60) default NULL,
`filterUserName` text,
`filterMsg` text,
`isShowLink` tinyint(1) NOT NULL default '1',
`status` tinyint(3) NOT NULL default '1',
`reason` text,
`GUEST_ACTION` varchar(20) NOT NULL default '11' COMMENT '1->Guest can see topic 2->Guest can download attachment',
`ad_topic_bottom` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_forum` (`id`,`userCount`,`userNew`,`createDate`,`topicCount`,`postCount`,`todayCount`,`todayDate`,`yestodayCount`,`maxCount`,`maxDate`,`maxOnlineCount`,`maxOnlineDate`,`notices`,`filterUserName`,`filterMsg`,`isShowLink`,`status`,`reason`,`GUEST_ACTION`,`ad_topic_bottom`) VALUES (1,0,'','1161917132890',0,0,0,'1161871326531',0,0,'0',1,'1161917272734','461,462,403,402,381,391','共产党|他妈的|放屁|狗屎','共*产*党',1,1,'<P><IMG src=\"http://localhost:8080/zjrj/editor/images/emot/face18.gif\">论坛维护中，请稍后访问！</P>','11','462,463,461');
CREATE TABLE `sq_friend` (
`id` int(11) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`friend` varchar(20) NOT NULL default '',
`rq` varchar(15) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_id` (
`idType` int(11) NOT NULL default '0',
`id` int(11) NOT NULL default '0',
PRIMARY KEY (`idType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_id` (`idType`,`id`) VALUES (0,1),(1,5),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1);
CREATE TABLE `sq_images` (
`id` bigint(11) NOT NULL default '0',
`path` varchar(200) NOT NULL default '',
`otherid` bigint(20) NOT NULL default '0',
`kind` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `IX_images` (`otherid`),
KEY `IX_images_1` (`kind`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_master` (
`id` int(11) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`sort` tinyint(3) unsigned NOT NULL default '0',
`description` varchar(100) default NULL,
PRIMARY KEY (`name`),
KEY `id` (`id`),
CONSTRAINT `sq_master_ibfk_1` FOREIGN KEY (`name`) REFERENCES `sq_user` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_message` (
`id` bigint(20) NOT NULL default '0',
`name` varchar(20) NOT NULL default 'N''无名氏''',
`expression` tinyint(3) unsigned default '25',
`boardcode` varchar(20) NOT NULL default 'N''xlmx''',
`replyid` bigint(20) NOT NULL default '-1',
`rootid` bigint(20) NOT NULL default '-1',
`msg_layer` int(11) NOT NULL default '1',
`length` int(11) NOT NULL default '0',
`orders` int(11) NOT NULL default '1',
`title` varchar(200) NOT NULL default '',
`content` longtext NOT NULL,
`recount` int(11) NOT NULL default '0',
`hit` int(11) NOT NULL default '0',
`lydate` varchar(15) NOT NULL default '',
`ip` varchar(15) default NULL,
`msg_level` int(11) NOT NULL default '0',
`isprivate` tinyint(1) NOT NULL default '1',
`MSG_TYPE` tinyint(3) unsigned default '0',
`filename` varchar(250) default NULL,
`extname` varchar(3) default NULL,
`voteoption` varchar(255) default NULL,
`voteresult` varchar(25) default NULL,
`voteduser` longtext,
`iselite` tinyint(1) NOT NULL default '0',
`islocked` tinyint(1) NOT NULL default '0',
`isguide` tinyint(3) unsigned NOT NULL default '0',
`show_ubbcode` tinyint(1) NOT NULL default '1',
`show_smile` tinyint(1) NOT NULL default '1',
`email_notify` tinyint(1) NOT NULL default '0',
`replier` varchar(20) default NULL,
`redate` varchar(15) default NULL,
`iswebedit` tinyint(3) unsigned NOT NULL default '0',
`color` varchar(20) default NULL,
`colorExpire` varchar(15) NOT NULL default '',
`isBold` tinyint(1) NOT NULL default '0',
`boldExpire` varchar(15) NOT NULL default '',
`isBlog` tinyint(1) default '0',
`blogUserDir` varchar(50) NOT NULL default 'default',
`replyRootName` varchar(50) default NULL,
`pluginCode` varchar(20) default NULL,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -