You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 lines
1.1 KiB
40 lines
1.1 KiB
-- ############### |
|
-- create MySQL database , if need create, cancel the comment |
|
-- ############### |
|
-- create database if not exists oauth2_boot default character set utf8; |
|
-- use oauth2_boot set default character = utf8; |
|
|
|
-- ############### |
|
-- grant privileges to oauth2/oauth2 |
|
-- ############### |
|
-- GRANT ALL PRIVILEGES ON oauth2.* TO oauth2@localhost IDENTIFIED BY "oauth2"; |
|
|
|
-- ############### |
|
-- Domain: User |
|
-- ############### |
|
Drop table if exists user_; |
|
CREATE TABLE user_ ( |
|
id int(11) NOT NULL auto_increment, |
|
guid varchar(255) not null unique, |
|
create_time datetime , |
|
archived tinyint(1) default '0', |
|
email varchar(255), |
|
password varchar(255) not null, |
|
phone varchar(255), |
|
username varchar(255) not null unique, |
|
default_user tinyint(1) default '0', |
|
last_login_time datetime , |
|
PRIMARY KEY (id) |
|
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; |
|
|
|
|
|
-- ############### |
|
-- Domain: Privilege |
|
-- ############### |
|
Drop table if exists user_privilege; |
|
CREATE TABLE user_privilege ( |
|
user_id int(11), |
|
privilege varchar(255), |
|
KEY user_id_index (user_id) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
|
|
|