From dcdf423d669e64a9cbe5bd5854a000b78af1f7fe Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 16 三月 2022 14:06:00 +0800
Subject: [PATCH] update 更新 sqlserver sql脚本 处理遇到的问题
---
script/sql/test.sql | 46 +++++++++++++++++++++++-----------------------
1 files changed, 23 insertions(+), 23 deletions(-)
diff --git a/script/sql/test.sql b/script/sql/test.sql
index 601360a..fd547e7 100644
--- a/script/sql/test.sql
+++ b/script/sql/test.sql
@@ -1,37 +1,40 @@
DROP TABLE if EXISTS test_demo;
CREATE TABLE test_demo
(
- id int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
- dept_id int(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
- user_id int(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
- order_num int(0) NULL DEFAULT 0 COMMENT '鎺掑簭鍙�',
+ id int(0) NOT NULL COMMENT '涓婚敭',
+ dept_id int(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+ user_id int(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
+ order_num int(0) NULL DEFAULT 0 COMMENT '鎺掑簭鍙�',
test_key varchar(255) NULL DEFAULT NULL COMMENT 'key閿�',
value varchar(255) NULL DEFAULT NULL COMMENT '鍊�',
- version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
- create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
- update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
- del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
+ version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
+ create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
+ del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB COMMENT = '娴嬭瘯鍗曡〃';
DROP TABLE if EXISTS test_tree;
CREATE TABLE test_tree
(
- id int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
- parent_id int(0) NULL DEFAULT 0 COMMENT '鐖秈d',
- dept_id int(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
- user_id int(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
+ id int(0) NOT NULL COMMENT '涓婚敭',
+ parent_id int(0) NULL DEFAULT 0 COMMENT '鐖秈d',
+ dept_id int(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+ user_id int(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
tree_name varchar(255) NULL DEFAULT NULL COMMENT '鍊�',
- version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
- create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
- update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
- del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
+ version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
+ create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
+ del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB COMMENT = '娴嬭瘯鏍戣〃';
+
+INSERT INTO sys_user(user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) VALUES (3, 108, 'test', '鏈儴闂ㄥ強浠ヤ笅 瀵嗙爜666666', 'sys_user', '', '', '0', '', '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), 'test', sysdate(), NULL);
+INSERT INTO sys_user(user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) VALUES (4, 102, 'test1', '浠呮湰浜� 瀵嗙爜666666', 'sys_user', '', '', '0', '', '$2a$10$b8yUzN0C71sbz.PhNOCgJe.Tu1yWC3RNrTyjSQ8p1W0.aaUXUJ.Ne', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), 'test1', sysdate(), NULL);
INSERT INTO sys_menu(menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark) VALUES (5, '娴嬭瘯鑿滃崟', 0, 5, 'demo', NULL, 1, 0, 'M', '0', '0', NULL, 'star', 'admin', '2021-05-30 00:34:26', NULL, NULL, '');
@@ -135,9 +138,6 @@
INSERT INTO sys_role_menu(role_id, menu_id) VALUES (4, 1509);
INSERT INTO sys_role_menu(role_id, menu_id) VALUES (4, 1510);
INSERT INTO sys_role_menu(role_id, menu_id) VALUES (4, 1511);
-
-INSERT INTO sys_user(user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) VALUES (3, 108, 'test', '鏈儴闂ㄥ強浠ヤ笅 瀵嗙爜666', '00', '', '', '0', '', '$2a$10$M6tZRpUZbWKq11O/z6YISePQc./Jhru8E18mmVJTr9aV8whzfjacC', '0', '0', '127.0.0.1', '2021-05-30 02:00:37', 'admin', '2021-04-22 09:50:41', 'test', '2021-05-30 02:00:37', NULL);
-INSERT INTO sys_user(user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, create_by, create_time, update_by, update_time, remark) VALUES (4, 102, 'test1', '浠呮湰浜� 瀵嗙爜666', '00', '', '', '0', '', '$2a$10$yBSXp5Ba1m402cxXTPSy4eXUO8CXCGvXfquNVP/XMWwZ8nf9GaoMy', '0', '0', '127.0.0.1', '2021-05-30 01:48:03', 'admin', '2021-05-30 01:16:02', 'test1', '2021-05-30 01:48:03', NULL);
INSERT INTO sys_user_role(user_id, role_id) VALUES (3, 3);
INSERT INTO sys_user_role(user_id, role_id) VALUES (4, 4);
--
Gitblit v1.9.3