⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 redmoonoa.sql

📁 oa 源代码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
  `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 '',
  `name` varchar(50) NOT NULL default '',
  `isHome` tinyint(1) NOT NULL default '0',
  `description` varchar(255) default NULL,
  `parent_code` varchar(50) NOT NULL default '',
  `root_code` varchar(50) NOT NULL default '',
  `orders` int(11) NOT NULL default '1',
  `child_count` int(11) default NULL,
  `add_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `islocked` tinyint(1) default NULL,
  `type` tinyint(3) unsigned default NULL,
  `layer` int(11) NOT NULL default '1',
  `doc_id` int(11) default NULL,
  `template_id` int(11) NOT NULL default '-1',
  `pluginCode` varchar(20) NOT NULL default 'default',
  `IS_SYSTEM` tinyint(1) NOT NULL default '0',
  `target` varchar(20) default NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`IS_SYSTEM`,`target`) VALUES ('a','a',1,'a','root','root',6,0,'2006-12-13 21:59:59',NULL,2,2,NULL,-1,'default',0,''),('aaa','aaa',1,'aaa.ppt','notice','root',3,1,'2007-01-15 12:44:58',NULL,3,3,NULL,-1,'default',0,''),('bbb','bbb',1,'bbb.ppt','aaa','root',1,0,'2007-01-15 12:45:18',NULL,3,4,NULL,-1,'default',0,''),('blog','博客',0,'','root','root',3,2,'2006-08-03 17:38:00',NULL,0,2,0,-1,'default',0,NULL),('blog_ad','广告',1,'','blog','root',2,4,'2006-08-03 17:38:49',NULL,0,3,0,-1,'default',1,NULL),('blog_ad1','公告旁的广告',1,'','blog_ad','root',1,0,'2006-08-03 17:39:23',NULL,1,4,1,-1,'default',0,NULL),('blog_ad2','首页中部横幅',0,'','blog_ad','root',2,0,'2006-08-03 17:39:42',NULL,1,4,2,-1,'default',0,NULL),('blog_ad3','首页底部横幅广告',1,'','blog_ad','root',3,0,'2006-08-03 17:40:00',NULL,1,4,3,-1,'default',0,NULL),('blog_ad4','右下友情链接',0,'','blog_ad','root',4,0,'2006-11-19 18:58:45',NULL,1,4,145,-1,'default',1,NULL);
