redmoonoa.sql
资源名称:JSP-OA.rar [点击查看]
上传用户:jhtang88
上传日期:2014-01-27
资源大小:28528k
文件大小:540k
源码类别:
Jsp/Servlet
开发平台:
Java
- `remark` text COMMENT '备注',
- `assort` varchar(250) default '' COMMENT '分类',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_khfkdjd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `booker` varchar(250) default '' COMMENT '登记人',
- `bookDate` varchar(250) default '' COMMENT '登记日期',
- `userName` varchar(250) default '' COMMENT '客户名称',
- `linkman` varchar(250) default '' COMMENT '联系人',
- `phone` varchar(250) default '' COMMENT '电话',
- `feedMode` varchar(250) default '' COMMENT '反馈方式',
- `feedContent` text COMMENT '反馈内容',
- `analyseDispose` text COMMENT '分析及处理',
- `chargeIdea` text COMMENT '主管意见',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_lxsqb` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `itemTitle` varchar(250) default '' COMMENT '项目名称',
- `applyDate` varchar(250) default '' COMMENT '申请日期',
- `itemSummerse` text COMMENT '项目概述',
- `itemBenefitExcept` text COMMENT '项目效益预期',
- `personalDemannd` text COMMENT '人员需求',
- `itemChargeBuget` text COMMENT '项目进度',
- `leadAuditing` text COMMENT '领导审核意见',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_ncd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `orderformNum` varchar(250) default '' COMMENT '订单编号',
- `operation` varchar(250) default '' COMMENT '业务员',
- `orderDate` varchar(250) default '' COMMENT '订单日期',
- `feedbackMan` varchar(250) default '' COMMENT '反馈人',
- `completeDate` varchar(250) default '' COMMENT '完工反馈日期',
- `invoiceNum` varchar(250) default '' COMMENT '发货单号',
- `consignee` varchar(250) default '' COMMENT '收货人',
- `contactPhone` varchar(250) default '' COMMENT '联系电话',
- `consigntMode` varchar(250) default '' COMMENT '发货方式',
- `CoName` varchar(250) default '' COMMENT '公司名称',
- `acceptAddress` varchar(250) default '' COMMENT '收货地址',
- `freightMode` varchar(250) default '' COMMENT '运费结算方式',
- `operationmanger` varchar(250) default '' COMMENT '业务经理',
- `consignmentDate` varchar(250) default '' COMMENT '发货日期',
- `consignment` varchar(250) default '' COMMENT '发货员',
- `consignmentConfirm` varchar(250) default '' COMMENT '发货确认日期',
- `operationAffirm` varchar(250) default '' COMMENT '业务确认',
- `feedOperation` varchar(250) default '' COMMENT '反馈业务员',
- `feedDate` varchar(250) default '' COMMENT '反馈日期',
- `clientDemand` text COMMENT '客户要求',
- `completeBack` text COMMENT '完工反馈',
- `consignmentMes` text COMMENT '发货员发货信息',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_qjd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `beginDate` datetime default '0000-00-00 00:00:00' COMMENT '开始时间',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO `form_table_qjd` (`flowId`,`flowTypeCode`,`beginDate`) VALUES (902,'qj','2006-03-15 00:00:00'),(1011,'qj','2006-03-17 00:00:00'),(1041,'qj','2006-03-19 00:00:00');
- CREATE TABLE `form_table_qjsqd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `applyman` varchar(250) default '' COMMENT '申请人',
- `applydate` varchar(250) default '' COMMENT '申请日期',
- `department` varchar(250) default '' COMMENT '部门',
- `qjkssj` date default '0000-00-00' COMMENT '请假开始时间',
- `qjjssj` date default '0000-00-00' COMMENT '请假结束时间',
- `qjly` varchar(250) default '' COMMENT '请假理由',
- `spren` varchar(250) default '' COMMENT '审批人',
- `sprq` varchar(250) default '' COMMENT '审批日期',
- `spyj` text COMMENT '审批意见',
- `jqlb` varchar(250) default '' COMMENT '假期类别',
- `kjxs` varchar(250) default '' COMMENT '扣假形式',
- `spjg` varchar(250) default '' COMMENT '审批结果',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_qksqd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `applyMan` varchar(250) default '' COMMENT '申请人',
- `department` varchar(250) default '' COMMENT '部门',
- `fund` varchar(250) default '' COMMENT '款额',
- `departmentChief` varchar(250) default '' COMMENT '部门主管',
- `financeCharge` varchar(250) default '' COMMENT '财务主管',
- `generalManager` varchar(250) default '' COMMENT '总经理',
- `remark` text COMMENT '备注',
- `paymentMode` varchar(250) default '' COMMENT '支付方式',
- `yong_tu` text COMMENT '用途',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_qzkhdjd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `unit` varchar(250) default '' COMMENT '单位',
- `name` varchar(250) default '' COMMENT '姓名',
- `phone` varchar(250) default '' COMMENT '电话',
- `appellation` varchar(250) default '' COMMENT '称谓',
- `mailbox` varchar(250) default '' COMMENT '电子邮箱',
- `QQ` varchar(250) default '' COMMENT 'QQ',
- `MSN` varchar(250) default '' COMMENT 'MSN',
- `address` varchar(250) default '' COMMENT '地址',
- `userDemand` text COMMENT '用户需求',
- `chargeIdea` text COMMENT '主管意见',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_rcszjrd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `date` varchar(250) default '' COMMENT '日期',
- `credenceNumber` varchar(250) default '' COMMENT '凭证编号',
- `abstact` varchar(250) default '' COMMENT '摘要',
- `debtorMoney` varchar(250) default '' COMMENT '借方金额',
- `lenderMoney` varchar(250) default '' COMMENT '贷方金额',
- `subject` varchar(250) default '' COMMENT '科目',
- `payee` varchar(250) default '' COMMENT '领款人',
- `approvePerson` varchar(250) default '' COMMENT '批准人',
- `remark` text COMMENT '备注',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_contract` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `contact_no` varchar(250) default '' COMMENT '合同编号',
- `contact_name` varchar(250) default '' COMMENT '合同名称',
- `begindate` date default '0000-00-00' COMMENT '生效日期',
- `enddate` date default '0000-00-00' COMMENT '结束时间',
- `linkman` varchar(250) default '' COMMENT '签约人',
- `toname` varchar(250) default '' COMMENT '签约人',
- `create_date` date default '0000-00-00' COMMENT '创建日期',
- `seller_name` varchar(250) default '' COMMENT '创建人',
- `contact_desc` text COMMENT '合同描述',
- `contact_item` text COMMENT '合同条款',
- `contact_content` text COMMENT '合同内容',
- `demo` text COMMENT '备注',
- `contact_type1` varchar(250) default '' COMMENT '合同类型',
- `contact_type` varchar(250) default '' COMMENT '合同打印样式',
- `customer` varchar(250) default '' COMMENT '客户名称',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_customer` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `sales_person` varchar(250) default '' COMMENT '销售员',
- `custom_num` varchar(250) default '' COMMENT '客户编码',
- `custom_short` varchar(250) default '' COMMENT '客户简称',
- `tel` varchar(250) default '' COMMENT '电话',
- `fax` varchar(250) default '' COMMENT '传真',
- `web` varchar(250) default '' COMMENT '网址',
- `email` varchar(250) default '' COMMENT '电子邮件',
- `postcode` varchar(250) default '' COMMENT '邮政编码',
- `constomerAdd` text COMMENT '详细地址',
- `enterMemo` text COMMENT '企业描述',
- `demo` text COMMENT '备注',
- `area` varchar(250) default '' COMMENT '地区',
- `source` varchar(250) default '' COMMENT '客户来源',
- `kind` varchar(250) default '' COMMENT '客户类别',
- `sellMode` varchar(250) default '' COMMENT '销售方式',
- `attribute` varchar(250) default '' COMMENT '行业属性',
- `enterType` varchar(250) default '' COMMENT '企业性质',
- `customer` varchar(250) default '' COMMENT '客户名称',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_customer_service` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `contact_date` date default '0000-00-00' COMMENT '服务日期',
- `customer` varchar(250) default '' COMMENT '客户名称',
- `lxr` varchar(250) default '' COMMENT '联系人',
- `cost` varchar(250) default '' COMMENT '服务预估成本',
- `time_cost` varchar(250) default '' COMMENT '时间成本',
- `contact_content` text COMMENT '服务内容描述',
- `feedback` text COMMENT '客户反馈意见',
- `description` text COMMENT '描述',
- `memo` text COMMENT '备注',
- `contact_type` varchar(250) default '' COMMENT '服务类型',
- `satisfy` varchar(250) default '' COMMENT '客户满意度',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_linkman` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `customer` varchar(250) default '' COMMENT '客户单位',
- `postPriv` varchar(250) default '' COMMENT '联系人职位',
- `linkmanName` varchar(250) default '' COMMENT '姓名',
- `postcodeHome` varchar(250) default '' COMMENT '家庭邮编',
- `addHome` varchar(250) default '' COMMENT '家庭住址',
- `telNoWork` varchar(250) default '' COMMENT '工作电话',
- `telNoHome` varchar(250) default '' COMMENT '家庭电话',
- `mobile` varchar(250) default '' COMMENT '手机',
- `EMAIL` varchar(250) default '' COMMENT 'email',
- `oicq` varchar(250) default '' COMMENT 'oicq',
- `msn` varchar(250) default '' COMMENT 'msn',
- `demo` text COMMENT '备注',
- `linkmanSex` varchar(250) default '' COMMENT '性别',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_product_info` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `product_name` varchar(250) default '' COMMENT '产品名称',
- `product_type` varchar(250) default '' COMMENT '产品型号',
- `measure_unit` varchar(250) default '' COMMENT '计量单位',
- `cost_price` varchar(250) default '' COMMENT '成本价',
- `standard_price` varchar(250) default '' COMMENT '出售价',
- `product_desc` text COMMENT '产品描述',
- `memo` text COMMENT '备注',
- `product_mode` varchar(250) default '' COMMENT '产品类别',
- `provider` varchar(250) default '' COMMENT '供应商',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_product_sell` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `product_name` varchar(250) default '' COMMENT '产品名称',
- `service_name` varchar(250) default '' COMMENT '服务',
- `price` varchar(250) default '' COMMENT '单价',
- `count` varchar(250) default '' COMMENT '数量',
- `total_price` varchar(250) default '' COMMENT '总价',
- `customer_name` varchar(250) default '' COMMENT '客户名称',
- `record_date` date default '0000-00-00' COMMENT '记录日期',
- `sales_man` varchar(250) default '' COMMENT '销售员',
- `demo` text COMMENT '备注',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_product_service` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `provider` varchar(250) default '' COMMENT '服务提供商',
- `service_name` varchar(250) default '' COMMENT '服务名称',
- `standad_name` varchar(250) default '' COMMENT '服务收费标准',
- `service_desc` text COMMENT '服务描述',
- `demo` text COMMENT '备注',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_product_service_sell` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `product_name` varchar(250) default '' COMMENT '服务型产品名称',
- `service` varchar(250) default '' COMMENT '服务',
- `price` varchar(250) default '' COMMENT '单价',
- `count` varchar(250) default '' COMMENT '数量',
- `total_count` varchar(250) default '' COMMENT '总价',
- `customer_name` varchar(250) default '' COMMENT '客户名称',
- `record_date` date default '0000-00-00' COMMENT '记录日期',
- `sales_man` varchar(250) default '' COMMENT '销售员',
- `demo` text COMMENT '备注',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_provider_info` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `provide_name` varchar(250) default '' COMMENT '供应商名称',
- `provider_code` varchar(250) default '' COMMENT '供应商编码',
- `provider_shot` varchar(250) default '' COMMENT '供应商简称',
- `tel` varchar(250) default '' COMMENT '电话',
- `fax` varchar(250) default '' COMMENT '传真',
- `web` varchar(250) default '' COMMENT '网址',
- `email` varchar(250) default '' COMMENT '电子邮件',
- `provider_add` varchar(250) default '' COMMENT '详细地址',
- `bank` varchar(250) default '' COMMENT '开户行',
- `account` varchar(250) default '' COMMENT '帐号',
- `demo` text COMMENT '备注',
- `area` varchar(250) default '' COMMENT '地区',
- `postcode` varchar(250) default '' COMMENT '邮政编码',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_sales_provider_name` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `id` int(10) unsigned NOT NULL auto_increment,
- `post_priv` varchar(250) default '' COMMENT '联系人职位',
- `linkman_name` varchar(250) default '' COMMENT '姓名',
- `birthday` varchar(250) default '' COMMENT '生日',
- `hobby` varchar(250) default '' COMMENT '爱好',
- `postal_home` varchar(250) default '' COMMENT '家庭邮编',
- `add_home` varchar(250) default '' COMMENT '家庭住址',
- `tel_no_work` varchar(250) default '' COMMENT '工作电话',
- `tel_no_home` varchar(250) default '' COMMENT '家庭电话',
- `mobile` varchar(250) default '' COMMENT '手机',
- `email` varchar(250) default '' COMMENT 'email',
- `qq` varchar(250) default '' COMMENT 'qq',
- `msn` varchar(250) default '' COMMENT 'msn',
- `memo` text COMMENT '备注',
- `sex` varchar(250) default '' COMMENT '性别',
- `provider_company` varchar(250) default '' COMMENT '供应商单位',
- PRIMARY KEY (`id`),
- KEY `flowId` (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_shouwen` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `lwdw` varchar(250) default '' COMMENT '来文单位',
- `swsj` varchar(250) default '' COMMENT '收文时间',
- `wjm` varchar(250) default '' COMMENT '文件名',
- `topic` varchar(250) default '' COMMENT '主题词',
- `page` varchar(250) default '' COMMENT '页码',
- `gdren` varchar(250) default '' COMMENT '归档人',
- `abstract` text COMMENT '摘要',
- `attribute` text COMMENT '意见',
- `pyyj` text COMMENT '批阅意见',
- `serct` varchar(250) default '' COMMENT '密级',
- `idea` text COMMENT '意见',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_vehicle_apply` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `licenseNo` varchar(250) default '' COMMENT '车辆牌照',
- `dept` varchar(250) default '' COMMENT '用车部门',
- `target` varchar(250) default '' COMMENT '目的地',
- `person` varchar(250) default '' COMMENT '用车人',
- `result` varchar(250) default '' COMMENT '是否同意',
- `beginDate` datetime default '0000-00-00 00:00:00' COMMENT '起始时间',
- `endDate` datetime default '0000-00-00 00:00:00' COMMENT '结束时间',
- `kilometer` varchar(250) default '' COMMENT '里程',
- `applier` varchar(250) default '' COMMENT '申请人',
- `reason` text COMMENT '事由',
- `remark` text COMMENT '备注',
- `driver` varchar(250) default '' COMMENT '司机',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`),
- KEY `beginDate` (`beginDate`),
- KEY `endDate` (`endDate`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `form_table_zbdjd` (
- `flowId` int(11) NOT NULL default '0',
- `flowTypeCode` varchar(20) NOT NULL default '',
- `slrq` varchar(250) default '' COMMENT '受理日期',
- `jtsj` varchar(250) default '' COMMENT '具体时间',
- `slren` varchar(250) default '' COMMENT '受理人',
- `dw` varchar(250) default '' COMMENT '单位',
- `dianhua` varchar(250) default '' COMMENT '电话',
- `nsren` varchar(250) default '' COMMENT '联系人',
- `shiyou` text COMMENT '事由',
- `slqk` text COMMENT '受理情况',
- `dbyj` text COMMENT '督办意见',
- `xbqk` text COMMENT '协办情况',
- `slfs` varchar(250) default '' COMMENT '受理方式',
- PRIMARY KEY (`flowId`),
- KEY `flowTypeCode` (`flowTypeCode`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `kaoqin` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(20) NOT NULL default '',
- `reason` varchar(100) default NULL,
- `myDate` datetime NOT NULL default '0000-00-00 00:00:00',
- `type` varchar(10) NOT NULL default '',
- `direction` char(1) NOT NULL default '',
- PRIMARY KEY (`id`),
- KEY `name` (`name`),
- KEY `type` (`type`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `link` (
- `id` int(11) NOT NULL auto_increment,
- `url` varchar(200) NOT NULL default '',
- `title` varchar(100) default NULL,
- `image` text,
- `userName` varchar(50) default NULL,
- `sort` int(11) NOT NULL default '0',
- `kind` varchar(50) NOT NULL default 'N''default''',
- PRIMARY KEY (`id`),
- KEY `userName` (`userName`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `log` (
- `ID` bigint(11) NOT NULL auto_increment,
- `USER_NAME` varchar(20) NOT NULL default '',
- `LOG_DATE` varchar(15) NOT NULL default '',
- `LOG_TYPE` int(11) NOT NULL default '0',
- `IP` varchar(15) default NULL,
- `ACTION` varchar(255) default NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO `log` (`ID`,`USER_NAME`,`LOG_DATE`,`LOG_TYPE`,`IP`,`ACTION`) VALUES (14,'admin','1172557594593',0,'127.0.0.1','登录系统');
- CREATE TABLE `message` (
- `id` int(11) NOT NULL default '0',
- `title` tinytext NOT NULL,
- `content` longtext NOT NULL,
- `sender` varchar(20) NOT NULL default '',
- `receiver` varchar(20) NOT NULL default '',
- `type` tinyint(3) unsigned NOT NULL default '0',
- `ip` varchar(15) NOT NULL default '',
- `isreaded` tinyint(3) NOT NULL default '0',
- `rq` varchar(15) NOT NULL default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `netdisk_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 '',
- `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`),
- KEY `dir_code` (`dir_code`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `netdisk_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',
- `isShared` tinyint(1) NOT NULL default '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `netdisk_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;
- CREATE TABLE `netdisk_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',
- PRIMARY KEY (`id`),
- KEY `IX_document` (`class1`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `netdisk_document_attach` (
- `id` int(11) NOT NULL auto_increment,
- `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',
- `file_size` int(11) NOT NULL default '0',
- `ext` varchar(20) default NULL,
- `uploadDate` datetime default NULL,
- `publicShareDir` varchar(20) NOT NULL default '',
- `USER_NAME` varchar(20) default NULL,
- `PUBLIC_SHARE_DEPTS` varchar(255) default NULL COMMENT 'if null then all user can see it',
- PRIMARY KEY (`id`),
- KEY `doc_id` (`doc_id`),
- KEY `publicShareDir` (`publicShareDir`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `netdisk_public_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',
- `edit` 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;
- INSERT INTO `netdisk_public_dir_priv` (`id`,`dir_code`,`see`,`append`,`del`,`edit`,`name`,`priv_type`,`examine`) VALUES (8,'99',1,0,0,1,'test',1,0);
- CREATE TABLE `netdisk_public_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',
- `mappingAddress` varchar(255) default NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO `netdisk_public_directory` (`code`,`name`,`isHome`,`description`,`parent_code`,`root_code`,`orders`,`child_count`,`add_date`,`islocked`,`type`,`layer`,`doc_id`,`template_id`,`pluginCode`,`mappingAddress`) VALUES ('root','全部目录',0,'全部目录','-1','root',1,5,'2006-05-18 12:00:00',0,2,1,-1,-1,'',NULL),('77','图片',0,'图片','root','root',1,0,'2006-05-18 20:47:47',NULL,2,2,0,-1,'',NULL),('99','视频',0,'视频','root','root',2,1,'2006-05-19 08:50:52',NULL,2,2,0,-1,'',NULL),('OA','OA客户端',0,'OA客户端','root','root',3,0,'2006-06-23 14:55:26',NULL,2,2,NULL,-1,'default',NULL),('dmap','D盘映射',0,'D盘映射','root','root',4,0,'2006-10-11 07:36:03',NULL,2,2,0,-1,'','d:/'),('e','E盘',0,'E盘','root','root',5,0,'2006-10-11 08:22:54',NULL,2,2,NULL,-1,'default','e:/oa'),('pp','pp',0,'pp','99','root',1,0,'2006-11-15 21:08:25',NULL,2,3,NULL,-1,'default','');
- CREATE TABLE `oa_message` (
- `id` int(11) NOT NULL default '0',
- `title` varchar(255) NOT NULL default '',
- `content` text NOT NULL,
- `sender` varchar(20) NOT NULL default '',
- `receiver` varchar(20) NOT NULL default '',
- `rq` datetime NOT NULL default '0000-00-00 00:00:00',
- `type` tinyint(3) unsigned NOT NULL default '0',
- `ip` varchar(15) NOT NULL default '',
- `isreaded` tinyint(1) NOT NULL default '0',
- `isDraft` tinyint(1) NOT NULL default '0',
- PRIMARY KEY (`id`),
- KEY `receiver` (`receiver`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `oa_message_attach` (
- `id` int(11) NOT NULL auto_increment,
- `msgId` 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;