-
Notifications
You must be signed in to change notification settings - Fork 49
/
pinto.sql
80 lines (62 loc) · 2.58 KB
/
pinto.sql
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
CREATE TABLE repository_property (
id INTEGER PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
value TEXT DEFAULT ''
);
CREATE TABLE distribution (
id INTEGER PRIMARY KEY NOT NULL,
path TEXT NOT NULL,
source TEXT NOT NULL,
mtime INTEGER NOT NULL,
md5 TEXT NOT NULL,
sha256 TEXT NOT NULL
);
CREATE TABLE package (
id INTEGER PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
version TEXT NOT NULL,
distribution INTEGER NOT NULL,
FOREIGN KEY(distribution) REFERENCES distribution(id)
);
CREATE TABLE stack (
id INTEGER PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
is_default INTEGER NOT NULL,
last_modified_on INTEGER NOT NULL,
last_modified_by TEXT NOT NULL
);
CREATE TABLE stack_property (
id INTEGER PRIMARY KEY NOT NULL,
stack INTEGER NOT NULL,
name TEXT NOT NULL,
value TEXT DEFAULT '',
FOREIGN KEY(stack) REFERENCES stack(id)
);
create TABLE registration (
id INTEGER PRIMARY KEY NOT NULL,
stack INTEGER NOT NULL,
package INTEGER NOT NULL,
is_pinned INTEGER NOT NULL,
package_name TEXT NOT NULL,
package_version TEXT NOT NULL,
distribution_path TEXT NOT NULL,
FOREIGN KEY(stack) REFERENCES stack(id),
FOREIGN KEY(package) REFERENCES package(id)
);
CREATE TABLE prerequisite (
id INTEGER PRIMARY KEY NOT NULL,
distribution INTEGER NOT NULL,
package_name TEXT NOT NULL,
package_version TEXT NOT NULL,
FOREIGN KEY(distribution) REFERENCES distribution(id)
);
/* Schema::Loader names the indexes for us */
CREATE UNIQUE INDEX a ON distribution(path);
CREATE UNIQUE INDEX b ON package(name, distribution);
CREATE UNIQUE INDEX c ON stack(name);
CREATE UNIQUE INDEX d ON registration(stack, package_name);
CREATE UNIQUE INDEX e ON prerequisite(distribution, package_name);
CREATE UNIQUE INDEX f ON stack_property(stack, name);
CREATE UNIQUE INDEX g ON repository_property(name);
CREATE INDEX h ON registration(stack);
CREATE INDEX i ON package(name);