mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-08 15:00:37 -04:00
24 lines
425 B
SQL
24 lines
425 B
SQL
-- Up
|
|
|
|
CREATE TABLE users (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
username TEXT NOT NULL,
|
|
email TEXT NOT NULL,
|
|
roles TEXT NOT NULL,
|
|
avatarSource TEXT
|
|
);
|
|
|
|
CREATE TABLE authenticators (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
userId TEXT,
|
|
type TEXT NOT NULL,
|
|
payload TEXT NOT NULL,
|
|
validUntil INTEGER,
|
|
FOREIGN KEY(userId) REFERENCES users(id)
|
|
);
|
|
|
|
-- Down
|
|
|
|
DROP TABLE authenticators;
|
|
DROP TABLE users;
|