aboutsummaryrefslogtreecommitdiff
path: root/libbrep/build-extra.sql
diff options
context:
space:
mode:
authorKaren Arutyunov <karen@codesynthesis.com>2017-07-04 11:27:47 +0300
committerKaren Arutyunov <karen@codesynthesis.com>2017-07-05 15:22:37 +0300
commit6e90b57a442424876b1325b9209f79c8a885a479 (patch)
treebcdc8ee050c05799e17dcca12d7afc80274840d0 /libbrep/build-extra.sql
parent17d44ec2c41a5b485cecae51a07396f85a601248 (diff)
Make use of foreign package objects in build-related functionality
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,