📄 cwbbs.sql
字号:
INSERT INTO `plugin_auction_catalog` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`) VALUES ('marry','婚纱/礼服',0,'','nuzhuang','root',8,0,'',NULL,1,3,NULL,-1),('meirong','美容美体',0,'','root','root',3,4,'',NULL,0,2,NULL,-1),('mianbu','面部保养',0,'','meirong','root',1,0,'',NULL,1,3,NULL,-1),('mobile','手机、通讯设备、卡',0,'','root','root',8,6,'',NULL,0,2,NULL,-1),('moto','摩托车',0,'','cheliang','root',3,0,'',NULL,1,3,NULL,-1),('neiyi','内衣',0,'','nuzhuang','root',10,0,'',NULL,1,3,NULL,-1),('niuzai','牛仔',0,'','nuzhuang','root',3,0,'',NULL,1,3,NULL,-1),('notebook','笔记本',0,'','hardware','root',2,0,'',NULL,1,4,0,-1),('nuzhuang','女装',0,'','root','root',5,17,'',NULL,0,2,NULL,-1),('old','中老年服装',0,'','nuzhuang','root',9,0,'',NULL,1,3,NULL,-1),('pc','台式机',0,'','hardware','root',3,0,'',NULL,1,4,0,-1),('peijian','配件',0,'','mobile','root',4,0,'',NULL,1,3,NULL,-1),('pet','宠物',0,'','liping','root',1,0,'',NULL,1,3,NULL,-1);
INSERT INTO `plugin_auction_catalog` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`) VALUES ('pinpai','品牌内衣',0,'','nuzhuang','root',11,0,'',NULL,1,3,NULL,-1),('qiche','汽车',0,'','cheliang','root',1,0,'',NULL,1,3,NULL,-1),('qunzi','裙子',0,'','nuzhuang','root',15,0,'',NULL,1,3,NULL,-1),('rcyp','日常用品',0,'','root','root',2,4,'',NULL,0,2,NULL,-1),('riyong','日用',0,'','dianqi','root',1,0,'',NULL,1,3,NULL,-1),('root','全部分类',0,'','-1','root',1,10,'',NULL,0,1,0,-1),('shancun','闪存',0,'','shuma','root',3,0,'',NULL,1,3,NULL,-1),('shexiang','摄像机',0,'','shuma','root',2,0,'',NULL,1,3,NULL,-1),('shipinbaojian','食品、保健品',0,'','root','root',7,4,'',NULL,0,2,NULL,-1),('shiping','手机饰品',0,'','mobile','root',6,0,'',NULL,1,3,NULL,-1),('shoubu','手部保养',0,'','meirong','root',3,0,'',NULL,1,3,NULL,-1),('shougong','手工',0,'','liping','root',3,0,'',NULL,1,3,NULL,-1),('shouji','手机',0,'','mobile','root',1,0,'',NULL,1,3,NULL,-1);
INSERT INTO `plugin_auction_catalog` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`) VALUES ('shuma','数码',0,'','root','root',9,5,'',NULL,0,2,0,-1),('smpeijian','配件',0,'','shuma','root',4,0,'',NULL,1,3,NULL,-1),('software','软件',0,'','computer','root',2,1,'',NULL,0,3,0,-1),('tang','唐装/中式服装',0,'','nuzhuang','root',7,0,'',NULL,1,3,NULL,-1),('taozhuang','套装',0,'','nuzhuang','root',16,0,'',NULL,1,3,NULL,-1),('tea','茶叶',0,'','shipinbaojian','root',2,0,'',NULL,1,3,NULL,-1),('techan','特产',0,'','shipinbaojian','root',3,0,'',NULL,1,3,NULL,-1),('tongche','童车',0,'','cheliang','root',5,0,'',NULL,1,3,NULL,-1),('wenju','文具',0,'','rcyp','root',3,0,'',NULL,1,3,NULL,-1),('xiaobeixin','小背心/吊带衫',0,'','nuzhuang','root',4,0,'',NULL,1,3,0,-1),('xiaolintong','小灵通',0,'','mobile','root',3,0,'',NULL,1,3,NULL,-1),('yingyin','影音',0,'','dianqi','root',2,0,'',NULL,1,3,NULL,-1),('yunfu','孕妇装',0,'','nuzhuang','root',17,0,'',NULL,1,3,NULL,-1);
INSERT INTO `plugin_auction_catalog` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`) VALUES ('zhongchang','中长外套',0,'','nuzhuang','root',13,0,'',NULL,1,3,NULL,-1);
CREATE TABLE `plugin_auction_catalog_priv` (
`id` int(11) NOT NULL auto_increment,
`dir_code` varchar(50) NOT NULL default '',
`see` tinyint(1) NOT NULL default '0',
`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`),
KEY `dir_code` (`dir_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `plugin_auction_catalog_priv` (`id`,`dir_code`,`see`,`append`,`del`,`modify`,`examine`,`name`,`type`) VALUES (1,'computer',1,0,0,0,0,'Everyone',0),(2,'hardware',1,0,0,0,0,'Everyone',0),(5,'notebook',1,0,0,0,0,'Everyone',0),(6,'pc',1,0,0,0,0,'Everyone',0),(7,'software',1,0,0,0,0,'Everyone',0),(8,'game',1,0,0,0,0,'Everyone',0),(9,'rcyp',1,0,0,0,0,'Everyone',0),(10,'jiaju',1,0,0,0,0,'Everyone',0),(11,'chaju',1,0,0,0,0,'Everyone',0),(12,'wenju',1,0,0,0,0,'Everyone',0),(14,'meirong',1,0,0,0,0,'Everyone',0),(15,'mianbu',1,0,0,0,0,'Everyone',0),(16,'caizhuang',1,0,0,0,0,'Everyone',0),(17,'shoubu',1,0,0,0,0,'Everyone',0),(18,'lipingshiping',1,0,0,0,0,'Everyone',0),(19,'cheliang',1,0,0,0,0,'Everyone',0),(20,'qiche',1,0,0,0,0,'Everyone',0),(21,'diandong',1,0,0,0,0,'Everyone',0),(22,'moto',1,0,0,0,0,'Everyone',0),(23,'bicycle',1,0,0,0,0,'Everyone',0),(24,'tongche',1,0,0,0,0,'Everyone',0),(25,'nuzhuang',1,0,0,0,0,'Everyone',0),(26,'cunshan',1,0,0,0,0,'Everyone',0),(27,'maoyi',1,0,0,0,0,'Everyone',0),(28,'niuzai',1,0,0,0,0,'Everyone',0);
INSERT INTO `plugin_auction_catalog_priv` (`id`,`dir_code`,`see`,`append`,`del`,`modify`,`examine`,`name`,`type`) VALUES (29,'xiaobeixin',1,0,0,0,0,'Everyone',0),(30,'lei',1,0,0,0,0,'Everyone',0),(31,'couple',1,0,0,0,0,'Everyone',0),(32,'tang',1,0,0,0,0,'Everyone',0),(33,'marry',1,0,0,0,0,'Everyone',0),(34,'old',1,0,0,0,0,'Everyone',0),(35,'neiyi',1,0,0,0,0,'Everyone',0),(36,'pinpai',1,0,0,0,0,'Everyone',0),(37,'duanwai',1,0,0,0,0,'Everyone',0),(38,'zhongchang',1,0,0,0,0,'Everyone',0),(39,'kz',1,0,0,0,0,'Everyone',0),(40,'qunzi',1,0,0,0,0,'Everyone',0),(41,'taozhuang',1,0,0,0,0,'Everyone',0),(42,'yunfu',1,0,0,0,0,'Everyone',0),(43,'dianqi',1,0,0,0,0,'Everyone',0),(44,'riyong',1,0,0,0,0,'Everyone',0),(45,'yingyin',1,0,0,0,0,'Everyone',0),(46,'shipinbaojian',1,0,0,0,0,'Everyone',0),(47,'coffiee',1,0,0,0,0,'Everyone',0),(48,'tea',1,0,0,0,0,'Everyone',0),(49,'techan',1,0,0,0,0,'Everyone',0),(50,'jianfei',1,0,0,0,0,'Everyone',0),(51,'mobile',1,0,0,0,0,'Everyone',0),(52,'shouji',1,0,0,0,0,'Everyone',0),(53,'dianhua',1,0,0,0,0,'Everyone',0);
INSERT INTO `plugin_auction_catalog_priv` (`id`,`dir_code`,`see`,`append`,`del`,`modify`,`examine`,`name`,`type`) VALUES (54,'xiaolintong',1,0,0,0,0,'Everyone',0),(55,'peijian',1,0,0,0,0,'Everyone',0),(56,'chongzhi',1,0,0,0,0,'Everyone',0),(57,'shiping',1,0,0,0,0,'Everyone',0),(58,'hufu',1,0,0,0,0,'Everyone',0),(59,'shuma',1,0,0,0,0,'Everyone',0),(60,'camera',1,0,0,0,0,'Everyone',0),(61,'shexiang',1,0,0,0,0,'Everyone',0),(62,'shancun',1,0,0,0,0,'Everyone',0),(63,'smpeijian',1,0,0,0,0,'Everyone',0),(64,'chongyin',1,0,0,0,0,'Everyone',0),(65,'liping',1,0,0,0,0,'Everyone',0),(66,'pet',1,0,0,0,0,'Everyone',0),(67,'flower',1,0,0,0,0,'Everyone',0),(68,'shougong',1,0,0,0,0,'Everyone',0);
CREATE TABLE `plugin_auction_order` (
`id` int(11) NOT NULL default '0',
`auctionId` int(11) NOT NULL default '0',
`auctionSellType` tinyint(3) unsigned NOT NULL default '0',
`seller` varchar(50) NOT NULL default '',
`buyer` varchar(50) NOT NULL default '',
`price` decimal(19,4) NOT NULL default '0.0000',
`moneyCode` varchar(50) NOT NULL default '',
`totalPrice` decimal(19,4) NOT NULL default '0.0000',
`amount` int(11) NOT NULL default '0',
`state` tinyint(3) unsigned NOT NULL default '0',
`orderDate` varchar(15) NOT NULL default '',
`payTime` varchar(15) default NULL,
`deliverTime` varchar(15) default NULL,
`commodityName` varchar(50) NOT NULL default '',
`sellerScore` int(11) NOT NULL default '-100',
`buyerScore` int(11) NOT NULL default '-100',
PRIMARY KEY (`id`),
KEY `auctionId` (`auctionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_auction_shop` (
`id` int(11) NOT NULL default '0',
`userName` varchar(50) NOT NULL default '',
`shopName` varchar(200) NOT NULL default '',
`address` text NOT NULL,
`tel` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`isValid` tinyint(1) NOT NULL default '1',
`reason` varchar(10) default NULL,
`openDate` varchar(15) NOT NULL default '',
`logo` text,
`logoWidth` int(11) NOT NULL default '0',
`skinCode` varchar(50) NOT NULL default 'default',
`IS_RECOMMANDED` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`userName`),
KEY `IX_plugin_auction_shop` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_auction_shop_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 '',
`sort` int(11) NOT NULL default '0',
`color` varchar(20) default NULL,
UNIQUE KEY `IX_plugin_auction_shop_dir` (`userName`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_auction_worth` (
`id` int(11) NOT NULL auto_increment,
`msgRootId` bigint(20) NOT NULL default '0',
`moneyCode` varchar(50) NOT NULL default '',
`price` decimal(19,4) NOT NULL default '0.0000',
`dlt` decimal(19,4) NOT NULL default '0.0000',
`referPrice` decimal(19,4) NOT NULL default '0.0000',
`isValid` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `msgRootId` (`msgRootId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_entrance_vip_card` (
`id` varchar(15) NOT NULL default '',
`userName` varchar(20) default NULL,
`beginDate` varchar(15) default NULL,
`endDate` varchar(15) default NULL,
`fee` int(11) default NULL,
`kind` varchar(20) NOT NULL default '',
`fingerPrint` varchar(32) default NULL,
`pwd` varchar(32) NOT NULL default '',
`pwdRaw` varchar(32) NOT NULL default '0',
`isUseFingerPrint` tinyint(1) NOT NULL default '0',
`isValid` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `userName_kind` (`userName`,`kind`,`endDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_entrance_vip_user` (
`userName` varchar(20) NOT NULL default '',
`beginDate` varchar(15) default NULL,
`endDate` varchar(15) default NULL,
`isValid` tinyint(1) NOT NULL default '0',
`boards` varchar(255) default NULL,
PRIMARY KEY (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_entrance_vip_user_group` (
`groupCode` varchar(20) NOT NULL default '',
`beginDate` varchar(15) default NULL,
`endDate` varchar(15) default NULL,
`isValid` tinyint(1) NOT NULL default '0',
`boards` varchar(255) default NULL,
PRIMARY KEY (`groupCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `plugin_entrance_vip_user_group` (`groupCode`,`beginDate`,`endDate`,`isValid`,`boards`) VALUES ('ccc','1160150400000','1161964800000',1,'trade,info,alipay,master');
CREATE TABLE `plugin_info` (
`id` bigint(20) NOT NULL default '0',
`typeCode` varchar(50) NOT NULL default '',
`userName` varchar(50) NOT NULL default '',
`addDate` varchar(15) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_info_board` (
`boardCode` varchar(20) NOT NULL default '',
`boardRule` text NOT NULL,
PRIMARY KEY (`boardCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `plugin_info_board` (`boardCode`,`boardRule`) VALUES ('info','发布各类信息，用户的信用值越高，信息越可信，但是“镇江人家”并不保证信息的真实性，请各用户在查看信息时判别其真实性。'),('reward','');
CREATE TABLE `plugin_reward` (
`msg_id` bigint(20) NOT NULL default '0',
`score` int(11) NOT NULL default '0',
`is_end` tinyint(1) default '0',
`money_code` varchar(20) default NULL,
`score_given` int(11) NOT NULL default '0',
`best_msg_id` bigint(20) default '0',
PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_reward_board` (
`boardCode` varchar(20) NOT NULL default '',
`boardRule` text NOT NULL,
PRIMARY KEY (`boardCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `plugin_reward_board` (`boardCode`,`boardRule`) VALUES ('reward','asdfasdfasdf');
CREATE TABLE `plugin_sweet` (
`msgRootId` bigint(20) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`state` tinyint(3) unsigned NOT NULL default '0',
`spouse` varchar(20) default NULL,
PRIMARY KEY (`msgRootId`),
UNIQUE KEY `IX_plugin_sweet` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_sweet_board` (
`boardCode` varchar(20) NOT NULL default '',
`sweetRule` text NOT NULL,
PRIMARY KEY (`boardCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `plugin_sweet_board` (`boardCode`,`sweetRule`) VALUES ('qrl','');
CREATE TABLE `plugin_sweet_life` (
`msgRootId` bigint(20) NOT NULL default '0',
`marryDate` varchar(15) NOT NULL default '',
`divorceDate` varchar(15) default NULL,
`ownerName` varchar(20) NOT NULL default '',
`spouseName` varchar(20) NOT NULL default '',
PRIMARY KEY (`msgRootId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_sweet_sq_message` (
`msgId` bigint(20) NOT NULL default '0',
`scretLevel` int(11) NOT NULL default '0',
`userAction` int(11) NOT NULL default '0',
PRIMARY KEY (`msgId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_sweet_user` (
`msgRootId` bigint(20) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`type` int(11) NOT NULL default '0',
`state` int(11) NOT NULL default '0',
UNIQUE KEY `IX_plugin_sweet_user` (`msgRootId`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_sweet_userinfo` (
`name` varchar(50) NOT NULL default '',
`gender` varchar(50) NOT NULL default 'N''男''',
`age` int(11) NOT NULL default '0',
`birthday` varchar(15) default NULL,
`marriage` varchar(10) NOT NULL default '0',
`province` varchar(50) default NULL,
`workAddress` varchar(200) default NULL,
`tall` varchar(10) default NULL,
`xueli` varchar(50) default NULL,
`job` varchar(50) default NULL,
`salary` varchar(20) default NULL,
`address` varchar(50) default NULL,
`postCode` int(11) default '0',
`tel` varchar(50) default NULL,
`email` varchar(50) default NULL,
`OICQ` int(11) default NULL,
`ICQ` varchar(50) default NULL,
`MSN` varchar(50) default NULL,
`description` text,
`sport` varchar(50) default NULL,
`book` varchar(50) default NULL,
`music` varchar(50) default NULL,
`celebrity` varchar(50) default NULL,
`photo` varchar(100) default NULL,
`hobby` varchar(50) default NULL,
`frendType` varchar(50) default NULL,
`frendAge` varchar(20) default NULL,
`frendTall` varchar(10) default NULL,
`frendMarriage` varchar(30) default NULL,
`frendProvince` varchar(50) default NULL,
`frendXueli` varchar(50) default NULL,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -