From 17d44ec2c41a5b485cecae51a07396f85a601248 Mon Sep 17 00:00:00 2001
From: Karen Arutyunov <karen@codesynthesis.com>
Date: Fri, 30 Jun 2017 02:53:57 +0300
Subject: Fix builds page to correctly display unbuilt package count

---
 libbrep/build-extra.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 libbrep/build-extra.sql

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

diff --git a/libbrep/build-extra.sql b/libbrep/build-extra.sql
new file mode 100644
index 0000000..31736c8
--- /dev/null
+++ b/libbrep/build-extra.sql
@@ -0,0 +1,20 @@
+-- This file should be parsable by the brep-migrate utility. To decrease the
+-- parser complexity, there is a number of restrictions, see package-extra.sql
+-- file for details.
+--
+
+-- The foreign table for build_package object.
+--
+--
+DROP FOREIGN TABLE IF EXISTS build_package;
+
+CREATE FOREIGN TABLE build_package (
+  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,
+  version_upstream TEXT NOT NULL,
+  version_release TEXT NULL,
+  internal_repository TEXT NULL)
+SERVER package_server OPTIONS (table_name 'package');
-- 
cgit v1.1

