From 55d694aaae4e421b5e55cd941500e08f85cb5d4d Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 27 八月 2026 18:21:33 +0800
Subject: [PATCH] feat(sales): 添加框架合同订单功能并优化销售台账管理

---
 sql/migration_device_area.sql |   25 +++++++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/sql/migration_device_area.sql b/sql/migration_device_area.sql
new file mode 100644
index 0000000..354297e
--- /dev/null
+++ b/sql/migration_device_area.sql
@@ -0,0 +1,25 @@
+-- 璁惧鍖哄煙锛堣溅闂�/浣嶇疆锛夌埗瀛愰�掑綊缁撴瀯
+CREATE TABLE IF NOT EXISTS `device_area` (
+    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+    `name` varchar(255) NOT NULL COMMENT '鍖哄煙/杞﹂棿/浣嶇疆鍚嶇О',
+    `parent_id` bigint NULL COMMENT '鐖剁骇鍖哄煙ID锛屾牴鑺傜偣涓篘ULL',
+    `ancestors` varchar(1000) NULL COMMENT '绁栫骇璺緞锛屽 1,2,3',
+    `sort` int NULL COMMENT '鎺掑簭',
+    `dept_id` bigint NULL COMMENT '閮ㄩ棬ID',
+    `tenant_id` bigint NULL COMMENT '绉熸埛ID',
+    `create_user` int NULL COMMENT '鍒涘缓浜�',
+    `create_time` datetime NULL COMMENT '鍒涘缓鏃堕棿',
+    `update_user` int NULL COMMENT '鏇存柊浜�',
+    `update_time` datetime NULL COMMENT '鏇存柊鏃堕棿',
+    PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='璁惧鍖哄煙琛紙杞﹂棿/浣嶇疆锛�';
+
+-- 璁惧鍙拌处鍏宠仈鍖哄煙锛堝箓绛夛細宸插瓨鍦ㄥ垪鏃惰烦杩囷級
+SET @col_exists = (SELECT COUNT(*) FROM information_schema.COLUMNS
+    WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'device_ledger' AND COLUMN_NAME = 'area_id');
+SET @ddl = IF(@col_exists = 0,
+    'ALTER TABLE `device_ledger` ADD COLUMN `area_id` bigint NULL COMMENT ''璁惧鍖哄煙ID'' AFTER `dept_id`',
+    'SELECT 1');
+PREPARE stmt FROM @ddl;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;

--
Gitblit v1.9.3