From 405a98c8f3fb970806f93e70a8dc97da395c54d3 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期四, 09 五月 2024 17:08:21 +0800 Subject: [PATCH] update 优化 规范命名规则 --- script/sql/update/update_5.1.2-5.2.0.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/script/sql/update/update_5.1.2-5.2.0.sql b/script/sql/update/update_5.1.2-5.2.0.sql index 678f548..3cf5601 100644 --- a/script/sql/update/update_5.1.2-5.2.0.sql +++ b/script/sql/update/update_5.1.2-5.2.0.sql @@ -1,3 +1,4 @@ ALTER TABLE sys_dept ADD dept_category VARCHAR(100) DEFAULT NULL COMMENT '閮ㄩ棬绫诲埆缂栫爜'; ALTER TABLE sys_post ADD dept_id BIGINT(20) NOT NULL COMMENT '閮ㄩ棬id', ADD post_category VARCHAR(100) DEFAULT NULL COMMENT '宀椾綅绫诲埆缂栫爜'; UPDATE sys_post SET dept_id = 100; +UPDATE sys_post SET dept_id = 103 where post_id = 1; -- Gitblit v1.9.3