add oauth_client.sql

archcentric · archcentric · commit 4e674533d67f · 2018-04-22T11:25:13.000+08:00
diff --git a/lab02/client-resttemplate/src/main/resources/db/oauth_client.sql b/lab02/client-resttemplate/src/main/resources/db/oauth_client.sql
@@ -0,0 +1,19 @@
+CREATE DATABASE clientdb;
+CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test';
+GRANT ALL PRIVILEGES ON clientdb.* TO 'testuser'@'localhost';
+
+use clientdb;
+
+create table client_user(
+    id bigint auto_increment primary key,
+    username varchar(100),
+    password varchar(50),
+    access_token varchar(100) NULL,
+    access_token_validity datetime NULL,
+    refresh_token varchar(100) NULL
+);
+
+insert into client_user
+(username, password)
+value
+('bobo', 'xyz');
