mirror of
https://gitee.com/knifecms/KnifeCMS.Java.git
synced 2026-11-18 16:13:09 +08:00
142 lines
4.8 KiB
SQL
142 lines
4.8 KiB
SQL
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; |