43 lines
883 B
SQL
43 lines
883 B
SQL
CREATE TABLE users (
|
|
id text primary key,
|
|
created integer,
|
|
user text not null,
|
|
password blob not null,
|
|
salt blob not null
|
|
);
|
|
|
|
CREATE TABLE tokens (
|
|
id text primary key,
|
|
uid text not null,
|
|
token text not null,
|
|
expires integer default 0,
|
|
FOREIGN KEY(uid) REFERENCES user(id)
|
|
);
|
|
|
|
CREATE TABLE database (
|
|
id text primary key,
|
|
host text not null,
|
|
port integer default 5432,
|
|
name text not null,
|
|
user text not null,
|
|
password text not null
|
|
);
|
|
|
|
CREATE TABLE registrations (
|
|
id text primary key,
|
|
code text not null
|
|
);
|
|
|
|
CREATE TABLE roles (
|
|
id text primary key,
|
|
role text not null
|
|
);
|
|
|
|
CREATE TABLE user_roles (
|
|
id text primary key,
|
|
uid text not null,
|
|
rid text not null,
|
|
FOREIGN KEY(uid) REFERENCES user(id),
|
|
FOREIGN KEY(rid) REFERENCES roles(id)
|
|
);
|