| | |
| | | CREATE TABLE sys_config |
| | | ( |
| | | config_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT '000000' NULL, |
| | | config_name nvarchar(100) DEFAULT '' NULL, |
| | | config_key nvarchar(100) DEFAULT '' NULL, |
| | | config_value nvarchar(500) DEFAULT '' NULL, |
| | |
| | | CREATE TABLE sys_dept |
| | | ( |
| | | dept_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | parent_id bigint DEFAULT ((0)) NULL, |
| | | ancestors nvarchar(500)DEFAULT '' NULL, |
| | | dept_name nvarchar(30) DEFAULT '' NULL, |
| | |
| | | CREATE TABLE sys_dict_data |
| | | ( |
| | | dict_code bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | dict_sort int DEFAULT ((0)) NULL, |
| | | dict_label nvarchar(100) DEFAULT '' NULL, |
| | | dict_value nvarchar(100) DEFAULT '' NULL, |
| | |
| | | CREATE TABLE sys_dict_type |
| | | ( |
| | | dict_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | dict_name nvarchar(100) DEFAULT '' NULL, |
| | | dict_type nvarchar(100) DEFAULT '' NULL, |
| | | status nchar(1) DEFAULT ('0') NULL, |
| | |
| | | ON [PRIMARY] |
| | | ) |
| | | ON [PRIMARY] |
| | | GO |
| | | |
| | | CREATE NONCLUSTERED INDEX sys_dict_type_index1 ON sys_dict_type (tenant_id, dict_type) |
| | | GO |
| | | |
| | | EXEC sys.sp_addextendedproperty |
| | |
| | | CREATE TABLE sys_logininfor |
| | | ( |
| | | info_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | user_name nvarchar(50) DEFAULT '' NULL, |
| | | ipaddr nvarchar(128) DEFAULT '' NULL, |
| | | login_location nvarchar(255) DEFAULT '' NULL, |
| | |
| | | GO |
| | | INSERT sys_menu VALUES (3, N'系统工具', 0, 4, N'tool', NULL, N'', 1, 0, N'M', N'0', N'0', N'', N'tool', 103, 1, getdate(), NULL, NULL, N'系统工具目录') |
| | | GO |
| | | INSERT sys_menu VALUES (4, N'PLUS官网', 0, 5, N'https://gitee.com/dromara/RuoYi-Vue-Plus', null, N'', 0, 0, N'M', N'0', N'0', N'', N'guide', 103, 1, sysdate(), null, null, N'RuoYi-Vue-Plus官网地址'); |
| | | GO |
| | | INSERT sys_menu VALUES (100, N'用户管理', 1, 1, N'user', N'system/user/index', N'', 1, 0, N'C', N'0', N'0', N'system:user:list', N'user', 103, 1, getdate(), NULL, NULL, N'用户管理菜单') |
| | | GO |
| | | INSERT sys_menu VALUES (101, N'角色管理', 1, 2, N'role', N'system/role/index', N'', 1, 0, N'C', N'0', N'0', N'system:role:list', N'peoples', 103, 1, getdate(), NULL, NULL, N'角色管理菜单') |
| | |
| | | CREATE TABLE sys_notice |
| | | ( |
| | | notice_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | notice_title nvarchar(50) NOT NULL, |
| | | notice_type nchar(1) NOT NULL, |
| | | notice_content nvarchar(max) NULL, |
| | |
| | | CREATE TABLE sys_oper_log |
| | | ( |
| | | oper_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | title nvarchar(50) DEFAULT '' NULL, |
| | | business_type int DEFAULT ((0)) NULL, |
| | | method nvarchar(100) DEFAULT '' NULL, |
| | |
| | | |
| | | CREATE TABLE sys_post |
| | | ( |
| | | post_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | post_code nvarchar(64) NOT NULL, |
| | | post_name nvarchar(50) NOT NULL, |
| | | post_sort int NOT NULL, |
| | | status nchar(1) NOT NULL, |
| | | create_dept bigint NULL, |
| | | create_by bigint NULL, |
| | | create_time datetime2(7) NULL, |
| | | update_by bigint NULL, |
| | | update_time datetime2(7) NULL, |
| | | remark nvarchar(500) NULL, |
| | | post_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | post_code nvarchar(64) NOT NULL, |
| | | post_name nvarchar(50) NOT NULL, |
| | | post_sort int NOT NULL, |
| | | status nchar(1) NOT NULL, |
| | | create_dept bigint NULL, |
| | | create_by bigint NULL, |
| | | create_time datetime2(7) NULL, |
| | | update_by bigint NULL, |
| | | update_time datetime2(7) NULL, |
| | | remark nvarchar(500) NULL, |
| | | CONSTRAINT PK__sys_post__3ED7876668E2D081 PRIMARY KEY CLUSTERED (post_id) |
| | | WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) |
| | | ON [PRIMARY] |
| | | ) |
| | | ON [PRIMARY] |
| | | GO |
| | | |
| | | CREATE NONCLUSTERED INDEX sys_dict_type_index1 ON sys_dict_type (tenant_id, dict_type) |
| | | GO |
| | | |
| | | EXEC sys.sp_addextendedproperty |
| | |
| | | CREATE TABLE sys_role |
| | | ( |
| | | role_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | role_name nvarchar(30) NOT NULL, |
| | | role_key nvarchar(100) NOT NULL, |
| | | role_sort int NOT NULL, |
| | |
| | | CREATE TABLE sys_user |
| | | ( |
| | | user_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | dept_id bigint NULL, |
| | | user_name nvarchar(30) NOT NULL, |
| | | nick_name nvarchar(30) NOT NULL, |
| | |
| | | CREATE TABLE sys_oss |
| | | ( |
| | | oss_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | file_name nvarchar(255) DEFAULT '' NOT NULL, |
| | | original_name nvarchar(255) DEFAULT '' NOT NULL, |
| | | file_suffix nvarchar(10) DEFAULT '' NOT NULL, |
| | |
| | | CREATE TABLE sys_oss_config |
| | | ( |
| | | oss_config_id bigint NOT NULL, |
| | | tenant_id nvarchar(20) NOT NULL, |
| | | tenant_id nvarchar(20) DEFAULT ('000000') NULL, |
| | | config_key nvarchar(20) DEFAULT '' NOT NULL, |
| | | access_key nvarchar(255) DEFAULT '' NULL, |
| | | secret_key nvarchar(255) DEFAULT '' NULL, |
| | |
| | | 'COLUMN', N'access_policy' |
| | | GO |
| | | EXEC sp_addextendedproperty |
| | | 'MS_Description', N'状态(0=正常,1=停用)', |
| | | 'MS_Description', N'是否默认(0=是,1=否)', |
| | | 'SCHEMA', N'dbo', |
| | | 'TABLE', N'sys_oss_config', |
| | | 'COLUMN', N'status' |