cwbbs.sql

这是论坛原代码,希望大家能好好看看,说明需要的太多了吧

  `examine` tinyint(3) unsigned NOT NULL default '0',
  `nick` varchar(50) default NULL,
  `hit` int(11) NOT NULL default '0',
  `template_id` int(11) NOT NULL default '-1',
  `page_count` int(11) NOT NULL default '1',
  `parent_code` varchar(20) default NULL,
  `isNew` tinyint(1) NOT NULL default '0',
  `flowTypeCode` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `IX_document` (`class1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `document` (`id`,`keywords`,`isrelateshow`,`title`,`class1`,`author`,`modifiedDate`,`can_comment`,`summary`,`isHome`,`voteoption`,`voteresult`,`type`,`examine`,`nick`,`hit`,`template_id`,`page_count`,`parent_code`,`isNew`,`flowTypeCode`) VALUES (1,'ad',1,'公告旁的广告','blog_ad1','admin','1156735806937',1,NULL,0,'','',0,0,'admin',23,-1,1,'blog_ad',0,''),(2,'ad',1,'首页中部横幅','blog_ad2','admin','1156735913968',1,NULL,0,'','',0,0,'admin',0,-1,1,'blog_ad',0,''),(3,'',1,'首页底部横幅','blog_ad3','admin','1156735951062',1,NULL,0,'','',0,0,'admin',0,-1,1,'blog_ad',0,''),(4,'',1,'便民服务','bmfu','admin','1156736629718',1,NULL,0,'','',0,0,'admin',0,-1,1,'shop',0,'');
CREATE TABLE `document_attach` (
  `id` int(11) NOT NULL default '0',
  `doc_id` int(11) NOT NULL default '0',
  `name` varchar(200) NOT NULL default '',
  `fullpath` text NOT NULL,
  `diskname` varchar(100) NOT NULL default '',
  `visualpath` varchar(200) NOT NULL default '',
  `page_num` int(11) NOT NULL default '1',
  `orders` int(11) NOT NULL default '0',
  `downloadCount` int(11) NOT NULL default '0',
  `upload_date` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `doc_id` (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `guestbook` (
  `id` int(11) NOT NULL auto_increment,
  `shopCode` varchar(50) NOT NULL default '',
  `userName` varchar(50) NOT NULL default '',
  `content` text NOT NULL,
  `ip` varchar(15) NOT NULL default '',
  `lydate` varchar(15) NOT NULL default '',
  `reply` text,
  `redate` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `lastly` (
  `BC` varchar(50) default NULL,
  `OS` varchar(50) default NULL,
  `IP` varchar(50) default NULL,
  `Date` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `link` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(200) NOT NULL default '',
  `title` varchar(100) default NULL,
  `image` text,
  `userName` varchar(50) default NULL,
  `sort` int(11) NOT NULL default '0',
  `kind` varchar(50) NOT NULL default 'N''default''',
  PRIMARY KEY  (`id`),
  KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `message` (
  `id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `sender` varchar(20) NOT NULL default '',
  `receiver` varchar(20) NOT NULL default '',
  `rq` varchar(15) NOT NULL default '',
  `type` tinyint(3) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `isreaded` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `receiver` (`receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `miniplugin_home` (
  `id` int(11) NOT NULL default '0',
  `hot` varchar(100) default NULL,
  `recommandBoard` varchar(255) default NULL,
  `recommandMsg` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `miniplugin_home` (`id`,`hot`,`recommandBoard`,`recommandMsg`) VALUES (0,'','','');
CREATE TABLE `monthcount` (
  `ID` int(11) NOT NULL default '0',
  `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,
  `24` int(11) default NULL,
  `25` int(11) default NULL,
  `26` int(11) default NULL,
  `27` int(11) default NULL,
  `28` int(11) default NULL,
  `29` int(11) default NULL,
  `30` int(11) default NULL,
  `31` int(11) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `nav` (
  `name` varchar(50) NOT NULL default '',
  `orders` tinyint(3) unsigned NOT NULL default '0',
  `link` varchar(255) NOT NULL default '',
  `color` varchar(20) default NULL,
  `target` varchar(20) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `nav` (`name`,`orders`,`link`,`color`,`target`) VALUES ('佳人有约',4,'forum/listtopic.jsp?boardcode=qrl','','_self'),('博客',5,'blog/index.jsp','#ff0000',''),('同城交易',2,'forum/listtopic.jsp?boardcode=trade','#ff0005',NULL),('百姓信息',3,'forum/listtopic.jsp?boardcode=info','',NULL),('论坛',1,'forum/index.jsp','',NULL);
CREATE TABLE `os` (
  `ID` int(11) NOT NULL auto_increment,
  `os` varchar(50) default NULL,
  `count` int(11) default NULL,
  `todays` int(11) default NULL,
  KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `photo` (
  `id` int(11) NOT NULL default '0',
  `title` varchar(100) default NULL,
  `image` varchar(255) default NULL,
  `userName` varchar(50) default NULL,
  `sort` int(11) NOT NULL default '0',
  `kind` varchar(50) NOT NULL default '',
  `addDate` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `IX_photo` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin2_alipay` (
  `msgRootId` bigint(20) NOT NULL default '0',
  `alipay_seller` varchar(50) NOT NULL default '',
  `alipay_subject` varchar(100) NOT NULL default '',
  `alipay_price` varchar(20) default NULL,
  `alipay_transport` tinyint(3) NOT NULL default '2',
  `alipay_demo` varchar(100) default NULL,
  `alipay_ww` varchar(30) default NULL,
  `alipay_qq` varchar(20) default NULL,
  `alipay_ordinary` varchar(20) default NULL,
  `alipay_express` varchar(20) default NULL,
  PRIMARY KEY  (`msgRootId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_auction` (
  `msgRootId` bigint(20) NOT NULL default '0',
  `name` text NOT NULL,
  `userType` varchar(50) NOT NULL default 'N''0''',
  `counts` int(11) NOT NULL default '-1',
  `beginDate` varchar(15) NOT NULL default '',
  `endDate` varchar(15) default NULL,
  `state` tinyint(3) unsigned NOT NULL default '0',
  `userName` varchar(50) NOT NULL default '',
  `sellType` varchar(10) default NULL,
  `curBidPrice` decimal(19,4) NOT NULL default '0.0000',
  `orderId` int(11) NOT NULL default '-1',
  `shopDir` varchar(50) NOT NULL default 'N''default''',
  `recommand` tinyint(1) NOT NULL default '0',
  `catalogCode` varchar(50) NOT NULL default '',
  `isShow` tinyint(1) NOT NULL default '0',
  `image` text,
  PRIMARY KEY  (`msgRootId`),
  KEY `endDate` (`endDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_auction_bid` (
  `id` int(11) NOT NULL auto_increment,
  `msgRootId` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `price` decimal(19,4) NOT NULL default '0.0000',
  `bidDate` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `msgRootId` (`msgRootId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `plugin_auction_board` (
  `boardCode` varchar(20) NOT NULL default '',
  `auctionRule` text NOT NULL,
  PRIMARY KEY  (`boardCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `plugin_auction_board` (`boardCode`,`auctionRule`) VALUES ('trade','<P>同城交易，更安全，更快捷，更放心！</P>');
CREATE TABLE `plugin_auction_catalog` (
  `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 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 '1',
  `doc_id` int(11) default NULL,
  `template_id` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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 ('bicycle','自行车',0,'','cheliang','root',4,0,'',NULL,1,3,NULL,-1),('caizhuang','彩妆',0,'','meirong','root',2,0,'',NULL,1,3,NULL,-1),('camera','数码相机',0,'','shuma','root',1,0,'',NULL,1,3,NULL,-1),('chaju','茶具',0,'','rcyp','root',2,0,'',NULL,1,3,NULL,-1),('cheliang','车辆',0,'','root','root',4,5,'',NULL,0,2,NULL,-1),('chongyin','冲印',0,'','shuma','root',5,0,'',NULL,1,3,NULL,-1),('chongzhi','充值卡',0,'','mobile','root',5,0,'',NULL,1,3,NULL,-1),('coffiee','咖啡',0,'','shipinbaojian','root',1,0,'',NULL,1,3,NULL,-1),('computer','计算机',0,'计算机','root','root',1,2,'',NULL,0,2,0,-1),('couple','情侣装',0,'','nuzhuang','root',6,0,'',NULL,1,3,NULL,-1),('cunshan','衬衫',0,'','nuzhuang','root',1,0,'',NULL,1,3,NULL,-1),('diandong','电动车',0,'','cheliang','root',2,0,'',NULL,1,3,NULL,-1),('dianhua','电话机',0,'','mobile','root',2,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 ('dianqi','电器',0,'','root','root',6,2,'',NULL,0,2,NULL,-1),('duanwai','短外套',0,'','nuzhuang','root',12,0,'',NULL,1,3,NULL,-1),('flower','鲜花',0,'','liping','root',2,0,'',NULL,1,3,NULL,-1),('game','游戏',0,'游戏','software','root',1,0,'',NULL,1,4,NULL,-1),('hardware','硬件',0,'硬件','computer','root',1,3,'',NULL,0,3,0,-1),('hufu','护肤',0,'','meirong','root',4,0,'',NULL,1,3,NULL,-1),('jiaju','家具',0,'','rcyp','root',1,0,'',NULL,1,3,NULL,-1),('jianfei','减肥',0,'','shipinbaojian','root',4,0,'',NULL,1,3,NULL,-1),('kz','裤子',0,'','nuzhuang','root',14,0,'',NULL,1,3,NULL,-1),('lei','蕾丝衫/雪纺衫',0,'','nuzhuang','root',5,0,'',NULL,1,3,NULL,-1),('liping','宠物、工艺品',0,'','root','root',10,3,'',NULL,0,2,0,-1),('lipingshiping','礼品饰品',0,'','rcyp','root',4,0,'',NULL,1,3,NULL,-1),('maoyi','毛衣',0,'','nuzhuang','root',2,0,'',NULL,1,3,NULL,-1);