diff options
| author | Yaco <franco@reevo.org> | 2020-06-04 11:01:00 -0300 |
|---|---|---|
| committer | Yaco <franco@reevo.org> | 2020-06-04 11:01:00 -0300 |
| commit | fc7369835258467bf97eb64f184b93691f9a9fd5 (patch) | |
| tree | daabd60089d2dd76d9f5fb416b005fbe159c799d /www/wiki/extensions/OATHAuth/sql | |
first commit
Diffstat (limited to 'www/wiki/extensions/OATHAuth/sql')
5 files changed, 63 insertions, 0 deletions
diff --git a/www/wiki/extensions/OATHAuth/sql/mssql/tables.sql b/www/wiki/extensions/OATHAuth/sql/mssql/tables.sql new file mode 100644 index 00000000..f4db281c --- /dev/null +++ b/www/wiki/extensions/OATHAuth/sql/mssql/tables.sql @@ -0,0 +1,10 @@ +CREATE TABLE /*_*/oathauth_users ( + -- User ID + id INT NOT NULL PRIMARY KEY IDENTITY(0,1), + + -- Secret key + secret NVARCHAR(255) NULL DEFAULT NULL, + + -- Scratch tokens + scratch_tokens varbinary(511) NULL DEFAULT NULL +); diff --git a/www/wiki/extensions/OATHAuth/sql/mysql/patch-remove_reset.sql b/www/wiki/extensions/OATHAuth/sql/mysql/patch-remove_reset.sql new file mode 100644 index 00000000..6b37a344 --- /dev/null +++ b/www/wiki/extensions/OATHAuth/sql/mysql/patch-remove_reset.sql @@ -0,0 +1,8 @@ +ALTER TABLE /*_*/oathauth_users + DROP COLUMN secret_reset; + +ALTER TABLE /*_*/oathauth_users + DROP COLUMN scratch_tokens_reset; + +ALTER TABLE /*_*/oathauth_users + DROP COLUMN is_validated; diff --git a/www/wiki/extensions/OATHAuth/sql/mysql/tables.sql b/www/wiki/extensions/OATHAuth/sql/mysql/tables.sql new file mode 100644 index 00000000..1d531f04 --- /dev/null +++ b/www/wiki/extensions/OATHAuth/sql/mysql/tables.sql @@ -0,0 +1,11 @@ +CREATE TABLE /*_*/oathauth_users ( + -- User ID + id int not null primary key, + + -- Secret key + secret varbinary(255) null, + + -- Scratch tokens + scratch_tokens varbinary(511) null + +) /*$wgDBTableOptions*/; diff --git a/www/wiki/extensions/OATHAuth/sql/oracle/tables.sql b/www/wiki/extensions/OATHAuth/sql/oracle/tables.sql new file mode 100644 index 00000000..51bf328a --- /dev/null +++ b/www/wiki/extensions/OATHAuth/sql/oracle/tables.sql @@ -0,0 +1,15 @@ +define mw_prefix='{$wgDBprefix}'; + +CREATE SEQUENCE oathauth_users_id_seq; +CREATE TABLE &mw_prefix.oathauth_users ( + -- User ID + id NUMBER NOT NULL, + + -- Secret key + secret VARCHAR2(255) NULL, + + -- Scratch tokens + scratch_tokens varbinary(511) NULL + +); +ALTER TABLE &mw_prefix.oathauth_users ADD CONSTRAINT &mw_prefix.oathauth_users_pk PRIMARY KEY (id);
\ No newline at end of file diff --git a/www/wiki/extensions/OATHAuth/sql/postgres/tables.sql b/www/wiki/extensions/OATHAuth/sql/postgres/tables.sql new file mode 100644 index 00000000..35dabedb --- /dev/null +++ b/www/wiki/extensions/OATHAuth/sql/postgres/tables.sql @@ -0,0 +1,19 @@ +BEGIN; +SET client_min_messages = 'ERROR'; + +DROP SEQUENCE IF EXISTS oathauth_users_id_seq CASCADE; + +CREATE SEQUENCE oathauth_users_id_seq MINVALUE 0 START WITH 0; +CREATE TABLE oathauth_users ( + -- User ID + id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('oathauth_users_id_seq'), + + -- Secret key + secret TEXT NULL, + + -- Scratch tokens + scratch_tokens TEXT NULL + +); + +COMMIT;
\ No newline at end of file |