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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
/* This file was generated by ODB, object-relational mapping (ORM)
* compiler for C++.
*/
CREATE TABLE "public_key" (
"tenant" TEXT NOT NULL,
"fingerprint" TEXT NOT NULL,
"data" TEXT NOT NULL,
PRIMARY KEY ("tenant",
"fingerprint"));
ALTER TABLE "package"
ADD COLUMN "custom_bot" BOOLEAN NULL;
CREATE TABLE "package_build_bot_keys" (
"tenant" TEXT NOT NULL,
"name" CITEXT NOT NULL,
"version_epoch" INTEGER NOT NULL,
"version_canonical_upstream" TEXT NOT NULL,
"version_canonical_release" TEXT NOT NULL COLLATE "C",
"version_revision" INTEGER NOT NULL,
"index" BIGINT NOT NULL,
"key_tenant" TEXT NOT NULL,
"key_fingerprint" TEXT NOT NULL);
CREATE INDEX "package_build_bot_keys_object_id_i"
ON "package_build_bot_keys" (
"tenant",
"name",
"version_epoch",
"version_canonical_upstream",
"version_canonical_release",
"version_revision");
CREATE INDEX "package_build_bot_keys_index_i"
ON "package_build_bot_keys" ("index");
CREATE TABLE "package_build_config_bot_keys" (
"tenant" TEXT NOT NULL,
"name" CITEXT NOT NULL,
"version_epoch" INTEGER NOT NULL,
"version_canonical_upstream" TEXT NOT NULL,
"version_canonical_release" TEXT NOT NULL COLLATE "C",
"version_revision" INTEGER NOT NULL,
"config_index" BIGINT NOT NULL,
"index" BIGINT NOT NULL,
"key_tenant" TEXT NOT NULL,
"key_fingerprint" TEXT NOT NULL);
CREATE INDEX "package_build_config_bot_keys_object_id_i"
ON "package_build_config_bot_keys" (
"tenant",
"name",
"version_epoch",
"version_canonical_upstream",
"version_canonical_release",
"version_revision");
ALTER TABLE "public_key"
ADD CONSTRAINT "tenant_fk"
FOREIGN KEY ("tenant")
REFERENCES "tenant" ("id")
INITIALLY DEFERRED;
ALTER TABLE "package_build_bot_keys"
ADD CONSTRAINT "tenant_fk"
FOREIGN KEY ("tenant")
REFERENCES "tenant" ("id")
INITIALLY DEFERRED,
ADD CONSTRAINT "object_id_fk"
FOREIGN KEY ("tenant",
"name",
"version_epoch",
"version_canonical_upstream",
"version_canonical_release",
"version_revision")
REFERENCES "package" ("tenant",
"name",
"version_epoch",
"version_canonical_upstream",
"version_canonical_release",
"version_revision")
ON DELETE CASCADE,
ADD CONSTRAINT "key_tenant_fk"
FOREIGN KEY ("key_tenant")
REFERENCES "tenant" ("id")
INITIALLY DEFERRED,
ADD CONSTRAINT "key_fk"
FOREIGN KEY ("key_tenant",
"key_fingerprint")
REFERENCES "public_key" ("tenant",
"fingerprint")
INITIALLY DEFERRED;
ALTER TABLE "package_build_config_bot_keys"
ADD CONSTRAINT "tenant_fk"
FOREIGN KEY ("tenant")
REFERENCES "tenant" ("id")
INITIALLY DEFERRED,
ADD CONSTRAINT "object_id_fk"
FOREIGN KEY ("tenant",
"name",
"version_epoch",
"version_canonical_upstream",
"version_canonical_release",
"version_revision")
REFERENCES "package" ("tenant",
"name",
"version_epoch",
"version_canonical_upstream",
"version_canonical_release",
"version_revision")
ON DELETE CASCADE,
ADD CONSTRAINT "key_tenant_fk"
FOREIGN KEY ("key_tenant")
REFERENCES "tenant" ("id")
INITIALLY DEFERRED,
ADD CONSTRAINT "key_fk"
FOREIGN KEY ("key_tenant",
"key_fingerprint")
REFERENCES "public_key" ("tenant",
"fingerprint")
INITIALLY DEFERRED;
UPDATE "schema_version"
SET "version" = 33, "migration" = TRUE
WHERE "name" = 'package';
|