From 7c0f41c785ef1ae7b121cf7c6127e7566da866a5 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 11 三月 2022 13:00:09 +0800
Subject: [PATCH] update 确保更好的适配 多数据库 主键策略统一改为 雪花ID
---
script/sql/sqlserver/sqlserver_ry_vue_4.X.sql | 28 ++++++++++++++--------------
1 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
index 29318b9..49d5af9 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_4.X.sql
@@ -1,7 +1,7 @@
CREATE TABLE [gen_table]
(
- [table_id] bigint IDENTITY (1,1) NOT NULL,
+ [table_id] bigint NOT NULL,
[table_name] nvarchar(200) DEFAULT '' NULL,
[table_comment] nvarchar(500) DEFAULT '' NULL,
[sub_table_name] nvarchar(64) NULL,
@@ -156,7 +156,7 @@
CREATE TABLE [gen_table_column]
(
- [column_id] bigint IDENTITY (1,1) NOT NULL,
+ [column_id] bigint NOT NULL,
[table_id] nvarchar(64) NULL,
[column_name] nvarchar(200) NULL,
[column_comment] nvarchar(500) NULL,
@@ -427,7 +427,7 @@
CREATE TABLE [sys_dept]
(
- [dept_id] bigint IDENTITY (100,1) NOT NULL,
+ [dept_id] bigint NOT NULL,
[parent_id] bigint DEFAULT ((0)) NULL,
[ancestors] nvarchar(50) DEFAULT '' NULL,
[dept_name] nvarchar(30) DEFAULT '' NULL,
@@ -565,7 +565,7 @@
CREATE TABLE [sys_dict_data]
(
- [dict_code] bigint IDENTITY (1,1) NOT NULL,
+ [dict_code] bigint NOT NULL,
[dict_sort] int DEFAULT ((0)) NULL,
[dict_label] nvarchar(100) DEFAULT '' NULL,
[dict_value] nvarchar(100) DEFAULT '' NULL,
@@ -739,7 +739,7 @@
CREATE TABLE [sys_dict_type]
(
- [dict_id] bigint IDENTITY (1,1) NOT NULL,
+ [dict_id] bigint NOT NULL,
[dict_name] nvarchar(100) DEFAULT '' NULL,
[dict_type] nvarchar(100) DEFAULT '' NULL,
[status] nchar(1) DEFAULT ('0') NULL,
@@ -842,7 +842,7 @@
CREATE TABLE [sys_logininfor]
(
- [info_id] bigint IDENTITY (1,1) NOT NULL,
+ [info_id] bigint NOT NULL,
[user_name] nvarchar(50) DEFAULT '' NULL,
[ipaddr] nvarchar(128) DEFAULT '' NULL,
[login_location] nvarchar(255) DEFAULT '' NULL,
@@ -920,7 +920,7 @@
CREATE TABLE [sys_menu]
(
- [menu_id] bigint IDENTITY (1,1) NOT NULL,
+ [menu_id] bigint NOT NULL,
[menu_name] nvarchar(50) NOT NULL,
[parent_id] bigint DEFAULT ((0)) NULL,
[order_num] int DEFAULT ((0)) NULL,
@@ -1240,7 +1240,7 @@
CREATE TABLE [sys_notice]
(
- [notice_id] bigint IDENTITY (1,1) NOT NULL,
+ [notice_id] bigint NOT NULL,
[notice_title] nvarchar(50) NOT NULL,
[notice_type] nchar(1) NOT NULL,
[notice_content] nvarchar(max) NULL,
@@ -1335,7 +1335,7 @@
CREATE TABLE [sys_oper_log]
(
- [oper_id] bigint IDENTITY (1,1) NOT NULL,
+ [oper_id] bigint NOT NULL,
[title] nvarchar(50) DEFAULT '' NULL,
[business_type] int DEFAULT ((0)) NULL,
[method] nvarchar(100) DEFAULT '' NULL,
@@ -1462,7 +1462,7 @@
CREATE TABLE [sys_post]
(
- [post_id] bigint IDENTITY (1,1) NOT NULL,
+ [post_id] bigint NOT NULL,
[post_code] nvarchar(64) NOT NULL,
[post_name] nvarchar(50) NOT NULL,
[post_sort] int NOT NULL,
@@ -1560,7 +1560,7 @@
CREATE TABLE [sys_role]
(
- [role_id] bigint IDENTITY (1,1) NOT NULL,
+ [role_id] bigint NOT NULL,
[role_name] nvarchar(30) NOT NULL,
[role_key] nvarchar(100) NOT NULL,
[role_sort] int NOT NULL,
@@ -1912,7 +1912,7 @@
CREATE TABLE [sys_user]
(
- [user_id] bigint IDENTITY (1,1) NOT NULL,
+ [user_id] bigint NOT NULL,
[dept_id] bigint NULL,
[user_name] nvarchar(30) NOT NULL,
[nick_name] nvarchar(30) NOT NULL,
@@ -2137,7 +2137,7 @@
CREATE TABLE [sys_oss]
(
- [oss_id] bigint IDENTITY (1,1) NOT NULL,
+ [oss_id] bigint NOT NULL,
[file_name] nvarchar(255) DEFAULT '' NOT NULL,
[original_name] nvarchar(255) DEFAULT '' NOT NULL,
[file_suffix] nvarchar(10) DEFAULT '' NOT NULL,
@@ -2222,7 +2222,7 @@
CREATE TABLE [sys_oss_config]
(
- [oss_config_id] bigint IDENTITY (1,1) NOT NULL,
+ [oss_config_id] bigint NOT NULL,
[config_key] nvarchar(255) DEFAULT '' NOT NULL,
[access_key] nvarchar(255) DEFAULT '' NULL,
[secret_key] nvarchar(255) DEFAULT '' NULL,
--
Gitblit v1.9.3