oficina / docs Public

Download this file

1	CREATE TABLE IF NOT EXISTS documents (
2	id INTEGER PRIMARY KEY,
3	sqid TEXT NOT NULL UNIQUE,
4	title TEXT NOT NULL,
5	guid TEXT NOT NULL,
6	client_id INTEGER NOT NULL,
7	created_at DATETIME NOT NULL,
8	updated_at DATETIME NOT NULL,
9	deleted_at DATETIME
10	);
11
12	CREATE TABLE IF NOT EXISTS doc_updates (
13	id INTEGER PRIMARY KEY,
14	doc_id INTEGER NOT NULL,
15	seq INTEGER NOT NULL,
16	update_bin BLOB NOT NULL,
17	created_at DATETIME NOT NULL
18	);
19