DatabaseScripts/MySQL/install.sql · wei/BootstrapAdmin

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 1.5K

wei/BootstrapAdmin

forked from LongbowEnterprise/BootstrapAdmin

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (4)

标签 (2)

管理

master

dev

dev-Tabs

dev-cpsy

v2.0.0

v1.0.0

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 4

标签 2

BootstrapAdmin

DatabaseScripts

MySQL

install.sql

install.sql 4.84 KB

CREATE TABLE Users (
 ID INTEGER PRIMARY KEY	Auto_increment,
 UserName NVARCHAR (50) NOT NULL,
 Password VARCHAR (50) NOT NULL,
 PassSalt VARCHAR (50) NOT NULL,
 DisplayName VARCHAR (50) NOT NULL,
 RegisterTime DATETIME NOT NULL,
 ApprovedTime DATETIME,
 ApprovedBy VARCHAR (50),
 Description VARCHAR (500) NOT NULL,
 RejectedBy VARCHAR (50),
 RejectedTime DATETIME,
 RejectedReason VARCHAR (50),
 Icon VARCHAR (50),
 Css VARCHAR (50),
	App			 VARCHAR (50)
);

CREATE TABLE UserRole (
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserID 			INT NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE UserGroup(
	ID 			INTEGER PRIMARY KEY	Auto_increment,
	UserID 			INT NOT NULL,
	GroupID 		INT NOT NULL
);

CREATE TABLE Roles(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	RoleName 		VARCHAR (50) NOT NULL,
	Description 	VARCHAR (500) NULL
);

CREATE TABLE RoleGroup(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	RoleID 			INT NOT NULL,
	GroupID 		INT NOT NULL
);

CREATE TABLE RoleApp(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	AppID 			VARCHAR (500) NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE Notifications(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	Category 		VARCHAR (50) NOT NULL,
	Title 			VARCHAR (50) NOT NULL,
	Content 		VARCHAR (50) NOT NULL,
	RegisterTime 	DATETIME NOT NULL,
	ProcessTime 	DATETIME NULL,
	ProcessBy 		VARCHAR (50) NULL,
	ProcessResult 	VARCHAR (50) NULL,
	Status 			VARCHAR (50) DEFAULT 0
);

CREATE TABLE Navigations(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	ParentId 		INT DEFAULT 0,
	Name 			VARCHAR (50) NOT NULL,
	`Order` 		INT NOT NULL DEFAULT 0,
	Icon 			VARCHAR (50) DEFAULT 'fa fa-fa',
	Url 			VARCHAR (4000) NULL,
	Category 		VARCHAR (50) DEFAULT 0,
	Target 			VARCHAR (10) DEFAULT '_self',
	IsResource 		INT DEFAULT 0,
	Application 	VARCHAR (200) DEFAULT 0
);

CREATE TABLE NavigationRole(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	NavigationID 	INT NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE Logs(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	CRUD 			VARCHAR (50) NOT NULL,
	UserName 		VARCHAR (50) NOT NULL,
	LogTime			DATETIME NOT NULL,
	Ip				VARCHAR (15) NOT NULL,
	Browser			VARCHAR (50) NULL,
	OS				VARCHAR (50) NULL,
	City			VARCHAR (50) NULL,
	RequestUrl		VARCHAR (500) NOT NULL,
	RequestData		MEDIUMTEXT NULL,
	UserAgent		VARCHAR (2000) NULL
);

CREATE TABLE `Groups`(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	GroupName 		VARCHAR (50) NOT NULL,
	Description 	VARCHAR (500) NULL
);

CREATE TABLE Exceptions(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	AppDomainName 	VARCHAR (50) NOT NULL,
	ErrorPage 		VARCHAR (50) NOT NULL,
	UserID 			VARCHAR (50) NULL,
	UserIp 			VARCHAR (15) NULL,
	ExceptionType 	TEXT NOT NULL,
	Message 		TEXT NOT NULL,
	StackTrace 		TEXT NULL,
	LogTime 		DATETIME NOT NULL,
	Category		VARCHAR (50) NULL
);

CREATE TABLE Dicts(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	Category 		VARCHAR (50) NOT NULL,
	Name 			VARCHAR (50) NOT NULL,
	Code 			VARCHAR (2000) NOT NULL,
	Define 			INT NOT NULL DEFAULT 1
);

CREATE TABLE Messages(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	Title 			VARCHAR (50) NOT NULL,
	Content 		VARCHAR (500) NOT NULL,
	`From` 			VARCHAR (50) NOT NULL,
	`To` 			VARCHAR (50) NOT NULL,
	SendTime 		DATETIME NOT NULL,
	Status 			VARCHAR (50) NOT NULL,
	Flag 			INT DEFAULT 0,
	IsDelete 		INT DEFAULT 0,
	Label 			VARCHAR (50)
);

CREATE TABLE Tasks(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	TaskName 		VARCHAR (500) NOT NULL,
	AssignName 		VARCHAR (50) NOT NULL,
	UserName 		VARCHAR (50) NOT NULL,
	TaskTime 		INT NOT NULL,
	TaskProgress 	INT NOT NULL,
	AssignTime 		DATETIME NOT NULL
);

CREATE TABLE RejectUsers(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserName 		VARCHAR (50) NOT NULL,
	DisplayName 	VARCHAR (50) NOT NULL,
	RegisterTime 	DATETIME NOT NULL,
	RejectedBy		VARCHAR (50) NOT NULL,
	RejectedTime	DATETIME NOT NULL,
	RejectedReason 	VARCHAR (50) NULL
);

CREATE TABLE LoginLogs(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserName 		VARCHAR (50) NOT NULL,
	LoginTime 	 DATETIME NOT NULL,
	Ip 	 VARCHAR (15) NOT NULL,
	OS		 VARCHAR (50) NULL,
	Browser	 VARCHAR (50) NULL,
	City 	 VARCHAR (50) NULL,
	Result 	 VARCHAR (50) NOT NULL,
	UserAgent		VARCHAR (2000) NULL
);

CREATE TABLE ResetUsers(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserName 		VARCHAR (50) NOT NULL,
	DisplayName 	VARCHAR (50) NOT NULL,
	Reason			VARCHAR (500) NOT NULL,
	ResetTime		DATETIME NOT NULL
);

CREATE TABLE Traces(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
 UserName 		VARCHAR (50) NOT NULL,
 LogTime 		DATETIME NOT NULL,
 IP 		VARCHAR (15) NOT NULL,
 Browser 		VARCHAR (50),
 OS 		VARCHAR (50),
 City 		VARCHAR (50),
 RequestUrl 		VARCHAR (500) NOT NULL,
	UserAgent		VARCHAR (2000) NULL
);

一键复制编辑原始数据按行查看历史

Argo Zhang 提交于 2019年04月30日 00:15 +08:00 . fix(#IW2JG): 菜单维护删除多个菜单时客户端报错

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184

CREATE TABLE Users (
 ID INTEGER PRIMARY KEY	Auto_increment,
 UserName NVARCHAR (50) NOT NULL,
 Password VARCHAR (50) NOT NULL,
 PassSalt VARCHAR (50) NOT NULL,
 DisplayName VARCHAR (50) NOT NULL,
 RegisterTime DATETIME NOT NULL,
 ApprovedTime DATETIME,
 ApprovedBy VARCHAR (50),
 Description VARCHAR (500) NOT NULL,
 RejectedBy VARCHAR (50),
 RejectedTime DATETIME,
 RejectedReason VARCHAR (50),
 Icon VARCHAR (50),
 Css VARCHAR (50),
	App			 VARCHAR (50)
);

CREATE TABLE UserRole (
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserID 			INT NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE UserGroup(
	ID 			INTEGER PRIMARY KEY	Auto_increment,
	UserID 			INT NOT NULL,
	GroupID 		INT NOT NULL
);

CREATE TABLE Roles(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	RoleName 		VARCHAR (50) NOT NULL,
	Description 	VARCHAR (500) NULL
);

CREATE TABLE RoleGroup(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	RoleID 			INT NOT NULL,
	GroupID 		INT NOT NULL
);

CREATE TABLE RoleApp(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	AppID 			VARCHAR (500) NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE Notifications(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	Category 		VARCHAR (50) NOT NULL,
	Title 			VARCHAR (50) NOT NULL,
	Content 		VARCHAR (50) NOT NULL,
	RegisterTime 	DATETIME NOT NULL,
	ProcessTime 	DATETIME NULL,
	ProcessBy 		VARCHAR (50) NULL,
	ProcessResult 	VARCHAR (50) NULL,
	Status 			VARCHAR (50) DEFAULT 0
);

CREATE TABLE Navigations(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	ParentId 		INT DEFAULT 0,
	Name 			VARCHAR (50) NOT NULL,
	`Order` 		INT NOT NULL DEFAULT 0,
	Icon 			VARCHAR (50) DEFAULT 'fa fa-fa',
	Url 			VARCHAR (4000) NULL,
	Category 		VARCHAR (50) DEFAULT 0,
	Target 			VARCHAR (10) DEFAULT '_self',
	IsResource 		INT DEFAULT 0,
	Application 	VARCHAR (200) DEFAULT 0
);

CREATE TABLE NavigationRole(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	NavigationID 	INT NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE Logs(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	CRUD 			VARCHAR (50) NOT NULL,
	UserName 		VARCHAR (50) NOT NULL,
	LogTime			DATETIME NOT NULL,
	Ip				VARCHAR (15) NOT NULL,
	Browser			VARCHAR (50) NULL,
	OS				VARCHAR (50) NULL,
	City			VARCHAR (50) NULL,
	RequestUrl		VARCHAR (500) NOT NULL,
	RequestData		MEDIUMTEXT NULL,
	UserAgent		VARCHAR (2000) NULL
);

CREATE TABLE `Groups`(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	GroupName 		VARCHAR (50) NOT NULL,
	Description 	VARCHAR (500) NULL
);

CREATE TABLE Exceptions(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	AppDomainName 	VARCHAR (50) NOT NULL,
	ErrorPage 		VARCHAR (50) NOT NULL,
	UserID 			VARCHAR (50) NULL,
	UserIp 			VARCHAR (15) NULL,
	ExceptionType 	TEXT NOT NULL,
	Message 		TEXT NOT NULL,
	StackTrace 		TEXT NULL,
	LogTime 		DATETIME NOT NULL,
	Category		VARCHAR (50) NULL
);

CREATE TABLE Dicts(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	Category 		VARCHAR (50) NOT NULL,
	Name 			VARCHAR (50) NOT NULL,
	Code 			VARCHAR (2000) NOT NULL,
	Define 			INT NOT NULL DEFAULT 1
);

CREATE TABLE Messages(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	Title 			VARCHAR (50) NOT NULL,
	Content 		VARCHAR (500) NOT NULL,
	`From` 			VARCHAR (50) NOT NULL,
	`To` 			VARCHAR (50) NOT NULL,
	SendTime 		DATETIME NOT NULL,
	Status 			VARCHAR (50) NOT NULL,
	Flag 			INT DEFAULT 0,
	IsDelete 		INT DEFAULT 0,
	Label 			VARCHAR (50)
);

CREATE TABLE Tasks(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	TaskName 		VARCHAR (500) NOT NULL,
	AssignName 		VARCHAR (50) NOT NULL,
	UserName 		VARCHAR (50) NOT NULL,
	TaskTime 		INT NOT NULL,
	TaskProgress 	INT NOT NULL,
	AssignTime 		DATETIME NOT NULL
);

CREATE TABLE RejectUsers(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserName 		VARCHAR (50) NOT NULL,
	DisplayName 	VARCHAR (50) NOT NULL,
	RegisterTime 	DATETIME NOT NULL,
	RejectedBy		VARCHAR (50) NOT NULL,
	RejectedTime	DATETIME NOT NULL,
	RejectedReason 	VARCHAR (50) NULL
);

CREATE TABLE LoginLogs(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserName 		VARCHAR (50) NOT NULL,
	LoginTime 	 DATETIME NOT NULL,
	Ip 	 VARCHAR (15) NOT NULL,
	OS		 VARCHAR (50) NULL,
	Browser	 VARCHAR (50) NULL,
	City 	 VARCHAR (50) NULL,
	Result 	 VARCHAR (50) NOT NULL,
	UserAgent		VARCHAR (2000) NULL
);

CREATE TABLE ResetUsers(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
	UserName 		VARCHAR (50) NOT NULL,
	DisplayName 	VARCHAR (50) NOT NULL,
	Reason			VARCHAR (500) NOT NULL,
	ResetTime		DATETIME NOT NULL
);

CREATE TABLE Traces(
	ID 				INTEGER PRIMARY KEY	Auto_increment,
 UserName 		VARCHAR (50) NOT NULL,
 LogTime 		DATETIME NOT NULL,
 IP 		VARCHAR (15) NOT NULL,
 Browser 		VARCHAR (50),
 OS 		VARCHAR (50),
 City 		VARCHAR (50),
 RequestUrl 		VARCHAR (500) NOT NULL,
	UserAgent		VARCHAR (2000) NULL
);