summaryrefslogtreecommitdiff
path: root/www/wiki/extensions/OATHAuth/sql/postgres/tables.sql
blob: 35dabedb37d40ac93dc73f882b9484cfa9ea0eac (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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;