Jsp/Servlet

开发平台：

Java

redmoonoa.sql：源码内容

SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `redmoonoa`;
USE `redmoonoa`;
CREATE TABLE `account` (
`name` varchar(20) NOT NULL default '',
`userName` varchar(20) NOT NULL default '',
PRIMARY KEY (`name`),
KEY `Index_userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `address` (
`ID` bigint(20) NOT NULL default '0',
`PERSON` varchar(20) NOT NULL default '',
`JOB` varchar(20) default NULL,
`TEL` varchar(50) default NULL,
`POSTALCODE` varchar(10) default NULL,
`EMAIL` varchar(100) default NULL,
`MOBILE` varchar(20) default NULL,
`INTRODUCTION` varchar(200) default NULL,
`ADDRESS` varchar(50) default NULL,
`USERNAME` varchar(20) NOT NULL default '',
`ADDDATE` datetime default NULL,
`TYPE` bigint(20) default NULL,
`FIRSTNAME` varchar(50) default NULL,
`FAMILYNAME` varchar(50) default NULL,
`MIDDLENAME` varchar(50) default NULL,
`NICKNAME` varchar(50) default NULL,
`STREET` varchar(50) default NULL,
`CITY` varchar(50) default NULL,
`PROVINCE` varchar(50) default NULL,
`COUNTRY` varchar(50) default NULL,
`FAX` varchar(50) default NULL,
`COMPANYSTREET` varchar(50) default NULL,
`COMPANYCITY` varchar(50) default NULL,
`COMPANYPOSTCODE` varchar(50) default NULL,
`COMPANYPROVICE` varchar(50) default NULL,
`COMPANYCOUNTRY` varchar(50) default NULL,
`OPERATIONWEB` varchar(50) default NULL,
`OPERATIONPHONE` varchar(50) default NULL,
`OPERATIONFAX` varchar(50) default NULL,
`BEEPPAGER` varchar(50) default NULL,
`COMPANY` varchar(50) default NULL,
`DEPARTMENT` varchar(50) default NULL,
`WEB` varchar(50) default NULL,
`TYPEID` int(11) default NULL,
`MSN` varchar(100) default NULL,
`QQ` varchar(20) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `address_type` (
`ID` bigint(20) NOT NULL default '0',
`NAME` varchar(50) default NULL,
`USER_NAME` varchar(20) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_assess` (
`ID` bigint(20) NOT NULL default '0',
`USERNAME` varchar(50) NOT NULL default '',
`ASSESSYEAR` varchar(50) default NULL,
`INFO` varchar(50) default NULL,
`MYDATE` datetime default NULL,
`RESULT` varchar(50) default NULL,
`REMARK` varchar(50) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_assess_his` (
`ID` bigint(20) NOT NULL default '0',
`USERNAME` varchar(50) NOT NULL default '',
`ASSESSYEAR` varchar(50) default NULL,
`INFO` varchar(50) default NULL,
`MYDATE` datetime default NULL,
`RESULT` varchar(50) default NULL,
`REMARK` varchar(50) default NULL,
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_duty` (
`ID` bigint(20) NOT NULL default '0',
`USERNAME` varchar(50) NOT NULL default '',
`INFO` varchar(50) default NULL,
`FILENUMBER` varchar(50) default NULL,
`MYDATE` datetime default NULL,
`DUTY` varchar(50) default NULL,
`DEPOSAL` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_duty` (`ID`,`USERNAME`,`INFO`,`FILENUMBER`,`MYDATE`,`DUTY`,`DEPOSAL`,`REMARK`) VALUES (100,'11624617811255930823','sdfg','sdfg','2006-11-20 00:00:00','dsfg','','sdfgsdfg');
CREATE TABLE `archive_duty_his` (
`ID` bigint(20) NOT NULL default '0',
`USERNAME` varchar(50) NOT NULL default '',
`INFO` varchar(50) default NULL,
`FILENUMBER` varchar(50) default NULL,
`MYDATE` datetime default NULL,
`DUTY` varchar(50) default NULL,
`DEPOSAL` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_duty_his` (`ID`,`USERNAME`,`INFO`,`FILENUMBER`,`MYDATE`,`DUTY`,`DEPOSAL`,`REMARK`,`OPERATOR`,`ADDDATE`,`OPERATETYPE`) VALUES (100,'11624617811255930823','sdfg','sdfg','2006-11-20 00:00:00','dsfg','','sdfgsdfg','admin','2006-11-02 18:08:55','创建');
CREATE TABLE `archive_family` (
`ID` bigint(20) NOT NULL default '0',
`APPELLATION` varchar(20) default NULL,
`NAME` varchar(20) default NULL,
`AGE` bigint(20) default NULL,
`POLITIC` varchar(20) default NULL,
`UNIT` varchar(100) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(20) default NULL,
`ADDRESS` varchar(200) default NULL,
`PHONE` varchar(20) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_family_his` (
`ID` bigint(20) NOT NULL default '0',
`APPELLATION` varchar(20) default NULL,
`NAME` varchar(20) default NULL,
`AGE` bigint(20) default NULL,
`POLITIC` varchar(20) default NULL,
`UNIT` varchar(100) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(20) default NULL,
`ADDRESS` varchar(200) default NULL,
`PHONE` varchar(20) default NULL,
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_field` (
`ID` int(11) NOT NULL default '0',
`FIELD_NAME` varchar(50) NOT NULL default '',
`FIELD_CODE` varchar(50) NOT NULL default '',
`TABLE_SHORT_CODE` varchar(50) NOT NULL default '',
`FIELD_TYPE` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_field` (`ID`,`FIELD_NAME`,`FIELD_CODE`,`TABLE_SHORT_CODE`,`FIELD_TYPE`) VALUES (16,'毕业院校','COLLEGE','AST','0'),(17,'毕业院校简称','SCOLLEGE','AST','0'),(18,'专业','SPECIALTY','AST','0'),(19,'专业简称','SSPECIALTY','AST','0'),(20,'是否在职','ISJOB','AST','1'),(21,'开始时间','BEGINDATE','AST','2'),(22,'结束时间','ENDDATE','AST','2'),(23,'学位','DEGREE','AST','1'),(24,'单位名称','COMPANY','ARES','0'),(25,'担任何种工作','JOB','ARES','0'),(26,'开始时间','BEGINDATE','ARES','2'),(27,'结束时间','ENDDATE','ARES','2'),(28,'离职原因','LEAVEREASON','ARES','0'),(29,'称谓','APPELLATION','AFA','1'),(30,'姓名','NAME','AFA','0'),(31,'年龄','AGE','AFA','0'),(32,'政治面貌','POLITIC','AFA','1'),(33,'工作单位','UNIT','AFA','0'),(34,'联系地址','ADDRESS','AFA','0'),(35,'联系电话','PHONE','AFA','0'),(36,'专业技术职务','PROFESSION','APR','1'),(37,'获取时间','MYDATE','APR','2'),(38,'证书编号','NUMBER','APR','0'),(39,'专长','SPECIAL','APR','0');
INSERT INTO `archive_field` (`ID`,`FIELD_NAME`,`FIELD_CODE`,`TABLE_SHORT_CODE`,`FIELD_TYPE`) VALUES (40,'证书名称','NAME','APR','0'),(41,'考核年度','ASSESSYEAR','AAS','0'),(42,'考核情况','INFO','AAS','0'),(43,'审批时间','MYDATE','AAS','2'),(44,'考核结果','RESULT','AAS','1'),(45,'何时','MYDATE','ARE','2'),(46,'何地','PLACE','ARE','0'),(47,'何种奖励','REWARDS','ARE','0'),(48,'主要事迹','REASON','ARE','0'),(49,'任免情况','INFO','ADU','0'),(50,'任职','duty','ADU','0'),(51,'免职','deposal','ADU','0'),(52,'任免时间','MYDATE','ADU','2'),(53,'任免文号','FILENUMBER','ADU','0'),(1,'真实姓名','REALNAME','AUS','0'),(2,'性别','SEX','AUS','1'),(3,'出生日期','BIRTHDAY','AUS','2'),(4,'籍贯','NATION','AUS','0'),(5,'出生地','BORN','AUS','0'),(6,'入党时间','JPARTYDATE','AUS','2'),(7,'参加工作时间','JWORKDATE','AUS','2'),(8,'健康状况','HEALTHSTATE','AUS','1'),(9,'文化程度','CULTURE','AUS','1'),(10,'后备干部级别','INSUPPORTCADRELEVEL','AUS','1'),(11,'定为后备干部的时间','INSUPPORTCADREDATE','AUS','2');
INSERT INTO `archive_field` (`ID`,`FIELD_NAME`,`FIELD_CODE`,`TABLE_SHORT_CODE`,`FIELD_TYPE`) VALUES (12,'政治面貌','POLITY','AUS','1'),(13,'其它党派加入时间','JOINCLANDATE','AUS','2'),(14,'编制情况','TYPEOFWORK','AUS','1'),(15,'学历','GRADE','AST','1'),(54,'编号','ACCOUNT','AUS','0'),(55,'在职情况','INACTIVESERVICE','AUS','1'),(56,'加入本单位时间','JDEPARTMENTDATE','AUS','2'),(57,'干部来源','CADRESSOURCE','AUS','1'),(58,'过渡时间','TRANSITIONDATE','AUS','2');
CREATE TABLE `archive_privilege` (
`ID` int(11) NOT NULL default '0',
`USERNAME` varchar(20) NOT NULL default '',
`QUERY_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_profession` (
`ID` bigint(20) NOT NULL default '0',
`PROFESSION` varchar(50) default NULL,
`MYDATE` datetime default NULL,
`SPECIAL` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(50) NOT NULL default '',
`NAME` varchar(50) default NULL,
`CNUM` varchar(50) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_profession_his` (
`ID` bigint(20) NOT NULL default '0',
`PROFESSION` varchar(50) default NULL,
`MYDATE` datetime default NULL,
`SPECIAL` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(50) NOT NULL default '',
`NAME` varchar(50) default NULL,
`CNUM` varchar(50) default NULL,
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_query` (
`ID` int(11) NOT NULL default '0',
`TABLE_CODE` varchar(200) NOT NULL default '',
`SHOW_FIELD_CODE` text NOT NULL,
`ORDER_FIELD_CODE` varchar(200) default NULL,
`QUERY_NAME` varchar(200) NOT NULL default '',
`DEPT_CODE` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_query_condition` (
`ID` int(11) NOT NULL default '0',
`QUERY_ID` int(11) NOT NULL default '0',
`CONDITION_FIELD_CODE` text NOT NULL,
`CONDITION_SIGN` varchar(10) NOT NULL default '',
`CONDITION_VALUE` text NOT NULL,
`CONDITION_TYPE` varchar(200) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_resume` (
`ID` bigint(20) NOT NULL default '0',
`COMPANY` varchar(100) default NULL,
`JOB` varchar(50) default NULL,
`BEGINDATE` datetime default NULL,
`ENDDATE` datetime default NULL,
`LEAVEREASON` varchar(100) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(20) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_resume_his` (
`ID` bigint(20) NOT NULL default '0',
`COMPANY` varchar(100) default NULL,
`JOB` varchar(50) default NULL,
`BEGINDATE` datetime default NULL,
`ENDDATE` datetime default NULL,
`LEAVEREASON` varchar(100) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(20) default NULL,
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_rewards` (
`ID` bigint(20) NOT NULL default '0',
`MYDATE` datetime default NULL,
`PLACE` varchar(50) default NULL,
`REWARDS` varchar(50) default NULL,
`REASON` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(50) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_rewards_his` (
`ID` bigint(20) NOT NULL default '0',
`MYDATE` datetime default NULL,
`PLACE` varchar(50) default NULL,
`REWARDS` varchar(50) default NULL,
`REASON` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
`USERNAME` varchar(50) NOT NULL default '',
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_studyinfo` (
`ID` bigint(20) NOT NULL default '0',
`GRADE` varchar(50) default NULL,
`COLLEGE` varchar(150) default NULL,
`SCOLLEGE` varchar(50) default NULL,
`ISJOB` varchar(10) default NULL,
`REMARK` varchar(250) default NULL,
`SPECIALTY` varchar(50) default NULL,
`SSPECIALTY` varchar(50) default NULL,
`BEGINDATE` datetime default NULL,
`ENDDATE` datetime default NULL,
`DEGREE` varchar(50) default NULL,
`USERNAME` varchar(20) default NULL,
`ISMOSTGRADE` char(1) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ARCHIVE_STUDYINFO_INDEX` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_studyinfo_his` (
`ID` bigint(20) NOT NULL default '0',
`GRADE` varchar(50) default NULL,
`COLLEGE` varchar(150) default NULL,
`SCOLLEGE` varchar(50) default NULL,
`ISJOB` varchar(10) default NULL,
`REMARK` varchar(250) default NULL,
`SPECIALTY` varchar(50) default NULL,
`SSPECIALTY` varchar(50) default NULL,
`BEGINDATE` datetime default NULL,
`ENDDATE` datetime default NULL,
`DEGREE` varchar(50) default NULL,
`USERNAME` varchar(20) default NULL,
`OPERATOR` varchar(20) default NULL,
`ADDDATE` datetime default NULL,
`OPERATETYPE` varchar(10) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `archive_table` (
`TABLE_SHORT_CODE` varchar(50) NOT NULL default '',
`TABLE_CODE` varchar(50) NOT NULL default '',
`TABLE_DESCRIPTION` varchar(50) NOT NULL default '',
PRIMARY KEY (`TABLE_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_table` (`TABLE_SHORT_CODE`,`TABLE_CODE`,`TABLE_DESCRIPTION`) VALUES ('AAS','ARCHIVE_ASSESS','考核'),('ADU','ARCHIVE_DUTY','任免'),('AFA','ARCHIVE_FAMILY','家庭'),('APR','ARCHIVE_PROFESSION','专业技能'),('ARES','ARCHIVE_RESUME','履历'),('ARE','ARCHIVE_REWARDS','奖励'),('AST','ARCHIVE_STUDYINFO','教育'),('AUS','ARCHIVE_USER','用户');
CREATE TABLE `archive_user` (
`USERNAME` varchar(20) NOT NULL default '',
`SEX` varchar(10) default 'NULL',
`BIRTHDAY` datetime default NULL,
`NATION` varchar(50) default 'NULL',
`BORN` varchar(250) default 'NULL',
`JPARTYDATE` datetime default NULL,
`JWORKDATE` datetime default NULL,
`HEALTHSTATE` varchar(50) default 'NULL',
`REMARK` varchar(250) default 'NULL',
`CULTURE` varchar(20) default 'NULL',
`INSUPPORTCADRELEVEL` varchar(50) default 'NULL',
`INSUPPORTCADREDATE` datetime default NULL,
`POLITY` varchar(20) default 'NULL',
`JOINCLANDATE` datetime default NULL,
`TYPEOFWORK` varchar(50) default 'NULL',
`REALNAME` varchar(20) default 'NULL',
`IMAGE` varchar(250) default 'NULL',
`JDEPARTMENTDATE` datetime default NULL,
`INACTIVESERVICE` varchar(20) default 'NULL',
`CADRESSOURCE` varchar(20) default 'NULL',
`TRANSITIONDATE` datetime default NULL,
`DEPTCODE` varchar(50) default 'NULL',
`ACCOUNT` varchar(20) default 'NULL\n',
`PEOPLE` varchar(50) default NULL,
`MOSTGRADE` varchar(50) default NULL,
PRIMARY KEY (`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_user` (`USERNAME`,`SEX`,`BIRTHDAY`,`NATION`,`BORN`,`JPARTYDATE`,`JWORKDATE`,`HEALTHSTATE`,`REMARK`,`CULTURE`,`INSUPPORTCADRELEVEL`,`INSUPPORTCADREDATE`,`POLITY`,`JOINCLANDATE`,`TYPEOFWORK`,`REALNAME`,`IMAGE`,`JDEPARTMENTDATE`,`INACTIVESERVICE`,`CADRESSOURCE`,`TRANSITIONDATE`,`DEPTCODE`,`ACCOUNT`,`PEOPLE`,`MOSTGRADE`) VALUES ('11605225628431810865','男',NULL,'dd','dd',NULL,NULL,'亚健康','','小学','科长',NULL,'团员',NULL,'行政','dd','',NULL,'','招考',NULL,'2deputyzjl','dd',NULL,NULL),('11624617811255930823','男',NULL,'asdf','sadf',NULL,NULL,'','sadfsafd','小学','科长',NULL,'团员',NULL,'行政','sdfasdf','',NULL,'','招考',NULL,'2deputyzjl','0',NULL,'专科');
CREATE TABLE `archive_user_his` (
`USERNAME` varchar(20) NOT NULL default '',
`SEX` varchar(10) default NULL,
`BIRTHDAY` datetime default NULL,
`NATION` varchar(50) default NULL,
`BORN` varchar(250) default NULL,
`JPARTYDATE` datetime default NULL,
`JWORKDATE` datetime default NULL,
`HEALTHSTATE` varchar(50) default NULL,
`REMARK` varchar(250) default NULL,
`CULTURE` varchar(20) default NULL,
`INSUPPORTCADRELEVEL` varchar(50) default NULL,
`INSUPPORTCADREDATE` datetime default NULL,
`POLITY` varchar(20) default NULL,
`JOINCLANDATE` datetime default NULL,
`TYPEOFWORK` varchar(50) default NULL,
`REALNAME` varchar(20) default NULL,
`IMAGE` varchar(250) default NULL,
`JDEPARTMENTDATE` datetime default NULL,
`INACTIVESERVICE` varchar(20) default NULL,
`OPERATOR` varchar(20) NOT NULL default '',
`ADDDATE` datetime NOT NULL default '0000-00-00 00:00:00',
`ID` int(11) NOT NULL default '0',
`CADRESSOURCE` varchar(20) default NULL,
`TRANSITIONDATE` datetime default NULL,
`DEPTCODE` varchar(50) default NULL,
`ACCOUNT` varchar(20) default NULL,
`OPERATETYPE` varchar(10) default NULL,
`PEOPLE` varchar(50) default NULL,
`MOSTGRADE` varchar(50) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ARCHIVE_USER_HIS_INDEX` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `archive_user_his` (`USERNAME`,`SEX`,`BIRTHDAY`,`NATION`,`BORN`,`JPARTYDATE`,`JWORKDATE`,`HEALTHSTATE`,`REMARK`,`CULTURE`,`INSUPPORTCADRELEVEL`,`INSUPPORTCADREDATE`,`POLITY`,`JOINCLANDATE`,`TYPEOFWORK`,`REALNAME`,`IMAGE`,`JDEPARTMENTDATE`,`INACTIVESERVICE`,`OPERATOR`,`ADDDATE`,`ID`,`CADRESSOURCE`,`TRANSITIONDATE`,`DEPTCODE`,`ACCOUNT`,`OPERATETYPE`,`PEOPLE`,`MOSTGRADE`) VALUES ('11605225628431810865','男',NULL,'dd','dd',NULL,NULL,'亚健康','','小学','科长',NULL,'团员',NULL,'行政','dd',NULL,NULL,'','admin','2006-10-11 07:22:50',0,'招考',NULL,'2deputyzjl','dd','创建',NULL,NULL),('11624617811255930823','男',NULL,'asdf','sadf',NULL,NULL,'','sadfsafd','小学','科长',NULL,'团员',NULL,'行政','sdfasdf',NULL,NULL,'','admin','2006-11-02 18:07:50',100,'招考',NULL,'2deputyzjl','0','创建',NULL,'专科'),('11624617811255930823','男',NULL,'asdf','sadf',NULL,NULL,'','sadfsafd','小学','科长',NULL,'团员',NULL,'行政','sdfasdf',NULL,NULL,'','admin','2006-11-02 18:08:42',101,'招考',NULL,'2deputyzjl','0','修改',NULL,'专科');
CREATE TABLE `asset_info` (
`Id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`type` varchar(50) default NULL,
`number` varchar(11) default NULL,
`typeId` int(11) default NULL,
`addId` varchar(50) default NULL,
`department` varchar(50) default NULL,
`buyMan` varchar(50) default NULL,
`buyDate` date default NULL,
`keeper` varchar(50) default NULL,
`startDate` date default NULL,
`regDate` date default NULL,
`abstracts` varchar(250) default NULL,
`inputMan` varchar(50) default NULL,
`price` double(20,2) default NULL,
PRIMARY KEY (`Id`),
KEY `name` (`name`),
KEY `typeId` (`typeId`),
KEY `number` (`number`),
KEY `name_number_typeId` (`name`,`number`,`typeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `asset_type_info` (
`Id` int(11) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`depreciationRate` varchar(50) default NULL,
`depreciationYears` int(11) default NULL,
`abstracts` varchar(250) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `basic_rank` (
`code` varchar(20) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`orders` int(11) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `basic_rank` (`code`,`name`,`orders`) VALUES ('11580656594533619880','科长',3),('11580659369536582571','总经理',1),('11580659437962752738','副总经理',2),('11580660647349840180','股长',4);
CREATE TABLE `blog` (
`id` int(11) NOT NULL default '0',
`blogCount` int(11) NOT NULL default '0',
`newBlogUserName` varchar(20) default NULL,
`topicCount` int(11) NOT NULL default '0',
`postCount` int(11) NOT NULL default '0',
`todayCount` int(11) NOT NULL default '0',
`todayDate` varchar(15) NOT NULL default '0',
`yestodayCount` int(11) NOT NULL default '0',
`maxCount` int(11) NOT NULL default '0',
`maxDate` varchar(15) NOT NULL default '0',
`star` varchar(20) default NULL,
`homeClasses` varchar(255) default NULL,
`recommandBlogs` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `blog` (`id`,`blogCount`,`newBlogUserName`,`topicCount`,`postCount`,`todayCount`,`todayDate`,`yestodayCount`,`maxCount`,`maxDate`,`star`,`homeClasses`,`recommandBlogs`) VALUES (1,0,'',0,0,0,'0',0,0,'0','','wx,cx','');
CREATE TABLE `blog_directory` (
`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 '' COMMENT 'not used',
`root_code` varchar(20) NOT NULL default '',
`orders` int(11) NOT NULL default '1',
`child_count` int(11) default '0',
`islocked` tinyint(1) default NULL,
`type` tinyint(3) unsigned default NULL,
`layer` int(11) NOT NULL default '0',
`doc_id` int(11) default NULL,
`template_id` int(11) NOT NULL default '-1',
`pluginCode` varchar(50) NOT NULL default 'N''default''',
`add_date` varchar(15) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `blog_directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`add_date`) VALUES ('c','c语言',0,'','cx','root',1,0,NULL,2,3,NULL,-1,'default','0'),('cx','程序',0,'','root','root',2,2,NULL,0,2,0,-1,'default','0'),('java','JAVA语言',0,'','cx','root',2,0,NULL,2,3,0,-1,'default','0'),('root','全部目录',1,NULL,'-1','root',1,2,NULL,0,1,NULL,-1,'default','0'),('sg','诗歌',0,'','wx','root',3,0,NULL,2,3,NULL,-1,'N'default'','0'),('sw','散文',0,'','wx','root',2,0,NULL,2,3,NULL,-1,'N'default'','0'),('wx','文学',0,'','root','root',1,3,NULL,0,2,0,-1,'default','0'),('xiaoshuo','小说',0,'','wx','root',1,0,NULL,2,3,NULL,-1,'default','0');
CREATE TABLE `blog_user_config` (
`userName` varchar(50) NOT NULL default '',
`title` varchar(50) NOT NULL default '',
`subtitle` varchar(50) default NULL,
`penName` varchar(50) NOT NULL default '',
`skin` varchar(50) NOT NULL default 'default',
`notice` varchar(255) NOT NULL default '',
`isValid` tinyint(1) NOT NULL default '1',
`viewCount` int(11) NOT NULL default '0',
`msgCount` int(11) NOT NULL default '0',
`replyCount` int(11) NOT NULL default '0',
`kind` varchar(50) NOT NULL default '',
`addDate` varchar(15) NOT NULL default '0',
PRIMARY KEY (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `blog_user_dir` (
`code` varchar(50) NOT NULL default '',
`userName` varchar(50) NOT NULL default '',
`dirName` varchar(250) NOT NULL default '',
`catalogCode` varchar(50) NOT NULL default 'N''default''',
`sort` int(11) NOT NULL default '0',
`color` varchar(20) default NULL,
`addDate` varchar(15) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `boardroom` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`personNum` varchar(3) NOT NULL default '',
`description` varchar(67) default NULL,
`address` varchar(17) default NULL,
`equipment` varchar(17) default NULL,
`mydate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `name` USING BTREE (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `boardroom_used_status` (
`Id` int(11) NOT NULL auto_increment,
`boardroomId` int(11) NOT NULL default '0',
`flowId` int(11) default NULL,
`applyUserName` varchar(20) default NULL,
`checkUserName` varchar(20) default NULL,
`beginDate` datetime NOT NULL default '0000-00-00 00:00:00',
`endDate` datetime default NULL,
`topic` varchar(250) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `book` (
`id` int(10) unsigned NOT NULL auto_increment,
`deptCode` varchar(33) default NULL,
`bookName` varchar(66) NOT NULL default '',
`typeId` int(10) unsigned default NULL,
`author` varchar(66) default NULL,
`bookNum` varchar(66) NOT NULL default '',
`pubHouse` varchar(66) default NULL,
`pubDate` date NOT NULL default '0000-00-00',
`keepSite` varchar(16) default NULL,
`price` double(10,2) default NULL,
`abstracts` varchar(66) default NULL,
`borrowRange` varchar(66) default NULL,
`borrowState` tinyint(1) default NULL,
`brief` varchar(66) default NULL,
`borrowPerson` varchar(66) default NULL,
`beginDate` date default NULL,
`endDate` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `book_type` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(150) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cms_comment` (
`id` int(11) NOT NULL auto_increment,
`content` text NOT NULL,
`add_date` datetime NOT NULL default '0000-00-00 00:00:00',
`doc_id` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`nick` varchar(50) default NULL,
`link` varchar(100) default NULL,
PRIMARY KEY (`id`),
KEY `IX_comment` (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cms_images` (
`id` int(11) NOT NULL auto_increment,
`path` varchar(200) NOT NULL default '',
`mainkey` varchar(20) NOT NULL default '',
`kind` varchar(20) NOT NULL default '',
`subkey` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `IX_images` (`mainkey`),
KEY `IX_images_1` (`kind`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `cms_images` (`id`,`path`,`mainkey`,`kind`,`subkey`) VALUES (10,'upfile/webeditimg/2006/8/2357ddd8a4354a8b82292978ec6821f6.jpg','1','document',1),(11,'upfile/webeditimg/2006/8/528e140122ca4930a85d31ca942a0ab3.jpg','2','document',1),(12,'upfile/webeditimg/2006/8/96ede6606c104816bc9f7a6722929a9c.jpg','3','document',1);
CREATE TABLE `customer_share` (
`Id` int(11) NOT NULL auto_increment,
`customerId` int(11) default '0',
`sharePerson` varchar(50) default '0',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `customer_share` (`Id`,`customerId`,`sharePerson`) VALUES (4,1,'张燕'),(5,2,'admin');
CREATE TABLE `department` (
`code` varchar(20) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`description` varchar(255) default NULL,
`parentCode` varchar(20) NOT NULL default '',
`rootCode` varchar(20) NOT NULL default '',
`orders` int(11) NOT NULL default '1',
`childCount` int(11) NOT NULL default '0',
`addDate` datetime NOT NULL default '0000-00-00 00:00:00',
`type` int(3) NOT NULL default '1',
`layer` int(11) NOT NULL default '1',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
INSERT INTO `department` (`code`,`name`,`description`,`parentCode`,`rootCode`,`orders`,`childCount`,`addDate`,`type`,`layer`) VALUES ('2deputyzjl','第一副总经理室','','zjl','root',1,2,'2006-02-12 10:54:50',1,3),('admin','管理员','','root','root',2,0,'2006-02-26 17:27:27',1,2),('cjywb','国际业务部','','ggb','root',2,0,'2006-06-21 09:47:25',1,5),('cnywb','国内业务部','','ggb','root',3,0,'2006-06-21 09:47:42',1,5),('cwb','财务部','','cwzj','root',1,0,'2006-06-21 09:39:58',1,5),('cwzj','财务总监','','deputy','root',2,2,'2006-06-21 09:39:17',1,4),('deputy','第二副总经理室','','zjl','root',2,2,'2006-02-12 10:54:50',1,3),('ggb','市场总监','','2deputyzjl','root',3,4,'2006-02-12 10:54:50',1,4),('jsb','行政总监','','deputy','root',1,2,'2006-02-12 10:54:50',1,4),('jxfwb','技术服务部','','ggb','root',4,0,'2006-06-21 09:48:04',1,5),('rlzyb','人力资源部','','jsb','root',2,0,'2006-06-21 09:41:35',1,5),('root','全部',NULL,'-1','root',1,2,'2006-02-12 10:54:50',1,1),('scb','技术总监','','2deputyzjl','root',2,3,'2006-02-12 10:54:50',1,4);
INSERT INTO `department` (`code`,`name`,`description`,`parentCode`,`rootCode`,`orders`,`childCount`,`addDate`,`type`,`layer`) VALUES ('scb1','市场部','','ggb','root',1,0,'2006-06-21 09:47:04',1,5),('xzb','行政部','','jsb','root',1,0,'2006-06-21 09:41:17',1,5),('yfzx','研发中心','','scb','root',1,0,'2006-06-21 09:43:37',1,5),('zcb','证券部','','cwzj','root',2,0,'2006-06-21 09:40:25',1,5),('zjl','总经理室','','root','root',1,2,'2006-02-12 10:54:50',2,2),('zjzx','质检中心','','scb','root',2,0,'2006-06-21 09:44:17',1,5);
CREATE TABLE `dept_user` (
`ID` int(11) NOT NULL default '0',
`DEPT_CODE` varchar(20) NOT NULL default '',
`USER_NAME` varchar(20) default NULL,
`ORDERS` int(11) NOT NULL default '1',
`RANK` varchar(20) default NULL,
PRIMARY KEY (`ID`),
KEY `dept_code` (`DEPT_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `dept_user` (`ID`,`DEPT_CODE`,`USER_NAME`,`ORDERS`,`RANK`) VALUES (0,'admin','admin',0,NULL);
CREATE TABLE `dir_priv` (
`id` int(11) NOT NULL auto_increment,
`dir_code` varchar(50) NOT NULL default '',
`see` tinyint(1) NOT NULL default '1',
`append` tinyint(1) NOT NULL default '0',
`del` tinyint(1) NOT NULL default '0',
`modify` tinyint(1) NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`priv_type` tinyint(1) NOT NULL default '0',
`examine` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `IX_dir_priv` (`dir_code`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `directory` (
`code` varchar(50) NOT NULL default '',