sql/core_oauth_authorization_codes.sql

sql/core_oauth_clients.sql

diff --git a/sql/core_oauth_authorization_codes.sql b/sql/core_oauth_authorization_codes.sql
index 62ec219..e9e25db 100644 (file)
--- a/sql/core_oauth_authorization_codes.sql
+++ b/sql/core_oauth_authorization_codes.sql
@@ -12,4 +12,4 @@ CREATE TABLE core_oauth_authorization_codes (
 CREATE INDEX authorization_code_idx ON core_oauth_authorization_codes (authorization_code) USING BTREE;
 CREATE INDEX client_id_idx ON core_oauth_authorization_codes (client_id) USING BTREE;
 CREATE INDEX user_id_idx ON core_oauth_authorization_codes (user_id) USING BTREE;
-CREATE INDEX redirect_uri_idx ON core_oauth_authorization_codes (redirect_uri) USING BTREE;
\ No newline at end of file
+CREATE INDEX redirect_uri_idx ON core_oauth_authorization_codes (redirect_uri(1000)) USING BTREE;

diff --git a/sql/core_oauth_clients.sql b/sql/core_oauth_clients.sql
index 5881bc2..26f9911 100644 (file)
--- a/sql/core_oauth_clients.sql
+++ b/sql/core_oauth_clients.sql
@@ -11,6 +11,5 @@ CREATE TABLE core_oauth_clients (
 
 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 redirect_uri_idx ON core_oauth_clients (redirect_uri(1000)) USING BTREE;
 CREATE INDEX user_id_idx ON core_oauth_clients (user_id) USING BTREE;
- 
\ No newline at end of file