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
|
/* This file was generated by ODB, object-relational mapping (ORM)
* compiler for C++.
*/
CREATE TABLE "build_auxiliary_machines" (
"package_tenant" TEXT NOT NULL,
"package_name" CITEXT NOT NULL,
"package_version_epoch" INTEGER NOT NULL,
"package_version_canonical_upstream" TEXT NOT NULL,
"package_version_canonical_release" TEXT NOT NULL COLLATE "C",
"package_version_revision" INTEGER NOT NULL,
"target" TEXT NOT NULL,
"target_config_name" TEXT NOT NULL,
"package_config_name" TEXT NOT NULL,
"toolchain_name" TEXT NOT NULL,
"toolchain_version_epoch" INTEGER NOT NULL,
"toolchain_version_canonical_upstream" TEXT NOT NULL,
"toolchain_version_canonical_release" TEXT NOT NULL COLLATE "C",
"toolchain_version_revision" INTEGER NOT NULL,
"index" BIGINT NOT NULL,
"name" TEXT NOT NULL,
"summary" TEXT NOT NULL);
CREATE INDEX "build_auxiliary_machines_object_id_i"
ON "build_auxiliary_machines" (
"package_tenant",
"package_name",
"package_version_epoch",
"package_version_canonical_upstream",
"package_version_canonical_release",
"package_version_revision",
"target",
"target_config_name",
"package_config_name",
"toolchain_name",
"toolchain_version_epoch",
"toolchain_version_canonical_upstream",
"toolchain_version_canonical_release",
"toolchain_version_revision");
CREATE INDEX "build_auxiliary_machines_index_i"
ON "build_auxiliary_machines" ("index");
ALTER TABLE "build_auxiliary_machines"
ADD CONSTRAINT "object_id_fk"
FOREIGN KEY ("package_tenant",
"package_name",
"package_version_epoch",
"package_version_canonical_upstream",
"package_version_canonical_release",
"package_version_revision",
"target",
"target_config_name",
"package_config_name",
"toolchain_name",
"toolchain_version_epoch",
"toolchain_version_canonical_upstream",
"toolchain_version_canonical_release",
"toolchain_version_revision")
REFERENCES "build" ("package_tenant",
"package_name",
"package_version_epoch",
"package_version_canonical_upstream",
"package_version_canonical_release",
"package_version_revision",
"target",
"target_config_name",
"package_config_name",
"toolchain_name",
"toolchain_version_epoch",
"toolchain_version_canonical_upstream",
"toolchain_version_canonical_release",
"toolchain_version_revision")
ON DELETE CASCADE;
UPDATE "schema_version"
SET "version" = 25, "migration" = TRUE
WHERE "name" = 'build';
|