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

📄 redmoonoa.sql

📁 oa 源代码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
  `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',
12345

⌨️ 快捷键说明

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