From 7cd7f9b123468c4ea272160d728fa2ba6941cdcc Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期一, 27 二月 2023 16:14:10 +0800
Subject: [PATCH] 更新数据库

---
 super_save_driving.sql |  133 ++++++++++++++++++++++++-------------------
 1 files changed, 74 insertions(+), 59 deletions(-)

diff --git a/super_save_driving.sql b/super_save_driving.sql
index cf08dda..0c3e295 100644
--- a/super_save_driving.sql
+++ b/super_save_driving.sql
@@ -11,7 +11,7 @@
  Target Server Version : 50637
  File Encoding         : 65001
 
- Date: 25/02/2023 16:15:06
+ Date: 26/02/2023 22:18:35
 */
 
 SET NAMES utf8mb4;
@@ -74,7 +74,7 @@
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `money` decimal(20, 2) NULL DEFAULT NULL COMMENT '报销金额',
   `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '描述',
-  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
+  `createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
   `state` int(11) NULL DEFAULT NULL COMMENT '状态: 1.待提交  2:待审核   3.审核通过 4:驳回',
   `userid` int(11) NULL DEFAULT NULL COMMENT '用户id',
   `processId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程定义id',
@@ -93,7 +93,7 @@
   `id` int(65) NOT NULL AUTO_INCREMENT COMMENT '主键',
   `logname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',
   `userid` int(65) NULL DEFAULT NULL COMMENT '管理员id',
-  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
+  `createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
   `succeed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否执行成功',
   `message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '具体消息',
   `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip',
@@ -682,7 +682,7 @@
   `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
   `type` int(11) NULL DEFAULT NULL COMMENT '类型',
   `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
-  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
+  `createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
   `creater` int(11) NULL DEFAULT NULL COMMENT '创建人',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知表' ROW_FORMAT = COMPACT;
@@ -704,7 +704,7 @@
   `userid` int(65) NULL DEFAULT NULL COMMENT '用户id',
   `classname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类名称',
   `method` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '方法名称',
-  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
+  `createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
   `succeed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否成功',
   `message` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',
   PRIMARY KEY (`id`) USING BTREE
@@ -985,16 +985,16 @@
   `password` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
   `salt` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5密码盐',
   `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名字',
-  `birthday` datetime NULL DEFAULT NULL COMMENT '生日',
+  `birthday` datetime(0) NULL DEFAULT NULL COMMENT '生日',
   `sex` int(11) NULL DEFAULT NULL COMMENT '性别（1：男 2：女）',
   `email` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮件',
   `phone` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
   `roleid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色id',
   `deptid` int(11) NULL DEFAULT NULL COMMENT '部门id',
   `status` int(11) NULL DEFAULT NULL COMMENT '状态(1：启用  2：冻结  3：删除）',
-  `createtime` datetime NULL DEFAULT NULL COMMENT '创建时间',
+  `createtime` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
   `version` int(11) NULL DEFAULT NULL COMMENT '保留字段',
-  `pass_word_update` datetime NULL DEFAULT NULL COMMENT '密码修改时间',
+  `pass_word_update` datetime(0) NULL DEFAULT NULL COMMENT '密码修改时间',
   `role_type` int(1) NULL DEFAULT NULL COMMENT '角色类型 1=平台 2=分公司 3=加盟商',
   `object_id` int(11) NULL DEFAULT NULL COMMENT '公司id',
   PRIMARY KEY (`id`) USING BTREE
