aq2nH3uC

1CREATE TABLE IF NOT EXISTS nodes (
2      id INTEGER PRIMARY KEY,
3      uri text,
4      created real NOT NULL,
5      modified real NOT NULL,
6      name text NOT NULL UNIQUE,
7      content text,
8      mass real,
9      energy real
10      );
11
12
13CREATE TABLE IF NOT EXISTS edges (
14      id INTEGER PRIMARY KEY,
15      uri text,
16      ref_0 INTEGER NOT NULL,
17      ref_1 INTEGER NOT null,
18      created real NOT NULL,
19      modified real NOT NULL,
20      name text NOT NULL UNIQUE,
21      content text,
22      mass real,
23      energy real,
24      FOREIGN KEY (ref_0) REFERENCES nodes (id),
25      FOREIGN KEY (ref_1) REFERENCES nodes (id),
26      );
27
28CREATE TABLE IF NOT EXISTS faces (
29      id INTEGER PRIMARY KEY,
30      uri text,
31      ref_0 INTEGER NOT NULL,
32      ref_1 INTEGER NOT NULL,
33      ref_2 INTEGER NOT NULL,
34      created real NOT NULL,
35      modified real NOT NULL,
36      name text NOT NULL UNIQUE,
37      content text,
38      mass real,
39      energy real,
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      created real NOT NULL,
54      modified real NOT NULL,
55      name text NOT NULL UNIQUE,
56      content text,
57      mass real,
58      energy real,
59      FOREIGN KEY (ref_0) REFERENCES faces (id),
60      FOREIGN KEY (ref_1) REFERENCES faces (id),
61      FOREIGN KEY (ref_2) REFERENCES faces (id),
62      );
63
64