-
Notifications
You must be signed in to change notification settings - Fork 21
Expand file tree
/
Copy pathinit.sql
More file actions
executable file
·85 lines (77 loc) · 1.81 KB
/
Copy pathinit.sql
File metadata and controls
executable file
·85 lines (77 loc) · 1.81 KB
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
CREATE TABLE document_entity (
id TEXT PRIMARY KEY,
title TEXT NOT NULL,
created_at BIGINT NOT NULL,
last_updated_at BIGINT NOT NULL,
last_synced BIGINT NOT NULL,
workspace_id TEXT NOT NULL,
favorite BOOLEAN NOT NULL,
parent_document_id TEXT NOT NULL,
icon TEXT,
icon_tint INTEGER,
is_locked BOOLEAN NOT NULL,
company_id TEXT NULL,
deleted BOOLEAN NOT NULL
);
CREATE TABLE story_step_entity (
id TEXT PRIMARY KEY,
local_id TEXT NOT NULL,
type INTEGER NOT NULL,
parent_id TEXT,
url TEXT,
path TEXT,
text TEXT,
checked BOOLEAN NOT NULL,
position INTEGER NOT NULL,
document_id TEXT NOT NULL,
is_group BOOLEAN NOT NULL,
has_inner_steps BOOLEAN NOT NULL,
background_color INTEGER,
tags TEXT NOT NULL,
spans TEXT NOT NULL,
link_to_document TEXT
);
CREATE TABLE user_entity (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
created_at BIGINT NOT NULL,
email TEXT NOT NULL UNIQUE,
password TEXT NOT NULL,
salt TEXT NOT NULL,
enabled BOOLEAN NOT NULL
);
CREATE TABLE company_entity (
domain TEXT PRIMARY KEY,
name TEXT NOT NULL
);
CREATE TABLE workspace_entity (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
icon TEXT,
icon_tint INTEGER
);
CREATE TABLE folder_entity (
id TEXT PRIMARY KEY,
parent_id TEXT NOT NULL,
workspace_id TEXT NOT NULL,
title TEXT NOT NULL,
created_at INTEGER NOT NULL,
last_updated_at BIGINT NOT NULL,
last_synced_at BIGINT,
favorite BOOLEAN NOT NULL,
icon TEXT,
icon_tint INTEGER
);
CREATE TABLE workspace_to_user (
workspace_id TEXT NOT NULL,
user_id TEXT NOT NULL,
role TEXT NOT NULL,
PRIMARY KEY(workspace_id, user_id)
);
CREATE TABLE user_favorite_entity (
user_id TEXT NOT NULL,
document_id TEXT NOT NULL,
workspace_id TEXT NOT NULL,
created_at INTEGER NOT NULL,
PRIMARY KEY (user_id, document_id)
);