[PATCH 1/3] Add constaint primary key (package) for blends_prospectivepackages

[zenith158@gmail.com]

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

---
 sql/modify_udd.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/modify_udd.sql

diff --git a/sql/modify_udd.sql b/sql/modify_udd.sql
new file mode 100644
index 0000000..a06b0c5
--- /dev/null
+++ b/sql/modify_udd.sql
@@ -0,0 +1,4 @@
+-- Add primary key for blends_prospective packages
+
+ALTER TABLE ONLY blends_prospectivepackages 
+    ADD CONSTRAINT blends_prospectivepackages_pkey PRIMARY KEY (package);
-- 
1.9.1