cms-worker/schema.sql at main · hunterashaw/cms-worker · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
drop table if exists users;
drop table if exists sessions;
drop table if exists documents;
drop table if exists cache;

create table users (
    email text primary key,
    key text,
    verification text,
    verification_expires_at number
) without rowid;
create unique index users_key on users (key);
insert into users (email, verification, verification_expires_at) values ('admin@example.com', '1234', 2000000000);

create table sessions (
    key text primary key,
    email text,
    expires_at integer
) without rowid;

create table documents (
    model text,
    name text,
    value text,
    modified_at integer,
    modified_by text,
    primary key (model, name)
);

create table cache (
    key text primary key,
    value text
);