DatabaseScripts/Postgresql/install.sql · longxiang/BootstrapAdmin

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

richgiteeai

Watch

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

1 Star 0 Fork 1.5K

longxiang/BootstrapAdmin

forked from LongbowEnterprise/BootstrapAdmin

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

服务

加入 Gitee

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

免费加入

已有帐号? 立即登录

文件

master

分支 (5)

标签 (2)

管理

master

dev

dev-Localization

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': # 私人令牌

分支 5

标签 2

BootstrapAdmin

DatabaseScripts

Postgresql

install.sql

install.sql 4.47 KB

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

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

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

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

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

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

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

CREATE TABLE Navigations(
	ID 				SERIAL PRIMARY KEY,
	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 				SERIAL PRIMARY KEY,
	NavigationID 	INT NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE Logs(
	ID 				SERIAL PRIMARY KEY,
	CRUD 			VARCHAR (50) NOT NULL,
	UserName 		VARCHAR (50) NOT NULL,
	LogTime			DATE 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 				SERIAL PRIMARY KEY,
	GroupName 		VARCHAR (50) NOT NULL,
	Description 	VARCHAR (500) NULL
);

CREATE TABLE Exceptions(
	ID 				SERIAL 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 		DATE NOT NULL,
	Category		VARCHAR (50) NULL
);

CREATE TABLE Dicts(
	ID 				SERIAL 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 				SERIAL PRIMARY KEY,
	Title 			VARCHAR (50) NOT NULL,
	Content 		VARCHAR (500) NOT NULL,
	"from" 			VARCHAR (50) NOT NULL,
	"to" 			VARCHAR (50) NOT NULL,
	SendTime 		DATE NOT NULL,
	Status 			VARCHAR (50) NOT NULL,
	Flag 			INT DEFAULT 0,
	IsDelete 		INT DEFAULT 0,
	Label 			VARCHAR (50)
);

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

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

CREATE TABLE RejectUsers(
	ID 				SERIAL PRIMARY KEY,
	UserName 		VARCHAR (50) NOT NULL,
	LoginTime 	 DATE NOT NULL,
	Ip 	 VARCHAR 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 				SERIAL PRIMARY KEY,
	UserName 		VARCHAR (50) NOT NULL,
	DisplayName 	VARCHAR (50) NOT NULL,
	Reason			VARCHAR (500) NOT NULL,
	ResetTime		DATE NOT NULL
);

CREATE TABLE Traces(
	ID 				SERIAL PRIMARY KEY,
 UserName 		VARCHAR (50) NOT NULL,
 LogTime 		DATE 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年05月18日 16:14 +08:00 . doc(user): 更新数据库脚本User表UserName列设置为16

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 SERIAL PRIMARY KEY,
 UserName VARCHAR (16) NOT NULL,
 Password VARCHAR (50) NOT NULL,
 PassSalt VARCHAR (50) NOT NULL,
 DisplayName VARCHAR (50) NOT NULL,
 RegisterTime DATE NOT NULL,
 ApprovedTime DATE,
 ApprovedBy VARCHAR (50),
 Description VARCHAR (500) NOT NULL,
 RejectedBy VARCHAR (50),
 RejectedTime DATE,
 RejectedReason VARCHAR (50),
 Icon VARCHAR (50),
 Css VARCHAR (50),
	App			 VARCHAR (50)
);

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

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

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

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

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

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

CREATE TABLE Navigations(
	ID 				SERIAL PRIMARY KEY,
	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 				SERIAL PRIMARY KEY,
	NavigationID 	INT NOT NULL,
	RoleID 			INT NOT NULL
);

CREATE TABLE Logs(
	ID 				SERIAL PRIMARY KEY,
	CRUD 			VARCHAR (50) NOT NULL,
	UserName 		VARCHAR (50) NOT NULL,
	LogTime			DATE 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 				SERIAL PRIMARY KEY,
	GroupName 		VARCHAR (50) NOT NULL,
	Description 	VARCHAR (500) NULL
);

CREATE TABLE Exceptions(
	ID 				SERIAL 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 		DATE NOT NULL,
	Category		VARCHAR (50) NULL
);

CREATE TABLE Dicts(
	ID 				SERIAL 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 				SERIAL PRIMARY KEY,
	Title 			VARCHAR (50) NOT NULL,
	Content 		VARCHAR (500) NOT NULL,
	"from" 			VARCHAR (50) NOT NULL,
	"to" 			VARCHAR (50) NOT NULL,
	SendTime 		DATE NOT NULL,
	Status 			VARCHAR (50) NOT NULL,
	Flag 			INT DEFAULT 0,
	IsDelete 		INT DEFAULT 0,
	Label 			VARCHAR (50)
);

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

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

CREATE TABLE RejectUsers(
	ID 				SERIAL PRIMARY KEY,
	UserName 		VARCHAR (50) NOT NULL,
	LoginTime 	 DATE NOT NULL,
	Ip 	 VARCHAR 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 				SERIAL PRIMARY KEY,
	UserName 		VARCHAR (50) NOT NULL,
	DisplayName 	VARCHAR (50) NOT NULL,
	Reason			VARCHAR (500) NOT NULL,
	ResetTime		DATE NOT NULL
);

CREATE TABLE Traces(
	ID 				SERIAL PRIMARY KEY,
 UserName 		VARCHAR (50) NOT NULL,
 LogTime 		DATE 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
);