@@ -1017,9 +1017,9 @@
   `oldData` double(10, 2) NULL DEFAULT NULL COMMENT '历史数据',
   `newData` double(10, 2) NULL DEFAULT NULL COMMENT '新数据',
   `explain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '变动说明',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '变动时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '变动时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '账户变动明细' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '账户变动明细' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_account_change_detail
@@ -1039,7 +1039,7 @@
   `cityCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '代理区域市编号',
   `cityName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '代理区域市名称',
   `status` int(1) NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
   `bankDeposit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
   `bankAccount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账号',
   PRIMARY KEY (`id`) USING BTREE
@@ -1072,7 +1072,7 @@
   `accountBalance` double(11, 2) NULL DEFAULT NULL COMMENT '账户余额',
   `userTagId` int(11) NULL DEFAULT NULL COMMENT '用户标签id',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   `is_exception` int(1) NULL DEFAULT 1 COMMENT '是否异常 1正常 2异常',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '启用/冻结理由',
   `inviterType` int(1) NULL DEFAULT NULL COMMENT '邀约人类型（1=用户，2=司机）',
@@ -1116,7 +1116,7 @@
   `districtCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '代理区域区编号',
   `districtName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '代理区域区名称',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '分公司' ROW_FORMAT = COMPACT;
 
@@ -1136,9 +1136,9 @@
   `userId` int(11) NULL DEFAULT NULL COMMENT '用户id',
   `cause` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '转单原因',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单取消记录' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单取消记录' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_cancel_order
@@ -1159,9 +1159,9 @@
   `html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '富文本',
   `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   `createUserId` int(11) NULL DEFAULT NULL COMMENT '添加人员id',
-  `updateTime` datetime NULL DEFAULT NULL COMMENT '更新时间',
+  `updateTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
   `updateUserId` int(11) NULL DEFAULT NULL COMMENT '更新人员id',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '广告' ROW_FORMAT = COMPACT;
@@ -1198,7 +1198,7 @@
   `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '注释',
   `state` int(1) NULL DEFAULT NULL COMMENT '处理状态（1=待处理，2=已处理）',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '投诉' ROW_FORMAT = COMPACT;
 
@@ -1215,7 +1215,7 @@
   `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
   `agent_id` int(11) NULL DEFAULT NULL COMMENT '代理商id',
   `branch_office_id` int(11) NULL DEFAULT NULL COMMENT '分公司id',
-  `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
   `coupon_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '优惠券名称',
   `coupon_type` int(1) NULL DEFAULT NULL COMMENT '优惠券类型 1活动券 2新人券',
   `coupon_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '优惠券码',
@@ -1266,12 +1266,12 @@
   `approvalStatus` int(1) NULL DEFAULT 1 COMMENT '审核状态（1=待审核，2=已同意，3=已拒绝）',
   `approvalNotes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '审核注释',
   `approvalUserId` int(11) NULL DEFAULT NULL COMMENT '审核用户id',
-  `approvalTime` datetime NULL DEFAULT NULL COMMENT '审核时间',
+  `approvalTime` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
   `serverStatus` int(1) NULL DEFAULT NULL COMMENT '服务状态（1=空闲，2=服务中）',
   `integral` int(11) NULL DEFAULT 0 COMMENT '剩余积分',
   `score` double(11, 1) NULL DEFAULT NULL COMMENT '评分',
   `status` int(1) NULL DEFAULT 1 COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
   `backgroundBalance` decimal(10, 2) NULL DEFAULT NULL COMMENT '后台充值余额',
   `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '启用冻结理由',
   `isException` int(1) NULL DEFAULT 1 COMMENT '是否异常 1正常 2异常',
@@ -1281,7 +1281,7 @@
   `cityName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '加盟区域市名称',
   `areaCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '加盟区域区编号',
   `areaName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '加盟区域区名称',
-  `firstCertificateTime` datetime NULL DEFAULT NULL COMMENT '驾驶证初次领证时间',
+  `firstCertificateTime` datetime(0) NULL DEFAULT NULL COMMENT '驾驶证初次领证时间',
   `commission` decimal(10, 2) NULL DEFAULT NULL COMMENT '佣金',
   `wxCollectionCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信收款码',
   `zfbCollectionCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝收款码',
