Files
KnifeCMS.Java/sql/modules/module-user-pgsql.sql
2013-08-15 21:56:13 +08:00

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;