From 6e90b57a442424876b1325b9209f79c8a885a479 Mon Sep 17 00:00:00 2001
From: Karen Arutyunov <karen@codesynthesis.com>
Date: Tue, 4 Jul 2017 11:27:47 +0300
Subject: Make use of foreign package objects in build-related functionality

---
 libbrep/build-extra.sql | 15 +++++++++++++--
 1 file changed, 13 insertions(+), 2 deletions(-)

(limited to 'libbrep/build-extra.sql')

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,
-- 
cgit v1.1

