From 3e210fac9492b90e21ca9bf76c1d9a8fda1f4388 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期三, 13 五月 2026 11:32:17 +0800
Subject: [PATCH] 代码生成
---
server/services/db/db_change.sql | 72 ++++++++++++++++++++++++++++++++++++
1 files changed, 72 insertions(+), 0 deletions(-)
diff --git a/server/services/db/db_change.sql b/server/services/db/db_change.sql
index e9ce016..17ff86d 100644
--- a/server/services/db/db_change.sql
+++ b/server/services/db/db_change.sql
@@ -5,6 +5,78 @@
-- ============================================================
+-- 2026/05/13 浼樻儬鍒镐俊鎭〃
+-- ============================================================
+CREATE TABLE `coupon` (
+ `ID` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `CREATOR` int DEFAULT NULL COMMENT '鍒涘缓浜虹紪鐮�',
+ `CREATE_DATE` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `EDITOR` int DEFAULT NULL COMMENT '鏇存柊浜虹紪鐮�',
+ `EDIT_DATE` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `ISDELETED` int DEFAULT NULL COMMENT '鏄惁鍒犻櫎0鍚� 1鏄�',
+ `STATUS` int DEFAULT NULL COMMENT '鐘舵�� 0鍚敤 1绂佺敤',
+ `REMARK` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
+ `NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍚嶇О',
+ `INFO` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇存槑',
+ `TYPE` int DEFAULT NULL COMMENT '绫诲瀷0骞冲彴浼樻儬鍒� ',
+ `LIMIT_PRICE` BIGINT DEFAULT NULL COMMENT '婊￠锛堝垎锛�',
+ `PRICE` BIGINT DEFAULT NULL COMMENT '浼樻儬閲戦锛堝垎锛�',
+ `PUSH_DAYS` int DEFAULT NULL COMMENT '鎺ㄩ�佸悗棰嗗彇鏈夋晥澶╂暟',
+ `VALID_DAYS` int DEFAULT NULL COMMENT '棰嗗彇鍚庢湁鏁堝ぉ鏁�',
+ `GET_METHOD` int DEFAULT NULL COMMENT '棰嗗彇鏂瑰紡 0棰嗗彇',
+ `USE_TYPE` int DEFAULT NULL COMMENT '浣跨敤绫诲瀷锛�0=鍥哄畾鏃堕暱锛�',
+ `COUPON_TYPE` int DEFAULT NULL COMMENT '浼樻儬鍒哥被鍨嬶細0=婊″噺鍒革紱',
+ PRIMARY KEY (`ID`) USING BTREE
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='浼樻儬鍒镐俊鎭〃';
+
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:coupon:create', '鏂板缓浼樻儬鍒�', '浼樻儬鍒哥鐞�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:coupon:delete', '鍒犻櫎浼樻儬鍒�', '浼樻儬鍒哥鐞�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:coupon:update', '淇敼浼樻儬鍒�', '浼樻儬鍒哥鐞�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:coupon:query', '鏌ヨ浼樻儬鍒�', '浼樻儬鍒哥鐞�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+
+
+-- ============================================================
+-- 2026/05/13 鐢ㄦ埛浼樻儬鍒歌〃
+-- ============================================================
+CREATE TABLE `member_coupon` (
+ `ID` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `CREATOR` int DEFAULT NULL COMMENT '鍒涘缓浜虹紪鐮�',
+ `CREATE_DATE` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `EDITOR` int DEFAULT NULL COMMENT '鏇存柊浜虹紪鐮�',
+ `EDIT_DATE` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ `ISDELETED` int DEFAULT NULL COMMENT '鏄惁鍒犻櫎0鍚� 1鏄�',
+ `REMARK` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '澶囨敞',
+ `COUPON_ID` int DEFAULT NULL COMMENT '浼樻儬鍒镐富閿叧鑱旇〃',
+ `MEMBER_ID` int DEFAULT NULL COMMENT '鐢ㄦ埛缂栫爜锛堝叧鑱攎ember琛級',
+ `STATUS` int DEFAULT NULL COMMENT '鐘舵�侊細0=寰呴鍙栵紱1=宸查鍙栵紱2=宸蹭娇鐢紱98=鏈鍙栧凡杩囨湡锛�99=宸茶繃鏈燂紱',
+ `VALID_DATE` datetime DEFAULT NULL COMMENT '棰嗗彇鏈夋晥鏈熸椂闂�',
+ `START_DATE` datetime DEFAULT NULL COMMENT '鏈夋晥鏈熷紑濮嬫椂闂�',
+ `END_DATE` datetime DEFAULT NULL COMMENT '鏈夋晥鏈熺粨鏉熸椂闂�',
+ `USE_DATE` datetime DEFAULT NULL COMMENT '浣跨敤鏃堕棿',
+ `ORDER_ID` int DEFAULT NULL COMMENT '鍏宠仈璁㈠崟涓婚敭',
+ `NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鍚嶇О',
+ `INFO` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '璇存槑',
+ `TYPE` int DEFAULT NULL COMMENT '绫诲瀷 0骞冲彴浼樻儬鍒� ',
+ `LIMIT_PRICE` BIGINT DEFAULT NULL COMMENT '婊￠锛堝垎锛�',
+ `PRICE` BIGINT DEFAULT NULL COMMENT '浼樻儬閲戦锛堝垎锛�',
+ `GET_METHOD` int DEFAULT NULL COMMENT '棰嗗彇鏂瑰紡 0棰嗗彇',
+ `COUPON_TYPE` int DEFAULT NULL COMMENT '浼樻儬鍒哥被鍨嬶細0=婊″噺鍒革紱',
+ `PUSH_DAYS` int DEFAULT NULL COMMENT '鎺ㄩ�佸悗棰嗗彇鏈夋晥澶╂暟',
+ `VALID_DAYS` int DEFAULT NULL COMMENT '棰嗗彇鍚庢湁鏁堝ぉ鏁�',
+ PRIMARY KEY (`ID`) USING BTREE
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鐢ㄦ埛浼樻儬鍒�';
+
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:memberCoupon:create', '鏂板缓鐢ㄦ埛浼樻儬鍒�', '鐢ㄦ埛浼樻儬鍒�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:memberCoupon:delete', '鍒犻櫎鐢ㄦ埛浼樻儬鍒�', '鐢ㄦ埛浼樻儬鍒�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:memberCoupon:update', '淇敼鐢ㄦ埛浼樻儬鍒�', '鐢ㄦ埛浼樻儬鍒�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `MODULE`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`) VALUES ('business:memberCoupon:query', '鏌ヨ鐢ㄦ埛浼樻儬鍒�', '鐢ㄦ埛浼樻儬鍒�', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0);
+
+-- ============================================================
+-- 2026/05/12 璁㈠崟澧炲姞鏄惁杞崲璁㈠崟瀛楁
+-- ============================================================
+ALTER TABLE `orders` ADD COLUMN `IS_CONVERTED` INT DEFAULT 0 COMMENT '鏄惁杞崲璁㈠崟锛�0=鍚︼紱1=鏄紙寮傚湴杞氨鍦帮級' AFTER `TYPE`;
+
+-- ============================================================
-- 2026/05/11 鍙告満鐗堟湰绫诲瀷瀛楁
-- ============================================================
ALTER TABLE `driver_info` ADD COLUMN `VERSION_TYPE` INT DEFAULT 0 COMMENT '鍙告満鐗堟湰绫诲瀷锛�0=姝ｅ紡鐗堟湰锛�1=鍙樻洿鐗堟湰';
--
Gitblit v1.9.3