36 lines
909 B
Markdown
36 lines
909 B
Markdown
|
CREATE TABLE users (
|
||
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
||
|
|
login TEXT UNIQUE NOT NULL,
|
||
|
|
password TEXT NOT NULL,
|
||
|
|
fullname TEXT,
|
||
|
|
superuser INTEGER NOT NULL DEFAULT 0
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE avatars (
|
||
|
|
id INTEGER PRIMARY KEY,
|
||
|
|
data BLOB,
|
||
|
|
FOREIGN KEY (id) REFERENCES users (id) ON DELETE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE metadatas (
|
||
|
|
id INTEGER PRIMARY KEY,
|
||
|
|
data TEXT NOT NULL,
|
||
|
|
FOREIGN KEY (id) REFERENCES users (id) ON DELETE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE sessions (
|
||
|
|
token TEXT PRIMARY KEY,
|
||
|
|
user_id INTEGER NOT NULL,
|
||
|
|
device TEXT,
|
||
|
|
address TEXT,
|
||
|
|
expires_at DATETIME NOT NULL,
|
||
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE invites (
|
||
|
|
token TEXT PRIMARY KEY,
|
||
|
|
uses INTEGER NOT NULL DEFAULT 1,
|
||
|
|
expires_at DATETIME NOT NULL,
|
||
|
|
created_at DATETIME NOT NULL CURRENT_TIMESTAMP,
|
||
|
|
);
|