diff options
author | Karen Arutyunov <karen@codesynthesis.com> | 2024-05-21 11:08:50 +0300 |
---|---|---|
committer | Karen Arutyunov <karen@codesynthesis.com> | 2024-05-21 11:08:50 +0300 |
commit | a51a5f81cabeb15fe8bf7fa6d02e287763758a69 (patch) | |
tree | 55e939e72deb11bbf7e0aad60000d2f3fa576ede /libbrep/build-025-pre.sql | |
parent | 57f6378aea619ceb07b935012772bd4698e6a2be (diff) |
Make changes required for CIci
Diffstat (limited to 'libbrep/build-025-pre.sql')
-rw-r--r-- | libbrep/build-025-pre.sql | 79 |
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'; + |