From 96eef805a3727639794ea90bfa82b3883f9f3d9c Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期六, 31 五月 2025 10:48:45 +0800
Subject: [PATCH] 省市区处理

---
 ruoyi-system/src/main/resources/db/migration/postgresql/V20250531102200__create_province.sql |   15 +++++++++++++++
 1 files changed, 15 insertions(+), 0 deletions(-)

diff --git a/ruoyi-system/src/main/resources/db/migration/postgresql/V20250531102200__create_province.sql b/ruoyi-system/src/main/resources/db/migration/postgresql/V20250531102200__create_province.sql
new file mode 100644
index 0000000..2dd8e10
--- /dev/null
+++ b/ruoyi-system/src/main/resources/db/migration/postgresql/V20250531102200__create_province.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS province;
+
+CREATE TABLE province
+(
+    id         bigserial PRIMARY KEY,
+    create_time timestamp with time zone NOT NULL,
+    update_time timestamp with time zone NOT NULL,
+    name       varchar(100) DEFAULT ''  NOT NULL
+);
+
+COMMENT ON TABLE province IS '鐪佽〃';
+
+COMMENT ON COLUMN province.name IS '鍚嶇О';
+create unique index on province(name);
+

--
Gitblit v1.9.3