INSERT INTO `directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`IS_SYSTEM`,`target`) VALUES ('blog_notice','博客通知',1,'','blog','root',1,0,'2006-08-03 17:38:35',NULL,2,3,0,-1,'default',1,NULL),('dd','dd',1,'http://www.sina.com.cn','news','root',1,0,'2006-11-24 10:28:32',NULL,3,3,NULL,-1,'default',0,''),('news','新闻',1,'','root','root',4,1,'2006-07-07 08:19:33',NULL,2,2,0,-1,'default',1,'_parent'),('news2','新闻2',1,'','root','root',5,0,'2006-11-24 09:02:23',NULL,2,2,NULL,-1,'default',0,NULL),('notice','公共通知',1,'','root','root',2,3,'2006-04-04 08:25:36',NULL,2,2,0,-1,'sms',1,NULL),('root','全部分类',1,'','-1','root',1,6,'2006-02-10 00:00:00',NULL,0,1,0,-1,'default',1,NULL),('ss','ss',1,'','notice','root',2,0,'2006-11-24 09:30:09',NULL,2,3,0,-1,'default',0,NULL),('template','模板',0,'','root','root',1,-1,'2006-02-15 13:32:53',NULL,0,2,NULL,-1,'default',1,NULL),('vvv','第一章',1,'1.ppt','notice','root',1,0,'2006-11-24 09:27:27',NULL,3,3,0,-1,'default',0,'');
CREATE TABLE `doc_content` (
  `doc_id` int(11) NOT NULL default '0',
  `content` longtext NOT NULL,
  `page_num` int(11) NOT NULL default '1',
  UNIQUE KEY `IX_doc_content_1` (`doc_id`,`page_num`),
  KEY `IX_doc_content` (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `doc_content` (`doc_id`,`content`,`page_num`) VALUES (1,'<IMG height=150 src=\"upfile/webeditimg/2006/8/2357ddd8a4354a8b82292978ec6821f6.jpg\" width=554>',1),(2,'<IMG height=104 src=\"upfile/webeditimg/2006/8/528e140122ca4930a85d31ca942a0ab3.jpg\" width=879>',1),(3,'<IMG height=104 src=\"upfile/webeditimg/2006/8/96ede6606c104816bc9f7a6722929a9c.jpg\" width=879>',1);
CREATE TABLE `document` (
  `id` int(11) NOT NULL default '0',
  `keywords` varchar(50) default NULL,
  `isrelateshow` tinyint(1) default '1',
  `title` varchar(100) NOT NULL default '',
  `class1` varchar(50) NOT NULL default '',
  `author` varchar(100) default NULL,
  `modifiedDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `can_comment` tinyint(1) NOT NULL default '0',
  `summary` text,
  `isHome` tinyint(1) NOT NULL default '0',
  `voteoption` varchar(250) default NULL,
  `voteresult` varchar(50) default NULL,
  `type` tinyint(3) unsigned NOT NULL default '0',
  `examine` tinyint(3) unsigned NOT NULL default '0',
  `nick` varchar(50) default NULL,
  `hit` int(11) NOT NULL default '0',
  `template_id` int(11) NOT NULL default '-1',
  `page_count` int(11) NOT NULL default '1',
  `parent_code` varchar(20) default NULL,
  `isNew` tinyint(1) NOT NULL default '0',
  `flowTypeCode` varchar(20) NOT NULL default '' COMMENT 'not used',
  `color` varchar(20) default NULL,
  `isBold` char(1) NOT NULL default '0',
  `expire_date` datetime default NULL,
  `orgAddr` varchar(15) default NULL,
  `createDate` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `IX_document` (`class1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `document` (`id`,`keywords`,`isrelateshow`,`title`,`class1`,`author`,`modifiedDate`,`can_comment`,`summary`,`isHome`,`voteoption`,`voteresult`,`type`,`examine`,`nick`,`hit`,`template_id`,`page_count`,`parent_code`,`isNew`,`flowTypeCode`,`color`,`isBold`,`expire_date`,`orgAddr`,`createDate`) VALUES (1,'ad',1,'公告旁的广告','blog_ad1','admin','2006-08-30 00:00:00',1,NULL,0,'','',0,0,'admin',23,-1,1,'blog_ad',0,'',NULL,'0',NULL,NULL,NULL),(2,'ad',1,'首页中部横幅','blog_ad2','admin','2006-08-30 00:00:00',1,NULL,0,'','',0,0,'admin',0,-1,1,'blog_ad',0,'',NULL,'0',NULL,NULL,NULL),(3,'',1,'首页底部横幅','blog_ad3','admin','2006-08-30 00:00:00',1,NULL,0,'','',0,0,'admin',0,-1,1,'blog_ad',0,'',NULL,'0',NULL,NULL,NULL);
CREATE TABLE `document_attach` (
  `id` int(11) NOT NULL default '0',
  `doc_id` 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 '0',
  `downloadCount` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `doc_id` (`doc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `email` (
  `id` int(11) NOT NULL default '0',
  `receiver` varchar(100) NOT NULL default '',
  `sender` varchar(100) NOT NULL default '',
  `subject` varchar(50) NOT NULL default '',
  `content` mediumtext,
  `mydate` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` int(1) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `email_attach` (
  `id` int(11) NOT NULL auto_increment,
  `emailId` 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 '',
  `orders` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `email_pop3` (
  `id` int(11) NOT NULL auto_increment,
  `userName` varchar(20) NOT NULL default '',
  `email` varchar(50) character set latin1 NOT NULL default '',
  `emailUser` varchar(50) default NULL,
  `emailPwd` varchar(50) character set latin1 default NULL,
  `server` varchar(50) character set latin1 NOT NULL default '',
  `port` int(11) NOT NULL default '0' COMMENT 'pop3 port',
  `smtpPort` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `name` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `flow` (
  `id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `mydate` datetime NOT NULL default '0000-00-00 00:00:00',
  `type_code` varchar(20) NOT NULL default '',
  `flow_string` text,
  `doc_id` int(11) default NULL,
  `userName` varchar(20) NOT NULL default '',
  `jobCode` varchar(20) default NULL,
  `status` tinyint(1) NOT NULL default '0',
  `resultValue` int(11) NOT NULL default '-2',
  `checkUserName` varchar(20) default NULL COMMENT 'The last person who check this flow.',
  `remark` varchar(200) default NULL,
  `return_back` tinyint(1) NOT NULL default '1',
  `BEGIN_DATE` datetime default NULL,
  `END_DATE` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `mydate` (`mydate`),
  KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `flow_action` (
  `id` int(11) NOT NULL default '0',
  `flow_id` int(11) NOT NULL default '0',
  `userName` varchar(255) default NULL,
  `userRealName` varchar(255) NOT NULL default '',
  `title` varchar(255) default NULL,
  `status` int(11) NOT NULL default '0',
  `reason` longtext,
  `isStart` tinyint(1) NOT NULL default '0',
  `internal_name` varchar(32) NOT NULL default '',
  `office_color_index` int(11) NOT NULL default '0',
  `mydate` datetime NOT NULL default '0000-00-00 00:00:00',
  `jobCode` varchar(255) default NULL,
  `jobName` varchar(255) default NULL,
  `proxyJobCode` varchar(20) default NULL,
  `proxyJobName` varchar(20) default NULL,
  `proxyUserName` varchar(20) default NULL,
  `proxyUserRealName` varchar(20) default NULL,
  `result` varchar(250) default NULL,
  `resultValue` int(11) NOT NULL default '-2',
  `checkDate` datetime default NULL,
  `checkUserName` varchar(11) default NULL COMMENT 'Person who check this action',
  `fieldWrite` text,
  `taskId` int(11) default NULL,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -