10 lines
309 B
Python
10 lines
309 B
Python
CREATE TABLE api_tokens (
|
|
id SERIAL PRIMARY KEY,
|
|
email TEXT REFERENCES accounts(email) ON DELETE RESTRICT,
|
|
name TEXT NOT NULL,
|
|
created TIMESTAMP NOT NULL DEFAULT NOW(),
|
|
token TEXT NOT NULL
|
|
);
|
|
|
|
UPDATE schemaversion SET version = 17;
|