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),
    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(1000)) USING BTREE;
CREATE INDEX user_id_idx ON core_oauth_clients (user_id) USING BTREE;
