/*
Navicat MySQL Data Transfer
Source Host     : localhost:3306
Source Database : rsv
Target Host     : localhost:3306
Target Database : rsv
Date: 2013-07-29 23:01:56
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for mm_contract_attachments
-- ----------------------------
DROP TABLE IF EXISTS `mm_contract_attachments`;
CREATE TABLE `mm_contract_attachments` (
  `CONTRACT_ATTACHMENTS_ID` varchar(32) DEFAULT NULL COMMENT '合同附件ID',
  `CONTRACT_ID` varchar(32) DEFAULT NULL COMMENT '合同ID',
  `ATTACHMENTS_NAME` varchar(100) DEFAULT NULL COMMENT '附件名称',
  `ATTACHMENTS_URL` varchar(100) DEFAULT NULL COMMENT '附件URL',
  `ATTACHMENTS_SIZE` varchar(20) DEFAULT NULL COMMENT '附件大小',
  `ATTACHMENTS_TYPE` varchar(1) DEFAULT NULL COMMENT '1：合同审批\r\n            2：变更审批\r\n            3：一般附件\r\n            4：正式合同\r\n            5：合同文本\r\n            6：其他\r\n            ',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '创建日期',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '创建人',
  `REMARK` varchar(100) DEFAULT NULL COMMENT '注备'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合同附件';

-- ----------------------------
-- Records of mm_contract_attachments
-- ----------------------------
INSERT INTO `mm_contract_attachments` VALUES ('c80d8875c41c41aebe46d50bb66775e7', '8048ac9a2904488e9bf13929f31a170c', '广东电网公司2012-10-19.zip', 'D:apache-tomcat-6.0.20in	empc80d8875c41c41aebe46d50bb66775e7.zip', '196.79', '1', '2012-09-02 06:17:25', 'mortal', 'xcvcxdfsdf');
INSERT INTO `mm_contract_attachments` VALUES ('df69da8e63fb4654a203979abba722d6', '8048ac9a2904488e9bf13929f31a170c', '心理学,教你怎么去看懂人心.doc', 'D:apache-tomcat-6.0.20in	empdf69da8e63fb4654a203979abba722d6.doc', '29.5', '1', '2012-10-19 21:24:08', 'mortal', '');
INSERT INTO `mm_contract_attachments` VALUES ('6749d1541d514e8e9574ba8f8d1bf959', '8048ac9a2904488e9bf13929f31a170c', '数据质量分析.pdf', 'D:apache-tomcat-6.0.20in	emp6749d1541d514e8e9574ba8f8d1bf959.pdf', '263.26', '1', '2012-11-14 22:40:15', '超级管理员', 'dfgdfg');
INSERT INTO `mm_contract_attachments` VALUES ('00df91f3938c4bcf9bfc044586ab5b36', '8048ac9a2904488e9bf13929f31a170c', '验证权限.txt', 'D:apache-tomcat-6.0.20in	emp\00df91f3938c4bcf9bfc044586ab5b36.txt', '1.07', '1', '2012-11-22 21:54:27', '超级管理员', 'fgd');

-- ----------------------------
-- Table structure for mm_customer
-- ----------------------------
DROP TABLE IF EXISTS `mm_customer`;
CREATE TABLE `mm_customer` (
  `CUSTOMER_ID` varchar(32) NOT NULL,
  `CUSTOMER_CODE` varchar(50) DEFAULT NULL,
  `CUSTOMER_COMPANY_NAME` varchar(50) DEFAULT NULL,
  `MOBILE` varchar(20) DEFAULT NULL,
  `TEL` varchar(20) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `account_code` varchar(50) DEFAULT NULL,
  `bank_name` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL COMMENT '1：可用\r\n            2：不可用\r\n            ',
  `RECORD_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`CUSTOMER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客户表';

-- ----------------------------
-- Records of mm_customer
-- ----------------------------
INSERT INTO `mm_customer` VALUES ('3ea2db97ac4b457f8fe6333d9456b800', '004', '广州元浩信息科技有限公司', '3224778', '0120220', '020222222', '广州市天河区天河北路嘉怡苑1座7E', '110', '光大银行', '1', '2012-06-14 15:51:40');
INSERT INTO `mm_customer` VALUES ('96f4fd05fc34490cb29a98712d146191', '003', '112', '112', '112', '112', '112', '1121', '112', '1', '2012-06-04 00:00:00');
INSERT INTO `mm_customer` VALUES ('c6ff0dd03c5147af8553676977d478cd', '001', '1', '2', '3', '66', '7', '4', '5', '1', '2012-05-25 00:00:00');
INSERT INTO `mm_customer` VALUES ('e39c1388f70c4824b123c289e15c344d', '002', '广州玲珑凡人工作室', '12345678941', '11111111111', '1111', '11', '111', '1111', '2', '2012-05-25 00:00:00');

-- ----------------------------
-- Table structure for mm_inventory
-- ----------------------------
DROP TABLE IF EXISTS `mm_inventory`;
CREATE TABLE `mm_inventory` (
  `INVENTORY_ID` varchar(32) DEFAULT NULL COMMENT '盘点ID',
  `INVENTORY_CODE` varchar(50) DEFAULT NULL COMMENT '盘点编号',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '所在仓库ID',
  `WAREHOUSE_CODE` varchar(32) DEFAULT NULL COMMENT '仓库编号',
  `WAREHOUSE_NAME` varchar(100) DEFAULT NULL COMMENT '仓库名称',
  `accounting_DATE` date DEFAULT NULL COMMENT '会计期间',
  `INVENTORY_START_DATE` datetime DEFAULT NULL COMMENT '盘点开始日期',
  `INVENTORY_END_DATE` datetime DEFAULT NULL COMMENT '盘点结束日期',
  `MATERIAL_START_DATE` datetime DEFAULT NULL COMMENT '物料库存开始日期',
  `MATERIAL_END_DATE` datetime DEFAULT NULL COMMENT '物料库存结束日期',
  `PHYS_SCOUT_MAN` varchar(20) DEFAULT NULL COMMENT '监盘人',
  `PARTICIPATOR_ID` varchar(32) DEFAULT NULL COMMENT '负责人ID',
  `PRINCIPAL` varchar(20) DEFAULT NULL COMMENT '负责人',
  `STATUS` varchar(1) DEFAULT NULL COMMENT '状态\n            1：未审核\n            2：审核中\n            3：已审核',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '制单时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='盘点表';

-- ----------------------------
-- Records of mm_inventory
-- ----------------------------
INSERT INTO `mm_inventory` VALUES ('3bc6301601314aca93fa534750b4fa92', '33', 'f0ba0e49bb55457d8e41c11fbd7b6794', 'gz', '广州一号仓库', null, '2013-02-16 00:00:00', '2013-02-16 00:00:00', '2013-02-16 00:00:00', '2013-02-16 00:00:00', '33', '0010', 'admin', '1', '0010', '超级管理员', '2013-02-16 18:01:54');
INSERT INTO `mm_inventory` VALUES ('bf48aee7cd364e12b88dcbf75b88390f', '44', 'f0ba0e49bb55457d8e41c11fbd7b6794', 'gz', '广州一号仓库', '2013-02-16', '2013-02-16 00:00:00', '2013-02-16 00:00:00', '2013-02-16 00:00:00', '2013-02-16 00:00:00', '33', '0010', 'admin', '3', '0010', '超级管理员', '2013-02-16 18:03:20');

-- ----------------------------
-- Table structure for mm_inventory_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_inventory_item`;
CREATE TABLE `mm_inventory_item` (
  `INVENTORY_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '盘点明细ID',
  `INVENTORY_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '盘点明细CODE',
  `INVENTORY_ID` varchar(32) DEFAULT NULL COMMENT '盘点ID',
  `INVENTORY_Code` varchar(32) DEFAULT NULL COMMENT '盘点CODE',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '物料名称',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '物料ID',
  `MATERIAL_CODE` varchar(50) DEFAULT NULL COMMENT '物料编号',
  `INVENTORY_LEDGER_COUNT` int(11) DEFAULT NULL COMMENT '盘点日台账数量',
  `FACT_START_COUNT` int(11) DEFAULT NULL COMMENT '实际初查盘点数量',
  `FACT_END_COUNT` int(11) DEFAULT NULL COMMENT '实际复查盘点数量',
  `PERIOD_ISSUE_COUNT` int(11) DEFAULT NULL COMMENT '期间出库数量',
  `PERIOD_RECEIPT_COUNT` int(11) DEFAULT NULL COMMENT '期间入库数量',
  `BASEDATE_COUNT` int(11) DEFAULT NULL COMMENT '基准日应存数',
  `BASEDATE_BOOK_COUNT` int(11) DEFAULT NULL COMMENT '基准日财务账面数量',
  `BASEDATE_BOOK_AMT` decimal(10,4) DEFAULT NULL COMMENT '基准日财务账面金额',
  `BASEDATE_BOOK_UNIT` varchar(10) DEFAULT NULL COMMENT '基准日财务账面单位',
  `BASEDATE_BOOK_UNIT_AMT` decimal(10,4) DEFAULT NULL COMMENT '基准日财务账面单价',
  `INVENTORY_LOSS_COUNT` int(11) DEFAULT NULL COMMENT '盘亏数',
  `INVENTORY_PROFIT_COUNT` int(11) DEFAULT NULL COMMENT '盘盈数',
  `CAUSE_ANALYSIS` varchar(100) DEFAULT NULL COMMENT '原因分析',
  `QUALITY_STATUS` varchar(1) DEFAULT NULL COMMENT '1：正常、\n            2：残次、\n            3：毁损、\n            4：滞销等',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `object_TYpe` varchar(1) DEFAULT NULL COMMENT '物品类型 1物料 2半成品 3产品'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='盘点表明细';

-- ----------------------------
-- Records of mm_inventory_item
-- ----------------------------
INSERT INTO `mm_inventory_item` VALUES ('63c735dc6bef4d67b10d3f0e2e6cf644', 'fff', 'bf48aee7cd364e12b88dcbf75b88390f', '44', '落地风扇', 'da88e476606341b3b14d9e08414c17f3', '001', '33', '0', '0', '35', '0', null, null, null, null, null, '2', '0', '0', null, null, null);
INSERT INTO `mm_inventory_item` VALUES ('2cd721706f354d01977e99ba7eb318b8', 'ddddd', '3bc6301601314aca93fa534750b4fa92', '33', '落地风扇', 'da88e476606341b3b14d9e08414c17f3', '001', '60', '0', '0', '0', '0', null, null, null, '', null, '0', '60', '0', '', '', '1');

-- ----------------------------
-- Table structure for mm_issue
-- ----------------------------
DROP TABLE IF EXISTS `mm_issue`;
CREATE TABLE `mm_issue` (
  `ISSUE_ID` varchar(32) NOT NULL COMMENT '出库单ID',
  `ISSUE_CODE` char(10) DEFAULT NULL COMMENT '出库单CODE',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '仓库ID',
  `WAREHOUSE_NAME` varchar(100) DEFAULT NULL COMMENT '仓库名称',
  `ISSUE_DATE` datetime DEFAULT NULL COMMENT '出库时间，审批完成日期',
  `ACCOUNTING_DATE` datetime DEFAULT NULL COMMENT '记账日期',
  `ISSUE_STATUS` varchar(1) DEFAULT NULL COMMENT '1：未审核\n            2：审核中\n            3：已审核',
  `ISSUE_TYPE` varchar(1) DEFAULT NULL COMMENT '出库类型，仓库出库，现场领用',
  `IS_FROM_MOVEMENT` varchar(1) DEFAULT NULL COMMENT '是否由调拨单生成，0表示不是，1表示是',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '总金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '总税额',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '制单日期',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `ISSUE_classify` int(11) DEFAULT NULL COMMENT '产品类型',
  PRIMARY KEY (`ISSUE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='出库单\n';

-- ----------------------------
-- Records of mm_issue
-- ----------------------------
INSERT INTO `mm_issue` VALUES ('8247d6355a9a4b3d8fe53f6cace5791e', 'CK001', '9c0edcdc26ef41eebc53bbc66a8658bb', '天河东仓库', '2013-05-07 00:00:00', '2013-05-07 00:00:00', '3', '1', '1', '460.0000', '20.0000', '0010', '超级管理员', '2013-05-07 22:54:09', 'fdgfdg', '2');
INSERT INTO `mm_issue` VALUES ('c107a9dafc274068861eabadb1b04d09', 'CPCK-001', '9c0edcdc26ef41eebc53bbc66a8658bb', '天河东仓库', '2013-05-07 00:00:00', '2013-05-07 00:00:00', '3', '1', '1', '200.0000', '2.0000', '0010', '超级管理员', '2013-05-07 23:19:36', 'h', '1');
INSERT INTO `mm_issue` VALUES ('c1852c3d33254aabb513d7eca1371223', 'ssss', 'e61375fd32044c4186f5595d3c0a6408', '黄埔仓库', '2013-06-13 00:00:00', '2013-06-13 00:00:00', '1', '1', '1', null, null, '0010', '超级管理员', '2013-06-13 20:33:39', 'asdf', '2');
INSERT INTO `mm_issue` VALUES ('c8643f3e40d34f13ad3faea76a03f261', 'sdfsf', 'e61375fd32044c4186f5595d3c0a6408', '黄埔仓库', '2013-05-14 00:00:00', '2013-05-14 00:00:00', '1', '1', '1', '4182.0000', '4182.0000', '0010', '超级管理员', '2013-05-14 21:01:43', 'sdfsdsf', '1');

-- ----------------------------
-- Table structure for mm_issue_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_issue_item`;
CREATE TABLE `mm_issue_item` (
  `ISSUE_ITEM_ID` varchar(32) NOT NULL COMMENT '领料出库单明细ID',
  `issue_Item_Code` varchar(32) DEFAULT NULL COMMENT '领料出库单明细Code',
  `ISSUE_ID` varchar(32) DEFAULT NULL COMMENT '领料出库单ID',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '仓库ID',
  `WAREHOUSE_NAME` varchar(100) DEFAULT NULL COMMENT '仓库名称',
  `ISSUE_DATE` datetime DEFAULT NULL COMMENT '发料时间（出库时间）',
  `BATCH_ID` varchar(32) DEFAULT NULL COMMENT '用来追寻单据的唯一流程，（唯一性）',
  `ISSUE_QTY` int(11) DEFAULT NULL COMMENT '出库数量',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '物资ID',
  `MATERIAL_Code` varchar(50) DEFAULT NULL COMMENT '物资Code',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '物资名称',
  `MAIN_TYPE` varchar(50) DEFAULT NULL COMMENT '单据类型,根据类型选择不同单号',
  `MAIN__CODE` varchar(50) DEFAULT NULL COMMENT '单号(主单号）',
  `MAIN_ID` varchar(32) DEFAULT NULL COMMENT '单ID(主单ID）',
  `MAIN_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '单明细ID',
  `MAIN_ITEM_CODE` varchar(32) DEFAULT NULL COMMENT '单明细CODE主单据对应的明细',
  `REMAIN_TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '剩余金额 计算公式：\n            对应入库明细单中的金额减去出库明细的金额',
  `REMAIN_TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '剩余税额 计算公式：\n            对应入库明细单中的税额减去出库明细的税额',
  `SPEC` varchar(50) DEFAULT NULL COMMENT '规格',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '税',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(20) DEFAULT NULL COMMENT '计量单位',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `MARKS` varchar(200) DEFAULT NULL COMMENT '备注',
  `object_Type` varchar(1) DEFAULT NULL COMMENT '类型 1物料 2半成品 3产品',
  PRIMARY KEY (`ISSUE_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='出库单明细';

-- ----------------------------
-- Records of mm_issue_item
-- ----------------------------
INSERT INTO `mm_issue_item` VALUES ('1241bb89b34f47698e89e633f791518a', '1212', '06026bad24a44caaa24acd3bd09502be', null, null, '2012-12-05 00:00:00', '9aed135943544fdd9fb323a797c570b8', '11', 'c3d2aa59c2c54abb94ea58a0be10839e', '002', '美的空调', null, null, null, null, null, null, null, '立式空调', '1.0000', '10.0000', '7e944f2bdd47423084955d4050f873d7', '台', '110.0000', '11.0000', '111dd', null);
INSERT INTO `mm_issue_item` VALUES ('1276d2c6b50f4d40879b1f89614cb7a8', 'CPCK-001-001', 'c107a9dafc274068861eabadb1b04d09', '', '', '2013-05-07 00:00:00', 'a52472812e924c6a89fef934aa8c21cf', '2', '40df6338dde44ce19dc38d6ebcb913b1', 'CP-001', '美的电风扇', '', '', '', '', '', null, null, '', '1.0000', '100.0000', '', '', '200.0000', '2.0000', 'xcx', '3');
INSERT INTO `mm_issue_item` VALUES ('5d0b4622c0f34609940291a7070311a9', 'sdfsdf', 'c8643f3e40d34f13ad3faea76a03f261', '', '', '2013-05-07 00:00:00', '6a7d783c4c574f9b835f9c625624610c', '34', '10372b6f382f4ed9a0f11df9de451ae4', '001', 'teset', '', '', '', '', '', null, null, '', '123.0000', '123.0000', '', '', '4182.0000', '4182.0000', 'd', '3');
INSERT INTO `mm_issue_item` VALUES ('894c78e3ee024852a51d9892e984487a', 'dddd', '895f483609c849bf8d76ff9c6c2b5a1e', null, null, '2013-02-03 00:00:00', '583a10c664c940be8730fec85b97681e', '33', '', '002', '美的空调', null, null, null, null, null, null, null, 'd', '1.0000', '10.0000', '7e944f2bdd47423084955d4050f873d7', '台', '330.0000', '33.0000', 'sdd', null);
INSERT INTO `mm_issue_item` VALUES ('97dc55544e26498e9f429a4bbf4f3e4c', 'CK-001-001', '8247d6355a9a4b3d8fe53f6cace5791e', '', '', '2013-05-07 00:00:00', 'b8802d9b03df40b18d386b020ade0905', '20', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '', '', '', '', '', null, null, '23', '1.0000', '23.0000', '7e944f2bdd47423084955d4050f873d7', '台', '460.0000', '20.0000', '233', '1');
INSERT INTO `mm_issue_item` VALUES ('99a7255da696403f8ed3c3d2fd0554dc', '1111', '06026bad24a44caaa24acd3bd09502be', '', '', '2012-12-04 00:00:00', 'c1b7dff8ca7545b8b52fb5832c48b63a', '11', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '1', 'qqwe', '0bc987b13a74487d9df90aa0759c2f0e', '8bf050f297ca466d9d5866cfea04b630', '0001', null, null, '太', '1.0000', '10.0000', '7e944f2bdd47423084955d4050f873d7', '台', null, null, '111', null);

-- ----------------------------
-- Table structure for mm_manufacture
-- ----------------------------
DROP TABLE IF EXISTS `mm_manufacture`;
CREATE TABLE `mm_manufacture` (
  `MANUFACTURE_ID` varchar(32) NOT NULL COMMENT '生产单ID',
  `MANUFACTURE_CODE` varchar(50) DEFAULT NULL COMMENT '生产单编号',
  `PRODUCE_ID` varchar(32) DEFAULT NULL COMMENT '部门ID',
  `PRODUCE_CODE` varchar(50) DEFAULT NULL COMMENT '部门编号',
  `PRODUCE_NAME` varchar(80) DEFAULT NULL COMMENT '部门名称',
  `ORDER_DATE` date DEFAULT NULL COMMENT '下单日期',
  `FINISH_DATE` date DEFAULT NULL COMMENT '预计完成日期',
  `FACT_DATE` date DEFAULT NULL COMMENT '实际完成日期',
  `STATUS` char(1) DEFAULT NULL COMMENT '状态 1：未审核\n            2：审核中\n            3：已审核\n            4：撤销\n            ',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(32) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` date DEFAULT NULL COMMENT '制单时间',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`MANUFACTURE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='生产单';

-- ----------------------------
-- Records of mm_manufacture
-- ----------------------------
INSERT INTO `mm_manufacture` VALUES ('569ecb2766f042f7a2276551bbc1fb52', 'sdfs', '966d0f78c3fa4a339537adcb186d6894', '11', '我问问33', '2013-05-04', '2013-05-04', '2013-05-04', '3', '0010', '超级管理员', '2013-05-04', 'sdf');

-- ----------------------------
-- Table structure for mm_manufacture_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_manufacture_item`;
CREATE TABLE `mm_manufacture_item` (
  `MANUFACTURE_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '生产明细单ID',
  `MANUFACTURE_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '生产明细单编号',
  `MANUFACTURE_ID` varchar(32) DEFAULT NULL COMMENT '生产单ID',
  `MANUFACTURE_CODE` varchar(50) DEFAULT NULL COMMENT '生产单编号',
  `Product_id` varchar(32) DEFAULT NULL COMMENT '产品ID',
  `Product_code` varchar(50) DEFAULT NULL COMMENT '产品编号',
  `Product_NAME` varchar(80) DEFAULT NULL COMMENT '产品名称',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(10) DEFAULT NULL COMMENT '计量单位',
  `SPEC` varchar(50) DEFAULT NULL COMMENT '规格',
  `PLAN_NUMBER` int(11) DEFAULT NULL COMMENT '预计生产数量',
  `FACT_NUMBER` int(11) DEFAULT NULL COMMENT '实际生产数量',
  `PLAN_FINISH_DATE` date DEFAULT NULL COMMENT '生产完成时间,每个产品的生产完成时间不同',
  `FACT_FINISH_DATE` date DEFAULT NULL COMMENT '实际生产完成时间',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='生产明细单  清单';

-- ----------------------------
-- Records of mm_manufacture_item
-- ----------------------------
INSERT INTO `mm_manufacture_item` VALUES ('02b59bf4b07745d9bf24015370f9a496', 'sfsd', '569ecb2766f042f7a2276551bbc1fb52', 'sdfs', '10372b6f382f4ed9a0f11df9de451ae4', '001', 'teset', '7e944f2bdd47423084955d4050f873d7', '台', 'dsf', '12', '12', '2013-05-05', '2013-05-05', '1212');

-- ----------------------------
-- Table structure for mm_material
-- ----------------------------
DROP TABLE IF EXISTS `mm_material`;
CREATE TABLE `mm_material` (
  `MATERIAL_ID` varchar(32) NOT NULL COMMENT '物资（产品）名称',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL,
  `MATERIAL_CODE` varchar(50) DEFAULT NULL,
  `CLASSIFY_ID` varchar(32) DEFAULT NULL,
  `unitid` varchar(32) DEFAULT NULL COMMENT '计量单位id',
  `UNIT` varchar(32) DEFAULT NULL,
  `SPEC` varchar(50) DEFAULT NULL,
  `COLOR` varchar(20) DEFAULT NULL,
  `STATUS` varchar(1) DEFAULT NULL,
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL,
  `tax` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `PRODUCE_CYCLE` varchar(20) DEFAULT NULL COMMENT '一天，一年，一个月，一个季度等',
  `USEFUL_LIFE` varchar(20) DEFAULT NULL,
  `DESCRIPTION` varchar(200) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `CREATOR` varchar(20) DEFAULT NULL,
  `MODIFTOR` varchar(20) DEFAULT NULL,
  `MODIFTY_DATE` datetime DEFAULT NULL,
  `warn_Number` int(11) DEFAULT NULL COMMENT '预警数量',
  PRIMARY KEY (`MATERIAL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='物资（产品）';

-- ----------------------------
-- Records of mm_material
-- ----------------------------
INSERT INTO `mm_material` VALUES ('498d7644d5ed46a0b9971dc85ef87fd2', 'sdfsff', 'dsfsf', '1', '', '米', 'sdf', 'sdf', '1', '3.0000', '3.0000', 'sdf', 'sdf', 'dsfsf', '2012-12-28 21:53:22', 'admin', 'admin', '2013-02-22 01:12:15', '100');
INSERT INTO `mm_material` VALUES ('76ed34529126486393cb9582f72e66cb', '222', '22', '1', '57410df7c7c74346aaf297d1eb823895', '个', '', '', '1', null, null, '', '', '', '2013-03-04 21:33:51', 'admin', 'admin', '2013-03-04 21:33:51', '22');
INSERT INTO `mm_material` VALUES ('b84afb5e7e864e818c4211ea4995f4a0', 'ee', 'e', '1', '', '盆', 'fs', '', '1', '0.0000', '0.0000', 'dddd', '', 'dd', '2013-03-04 21:41:57', 'admin', 'admin', '2013-05-25 13:36:48', '3');
INSERT INTO `mm_material` VALUES ('c3d2aa59c2c54abb94ea58a0be10839e', '美的空调', '002', '2', '', '台', '立式空调', '白色', '1', '11.0000', '1.0000', '一天一台', '700天', '白色空调。', '2012-06-14 15:04:36', 'mortal', 'admin', '2013-05-01 20:22:11', '12');
INSERT INTO `mm_material` VALUES ('da88e476606341b3b14d9e08414c17f3', '落地风扇', '001', '1', '', '台', '太', '白色', '1', '10.1100', '1.0000', '0000方法', '一年', 'test', '2012-06-14 14:55:22', 'mortal', 'admin', '2013-05-07 22:38:33', '100');

-- ----------------------------
-- Table structure for mm_movement
-- ----------------------------
DROP TABLE IF EXISTS `mm_movement`;
CREATE TABLE `mm_movement` (
  `MOVEMENT_ID` varchar(32) NOT NULL COMMENT '调拨单_ID',
  `MOVEMENT_CODE` varchar(50) DEFAULT NULL COMMENT '调拨单编号',
  `FROM_WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '原仓库ID',
  `FROM_WAREHOUSE_CODE` varchar(50) DEFAULT NULL COMMENT '原仓库编号',
  `FROM_WAREHOUSE_NAME` varchar(80) DEFAULT NULL COMMENT '原仓库名称',
  `FROM_DEPT_ID` varchar(32) DEFAULT NULL COMMENT '原部门ID',
  `FROM_DEPT_CODE` varchar(50) DEFAULT NULL COMMENT '原部门CODE',
  `FROM_DEPT_NAME` varchar(80) DEFAULT NULL COMMENT '原部门名称',
  `TOTAL_PRICE` decimal(12,4) DEFAULT NULL COMMENT '总价格',
  `TOTAL_TAX` decimal(12,4) DEFAULT NULL COMMENT '总税额',
  `TO_DEPT_ID` varchar(32) DEFAULT NULL COMMENT '目标部门id',
  `TO_DEPT_CODE` varchar(50) DEFAULT NULL COMMENT '目标部门code',
  `TO_DEPT_NAME` varchar(80) DEFAULT NULL COMMENT '目标部门名称',
  `TO_WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '目标仓库ID',
  `TO_WAREHOUSE_CODE` varchar(50) DEFAULT NULL COMMENT '目标仓库CODE',
  `TO_WAREHOUSE_NAME` varchar(80) DEFAULT NULL COMMENT '目标仓库名称',
  `MOVEMENT_TYPE` varchar(1) DEFAULT NULL COMMENT '移动类型          1：.仓库间调拨,2：仓库间移库',
  `MOVEMENT_CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '调拨人ID',
  `MOVEMENT_CREATOR` char(10) DEFAULT NULL COMMENT '调拨人',
  `STATUS` varchar(1) DEFAULT NULL COMMENT '状态',
  `MOVEMENT_DATE` date DEFAULT NULL COMMENT '调拨时间',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(50) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` date DEFAULT NULL COMMENT '制单日期',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`MOVEMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='调拨单';

-- ----------------------------
-- Records of mm_movement
-- ----------------------------
INSERT INTO `mm_movement` VALUES ('7ca57efc91ee424faa70a741ddfb9ac0', '12', 'f0ba0e49bb55457d8e41c11fbd7b6794', 'gz', '广州一号仓库', '966d0f78c3fa4a339537adcb186d6894', '11', '我问问33', '529.0000', '529.0000', 'af0af28492c847bf98d5e64943e5a393', '3333', '333', '0088f02ca79742e6a3413853baedf7ac', 'th', '天河仓库', '1', '0010', 'admin', '3', '2013-04-24', '0010', '超级管理员', '2013-04-24', 's');
INSERT INTO `mm_movement` VALUES ('fc236fe6834f4f65b2ce8c879527f07b', 'DB002', '9c0edcdc26ef41eebc53bbc66a8658bb', 'th-001', '天河东仓库', '001002', '00', '开发部', '3330.3300', '36.0000', '966d0f78c3fa4a339537adcb186d6894', '11', '我问问33', 'f0ba0e49bb55457d8e41c11fbd7b6794', 'gz', '广州一号仓库', '1', '0010', 'admin', '1', '2013-05-14', '0010', '超级管理员', '2013-05-14', 'sdfsdf');

-- ----------------------------
-- Table structure for mm_movement_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_movement_item`;
CREATE TABLE `mm_movement_item` (
  `MOVEMENT_ITEM_ID` varchar(32) NOT NULL COMMENT '调拨明细ID',
  `MOVEMENT_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '调拨明细编号',
  `MOVEMENT_ID` varchar(32) DEFAULT NULL COMMENT '调拨单ID',
  `MOVEMENT_CODE` varchar(50) DEFAULT NULL COMMENT '调拨编号',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '物品ID',
  `MATERIAL_CODE` varchar(50) DEFAULT NULL COMMENT '物品编码',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '物品名称',
  `OBJECT_TYPE` varchar(1) DEFAULT NULL COMMENT '物品类型： 1：物料；2：半成品；3：产品',
  `SPEC` varchar(50) DEFAULT NULL COMMENT '规格',
  `REGULATION` varchar(50) DEFAULT NULL COMMENT '规范',
  `MOVEMENT_QTY` int(11) DEFAULT NULL COMMENT '调拨数量',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(10) DEFAULT NULL COMMENT '计量单位',
  `UNIT_PRICE` decimal(12,4) DEFAULT NULL COMMENT '单价',
  `TAX` decimal(12,4) DEFAULT NULL COMMENT '税',
  `TOTAL_PRICE` decimal(12,4) DEFAULT NULL COMMENT '金额',
  `TOTAL_TAX` decimal(12,4) DEFAULT NULL COMMENT '税额',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`MOVEMENT_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='调拨明细单';

-- ----------------------------
-- Records of mm_movement_item
-- ----------------------------
INSERT INTO `mm_movement_item` VALUES ('238dfbe40b4b421d8bf0307c475b6051', '23', '7ca57efc91ee424faa70a741ddfb9ac0', '12', '76ed34529126486393cb9582f72e66cb', '', '222(22)', '1', '23', '23', '23', '7e944f2bdd47423084955d4050f873d7', '台', '23.0000', '23.0000', '529.0000', '529.0000', '23');
INSERT INTO `mm_movement_item` VALUES ('2fa8a7340e8145d8a9cc5f5d8c77b20e', 'dsfsdf', 'fc236fe6834f4f65b2ce8c879527f07b', 'DB002', '9233c27be32247e7af3773657abda726', '002', '电灯泡', '3', '33', '33', '33', '7e944f2bdd47423084955d4050f873d7', '台', '100.0000', '1.0000', '3300.0000', '33.0000', 'dsfsf');
INSERT INTO `mm_movement_item` VALUES ('31dd6c8352a247d2b2f375cc135ecc7b', 'dsdf', 'c9cb7e974b4f4bb8a0b8f1eef781ac12', 'edsf', '9233c27be32247e7af3773657abda726', '', '电灯泡(002)', '3', '45', '45', '45', '57410df7c7c74346aaf297d1eb823895', '个', '45.0000', '45.0000', '2025.0000', '2025.0000', '44');
INSERT INTO `mm_movement_item` VALUES ('f1afe280141c431595312d784ec1a8c3', 'dsfsf', 'fc236fe6834f4f65b2ce8c879527f07b', 'DB002', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '1', 'sdsdf', 'sdf', '3', '54c48b23333040b2ac7c2750ffcdda6e', '盆', '10.1100', '1.0000', '30.3300', '3.0000', 'sdf');

-- ----------------------------
-- Table structure for mm_operation_history
-- ----------------------------
DROP TABLE IF EXISTS `mm_operation_history`;
CREATE TABLE `mm_operation_history` (
  `OPERATION_HISTORY_ID` varchar(32) NOT NULL COMMENT '库存历史ID',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '物资ID',
  `BATCH_ID` varchar(32) DEFAULT NULL COMMENT '批次ID',
  `material_Code` varchar(32) DEFAULT NULL COMMENT '物资编码',
  `MATERIAL_NAME` varchar(50) DEFAULT NULL COMMENT '物资名称',
  `BILL_ID` varchar(32) DEFAULT NULL COMMENT '单据明细(例如入库单，那么存入库单明细）',
  `BILL_MAIN_ID` varchar(32) DEFAULT NULL COMMENT '主单据ID',
  `OPERATION_DATE` datetime DEFAULT NULL COMMENT '记录库存操作时间',
  `BILL_TYPE` varchar(1) DEFAULT NULL COMMENT '根据单据不同，1：入库2：入库冲红3：出库4：出库',
  `QTY` int(11) DEFAULT NULL COMMENT '数量',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '单位税额',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '仓位id',
  `WAREHOUSE_FULL_NAME` varchar(50) DEFAULT NULL COMMENT '仓位全称',
  `WAREHOUSE_CODE` varchar(50) DEFAULT NULL COMMENT '仓位代码',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(10) DEFAULT NULL COMMENT '计量单位',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '此次操作的总金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '此次操作的总税额',
  `OBJECT_TYPE` varchar(1) DEFAULT NULL COMMENT '物品类型',
  PRIMARY KEY (`OPERATION_HISTORY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mm_operation_history
-- ----------------------------
INSERT INTO `mm_operation_history` VALUES ('257edd7906a247ec804bde4d80059716', 'da88e476606341b3b14d9e08414c17f3', 'f5c1403555f745f28c5fe4dbff456b48', '001', '落地风扇', '4db82b7edb9545a8a13dac50fedfbb51', '1fa0c8dd1915411cbcd42ac5af6b7b95', '2013-06-13 00:00:00', '1', '33', '10.1100', '1.0000', '8470b763efba46b6935a0f45ee9aa53e', '深圳仓库', 'sz-001', '57410df7c7c74346aaf297d1eb823895', '个', '333.6300', '33.0000', '1');
INSERT INTO `mm_operation_history` VALUES ('316a642a09b0455daa67e2d47c7d875c', 'da88e476606341b3b14d9e08414c17f3', 'b8802d9b03df40b18d386b020ade0905', '001', '落地风扇', '97dc55544e26498e9f429a4bbf4f3e4c', '8247d6355a9a4b3d8fe53f6cace5791e', '2013-05-07 00:00:00', '4', '20', '23.0000', '1.0000', '9c0edcdc26ef41eebc53bbc66a8658bb', '天河东仓库', 'th-001', '7e944f2bdd47423084955d4050f873d7', '台', '460.0000', '20.0000', '1');
INSERT INTO `mm_operation_history` VALUES ('668eaff01a294923bdffd1b24c6e6036', 'da88e476606341b3b14d9e08414c17f3', 'b1d937f31e5c44a0aa4f02eb7ccef2c6', '001', '落地风扇', '95a8353aa0bf466a977955e716bf3bb1', '7736ff85ea564900bf070cca8ac93b99', '2013-05-07 00:00:00', '1', '100', '10.1100', '1.0000', '9c0edcdc26ef41eebc53bbc66a8658bb', '天河东仓库', 'th-001', '7e944f2bdd47423084955d4050f873d7', '台', '1011.0000', '100.0000', '1');
INSERT INTO `mm_operation_history` VALUES ('7652c47dc3114db59616e91624f90129', 'c3d2aa59c2c54abb94ea58a0be10839e', '', '002', '美的空调', 'baac4a400b5144c49ace5c7890eaf271', '2', '2013-03-22 00:00:00', '8', '11', '10.0000', '1.0000', '11', '风扇', '', '7e944f2bdd47423084955d4050f873d7', '台', '110.0000', '11.0000', '1');
INSERT INTO `mm_operation_history` VALUES ('dbf41ebe488242acb62a108839718cff', 'c3d2aa59c2c54abb94ea58a0be10839e', '', '002', '美的空调', '863aa910620840479e7d83b2281c5ef7', '2', '2013-03-23 00:00:00', '8', '12', '10.0000', '1.0000', '11', '风扇', '', '7e944f2bdd47423084955d4050f873d7', '台', '120.0000', '12.0000', '1');
INSERT INTO `mm_operation_history` VALUES ('e10f05997fe045c88a911799f4cfb7cc', '40df6338dde44ce19dc38d6ebcb913b1', 'a52472812e924c6a89fef934aa8c21cf', 'CP-001', '美的电风扇', '1276d2c6b50f4d40879b1f89614cb7a8', 'c107a9dafc274068861eabadb1b04d09', '2013-05-07 00:00:00', '4', '2', '100.0000', '1.0000', '9c0edcdc26ef41eebc53bbc66a8658bb', '天河东仓库', 'th-001', '', '', '200.0000', '2.0000', '3');
INSERT INTO `mm_operation_history` VALUES ('fcd5d22e7e014aff983f69d5cdcdce97', '9233c27be32247e7af3773657abda726', '8d7c0a9a44de4b82a6157ae3f7b650f2', '002', '电灯泡', '15c9cb5ce81c4c75bd835203519098a2', '7736ff85ea564900bf070cca8ac93b99', '2013-05-07 00:00:00', '1', '200', '100.0000', '1.0000', '9c0edcdc26ef41eebc53bbc66a8658bb', '天河东仓库', 'th-001', '57410df7c7c74346aaf297d1eb823895', '个', '20000.0000', '200.0000', '3');

-- ----------------------------
-- Table structure for mm_order
-- ----------------------------
DROP TABLE IF EXISTS `mm_order`;
CREATE TABLE `mm_order` (
  `ORDER_ID` varchar(32) NOT NULL COMMENT '订单',
  `ORDER_CODE` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `CUSTOMER_ID` varchar(32) DEFAULT NULL COMMENT '下订单的客户',
  `CUSTOMER_CODE` varchar(50) DEFAULT NULL COMMENT '客户编号',
  `CUSTOMER_NAME` varchar(80) DEFAULT NULL COMMENT '客户名称',
  `ORDER_DATE` date DEFAULT NULL COMMENT '下单日期',
  `STATUS` varchar(1) DEFAULT NULL COMMENT '状态',
  `CREATE_ID` varchar(32) DEFAULT NULL COMMENT '制单人_ID',
  `CREATOR` varchar(50) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` date DEFAULT NULL COMMENT '制单时间',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`ORDER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='客户订单';

-- ----------------------------
-- Records of mm_order
-- ----------------------------
INSERT INTO `mm_order` VALUES ('0e6cac90fc34462da71885816caed0d4', '001', '02da5dc70bdb4eaea8c8d4a2ec720e35', '002', '广州科博特信息有限公司', '2013-04-11', '3', '0010', '超级管理员', '2013-04-11', 'sdffs');

-- ----------------------------
-- Table structure for mm_order_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_order_item`;
CREATE TABLE `mm_order_item` (
  `ORDER_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '订单明细ID',
  `ORDER_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '订单明细编码',
  `ORDER_ID` varchar(32) DEFAULT NULL COMMENT '订单id',
  `PRODUCT_ID` varchar(32) DEFAULT NULL COMMENT '产品ID',
  `PRODUCT_CODE` varchar(50) DEFAULT NULL COMMENT '产品编号',
  `PRODUCT_NAME` varchar(80) DEFAULT NULL COMMENT '产品名称',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '单位ID',
  `UNIT_NAME` varchar(30) DEFAULT NULL COMMENT '单位名称',
  `PRODUCT_NUM` int(11) DEFAULT NULL COMMENT '产品数量',
  `PRODUCT_PRICE` decimal(12,4) DEFAULT NULL COMMENT '产品单价',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单明细';

-- ----------------------------
-- Records of mm_order_item
-- ----------------------------
INSERT INTO `mm_order_item` VALUES ('e022232c910342588b6a7958ddfbe322', '123444', '0e6cac90fc34462da71885816caed0d4', '9233c27be32247e7af3773657abda726', '002', '电灯泡', '7e944f2bdd47423084955d4050f873d7', '台', '12', '100.0000', '12dsfsd44');
INSERT INTO `mm_order_item` VALUES ('a0f5b43e6bb446b5ad7a4e2bb59ef1a7', '1234', '0e6cac90fc34462da71885816caed0d4', '9233c27be32247e7af3773657abda726', '002', '电灯泡', '7e944f2bdd47423084955d4050f873d7', '台', '12', '100.0000', '22sd');
INSERT INTO `mm_order_item` VALUES ('a469c6972ef446bb984a35a39020762d', 'dd', '0e6cac90fc34462da71885816caed0d4', '40df6338dde44ce19dc38d6ebcb913b1', 'CP-001', '美的电风扇', '7e944f2bdd47423084955d4050f873d7', '台', '3', '100.0000', 'sd');

-- ----------------------------
-- Table structure for mm_product
-- ----------------------------
DROP TABLE IF EXISTS `mm_product`;
CREATE TABLE `mm_product` (
  `Product_id` varchar(32) NOT NULL COMMENT '产品',
  `Product_code` varchar(50) DEFAULT NULL COMMENT '产品编号',
  `Product_NAME` varchar(100) DEFAULT NULL COMMENT '产品名称',
  `Product_TYPE_id` char(32) DEFAULT NULL COMMENT '产品类型',
  `Product_TYPE_Name` char(50) DEFAULT NULL COMMENT '产品类型名称',
  `unit_id` char(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT` varchar(32) DEFAULT NULL COMMENT '计量单位',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '金额',
  `tax` decimal(10,4) DEFAULT NULL COMMENT '产品税额',
  `COLOR` varchar(20) DEFAULT NULL COMMENT '颜色',
  `spec` varchar(100) DEFAULT NULL COMMENT '规格',
  `status` char(1) DEFAULT NULL COMMENT '\r\n            状态\r\n            1：可用\r\n            2：报废',
  `DESCRIPTION` varchar(200) DEFAULT NULL COMMENT '描述',
  `creator` varchar(20) DEFAULT NULL COMMENT '创建人',
  `create_date` date DEFAULT NULL COMMENT '创建时间',
  `warn_Number` int(11) DEFAULT NULL COMMENT '预警数量',
  PRIMARY KEY (`Product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mm_product
-- ----------------------------
INSERT INTO `mm_product` VALUES ('10372b6f382f4ed9a0f11df9de451ae4', '001', 'teset', '9843b98248a14c2297ba57eef689713f', '家电', '7e944f2bdd47423084955d4050f873d7', '台', '123.0000', '123.0000', '12', '213', '1', '21', '超级管理员', '2013-01-20', '333');
INSERT INTO `mm_product` VALUES ('34c15cdcee60414898f0bc8fecd22191', 'SJ-001', '龙神手机', '9843b98248a14c2297ba57eef689713f', '家电', '7e944f2bdd47423084955d4050f873d7', '台', '3000.0000', '10.0000', '黑色', 'S4', '1', '龙神手机 必属精品。', '超级管理员', '2013-05-25', '100');
INSERT INTO `mm_product` VALUES ('40df6338dde44ce19dc38d6ebcb913b1', 'CP-001', '美的电风扇', '9843b98248a14c2297ba57eef689713f', '家电', '7e944f2bdd47423084955d4050f873d7', '台', '100.0000', '1.0000', '红色', '12', '1', 'sdsf', '超级管理员', '2013-05-07', '100');
INSERT INTO `mm_product` VALUES ('9233c27be32247e7af3773657abda726', '002', '电灯泡', 'c17e56db87294fe69f592bbd46cfa546', '礼包', '7e944f2bdd47423084955d4050f873d7', '台', '100.0000', '1.0000', '白色', '', '1', 'dd', '超级管理员', '2013-03-26', '100');

-- ----------------------------
-- Table structure for mm_product_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_product_item`;
CREATE TABLE `mm_product_item` (
  `Product_item_ID` varchar(32) NOT NULL COMMENT '产品明细ID',
  `Product_ID` varchar(32) NOT NULL COMMENT '产品ID',
  `Product_item_CODE` varchar(50) DEFAULT NULL COMMENT '产品明细CODE',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '物资ID',
  `MATERIAL_CODE` varchar(50) DEFAULT NULL COMMENT '产品编码',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '物资名称',
  `unit_id` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT` varchar(32) DEFAULT NULL COMMENT '计量单位',
  `SPEC` varchar(50) DEFAULT NULL COMMENT '规格（尺寸）',
  `COLOR` varchar(20) DEFAULT NULL COMMENT '颜色',
  `MATERIAL_Number` int(11) DEFAULT NULL COMMENT '数量',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `DESCRIPTION` varchar(200) DEFAULT NULL COMMENT '描述',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '创建时间',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`Product_item_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mm_product_item
-- ----------------------------
INSERT INTO `mm_product_item` VALUES ('19ebd82a1a4d408a83afdf202f736f88', '9233c27be32247e7af3773657abda726', '001-001', '498d7644d5ed46a0b9971dc85ef87fd2', 'dsfsf', 'sdfsff', '7e944f2bdd47423084955d4050f873d7', '台', 'sdf', '白色', '1', '3.0000', '3.0000', 'ff', '2013-03-26 00:00:00', '超级管理员');
INSERT INTO `mm_product_item` VALUES ('33ab275ce57e4c26b3e926f9ba573706', '10372b6f382f4ed9a0f11df9de451ae4', '002', '498d7644d5ed46a0b9971dc85ef87fd2', 'dsfsf', 'sdfsff', '54c48b23333040b2ac7c2750ffcdda6e', '盆', 'sdf', '444', '1', '3.0000', '3.0000', 'ddd', '2013-01-21 00:00:00', '超级管理员');
INSERT INTO `mm_product_item` VALUES ('49409bc740a14be6acd1d7a907a8fd9d', '34c15cdcee60414898f0bc8fecd22191', '11', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '54c48b23333040b2ac7c2750ffcdda6e', '盆', '太', '1', '1', '11.0000', '10.1100', '1', '2013-05-25 00:00:00', '超级管理员');
INSERT INTO `mm_product_item` VALUES ('d73551e263bc4874bcf6858fbd3d2115', '40df6338dde44ce19dc38d6ebcb913b1', 'CH-001-001', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '7e944f2bdd47423084955d4050f873d7', '台', '太', '红色', '10', '1.0000', '10.1100', 'dsf', '2013-05-07 00:00:00', '超级管理员');

-- ----------------------------
-- Table structure for mm_purchase
-- ----------------------------
DROP TABLE IF EXISTS `mm_purchase`;
CREATE TABLE `mm_purchase` (
  `PURCHASE_ID` varchar(32) NOT NULL COMMENT '采购单ID',
  `PURCHASE_CODE` varchar(50) DEFAULT NULL COMMENT '采购单编码',
  `CONTRACT_ID` varchar(32) DEFAULT NULL COMMENT '合同ID',
  `CONTRACT_CODE` varchar(50) DEFAULT NULL COMMENT '合同号',
  `CONTRACT_NAME` varchar(50) DEFAULT NULL COMMENT '合同名称',
  `TOTAL_AMOUNT` decimal(10,4) DEFAULT NULL COMMENT '采购单总金额',
  `SIGN_DATE` date DEFAULT NULL COMMENT '签收时间',
  `PURCHASE_DATE` date DEFAULT NULL COMMENT '采购时间',
  `VENDOR_ID` varchar(32) DEFAULT NULL COMMENT '供应商ID',
  `VENDOR_CODE` char(10) DEFAULT NULL COMMENT '供应商编码',
  `VENDOR_NAME` varchar(50) DEFAULT NULL COMMENT '供应商名称',
  `STATUS` varchar(10) DEFAULT NULL COMMENT '状态 new新增，auditing审批中，audited审批通过',
  `FINISH_DATE` date DEFAULT NULL COMMENT '审批完成时间',
  `PURCHASE_DATE_DELAYREASON` varchar(200) DEFAULT NULL COMMENT '采购延时原因',
  `READ_FLAG` char(1) DEFAULT NULL COMMENT '已读未读标志',
  `PURCHASER_ID` varchar(32) DEFAULT NULL COMMENT '采购物资员ID',
  `PURCHASER` varchar(50) DEFAULT NULL COMMENT '采购物资员（负责人）',
  `MATERIAL_PAYMENT_AMOUNT` decimal(10,4) DEFAULT NULL COMMENT '付款申请金额',
  `RECEIPT_AMOUNT` decimal(10,4) DEFAULT NULL COMMENT '到货金额',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(50) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` date DEFAULT NULL COMMENT '创建日期',
  `REMARK` varchar(100) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`PURCHASE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购单';

-- ----------------------------
-- Records of mm_purchase
-- ----------------------------
INSERT INTO `mm_purchase` VALUES ('b612e216acfc46c58f56aa2875c9f812', '香蕉1吨', '8048ac9a2904488e9bf13929f31a170c', '002', '10台打印机', '10000.0000', '2012-06-13', '2012-06-20', '0a35032a708b452c89304b726b7e3556', '1', '2', '3', null, '的飞洒', 'W', '0010', 'mortal', null, '500.0000', '0010', 'mortal', '2012-06-16', '撒旦法');
INSERT INTO `mm_purchase` VALUES ('c9fe5b3322104fa488dc1bec82b0dfde', '葡萄500公斤', '8048ac9a2904488e9bf13929f31a170c', '002', '10台打印机', '10000.0000', '2012-06-21', '2012-06-15', '02da5dc70bdb4eaea8c8d4a2ec720e35', '002', '广州科博特信息有限公司', '3', null, '堵车', 'W', '0010', 'mortal', null, '5000.0000', '0010', 'mortal', '2012-06-16', '普通500公斤.');

-- ----------------------------
-- Table structure for mm_purchase_contract
-- ----------------------------
DROP TABLE IF EXISTS `mm_purchase_contract`;
CREATE TABLE `mm_purchase_contract` (
  `CONTRACT_ID` varchar(32) NOT NULL COMMENT '合同ID',
  `CONTRACT_CODE` varchar(50) DEFAULT NULL COMMENT '合同号',
  `CONTRACT_NAME` varchar(100) DEFAULT NULL COMMENT '合同名称',
  `CONTRACT_TYPE` varchar(1) DEFAULT NULL COMMENT '1：采购合同\r\n            2：销售合同',
  `DELIVERY_DATE` datetime DEFAULT NULL COMMENT '交货日期',
  `DELIVERY_SPOT` varchar(100) DEFAULT NULL COMMENT '交货地点',
  `MAIN_CONTRACT_CODE` varchar(50) DEFAULT NULL COMMENT '原合同号（用于增补合同）',
  `TOTAL_MONEY` decimal(10,4) DEFAULT NULL COMMENT '总金额',
  `MONEY_UNIT` varchar(10) DEFAULT NULL COMMENT '货币单位',
  `ORIGINAL_TOTAL_MONEY` decimal(10,4) DEFAULT NULL COMMENT '记录原始的总金额,避免做合同变更后TOTAL_MONEY更改后无法找到原始金额',
  `PAYED_MONEY` decimal(10,4) DEFAULT NULL COMMENT '已付款金额',
  `REQUIRE_COMPANY` varchar(50) DEFAULT NULL COMMENT '需方单位（合同需求方单位）',
  `REQUIRE_COMPANY_ID` varchar(32) DEFAULT NULL COMMENT '需方单位ID',
  `REQ_CONTACT_MAN` varchar(20) DEFAULT NULL COMMENT '需方联系人',
  `REQ_CONTACT_PHONE` varchar(20) DEFAULT NULL COMMENT '需方联系人电话',
  `REQ_CORRESPOND_ADDRESS` varchar(100) DEFAULT NULL COMMENT '需方通信地址',
  `REQ_FAX_PHONE` varchar(20) DEFAULT NULL COMMENT '需方传真电话',
  `REQ_POSTALCODE` varchar(20) DEFAULT NULL COMMENT '需方邮政编码',
  `SUPPLY_CONTACT_MAN` varchar(20) DEFAULT NULL COMMENT '供方联系人',
  `SUPPLY_CONTACT_PHONE` varchar(20) DEFAULT NULL COMMENT '供方联系人电话',
  `SUPPLY_CORRESPOND_ADDRESS` varchar(100) DEFAULT NULL COMMENT '供方通信地址',
  `SUPPLY_FAX_PHONE` varchar(20) DEFAULT NULL COMMENT '供方传真电话',
  `SUPPLY_POSTALCODE` varchar(20) DEFAULT NULL COMMENT '供方邮政编码',
  `SUPPLY_SETTLEMENT_ACCOUNT` varchar(50) DEFAULT NULL COMMENT '供方结算账户',
  `SUPPLY_SETTLEMENT_ACCOUNT_NAME` varchar(20) DEFAULT NULL COMMENT '供方账户名称',
  `SUPPLY_SETTLEMENT_BANK` varchar(20) DEFAULT NULL COMMENT '供方开户银行',
  `SUPPLY_TAX_CODE` varchar(30) DEFAULT NULL COMMENT '供方税号',
  `VENDOR_CODE` varchar(50) DEFAULT NULL COMMENT '供应商代码',
  `VENDOR_ID` varchar(32) DEFAULT NULL COMMENT '供应商id',
  `VENDOR_NAME` varchar(100) DEFAULT NULL COMMENT '供应商名称',
  `START_DATE` datetime DEFAULT NULL COMMENT '合同开始时间（生效时间）',
  `END_DATE` datetime DEFAULT NULL COMMENT '合同结束时间',
  `status` varchar(1) DEFAULT NULL COMMENT '状态 1未审核 2审核中 3 已审核',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`CONTRACT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购合同';

-- ----------------------------
-- Records of mm_purchase_contract
-- ----------------------------
INSERT INTO `mm_purchase_contract` VALUES ('8048ac9a2904488e9bf13929f31a170c', '002', '10台打印机', '1', '2012-06-22 00:00:00', '岑村西街', '', '10000.0000', '人民币', '0.0000', '5000.0000', '凡人玲珑工作室', '001', '阳凡', '110', '员村ddd', '110', '110', '地球', '地球', '地球', '地球', '地球', '地球', '地球', '地球', '地球', '002', '02da5dc70bdb4eaea8c8d4a2ec720e35', '广州科博特信息有限公司', '2012-06-05 00:00:00', '2012-06-14 00:00:00', '3', '地球');
INSERT INTO `mm_purchase_contract` VALUES ('a3cca9d20bab4bb6a73931ec8fb3e571', '0022', '测试。', '1', '2013-01-31 00:00:00', '33', '', '0.0000', '人民币', '0.0000', '0.0000', '玲珑工作室', '001', '33', '3', '33', '33', '33', '33', '333', '33', '3', '', '33', '33', '33', '', '0001', '72f351f83ad843b6980b2b4ec0914d36', '1', '2013-02-21 00:00:00', '2013-02-28 00:00:00', '1', '3查询');

-- ----------------------------
-- Table structure for mm_purchase_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_purchase_item`;
CREATE TABLE `mm_purchase_item` (
  `PURCHASE_ITEM_ID` varchar(32) NOT NULL COMMENT '采购单明细ID',
  `PURCHASE_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '采购单明细CODE',
  `PURCHASE_ID` varchar(32) DEFAULT NULL COMMENT '采购单ID',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '产品ID',
  `MATERIAL_CODE` varchar(50) DEFAULT NULL COMMENT '产品编码',
  `MATERIAL_NAME` varchar(50) DEFAULT NULL COMMENT '产品名称',
  `DEPARTMENT_ID` varchar(32) DEFAULT NULL COMMENT '申购部门ID',
  `DEPARTMENT_CODE` varchar(50) DEFAULT NULL COMMENT '申购部门编码',
  `DEPARTMENT_NAME` varchar(50) DEFAULT NULL COMMENT '申购部门名称',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(20) DEFAULT NULL COMMENT '计量单位',
  `SPEC` varchar(50) DEFAULT NULL COMMENT '规格',
  `PURCHASE_QTY` int(11) DEFAULT NULL COMMENT '实际采购数量',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '单位税额',
  `RECEIPT_QTY` int(11) DEFAULT NULL COMMENT '已经到货数量',
  `RECEIPT_ONSITE_QTY` int(11) DEFAULT NULL COMMENT '领用数量',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `ACTUAL_DELIVERY_DATE` date DEFAULT NULL COMMENT '实际交货日期',
  `CONFIRM_RECEIPT_DATE` date DEFAULT NULL COMMENT '确认到货日期（入库过帐日期）',
  `PURCHASE_TYPE` varchar(50) DEFAULT NULL COMMENT '采购方式',
  `MATERIAL_TYPE` varchar(1) DEFAULT NULL COMMENT '物资类型，1设备 2材料',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`PURCHASE_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='采购单明细';

-- ----------------------------
-- Records of mm_purchase_item
-- ----------------------------
INSERT INTO `mm_purchase_item` VALUES ('1d0621ee4b3f441b92f273b507624968', '0002', 'b612e216acfc46c58f56aa2875c9f812', 'c3d2aa59c2c54abb94ea58a0be10839e', '002', '美的空调', '966d0f78c3fa4a339537adcb186d6894', '11', '我问问33', '54c48b23333040b2ac7c2750ffcdda6e', '盆', '立式空调', '111', '10.0000', '22.0000', null, null, '1110.0000', '2442.0000', '2012-10-01', '2012-10-16', '11', '1', 'sdfsf');
INSERT INTO `mm_purchase_item` VALUES ('76dfbeaf972a454baee8beb30b8790a4', 'dsfsdf', 'c9fe5b3322104fa488dc1bec82b0dfde', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '966d0f78c3fa4a339537adcb186d6894', '11', '我问问33', '7e944f2bdd47423084955d4050f873d7', '台', '太zx', '12', '10.0000', '0.0000', null, null, '120.0000', '0.0000', '2012-11-16', '2012-11-13', 'zxc', '1', 'xzccxz');
INSERT INTO `mm_purchase_item` VALUES ('8d54741bb4a64fc1b307883c5cfafd6f', '333', 'b612e216acfc46c58f56aa2875c9f812', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '966d0f78c3fa4a339537adcb186d6894', '11', '我问问33', '57410df7c7c74346aaf297d1eb823895', '个', '太', '22', '10.0000', '1.0000', null, null, '220.0000', '22.0000', '2012-12-04', '2012-12-03', '22', '1', '2');

-- ----------------------------
-- Table structure for mm_receipt
-- ----------------------------
DROP TABLE IF EXISTS `mm_receipt`;
CREATE TABLE `mm_receipt` (
  `RECEIPT_ID` varchar(32) NOT NULL COMMENT '入库单ID',
  `RECEIPT_CODE` varchar(50) DEFAULT NULL COMMENT '入库编码',
  `RECEIPT_TYPE` varchar(1) DEFAULT NULL COMMENT '1:到仓库\r\n            2:到现场',
  `CONTRACT_ID` varchar(32) DEFAULT NULL COMMENT '合同ID',
  `CONTRACT_CODE` varchar(50) DEFAULT NULL COMMENT '合同号',
  `CONTRACT_NAME` varchar(100) DEFAULT NULL COMMENT '合同名称',
  `IS_FROM_MOVEMENT` varchar(1) DEFAULT NULL COMMENT '是否由调拨单生成，0表示不是，1表示是',
  `RECEIPT_DATE` datetime DEFAULT NULL COMMENT '实际入库时间',
  `ACTUAL_RECEIPT_TIME` datetime DEFAULT NULL COMMENT '实际到货时间',
  `STATUS` varchar(1) DEFAULT NULL COMMENT '状态\r\n            1：未审核\r\n            2：审核中\r\n            3：已审核',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '总价格',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '总税额',
  `PURCHASE_ID` varchar(32) DEFAULT NULL COMMENT '采购单',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '仓库ID',
  `WAREHOUSE_CODE` varchar(50) DEFAULT NULL COMMENT '仓库CODE',
  `WAREHOUSE_NAME` varchar(50) DEFAULT NULL COMMENT '仓库名称',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '制单日期',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `accounting_Date` datetime DEFAULT NULL COMMENT '记账日期',
  PRIMARY KEY (`RECEIPT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='入库单';

-- ----------------------------
-- Records of mm_receipt
-- ----------------------------
INSERT INTO `mm_receipt` VALUES ('1fa0c8dd1915411cbcd42ac5af6b7b95', '03892', '1', '8048ac9a2904488e9bf13929f31a170c', '002', '10台打印机', '1', '2013-06-13 00:00:00', '2013-06-13 00:00:00', '3', '333.6300', '33.0000', 'b612e216acfc46c58f56aa2875c9f812', '8470b763efba46b6935a0f45ee9aa53e', 'sz-001', '深圳仓库', '0010', '超级管理员', '2013-06-13 20:40:04', '', '2013-06-13 20:39:52');
INSERT INTO `mm_receipt` VALUES ('7736ff85ea564900bf070cca8ac93b99', 'RK001', '1', '8048ac9a2904488e9bf13929f31a170c', '002', '10台打印机', '1', '2013-05-07 00:00:00', '2013-05-07 00:00:00', '3', '21011.0000', '300.0000', 'b612e216acfc46c58f56aa2875c9f812', '9c0edcdc26ef41eebc53bbc66a8658bb', 'th-001', '天河东仓库', '0010', '超级管理员', '2013-05-07 22:29:44', 'sdfsdf', '2013-05-07 22:29:25');

-- ----------------------------
-- Table structure for mm_receipt_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_receipt_item`;
CREATE TABLE `mm_receipt_item` (
  `RECEIPT_ITEM_ID` varchar(32) NOT NULL COMMENT '入库单明细ID',
  `RECEIPT_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '入库单明细编码',
  `RECEIPT_ID` varchar(32) DEFAULT NULL COMMENT '入库单ID',
  `RECEIPT_CODE` varchar(50) DEFAULT NULL COMMENT '入库编码',
  `BATCH_ID` varchar(32) DEFAULT NULL COMMENT '用来追寻单据的唯一流程，（唯一性）',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '产品ID',
  `MATERIAL_CODE` varchar(50) DEFAULT NULL COMMENT '产品编码',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '产品名称',
  `SPEC` varchar(50) DEFAULT NULL COMMENT '规格',
  `REGULATION` varchar(50) DEFAULT NULL COMMENT '规范',
  `RECEIPT_QTY` int(11) DEFAULT NULL COMMENT '已经到货数量',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(10) DEFAULT NULL COMMENT '计量单位',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '税',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `RECEIPT_DATE` datetime DEFAULT NULL COMMENT '实际入库时间',
  `CARRIAGE` decimal(10,4) DEFAULT NULL COMMENT '运费',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `object_Type` varchar(1) DEFAULT NULL COMMENT '类型 1：物料；2：半成品；3：产品',
  PRIMARY KEY (`RECEIPT_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='入库单明细';

-- ----------------------------
-- Records of mm_receipt_item
-- ----------------------------
INSERT INTO `mm_receipt_item` VALUES ('15c9cb5ce81c4c75bd835203519098a2', 'RK001-002', '7736ff85ea564900bf070cca8ac93b99', 'RK001', '8d7c0a9a44de4b82a6157ae3f7b650f2', '9233c27be32247e7af3773657abda726', '002', '电灯泡', 'ds', 'sdf', '200', '57410df7c7c74346aaf297d1eb823895', '个', '100.0000', '1.0000', '20000.0000', '200.0000', '2013-05-07 00:00:00', '0.0000', 'dsf', '3');
INSERT INTO `mm_receipt_item` VALUES ('4db82b7edb9545a8a13dac50fedfbb51', 'rstd', '1fa0c8dd1915411cbcd42ac5af6b7b95', '03892', 'f5c1403555f745f28c5fe4dbff456b48', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '太', '', '33', '57410df7c7c74346aaf297d1eb823895', '个', '10.1100', '1.0000', '333.6300', '33.0000', '2013-06-13 00:00:00', '0.0000', '', '1');
INSERT INTO `mm_receipt_item` VALUES ('95a8353aa0bf466a977955e716bf3bb1', 'RK001-001', '7736ff85ea564900bf070cca8ac93b99', 'RK001', 'b1d937f31e5c44a0aa4f02eb7ccef2c6', 'da88e476606341b3b14d9e08414c17f3', '001', '落地风扇', '太', '12', '100', '7e944f2bdd47423084955d4050f873d7', '台', '10.1100', '1.0000', '1011.0000', '100.0000', '2013-05-07 00:00:00', '1.0000', '1221', '1');

-- ----------------------------
-- Table structure for mm_return_deliverer
-- ----------------------------
DROP TABLE IF EXISTS `mm_return_deliverer`;
CREATE TABLE `mm_return_deliverer` (
  `RETURN_DELIVERER_ID` varchar(32) NOT NULL COMMENT '冲红单ID',
  `RETURN_DELIVERER_CODE` varchar(50) DEFAULT NULL COMMENT '冲红单CODE',
  `RETURN_DELIVERER_DATE` datetime DEFAULT NULL COMMENT '退货（冲红）时间',
  `ACCOUNTING_DATE` datetime DEFAULT NULL COMMENT '记账日期',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '总价格',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '总税额',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '仓位ID',
  `WAREHOUSE_NAME` varchar(100) DEFAULT NULL COMMENT '仓位名称',
  `RECEIPT_ID` varchar(32) DEFAULT NULL COMMENT '入库ID',
  `RECEIPT_CODE` char(50) DEFAULT NULL COMMENT '入库单编码',
  `RETURN_DELIVERER_TYPE` varchar(1) DEFAULT NULL COMMENT '冲红类别，1入库冲红 2现场到货冲红',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(50) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '制单日期',
  `STATUS` varchar(1) DEFAULT NULL COMMENT '1：未审核\r\n            2：审核中\r\n            3：已审核',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`RETURN_DELIVERER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of mm_return_deliverer
-- ----------------------------
INSERT INTO `mm_return_deliverer` VALUES ('0797065c1f5b447e85c71dc9f0c82553', 'sdfsf', '2013-05-14 00:00:00', '2013-05-14 00:00:00', null, null, '89c38bf1462b4192a393389699311ed6', '2', '7736ff85ea564900bf070cca8ac93b99', 'RK001', '1', '0010', '超级管理员', '2013-05-14 19:54:17', '1', 'sdfsdf');

-- ----------------------------
-- Table structure for mm_return_deliverer_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_return_deliverer_item`;
CREATE TABLE `mm_return_deliverer_item` (
  `RETURN_DELIVERER_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '入库冲红明细ID',
  `RETURN_DELIVERER_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '入库冲红明细CODE',
  `BATCH_ID` varchar(32) DEFAULT NULL COMMENT '用来追寻单据的唯一流程，（唯一性）',
  `RETURN_DELIVERER_ID` varchar(32) DEFAULT NULL COMMENT '冲红单ID',
  `RETURN_DELIVERER_DATE` datetime DEFAULT NULL COMMENT '实际退货时间',
  `RECEIPT_ITEM_ID` varchar(32) NOT NULL DEFAULT '' COMMENT '入库单明细ID',
  `receipt_item_code` varchar(50) DEFAULT NULL COMMENT '入库单明细CODE',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '产品ID',
  `MATERIAL_CODE` varchar(50) DEFAULT NULL COMMENT '产品编码',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '产品名称',
  `QTY` int(11) DEFAULT NULL COMMENT '数量',
  `SPEC` varchar(200) DEFAULT NULL COMMENT '规格',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '税',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(20) DEFAULT NULL COMMENT '计量单位',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `REGULATION` varchar(50) DEFAULT NULL COMMENT '规范',
  `object_type` varchar(1) DEFAULT NULL COMMENT '类型 1物料 2半成品 3产品',
  PRIMARY KEY (`RECEIPT_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='入库冲红明细';

-- ----------------------------
-- Records of mm_return_deliverer_item
-- ----------------------------

-- ----------------------------
-- Table structure for mm_return_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `mm_return_warehouse`;
CREATE TABLE `mm_return_warehouse` (
  `RETURN_WAREHOUSE_ID` varchar(32) NOT NULL COMMENT '退库单ID',
  `RETURN_WAREHOUSE_CODE` varchar(50) DEFAULT NULL COMMENT '出库单编码',
  `RETURN_WAREHOUSE_TYPE` varchar(1) DEFAULT NULL COMMENT '1   实物退库  2领用冲红',
  `RETURN_WAREHOUSE_DATE` datetime DEFAULT NULL COMMENT '退库日期',
  `RETURN_REASON` varchar(200) DEFAULT NULL COMMENT '退库原因',
  `STATUS` varchar(1) DEFAULT NULL COMMENT '状态\n            1：未审核\n            2：审核中\n            3：已审核\n            4：撤销',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '总金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '总税额',
  `WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '仓库ID',
  `WAREHOUSE_NAME` varchar(100) DEFAULT NULL COMMENT '仓库名称',
  `CREATOR_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` datetime DEFAULT NULL COMMENT '制单日期',
  PRIMARY KEY (`RETURN_WAREHOUSE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='退库';

-- ----------------------------
-- Records of mm_return_warehouse
-- ----------------------------
INSERT INTO `mm_return_warehouse` VALUES ('1', 'ww', '1', '2013-01-31 00:00:00', '质量as', '3', null, null, '11', '风扇', '1', 'test', '2013-02-02 00:00:00');
INSERT INTO `mm_return_warehouse` VALUES ('1a2eb6a6c9dc4c828617faa4fccfd289', 'd33', '1', '2013-04-29 00:00:00', 'dd', '3', '0.0000', '0.0000', '89c38bf1462b4192a393389699311ed6', '2', '0010', '超级管理员', '2013-04-29 00:01:02');
INSERT INTO `mm_return_warehouse` VALUES ('2', '1', '1', '2013-01-01 00:00:00', '质量sdfsfsdf', '3', '230.0000', '23.0000', '11', '风扇', '1', 'test', '2013-02-02 00:00:00');
INSERT INTO `mm_return_warehouse` VALUES ('639a63296a384def801a4fdcfed46380', 'eee', '1', '2013-03-16 00:00:00', 'ed', '1', '100.0000', '10.0000', 'f0ba0e49bb55457d8e41c11fbd7b6794', '广州一号仓库', '0010', '超级管理员', '2013-03-16 23:13:01');

-- ----------------------------
-- Table structure for mm_return_warehouse_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_return_warehouse_item`;
CREATE TABLE `mm_return_warehouse_item` (
  `RETURN_WAREHOUSE_ITEM_ID` varchar(32) NOT NULL COMMENT '退库物资项ID',
  `return_Warehouse_Item_Code` varchar(20) DEFAULT NULL COMMENT '退库明细编号',
  `RETURN_WAREHOUSE_ID` varchar(32) DEFAULT NULL COMMENT '退库单ID',
  `ISSUE_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '领料单明细ID',
  `MATERIAL_ID` varchar(32) DEFAULT NULL COMMENT '物料ID',
  `material_Code` varchar(30) DEFAULT NULL COMMENT '物料编号',
  `MATERIAL_NAME` varchar(100) DEFAULT NULL COMMENT '物料名称',
  `RETURN_TYPE` varchar(10) DEFAULT NULL COMMENT '1:物料；2:半成品；3:产品',
  `BATCH_ID` varchar(32) DEFAULT NULL COMMENT '用来追寻单据的唯一流程，（唯一性）',
  `ISSUE_ID` varchar(32) DEFAULT NULL COMMENT '领料单ID',
  `RETURN_DATE` datetime DEFAULT NULL COMMENT '退库时间',
  `RETURN_QTY` int(11) DEFAULT NULL COMMENT '退库数量',
  `SPEC` varchar(100) DEFAULT NULL COMMENT '规格',
  `TAX` decimal(10,4) DEFAULT NULL COMMENT '税',
  `UNIT_PRICE` decimal(10,4) DEFAULT NULL COMMENT '单价',
  `UNIT_ID` varchar(32) DEFAULT NULL COMMENT '计量单位ID',
  `UNIT_NAME` varchar(20) DEFAULT NULL COMMENT '计量单位',
  `TOTAL_PRICE` decimal(10,4) DEFAULT NULL COMMENT '金额',
  `TOTAL_TAX` decimal(10,4) DEFAULT NULL COMMENT '税额',
  `REMARKS` varchar(200) DEFAULT NULL COMMENT '备注',
  `object_Type` varchar(1) DEFAULT NULL COMMENT '类型 1物料 2半成品 3产品',
  PRIMARY KEY (`RETURN_WAREHOUSE_ITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='退库明细';

-- ----------------------------
-- Records of mm_return_warehouse_item
-- ----------------------------
INSERT INTO `mm_return_warehouse_item` VALUES ('64a44fbecde94185b03cd7ca1b571773', '12212', '1a2eb6a6c9dc4c828617faa4fccfd289', '', 'b84afb5e7e864e818c4211ea4995f4a0', 'e', 'ee', '1', '', '', '2013-05-01 00:00:00', '1221', '12', '0.0000', '0.0000', '7e944f2bdd47423084955d4050f873d7', '台', '0.0000', '0.0000', '12122', null);
INSERT INTO `mm_return_warehouse_item` VALUES ('863aa910620840479e7d83b2281c5ef7', '3333', '2', '', 'c3d2aa59c2c54abb94ea58a0be10839e', '002', '美的空调', '1', '', '', '2013-03-23 00:00:00', '12', '立式空调', '1.0000', '10.0000', '7e944f2bdd47423084955d4050f873d7', '台', '120.0000', '12.0000', '1212', null);
INSERT INTO `mm_return_warehouse_item` VALUES ('8fee08acc6d743ffad438946a14d17a0', '12', '639a63296a384def801a4fdcfed46380', '', 'c3d2aa59c2c54abb94ea58a0be10839e', '002', '美的空调', '1', '', '', '2013-03-17 00:00:00', '10', '立式空调', '1.0000', '10.0000', '54c48b23333040b2ac7c2750ffcdda6e', '盆', '100.0000', '10.0000', 'qq', null);
INSERT INTO `mm_return_warehouse_item` VALUES ('baac4a400b5144c49ace5c7890eaf271', 'assa', '2', '', 'c3d2aa59c2c54abb94ea58a0be10839e', '002', '美的空调', '1', '', '', '2013-03-22 00:00:00', '11', '立式空调', '1.0000', '10.0000', '7e944f2bdd47423084955d4050f873d7', '台', '110.0000', '11.0000', '2222', null);

-- ----------------------------
-- Table structure for mm_returned_purchase
-- ----------------------------
DROP TABLE IF EXISTS `mm_returned_purchase`;
CREATE TABLE `mm_returned_purchase` (
  `RETURNED_PURCHASE_ID` varchar(32) NOT NULL COMMENT '退货单ID',
  `RETURNED_PURCHASE_CODE` varchar(50) DEFAULT NULL COMMENT '退货单编码',
  `ORDER_ID` varchar(32) DEFAULT NULL COMMENT '订单ID',
  `ORDER_CODE` varchar(50) DEFAULT NULL COMMENT '订单编码',
  `CUSTOMER_ID` varchar(32) DEFAULT NULL COMMENT '客户ID',
  `CUSTOMER_CODE` varchar(50) DEFAULT NULL COMMENT '客户编码',
  `CUSTOMER_NAME` varchar(80) DEFAULT NULL COMMENT '客户名称',
  `ISSUE_STATUS` varchar(1) DEFAULT NULL COMMENT '1：未审核\n            2：审核中\n            3：已审核\n            4：撤销',
  `RETURNED_DATE` date DEFAULT NULL COMMENT '退货时间',
  `CREATE_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(50) DEFAULT NULL COMMENT '制单人',
  `CREATE_DATE` date DEFAULT NULL COMMENT '制单时间',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`RETURNED_PURCHASE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='退货单\n客户下订单后，发现有些产品因为某�';

-- ----------------------------
-- Records of mm_returned_purchase
-- ----------------------------
INSERT INTO `mm_returned_purchase` VALUES ('906f640c0f8e4f4fb9075513743ac3d0', 's12', '0e6cac90fc34462da71885816caed0d4', '001', '02da5dc70bdb4eaea8c8d4a2ec720e35', '002', '广州科博特信息有限公司', '3', '2013-04-14', '0010', '超级管理员', '2013-04-14', '2222');
INSERT INTO `mm_returned_purchase` VALUES ('9c958d14afc145b789432f463886b0a0', 'sdf', '0e6cac90fc34462da71885816caed0d4', '001', '72f351f83ad843b6980b2b4ec0914d36', '0001', '1', '1', '2013-04-14', '0010', '超级管理员', '2013-04-14', 'sdfsdfsdf');

-- ----------------------------
-- Table structure for mm_returned_purchase_item
-- ----------------------------
DROP TABLE IF EXISTS `mm_returned_purchase_item`;
CREATE TABLE `mm_returned_purchase_item` (
  `RETURNED_PURCHASE_ITEM_ID` varchar(32) DEFAULT NULL COMMENT '退货单明细ID',
  `RETURNED_PURCHASE_ITEM_CODE` varchar(50) DEFAULT NULL COMMENT '退货单明细CODE',
  `RETURNED_PURCHASE_ID` varchar(32) DEFAULT NULL COMMENT '退货单ID',
  `RETURNED_PURCHASE_CODE` varchar(50) DEFAULT NULL COMMENT '退货单CODE',
  `ORDER_ID` varchar(32) DEFAULT NULL COMMENT '订单ID',
  `order_Code` varchar(50) DEFAULT NULL COMMENT '订单编号',
  `ORDER_ITEM_ID` char(32) DEFAULT NULL COMMENT '订单明细ID',
  `ORDER_ITEM_CODE` char(50) DEFAULT NULL COMMENT '订单明细编号',
  `Product_id` varchar(32) DEFAULT NULL COMMENT '产品_ID',
  `PRODUCT_CODE` varchar(50) DEFAULT NULL COMMENT '产品_CODE',
  `PRODUCT_NAME` varchar(80) DEFAULT NULL COMMENT '产品名称',
  `PRODUCT_NUM` int(11) DEFAULT NULL COMMENT '产品数量(退货数量）',
  `CREATER_ID` varchar(32) DEFAULT NULL COMMENT '制单人ID',
  `CREATOR` varchar(20) DEFAULT NULL COMMENT '制单人',
  `CREATER_DATE` date DEFAULT NULL COMMENT '制单时间',
  `REMARK` varchar(200) DEFAULT NULL COMMENT '备注',
  `object_type` varchar(1) DEFAULT NULL COMMENT '类型 1物料 2半成品 3产品'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='退货明细单';

-- ----------------------------
-- Records of mm_returned_purchase_item
-- ----------------------------
INSERT INTO `mm_returned_purchase_item` VALUES ('de8c02d2ab8d4ebb8d71bfd0f396f9a5', 'sdfsdf', '906f640c0f8e4f4fb9075513743ac3d0', 's12', '0e6cac90fc34462da71885816caed0d4', '001', 'a0f5b43e6bb446b5ad7a4e2bb59ef1a7', '1234', '9233c27be32247e7af3773657abda726', '002', '电灯泡', '2', '0010', '超级管理员', '2013-04-14', '3323', '1');
INSERT INTO `mm_returned_purchase_item` VALUES ('03742d6eb35b43d9903ed65389be5af6', 'sdfsdf3', '906f640c0f8e4f4fb9075513743ac3d0', 's12', '0e6cac90fc34462da71885816caed0d4', '001', 'a0f5b43e6bb446b5ad7a4e2bb59ef1a7', '1234', '9233c27be32247e7af3773657abda726', '002', '电灯泡', '23', '0010', '超级管理员', '2013-04-14', 'sdf', '1');

-- ----------------------------
-- Table structure for mm_vendor
-- ----------------------------
DROP TABLE IF EXISTS `mm_vendor`;
CREATE TABLE `mm_vendor` (
  `VENDOR_ID` varchar(32) NOT NULL,
  `VENDOR_CODE` varchar(50) DEFAULT NULL,
  `VENDOR_NAME` varchar(100) DEFAULT NULL,
  `VENDOR_SHORT_NAME` varchar(50) DEFAULT NULL,
  `REGION` varchar(50) DEFAULT NULL,
  `ADDRESS` varchar(200) DEFAULT NULL,
  `EMAIL` varchar(100) DEFAULT NULL,
  `CONTACTER` varchar(30) DEFAULT NULL,
  `TELEPHONE` varchar(20) DEFAULT NULL,
  `FAX` varchar(20) DEFAULT NULL,
  `CREDIT_LEVEL` varchar(1) DEFAULT NULL,
  `ARTUFICIALPERSON` varchar(20) DEFAULT NULL,
  `DEPUTY` varchar(20) DEFAULT NULL,
  `URL` varchar(150) DEFAULT NULL,
  `ZIP` varchar(20) DEFAULT NULL,
  `REGISTRATION_CODE` varchar(50) DEFAULT NULL,
  `REGISTRATION_FUND` decimal(10,4) DEFAULT NULL,
  `STATUS` varchar(1) DEFAULT NULL,
  `REMARK` varchar(200) DEFAULT NULL,
  `RECORD_CREATE_DATE` datetime DEFAULT NULL,
  `LEGAL_PERSON_TEL` varchar(20) DEFAULT NULL,
  `TYPE` varchar(1) DEFAULT NULL,
  `ACCOUNT_CODE` varchar(50) DEFAULT NULL,
  `ACCOUNT_NAME` varchar(100) DEFAULT NULL,
  `BANK` varchar(50) DEFAULT NULL,
  `PRODUCT_LIST` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`VENDOR_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应商';

-- ----------------------------
-- Records of mm_vendor
-- ----------------------------
INSERT INTO `mm_vendor` VALUES ('001', '001', '凡人玲珑工作室', '疯子阳', '1', null, null, null, null, null, null, null, null, null, null, null, null, 'F', null, '2012-06-27 00:00:00', null, null, null, null, null, null);
INSERT INTO `mm_vendor` VALUES ('02da5dc70bdb4eaea8c8d4a2ec720e35', '002', '广州科博特信息有限公司', '科博公司', '华南', '广东省广州市天河区黄村西街10巷10号', '110@email.com', '杨武', '110', '110', '1', '杨武', '张峰', 'www.ttt.com', '555555', '000111', '111110.0000', 'T', '指纹打卡机、考勤系统、阅卷分析系统等', '2012-06-14 15:42:59', '1110', '1', '000', '00000', '0000', '指纹打卡机、考勤系统、阅卷分析系统等');
INSERT INTO `mm_vendor` VALUES ('0a35032a708b452c89304b726b7e3556', '1', '2', '3', '13', '8', '7', '4', '5', '6', '1', '9', '10', '11', '12', '15', '16.0000', 'F', '21', '2012-06-05 00:00:00', '14', '1', '17', '18', '19', '20');
INSERT INTO `mm_vendor` VALUES ('72f351f83ad843b6980b2b4ec0914d36', '0001', '1', '1', '1', '1', '1', '1', '1', '1', '3', '1', '1', '1', '1', '1', '1.0000', 'T', '斯蒂芬斯蒂芬森的', '2012-06-05 00:00:00', '1', '2', '1', '1', '1', 'ghhhhhhhhhhhhhhh');
INSERT INTO `mm_vendor` VALUES ('d63a25230b29402ba56f2977dab58260', '111', '111', '11', '22', '22', '11', '11', '111', '111', '1', '222', '222', '222', '22', '222', '222.0000', 'T', '222', '2012-11-17 12:38:42', '222', '1', '222', '22', '222', '22');

-- ----------------------------
-- Table structure for mm_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `mm_warehouse`;
CREATE TABLE `mm_warehouse` (
  `WAREHOUSE_ID` varchar(32) NOT NULL,
  `WAREHOUSE_CODE` varchar(40) DEFAULT NULL,
  `WAREHOUSE_NAME` varchar(50) DEFAULT NULL,
  `WAREHOUSE_FULL_Id` varchar(500) DEFAULT NULL COMMENT '仓库id全称',
  `WAREHOUSE_FULL_NAME` varchar(80) DEFAULT NULL,
  `PARENT_WAREHOUSE_ID` varchar(32) DEFAULT NULL,
  `WAREHOUSE_TYPE` char(1) DEFAULT NULL COMMENT '1：仓库\r\n            2：库房\r\n            3：库区\r\n            4：货架\r\n            5：货位',
  `IS_USABLE` char(1) DEFAULT NULL COMMENT '1：可用\r\n            2：不可用',
  `ADMIN_ID` varchar(32) DEFAULT NULL COMMENT '关联用户',
  `ADMIN` varchar(40) DEFAULT NULL,
  `ADDRESS` varchar(100) DEFAULT NULL,
  `TELEPHONE` varchar(20) DEFAULT NULL,
  `REMARK` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`WAREHOUSE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='仓库';

-- ----------------------------
-- Records of mm_warehouse
-- ----------------------------
INSERT INTO `mm_warehouse` VALUES ('0088f02ca79742e6a3413853baedf7ac', 'th', '天河仓库', '/f0ba0e49bb55457d8e41c11fbd7b6794/0088f02ca79742e6a3413853baedf7ac', '/广州一号仓库/天河仓库', 'f0ba0e49bb55457d8e41c11fbd7b6794', '2', '1', '0e0baf4a97fc431bb424d333867a462b', 'test1', 'd', '的', 'd ');
INSERT INTO `mm_warehouse` VALUES ('8470b763efba46b6935a0f45ee9aa53e', 'sz-001', '深圳仓库', '/8470b763efba46b6935a0f45ee9aa53e', '/深圳仓库', '-9999', '1', '1', '0010', 'admin', 'sdf', 'sdf', 'sfd');
INSERT INTO `mm_warehouse` VALUES ('89c38bf1462b4192a393389699311ed6', '2', '2', '/89c38bf1462b4192a393389699311ed6', '/2', '-9999', '1', '1', '002', 'test', '2', '2', '速度发速度发ccc');
INSERT INTO `mm_warehouse` VALUES ('9c0edcdc26ef41eebc53bbc66a8658bb', 'th-001', '天河东仓库', '/f0ba0e49bb55457d8e41c11fbd7b6794/0088f02ca79742e6a3413853baedf7ac/9c0edcdc26ef41eebc53bbc66a8658bb', '/广州一号仓库/天河仓库/天河东仓库', '0088f02ca79742e6a3413853baedf7ac', '3', '1', '0010', 'admin', 'sdf', 'sdf', 'sfd');
INSERT INTO `mm_warehouse` VALUES ('bcafb443ad844bf4b3226cb92e816722', '0023', 'sdfsdf', '/89c38bf1462b4192a393389699311ed6/bcafb443ad844bf4b3226cb92e816722', '/sdfsdf', '-9999', '1', '2', '0010', 'mortal', 'sdfsd', 'sdf', 'fsdfsdf');
INSERT INTO `mm_warehouse` VALUES ('e61375fd32044c4186f5595d3c0a6408', 'sdfsdfsdf', '黄埔仓库', '/89c38bf1462b4192a393389699311ed6/e61375fd32044c4186f5595d3c0a6408', '/2/黄埔仓库', '89c38bf1462b4192a393389699311ed6', '2', '1', '5bc57bb00f394c06a928ec11b4129928', '22', 'sdfsd', 'sdf', 'sdffsdddff得分倒萨');
INSERT INTO `mm_warehouse` VALUES ('f0ba0e49bb55457d8e41c11fbd7b6794', 'gz', '广州一号仓库', '/f0ba0e49bb55457d8e41c11fbd7b6794', '/广州一号仓库', '-9999', '1', '1', '398e2bfbe9f747ceb80e5c4c26a3a4b0', 'dfdsfsd', 'd', 'd', 'd');

-- ----------------------------
-- Table structure for pub_backup_data_base
-- ----------------------------
DROP TABLE IF EXISTS `pub_backup_data_base`;
CREATE TABLE `pub_backup_data_base` (
  `id` varchar(32) NOT NULL COMMENT '生产单ID',
  `user_Id` varchar(32) DEFAULT NULL COMMENT '人员id',
  `user_Name` varchar(32) DEFAULT NULL COMMENT '备份人员',
  `operate_Date` varchar(20) DEFAULT NULL COMMENT '备份日期',
  `file_Name` varchar(30) DEFAULT NULL COMMENT '文件名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pub_backup_data_base
-- ----------------------------
INSERT INTO `pub_backup_data_base` VALUES ('07b6ec1bb1fd48e5b345013e5e2489c7', '0010', '超级管理员', '2013-05-23 20:20:36', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('09207f46b4a542059b427f141e11ecb5', '0010', '超级管理员', '2013-05-23 20:24:46', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('0d17fc46379c48cba3da5c3c552f71c6', '0010', '超级管理员', '2013-05-07 21:42:15', 'rsv_2013-05-07.sql');
INSERT INTO `pub_backup_data_base` VALUES ('2cd9f96810e245e4bfb9ee30e129e665', '0010', '超级管理员', '2013-05-23 20:19:56', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('356a096052c5462798882b1fa9e05b5b', '0010', '超级管理员', '2013-05-23 20:25:47', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('45df5f74635d4ec4a3b6e173ff98e40f', '0010', '超级管理员', '2013-05-23 22:34:15', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('48c6d6db3cb7402ea24cc2608f155248', '0010', '超级管理员', '2013-05-23 20:29:30', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('4c440266c843432e8c1dc2b3c2b01ecc', '0010', '超级管理员', '2013-05-07 23:35:45', 'rsv_2013-05-07.sql');
INSERT INTO `pub_backup_data_base` VALUES ('4dcaa4c86b4348b994ccd2065b8edf4f', '0010', '超级管理员', '2013-05-23 20:23:17', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('5c3909b95ff145dfb3fdcfea31716831', '0010', '超级管理员', '2013-05-07 23:34:01', 'rsv_2013-05-07.sql');
INSERT INTO `pub_backup_data_base` VALUES ('668a7fd85f3341e1b213c4cc1c2ffad2', '0010', '超级管理员', '2013-05-23 22:34:45', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('6db60e29feda43f7aed9b5a5c4b168a3', '0010', '超级管理员', '2013-05-23 21:20:57', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('7737eb60985f441c8623b6eae3e52728', '0010', '超级管理员', '2013-05-23 21:22:25', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('8698a5ddff444bb98534be6fb8046886', '0010', '超级管理员', '2013-05-23 20:22:04', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('93f95d5240d04ef691bf7ff7e2a10ef3', '0010', '超级管理员', '2013-05-25 13:27:26', 'rsv_2013-05-25.sql');
INSERT INTO `pub_backup_data_base` VALUES ('9d217678bee747a4b60210cc95386718', '0010', '超级管理员', '2013-05-23 20:18:51', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('a82e70eb40d5484e859f91d6c5ec8e88', '0010', '超级管理员', '2013-05-07 21:29:05', 'rsv_2013-05-07.sql');
INSERT INTO `pub_backup_data_base` VALUES ('b115999f034f45d48686d1ab061e6f9a', '0010', '超级管理员', '2013-05-23 20:28:02', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('bbc1594847f7428b8a36be82ae53fbcb', '0010', '超级管理员', '2013-05-25 13:39:53', 'rsv_2013-05-25.sql');
INSERT INTO `pub_backup_data_base` VALUES ('ce7c1acd1b9141b0b5b39c2d339949a0', '0010', '超级管理员', '2013-05-23 20:29:17', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('d3da9e28209b42d1a14ad8d09d63bd4d', '0010', '超级管理员', '2013-05-23 20:27:20', 'rsv_2013-05-23.sql');
INSERT INTO `pub_backup_data_base` VALUES ('e10d7f3c5dac42cba7edc12292c3b441', '0010', '超级管理员', '2013-05-07 21:29:06', 'rsv_2013-05-07.sql');
INSERT INTO `pub_backup_data_base` VALUES ('ef210121bfc644d7bac284b34ca94bf8', '0010', '超级管理员', '2013-05-23 21:19:31', 'rsv_2013-05-23.sql');

-- ----------------------------
-- Table structure for pub_department
-- ----------------------------
DROP TABLE IF EXISTS `pub_department`;
CREATE TABLE `pub_department` (
  `DEPARTMENT_ID` varchar(32) NOT NULL COMMENT '部门ID',
  `DEPARTMENT_CODE` varchar(50) DEFAULT NULL COMMENT '部门编码',
  `DEPARTMENT_NAME` varchar(50) DEFAULT NULL,
  `FULL_NAME` varchar(100) DEFAULT NULL,
  `PARENT_DEPTMENT_ID` varchar(32) DEFAULT NULL,
  `SORT` int(11) DEFAULT NULL,
  `STATE` int(11) DEFAULT NULL COMMENT '2:不可用；1或null表示可用',
  `TREE_LEVEL` int(11) DEFAULT NULL COMMENT '1-集团2-分公司3-分部4-科5-班6-组',
  `UPDATE_DATE` date DEFAULT NULL,
  `DEPT_TYPE` int(11) DEFAULT NULL COMMENT '部门的类型,0-本单位部门;1-外协单位部门',
  PRIMARY KEY (`DEPARTMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部门表';

-- ----------------------------
-- Records of pub_department
-- ----------------------------
INSERT INTO `pub_department` VALUES ('001', '000', '玲珑工作室', '玲珑工作室', '-9999', '8', '1', null, '2012-11-22', '0');
INSERT INTO `pub_department` VALUES ('001002', '00', '开发部', 'tt玲珑工作室1/开发部', '001', '1', '1', null, '2012-10-15', '1');
INSERT INTO `pub_department` VALUES ('1186cf284d464588bf07f7f542762a11', '22', '2', '11/2', '966d0f78c3fa4a339537adcb186d6894', '22', '2', null, '2012-09-26', '0');
INSERT INTO `pub_department` VALUES ('19e9e0d170574eccab3c1c9dd8ccd8c3', '22222', '22', '22', '001', '22', '2', null, '2012-10-15', '0');
INSERT INTO `pub_department` VALUES ('5bd8f2822b964f0bbf13c40785b61c36', '001001', 'sdfsd', '开发部/sdfsd', '001002', '22', '1', null, '2012-05-28', '0');
INSERT INTO `pub_department` VALUES ('645dc35b28404d90bb66523026015bd8', '00111', '1111111111', '开发部/sdfsd/1111111111', '5bd8f2822b964f0bbf13c40785b61c36', '333', '1', null, '2012-09-26', '0');
INSERT INTO `pub_department` VALUES ('6fe1f8104ec4461086525b673ef9f1f1', 'edd', '1111111111111111111111111111111111', '开发部/sdfsd/1111111111/1111111111111111111111111111111111', '645dc35b28404d90bb66523026015bd8', '3333', '1', null, '2012-09-26', '0');
INSERT INTO `pub_department` VALUES ('8704ec9671064379a3d5d5ad03b96c0c', '222', '222', '开发部/222', '001002', '22', '1', null, '2012-10-14', '0');
INSERT INTO `pub_department` VALUES ('966d0f78c3fa4a339537adcb186d6894', '11', '我问问33d', '我问问33d', '001', '2', '1', null, '2013-05-25', '1');
INSERT INTO `pub_department` VALUES ('af0af28492c847bf98d5e64943e5a393', '3333', '333', '333', '001', '2', '1', null, '2012-10-15', '0');
INSERT INTO `pub_department` VALUES ('d2c8104922c343b0803987a6e61b533c', '111', '测试部', '11/测试部', '966d0f78c3fa4a339537adcb186d6894', '2', '1', null, '2012-10-07', '0');
INSERT INTO `pub_department` VALUES ('d785813fb74e42c88a4ffee1f0522063', '001001eee', '11', 'tt玲珑工作室1/11', '001', '11', '2', null, '2012-10-15', '0');
INSERT INTO `pub_department` VALUES ('e8b40a357406446e9bb714468080e351', '222222', '2222eeee', '开发部/222/2222eeee', '8704ec9671064379a3d5d5ad03b96c0c', '2222', '1', null, '2012-10-15', '0');
INSERT INTO `pub_department` VALUES ('ee4104040589444c86673ccfc854624e', 'ww', 'ww', '11/ww', '966d0f78c3fa4a339537adcb186d6894', '22', '2', null, '2012-10-14', '0');

-- ----------------------------
-- Table structure for pub_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `pub_dictionary`;
CREATE TABLE `pub_dictionary` (
  `dictionary_ID` varchar(32) DEFAULT NULL,
  `parent_dictionary_ID` varchar(32) DEFAULT NULL,
  `MODULE_CODE` varchar(50) DEFAULT NULL COMMENT '该字段用于区分各个模块',
  `CODE` varchar(50) DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL,
  `sort_id` int(11) DEFAULT NULL,
  `REMARK` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典';

-- ----------------------------
-- Records of pub_dictionary
-- ----------------------------
INSERT INTO `pub_dictionary` VALUES ('b1b044013eb346c8ad8b089704d4878c', '-9999', 'dept', 'dept', '部门编码', '1', 'ee222');
INSERT INTO `pub_dictionary` VALUES ('8121c7aa823a46dca33fd3b369a1d74a', '-9999', 'wzlb', 'wzlb', '物资类别', '1', '物资类别');
INSERT INTO `pub_dictionary` VALUES ('f05358e2a450490888feb188d27a70a5', '8121c7aa823a46dca33fd3b369a1d74a', 'wzlb', 'yjwz', '一级物资', '1', '物资类别编码');
INSERT INTO `pub_dictionary` VALUES ('54dd7a23ac304a139e882c92d3801b77', '8121c7aa823a46dca33fd3b369a1d74a', 'wzlb', 'ejwz', '二级物资', '2', '二级物资');
INSERT INTO `pub_dictionary` VALUES ('84899968fece4b099d9b1a5a87e71a8e', '-9999', 'jldw', 'jldw', '计量单位1', '3', '计量单位');
INSERT INTO `pub_dictionary` VALUES ('57410df7c7c74346aaf297d1eb823895', '84899968fece4b099d9b1a5a87e71a8e', 'jldw', 'ge', '个', '1', '个');
INSERT INTO `pub_dictionary` VALUES ('7e944f2bdd47423084955d4050f873d7', '84899968fece4b099d9b1a5a87e71a8e', 'jldw', 'tai', '台', '2', '台');
INSERT INTO `pub_dictionary` VALUES ('6a1c6b25aa2a459589a8a49b991a8ebe', '8121c7aa823a46dca33fd3b369a1d74a', 'wzlb', '3', '三级物资', '3', '三级物资');
INSERT INTO `pub_dictionary` VALUES ('54c48b23333040b2ac7c2750ffcdda6e', '84899968fece4b099d9b1a5a87e71a8e', 'jldw', 'peng', '盆', '4', '盆栽');
INSERT INTO `pub_dictionary` VALUES ('5882579fb6f34f0986a055f08e4b2e25', '8121c7aa823a46dca33fd3b369a1d74a', 'wzlb', 'f', '1', '1', '1');
INSERT INTO `pub_dictionary` VALUES ('ce618814f35e4c66aa25d2b9a085d3c5', '84899968fece4b099d9b1a5a87e71a8e', 'jldw', 'mi', '米', '4', '米');
INSERT INTO `pub_dictionary` VALUES ('65e1aa664d234f1c8f189e7fa006183f', 'ce618814f35e4c66aa25d2b9a085d3c5', 'jldw', 'nn', '大米', '2', '俄俄');
INSERT INTO `pub_dictionary` VALUES ('4918a920b9b3455e982a5df69191ed05', '-9999', 'ProductType', 'ProductType', '产品类型', '3', '产品类型');
INSERT INTO `pub_dictionary` VALUES ('9843b98248a14c2297ba57eef689713f', '4918a920b9b3455e982a5df69191ed05', 'ProductType', 'DQ', '家电', '1', '家电');
INSERT INTO `pub_dictionary` VALUES ('c17e56db87294fe69f592bbd46cfa546', '4918a920b9b3455e982a5df69191ed05', 'ProductType', 'LB', '礼包', '2', '礼包');

-- ----------------------------
-- Table structure for pub_menu
-- ----------------------------
DROP TABLE IF EXISTS `pub_menu`;
CREATE TABLE `pub_menu` (
  `menu_Id` varchar(32) NOT NULL DEFAULT '' COMMENT '菜单id',
  `menu_Name` varchar(30) DEFAULT NULL COMMENT '菜单名称',
  `parent_id` varchar(40) DEFAULT NULL COMMENT '上级菜单id',
  `url` varchar(50) DEFAULT NULL COMMENT '菜单url',
  `isStartUsing` int(11) DEFAULT NULL COMMENT '是否启用',
  `isNewOpenWindow` int(11) DEFAULT NULL COMMENT '是否新开窗体',
  `isDefaultOpen` int(11) DEFAULT NULL COMMENT '是否默认打开',
  `showSort` int(11) DEFAULT NULL COMMENT '排序索引',
  `powerUrl` varchar(1000) DEFAULT NULL COMMENT '该页面对应的url 验证权限',
  `remark` varchar(50) DEFAULT NULL COMMENT '用于标明该用户是\r\n            1：一级管理员，2：二级管理员，3：三级管理员，4：普通用户等\r\n            ',
  PRIMARY KEY (`menu_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统菜单表';

-- ----------------------------
-- Records of pub_menu
-- ----------------------------
INSERT INTO `pub_menu` VALUES ('001', '系统管理', '-9999', '', '1', '2', '2', '19', null, '系统管理');
INSERT INTO `pub_menu` VALUES ('002', '菜单管理', '001', 'jxc/menu/menuMain.jsp', '1', '2', '2', '1', null, '系统菜单管理fff');
INSERT INTO `pub_menu` VALUES ('01f12cd4b6d0459295f985e29820162d', '仓库周转率', 'f6ddf73bbb6947a1ab848ef68f94cae6', '/jxc/billSauditReport/wareHouseMonthReport.jsp', '2', '2', '2', '1', '', '仓库周转率');
INSERT INTO `pub_menu` VALUES ('020df1bc962544fe953e12917a2aabfa', '订单采购管理', '35e6fa5518c14204b16c179dce78fd02', '', '2', '2', '2', '2', '', '管理企业的采购业务');
INSERT INTO `pub_menu` VALUES ('050d2b44ad8d45f8b8f602863ed6408d', '日志管理', '001', '/log/logMain.jsp', '1', '2', '2', '6', '', '日志管理');
INSERT INTO `pub_menu` VALUES ('05e1f9427dc54ca0a696b95f6fbb85d1', '数据备份', '001', '/backup/backupDataBaseMain.jsp', '1', '2', '2', '7', '', '数据库数据备份');
INSERT INTO `pub_menu` VALUES ('05f700ca85a7414d946e863fee1c27a3', '基本信息管理', '35e6fa5518c14204b16c179dce78fd02', '', '2', '2', '2', '1', null, '主要包括：商品资料，供应商资料、客户资料等。');
INSERT INTO `pub_menu` VALUES ('105be1ac21fa440bacfaea1752a19b5e', '供应商基本信息', '05f700ca85a7414d946e863fee1c27a3', 'jxc/vendor/vendorMain.jsp', '1', '2', '2', '3', null, '供应商资料维护');
INSERT INTO `pub_menu` VALUES ('27e3634187d44f56bfc6d42c199d5733', '计量单位管理', '05f700ca85a7414d946e863fee1c27a3', '/jxc/dictionary/code/codeMain.jsp?moduleCode=jldw', '1', '2', '2', '8', null, '计量单位管理');
INSERT INTO `pub_menu` VALUES ('3360c3f18af149a09e2c02806fa2d9aa', '出库单管理', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/issue/issuelMain.jsp', '1', '2', '2', '5', '', '出库单管理 对应入库单..');
INSERT INTO `pub_menu` VALUES ('35e6fa5518c14204b16c179dce78fd02', '企业管理', '-9999', '', '1', '2', '2', '1', 'sdfsf', '进销存管理系统跟节点。');
INSERT INTO `pub_menu` VALUES ('53762cbde0cb4258840d2c2cb7c110df', '字典管理', '001', 'jxc/dictionary/dictionaryMain.jsp', '1', '2', '2', '3', null, '项目字典管理');
INSERT INTO `pub_menu` VALUES ('59ce66eb5a1d4e569e5209301b106641', '权限管理', '001', 'jxc/roles/authorityMain.jsp', '1', '2', '2', '4', null, '权限管理');
INSERT INTO `pub_menu` VALUES ('5a269b1db76c4f21bf943d29339b1045', '首页', '001', '/homePage!queryAllBillSauditSize', '1', '2', '1', '5', '', '主页管理');
INSERT INTO `pub_menu` VALUES ('626772d3aaeb45e5b1118ac7336369fa', '角色管理', '001', 'jxc/roles/rolesMain.jsp', '1', '2', '2', '2', null, '角色管理');
INSERT INTO `pub_menu` VALUES ('67a09f56cddb491f8e5fcb1b63c2d801', '按产品出库', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/productIssue/productIssueMain.jsp', '1', '2', '2', '4', '', '按产品出库');
INSERT INTO `pub_menu` VALUES ('695550653d9a4fb3951a5f5b4eb0fc20', '退货单管理', '020df1bc962544fe953e12917a2aabfa', '/jxc/returnedPurchase/returnedPurchaseMain.jsp', '1', '2', '2', '2', '', '退货单管理');
INSERT INTO `pub_menu` VALUES ('6df1ffbeb03d4e9b8e26c2ad08cfa211', '库存盘点', 'ae5a132bbf8d4a67bb22734465236da5', '/jxc/inventory/inventoryMain.jsp', '1', '2', '2', '1', '', '库存盘点');
INSERT INTO `pub_menu` VALUES ('7776013b0fe44ac29901c4a5238e9873', '系统主题管理', 'bb55a5f40f9949b5a0578ff71118c798', 'jxc/xtheme/xthemeMain.jsp', '1', '2', '2', '2', null, '个人系统主题..');
INSERT INTO `pub_menu` VALUES ('782ae938f0474b55aff2dba9a654089b', '订单管理', '020df1bc962544fe953e12917a2aabfa', '/jxc/order/orderMain.jsp', '1', '2', '2', '1', '', '订单管理');
INSERT INTO `pub_menu` VALUES ('79d7304fe985453db3ce1dbc5f661454', '客户购买产品情况', 'f6ddf73bbb6947a1ab848ef68f94cae6', '/jxc/billSauditReport/customerProductMain.jsp', '1', '2', '2', '2', '', '客户购买产品情况');
INSERT INTO `pub_menu` VALUES ('7a526e88fbaf4f309b4b2bc62214ae05', '客户基本信息', '05f700ca85a7414d946e863fee1c27a3', 'jxc/customer/customerMain.jsp', '1', '2', '2', '4', null, '客户资料维护');
INSERT INTO `pub_menu` VALUES ('8d6b0a2422124da5b499e0871a588ee0', '产品查询', '05f700ca85a7414d946e863fee1c27a3', 'jxc/product/productShowMain.jsp', '1', '2', '2', '2', '', '产品、物料查询');
INSERT INTO `pub_menu` VALUES ('a069bd88fdd84f57a63f45009774091e', '入库冲红单管理', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/returnDeliverer/returnDelivererMain.jsp', '1', '2', '2', '3', null, '入库冲红单管理');
INSERT INTO `pub_menu` VALUES ('a1e281e9922a421585081e5a17f6cca8', '密码修改', 'bb55a5f40f9949b5a0578ff71118c798', 'jxc/updatePassword/updatePassword.jsp', '1', '2', '2', '1', null, '修改个人密码..');
INSERT INTO `pub_menu` VALUES ('a61a1f6334dc404eb77a97f0db7095b1', '库存管理', '35e6fa5518c14204b16c179dce78fd02', '', '2', '2', '2', '4', null, '企业库存商品管理');
INSERT INTO `pub_menu` VALUES ('a68fc5b361d44e98970a46d80e4beebe', '退库单管理', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/returned/returnWarehouseMain.jsp', '1', '2', '2', '5', '', '物料退库管理');
INSERT INTO `pub_menu` VALUES ('aab5a53f99834fe89e70eb79852f2823', '部门管理', 'f37cc2606e654826869a761a680590dd', '/jxc/department/department/departmentMain.jsp', '1', '2', '2', '2', null, '部门管理');
INSERT INTO `pub_menu` VALUES ('ab2a405fb0a440cea73debb407dfb4e0', '调拨单管理', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/moveMent/moveMentlMain.jsp', '1', '2', '2', '6', '', '调拨单管理');
INSERT INTO `pub_menu` VALUES ('ae5a132bbf8d4a67bb22734465236da5', '盘点管理', '35e6fa5518c14204b16c179dce78fd02', '', '1', '2', '2', '4', '', '盘点管理');
INSERT INTO `pub_menu` VALUES ('afcf60acb8914de89105f57147c795fb', '仓库基本信息', '05f700ca85a7414d946e863fee1c27a3', 'jxc/warehouse/warehouseMain.jsp', '1', '2', '2', '6', null, '仓库信息维护');
INSERT INTO `pub_menu` VALUES ('b7e526cb05604919a59be9482af1c5aa', '产品库存查询', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/reserveSearch/productMaterialSearch.jsp', '2', '2', '2', '7', '', '产品明细库存查询。');
INSERT INTO `pub_menu` VALUES ('b816ddcdbf4c442c8a691890b51597b1', '物料基本信息', '05f700ca85a7414d946e863fee1c27a3', 'jxc/material/materialMain.jsp', '1', '2', '2', '2', '', '产品物料');
INSERT INTO `pub_menu` VALUES ('ba2d82004b7b4a9fad0f45094c3acf45', '库存查询', 'a61a1f6334dc404eb77a97f0db7095b1', '/jxc/reserveSearch/reserveSearch.jsp', '1', '2', '2', '6', '', '库存查询。。');
INSERT INTO `pub_menu` VALUES ('bb55a5f40f9949b5a0578ff71118c798', '个人管理', '-9999', '', '1', '2', '2', '21', null, '个人信息管理.');
INSERT INTO `pub_menu` VALUES ('cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', '入库单管理', 'a61a1f6334dc404eb77a97f0db7095b1', 'jxc/receipt/receiptMain.jsp', '1', '2', '2', '1', null, '入库单管理..');
INSERT INTO `pub_menu` VALUES ('e3da9e86a2fd4d9b839405fcd603523a', '产品管理', '05f700ca85a7414d946e863fee1c27a3', '/jxc/product/productMain.jsp', '1', '2', '2', '1', '', '产品管理..');
INSERT INTO `pub_menu` VALUES ('ee7799d17e834fa2bb1b2c684211266b', '生产管理', 'f1481d7ef895440eb1c8734f9de736be', 'jxc/manufacture/manufactureMain.jsp', '1', '2', '2', '1', '', '生产管理');
INSERT INTO `pub_menu` VALUES ('ef4624d8578744dcb110416b86cc892e', '采购合同', '020df1bc962544fe953e12917a2aabfa', 'jxc/purchaseContract/purchaseContractMain.jsp', '1', '2', '2', '1', null, '采购合同管理.');
INSERT INTO `pub_menu` VALUES ('f0fc1ac835844d93852b6185b8cc0c9a', '合同采购单', '020df1bc962544fe953e12917a2aabfa', 'jxc/purchase/purchaseMain.jsp', '1', '2', '2', '2', null, '合同采购单管理.');
INSERT INTO `pub_menu` VALUES ('f1481d7ef895440eb1c8734f9de736be', '生产管理', '35e6fa5518c14204b16c179dce78fd02', '', '1', '2', '2', '6', '', '生产管理');
INSERT INTO `pub_menu` VALUES ('f37cc2606e654826869a761a680590dd', '组织架构管理', '-9999', '', '1', '2', '2', '20', null, '系统组织架构管理');
INSERT INTO `pub_menu` VALUES ('f6ddf73bbb6947a1ab848ef68f94cae6', '统计管理', '35e6fa5518c14204b16c179dce78fd02', '', '2', '2', '2', '7', null, '统计报表等.');
INSERT INTO `pub_menu` VALUES ('f934dbf628d942d28b6085a605d6c311', '员工管理', 'f37cc2606e654826869a761a680590dd', '/jxc/department/person/pubPersonMain.jsp', '1', '2', '2', '1', null, '组织机构管理和人员管理');
INSERT INTO `pub_menu` VALUES ('ff9954d813de45a89ac1b590049a5ec2', '物资类别管理', '05f700ca85a7414d946e863fee1c27a3', '/jxc/dictionary/code/codeMain.jsp?moduleCode=wzlb', '1', '2', '2', '7', null, '物资类别管理');

-- ----------------------------
-- Table structure for pub_menu_button
-- ----------------------------
DROP TABLE IF EXISTS `pub_menu_button`;
CREATE TABLE `pub_menu_button` (
  `button_Id` varchar(32) NOT NULL COMMENT '按钮id',
  `parent_Menu_Id` varchar(32) DEFAULT NULL COMMENT '上级菜单id  按钮属于什么菜单下',
  `button_Page_Id` varchar(32) DEFAULT NULL COMMENT '页面按钮id',
  `button_Name` varchar(30) DEFAULT NULL COMMENT '按钮名称',
  `button_English_Name` varchar(100) DEFAULT NULL COMMENT '按钮函数名称',
  `icons` varchar(30) DEFAULT NULL COMMENT '按钮样式名称',
  `sort_Index` int(11) DEFAULT NULL COMMENT '排序索引',
  `powerUrl` varchar(1000) DEFAULT NULL COMMENT '菜单用到的请求',
  `description` varchar(50) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`button_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统菜单对应按钮表';

-- ----------------------------
-- Records of pub_menu_button
-- ----------------------------
INSERT INTO `pub_menu_button` VALUES ('00f054699095498f824cfe5c8a0e3e51', 'a069bd88fdd84f57a63f45009774091e', 'updMmReturnDelivererItemBtn', '修改', 'operMmReturnDelivererItem(\'edit\')', 'icon-modify', '6', null, '更新入库冲红明细单');
INSERT INTO `pub_menu_button` VALUES ('01d44260ab0b4833b5dbbc0ee76f39d0', 'ab2a405fb0a440cea73debb407dfb4e0', 'expMmMoveMentItem', '导出', 'expMmMoveMentItem()', 'icon-exportExcel', '9', '', '导出调拨单明细单');
INSERT INTO `pub_menu_button` VALUES ('068f4ed8f8b245b9ac562ad9a4f2bf45', 'ee7799d17e834fa2bb1b2c684211266b', 'expMmManufactureItem', '导出', 'expMmManufactureItem()', 'icon-exportExcel', '9', '', '导出生产单明细单');
INSERT INTO `pub_menu_button` VALUES ('0b976b6e6c5249f9aacc636090223704', '59ce66eb5a1d4e569e5209301b106641', 'adminRolesManage', '权限管理', 'adminRolesManage()', 'icon-info', '5', null, '角色与权限管理');
INSERT INTO `pub_menu_button` VALUES ('0cb6da2980b54f1a97805439912a88db', 'ef4624d8578744dcb110416b86cc892e', 'manageAttachments', '附件管理', 'createContractAttachmentsWin()', 'icon-info', '5', null, '管理上传好的合同附件');
INSERT INTO `pub_menu_button` VALUES ('0dcf3078afd041e4a550df70aa45de35', '3360c3f18af149a09e2c02806fa2d9aa', 'delIssueBtn', '删除', 'delIssue()', 'icon-delete', '3', null, '删除出库单');
INSERT INTO `pub_menu_button` VALUES ('10731954d0244dab9794fecd828c2546', 'ee7799d17e834fa2bb1b2c684211266b', 'addMmManufactureBtn', '新增', 'saveOrUpdateMmManufacture(\'add\')', 'icon-add', '1', '', '新增生产单');
INSERT INTO `pub_menu_button` VALUES ('131b7ece22d546eab5ef32abc194152e', '695550653d9a4fb3951a5f5b4eb0fc20', 'printWindow', '打印', 'printGrid(\'mmReturnedPurchaseWin\', \'mmReturnedPurchaseForm\', \'mmReturnedPurchaseItemGrid\')', 'icon-print', '10', '', '打印退货单信息');
INSERT INTO `pub_menu_button` VALUES ('15859b9b5dfb4e489335f9255d793190', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'updInventoryBtn', '修改', 'saveOrEditInventory(\'edit\')', 'icon-modify', '2', '', '修改盘点单据');
INSERT INTO `pub_menu_button` VALUES ('158b64bd77764a72b4c56f88720b73ca', 'a069bd88fdd84f57a63f45009774091e', 'delReturnDelivererItemBtn', '删除', 'delReturnDelivererItem()', 'icon-delete', '7', null, '删除入库冲红明细单');
INSERT INTO `pub_menu_button` VALUES ('16328f20ea61427fb501855693cecadc', 'f0fc1ac835844d93852b6185b8cc0c9a', 'delPurchaseBtn', '删除', 'delSelectCustomer()', 'icon-delete', '3', null, '删除合同采购单');
INSERT INTO `pub_menu_button` VALUES ('16ce5f12d9b94dcc92b0739f7fec1375', 'a68fc5b361d44e98970a46d80e4beebe', 'addReturnWarehouseBtn', '新增', 'saveOrUpdateMmReturnWarehouse(\'add\')', 'icon-add', '1', '', '新增退库单');
INSERT INTO `pub_menu_button` VALUES ('1926e645067f4342a05726c53bfe201c', 'a069bd88fdd84f57a63f45009774091e', 'addReturnDelivererBtn', '新增', 'saveOrUpdateMmReturnDeliverer(\'add\')', 'icon-add', '1', null, '新增入库冲红单');
INSERT INTO `pub_menu_button` VALUES ('1a37d80d48144438bb5e8c103243544d', '002', 'delButton', '删除', 'delSelectMenuButton()', 'icon-delete', '3', null, '删除按钮');
INSERT INTO `pub_menu_button` VALUES ('1acafe219d244c30a890ce7f2a0ead77', 'ab2a405fb0a440cea73debb407dfb4e0', 'delMmMoveMentBtn', '删除', 'delMmMoveMent()', 'icon-delete', '3', '', '删除调拨单');
INSERT INTO `pub_menu_button` VALUES ('216d50ee377c47e2b28526a28a269940', 'ef4624d8578744dcb110416b86cc892e', 'addAttachmentsBtn', '附件上传', 'contractAttachments()', 'icon-export', '4', null, '上传合同附件');
INSERT INTO `pub_menu_button` VALUES ('21cd45d6a8a846c7948b398f5b165055', 'a069bd88fdd84f57a63f45009774091e', 'billSauditReceiptDeliverer', '审核', 'billSauditReceiptDeliverer()', 'icon-info', '4', null, '审核入库冲红单');
INSERT INTO `pub_menu_button` VALUES ('227402590b264554bbb94ced61579f10', 'b7e526cb05604919a59be9482af1c5aa', 'expBtn', '导出', 'expProductAndItem()', 'icon-exportExcel', '1', '', '导出excel');
INSERT INTO `pub_menu_button` VALUES ('227d9527b2194c49a6f9137136642c54', 'b816ddcdbf4c442c8a691890b51597b1', 'updBtn', '修改', 'addOrUpdateMaterial(\'edit\')', 'icon-modify', '2', null, '修改产品信息');
INSERT INTO `pub_menu_button` VALUES ('22903e4e8e90493e8c0d1f5d92a8d6da', '3360c3f18af149a09e2c02806fa2d9aa', 'addIssueItemBtn', '新增', 'saveOrUpdateIssueItem(\'add\')', 'icon-add', '5', null, '新增出库明细单');
INSERT INTO `pub_menu_button` VALUES ('235f4fbd9ba94d3f897f6f237c9317a7', 'ee7799d17e834fa2bb1b2c684211266b', 'updMmManufactureItemBtn', '修改', 'saveOrUpdateMmManufactureItem(\'edit\')', 'icon-modify', '6', '', '修改生产单明细单');
INSERT INTO `pub_menu_button` VALUES ('25bcf315e4344be399c7414198a38c65', '3360c3f18af149a09e2c02806fa2d9aa', 'updIssueItemBtn', '修改', 'saveOrUpdateIssueItem(\'edit\')', 'icon-modify', '6', null, '修改出库明细单');
INSERT INTO `pub_menu_button` VALUES ('265d17a4e7684c1b80479754d30e7a3e', '5a269b1db76c4f21bf943d29339b1045', 'billSauditInfo', '审核', 'billSauditInfo()', 'icon-info', '1', '', '审核单据(所有单据.)');
INSERT INTO `pub_menu_button` VALUES ('279ba74e817c4d89a383c0665b04de09', '782ae938f0474b55aff2dba9a654089b', 'billSauditMmOrder', '审核', 'billSauditMmOrder()', 'icon-info', '4', '', '审核订单');
INSERT INTO `pub_menu_button` VALUES ('298dd6736b254571bc212b058503f157', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'addInventoryBtn', '新增', 'saveOrEditInventory(\'add\')', 'icon-add', '1', '', '新增盘点单据');
INSERT INTO `pub_menu_button` VALUES ('2eadbf1d624548769ddd8de07b0ad1ad', '7a526e88fbaf4f309b4b2bc62214ae05', 'delBtn', '删除', 'delSelectCustomer()', 'icon-delete', '3', null, '删除客户信息');
INSERT INTO `pub_menu_button` VALUES ('32115de0061e44a1abddd8c034f0786b', 'a68fc5b361d44e98970a46d80e4beebe', 'printWindow', '打印', 'printGrid(\'returnWarehouseWin\', \'returnWarehouseForm\', \'returnWarehouseItemGrid\')', 'icon-print', '10', '', '打印退库明细单');
INSERT INTO `pub_menu_button` VALUES ('341647dedee9400897c5b1dc3e68c374', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'updReceiptBtn', '修改', 'saveOrUpdateReceipt(\'edit\')', 'icon-modify', '2', null, '修改入库单');
INSERT INTO `pub_menu_button` VALUES ('3455900ff3e345ec807b6ef02ee90c09', '3360c3f18af149a09e2c02806fa2d9aa', 'expIssuelItem', '导出', 'expIssuelItem()', 'icon-exportExcel', '9', '', '导出出库明细单');
INSERT INTO `pub_menu_button` VALUES ('368326b271614bfd9407025d6f00c1a2', '3360c3f18af149a09e2c02806fa2d9aa', 'printWindow', '打印', 'printGrid(\'issueWin\', \'issueForm\', \'issueItemGrid\')', 'icon-print', '10', '', '打印出库明细单');
INSERT INTO `pub_menu_button` VALUES ('37ab306108954ed1b754fff04da72cb3', 'a069bd88fdd84f57a63f45009774091e', 'expReturnDeliverer', '导出', 'expReturnDeliverer', 'icon-exportExcel', '5', '', '导出入库冲红单');
INSERT INTO `pub_menu_button` VALUES ('37ae7519b3ad4a5185d0e0dfa15829bb', '67a09f56cddb491f8e5fcb1b63c2d801', 'addIssueBtn', '新增', 'saveOrUpdateIssue(\'add\')', 'icon-add', '1', 'null', '新增出库单');
INSERT INTO `pub_menu_button` VALUES ('37c0959710bc4d1dadfb13283fc1bcd8', '695550653d9a4fb3951a5f5b4eb0fc20', 'expMmReturnedPurchase', '导出', 'expMmReturnedPurchase()', 'icon-exportExcel', '8', '', '导出退货单');
INSERT INTO `pub_menu_button` VALUES ('37dabae268534ff7a985d09d163bb401', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'addReceiptItemBtn', '新增', 'saveOrUpdateReceiptItem(\'add\')', 'icon-add', '5', null, '新增入库明细单');
INSERT INTO `pub_menu_button` VALUES ('382801f96ed1485ca8ef08bdf6284bad', 'a68fc5b361d44e98970a46d80e4beebe', 'updMmReturnWarehouseItemBtn', '修改', 'saveOrUpdWarehouseItem(\'edit\')', 'icon-modify', '7', '', '修改退库明细单');
INSERT INTO `pub_menu_button` VALUES ('3a0d7ba011174ba28e0748f97f4df53b', '626772d3aaeb45e5b1118ac7336369fa', 'delRolesBtn', '删除', 'delRolesById()', 'icon-delete', '3', null, '删除角色');
INSERT INTO `pub_menu_button` VALUES ('3c70fda83c0a4521ae36802fd6982380', '67a09f56cddb491f8e5fcb1b63c2d801', 'updIssueItemBtn', '修改', 'saveOrUpdateIssueItem(\'edit\')', 'icon-modify', '6', 'null', '修改出库明细单');
INSERT INTO `pub_menu_button` VALUES ('3e0025a91d144b9ba75dc6f93fba22ea', 'b816ddcdbf4c442c8a691890b51597b1', 'delBtn', '删除', 'delSelectMaterial()', 'icon-delete', '3', null, '删除产品信息');
INSERT INTO `pub_menu_button` VALUES ('3f4fb9a57e8843df84217c0df69ddcb1', '8d6b0a2422124da5b499e0871a588ee0', 'expBtn', '导出', 'expProductAndItem()', 'icon-exportExcel', '1', '', '导出产品和明细信息');
INSERT INTO `pub_menu_button` VALUES ('4265f75bad3a486fa5ef2d93324e28d2', '782ae938f0474b55aff2dba9a654089b', 'expMmOrderItem', '导出', 'expMmOrderItem()', 'icon-exportExcel', '9', '', '导出订单明细单');
INSERT INTO `pub_menu_button` VALUES ('4399bd3a7b5e47b0b6c483a2d46e292c', 'f934dbf628d942d28b6085a605d6c311', 'addUserBtn', '新增', 'insertUser()', 'icon-add', '1', 'jjjj\'', '新增人员信息');
INSERT INTO `pub_menu_button` VALUES ('443d49c1fd30479baf50ec3d1ccddca1', 'a069bd88fdd84f57a63f45009774091e', 'expReturnDelivererItem', '导出', 'expReturnDelivererItem()', 'icon-exportExcel', '9', '', '导出入库冲红明细单');
INSERT INTO `pub_menu_button` VALUES ('44e276d563d542e7822c21b4e303f170', 'f934dbf628d942d28b6085a605d6c311', 'updatePersonPassBtn', '修改密码', 'updatePersonPass(\'grid\')', 'icon-modify', '4', null, '修改用户密码');
INSERT INTO `pub_menu_button` VALUES ('453a07cbbd0844f0955edf0630edec2f', 'a069bd88fdd84f57a63f45009774091e', 'addMmReturnDelivererItemBtn', '新增', 'operMmReturnDelivererItem(\'add\')', 'icon-add', '5', null, '新增入库冲红明细单');
INSERT INTO `pub_menu_button` VALUES ('4813df61f8184733b74b7147f3bd0574', 'a68fc5b361d44e98970a46d80e4beebe', 'updReturnWarehouseBtn', '修改', 'saveOrUpdateMmReturnWarehouse(\'edit\')', 'icon-modify', '2', '', '修改退库单。');
INSERT INTO `pub_menu_button` VALUES ('492e5ebd03614b309eec0d55bf22f3ab', '67a09f56cddb491f8e5fcb1b63c2d801', 'delIssueItemBtn', '删除', 'delIssueItem()', 'icon-delete', '7', 'null', '删除出库明细单');
INSERT INTO `pub_menu_button` VALUES ('4a42c8683a164bd787c3d00bc035f1fe', 'ef4624d8578744dcb110416b86cc892e', 'delAttachmentsBtn', '删除', 'ext_DelSelectAttachments()', 'icon-delete', '7', null, '删除上传好的合同附件');
INSERT INTO `pub_menu_button` VALUES ('4caebdfcc44a4cd2a0edba9f730bb01a', '7a526e88fbaf4f309b4b2bc62214ae05', 'addBtn', '新增', 'addOrUpdateCustomer(\'add\')', 'icon-add', '1', null, '新增客户信息');
INSERT INTO `pub_menu_button` VALUES ('500966360f05494d9cd645fdba9d8efc', 'ab2a405fb0a440cea73debb407dfb4e0', 'expMmMoveMent', '导出', 'expMmMoveMent()', 'icon-exportExcel', '8', '', '导出调拨单');
INSERT INTO `pub_menu_button` VALUES ('580949f10c784e6aad5e0b16011cd09d', 'ef4624d8578744dcb110416b86cc892e', 'delContractBtn', '删除', 'delSelectCustomer()', 'icon-delete', '3', null, '删除采购合同');
INSERT INTO `pub_menu_button` VALUES ('5d3c04b6eea647bc85f80b39c660b511', 'e3da9e86a2fd4d9b839405fcd603523a', 'updBtn', '修改', 'addOrUpdateProduct(\'edit\')', 'icon-modify', '2', '', '修改产品信息');
INSERT INTO `pub_menu_button` VALUES ('5e08327f381e4a76a8bfee0fe281c64b', '105be1ac21fa440bacfaea1752a19b5e', 'updBtn', '修改', 'addOrUpdateMmVendor(\'edit\')', 'icon-modify', '2', null, '修改供应商信息');
INSERT INTO `pub_menu_button` VALUES ('5ea9258c5f034ac1ab3054207f8687ec', 'aab5a53f99834fe89e70eb79852f2823', 'delDeparmentBtn', '删除', 'delOrgBySelectNode()', 'icon-delete', '3', null, '删除选中的架构信息\r\n');
INSERT INTO `pub_menu_button` VALUES ('5f3a8c130a3144d1811aa2f1c16f5660', '626772d3aaeb45e5b1118ac7336369fa', 'addRolesBtn', '新增', 'isertRoles', 'icon-add', '1', null, 'dfsd');
INSERT INTO `pub_menu_button` VALUES ('6142e7ccf1a74b87a1e66d6702a927e5', 'a68fc5b361d44e98970a46d80e4beebe', 'delReceiptWarehouseBtn', '删除', 'delReturnWarehouse()', 'icon-delete', '3', '', '删除。');
INSERT INTO `pub_menu_button` VALUES ('63bdd008df4648a0a7b4f60a2ec4cef6', '782ae938f0474b55aff2dba9a654089b', 'delMmOrderBtn', '删除', 'delMmOrder()', 'icon-delete', '3', '', '删除订单');
INSERT INTO `pub_menu_button` VALUES ('6429dcd520a14d5f9b14a1a7af78a242', '782ae938f0474b55aff2dba9a654089b', 'addMmOrderItemBtn', '新增', 'saveOrUpdateMmOrderItem(\'add\')', 'icon-add', '5', '', '新增订单明细单');
INSERT INTO `pub_menu_button` VALUES ('6751b5a417b5439a883e3ff7f70458bc', '695550653d9a4fb3951a5f5b4eb0fc20', 'delMmReturnedPurchaseBtn', '删除', 'delMmReturnedPurchase()', 'icon-delete', '3', '', '删除退货单');
INSERT INTO `pub_menu_button` VALUES ('67a4d69976124a479ee6778ad85c2691', '3360c3f18af149a09e2c02806fa2d9aa', 'updIssueBtn', '修改', 'saveOrUpdateIssue(\'edit\')', 'icon-modify', '2', null, '修改出库单');
INSERT INTO `pub_menu_button` VALUES ('68fa89f9158941c5a695e838eedd89fa', 'b816ddcdbf4c442c8a691890b51597b1', 'addBtn', '新增', 'addOrUpdateMaterial(\'add\')', 'icon-add', '1', null, '增加产品信息');
INSERT INTO `pub_menu_button` VALUES ('6adbe479beda41818627995615e7207b', 'a68fc5b361d44e98970a46d80e4beebe', 'delReturnWarehouseItemBtn', '删除', 'delReturnWarehouseItem()', 'icon-delete', '8', '', '删除退库明细单');
INSERT INTO `pub_menu_button` VALUES ('6b95b4867f7a48f1b0ea8868cb3956b7', 'aab5a53f99834fe89e70eb79852f2823', 'addDeparmentBtn', '新增', 'editNextOrg(\'add\')', 'icon-add', '1', null, '新增下级架构');
INSERT INTO `pub_menu_button` VALUES ('713e52bfa2904914ad9fe62a950a36cc', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'updReceiptItemBtn', '修改', 'saveOrUpdateReceiptItem(\'edit\')', 'icon-modify', '6', null, '修改入库明细单');
INSERT INTO `pub_menu_button` VALUES ('7821ae70e63b492f834c5858151261b5', 'ab2a405fb0a440cea73debb407dfb4e0', 'updMmMoveMentItemBtn', '修改', 'saveOrUpdateMmMoveMentItem(\'edit\')', 'icon-modify', '6', '', '修改调拨单明细单');
INSERT INTO `pub_menu_button` VALUES ('782b1e758b7a4f74a2385c720ca555a2', 'a68fc5b361d44e98970a46d80e4beebe', 'billSauditRetrunWarehouse', '审核', 'billSauditRetrunWarehouse()', 'icon-info', '4', '', '审核退库单。');
INSERT INTO `pub_menu_button` VALUES ('78496f851ed74bf9a3a10b198a12a256', '05e1f9427dc54ca0a696b95f6fbb85d1', 'backupDataBaseBtn', '备份', 'backupDataBase()', 'icon-info', '1', '', '备份数据');
INSERT INTO `pub_menu_button` VALUES ('7a84bd6e1c3c48e989726c4333ec651d', '105be1ac21fa440bacfaea1752a19b5e', 'delBtn', '删除', 'delSelectMmVendor()', 'icon-delete', '3', null, '删除供应商信息');
INSERT INTO `pub_menu_button` VALUES ('7ba5c43321194083a85395cee4840047', 'f0fc1ac835844d93852b6185b8cc0c9a', 'delPurchaseItemBtn', '删除', 'delSelectPurchaseItem()', 'icon-delete', '6', null, '删除采购明细单');
INSERT INTO `pub_menu_button` VALUES ('7e839dd119a94df087a272289d0951cd', '3360c3f18af149a09e2c02806fa2d9aa', 'billSauditIssueBtn', '审核', 'billSauditIsSue()', 'icon-info', '4', null, '审核出库单');
INSERT INTO `pub_menu_button` VALUES ('847b9d7beaab4e799610bf7563e903bc', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'expReceipt', '导出', 'expReceipt()', 'icon-exportExcel', '8', '', '导出入库单');
INSERT INTO `pub_menu_button` VALUES ('85a573b919b34e7ca3fcdecfe33f2588', 'ba2d82004b7b4a9fad0f45094c3acf45', 'showItemGrid', '明细', 'showItemGrid', 'icon-info', '1', '', '显示物资在各仓库明细库存数量');
INSERT INTO `pub_menu_button` VALUES ('8683659d83404a1c8d08c5eff8b4b121', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'billSauditReceipt', '审核', 'billSauditReceipt()', 'icon-info', '4', null, '审核入库单');
INSERT INTO `pub_menu_button` VALUES ('88de5b000aba4647a76c11d32303a9c2', '67a09f56cddb491f8e5fcb1b63c2d801', 'expIssuelItem', '导出', 'expIssuelItem()', 'icon-exportExcel', '9', '', '导出出库明细单');
INSERT INTO `pub_menu_button` VALUES ('8a1faa4433c843c79a01e0f2d48f6cca', 'a68fc5b361d44e98970a46d80e4beebe', 'addMmReturnWarehouseItemBtn', '新增', 'saveOrUpdWarehouseItem(\'add\')', 'icon-add', '6', '', '新增退库明细单');
INSERT INTO `pub_menu_button` VALUES ('8b1ee76a985a47a7a3e44a84a18f0276', '002', 'updButton', '修改', 'addOrEditMenuButton(\'edit\')', 'icon-modify', '2', null, '修改菜单信息按钮');
INSERT INTO `pub_menu_button` VALUES ('8d768166af6c40d9b83394a10992b98e', 'ef4624d8578744dcb110416b86cc892e', 'billSauditReceipt', '审核', 'billSauditPurchaseContract()', 'icon-info', '9', null, '审核采购合同');
INSERT INTO `pub_menu_button` VALUES ('907288e46d414582b0da05e60aeb8657', 'e3da9e86a2fd4d9b839405fcd603523a', 'addBtn', '新增', 'addOrUpdateProduct(\'add\')', 'icon-add', '1', '', '新增产品');
INSERT INTO `pub_menu_button` VALUES ('9254c2b1fa8d4baca75240d891a9a75b', 'f0fc1ac835844d93852b6185b8cc0c9a', 'updPurchaseBtn', '修改', 'addOrUpdatePurchase(\'edit\')', 'icon-modify', '2', null, '修改合同采购单');
INSERT INTO `pub_menu_button` VALUES ('9307af42980a49da9501ea2a0e626613', 'e3da9e86a2fd4d9b839405fcd603523a', 'addItemBtn', '新增', 'saveOrUpdProductItem(\'add\')', 'icon-add', '4', '', '新增产品明细');
INSERT INTO `pub_menu_button` VALUES ('93d2d73dfcef48b69de08b8d8f580f44', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'delInventoryItemBtn', '删除', 'delInventoryItem', 'icon-delete', '8', '', '删除盘点明细。');
INSERT INTO `pub_menu_button` VALUES ('96e93c37a4e84336b3b469ee410716e8', '626772d3aaeb45e5b1118ac7336369fa', 'rolesAndRolesManage', '人员角色分配', 'rolesAndRolesManage(\'grid\')', 'icon-info', '4', null, '角色与人员管理');
INSERT INTO `pub_menu_button` VALUES ('9738a66f4de84daa912795ff5260527d', '67a09f56cddb491f8e5fcb1b63c2d801', 'printWindow', '打印', 'printGrid(\'issueWin\', \'issueForm\', \'issueItemGrid\')', 'icon-print', '10', '', '打印产品明细出库');
INSERT INTO `pub_menu_button` VALUES ('9b8541d122954c9fa7fc32cfffae9127', 'ef4624d8578744dcb110416b86cc892e', 'updContractBtn', '修改', 'addOrUpdatePurchaseContract(\'edit\')', 'icon-modify', '2', null, '修改采购合同');
INSERT INTO `pub_menu_button` VALUES ('9b985b9ccb43430fa04f5c470ed45644', 'ee7799d17e834fa2bb1b2c684211266b', 'delMmManufactureBtn', '删除', 'delMmManufacture()', 'icon-delete', '3', '', '删除生产单');
INSERT INTO `pub_menu_button` VALUES ('9f67324f413b4e60a8930d44fd0fe53c', 'f0fc1ac835844d93852b6185b8cc0c9a', 'updPurchaseItemBtn', '修改', 'addOrUpdatePurchaseItem(\'edit\')', 'icon-modify', '5', null, '修改采购明细单');
INSERT INTO `pub_menu_button` VALUES ('9f956f992a394e26a8b73cfdd76d9ffb', 'a069bd88fdd84f57a63f45009774091e', 'delReceiptDelivererBtn', '删除', 'delReturnDeliverer()', 'icon-delete', '3', null, '删除入库冲红单');
INSERT INTO `pub_menu_button` VALUES ('a0820b6c65de4368b67c7fe22bec661f', '695550653d9a4fb3951a5f5b4eb0fc20', 'billSauditMmReturnedPurchase', '审核', 'billSauditMmReturnedPurchase()', 'icon-info', '4', '', '审核退货单');
INSERT INTO `pub_menu_button` VALUES ('a09cb5a677b34ea89647880c588d053a', 'ef4624d8578744dcb110416b86cc892e', 'addContractBtn', '新增', 'addOrUpdatePurchaseContract(\'add\')', 'icon-add', '1', null, '新增采购合同');
INSERT INTO `pub_menu_button` VALUES ('a0afc83069d0472a82b8c8f8dd05873f', 'ee7799d17e834fa2bb1b2c684211266b', 'expMmManufacture', '导出', 'expMmManufacture()', 'icon-exportExcel', '8', '', '导出生产单');
INSERT INTO `pub_menu_button` VALUES ('a12c8730e90047b9a0139e5c47dce9c4', '695550653d9a4fb3951a5f5b4eb0fc20', 'addMmReturnedPurchaseItemBtn', '新增', 'saveOrUpdateMmReturnedPurchaseItem(\'add\')', 'icon-add', '5', '', '新增退货单明细单');
INSERT INTO `pub_menu_button` VALUES ('a133c825f72a42a598348bdb65d38143', '67a09f56cddb491f8e5fcb1b63c2d801', 'updIssueBtn', '修改', 'saveOrUpdateIssue(\'edit\')', 'icon-modify', '2', 'null', '修改出库单');
INSERT INTO `pub_menu_button` VALUES ('a2989d39968b4e47b5c353009579dc68', 'ab2a405fb0a440cea73debb407dfb4e0', 'billSauditMmMoveMent', '审核', 'billSauditMmMoveMent()', 'icon-info', '4', '', '审核调拨单');
INSERT INTO `pub_menu_button` VALUES ('a5765bcceb664019a3543cc52257b805', '3360c3f18af149a09e2c02806fa2d9aa', 'expIssuel', '导出', 'expIssuel()', 'icon-exportExcel', '8', '', '导出出库单');
INSERT INTO `pub_menu_button` VALUES ('a6749fcbac1547ed9158f0cb1e624b53', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'addInventoryItemBtn', '新增', 'addInventoryItem', 'icon-add', '6', '', '新增盘点明细');
INSERT INTO `pub_menu_button` VALUES ('a7f591ab9ac34a1895c76d13fcc4dc0c', 'ef4624d8578744dcb110416b86cc892e', 'updAttachmentsBtn', '修改', 'updAttachments()', 'icon-modify', '6', null, '修改上传好的合同附件');
INSERT INTO `pub_menu_button` VALUES ('a8b453e463f1401abd0750efbd4160a7', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'expReceiptItem', '导出', 'expReceiptItem()', 'icon-exportExcel', '9', '', '导出入库明细单');
INSERT INTO `pub_menu_button` VALUES ('a8cbfcfb17604055adce75bdc4959a31', '67a09f56cddb491f8e5fcb1b63c2d801', 'addIssueItemBtn', '新增', 'saveOrUpdateIssueItem(\'add\')', 'icon-add', '5', 'null', '新增出库明细单');
INSERT INTO `pub_menu_button` VALUES ('a951c9a872c24a4bac93fb192b2d8f12', '782ae938f0474b55aff2dba9a654089b', 'addMmOrderBtn', '新增', 'saveOrUpdateMmOrder(\'add\')', 'icon-add', '1', '', '新增订单');
INSERT INTO `pub_menu_button` VALUES ('aa79b93d7e5043048a94349818a1d281', '626772d3aaeb45e5b1118ac7336369fa', 'saveRolesBtn', '保存', 'saveRoles', 'icon-save', '2', null, '保存角色名称');
INSERT INTO `pub_menu_button` VALUES ('abc7832801144c2184b40167298364d8', '695550653d9a4fb3951a5f5b4eb0fc20', 'expMmReturnedPurchaseItem', '导出', 'expMmReturnedPurchaseItem()', 'icon-exportExcel', '9', '', '导出退货单明细单');
INSERT INTO `pub_menu_button` VALUES ('aec5ea1c74f243d0b546f7b2ba67ff6b', '3360c3f18af149a09e2c02806fa2d9aa', 'delIssueItemBtn', '删除', 'delIssueItem()', 'icon-delete', '7', null, '删除出库明细单');
INSERT INTO `pub_menu_button` VALUES ('af1e88a4edc748bcb50973e43108a74f', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'saveInventoryItemBtn', '保存', 'saveInventoryItem', 'icon-save', '7', '', '保存盘点明细');
INSERT INTO `pub_menu_button` VALUES ('b0153873999f4913bed8a8f3874ce889', '7a526e88fbaf4f309b4b2bc62214ae05', 'updBtn', '修改', 'addOrUpdateCustomer(\'edit\')', 'icon-add', '2', null, '修改客户信息');
INSERT INTO `pub_menu_button` VALUES ('b254a1e3681f461ba885d21a7eecd5c1', 'f0fc1ac835844d93852b6185b8cc0c9a', 'addPurchaseBtn', '新增', 'addOrUpdatePurchase(\'add\')', 'icon-add', '1', null, '新增合同采购单');
INSERT INTO `pub_menu_button` VALUES ('b603ed624d9b48b3b166d41dbbc416c4', 'ee7799d17e834fa2bb1b2c684211266b', 'addMmManufactureItemBtn', '新增', 'saveOrUpdateMmManufactureItem(\'add\')', 'icon-add', '5', '', '新增生产单明细单');
INSERT INTO `pub_menu_button` VALUES ('b683fcb6267844a7854d410344922bc2', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'addReceiptBtn', '新增', 'saveOrUpdateReceipt(\'add\')', 'icon-add', '1', null, '新增入库单');
INSERT INTO `pub_menu_button` VALUES ('bbcd05bdc05d484d93095c060e41e089', 'ee7799d17e834fa2bb1b2c684211266b', 'delMmManufactureItemBtn', '删除', 'delMmManufactureItem()', 'icon-delete', '7', '', '删除生产单明细单');
INSERT INTO `pub_menu_button` VALUES ('bc554acbaf114a20a61e0d0c03410794', 'a069bd88fdd84f57a63f45009774091e', 'updReturnDelivererBtn', '修改', 'saveOrUpdateMmReturnDeliverer(\'edit\')', 'icon-modify', '2', null, '修改入库冲红单');
INSERT INTO `pub_menu_button` VALUES ('bd7189075d85460191076aa87bea3faf', 'a68fc5b361d44e98970a46d80e4beebe', 'expReturnWarehouse', '导出', 'expReturnWarehouse()', 'icon-exportExcel', '5', '', '导出excel');
INSERT INTO `pub_menu_button` VALUES ('bddd4aed34de468b8cdcbf14d491d8c4', '782ae938f0474b55aff2dba9a654089b', 'printMmOrderItem', '打印', 'printGrid(\'mmOrderWin\', \'mmOrderForm\', \'mmOrderItemGrid\')', 'icon-print', '10', '', '打印订单明细列表');
INSERT INTO `pub_menu_button` VALUES ('be9bfb0d703544f3bfda2c30c24572aa', '67a09f56cddb491f8e5fcb1b63c2d801', 'expIssuel', '导出', 'expIssuel()', 'icon-exportExcel', '8', '', '导出出库单');
INSERT INTO `pub_menu_button` VALUES ('c1a9882e69d6488cbd2646a79c31824d', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'delInventoryBtn', '删除', 'delInventory()', 'icon-delete', '3', '', '删除');
INSERT INTO `pub_menu_button` VALUES ('c280bafc5a1e4a5e9efdfc6fb5402f65', '695550653d9a4fb3951a5f5b4eb0fc20', 'delMmReturnedPurchaseItemBtn', '删除', 'delMmReturnedPurchaseItem()', 'icon-delete', '7', '', '删除退货单明细单');
INSERT INTO `pub_menu_button` VALUES ('c3376026569841c08a298349e6730a17', 'aab5a53f99834fe89e70eb79852f2823', 'saveDeparmentBtn', '编辑', 'editNextOrg(\'edit\')', 'icon-modify', '2', null, '编辑选中的架构信息');
INSERT INTO `pub_menu_button` VALUES ('c4d70d03f18c499890a1e563d3fe17d3', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'printWindow', '打印', 'printGrid(\'win\', \'form\', \'receiptItemGrid\')', 'icon-print', '10', '', '打印入库单明细单');
INSERT INTO `pub_menu_button` VALUES ('c9ab30d3a1614881b2b8fe22ebb61c77', 'ee7799d17e834fa2bb1b2c684211266b', 'printWindow', '打印', 'printGrid(\'mmManufactureWin\', \'mmManufactureForm\', \'mmManufactureItemGrid\')', 'icon-print', '10', '', '打印生产单');
INSERT INTO `pub_menu_button` VALUES ('ce58af8147da4f2093da12618005fe11', '67a09f56cddb491f8e5fcb1b63c2d801', 'delIssueBtn', '删除', 'delIssue()', 'icon-delete', '3', 'null', '删除出库单');
INSERT INTO `pub_menu_button` VALUES ('cfbf7ce7586043bab05353bef82a96d0', '782ae938f0474b55aff2dba9a654089b', 'updMmOrderItemBtn', '修改', 'saveOrUpdateMmOrderItem(\'edit\')', 'icon-modify', '6', '', '修改订单明细单');
INSERT INTO `pub_menu_button` VALUES ('d206f9e783ef44789b665c866cd821c1', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'delReceiptItemBtn', '删除', 'delReceiptItem()', 'icon-delete', '7', null, '删除入库明细单');
INSERT INTO `pub_menu_button` VALUES ('d3570e4f7d25448fa0de504a6d0e110f', '67a09f56cddb491f8e5fcb1b63c2d801', 'billSauditIssueBtn', '审核', 'billSauditIsSue()', 'icon-info', '4', 'null', '审核出库单');
INSERT INTO `pub_menu_button` VALUES ('d45587a85c8949c3a7a6392bd8c1f330', 'a68fc5b361d44e98970a46d80e4beebe', 'expReturnWarehouseItem', '导出', 'expReturnWarehouseItem()', 'icon-exportExcel', '9', '', '导出退库明细单');
INSERT INTO `pub_menu_button` VALUES ('d5024df0d4354cb6aaadd11024094a4c', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'billSauditInventoryBtn', '审核', 'billSauditInventory()', 'icon-info', '4', '', '审核盘点单据');
INSERT INTO `pub_menu_button` VALUES ('d5be02a4ce60475dbfc810380e6b3987', '6df1ffbeb03d4e9b8e26c2ad08cfa211', 'expInventoryBtn', '导出', 'expInventory()', 'icon-exportExcel', '5', '', '导出盘点单据');
INSERT INTO `pub_menu_button` VALUES ('d6fb20c245ce49e18b96c1c6e6a5e4ff', 'f0fc1ac835844d93852b6185b8cc0c9a', 'billSauditPurchase', '审核', 'billSauditPurchase()', 'icon-info', '7', null, '审核合同采购单');
INSERT INTO `pub_menu_button` VALUES ('d722b465284a461c92531856bdf2aef9', '695550653d9a4fb3951a5f5b4eb0fc20', 'addMmReturnedPurchaseBtn', '新增', 'saveOrUpdateMmReturnedPurchase(\'add\')', 'icon-add', '1', '', '新增退货单');
INSERT INTO `pub_menu_button` VALUES ('d752b3811df340a3a88eec0b3e8380ac', '782ae938f0474b55aff2dba9a654089b', 'updMmOrderBtn', '修改', 'saveOrUpdateMmOrder(\'edit\')', 'icon-modify', '2', '', '修改订单');
INSERT INTO `pub_menu_button` VALUES ('d84508e72c8b43b882c603f8d9c986c2', 'ab2a405fb0a440cea73debb407dfb4e0', 'updMmMoveMentBtn', '修改', 'saveOrUpdateMmMoveMent(\'edit\')', 'icon-modify', '2', '', '修改调拨单');
INSERT INTO `pub_menu_button` VALUES ('d864df7125514dafb15db2a49304b773', 'ab2a405fb0a440cea73debb407dfb4e0', 'printWindow', '打印', 'printGrid(\'mmMoveMentWin\', \'mmMoveMentForm\', \'mmMoveMentItemGrid\')', 'icon-print', '10', '', '打印调拨明细单');
INSERT INTO `pub_menu_button` VALUES ('da01d6b93a184b46951c1d0ba462701f', 'e3da9e86a2fd4d9b839405fcd603523a', 'delBtn', '删除', 'delSelectProduct', 'icon-delete', '3', '', '删除产品信息 同时删除明细信息');
INSERT INTO `pub_menu_button` VALUES ('dcba21ec35984c68a84175a03376ff10', 'f934dbf628d942d28b6085a605d6c311', 'delUserBtn', '删除', 'deleteSelectPerson(\'grid\')', 'icon-delete', '3', null, '删除用户');
INSERT INTO `pub_menu_button` VALUES ('dceba662dc3642d2b7df3ba8e5507416', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'delReceiptBtn', '删除', 'delReceipt()', 'icon-delete', '3', null, '删除入库单');
INSERT INTO `pub_menu_button` VALUES ('de8ac9bf2ad74a63b6e562763055d956', 'e3da9e86a2fd4d9b839405fcd603523a', 'updItemBtn', '修改', 'saveOrUpdProductItem(\'edit\')', 'icon-modify', '5', '', '修改产品明细');
INSERT INTO `pub_menu_button` VALUES ('e065c485d2a947e58fa4c91c48e8c74e', 'ab2a405fb0a440cea73debb407dfb4e0', 'addMmMoveMentBtn', '新增', 'saveOrUpdateMmMoveMent(\'add\')', 'icon-add', '1', '', '新增调拨单');
INSERT INTO `pub_menu_button` VALUES ('e0d87d90b2c14df5ac9cc862dd1f236e', 'a069bd88fdd84f57a63f45009774091e', 'printWindow', '打印', 'printGrid(\'win\', \'form\', \'returnDelivererItemGrid\')', 'icon-print', '10', '', '打印入库冲红明细');
INSERT INTO `pub_menu_button` VALUES ('e5952fde89ce4c3d9d149b2e95c24592', 'ee7799d17e834fa2bb1b2c684211266b', 'updMmManufactureBtn', '修改', 'saveOrUpdateMmManufacture(\'edit\')', 'icon-modify', '2', '', '修改生产单');
INSERT INTO `pub_menu_button` VALUES ('e6a9f4a6bd194cd1b7da1bc514799c09', '782ae938f0474b55aff2dba9a654089b', 'expMmOrder', '导出', 'expMmOrder()', 'icon-exportExcel', '8', '', '导出订单');
INSERT INTO `pub_menu_button` VALUES ('e7210c3d12144d6893871ecb44183a13', '695550653d9a4fb3951a5f5b4eb0fc20', 'updMmReturnedPurchaseBtn', '修改', 'saveOrUpdateMmReturnedPurchase(\'edit\')', 'icon-modify', '2', '', '修改退货单');
INSERT INTO `pub_menu_button` VALUES ('e8160cc670e346bd815bfbcb544d4f52', '695550653d9a4fb3951a5f5b4eb0fc20', 'updMmReturnedPurchaseItemBtn', '修改', 'saveOrUpdateMmReturnedPurchaseItem(\'edit\')', 'icon-modify', '6', '', '修改退货单明细单');
INSERT INTO `pub_menu_button` VALUES ('eb6a517318eb4bd3b183699558edacef', '105be1ac21fa440bacfaea1752a19b5e', 'addBtn', '新增', 'addOrUpdateMmVendor(\'add\')', 'icon-add', '1', null, '新增供应商按钮');
INSERT INTO `pub_menu_button` VALUES ('ebe510e0761041fa81831d84746ef052', '3360c3f18af149a09e2c02806fa2d9aa', 'addIssueBtn', '新增', 'saveOrUpdateIssue(\'add\')', 'icon-add', '1', null, '新增出库单');
INSERT INTO `pub_menu_button` VALUES ('ee5c8c309cc74e7087cd109e511272f3', 'ee7799d17e834fa2bb1b2c684211266b', 'billSauditMmManufacture', '审核', 'billSauditMmManufacture()', 'icon-info', '4', '', '审核生产单');
INSERT INTO `pub_menu_button` VALUES ('f46eb9b199dc462a86bf950618284007', 'e3da9e86a2fd4d9b839405fcd603523a', 'delItemBtn', '删除', 'delProductItem()', 'icon-delete', '6', '', '删除产品明细');
INSERT INTO `pub_menu_button` VALUES ('f53972ae2a204a1182468dfca38a2651', '002', 'addButton', '新增', 'addOrEditMenuButton(\'add\')', 'icon-add', '1', null, '新增页面菜单按钮');
INSERT INTO `pub_menu_button` VALUES ('f56c17f9a6b049aaa1dbfee45af9e753', 'ef4624d8578744dcb110416b86cc892e', 'downAttachmentsBtn', '下载', 'downAttachmentsFile()', 'icon-import', '8', null, '下载上传好的合同附件');
INSERT INTO `pub_menu_button` VALUES ('f66c535f8b9a423f8672716f8962c089', 'ab2a405fb0a440cea73debb407dfb4e0', 'addMmMoveMentItemBtn', '新增', 'saveOrUpdateMmMoveMentItem(\'add\')', 'icon-add', '5', '', '新增调拨单明细单');
INSERT INTO `pub_menu_button` VALUES ('f6ca822cb9cd4293822a1c36eb3b3ee3', '782ae938f0474b55aff2dba9a654089b', 'delMmOrderItemBtn', '删除', 'delMmOrderItem()', 'icon-delete', '7', '', '删除订单明细单');
INSERT INTO `pub_menu_button` VALUES ('f9ade753b00642878b2bce37c152628d', 'f934dbf628d942d28b6085a605d6c311', 'saveUserBtn', '保存', 'saveUser()', 'icon-save', '2', null, '保存用户信息');
INSERT INTO `pub_menu_button` VALUES ('fa41046d10ca46458c809372a5cc3a4a', 'ab2a405fb0a440cea73debb407dfb4e0', 'delMmMoveMentItemBtn', '删除', 'delMmMoveMentItem()', 'icon-delete', '7', '', '删除调拨单明细单');
INSERT INTO `pub_menu_button` VALUES ('fa851bc325914558900a77e472bce637', 'f0fc1ac835844d93852b6185b8cc0c9a', 'addPurchaseItemBtn', '新增', 'addOrUpdatePurchaseItem(\'add\')', 'icon-add', '4', null, '新增采购明细单');

-- ----------------------------
-- Table structure for pub_menu_roles
-- ----------------------------
DROP TABLE IF EXISTS `pub_menu_roles`;
CREATE TABLE `pub_menu_roles` (
  `roles_id` varchar(32) DEFAULT NULL COMMENT '角色id',
  `menu_id` varchar(32) DEFAULT NULL COMMENT '角色名称',
  `type` varchar(10) DEFAULT NULL COMMENT '类型（menu菜单 button按钮）'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与菜单';

-- ----------------------------
-- Records of pub_menu_roles
-- ----------------------------
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '35e6fa5518c14204b16c179dce78fd02', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '05f700ca85a7414d946e863fee1c27a3', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', 'b816ddcdbf4c442c8a691890b51597b1', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '68fa89f9158941c5a695e838eedd89fa', 'button');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '227d9527b2194c49a6f9137136642c54', 'button');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '3e0025a91d144b9ba75dc6f93fba22ea', 'button');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '001', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '002', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', 'f53972ae2a204a1182468dfca38a2651', 'button');
INSERT INTO `pub_menu_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '8b1ee76a985a47a7a3e44a84a18f0276', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '35e6fa5518c14204b16c179dce78fd02', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '05f700ca85a7414d946e863fee1c27a3', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'b816ddcdbf4c442c8a691890b51597b1', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '68fa89f9158941c5a695e838eedd89fa', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '227d9527b2194c49a6f9137136642c54', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '3e0025a91d144b9ba75dc6f93fba22ea', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '105be1ac21fa440bacfaea1752a19b5e', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '7a84bd6e1c3c48e989726c4333ec651d', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '7a526e88fbaf4f309b4b2bc62214ae05', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '4caebdfcc44a4cd2a0edba9f730bb01a', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'b0153873999f4913bed8a8f3874ce889', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '2eadbf1d624548769ddd8de07b0ad1ad', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'afcf60acb8914de89105f57147c795fb', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '020df1bc962544fe953e12917a2aabfa', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'ef4624d8578744dcb110416b86cc892e', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'a09cb5a677b34ea89647880c588d053a', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '9b8541d122954c9fa7fc32cfffae9127', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '580949f10c784e6aad5e0b16011cd09d', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '216d50ee377c47e2b28526a28a269940', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '0cb6da2980b54f1a97805439912a88db', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'a7f591ab9ac34a1895c76d13fcc4dc0c', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '4a42c8683a164bd787c3d00bc035f1fe', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f56c17f9a6b049aaa1dbfee45af9e753', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '8d768166af6c40d9b83394a10992b98e', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f0fc1ac835844d93852b6185b8cc0c9a', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'b254a1e3681f461ba885d21a7eecd5c1', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '9254c2b1fa8d4baca75240d891a9a75b', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '16328f20ea61427fb501855693cecadc', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'fa851bc325914558900a77e472bce637', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '9f67324f413b4e60a8930d44fd0fe53c', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '7ba5c43321194083a85395cee4840047', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'd6fb20c245ce49e18b96c1c6e6a5e4ff', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'a61a1f6334dc404eb77a97f0db7095b1', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'cc3b1bbaf2214c7cbf6a5fe5b1c9ab5f', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'b683fcb6267844a7854d410344922bc2', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '341647dedee9400897c5b1dc3e68c374', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'dceba662dc3642d2b7df3ba8e5507416', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '8683659d83404a1c8d08c5eff8b4b121', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '37dabae268534ff7a985d09d163bb401', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '713e52bfa2904914ad9fe62a950a36cc', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'd206f9e783ef44789b665c866cd821c1', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'a069bd88fdd84f57a63f45009774091e', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '1926e645067f4342a05726c53bfe201c', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'bc554acbaf114a20a61e0d0c03410794', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '9f956f992a394e26a8b73cfdd76d9ffb', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '21cd45d6a8a846c7948b398f5b165055', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '453a07cbbd0844f0955edf0630edec2f', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '00f054699095498f824cfe5c8a0e3e51', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '158b64bd77764a72b4c56f88720b73ca', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '3360c3f18af149a09e2c02806fa2d9aa', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'ebe510e0761041fa81831d84746ef052', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '67a4d69976124a479ee6778ad85c2691', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '0dcf3078afd041e4a550df70aa45de35', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '7e839dd119a94df087a272289d0951cd', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '22903e4e8e90493e8c0d1f5d92a8d6da', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '25bcf315e4344be399c7414198a38c65', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'aec5ea1c74f243d0b546f7b2ba67ff6b', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f6ddf73bbb6947a1ab848ef68f94cae6', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '01f12cd4b6d0459295f985e29820162d', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '001', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '002', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f53972ae2a204a1182468dfca38a2651', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '8b1ee76a985a47a7a3e44a84a18f0276', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '1a37d80d48144438bb5e8c103243544d', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '626772d3aaeb45e5b1118ac7336369fa', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '5f3a8c130a3144d1811aa2f1c16f5660', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'aa79b93d7e5043048a94349818a1d281', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '3a0d7ba011174ba28e0748f97f4df53b', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '96e93c37a4e84336b3b469ee410716e8', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '59ce66eb5a1d4e569e5209301b106641', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '0b976b6e6c5249f9aacc636090223704', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '5a269b1db76c4f21bf943d29339b1045', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '265d17a4e7684c1b80479754d30e7a3e', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f37cc2606e654826869a761a680590dd', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f934dbf628d942d28b6085a605d6c311', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '4399bd3a7b5e47b0b6c483a2d46e292c', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'f9ade753b00642878b2bce37c152628d', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'dcba21ec35984c68a84175a03376ff10', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '44e276d563d542e7822c21b4e303f170', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'aab5a53f99834fe89e70eb79852f2823', 'menu');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '6b95b4867f7a48f1b0ea8868cb3956b7', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', 'c3376026569841c08a298349e6730a17', 'button');
INSERT INTO `pub_menu_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '5ea9258c5f034ac1ab3054207f8687ec', 'button');

-- ----------------------------
-- Table structure for pub_roles
-- ----------------------------
DROP TABLE IF EXISTS `pub_roles`;
CREATE TABLE `pub_roles` (
  `roles_id` varchar(32) DEFAULT NULL COMMENT '角色id',
  `roles_Name` varchar(30) DEFAULT NULL COMMENT '角色名称',
  `showSort` int(11) DEFAULT NULL COMMENT '排序索引',
  `create_date` date DEFAULT NULL COMMENT '创建时间',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统角色表';

-- ----------------------------
-- Records of pub_roles
-- ----------------------------
INSERT INTO `pub_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '2', '1', '2012-05-18', '1');
INSERT INTO `pub_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', 'test', '2', '2012-05-18', 'stest');
INSERT INTO `pub_roles` VALUES ('74b4cc9fdb164414a40d34b8f7d8d14d', 'dd地得到方', '3', '2012-12-31', '');

-- ----------------------------
-- Table structure for pub_user
-- ----------------------------
DROP TABLE IF EXISTS `pub_user`;
CREATE TABLE `pub_user` (
  `USER_ID` varchar(32) NOT NULL DEFAULT '' COMMENT '用户ID',
  `USER_CODE` varchar(50) DEFAULT NULL COMMENT '用户编码',
  `department_id` varchar(32) DEFAULT NULL,
  `USER_NAME` varchar(30) DEFAULT NULL COMMENT '用户名称',
  `PASSWORD` varchar(40) DEFAULT NULL COMMENT '用户密码',
  `FULL_NAME` varchar(30) DEFAULT NULL COMMENT '用户真实姓名',
  `sex` char(1) DEFAULT NULL COMMENT '性别',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号码',
  `telphoto` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `emailaddress` varchar(100) DEFAULT NULL COMMENT 'email地址',
  `USER_LEVEL` char(1) DEFAULT NULL COMMENT '用于标明该用户是\r\n            1：一级管理员，2：二级管理员，3：三级管理员，4：普通用户等\r\n            ',
  `status` char(1) DEFAULT NULL COMMENT '用户状态\r\n            用于标明该用户是否开通，或者关闭着\r\n            1：开通\r\n            2：关闭',
  `create_date` date DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(20) DEFAULT NULL COMMENT '创建人',
  `modifytor` varchar(20) DEFAULT NULL COMMENT '修改人',
  `modify_date` date DEFAULT NULL COMMENT '修改时间',
  `remarks` varchar(300) DEFAULT NULL COMMENT '备注',
  `is_Leave` int(11) DEFAULT NULL COMMENT '是否离职 1在岗 2离职',
  PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of pub_user
-- ----------------------------
INSERT INTO `pub_user` VALUES ('0010', '11', '001', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员', '1', '139', '', '', '1', '1', '2002-02-03', null, 'admin', '2013-05-25', 'test', '0');
INSERT INTO `pub_user` VALUES ('37750eaa072644a08a805a307176e990', null, '001002', '1', '1', '11', '1', 'xcvx', '', '', '1', '2', '2012-05-23', 'mortal', 'mortal', '2012-05-23', '', null);
INSERT INTO `pub_user` VALUES ('5bc57bb00f394c06a928ec11b4129928', null, '001002', '22', '7694f4a66316e53c8cdd9d9954bd611d', '22', '1', 'ds', '', '', '1', '2', '2012-05-23', 'mortal', 'mortal', '2012-05-24', '', null);
INSERT INTO `pub_user` VALUES ('ae477642527e46fc951cdf1fc4969b89', '33', '001', '888', 'b4b147bc522828731f1a016bfa72c073', '777', '1', '', '', '', '1', '2', '2012-10-16', 'mortal', 'mortal', '2012-10-16', '', null);
INSERT INTO `pub_user` VALUES ('b108650db31b493182f1ed3a361f9fc8', null, '001', 'test2', '098f6bcd4621d373cade4e832627b4f6', 'test', '1', '33', '', '', '1', '2', '2012-09-26', 'mortal', 'mortal', '2012-09-26', '', null);

-- ----------------------------
-- Table structure for pub_user_roles
-- ----------------------------
DROP TABLE IF EXISTS `pub_user_roles`;
CREATE TABLE `pub_user_roles` (
  `roles_id` varchar(32) DEFAULT NULL COMMENT '角色id',
  `user_id` varchar(32) DEFAULT NULL COMMENT '人员id',
  `type` varchar(6) DEFAULT NULL COMMENT '类型(person是人员 oirg 是组织)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与人员';

-- ----------------------------
-- Records of pub_user_roles
-- ----------------------------
INSERT INTO `pub_user_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '001002', 'org');
INSERT INTO `pub_user_roles` VALUES ('832ca1aed8c14dacacdbf1ce2fb5bc32', '002', 'person');
INSERT INTO `pub_user_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '', 'org');
INSERT INTO `pub_user_roles` VALUES ('ff7617a0e3604255bd35f152d4af7b35', '0010', 'person');

-- ----------------------------
-- Table structure for pub_xtheme
-- ----------------------------
DROP TABLE IF EXISTS `pub_xtheme`;
CREATE TABLE `pub_xtheme` (
  `user_id` varchar(32) NOT NULL COMMENT '用户id',
  `xtheme_name` varchar(50) DEFAULT NULL COMMENT '主题名称',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户系统主题';

-- ----------------------------
-- Records of pub_xtheme
-- ----------------------------
INSERT INTO `pub_xtheme` VALUES ('0010', 'xtheme-blue.css');

-- ----------------------------
-- Table structure for wft_mm_f_billsaudit
-- ----------------------------
DROP TABLE IF EXISTS `wft_mm_f_billsaudit`;
CREATE TABLE `wft_mm_f_billsaudit` (
  `AUDIT_ID` varchar(32) NOT NULL COMMENT '审核ID',
  `BILLS_ID` varchar(32) DEFAULT NULL COMMENT '单据ID',
  `AUDITOR_ID` varchar(32) DEFAULT NULL COMMENT '审核人ID',
  `AUDITOR` varchar(50) DEFAULT NULL COMMENT '审核人',
  `AUDIT_DATE` datetime DEFAULT NULL COMMENT '审核时间',
  `AUDIT_FLAG` varchar(1) DEFAULT NULL COMMENT '审核标志,表示该单据的审核流程位置\n            F：审核未关闭（可以继续审核，未接下来撤销做扩展（审核中））\n            T：审核关闭（不能继续审核）\n            默认是审核关闭',
  `REMARK` varchar(100) DEFAULT NULL COMMENT '审核意见',
  `AUDIT_ORDER` int(11) DEFAULT NULL COMMENT '默认值为0（第一次）\n            审核流程标志 （加1）\n            默认情况下，是按数字排序\n            添加方式：\n            取该单据ID中最大的这个字段的数据再加1\n            \n            ',
  `BILLS_TYPE` int(11) DEFAULT NULL COMMENT '单据类型\n            1:入库单\n            2：入库冲红\n            3：退库单\n            4：出库单',
  `bills_Status` int(11) DEFAULT NULL COMMENT '单据状态',
  PRIMARY KEY (`AUDIT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='业务单据审核表\n';

-- ----------------------------
-- Records of wft_mm_f_billsaudit
-- ----------------------------
INSERT INTO `wft_mm_f_billsaudit` VALUES ('0385197487594b43a3ce4f99257c1611', '643e002ea31a408cbf0ccafec8872041', '0010', 'mortal', '2012-10-12 22:44:54', 'T', 'sdfsd', '4', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('0681046c6d724e3593022309c2c4f2b0', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-09-19 22:59:05', 'T', 'fff', '10', '1', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('0c232b528cf642a5876e4d4944d60091', '7f5952545cd1478db37488f57104c17b', '0010', '超级管理员', '2013-02-26 08:52:35', 'T', '333', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('0ca5834edcc34913bd31a001468053c3', 'bf48aee7cd364e12b88dcbf75b88390f', '0010', '超级管理员', '2013-02-16 18:23:21', 'T', 'dsfs', '1', '7', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('0db5ad7dd50245a09feb81d844f0c893', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:31:10', 'T', 'ds', '4', '8', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('11b1429d39414b5e8173e2615257fda5', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:41:11', 'T', 'df', '7', '1', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('14927e9135cb488da6d72ca67bd721a6', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-10-12 22:30:54', 'T', 'fdgdfg', '5', '6', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('150fa96a22b448cda62fa12016f105dd', '632a819353834e768daccc427b4e4d54', '0010', '超级管理员', '2013-02-21 20:49:59', 'T', '222', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('161d0eafd0484fefa967dd88f72da2c6', '06026bad24a44caaa24acd3bd09502be', '0010', '超级管理员', '2012-12-24 20:42:36', 'T', 'd', '2', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('19a49bb27bca4f8d9ad83a53d3380801', '2', '0010', '超级管理员', '2013-03-16 22:09:59', 'T', '233', '1', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('20943017a4744ba09faafe7e14e67e3a', '1', '0010', '超级管理员', '2013-04-10 22:29:40', 'T', 'sdfdsf', '1', '9', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('260b2d0aa14841aba8ec6b4701b55eca', 'f2f04c156a98448ea8a59380c7f2d8e0', '0010', 'mortal', '2012-10-12 22:44:35', 'T', 'dsfs', '5', '2', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('27deeef57bf4404ab821c6ff7e4f3601', '06026bad24a44caaa24acd3bd09502be', '0010', '超级管理员', '2012-12-24 20:35:58', 'T', 'dd', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('28f6b7ba7b1d40df87070ac7e5791176', '1', '0010', '超级管理员', '2013-04-10 22:39:27', 'T', 'dd', '1', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('296698c067044562b1687b5d72d594a9', 'bf48aee7cd364e12b88dcbf75b88390f', '0010', '超级管理员', '2013-02-16 18:24:58', 'T', 'e', '2', '7', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('2b529e0d114a4a0583a2e6afe130bd85', '643e002ea31a408cbf0ccafec8872041', '0010', 'mortal', '2012-10-12 22:44:45', 'T', 'sdf', '3', '4', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('2ba376528cba4699b102c23fbe748f0d', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-05-25 23:01:01', 'T', 'sdf', '6', '9', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('2ec490482428404abc99959d135bf881', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-22 01:03:20', 'T', 'sdfsf', '13', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('35ad40c7d49840408d1ac3d7e18b22d5', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-21 21:27:18', 'T', 'd', '12', '8', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('39f8ffdb5bff49fea59cde84153cdd20', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:13:31', 'T', 'd', '2', '8', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('3cc30f1f47cd44359ee3e3141fe06452', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-05-25 22:54:26', 'T', 'sdfs', '3', '9', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('3f6c883edc904d55b308d5e5a900b0f7', '1', '0010', '超级管理员', '2013-04-11 22:18:57', 'T', 'd', '2', '9', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('3f7af35a79c24ce6bd8bc9d7d792b65b', '8247d6355a9a4b3d8fe53f6cace5791e', '0010', '超级管理员', '2013-05-07 23:05:22', 'T', 'sdff', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('403293e9d254484f9f5e66ffa09ebb66', '35020c7472f74f6785157f7963b4e784', '0010', '超级管理员', '2013-05-06 00:20:32', 'T', 'dsf', '2', '4', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('4362d0a633a7454abc7fd5ba9df8ca10', '35020c7472f74f6785157f7963b4e784', '0010', '超级管理员', '2013-05-05 21:41:36', 'T', 'ff', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('4409c8787a354852bf19fe19c782fdae', '9c958d14afc145b789432f463886b0a0', '0010', '超级管理员', '2013-05-25 23:15:29', 'T', 'ds', '2', '10', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('49ef33c450a441f6a615a606dac93834', '0d12d685496d4ab0bcf4005737283416', '0010', '超级管理员', '2013-05-06 00:21:13', 'T', 'dd', '2', '4', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('4b6fea504f0d4e518e40a6b9f3c4aeac', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 11:58:29', 'T', 'ewe', '1', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('4f64238346054f1fa5cc17f6dd63e214', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-09-17 21:15:55', 'T', 'ddd', '8', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5024b657d10a434d89d0d00204a1ac2b', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-04-11 22:31:18', 'T', 'fd', '2', '9', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('51cb917252e54aa6bdd59ea733eff9e1', 'f2f04c156a98448ea8a59380c7f2d8e0', '0010', 'mortal', '2012-09-23 07:02:58', 'T', '。。', '2', '2', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('532cf79cd3904e7bb3328b1018fca9dc', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:33:59', 'T', 'ds', '5', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('56ce7c4053a246f39cda10a95fcb8c32', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-10-12 22:30:44', 'T', 'dfgg', '4', '6', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5bd810933d2e4f1e97508298e17c8f61', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:27:32', 'T', '.', '4', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5dbeedb719044c13905696a1e050ab82', 'bf48aee7cd364e12b88dcbf75b88390f', '0010', '超级管理员', '2013-04-10 22:47:03', 'T', 'dd', '3', '7', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5eaedcfff52e4c8d9be3b6664d7b012b', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-21 21:24:00', 'T', 'sdfsf', '11', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5eceba93bcb84af190e49f9cec14648a', '80941e31450c40afa458b72645672541', '0010', '超级管理员', '2013-02-21 20:21:16', 'T', '33', '1', '2', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5ef39c5f35f14691a6113b99e33090c2', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-22 01:03:47', 'T', 'sdd', '14', '8', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('5fced9df2fe447b6820aa55a07538b0c', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-10-17 22:16:15', 'T', 'ddd', '5', '6', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('62d0198a3dcb4833887e8d9a9b842d57', 'a055f88fafe44770a655f763386dfccb', '0010', '超级管理员', '2013-02-21 20:16:41', 'T', 'dd', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('63af01e68c05412eac377a8b6996ca60', 'f889e912fd75412684ed11c125af5b94', '0010', '超级管理员', '2013-02-01 23:55:26', 'T', 'sdfsd', '4', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('650597a3ea624c73b13278d66c243ebd', '1fa0c8dd1915411cbcd42ac5af6b7b95', '0010', '超级管理员', '2013-06-13 20:46:21', 'T', 'ii', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('6899f356f1ca496a8b827b4062b219f6', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-05-25 22:55:56', 'T', 'ff', '4', '9', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('6b6ce9959b414c27b45f9af9d7387430', '632a819353834e768daccc427b4e4d54', '0010', '超级管理员', '2013-05-05 21:39:43', 'T', 'dfgfd', '5', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('6c05d0ac6e1d4b3793b05e19dfe3b9df', 'f2f04c156a98448ea8a59380c7f2d8e0', '0010', 'mortal', '2012-10-12 22:44:27', 'T', 'edd', '4', '2', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('6c16e087200c46a49d2fb91e3d4cd12e', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:39:43', 'T', 'dsf', '6', '8', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('6c7b7f406ac6463d92fe73371468e155', '879d23ac721241c798ba1f0dfb5ae270', '0010', '超级管理员', '2013-04-24 21:27:04', 'T', 'k', '1', '11', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('6cad771f065c4e22bf0e4bb1d37883d7', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-10-17 22:18:33', 'T', 'vv', '7', '6', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('7010e9d351b5469991e95c07bf282648', 'f889e912fd75412684ed11c125af5b94', '0010', '超级管理员', '2013-01-30 20:41:56', 'T', 'efds', '3', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('70781d8f45b24333b68e0972f52d45af', '1c1a20645a844ce4ba9a4a2d691410a5', '0010', '超级管理员', '2013-01-31 00:40:17', 'T', 'xcvxcv', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('72af860dd7e443bd99761ef3343c3ae8', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:45:04', 'T', 'ds', '9', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('74e198f299ee4b8195687a098ec8a464', '8048ac9a2904488e9bf13929f31a170c', '0010', 'mortal', '2012-09-17 21:50:26', 'T', 'fgfdg', '2', '5', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('7f3dde58b0cb4c549ddeef1dcc4f2aeb', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-10-17 22:14:10', 'T', 'dd', '4', '6', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('7fbe8f7622664c29bb0244bc39b67bce', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-10-17 22:17:50', 'T', 'dd', '6', '6', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('830b4e15ddbc42b180846f553531596a', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-09-18 21:15:08', 'T', ',', '1', '6', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('832fdf3ae9ba41709eb0cd3d5740497c', '1', '0010', '超级管理员', '2012-12-24 22:36:30', 'T', 'ddd', '2', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('84369159c01b4169bd4dface4962a7c5', '1', '0010', '超级管理员', '2012-12-24 22:34:03', 'T', 'ddd', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8557355b09444b51ad4b3f70472413f2', '2', '0010', '超级管理员', '2013-05-11 18:55:12', 'T', 'dd', '3', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8676a33aad944d41a7d97688b507fd69', '632a819353834e768daccc427b4e4d54', '0010', '超级管理员', '2013-03-20 21:19:56', 'T', 'dd', '4', '1', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8788c575e8f545b880d20393fb9549f2', '569ecb2766f042f7a2276551bbc1fb52', '0010', '超级管理员', '2013-05-05 01:13:27', 'T', 'ff', '1', '12', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8805b138848543c3b8d87773dcc41043', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-10-12 22:28:50', 'T', 'dfgdfg', '2', '5', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8c3c120a7ffe4407b54fa2b35b09fc17', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:35:45', 'T', 'sdvfsdf', '5', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8d9109b9e0a24bdf8779d0aec40dae12', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', '超级管理员', '2013-05-24 22:41:03', 'T', 'dd', '8', '6', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('8ea92baeb5a54111aba58a388d6dd9c5', 'a138503f568f428aacbe6ddd55818077', '0010', '超级管理员', '2013-02-26 21:01:05', 'T', '22', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('93f7814d0c484591a57cf79fcc9a5384', '7f5952545cd1478db37488f57104c17b', '0010', '超级管理员', '2013-03-21 21:34:14', 'T', 'dsfs', '3', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('97b9f0e03a934d4184b21da44ff4c580', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-09-18 22:36:09', 'T', 'fff', '2', '6', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('97f312d290a04f6fb03b0a9871e463fe', 'b05bb488fd9e47fb8c5868dd10d2f2b2', '0010', '超级管理员', '2013-02-21 20:17:15', 'T', '33', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('983750538cc24cf3aac42ce9c1798afb', '632a819353834e768daccc427b4e4d54', '0010', '超级管理员', '2013-02-21 21:38:18', 'T', 'dd', '2', '1', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('9931c990a1424e638f1fbf72e91b654b', '8048ac9a2904488e9bf13929f31a170c', '0010', 'mortal', '2012-09-18 22:42:38', 'T', 'gg', '3', '5', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('9b575e47330f47c08d10c1244248dc38', '815c6045766349569b3a29749f46ccc4', '0010', '超级管理员', '2013-02-21 20:56:10', 'T', 'dd', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('9dbf0e8723fb4d938579aaef11431424', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-10-12 22:27:16', 'T', 'dfgfd', '1', '5', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('9ea831990c124fed9df198234eac3b3e', '643e002ea31a408cbf0ccafec8872041', '0010', 'mortal', '2012-09-23 07:06:33', 'T', '，，', '2', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('9ecac97510074f6bbf384ec6ad454101', '934d2cdd008a4bdf921ac37438087a79', '0010', '超级管理员', '2013-02-20 20:20:39', 'T', 'dd', '16', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('a0c31db6fcb94a6e9901e7152a31cd16', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-10-12 22:34:34', 'T', 'fgdfg', '13', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('a3132d31774c44b4a5a9a1e1c99fc249', '11', '0010', '超级管理员', '2012-12-24 22:43:28', 'T', 'vv', '2', '1', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('a4f784fa4b114d919d5474bd8bfc47b9', 'c107a9dafc274068861eabadb1b04d09', '0010', '超级管理员', '2013-05-07 23:20:28', 'T', 'fdgdg', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('a947b04dfa3e4b769ccb69f32afa83c2', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-21 21:23:48', 'T', 'sdfsdf', '10', '8', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('aac71a3c015f42f099acbe01e7e4c62c', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-10-10 21:12:44', 'T', 'gg', '12', '1', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ab9adb09ee5f463eaf104efb559ee8f8', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-10-12 22:29:41', 'T', 'dfgdfg', '3', '6', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ac8c904ced184669aa07a1256950ecdb', 'b612e216acfc46c58f56aa2875c9f812', '0010', 'mortal', '2012-09-18 21:15:15', 'T', '888', '1', '6', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ad06dd84bcc94c49b900f50891404123', '1a2eb6a6c9dc4c828617faa4fccfd289', '0010', '超级管理员', '2013-05-11 18:53:51', 'T', 'd', '1', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ad092a35d8fa49a6b96c947d8d55c1ba', '10', '0010', '超级管理员', '2012-12-24 22:37:36', 'T', 'ff', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('af1559eb317b42f7ab6dd40122bc0254', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:39:54', 'T', '.', '7', '8', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b0a6de950a4d44c1bf6e2901558baa07', '643e002ea31a408cbf0ccafec8872041', '0010', 'mortal', '2012-08-14 21:53:22', 'T', 'dghf', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b3c3e12d9cfc47fcbd1ea45c1d274b67', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-04-11 22:30:49', 'T', 'dfg', '1', '9', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b3cbc89be9a344c1bf6ee3cbfca54393', '79e4483ce6d54ec7b6f1ebf6b095a943', '0010', '超级管理员', '2013-02-21 20:50:52', 'T', '333', '1', '2', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b5daf7303a5a4fd09748639b4ac11a84', '8048ac9a2904488e9bf13929f31a170c', '0010', 'mortal', '2012-09-17 21:39:20', 'T', '，，', '1', '5', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b652935f670a4fe7a53a8514a6364236', '0d12d685496d4ab0bcf4005737283416', '0010', '超级管理员', '2013-04-10 22:37:45', 'T', 'ddd', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b6ac7a5ce8544600ade78ff222510be4', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:26:03', 'T', 'fdgdfgdfg', '2', '1', '2');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('b9c8595e6ca54f29a2498223283e5429', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-09-22 19:50:03', 'T', '审核通过', '11', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('bc1153a0d1ab4ca9b79163502ef17aa4', '11', '0010', '超级管理员', '2012-12-24 22:41:24', 'T', 'ddd', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('bf611f310dbc4643a7802e1f9dea45d4', '35020c7472f74f6785157f7963b4e784', '0010', '超级管理员', '2013-05-06 00:20:56', 'T', 'dd', '3', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c00fd33711594f5fa070441021f849b1', '422cb24d7f5540f49d4e564b2562c9ed', '0010', '超级管理员', '2013-02-21 20:56:57', 'T', '33', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c09b426293e9498da2ff86c3c119e62d', 'f889e912fd75412684ed11c125af5b94', '0010', '超级管理员', '2013-01-30 20:40:42', 'T', 'fdg', '2', '4', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c119676cc4dc49d59db9baf14bb2d67f', '632a819353834e768daccc427b4e4d54', '0010', '超级管理员', '2013-02-22 08:51:53', 'T', 'fff', '3', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c3029d73b85c4ebcb8fa8241e4182407', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:27:19', 'T', ',,,,', '3', '1', '2');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c39cf3f8c36e4a3dbc769d2627bbc80f', '2', '0010', '超级管理员', '2013-03-16 22:12:21', 'T', 'sdfs', '2', '8', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c39d8a9cf81c4eb6a24cd19dc2ba5ec2', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:29:51', 'T', 'sdf', '3', '8', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c70e20fa9a914828afa96103c207d22b', '32a95e0397b847a4a350aaed63276c80', '0010', '超级管理员', '2013-02-20 20:24:24', 'T', 'dssd', '1', '2', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c7be4db8712a4a0590c21b327dff5874', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-05-25 22:57:23', 'T', 'mm', '5', '9', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('c961d0a9861e47fd954378d4461f6000', '639a63296a384def801a4fdcfed46380', '0010', '超级管理员', '2013-03-17 12:44:16', 'T', 'sdf', '8', '8', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ca0be9b865c446b98865d8fccf72c368', 'f889e912fd75412684ed11c125af5b94', '0010', '超级管理员', '2013-01-28 22:49:37', 'T', 'dfdsf', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ce213e270a914bdfba09aee77cc6ea89', '7ca57efc91ee424faa70a741ddfb9ac0', '0010', '超级管理员', '2013-04-24 23:59:47', 'T', '323', '1', '11', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('cfda57410ade4771a39a3074f593cb9a', '11', '0010', '超级管理员', '2012-12-24 22:43:45', 'T', 'fff', '3', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d026fd8b16724a43a70270d27f9c60ed', 'f2f04c156a98448ea8a59380c7f2d8e0', '0010', 'mortal', '2012-08-14 21:53:32', 'T', 'dfdg', '1', '2', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d5c0fb2dd7de4b46ab80a5d2b2ca87ec', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-10-12 22:38:34', 'T', 'hgjgj', '14', '1', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d626c41d0c34446c893ce04e209dd395', '643e002ea31a408cbf0ccafec8872041', '0010', 'mortal', '2012-10-12 22:46:44', 'T', 'dff', '6', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d6568128c587486aba1e6f723700a324', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-10-12 22:38:46', 'T', 'fdg', '15', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d72d84f4db894fb18f2f87db88389683', '9c958d14afc145b789432f463886b0a0', '0010', '超级管理员', '2013-04-14 20:50:52', 'T', 'sdf', '1', '10', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d8cc1b2dfa364746bb91f6dd285f0ea8', '7736ff85ea564900bf070cca8ac93b99', '0010', '超级管理员', '2013-05-07 22:49:07', 'T', 'sdfsd', '2', '1', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('d9728ae0b55a4e8190a497bbb47e8158', '7736ff85ea564900bf070cca8ac93b99', '0010', '超级管理员', '2013-05-07 22:30:51', 'T', 'sdfsdf', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('dc0a34b57ffd472abfefc7395b48ce29', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-09-19 22:56:21', 'T', 'fff', '9', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('dd678e5037ca4e8183507faba756c64d', '7736ff85ea564900bf070cca8ac93b99', '0010', '超级管理员', '2013-05-07 22:52:25', 'T', 'fdf', '3', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('df9e995bd6244b268974c9b2b0036fc7', 'dfa6a1f658f14e2385534a1517bea290', '0010', '超级管理员', '2013-05-05 23:24:12', 'T', '23', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('dfb4d8bae7a247269e39af494f419fd0', 'f2f04c156a98448ea8a59380c7f2d8e0', '0010', 'mortal', '2012-09-23 07:07:11', 'T', '，。。', '3', '2', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('e05efe923f6d49098309269fb9691165', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-10-10 21:12:25', 'T', 'hh', '2', '6', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('e1795f9f521341988ac32938ab3f7ea3', 'ef5cc3bfdd1a4542984f9e6e0b22e690', '0010', '超级管理员', '2013-02-21 20:27:00', 'T', '33', '1', '4', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('e3e79449da2b4cc690836acf8bd56c63', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:40:34', 'T', 'dddd', '6', '1', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('e7a0b4b196ea45e8aaafb149e0a113d5', '906f640c0f8e4f4fb9075513743ac3d0', '0010', '超级管理员', '2013-04-14 21:33:22', 'T', 'sdf', '1', '10', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('e7daabf30e634f3faa1802e4a24ac8d4', '0e6cac90fc34462da71885816caed0d4', '0010', '超级管理员', '2013-05-25 23:16:55', 'T', 'edsf', '7', '9', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('e8e99437b1c44a0fbe2a422abc273989', '643e002ea31a408cbf0ccafec8872041', '0010', 'mortal', '2012-10-12 22:46:34', 'T', 'dfg', '5', '4', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ec484cfb789f4cf69dff2af1622fa40b', '7f5952545cd1478db37488f57104c17b', '0010', '超级管理员', '2013-03-20 21:18:36', 'T', 'd', '2', '1', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ec4f5a5c3e134edaa89a51af0812159c', '422cb24d7f5540f49d4e564b2562c9ed', '0010', '超级管理员', '2013-02-21 21:41:19', 'T', 'dd', '2', '4', '4');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('ee6c36dce04b45e5b9c02e46b99ac00e', '569ecb2766f042f7a2276551bbc1fb52', '0010', '超级管理员', '2013-05-14 23:06:52', 'T', 'sdf', '3', '12', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('f2afb544a8724851b4dae1332ac0bfe6', 'c9fe5b3322104fa488dc1bec82b0dfde', '0010', 'mortal', '2012-10-17 21:39:41', 'T', 'xff', '3', '6', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('f3c9adde1fa543eabb3cb38943d82dea', '569ecb2766f042f7a2276551bbc1fb52', '0010', '超级管理员', '2013-05-05 01:15:29', 'T', 'dsf', '2', '12', '1');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('f7774c46eb7b4625974bb132e5013b0f', '77f1f151391744459b1d82eef7eb942e', '0010', '超级管理员', '2013-03-21 21:40:52', 'T', 'dsd', '1', '1', '3');
INSERT INTO `wft_mm_f_billsaudit` VALUES ('f7e8662959824a3da9edd440b42b903c', '934d2cdd008a4bdf921ac37438087a79', '0010', 'mortal', '2012-08-14 21:20:33', 'T', 'sdfsfdsf', '1', '1', '2');
