XBzCrXkb

1-- name: init#
2
3
4CREATE TABLE IF NOT EXISTS content {
5      content_id INTEGER PRIMARY KEY,
6      created REAL,
7      modified REAL,
8      name TEXT,
9      content TEXT,
10      media BLOB
11}
12
13CREATE TABLE IF NOT EXISTS nodes (
14      id INTEGER PRIMARY KEY,
15      uri text,
16      content_id INTEGER,
17      FOREIGN KEY (content_id) REFERENCES content (content_id)
18      );
19
20
21CREATE TABLE IF NOT EXISTS edges (
22      id INTEGER PRIMARY KEY,
23      uri text,
24      ref_0 INTEGER NOT NULL,
25      ref_1 INTEGER NOT null,
26      content_id INTEGER,
27      FOREIGN KEY (content_id) REFERENCES content (content_id)
28      FOREIGN KEY (ref_0) REFERENCES nodes (id),
29      FOREIGN KEY (ref_1) REFERENCES nodes (id),
30      );
31
32CREATE TABLE IF NOT EXISTS faces (
33      id INTEGER PRIMARY KEY,
34      uri text,
35      ref_0 INTEGER NOT NULL,
36      ref_1 INTEGER NOT NULL,
37      ref_2 INTEGER NOT NULL,
38      content_id INTEGER,
39      FOREIGN KEY (content_id) REFERENCES content (content_id)
40      FOREIGN KEY (ref_0) REFERENCES edges (id),
41      FOREIGN KEY (ref_1) REFERENCES edges (id),
42      FOREIGN KEY (ref_2) REFERENCES edges (id),
43      );
44
45
46CREATE TABLE IF NOT EXISTS solids (
47      id INTEGER PRIMARY KEY,
48      uri text,
49      ref_0 INTEGER NOT NULL,
50      ref_1 INTEGER NOT NULL,
51      ref_2 INTEGER NOT NULL,
52      ref_3 INTEGER NOT NULL,
53      content_id INTEGER,
54      FOREIGN KEY (content_id) REFERENCES content (content_id)
55      FOREIGN KEY (ref_0) REFERENCES faces (id),
56      FOREIGN KEY (ref_1) REFERENCES faces (id),
57      FOREIGN KEY (ref_2) REFERENCES faces (id),
58      FOREIGN KEY (ref_3) REFERENCES faces (id),
59      );
60
61