/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : bid

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 13/07/2020 17:46:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for op_bid
-- ----------------------------
DROP TABLE IF EXISTS `op_bid`;
CREATE TABLE `op_bid`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
  `openDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开标日期',
  `hasTech` tinyint(1) NULL DEFAULT NULL COMMENT '是否含有技术标',
  `department` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投标部门',
  `auditor` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核人',
  `refundInfo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保证金退回信息',
  `inCharge` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `bidStatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL,
  `lastUpdateUser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `lastUpdateTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `bidCharge` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投标负责人',
  `scale` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目规模',
  `openBy` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开标人',
  `winBid` tinyint(1) NULL DEFAULT NULL COMMENT '是否中标',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '投标项目表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_bid
-- ----------------------------
INSERT INTO `op_bid` VALUES (30, '你好', '2020-07-13 01:02', 0, '', NULL, NULL, '阿斯达四大', 'DEPOSITING', 1, 'admin', '2020-07-13 01:02:35', '阿斯达四大', '哎哎哎', '啊啊啊是', NULL);

-- ----------------------------
-- Table structure for op_bid_flow
-- ----------------------------
DROP TABLE IF EXISTS `op_bid_flow`;
CREATE TABLE `op_bid_flow`  (
  `bidId` int(11) NULL DEFAULT NULL,
  `flowId` int(11) NULL DEFAULT NULL,
  `lastUpdateTime` datetime(0) NULL DEFAULT NULL,
  `lastUpdateUser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `approved` tinyint(1) NULL DEFAULT NULL
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_bid_flow
-- ----------------------------
INSERT INTO `op_bid_flow` VALUES (30, 0, '2020-07-13 01:02:35', 'admin', 0);
INSERT INTO `op_bid_flow` VALUES (30, 1, '2020-07-13 01:02:35', 'admin', 0);
INSERT INTO `op_bid_flow` VALUES (30, 2, '2020-07-13 01:02:35', 'admin', 0);
INSERT INTO `op_bid_flow` VALUES (30, 3, '2020-07-13 01:02:35', 'admin', 0);
INSERT INTO `op_bid_flow` VALUES (30, 4, '2020-07-13 01:02:35', 'admin', 0);

