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