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.sql15
1 files changed, 13 insertions, 2 deletions
diff --git a/libbrep/build-extra.sql b/libbrep/build-extra.sql
index 31736c8..6a222a7 100644
--- a/libbrep/build-extra.sql
+++ b/libbrep/build-extra.sql
@@ -3,11 +3,22 @@
-- file for details.
--
--- The foreign table for build_package object.
+DROP FOREIGN TABLE IF EXISTS build_package;
+
+DROP FOREIGN TABLE IF EXISTS build_repository;
+
+-- The foreign table for build_repository object.
--
--
-DROP FOREIGN TABLE IF EXISTS build_package;
+CREATE FOREIGN TABLE build_repository (
+ name TEXT NOT NULL,
+ location TEXT NOT NULL,
+ certificate_fingerprint TEXT NULL)
+SERVER package_server OPTIONS (table_name 'repository');
+-- The foreign table for build_package object.
+--
+--
CREATE FOREIGN TABLE build_package (
name TEXT NOT NULL,
version_epoch INTEGER NOT NULL,