-- ----------------------------
-- Table structure for op_flow
-- ----------------------------
DROP TABLE IF EXISTS `op_flow`;
CREATE TABLE `op_flow`  (
  `bidId` int(11) NULL DEFAULT NULL,
  `flowId` int(11) NULL DEFAULT NULL,
  `lastUpdateTime` datetime(0) NULL DEFAULT NULL,
  `lastUpdateUser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `approved` tinyint(1) NULL DEFAULT NULL
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_flow
-- ----------------------------
INSERT INTO `op_flow` VALUES (19, 0, '2020-06-14 13:58:31', 'admin', 0);
INSERT INTO `op_flow` VALUES (19, 1, '2020-06-14 13:58:18', 'admin', 0);
INSERT INTO `op_flow` VALUES (19, 2, '2020-06-14 13:58:18', 'admin', 0);
INSERT INTO `op_flow` VALUES (19, 3, '2020-06-14 13:58:18', 'admin', 0);
INSERT INTO `op_flow` VALUES (20, 0, '2020-06-18 18:08:26', 'admin', 0);
INSERT INTO `op_flow` VALUES (20, 1, '2020-06-18 18:08:26', 'admin', 0);
INSERT INTO `op_flow` VALUES (20, 2, '2020-06-18 18:08:26', 'admin', 0);
INSERT INTO `op_flow` VALUES (20, 3, '2020-06-18 18:08:26', 'admin', 0);
INSERT INTO `op_flow` VALUES (21, 0, '2020-06-18 18:11:59', 'admin', 0);
INSERT INTO `op_flow` VALUES (21, 1, '2020-06-18 18:11:59', 'admin', 0);
INSERT INTO `op_flow` VALUES (21, 2, '2020-06-18 18:11:59', 'admin', 0);
INSERT INTO `op_flow` VALUES (21, 3, '2020-06-18 18:11:59', 'admin', 0);
INSERT INTO `op_flow` VALUES (22, 0, '2020-06-19 01:17:41', 'admin', 0);
INSERT INTO `op_flow` VALUES (22, 1, '2020-06-19 01:17:41', 'admin', 0);
INSERT INTO `op_flow` VALUES (22, 2, '2020-06-19 01:17:41', 'admin', 0);
INSERT INTO `op_flow` VALUES (22, 3, '2020-06-19 01:17:41', 'admin', 0);
INSERT INTO `op_flow` VALUES (23, 0, '2020-06-22 23:53:04', 'admin', 0);
INSERT INTO `op_flow` VALUES (23, 1, '2020-06-22 23:53:04', 'admin', 0);
INSERT INTO `op_flow` VALUES (23, 2, '2020-06-22 23:53:04', 'admin', 0);
INSERT INTO `op_flow` VALUES (23, 3, '2020-06-22 23:53:04', 'admin', 0);
INSERT INTO `op_flow` VALUES (24, 0, '2020-06-23 00:09:06', 'admin', 0);
INSERT INTO `op_flow` VALUES (24, 1, '2020-06-23 00:09:06', 'admin', 0);
INSERT INTO `op_flow` VALUES (24, 2, '2020-06-23 00:09:06', 'admin', 0);
INSERT INTO `op_flow` VALUES (24, 3, '2020-06-23 00:09:06', 'admin', 0);
INSERT INTO `op_flow` VALUES (25, 0, '2020-06-23 00:37:15', 'admin', 0);
INSERT INTO `op_flow` VALUES (25, 1, '2020-06-23 00:37:15', 'admin', 0);
INSERT INTO `op_flow` VALUES (25, 2, '2020-06-23 00:37:15', 'admin', 0);
INSERT INTO `op_flow` VALUES (25, 3, '2020-06-23 00:37:15', 'admin', 0);
INSERT INTO `op_flow` VALUES (26, 0, '2020-06-23 18:13:36', 'admin', 0);
INSERT INTO `op_flow` VALUES (26, 1, '2020-06-23 18:13:36', 'admin', 0);
INSERT INTO `op_flow` VALUES (26, 2, '2020-06-23 18:13:36', 'admin', 0);
INSERT INTO `op_flow` VALUES (26, 3, '2020-06-24 08:54:31', 'admin', 0);
INSERT INTO `op_flow` VALUES (27, 0, '2020-07-06 14:34:12', 'admin', 0);
INSERT INTO `op_flow` VALUES (27, 1, '2020-07-06 14:34:12', 'admin', 0);
INSERT INTO `op_flow` VALUES (27, 2, '2020-07-06 14:34:12', 'admin', 0);
INSERT INTO `op_flow` VALUES (27, 3, '2020-07-06 14:34:12', 'admin', 0);
INSERT INTO `op_flow` VALUES (27, 4, '2020-07-06 14:34:12', 'admin', 0);

-- ----------------------------
-- Table structure for op_group
-- ----------------------------
DROP TABLE IF EXISTS `op_group`;
CREATE TABLE `op_group`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `operation` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_group
-- ----------------------------
INSERT INTO `op_group` VALUES (1, '管理员', '101,102,103,104,105,106,107,108,109,110,201,202,203,204,205,206,207');
INSERT INTO `op_group` VALUES (2, '技术人员', '103,104,105,106,107,108');
INSERT INTO `op_group` VALUES (3, '成本人员', '101,102,107,108,109,110');

-- ----------------------------
-- Table structure for op_operation
-- ----------------------------
DROP TABLE IF EXISTS `op_operation`;
CREATE TABLE `op_operation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NULL DEFAULT NULL,
  `typeName` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `subtype` int(11) NULL DEFAULT NULL,
  `subtypeName` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `display` int(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 208 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_operation
-- ----------------------------
INSERT INTO `op_operation` VALUES (101, 100, '新建招标流程', 101, '新建招标流程', 1);
INSERT INTO `op_operation` VALUES (102, 100, '新建结算流程', 102, '新建结算流程', 1);
INSERT INTO `op_operation` VALUES (103, 100, '上传招标附件', 103, '上传招标附件', 1);
INSERT INTO `op_operation` VALUES (104, 100, '下载招标附件', 104, '下载招标附件', 1);
INSERT INTO `op_operation` VALUES (105, 100, '上传结算附件', 105, '上传结算附件', 1);
INSERT INTO `op_operation` VALUES (106, 100, '下载结算附件', 106, '下载结算附件', 1);
INSERT INTO `op_operation` VALUES (107, 100, '查看招标信息', 107, '查看招标信息', 1);
INSERT INTO `op_operation` VALUES (108, 100, '查看结算信息', 108, '查看结算信息', 1);
INSERT INTO `op_operation` VALUES (109, 100, '编辑招标信息', 109, '编辑招标信息', 1);
INSERT INTO `op_operation` VALUES (110, 100, '编辑结算信息', 110, '编辑结算信息', 1);
INSERT INTO `op_operation` VALUES (201, 200, '获取权限组', 201, '获取权限组', 1);
INSERT INTO `op_operation` VALUES (202, 200, '获取用户', 202, '获取用户', 1);
INSERT INTO `op_operation` VALUES (203, 200, '设置权限', 203, '设置权限', 1);
INSERT INTO `op_operation` VALUES (204, 200, '添加权限组', 204, '添加权限组', 1);
INSERT INTO `op_operation` VALUES (205, 200, '添加用户', 205, '添加用户', 1);
INSERT INTO `op_operation` VALUES (206, 200, '修改用户密码', 206, '修改用户密码', 1);
INSERT INTO `op_operation` VALUES (207, 200, '删除用户', 207, '删除用户', 1);

-- ----------------------------
-- Table structure for op_passport
-- ----------------------------
DROP TABLE IF EXISTS `op_passport`;
CREATE TABLE `op_passport`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `pwd` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `groupId` int(11) NULL DEFAULT NULL,
  `admin` tinyint(1) NULL DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `banned` tinyint(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_passport
-- ----------------------------
INSERT INTO `op_passport` VALUES (1, 'admin', 'qweqwe123', 1, 1, 'debug', 0);
INSERT INTO `op_passport` VALUES (2, 'yixiaoan', 'qweqwe123', 2, 1, NULL, NULL);
INSERT INTO `op_passport` VALUES (3, 'ckh', '123456', 2, 1, NULL, NULL);
INSERT INTO `op_passport` VALUES (5, 'test01', 'qweqwe123', 3, 1, NULL, NULL);

-- ----------------------------
-- Table structure for op_settle
-- ----------------------------
DROP TABLE IF EXISTS `op_settle`;
CREATE TABLE `op_settle`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `inCharge` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `scale` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `valuation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `signDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `enable` int(11) NULL DEFAULT 1,
  `lastUpdateUser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `lastUpdateTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `settleMan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `techMan` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `buildingStart` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `buildingEnd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `reportDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `hasFirstReport` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'false',
  `hasDetailReport` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'false',
  `hasPicAudit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'false',
  `outsideReportEqual` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'true',
  `printCost` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `firstArriveMoney` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `firstArriveMoneyDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `secondArriveMoney` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `secondArriveMoneyDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `thirdArriveMoney` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `thirdArriveMoneyDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `finalDeposit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `firstLabor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `firstLaborDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `secondLabor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `secondLaborDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `thirdLaborDate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `thirdLabor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_settle
-- ----------------------------
INSERT INTO `op_settle` VALUES (10, '结算11', NULL, '111', '22222元', '2020-07-15 00:00', 1, NULL, NULL, '科比11', '阿斯达四大11', '2020-07-07', '2020-07-09', '2020-07-18', 'false', 'false', 'false', 'true', '111', '11', '2020-07-01', '22', '2020-07-03', '33', '2020-07-15', '111', '55', '2020-07-16', '66', '2020-07-17', '2020-07-18', '77');

-- ----------------------------
-- Table structure for op_settle_flow
-- ----------------------------
DROP TABLE IF EXISTS `op_settle_flow`;
CREATE TABLE `op_settle_flow`  (
  `settleId` int(11) NULL DEFAULT NULL,
  `flowId` int(11) NULL DEFAULT NULL,
  `lastUpdateTime` datetime(0) NULL DEFAULT NULL,
  `lastUpdateUser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `approved` tinyint(1) NULL DEFAULT NULL
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of op_settle_flow
-- ----------------------------
INSERT INTO `op_settle_flow` VALUES (10, 0, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 1, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 2, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 3, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 4, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 5, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 6, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 7, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 8, '2020-07-12 01:58:10', 'admin', 0);
INSERT INTO `op_settle_flow` VALUES (10, 9, '2020-07-12 01:58:10', 'admin', 0);

SET FOREIGN_KEY_CHECKS = 1;