@@ -1307,8 +1307,8 @@
 CREATE TABLE `t_driver_work`  (
   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
   `driverId` int(11) NULL DEFAULT NULL COMMENT '司机id',
-  `workTime` datetime NULL DEFAULT NULL COMMENT '上班时间',
-  `offWorkTime` datetime NULL DEFAULT NULL COMMENT '下班时间',
+  `workTime` datetime(0) NULL DEFAULT NULL COMMENT '上班时间',
+  `offWorkTime` datetime(0) NULL DEFAULT NULL COMMENT '下班时间',
   `onlineTime` bigint(20) NULL DEFAULT NULL COMMENT '在线时长（秒）',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=上班，2=下班）',
   PRIMARY KEY (`id`) USING BTREE
@@ -1329,7 +1329,7 @@
   `score` int(1) NULL DEFAULT NULL COMMENT '评分',
   `evaluate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '评价内容',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单评价' ROW_FORMAT = COMPACT;
 
@@ -1343,9 +1343,9 @@
 DROP TABLE IF EXISTS `t_html`;
 CREATE TABLE `t_html`  (
   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `type` int(1) NULL DEFAULT NULL COMMENT '类型（1=）',
+  `type` int(1) NULL DEFAULT NULL COMMENT '类型（1=用户协议，2=隐私政策，3=法律条款，4=代驾服务协议，5=个人信息处理规则，6=积分说明，7=佣金规则说明，8=行程录音说明，9=预估价格说明，10=加盟基本要求，11=加盟流程，12=起步价说明，13=注销协议，14=关于我们，15=司机消单说明）',
   `html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'H5内容',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'H5富文本' ROW_FORMAT = COMPACT;
 
@@ -1361,7 +1361,7 @@
   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
   `type` int(1) NULL DEFAULT NULL COMMENT '数据类型（1=启动页）',
   `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片地址',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统图片' ROW_FORMAT = COMPACT;
 
@@ -1383,18 +1383,18 @@
   `source` int(1) NULL DEFAULT NULL COMMENT '订单来源（1=小程序，2=APP）',
   `agentId` int(11) NULL DEFAULT NULL COMMENT '代理商id',
   `branchOfficeId` int(11) NULL DEFAULT NULL COMMENT '分公司id',
-  `orderTakingTime` datetime NULL DEFAULT NULL COMMENT '接单时间',
-  `goToAppointmentPointTime` datetime NULL DEFAULT NULL COMMENT '前往预约点时间',
-  `arrivalTimeAtTheAppointmentPoint` datetime NULL DEFAULT NULL COMMENT '到达预约点时间',
-  `startTime` datetime NULL DEFAULT NULL COMMENT '开始服务时间',
+  `orderTakingTime` datetime(0) NULL DEFAULT NULL COMMENT '接单时间',
+  `goToAppointmentPointTime` datetime(0) NULL DEFAULT NULL COMMENT '前往预约点时间',
+  `arrivalTimeAtTheAppointmentPoint` datetime(0) NULL DEFAULT NULL COMMENT '到达预约点时间',
+  `startTime` datetime(0) NULL DEFAULT NULL COMMENT '开始服务时间',
   `startAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '起点地址',
   `startLat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '起点纬度',
   `startLng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '起点经度',
   `endAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '终点地址',
   `endLat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '终点纬度',
   `endLng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '终点经度',
-  `boardingTime` datetime NULL DEFAULT NULL COMMENT '上车时间',
-  `getoffTime` datetime NULL DEFAULT NULL COMMENT '下车时间',
+  `boardingTime` datetime(0) NULL DEFAULT NULL COMMENT '上车时间',
+  `getoffTime` datetime(0) NULL DEFAULT NULL COMMENT '下车时间',
   `startDistance` double(11, 2) NULL DEFAULT NULL COMMENT '起步里程（公里）',
   `startPrice` decimal(10, 2) NULL DEFAULT NULL COMMENT '起步价',
   `overDriveDistance` double(11, 2) NULL DEFAULT NULL COMMENT '超出起步里程',
@@ -1422,13 +1422,13 @@
   `discountAmount` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣优惠金额',
   `discount` decimal(10, 2) NULL DEFAULT NULL COMMENT '折扣',
   `payType` int(1) NULL DEFAULT NULL COMMENT '支付类型（1=微信支付，2=余额支付，3=线下收款）',
-  `payTime` datetime NULL DEFAULT NULL COMMENT '支付时间',
+  `payTime` datetime(0) NULL DEFAULT NULL COMMENT '支付时间',
   `hallOrder` int(1) NULL DEFAULT 0 COMMENT '大厅订单（0=否，1=是）',
-  `startWaitTime` datetime NULL DEFAULT NULL COMMENT '开始进入等待状态时间',
+  `startWaitTime` datetime(0) NULL DEFAULT NULL COMMENT '开始进入等待状态时间',
   `state` int(1) NULL DEFAULT NULL COMMENT '订单状态（101=待接单，102=已接单，103=前往预约点，104=到达预约点，105=开始服务，106=到达目的地，107=待支付，108=待评价，109=已完成，201=转单中，301=已取消，401=等待中）',
   `oldState` int(1) NULL DEFAULT NULL COMMENT '历史订单状态（用于还原之前状态）',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单' ROW_FORMAT = COMPACT;
 
@@ -1449,9 +1449,9 @@
   `startAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '起点地址',
   `endAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '终点地址',
   `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '编号',
-  `createTime` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '拒单记录' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '拒单记录' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_order_refusal
@@ -1469,10 +1469,10 @@
   `newDriverId` int(11) NULL DEFAULT NULL COMMENT '新司机id',
   `cause` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '转单原因',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `successTime` datetime NULL DEFAULT NULL COMMENT '转单成功时间',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `successTime` datetime(0) NULL DEFAULT NULL COMMENT '转单成功时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单转派记录' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '订单转派记录' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_order_transfer
@@ -1489,10 +1489,10 @@
   `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
   `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '充值金额',
   `payType` int(1) NULL DEFAULT NULL COMMENT '支付方式（1=微信）',
-  `payTime` datetime NULL DEFAULT NULL COMMENT '完成支付时间',
+  `payTime` datetime(0) NULL DEFAULT NULL COMMENT '完成支付时间',
   `payStatus` int(1) NULL DEFAULT NULL COMMENT '支付状态（1=待支付，2=已完成）',
   `orderNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方流水号',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '充值记录' ROW_FORMAT = COMPACT;
 
@@ -5065,9 +5065,9 @@
   `userId` int(11) NULL DEFAULT NULL COMMENT '用户id',
   `orderId` int(11) NULL DEFAULT NULL COMMENT '订单id',
   `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '收入金额',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '收入记录' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '收入记录' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_revenue
@@ -5083,9 +5083,9 @@
   `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '图片',
   `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统公告' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统公告' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_system_bulletin
@@ -5102,9 +5102,9 @@
   `userId` int(11) NULL DEFAULT NULL COMMENT '用户id',
   `isRead` int(1) NULL DEFAULT NULL COMMENT '阅读（0=否，1=是）',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统公告-用户关系' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统公告-用户关系' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_system_bulletin_user
@@ -5144,12 +5144,27 @@
   `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
   `isRead` int(1) NULL DEFAULT NULL COMMENT '阅读状态（0=否，1=是）',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统消息' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统消息' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_system_message
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for t_systen_config
+-- ----------------------------
+DROP TABLE IF EXISTS `t_systen_config`;
+CREATE TABLE `t_systen_config`  (
+  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
+  `type` int(1) NULL DEFAULT NULL COMMENT '类型（1=派单规则，2=佣金分成规则，3=抽成规则，4=积分规则，5=价格规则，6=余额规则，7=客服管理）',
+  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
+  PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '系统配置' ROW_FORMAT = COMPACT;
+
+-- ----------------------------
+-- Records of t_systen_config
 -- ----------------------------
 
 -- ----------------------------
@@ -5161,7 +5176,7 @@
   `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '标签名',
   `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '达标条件',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签' ROW_FORMAT = COMPACT;
 
@@ -5179,7 +5194,7 @@
   `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
   `district` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 3306 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '天气城市数据' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 3306 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '天气城市数据' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_weather_city
@@ -8427,9 +8442,9 @@
   `effectiveTime` int(11) NULL DEFAULT NULL COMMENT '有效天数',
   `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '服务内容',
   `status` int(1) NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=删除）',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '优推' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '优推' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_you_tui
@@ -8444,10 +8459,10 @@
   `driverId` int(11) NULL DEFAULT NULL COMMENT '司机id',
   `youTuiId` int(11) NULL DEFAULT NULL COMMENT '优推id',
   `integral` int(11) NULL DEFAULT NULL COMMENT '积分',
-  `failureTime` datetime NULL DEFAULT NULL COMMENT '失效时间',
-  `createTime` datetime NULL DEFAULT NULL COMMENT '添加时间',
+  `failureTime` datetime(0) NULL DEFAULT NULL COMMENT '失效时间',
+  `createTime` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
   PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '司机优推数据' ROW_FORMAT = Compact;
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '司机优推数据' ROW_FORMAT = COMPACT;
 
 -- ----------------------------
 -- Records of t_you_tui_driver

--
Gitblit v1.7.1