DatabaseScripts/SQLite/Install.sql · wei/BootstrapAdmin

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 1.5K

wei/BootstrapAdmin

forked from LongbowEnterprise/BootstrapAdmin

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (4)

Tags (2)

Manage

master

dev

dev-Tabs

dev-cpsy

v2.0.0

v1.0.0

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

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

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

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

Password for 'https://userName@gitee.com': # Private Token

Branches 4

Tags 2

BootstrapAdmin

DatabaseScripts

SQLite

Install.sql

Install.sql 4.66 KB

CREATE TABLE Users (
 ID INTEGER PRIMARY KEY,
 UserName NVARCHAR (50) NOT NULL COLLATE NOCASE,
 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) COLLATE NOCASE,
 RejectedTime DATETIME,
 RejectedReason VARCHAR (50),
 Icon VARCHAR (50),
 Css VARCHAR (50),
 App VARCHAR (50) 
);

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

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

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

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

CREATE TABLE RoleApp(
	ID 		INTEGER PRIMARY KEY,
	AppID 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	RoleID 	INT NOT NULL
);

CREATE TABLE Notifications(
	ID 				INTEGER PRIMARY KEY,
	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,
	ParentId 	INT DEFAULT (0),
	Name 		VARCHAR (50) NOT NULL,
	[Order] 	INT NOT NULL DEFAULT (0),
	Icon 		VARCHAR (50) DEFAULT none,
	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,
	NavigationID INT NOT NULL,
	RoleID INT NOT NULL
);

CREATE TABLE Logs(
	ID 			INTEGER PRIMARY KEY,
	CRUD 		VARCHAR (50) NOT NULL,
	UserName 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	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 TEXT		 NULL,
	UserAgent	VARCHAR (2000) NULL
);

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

CREATE TABLE Exceptions(
	ID 				INTEGER PRIMARY KEY,
	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,
	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,
	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,
	TaskName 		VARCHAR (500) NOT NULL COLLATE NOCASE,
	AssignName 		VARCHAR (50) NOT NULL COLLATE NOCASE,
	UserName 		VARCHAR (50) NOT NULL COLLATE NOCASE,
	TaskTime 		INT NOT NULL,
	TaskProgress	INT NOT NULL,
	AssignTime 		DATETIME NOT NULL
);

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

CREATE TABLE LoginLogs(
	ID 			INTEGER PRIMARY KEY,
	UserName 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	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,
	UserName 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	DisplayName VARCHAR (50) NOT NULL,
	Reason 		VARCHAR (500) NOT NULL,
	ResetTime 	DATETIME NOT NULL
);

CREATE TABLE Traces(
 ID INTEGER PRIMARY KEY,
 UserName VARCHAR (50) NOT NULL COLLATE NOCASE,
 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)
);

Copy Edit Raw Blame History

Argo Zhang authored 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,
 UserName NVARCHAR (50) NOT NULL COLLATE NOCASE,
 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) COLLATE NOCASE,
 RejectedTime DATETIME,
 RejectedReason VARCHAR (50),
 Icon VARCHAR (50),
 Css VARCHAR (50),
 App VARCHAR (50) 
);

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

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

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

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

CREATE TABLE RoleApp(
	ID 		INTEGER PRIMARY KEY,
	AppID 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	RoleID 	INT NOT NULL
);

CREATE TABLE Notifications(
	ID 				INTEGER PRIMARY KEY,
	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,
	ParentId 	INT DEFAULT (0),
	Name 		VARCHAR (50) NOT NULL,
	[Order] 	INT NOT NULL DEFAULT (0),
	Icon 		VARCHAR (50) DEFAULT none,
	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,
	NavigationID INT NOT NULL,
	RoleID INT NOT NULL
);

CREATE TABLE Logs(
	ID 			INTEGER PRIMARY KEY,
	CRUD 		VARCHAR (50) NOT NULL,
	UserName 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	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 TEXT		 NULL,
	UserAgent	VARCHAR (2000) NULL
);

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

CREATE TABLE Exceptions(
	ID 				INTEGER PRIMARY KEY,
	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,
	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,
	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,
	TaskName 		VARCHAR (500) NOT NULL COLLATE NOCASE,
	AssignName 		VARCHAR (50) NOT NULL COLLATE NOCASE,
	UserName 		VARCHAR (50) NOT NULL COLLATE NOCASE,
	TaskTime 		INT NOT NULL,
	TaskProgress	INT NOT NULL,
	AssignTime 		DATETIME NOT NULL
);

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

CREATE TABLE LoginLogs(
	ID 			INTEGER PRIMARY KEY,
	UserName 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	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,
	UserName 	VARCHAR (50) NOT NULL COLLATE NOCASE,
	DisplayName VARCHAR (50) NOT NULL,
	Reason 		VARCHAR (500) NOT NULL,
	ResetTime 	DATETIME NOT NULL
);

CREATE TABLE Traces(
 ID INTEGER PRIMARY KEY,
 UserName VARCHAR (50) NOT NULL COLLATE NOCASE,
 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)
);