[PATCH 2/3] Add table blends_unknown_packages

[zenith158@gmail.com]

From: Akshita Jha <akshita-guest@users.alioth.debian.org>

---
 sql/modify_udd.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

diff --git a/sql/modify_udd.sql b/sql/modify_udd.sql
index a06b0c5..ebab03e 100644
--- a/sql/modify_udd.sql
+++ b/sql/modify_udd.sql
@@ -2,3 +2,22 @@
 
 ALTER TABLE ONLY blends_prospectivepackages 
     ADD CONSTRAINT blends_prospectivepackages_pkey PRIMARY KEY (package);
+
+-- blends_unknown_packages: packages which are not present in vcs
+
+CREATE TABLE blends_unknown_packages
+  (blend text,
+       package text,
+       pkg_url text,
+       source text,
+       maintainer text,
+       maintainer_name text,
+       maintainer_email text,
+       description text,
+       long_description text,
+       description_md5 text,
+       homepage text,
+       langauge text,
+       enhances text,
+       PRIMARY KEY (package)
+);
-- 
1.9.1