12 lines
303 B
SQL
12 lines
303 B
SQL
-- Add migration script here
|
|
|
|
CREATE TABLE IF NOT EXISTS api_keys
|
|
(
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
user_id INTEGER NOT NULL REFERENCES users(id),
|
|
token TEXT NOT NULL,
|
|
name TEXT NOT NULL,
|
|
expiration_date DATE NOT NULL,
|
|
permissions TEXT NOT NULL,
|
|
revoked BOOLEAN NOT NULL
|
|
);
|