1 files changed, 79 insertions, 0 deletions
diff --git a/libbrep/build-025-pre.sql b/libbrep/build-025-pre.sql
new file mode 100644
index 0000000..fef3ab7
--- /dev/null
+++ b/libbrep/build-025-pre.sql
@@ -0,0 +1,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';
+