1CREATE TABLE IF NOT EXISTS objects (
2 id BLOB PRIMARY KEY,
3 kind TEXT NOT NULL,
4 data BLOB NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS bookmarks (
8 name TEXT PRIMARY KEY,
9 commit_id BLOB NOT NULL REFERENCES objects(id),
10 remote TEXT
11);
12
13CREATE TABLE IF NOT EXISTS phases (
14 commit_id BLOB PRIMARY KEY REFERENCES objects(id),
15 phase INTEGER NOT NULL
16);
17
18CREATE TABLE IF NOT EXISTS changes (
19 change_id TEXT PRIMARY KEY,
20 commit_id BLOB REFERENCES objects(id)
21);
22
23CREATE TABLE IF NOT EXISTS pack_index (
24 blob_id BLOB PRIMARY KEY,
25 pack_file TEXT NOT NULL,
26 offset INTEGER NOT NULL,
27 raw_size INTEGER NOT NULL
28);
29
30CREATE TABLE IF NOT EXISTS wcache (
31 path TEXT PRIMARY KEY,
32 inode INTEGER NOT NULL,
33 mtime_ns INTEGER NOT NULL,
34 size INTEGER NOT NULL,
35 blob_id BLOB NOT NULL
36);
37
38CREATE TABLE IF NOT EXISTS operations (
39 seq INTEGER PRIMARY KEY AUTOINCREMENT,
40 kind TEXT NOT NULL,
41 timestamp INTEGER NOT NULL,
42 before TEXT NOT NULL DEFAULT '',
43 after TEXT NOT NULL DEFAULT '',
44 metadata TEXT
45);