From 004062737657986294163672ae67d16348e203f6 Mon Sep 17 00:00:00 2001 From: Karen Arutyunov Date: Wed, 14 Oct 2020 20:43:20 +0300 Subject: Make changes required for test --- libbrep/build.sql | 158 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 158 insertions(+) create mode 100644 libbrep/build.sql (limited to 'libbrep/build.sql') diff --git a/libbrep/build.sql b/libbrep/build.sql new file mode 100644 index 0000000..2d62823 --- /dev/null +++ b/libbrep/build.sql @@ -0,0 +1,158 @@ +/* This file was generated by ODB, object-relational mapping (ORM) + * compiler for C++. + */ + +DROP TABLE IF EXISTS "build_delay" CASCADE; + +DROP TABLE IF EXISTS "build_results" CASCADE; + +DROP TABLE IF EXISTS "build" CASCADE; + +DROP TABLE IF EXISTS "schema_version"; + +CREATE TABLE "build" ( + "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, + "configuration" 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, + "package_version_upstream" TEXT NOT NULL, + "package_version_release" TEXT NULL, + "toolchain_version_upstream" TEXT NOT NULL, + "toolchain_version_release" TEXT NULL, + "state" TEXT NOT NULL, + "timestamp" BIGINT NOT NULL, + "force" TEXT NOT NULL, + "status" TEXT NULL, + "completion_timestamp" BIGINT NOT NULL DEFAULT 0, + "agent_fingerprint" TEXT NULL, + "agent_challenge" TEXT NULL, + "machine" TEXT NOT NULL, + "machine_summary" TEXT NOT NULL, + "target" TEXT NOT NULL, + PRIMARY KEY ("package_tenant", + "package_name", + "package_version_epoch", + "package_version_canonical_upstream", + "package_version_canonical_release", + "package_version_revision", + "configuration", + "toolchain_name", + "toolchain_version_epoch", + "toolchain_version_canonical_upstream", + "toolchain_version_canonical_release", + "toolchain_version_revision")); + +CREATE INDEX "build_timestamp_i" + ON "build" ("timestamp"); + +CREATE TABLE "build_results" ( + "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, + "configuration" 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, + "operation" TEXT NOT NULL, + "status" TEXT NOT NULL, + "log" TEXT NOT NULL, + CONSTRAINT "object_id_fk" + FOREIGN KEY ("package_tenant", + "package_name", + "package_version_epoch", + "package_version_canonical_upstream", + "package_version_canonical_release", + "package_version_revision", + "configuration", + "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", + "configuration", + "toolchain_name", + "toolchain_version_epoch", + "toolchain_version_canonical_upstream", + "toolchain_version_canonical_release", + "toolchain_version_revision") + ON DELETE CASCADE); + +CREATE INDEX "build_results_object_id_i" + ON "build_results" ( + "package_tenant", + "package_name", + "package_version_epoch", + "package_version_canonical_upstream", + "package_version_canonical_release", + "package_version_revision", + "configuration", + "toolchain_name", + "toolchain_version_epoch", + "toolchain_version_canonical_upstream", + "toolchain_version_canonical_release", + "toolchain_version_revision"); + +CREATE INDEX "build_results_index_i" + ON "build_results" ("index"); + +CREATE TABLE "build_delay" ( + "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, + "configuration" 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, + "package_version_upstream" TEXT NOT NULL, + "package_version_release" TEXT NULL, + "toolchain_version_upstream" TEXT NOT NULL, + "toolchain_version_release" TEXT NULL, + "report_timestamp" BIGINT NOT NULL, + "package_timestamp" BIGINT NOT NULL, + PRIMARY KEY ("package_tenant", + "package_name", + "package_version_epoch", + "package_version_canonical_upstream", + "package_version_canonical_release", + "package_version_revision", + "configuration", + "toolchain_name", + "toolchain_version_epoch", + "toolchain_version_canonical_upstream", + "toolchain_version_canonical_release", + "toolchain_version_revision")); + +CREATE TABLE "schema_version" ( + "name" TEXT NOT NULL PRIMARY KEY, + "version" BIGINT NOT NULL, + "migration" BOOLEAN NOT NULL); + +INSERT INTO "schema_version" ( + "name", "version", "migration") + VALUES ('build', 12, FALSE); + -- cgit v1.1