Jsp/Servlet

开发平台：

Java

redmoonoa.sql：源码内容

`content` longtext NOT NULL,
`recount` int(11) NOT NULL default '0',
`hit` int(11) NOT NULL default '0',
`lydate` varchar(15) NOT NULL default '0',
`ip` varchar(15) default NULL,
`msg_level` int(11) NOT NULL default '0',
`isprivate` tinyint(1) NOT NULL default '1',
`msg_type` tinyint(3) unsigned default '0',
`filename` varchar(250) default NULL,
`extname` varchar(3) default NULL,
`iselite` tinyint(1) NOT NULL default '0',
`islocked` tinyint(1) NOT NULL default '0',
`isguide` tinyint(3) unsigned NOT NULL default '0',
`show_ubbcode` tinyint(1) NOT NULL default '1',
`show_smile` tinyint(1) NOT NULL default '1',
`email_notify` tinyint(1) NOT NULL default '0',
`replier` varchar(20) default NULL,
`redate` varchar(15) default NULL,
`iswebedit` tinyint(3) unsigned NOT NULL default '0',
`color` varchar(20) default NULL,
`colorExpire` varchar(15) NOT NULL default '0',
`isBold` tinyint(1) NOT NULL default '0',
`boldExpire` varchar(15) NOT NULL default '0',
`isBlog` tinyint(1) NOT NULL default '0',
`blogUserDir` varchar(50) NOT NULL default 'default',
`replyRootName` varchar(50) default NULL,
`pluginCode` varchar(20) default NULL,
`plugin2Code` varchar(20) default NULL,
`thread_type` int(11) NOT NULL default '0',
`check_status` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `rootid` (`rootid`)
) 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` text NOT NULL,
`diskname` varchar(100) NOT NULL default '',
`visualpath` varchar(200) NOT NULL default '',
`orders` int(11) NOT NULL default '0',
`DOWNLOAD_COUNT` int(11) NOT NULL default '0',
`UPLOAD_DATE` varchar(15) NOT NULL default '0',
`FILE_SIZE` bigint(20) NOT NULL default '0',
`USER_NAME` varchar(20) default NULL,
PRIMARY KEY (`id`),
KEY `msgId` (`msgId`),
KEY `idx_upload_date` (`UPLOAD_DATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_online` (
`name` varchar(50) 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 '0',
`staytime` varchar(15) NOT NULL default '0',
`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 ('1172557619156662517509','ygtd','127.0.0.1',NULL,'1172557619156','1172557619156',1,0);
CREATE TABLE `sq_poll` (
`msg_id` bigint(20) unsigned NOT NULL auto_increment,
`expire_date` date default NULL,
`max_choice` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_poll_option` (
`msg_id` bigint(20) NOT NULL default '0',
`orders` int(10) unsigned NOT NULL default '0',
`vote_user` text,
`content` varchar(45) NOT NULL default '',
`vote_count` int(11) NOT NULL default '0',
PRIMARY KEY (`msg_id`,`orders`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_setup_user_level` (
`levelAmount` int(11) NOT NULL default '0',
`description` varchar(50) NOT NULL default '',
`levelPicPath` varchar(255) default NULL,
`groupCode` varchar(20) default NULL,
PRIMARY KEY (`levelAmount`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_setup_user_level` (`levelAmount`,`description`,`levelPicPath`,`groupCode`) VALUES (0,'初入江湖','level1.gif','everyone'),(1000,'小有名气','level2.gif',''),(2000,'名动一方','level3.gif',''),(3000,'天下闻名','level4.gif',''),(4000,'一代宗师','level5.gif',''),(5000,'超凡入圣','level6.gif',''),(6000,'天外飞仙','level7.gif',''),(7000,'无所不能','level8.gif','');
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 '0',
`redate` varchar(15) default '0' 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',
`check_status` tinyint(3) NOT NULL default '1',
`thread_type` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `boardcode` (`boardcode`),
KEY `name` (`name`),
KEY `blog_name_blogUserDir` (`name`,`blogUserDir`),
KEY `lydate` (`lydate`),
KEY `redate` (`redate`),
KEY `hit` (`hit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_thread_type` (
`id` int(11) NOT NULL default '0',
`board_code` varchar(20) NOT NULL default '',
`display_order` int(10) unsigned NOT NULL default '1',
`name` varchar(20) NOT NULL default '',
`color` varchar(20) default NULL,
PRIMARY KEY (`id`),
KEY `board_code` (`board_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `sq_user` (
`name` varchar(20) NOT NULL default '',
`pwd` varchar(32) default NULL,
`rawPwd` varchar(32) default NULL,
`RegDate` varchar(15) NOT NULL default '0',
`realname` varchar(50) 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(10) default NULL,
`Birthday` varchar(15) default '0',
`IDCard` varchar(50) default NULL,
`Career` varchar(100) default NULL,
`Job` varchar(50) default NULL,
`State` varchar(50) default NULL,
`City` varchar(50) default NULL,
`Address` varchar(255) default NULL,
`PostCode` varchar(50) default NULL,
`Phone` varchar(50) default NULL,
`Mobile` varchar(50) default NULL,
`Hobbies` varchar(50) default NULL,
`lastTime` varchar(15) NOT NULL default '0',
`curTime` varchar(15) NOT NULL default '0',
`sign` varchar(200) 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',
`arrestreason` text,
`arresttime` varchar(15) default NULL,
`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 '1024000',
`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 '',
`releasetime` varchar(15) NOT NULL default '0',
`home` varchar(200) 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,
`locale` varchar(20) default NULL,
`nick` varchar(20) NOT NULL default '',
`check_status` tinyint(3) NOT NULL default '1',
PRIMARY KEY (`name`),
KEY `RegDate` (`RegDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_user` (`name`,`pwd`,`rawPwd`,`RegDate`,`realname`,`RealPic`,`Question`,`Answer`,`Email`,`Gender`,`OICQ`,`Birthday`,`IDCard`,`Career`,`Job`,`State`,`City`,`Address`,`PostCode`,`Phone`,`Mobile`,`Hobbies`,`lastTime`,`curTime`,`sign`,`myface`,`myfacewidth`,`myfaceheight`,`favoriate`,`ispolice`,`arrestday`,`arrestreason`,`arresttime`,`arrestpolice`,`experience`,`credit`,`addcount`,`delcount`,`eliteCount`,`Marriage`,`gold`,`isValid`,`diskSpaceAllowed`,`diskSpaceUsed`,`isSecret`,`IP`,`timeZone`,`releasetime`,`home`,`msn`,`group_code`,`icq`,`uc`,`yahoo`,`locale`,`nick`,`check_status`) VALUES ('admin',NULL,NULL,'1157098314031',NULL,'face.gif',NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',NULL,NULL,120,150,NULL,0,0,NULL,NULL,NULL,0,500,0,0,0,0,0,1,1024000,0,1,NULL,'','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin',1);
CREATE TABLE `sq_user_group` (
`code` varchar(50) NOT NULL default '',
`description` varchar(50) NOT NULL default '',
`isSystem` tinyint(1) NOT NULL default '0',
`display_order` int(11) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_user_group` (`code`,`description`,`isSystem`,`display_order`) VALUES ('everyone','所有人',1,1);
CREATE TABLE `sq_user_group_priv` (
`group_code` varchar(20) NOT NULL default '',
`priv` varchar(50) NOT NULL default '',
`add_topic` char(1) NOT NULL default '1',
`reply_topic` char(1) NOT NULL default '1',
`vote` char(1) NOT NULL default '1',
`search` char(1) NOT NULL default '1',
`attach_upload` char(1) NOT NULL default '1',
`attach_download` char(1) NOT NULL default '1',
`board_code` varchar(50) NOT NULL default '',
`money_code` varchar(20) default NULL,
`money_sum` int(11) NOT NULL default '0',
`is_default` char(1) NOT NULL default '1',
`enter_board` char(1) NOT NULL default '1',
`view_topic` char(1) NOT NULL default '1',
PRIMARY KEY (`group_code`,`board_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user''s privilege';
CREATE TABLE `sq_user_priv` (
`user_name` varchar(20) NOT NULL default '',
`priv` varchar(50) NOT NULL default '',
`attach_day_count` int(10) unsigned default NULL,
`attach_size` int(10) unsigned default '0' COMMENT 'unit is K',
`add_topic` char(1) default '1',
`reply_topic` char(1) default '1',
`vote` char(1) default '1',
`search` char(1) default '1',
`attach_upload` char(1) default '1',
`attach_download` char(1) default '1',
`attach_today` varchar(15) default NULL,
`attach_today_upload_count` int(10) unsigned NOT NULL default '0',
`is_default` char(1) default '1',
PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='user''s privilege';
CREATE TABLE `sq_user_prop` (
`name` varchar(20) NOT NULL default '',
`flower_count` int(11) NOT NULL default '0',
`egg_count` int(11) NOT NULL default '0',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `sq_user_prop` (`name`,`flower_count`,`egg_count`) VALUES ('1',0,0),('admin',0,0);
CREATE TABLE `sq_user_treasure` (
`userName` varchar(50) NOT NULL default '',
`treasureCode` varchar(50) NOT NULL default '',
`buyDate` varchar(15) NOT NULL default '0',
`amount` int(11) NOT NULL default '0',
UNIQUE KEY `IX_sq_user_treasure` (`userName`,`treasureCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `task` (
`id` int(11) NOT NULL default '0',
`initiator` varchar(20) NOT NULL default '',
`title` varchar(34) NOT NULL default '',
`content` longtext NOT NULL,
`person` varchar(20) default NULL,
`rootid` int(11) NOT NULL default '0',
`type` varchar(4) NOT NULL default '',
`layer` int(11) NOT NULL default '0',
`orders` int(11) NOT NULL default '0',
`parentid` int(11) NOT NULL default '-1',
`mydate` datetime NOT NULL default '0000-00-00 00:00:00',
`IP` varchar(15) NOT NULL default '',
`expression` tinyint(3) unsigned NOT NULL default '0',
`recount` int(11) NOT NULL default '0',
`fileName` varchar(7) default NULL,
`ext` varchar(10) default NULL,
`status` tinyint(1) NOT NULL default '0',
`jobCode` varchar(11) default '20',
`actionId` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `initiator` (`initiator`),
KEY `person` (`person`),
KEY `actionId` USING BTREE (`actionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `task_attach` (
`id` int(11) NOT NULL auto_increment,
`taskId` int(11) NOT NULL default '0',
`fullPath` varchar(250) NOT NULL default '0',
`diskName` varchar(250) NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`visualPath` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `taskId` (`taskId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_admin_dept` (
`id` int(11) NOT NULL default '0',
`userName` varchar(20) NOT NULL default '',
`deptCode` varchar(20) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_archive` (
`id` varchar(20) NOT NULL default '',
`name` varchar(20) NOT NULL default '',
`realName` varchar(20) default NULL,
`birthday` date default NULL,
`nation` varchar(10) default NULL,
`IDCard` varchar(20) default NULL,
`photo` varchar(250) default NULL,
`gender` tinyint(1) NOT NULL default '0',
`marriage` tinyint(1) NOT NULL default '0',
`jiGuan` varchar(20) default NULL,
`hukouAddress` varchar(250) default NULL,
`xueLi` int(11) NOT NULL default '0',
`zhuanYe` varchar(50) default NULL,
`school` varchar(50) default NULL,
`workDate` date default NULL,
`workDateAtHere` date default NULL,
`dept` varchar(50) default NULL,
`zhiWu` varchar(50) default NULL,
`zhiChen` varchar(20) default NULL,
`politics` int(11) NOT NULL default '0',
`homeAddress` varchar(250) default NULL,
`homeTel` varchar(20) default NULL,
`email` varchar(30) default NULL,
`postChange` text,
`education` text,
`resume` text,
`socialRelation` text,
`jiangchenRecord` text,
`zhiwuQinkuang` text,
`trainRecord` text,
`danbaoRecord` varchar(11) default NULL,
`contract` text,
`insure` text,
`tijianRecord` text,
`remark` text,
`attachment` varchar(250) default NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_desktop_setup` (
`ID` int(10) unsigned NOT NULL default '0',
`USER_NAME` varchar(20) NOT NULL default '',
`TITLE` varchar(255) NOT NULL default '',
`COUNT` int(10) unsigned NOT NULL default '10',
`WIN_LEFT` int(10) unsigned NOT NULL default '0',
`WIN_TOP` int(10) unsigned NOT NULL default '0',
`WIN_WIDTH` int(10) unsigned NOT NULL default '200',
`WIN_HEIGHT` int(10) unsigned NOT NULL default '100',
`MODULE_CODE` varchar(20) default NULL,
`MODULE_ITEM` varchar(100) default NULL,
`IS_SYSTEM` int(10) unsigned NOT NULL default '0',
`MORE_PAGE` varchar(255) default NULL,
`IS_LOCKED` char(1) NOT NULL default '',
`ZINDEX` int(10) unsigned NOT NULL default '100',
`WIN_MIN` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `user_name` (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `user_desktop_setup` (`ID`,`USER_NAME`,`TITLE`,`COUNT`,`WIN_LEFT`,`WIN_TOP`,`WIN_WIDTH`,`WIN_HEIGHT`,`MODULE_CODE`,`MODULE_ITEM`,`IS_SYSTEM`,`MORE_PAGE`,`IS_LOCKED`,`ZINDEX`,`WIN_MIN`) VALUES (1,'1','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(2,'1','待办工作流',20,6,0,418,244,'flow','',0,NULL,'',1,0),(3,'1','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(4,'1','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(5,'1','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(6,'1','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(12,'bluewind','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(13,'bluewind','待办工作流',20,6,0,418,244,'flow','',0,NULL,'',1,0),(14,'bluewind','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(15,'bluewind','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(16,'bluewind','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(17,'bluewind','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(365,'test','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0);
INSERT INTO `user_desktop_setup` (`ID`,`USER_NAME`,`TITLE`,`COUNT`,`WIN_LEFT`,`WIN_TOP`,`WIN_WIDTH`,`WIN_HEIGHT`,`MODULE_CODE`,`MODULE_ITEM`,`IS_SYSTEM`,`MORE_PAGE`,`IS_LOCKED`,`ZINDEX`,`WIN_MIN`) VALUES (366,'test','待办工作流',20,6,0,418,244,'flow','',0,NULL,'',1,0),(367,'test','任务督办',10,7,523,418,269,'task','',0,NULL,'',3,0),(368,'test','短消息',10,7,255,418,265,'msg','',0,NULL,'',2,0),(369,'test','论坛新贴',10,431,514,371,264,'forum','',0,NULL,'',3,0),(370,'test','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(397,'3','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(398,'3','待办工作流',20,6,0,418,252,'flow','',0,NULL,'',2,0),(399,'3','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(400,'3','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(401,'3','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(402,'3','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(430,'2','公共通知',10,429,0,371,250,'fileark','notice',0,NULL,'',5,0),(431,'2','待办工作流',20,6,0,418,248,'flow','',0,NULL,'',15,0);
INSERT INTO `user_desktop_setup` (`ID`,`USER_NAME`,`TITLE`,`COUNT`,`WIN_LEFT`,`WIN_TOP`,`WIN_WIDTH`,`WIN_HEIGHT`,`MODULE_CODE`,`MODULE_ITEM`,`IS_SYSTEM`,`MORE_PAGE`,`IS_LOCKED`,`ZINDEX`,`WIN_MIN`) VALUES (432,'2','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(433,'2','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(434,'2','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(435,'2','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(441,'111','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(442,'111','待办工作流',20,6,0,418,244,'flow','',0,NULL,'',1,0),(443,'111','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(444,'111','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(445,'111','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(446,'111','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(452,'admin','公共通知',10,432,2,371,257,'fileark','notice',0,NULL,'',12,0),(453,'admin','待办工作流',20,10,1,416,271,'flow','',0,NULL,'',37,0),(454,'admin','任务督办',10,14,528,418,285,'task','',0,NULL,'',11,0);
INSERT INTO `user_desktop_setup` (`ID`,`USER_NAME`,`TITLE`,`COUNT`,`WIN_LEFT`,`WIN_TOP`,`WIN_WIDTH`,`WIN_HEIGHT`,`MODULE_CODE`,`MODULE_ITEM`,`IS_SYSTEM`,`MORE_PAGE`,`IS_LOCKED`,`ZINDEX`,`WIN_MIN`) VALUES (455,'admin','短消息',10,6,278,422,252,'msg','',0,NULL,'',26,0),(456,'admin','论坛新贴',10,432,537,374,280,'forum','',0,NULL,'',15,0),(457,'admin','日程安排',10,432,278,373,260,'plan','',0,NULL,'',15,0),(464,'张晨','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(465,'333','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(466,'222','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(467,'5','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(469,'6','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(470,'3','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',3,0),(471,'2','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',16,0),(473,'test','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',4,0),(475,'张晨','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',2,0);
INSERT INTO `user_desktop_setup` (`ID`,`USER_NAME`,`TITLE`,`COUNT`,`WIN_LEFT`,`WIN_TOP`,`WIN_WIDTH`,`WIN_HEIGHT`,`MODULE_CODE`,`MODULE_ITEM`,`IS_SYSTEM`,`MORE_PAGE`,`IS_LOCKED`,`ZINDEX`,`WIN_MIN`) VALUES (476,'333','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',2,0),(477,'222','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',2,0),(478,'5','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',2,0),(480,'6','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',2,0),(481,'3','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',4,0),(482,'2','公共通知',10,664,65,371,250,'fileark','notice',0,NULL,'',17,0),(487,'张晨','文章',500,0,0,200,100,'document','255',0,NULL,'',3,0),(489,'222','文章',500,0,0,200,100,'document','255',0,NULL,'',3,0),(490,'5','文章',500,0,0,200,100,'document','255',0,NULL,'',3,0),(492,'6','文章',500,0,0,200,100,'document','255',0,NULL,'',3,0),(493,'3','文章',500,0,0,200,100,'document','255',0,NULL,'',5,0),(494,'2','文章',500,0,0,200,100,'document','255',0,NULL,'',18,0);
INSERT INTO `user_desktop_setup` (`ID`,`USER_NAME`,`TITLE`,`COUNT`,`WIN_LEFT`,`WIN_TOP`,`WIN_WIDTH`,`WIN_HEIGHT`,`MODULE_CODE`,`MODULE_ITEM`,`IS_SYSTEM`,`MORE_PAGE`,`IS_LOCKED`,`ZINDEX`,`WIN_MIN`) VALUES (507,'我是谁','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(508,'我是谁','待办工作流',20,6,0,418,244,'flow','',0,NULL,'',1,0),(509,'我是谁','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(510,'我是谁','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(511,'我是谁','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(512,'我是谁','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0),(518,'你','公共通知',10,430,0,371,246,'fileark','notice',0,NULL,'',1,0),(519,'你','待办工作流',20,6,0,418,244,'flow','',0,NULL,'',1,0),(520,'你','任务督办',10,8,512,418,265,'task','',0,NULL,'',1,0),(521,'你','短消息',10,7,255,418,248,'msg','',0,NULL,'',1,0),(522,'你','论坛新贴',10,431,514,371,260,'forum','',0,NULL,'',1,0),(523,'你','日程安排',10,431,254,371,253,'plan','',0,NULL,'',1,0);
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),('ky','一般科员',0);
CREATE TABLE `user_group_of_role` (
`userGroupCode` varchar(50) NOT NULL default '',
`roleCode` varchar(50) NOT NULL default '',
KEY `IX_user_of_role` (`userGroupCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_group_priv` (
`groupCode` varchar(20) NOT NULL default '',
`priv` varchar(20) NOT NULL default '',
KEY `IX_group_priv` (`groupCode`)
) 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;
INSERT INTO `user_of_group` (`user_name`,`group_code`) VALUES ('admin','Administrators');
CREATE TABLE `user_of_role` (
`userName` varchar(50) NOT NULL default '',
`roleCode` varchar(50) NOT NULL default '',
KEY `IX_user_of_role` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_plan` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`content` tinytext,
`userName` varchar(20) NOT NULL default '',
`myDate` datetime NOT NULL default '0000-00-00 00:00:00',
`zdrq` datetime NOT NULL default '0000-00-00 00:00:00',
`isRemind` tinyint(1) NOT NULL default '0',
`remindDate` datetime default NULL,
`remindCount` int(11) NOT NULL default '0',
`IS_REMIND_BY_SMS` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `myDate` (`myDate`),
KEY `remindDate_myDate` (`remindDate`,`myDate`)
) 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 `user_role` (
`code` varchar(50) NOT NULL default '',
`description` varchar(50) NOT NULL default '',
`isSystem` tinyint(1) NOT NULL default '0',
`orders` int(11) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_role_priv` (
`roleCode` varchar(20) NOT NULL default '',
`priv` varchar(20) NOT NULL default '',
KEY `IX_role_priv` (`roleCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `user_setup` (
`USER_NAME` varchar(20) NOT NULL default '',
`MESSAGE_TO_DEPT` varchar(255) default NULL,
`MESSAGE_TO_USERGROUP` varchar(255) default NULL,
`MESSAGE_TO_USERROLE` varchar(255) default NULL,
`MESSAGE_TO_MAX_USER` int(11) NOT NULL default '5',
`MESSAGE_USER_MAX_COUNT` int(11) NOT NULL default '800',
`IS_MSG_WIN_POPUP` tinyint(1) NOT NULL default '1',
`IS_CHAT_SOUND_PLAY` tinyint(1) NOT NULL default '1',
`IS_CHAT_ICON_SHOW` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `user_setup` (`USER_NAME`,`MESSAGE_TO_DEPT`,`MESSAGE_TO_USERGROUP`,`MESSAGE_TO_USERROLE`,`MESSAGE_TO_MAX_USER`,`MESSAGE_USER_MAX_COUNT`,`IS_MSG_WIN_POPUP`,`IS_CHAT_SOUND_PLAY`,`IS_CHAT_ICON_SHOW`) VALUES ('admin','','','',5,800,1,1,1);
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`pwd` varchar(32) default NULL,
`pwdRaw` varchar(32) default NULL,
`regDate` datetime NOT NULL default '0000-00-00 00:00:00',
`realName` varchar(17) default NULL,
`picture` varchar(17) default NULL COMMENT '论坛中所用的图片',
`email` varchar(17) default NULL,
`gender` tinyint(1) default '0',
`QQ` varchar(15) default NULL,
`birthday` datetime default NULL,
`IDCard` varchar(17) default NULL,
`isMarriaged` tinyint(1) NOT NULL default '0' COMMENT '0 未婚',
`state` varchar(17) default NULL,
`city` varchar(17) default NULL,
`address` varchar(17) default NULL,
`postCode` varchar(20) default NULL,
`phone` varchar(17) default NULL,
`mobile` varchar(12) default NULL,
`hobbies` varchar(17) default NULL,
`lastTime` datetime NOT NULL default '0000-00-00 00:00:00',
`isValid` tinyint(3) unsigned NOT NULL default '1' COMMENT '1 有效 0 禁止',
`emailName` varchar(20) default NULL,
`MSN` varchar(20) default NULL,
`proxy` varchar(20) default NULL COMMENT 'null -- no proxy 代理者的职位编码',
`proxyBeginDate` datetime default NULL,
`proxyEndDate` datetime default NULL,
`diskSpaceAllowed` bigint(20) NOT NULL default '10240000',
`diskSpaceUsed` bigint(20) NOT NULL default '0',
`rankCode` varchar(20) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `Index_mobile` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `users` (`id`,`name`,`pwd`,`pwdRaw`,`regDate`,`realName`,`picture`,`email`,`gender`,`QQ`,`birthday`,`IDCard`,`isMarriaged`,`state`,`city`,`address`,`postCode`,`phone`,`mobile`,`hobbies`,`lastTime`,`isValid`,`emailName`,`MSN`,`proxy`,`proxyBeginDate`,`proxyEndDate`,`diskSpaceAllowed`,`diskSpaceUsed`,`rankCode`) VALUES (2,'admin','96e79218965eb72c92a549dd5a330112','111111','2006-08-30 00:00:00','admin',NULL,NULL,0,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',1,NULL,NULL,'',NULL,NULL,10240000,0,NULL);
CREATE TABLE `vehicle` (
`licenseNo` varchar(50) NOT NULL default '',
`engineNo` varchar(50) NOT NULL default '',
`type` int(11) default NULL,
`driver` varchar(20) NOT NULL default '',
`price` varchar(20) NOT NULL default '0',
`image` varchar(255) default NULL,
`buyDate` datetime NOT NULL default '0000-00-00 00:00:00',
`state` int(11) default NULL,
`remark` text,
`brand` varchar(200) default NULL,
PRIMARY KEY (`licenseNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `vehicle_driver` (
`Id` int(11) NOT NULL auto_increment,
`userName` varchar(20) NOT NULL default '',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `vehicle_maintenance` (
`id` int(11) NOT NULL default '0',
`licenseNo` varchar(50) NOT NULL default '',
`beginDate` datetime NOT NULL default '0000-00-00 00:00:00',
`endDate` datetime default NULL,
`type` int(11) NOT NULL default '0',
`cause` varchar(200) default NULL,
`expense` varchar(50) default NULL,
`transactor` varchar(20) NOT NULL default '',
`remark` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `vehicle_type` (
`Id` int(11) NOT NULL auto_increment,
`typeCode` varchar(11) default NULL,
`description` varchar(11) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `vehicle_use` (
`id` int(11) NOT NULL default '0',
`licenseNo` varchar(50) NOT NULL default '',
`beginDate` datetime NOT NULL default '0000-00-00 00:00:00',
`endDate` datetime default NULL,
`vehicleUser` varchar(20) NOT NULL default '',
`vehicleDeptNo` int(11) NOT NULL default '0',
`transactor` varchar(20) NOT NULL default '',
`destination` varchar(50) NOT NULL default '',
`cause` text,
`remark` text,
`state` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `visual_attach` (
`id` int(11) NOT NULL auto_increment,
`visualId` int(11) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`fullpath` text NOT NULL,
`diskname` varchar(100) NOT NULL default '',
`visualpath` varchar(200) NOT NULL default '',
`orders` int(11) NOT NULL default '0',
`formCode` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `visualId` (`visualId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `work_log` (
`id` int(11) NOT NULL auto_increment,
`userName` varchar(20) NOT NULL default '',
`content` text NOT NULL,
`myDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `work_plan` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(250) default NULL,
`content` text,
`beginDate` date default NULL,
`endDate` date default NULL,
`typeId` int(11) NOT NULL default '0',
`remark` text,
`principal` varchar(100) default NULL,
`isMessageRemind` tinyint(1) NOT NULL default '1',
`author` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `work_plan_attach` (
`id` int(11) NOT NULL auto_increment,
`workPlanId` int(11) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`fullpath` varchar(255) NOT NULL default '',
`diskname` varchar(100) NOT NULL default '',
`visualpath` varchar(200) NOT NULL default '',
`page_num` int(11) NOT NULL default '1',
`orders` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `workPlanId` (`workPlanId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `work_plan_dept` (
`workPlanId` int(11) default NULL,
`deptCode` varchar(50) default NULL,
KEY `workPlanId` (`workPlanId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `work_plan_type` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`orders` int(11) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `work_plan_user` (
`workPlanId` int(11) default NULL,
`userName` varchar(20) NOT NULL default '',
KEY `workPlanId` (`workPlanId`)
) 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 */;