SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*KnifeCMS执行脚本:数据初始化*/; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; DROP TABLE IF EXISTS `databasedocument`; CREATE TABLE IF NOT EXISTS `databasedocument` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) DEFAULT NULL, `source` varchar(100) DEFAULT NULL, `author` varchar(45) DEFAULT NULL, `risktype` varchar(32) DEFAULT NULL, `documenttype` varchar(32) DEFAULT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `filetype` varchar(45) DEFAULT NULL, `fileurl` varchar(300) DEFAULT NULL, `isfee` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `documenttype`; CREATE TABLE IF NOT EXISTS `documenttype` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `english`; CREATE TABLE IF NOT EXISTS `english` ( `id` int(11) NOT NULL AUTO_INCREMENT, `en` varchar(200) DEFAULT NULL, `cn` varchar(200) DEFAULT NULL, `means` text, `hot` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `history`; CREATE TABLE IF NOT EXISTS `history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usermail` varchar(100) DEFAULT NULL, `ip` varchar(50) DEFAULT NULL, `os` varchar(50) DEFAULT NULL, `browser` varchar(50) DEFAULT NULL, `url` varchar(100) DEFAULT NULL, `accessdate` date DEFAULT '0000-00-00', `accesstime` time DEFAULT '00:00:00', `type` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `meeting`; CREATE TABLE IF NOT EXISTS `meeting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `host` varchar(100) DEFAULT NULL, `starttime` datetime DEFAULT NULL, `endtime` datetime DEFAULT NULL, `isclosed` tinyint(1) NOT NULL DEFAULT '0', `meetingid` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `organclass`; CREATE TABLE IF NOT EXISTS `organclass` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `oid` int(10) unsigned DEFAULT NULL, `Class` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `organization`; CREATE TABLE IF NOT EXISTS `organization` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Type` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `risktype`; CREATE TABLE IF NOT EXISTS `risktype` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `userfav`; CREATE TABLE IF NOT EXISTS `userfav` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` int(11) NOT NULL, `docid` varchar(16) NOT NULL, `type` int(11) DEFAULT '0', `favdate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `userinfo`; CREATE TABLE IF NOT EXISTS `userinfo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `idcard` varchar(20) DEFAULT NULL, `acount` varchar(45) DEFAULT NULL, `password` varchar(45) DEFAULT NULL, `realname` varchar(45) DEFAULT NULL, `birthday` datetime DEFAULT NULL, `sex` tinyint(1) DEFAULT NULL, `education` varchar(100) DEFAULT NULL, `professional` varchar(100) NULL, `email` varchar(200) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `mobile` varchar(45) DEFAULT NULL, `organization` varchar(80) DEFAULT NULL, `department` varchar(80) DEFAULT NULL, `position` varchar(80) DEFAULT NULL, `location` varchar(200) DEFAULT NULL, `zipcode` varchar(20) DEFAULT NULL, `isfee` int(11) DEFAULT '0', `isadmin` int(11) DEFAULT '0', `adminnum` int(11) DEFAULT '0', `usednum` int(11) DEFAULT '0', `score` bigint(20) DEFAULT '0', `mac` varchar(500) DEFAULT '', `active` tinyint(4) DEFAULT '0', `hobby` VARCHAR(200) NULL, `salary` VARCHAR(100) NULL, `attend` VARCHAR(200) NULL, `exhibition` VARCHAR(200) NULL, `receive` VARCHAR(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; DROP TABLE IF EXISTS `usertype`; CREATE TABLE IF NOT EXISTS `usertype` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) DEFAULT NULL, `rights` int(11) NOT NULL DEFAULT '0', `onscore` int(11) DEFAULT '0', `macnum` int(11) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;