sql/core_oauth_clients.sql

[Pman.Core] / sql / core_oauth_clients.sql

diff --git a/sql/core_oauth_clients.sql b/sql/core_oauth_clients.sql
index 20a3529..5881bc2 100644 (file)
--- a/sql/core_oauth_clients.sql
+++ b/sql/core_oauth_clients.sql
@@ -1,10 +1,16 @@
-CREATE TABLE oauth_clients (
+CREATE TABLE core_oauth_clients (
+    id INT(11) NOT NULL AUTO_INCREMENT,
     client_id VARCHAR(80) NOT NULL,
     client_secret VARCHAR(80) NOT NULL, 
     redirect_uri VARCHAR(2000) NOT NULL, 
     grant_types VARCHAR(80), 
     scope VARCHAR(100), 
-    user_id VARCHAR(80), 
-    CONSTRAINT client_id_pk 
-    PRIMARY KEY (client_id)
+    user_id VARCHAR(80),
+    PRIMARY KEY (id)
 );
+
+CREATE INDEX client_id_idx ON core_oauth_clients (client_id) USING BTREE;
+CREATE INDEX client_secret_idx ON core_oauth_clients (client_secret) USING BTREE;
+CREATE INDEX redirect_uri_idx ON core_oauth_clients (redirect_uri) USING BTREE;
+CREATE INDEX user_id_idx ON core_oauth_clients (user_id) USING BTREE;
+ 
\ No newline at end of file