cwbbs.sql

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

  `plugin2Code` varchar(20) default NULL,
  `msg_kind` varchar(20) default NULL,
  `isChecked` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`,`replyid`),
  KEY `rootid` (`rootid`),
  KEY `replyid` (`replyid`),
  KEY `boardcode` (`boardcode`),
  KEY `replyRootName` (`replyRootName`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_message_attach` (
  `id` bigint(20) NOT NULL default '0',
  `msgId` bigint(20) NOT NULL default '0',
  `name` varchar(200) NOT NULL default '',
  `fullpath` varchar(255) default NULL,
  `diskname` varchar(100) NOT NULL default '',
  `visualpath` varchar(255) NOT NULL default '',
  `orders` int(11) NOT NULL default '0',
  `DOWNLOAD_COUNT` int(11) NOT NULL default '0',
  `UPLOAD_DATE` varchar(15) default NULL,
  `FILE_SIZE` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `msgId` (`msgId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_online` (
  `name` varchar(26) NOT NULL default '',
  `boardcode` varchar(20) default NULL,
  `ip` varchar(15) NOT NULL default '',
  `doing` varchar(50) default NULL,
  `logtime` varchar(15) NOT NULL default '',
  `staytime` varchar(15) NOT NULL default '',
  `isguest` tinyint(1) NOT NULL default '0',
  `covered` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`name`),
  KEY `IX_sq_online` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_online` (`name`,`boardcode`,`ip`,`doing`,`logtime`,`staytime`,`isguest`,`covered`) VALUES ('11619172726091330867595','reward','127.0.0.1',NULL,'1161917272640','1161917272640',1,0);
CREATE TABLE `sq_roomemcee` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  `room` varchar(20) NOT NULL default '',
  `sort` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `room` (`room`),
  KEY `name` (`name`),
  CONSTRAINT `FK_sq_roomemcee_sq_chatroom` FOREIGN KEY (`room`) REFERENCES `sq_chatroom` (`name`),
  CONSTRAINT `FK_sq_roomemcee_users` FOREIGN KEY (`name`) REFERENCES `sq_user` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_setup_user_level` (
  `levelAmount` int(11) NOT NULL default '0',
  `description` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`levelAmount`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_setup_user_level` (`levelAmount`,`description`) VALUES (0,'初入江湖'),(1000,'小有名气'),(2000,'名动一方'),(3000,'天下闻名'),(4000,'一代宗师'),(5000,'超凡入圣'),(6000,'天外飞仙'),(7000,'无所不能');
CREATE TABLE `sq_thread` (
  `id` bigint(20) NOT NULL default '0' COMMENT 'The id of message''s root id',
  `boardcode` varchar(20) default NULL,
  `msg_level` int(11) NOT NULL default '0',
  `iselite` tinyint(1) NOT NULL default '0',
  `lydate` varchar(15) NOT NULL default '',
  `redate` varchar(15) default NULL COMMENT 'reply date',
  `name` varchar(20) NOT NULL default '',
  `blogUserDir` varchar(50) default NULL,
  `isBlog` tinyint(1) NOT NULL default '0',
  `hit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `boardcode` (`boardcode`),
  KEY `name` (`name`),
  KEY `lydate` (`lydate`),
  KEY `redate` (`redate`),
  KEY `name_blogUserDir` (`name`,`blogUserDir`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_user` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  `pwd` varchar(32) default NULL,
  `rawPwd` varchar(20) default NULL,
  `RegDate` varchar(15) NOT NULL default '',
  `realname` varchar(20) default NULL,
  `RealPic` varchar(50) default NULL,
  `Question` varchar(50) default NULL,
  `Answer` varchar(50) default NULL,
  `Email` varchar(50) default NULL,
  `Gender` char(1) default NULL,
  `OICQ` varchar(15) default NULL,
  `Birthday` varchar(15) default NULL,
  `IDCard` varchar(50) default NULL,
  `Career` varchar(255) default NULL,
  `Job` varchar(50) default NULL,
  `State` varchar(50) default NULL,
  `City` varchar(50) default NULL,
  `Address` varchar(255) default NULL,
  `PostCode` varchar(20) default NULL,
  `Phone` varchar(50) default NULL,
  `Mobile` varchar(30) default NULL,
  `Hobbies` varchar(50) default NULL,
  `lastTime` varchar(15) NOT NULL default '',
  `curTime` varchar(15) NOT NULL default '',
  `sign` varchar(255) default NULL,
  `myface` varchar(50) default NULL,
  `myfacewidth` int(11) default '120',
  `myfaceheight` int(11) default '150',
  `favoriate` varchar(250) default NULL,
  `ispolice` tinyint(1) NOT NULL default '0',
  `arrestday` int(11) NOT NULL default '0',
  `releasetime` varchar(15) NOT NULL default '0',
  `arrestreason` varchar(255) default NULL,
  `arresttime` varchar(15) NOT NULL default '0',
  `arrestpolice` varchar(20) default NULL,
  `experience` int(11) NOT NULL default '0',
  `credit` int(11) NOT NULL default '500',
  `addcount` int(11) NOT NULL default '0',
  `delcount` int(11) NOT NULL default '0',
  `eliteCount` int(11) NOT NULL default '0',
  `Marriage` tinyint(3) unsigned NOT NULL default '0',
  `gold` int(11) NOT NULL default '0',
  `isValid` tinyint(1) NOT NULL default '1',
  `diskSpaceAllowed` int(11) NOT NULL default '10240000',
  `diskSpaceUsed` int(11) NOT NULL default '0',
  `isSecret` tinyint(1) NOT NULL default '1',
  `IP` varchar(15) default NULL,
  `timeZone` varchar(9) NOT NULL default '',
  `home` varchar(255) default NULL,
  `msn` varchar(200) default NULL,
  `group_code` varchar(20) default NULL,
  `icq` varchar(50) default NULL,
  `uc` varchar(50) default NULL,
  `yahoo` varchar(50) default NULL,
  `isChecked` tinyint(1) NOT NULL default '1',
  `locale` varchar(20) default NULL,
  PRIMARY KEY  (`name`),
  KEY `id` (`id`),
  KEY `RegDate` (`RegDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_user_group` (
  `code` varchar(50) NOT NULL default '',
  `description` varchar(50) NOT NULL default '',
  `isSystem` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_user_treasure` (
  `userName` varchar(50) NOT NULL default '',
  `treasureCode` varchar(50) NOT NULL default '',
  `buyDate` varchar(15) NOT NULL default '',
  `amount` int(11) NOT NULL default '0',
  UNIQUE KEY `IX_sq_user_treasure` (`userName`,`treasureCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_group` (
  `code` varchar(50) NOT NULL default '',
  `description` varchar(50) NOT NULL default '',
  `isSystem` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `user_group` (`code`,`description`,`isSystem`) VALUES ('Administrators','管理员组',1),('Everyone','每个人',1);
CREATE TABLE `user_group_priv` (
  `group_code` varchar(20) NOT NULL default '',
  `priv` varchar(20) NOT NULL default '',
  KEY `IX_group_priv` (`group_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_of_group` (
  `user_name` varchar(50) NOT NULL default '',
  `group_code` varchar(50) NOT NULL default '',
  KEY `IX_user_of_group` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_priv` (
  `username` varchar(20) NOT NULL default '',
  `priv` varchar(50) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
  `name` varchar(20) NOT NULL default '',
  `pwd` varchar(32) NOT NULL default '',
  `realname` varchar(20) NOT NULL default '',
  `description` varchar(200) default NULL,
  `enter_count` int(11) NOT NULL default '0',
  `enter_last` varchar(15) NOT NULL default '0',
  PRIMARY KEY  (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `users` (`name`,`pwd`,`realname`,`description`,`enter_count`,`enter_last`) VALUES ('admin','96e79218965eb72c92a549dd5a330112','admin',NULL,0,'0');
CREATE TABLE `yearcount` (
  `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,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;