diff options
Diffstat (limited to 'libbrep/build-extra.sql')
-rw-r--r-- | libbrep/build-extra.sql | 15 |
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, |