1 files changed, 15 insertions, 0 deletions
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