From 061c6e822dd8f6e81c10362fa6703e533f3d64a9 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期二, 02 四月 2024 17:02:25 +0800
Subject: [PATCH] update 优化 移除删表语句 用户自行处理
---
script/sql/sqlserver/flowable.sql | 2 --
script/sql/postgres/postgres_ry_vue_5.X.sql | 24 ------------------------
script/sql/flowable.sql | 4 ----
script/sql/postgres/flowable.sql | 2 --
4 files changed, 0 insertions(+), 32 deletions(-)
diff --git a/script/sql/flowable.sql b/script/sql/flowable.sql
index 1d414e8..4c03f8d 100644
--- a/script/sql/flowable.sql
+++ b/script/sql/flowable.sql
@@ -19,7 +19,6 @@
insert into sys_menu values ('11626', '娴佺▼鍒嗙被鍒犻櫎', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, sysdate(), null, null, '');
insert into sys_menu values ('11627', '娴佺▼鍒嗙被瀵煎嚭', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, sysdate(), null, null, '');
-- 璇峰亣鍗曚俊鎭�
-DROP TABLE if EXISTS test_leave;
create table test_leave
(
id bigint not null comment '涓婚敭',
@@ -38,7 +37,6 @@
) ENGINE = InnoDB COMMENT = '璇峰亣鐢宠琛�';
-- 娴佺▼鍒嗙被淇℃伅琛�
-DROP TABLE if EXISTS wf_category;
create table wf_category
(
id bigint not null comment '涓婚敭'
@@ -58,7 +56,6 @@
) engine=innodb comment= '娴佺▼鍒嗙被';
INSERT INTO wf_category values (1, 'OA', 'OA', 0, 0, '000000', 103, 1, sysdate(), 1, sysdate());
-DROP TABLE if EXISTS wf_task_back_node;
create table wf_task_back_node
(
id bigint not null
@@ -78,7 +75,6 @@
)
comment '鑺傜偣瀹℃壒璁板綍';
-DROP TABLE if EXISTS wf_definition_config;
create table wf_definition_config
(
id bigint not null comment '涓婚敭'
diff --git a/script/sql/postgres/flowable.sql b/script/sql/postgres/flowable.sql
index 60b6cca..f20426d 100644
--- a/script/sql/postgres/flowable.sql
+++ b/script/sql/postgres/flowable.sql
@@ -19,7 +19,6 @@
insert into sys_menu values ('11626', '娴佺▼鍒嗙被鍒犻櫎', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, now(), null, null, '');
insert into sys_menu values ('11627', '娴佺▼鍒嗙被瀵煎嚭', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, now(), null, null, '');
-- 璇峰亣鍗曚俊鎭�
-DROP TABLE if EXISTS test_leave;
create table test_leave
(
id bigint not null
@@ -66,7 +65,6 @@
owner to postgres;
-- 娴佺▼鍒嗙被淇℃伅琛�
-DROP TABLE if EXISTS wf_category;
create table wf_category
(
id bigint not null
diff --git a/script/sql/postgres/postgres_ry_vue_5.X.sql b/script/sql/postgres/postgres_ry_vue_5.X.sql
index e6f6bac..58a5193 100644
--- a/script/sql/postgres/postgres_ry_vue_5.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_5.X.sql
@@ -69,7 +69,6 @@
-- ----------------------------
-- 绉熸埛琛�
-- ----------------------------
-drop table if exists sys_tenant;
create table if not exists sys_tenant
(
id int8,
@@ -128,7 +127,6 @@
-- ----------------------------
-- 绉熸埛濂楅琛�
-- ----------------------------
-drop table if exists sys_tenant_package;
create table if not exists sys_tenant_package
(
package_id int8,
@@ -164,7 +162,6 @@
-- ----------------------------
-- 1銆侀儴闂ㄨ〃
-- ----------------------------
-drop table if exists sys_dept;
create table if not exists sys_dept
(
dept_id int8,
@@ -221,7 +218,6 @@
-- ----------------------------
-- 2銆佺敤鎴蜂俊鎭〃
-- ----------------------------
-drop table if exists sys_user;
create table if not exists sys_user
(
user_id int8,
@@ -282,7 +278,6 @@
-- ----------------------------
-- 3銆佸矖浣嶄俊鎭〃
-- ----------------------------
-drop table if exists sys_post;
create table if not exists sys_post
(
post_id int8,
@@ -325,7 +320,6 @@
-- ----------------------------
-- 4銆佽鑹蹭俊鎭〃
-- ----------------------------
-drop table if exists sys_role;
create table if not exists sys_role
(
role_id int8,
@@ -375,7 +369,6 @@
-- ----------------------------
-- 5銆佽彍鍗曟潈闄愯〃
-- ----------------------------
-drop table if exists sys_menu;
create table if not exists sys_menu
(
menu_id int8,
@@ -575,7 +568,6 @@
-- ----------------------------
-- 6銆佺敤鎴峰拰瑙掕壊鍏宠仈琛� 鐢ㄦ埛N-1瑙掕壊
-- ----------------------------
-drop table if exists sys_user_role;
create table if not exists sys_user_role
(
user_id int8 not null,
@@ -597,7 +589,6 @@
-- ----------------------------
-- 7銆佽鑹插拰鑿滃崟鍏宠仈琛� 瑙掕壊1-N鑿滃崟
-- ----------------------------
-drop table if exists sys_role_menu;
create table if not exists sys_role_menu
(
role_id int8 not null,
@@ -699,7 +690,6 @@
-- ----------------------------
-- 8銆佽鑹插拰閮ㄩ棬鍏宠仈琛� 瑙掕壊1-N閮ㄩ棬
-- ----------------------------
-drop table if exists sys_role_dept;
create table if not exists sys_role_dept
(
role_id int8 not null,
@@ -715,7 +705,6 @@
-- ----------------------------
-- 9銆佺敤鎴蜂笌宀椾綅鍏宠仈琛� 鐢ㄦ埛1-N宀椾綅
-- ----------------------------
-drop table if exists sys_user_post;
create table if not exists sys_user_post
(
user_id int8 not null,
@@ -735,7 +724,6 @@
-- ----------------------------
-- 10銆佹搷浣滄棩蹇楄褰�
-- ----------------------------
-drop table if exists sys_oper_log;
create table if not exists sys_oper_log
(
oper_id int8,
@@ -786,7 +774,6 @@
-- ----------------------------
-- 11銆佸瓧鍏哥被鍨嬭〃
-- ----------------------------
-drop table if exists sys_dict_type;
create table if not exists sys_dict_type
(
dict_id int8,
@@ -830,7 +817,6 @@
-- ----------------------------
-- 12銆佸瓧鍏告暟鎹〃
-- ----------------------------
-drop table if exists sys_dict_data;
create table if not exists sys_dict_data
(
dict_code int8,
@@ -907,7 +893,6 @@
-- ----------------------------
-- 13銆佸弬鏁伴厤缃〃
-- ----------------------------
-drop table if exists sys_config;
create table if not exists sys_config
(
config_id int8,
@@ -949,7 +934,6 @@
-- ----------------------------
-- 14銆佺郴缁熻闂褰�
-- ----------------------------
-drop table if exists sys_logininfor;
create table if not exists sys_logininfor
(
info_id int8,
@@ -987,7 +971,6 @@
-- ----------------------------
-- 17銆侀�氱煡鍏憡琛�
-- ----------------------------
-drop table if exists sys_notice;
create table if not exists sys_notice
(
notice_id int8,
@@ -1029,7 +1012,6 @@
-- ----------------------------
-- 18銆佷唬鐮佺敓鎴愪笟鍔¤〃
-- ----------------------------
-drop table if exists gen_table;
create table if not exists gen_table
(
table_id int8,
@@ -1084,7 +1066,6 @@
-- ----------------------------
-- 19銆佷唬鐮佺敓鎴愪笟鍔¤〃瀛楁
-- ----------------------------
-drop table if exists gen_table_column;
create table if not exists gen_table_column
(
column_id int8,
@@ -1141,7 +1122,6 @@
-- ----------------------------
-- OSS瀵硅薄瀛樺偍琛�
-- ----------------------------
-drop table if exists sys_oss;
create table if not exists sys_oss
(
oss_id int8,
@@ -1176,7 +1156,6 @@
-- ----------------------------
-- OSS瀵硅薄瀛樺偍鍔ㄦ�侀厤缃〃
-- ----------------------------
-drop table if exists sys_oss_config;
create table if not exists sys_oss_config
(
oss_config_id int8,
@@ -1233,7 +1212,6 @@
-- ----------------------------
-- 绯荤粺鎺堟潈琛�
-- ----------------------------
-drop table if exists sys_client;
create table sys_client (
id int8,
client_id varchar(64) default ''::varchar,
@@ -1273,7 +1251,6 @@
insert into sys_client values (1, 'e5cd7e4891bf95d1d19206ce24a7b32e', 'pc', 'pc123', 'password,social', 'pc', 1800, 604800, 0, 0, 103, 1, now(), 1, now());
insert into sys_client values (2, '428a8310cd442757ae699df5d894f051', 'app', 'app123', 'password,sms,social', 'android', 1800, 604800, 0, 0, 103, 1, now(), 1, now());
-DROP TABLE if EXISTS test_demo;
create table if not exists test_demo
(
id int8,
@@ -1308,7 +1285,6 @@
comment on column test_demo.update_by is '鏇存柊浜�';
comment on column test_demo.del_flag is '鍒犻櫎鏍囧織';
-DROP TABLE if EXISTS test_tree;
create table if not exists test_tree
(
id int8,
diff --git a/script/sql/sqlserver/flowable.sql b/script/sql/sqlserver/flowable.sql
index 1c0576b..19810b0 100644
--- a/script/sql/sqlserver/flowable.sql
+++ b/script/sql/sqlserver/flowable.sql
@@ -19,7 +19,6 @@
insert into sys_menu values ('11626', '娴佺▼鍒嗙被鍒犻櫎', '11622', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove','#', 103, 1, getdate(), null, null, '');
insert into sys_menu values ('11627', '娴佺▼鍒嗙被瀵煎嚭', '11622', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:export','#', 103, 1, getdate(), null, null, '');
-- 璇峰亣鍗曚俊鎭�
-DROP TABLE if EXISTS test_leave;
create table test_leave
(
id bigint not null
@@ -84,7 +83,6 @@
go
-- 娴佺▼鍒嗙被淇℃伅琛�
-DROP TABLE if EXISTS wf_category;
create table wf_category
(
id bigint not null
--
Gitblit v1.9.3