Debian Codegraph @

share/database-schema/sqlite-create.sql

raw
1 CREATE TABLE IF NOT EXISTS attean_version (
2 attean_version VARCHAR(16),
3 store_version VARCHAR(16),
4 created DATETIME DEFAULT CURRENT_TIMESTAMP,
5 updated DATETIME DEFAULT CURRENT_TIMESTAMP
6 );
7
8 CREATE TABLE IF NOT EXISTS term (
9 term_id INTEGER PRIMARY KEY,
10 type CHAR(7),
11 datatype_id BIGINT REFERENCES term(term_id),
12 value LONGTEXT NOT NULL,
13 language TEXT
14 );
15
16 CREATE UNIQUE INDEX term_idx ON term (type, datatype_id, language, value);
17
18 CREATE TABLE IF NOT EXISTS quad (
19 subject BIGINT NOT NULL REFERENCES term,
20 predicate BIGINT NOT NULL REFERENCES term,
21 object BIGINT NOT NULL REFERENCES term,
22 graph BIGINT NOT NULL REFERENCES term,
23 PRIMARY KEY (subject, predicate, object, graph)
24 );
25
26 CREATE INDEX quad_pogs_idx ON quad (predicate,object,graph,subject);
27 CREATE INDEX quad_g ON quad (graph);