sql/core_oauth_access_tokens.sql

sql/core_oauth_authorization_codes.sql
sql/core_oauth_clients.sql
sql/core_oauth_jwt.sql
sql/core_oauth_refresh_tokens.sql
sql/core_oauth_scopes.sql
sql/core_oauth_users.sql

diff --git a/sql/Projects.sql b/sql/Projects.sql
deleted file mode 100644 (file)
index 16df2f8..0000000
--- a/sql/Projects.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-
-CREATE TABLE Projects (
-  id int(11) NOT NULL auto_increment,
-  PRIMARY KEY  (id)
-  
-) ;
-
-
-
-ALTER TABLE  Projects  ADD COLUMN name varchar(254)  NOT NULL  DEFAULT '';
-ALTER TABLE  Projects  ADD COLUMN   remarks text ;
-ALTER TABLE  Projects  ADD COLUMN   owner_id int(11) default NULL;
-ALTER TABLE  Projects  ADD COLUMN   code varchar(32)  NOT NULL  DEFAULT '';
-ALTER TABLE  Projects  ADD COLUMN   active int(11) default '1';
-ALTER TABLE  Projects  ADD COLUMN   type varchar(1)  NOT NULL default 'P';
-ALTER TABLE  Projects  ADD COLUMN   client_id int(11) NOT NULL default '0';
-ALTER TABLE  Projects  ADD COLUMN   team_id int(11) NOT NULL default '0';
-ALTER TABLE  Projects  ADD COLUMN file_location varchar(254)    NOT NULL default '';
-ALTER TABLE  Projects  ADD COLUMN open_date date default NULL;
-ALTER TABLE  Projects  ADD COLUMN open_by int(11) NOT NULL default '0';
-ALTER TABLE  Projects  ADD COLUMN updated_dt DATETIME NOT NULL;
-
--- these should be removed, as they are code specific..
-ALTER TABLE Projects ADD COLUMN countries varchar(128)  NOT NULL DEFAULT '';
-ALTER TABLE Projects  ADD COLUMN languages varchar(128)  NOT NULL DEFAULT '';
-ALTER TABLE  Projects ADD COLUMN agency_id int(11)  NOT NULL DEFAULT 0 ;
-
-ALTER TABLE Projects ADD INDEX plookup (code);
- 
\ No newline at end of file

diff --git a/sql/core_oauth_access_tokens.sql b/sql/core_oauth_access_tokens.sql
deleted file mode 100644 (file)
index 98663b3..0000000
--- a/sql/core_oauth_access_tokens.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE core_oauth_access_tokens (
-    id INT(11) NOT NULL AUTO_INCREMENT,
-    access_token VARCHAR(40) NOT NULL, 
-    client_id VARCHAR(80) NOT NULL, 
-    user_id VARCHAR(255), 
-    expires TIMESTAMP NOT NULL, 
-    scope VARCHAR(2000), 
-    PRIMARY KEY (id)
-);
-
-CREATE INDEX access_token_idx ON core_oauth_access_tokens (access_token) USING BTREE;
-CREATE INDEX client_id_idx ON core_oauth_access_tokens (client_id) USING BTREE;
-CREATE INDEX user_id_idx ON core_oauth_access_tokens (user_id) USING BTREE;
-
- 
\ No newline at end of file

diff --git a/sql/core_oauth_authorization_codes.sql b/sql/core_oauth_authorization_codes.sql
deleted file mode 100644 (file)
index e9e25db..0000000
--- a/sql/core_oauth_authorization_codes.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE TABLE core_oauth_authorization_codes (
-    id INT(11) NOT NULL AUTO_INCREMENT,
-    authorization_code VARCHAR(40) NOT NULL, 
-    client_id VARCHAR(80) NOT NULL, 
-    user_id VARCHAR(255), 
-    redirect_uri VARCHAR(2000), 
-    expires TIMESTAMP NOT NULL, 
-    scope VARCHAR(2000),
-    PRIMARY KEY (id)
-);
-
-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(1000)) USING BTREE;

diff --git a/sql/core_oauth_clients.sql b/sql/core_oauth_clients.sql
deleted file mode 100644 (file)
index 26f9911..0000000
--- a/sql/core_oauth_clients.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-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;

diff --git a/sql/core_oauth_jwt.sql b/sql/core_oauth_jwt.sql
deleted file mode 100644 (file)
index 36a9552..0000000
--- a/sql/core_oauth_jwt.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-CREATE TABLE core_oauth_jwt (
-    id INT(11) NOT NULL AUTO_INCREMENT,
-    client_id VARCHAR(80) NOT NULL, 
-    subject VARCHAR(80), 
-    public_key VARCHAR(2000),
-    PRIMARY KEY (id)
-);
-
-CREATE INDEX client_id_idx ON core_oauth_jwt (client_id) USING BTREE;
-CREATE INDEX public_key_idx ON core_oauth_jwt (public_key(1000)) USING BTREE;
- 
\ No newline at end of file

