aboutsummaryrefslogtreecommitdiff
path: root/libbrep/build-extra.sql
diff options
context:
space:
mode:
Diffstat (limited to 'libbrep/build-extra.sql')
-rw-r--r--libbrep/build-extra.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/libbrep/build-extra.sql b/libbrep/build-extra.sql
index 6a222a7..4da75e5 100644
--- a/libbrep/build-extra.sql
+++ b/libbrep/build-extra.sql
@@ -3,6 +3,8 @@
-- file for details.
--
+DROP FOREIGN TABLE IF EXISTS build_package_constraints;
+
DROP FOREIGN TABLE IF EXISTS build_package;
DROP FOREIGN TABLE IF EXISTS build_repository;
@@ -29,3 +31,19 @@ CREATE FOREIGN TABLE build_package (
version_release TEXT NULL,
internal_repository TEXT NULL)
SERVER package_server OPTIONS (table_name 'package');
+
+-- The foreign table for the build_package object constraints member (that is
+-- of a container type).
+--
+--
+CREATE FOREIGN TABLE build_package_constraints (
+ name TEXT 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,
+ exclusion BOOLEAN NOT NULL,
+ config TEXT NOT NULL,
+ target TEXT NULL)
+SERVER package_server OPTIONS (table_name 'package_build_constraints');