diff --git a/sql/core_oauth_refresh_tokens.sql b/sql/core_oauth_refresh_tokens.sql
deleted file mode 100644 (file)
index f86fe63..0000000
--- a/sql/core_oauth_refresh_tokens.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-CREATE TABLE core_oauth_refresh_tokens (
-    id INT(11) NOT NULL AUTO_INCREMENT,
-    refresh_token VARCHAR(40) NOT NULL, 
-    client_id VARCHAR(80) NOT NULL, 
-    user_id VARCHAR(255), 
-    expires TIMESTAMP NOT NULL, 
-    scope VARCHAR(2000),
-    PRIMARY KEY (id)
-);
-
-CREATE INDEX refresh_token_idx ON core_oauth_refresh_tokens (refresh_token) USING BTREE;
-CREATE INDEX client_id_idx ON core_oauth_refresh_tokens (client_id) USING BTREE;
-CREATE INDEX user_id_idx ON core_oauth_refresh_tokens (user_id) USING BTREE;
- 
\ No newline at end of file

diff --git a/sql/core_oauth_scopes.sql b/sql/core_oauth_scopes.sql
deleted file mode 100644 (file)
index bf715bb..0000000
--- a/sql/core_oauth_scopes.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-CREATE TABLE core_oauth_scopes (
-    id INT(11) NOT NULL AUTO_INCREMENT,
-    scope TEXT, 
-    is_default BOOLEAN,
-    PRIMARY KEY (id)
-);
-
- 
\ No newline at end of file

diff --git a/sql/core_oauth_users.sql b/sql/core_oauth_users.sql
deleted file mode 100644 (file)
index 9760db3..0000000
--- a/sql/core_oauth_users.sql
+++ /dev/null
@@ -1,11 +0,0 @@
--- CREATE TABLE core_oauth_users (
---     id INT(11) NOT NULL AUTO_INCREMENT,
---     username VARCHAR(255) NOT NULL, 
---     password VARCHAR(2000), 
---     first_name VARCHAR(255), 
---     last_name VARCHAR(255),
---     PRIMARY KEY (id)
--- );
--- 
--- CREATE INDEX username_idx ON core_oauth_users (username) USING BTREE;
--- CREATE INDEX password_idx ON core_oauth_users (password) USING BTREE;
\ No newline at end of file

diff --git a/sql/core_projects.sql b/sql/core_projects.sql
deleted file mode 100644 (file)
index 16df2f8..0000000
--- a/sql/core_projects.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-
-CREATE TABLE Projects (
-  id int(11) NOT NULL auto_increment,
-  PRIMARY KEY  (id)
-  
-) ;
-
-
-
-ALTER TABLE  Projects  ADD COLUMN name varchar(254)  NOT NULL  DEFAULT '';
-ALTER TABLE  Projects  ADD COLUMN   remarks text ;
-ALTER TABLE  Projects  ADD COLUMN   owner_id int(11) default NULL;
-ALTER TABLE  Projects  ADD COLUMN   code varchar(32)  NOT NULL  DEFAULT '';
-ALTER TABLE  Projects  ADD COLUMN   active int(11) default '1';
-ALTER TABLE  Projects  ADD COLUMN   type varchar(1)  NOT NULL default 'P';
-ALTER TABLE  Projects  ADD COLUMN   client_id int(11) NOT NULL default '0';
-ALTER TABLE  Projects  ADD COLUMN   team_id int(11) NOT NULL default '0';
-ALTER TABLE  Projects  ADD COLUMN file_location varchar(254)    NOT NULL default '';
-ALTER TABLE  Projects  ADD COLUMN open_date date default NULL;
-ALTER TABLE  Projects  ADD COLUMN open_by int(11) NOT NULL default '0';
-ALTER TABLE  Projects  ADD COLUMN updated_dt DATETIME NOT NULL;
-
--- these should be removed, as they are code specific..
-ALTER TABLE Projects ADD COLUMN countries varchar(128)  NOT NULL DEFAULT '';
-ALTER TABLE Projects  ADD COLUMN languages varchar(128)  NOT NULL DEFAULT '';
-ALTER TABLE  Projects ADD COLUMN agency_id int(11)  NOT NULL DEFAULT 0 ;
-
-ALTER TABLE Projects ADD INDEX plookup (code);
- 
\ No newline at end of file