[PATCH 06/12] [db] Add a "value" column to package_priorities so that they are sortable

[Adeodato Simó <dato@net.com.org.es>]

---
 db/db.sql |   15 +++++++++------
 1 files changed, 9 insertions(+), 6 deletions(-)

diff --git a/db/db.sql b/db/db.sql
index 6884498..fbe1110 100644
--- a/db/db.sql
+++ b/db/db.sql
@@ -88,17 +88,20 @@ INSERT INTO components (name) VALUES ('non-free');
 
 CREATE TABLE package_priorities (
 	name text
-	  CONSTRAINT pkg_pri_pkey PRIMARY KEY
+	  CONSTRAINT pkg_pri_pkey PRIMARY KEY,
+	value integer
+	  DEFAULT 0
 );
 
 COMMENT ON TABLE package_priorities IS 'Valid package priorities';
 COMMENT ON COLUMN package_priorities.name IS 'Priority name';
+COMMENT ON COLUMN package_priorities.value IS 'Integer value for sorting priorities';
 
-INSERT INTO package_priorities (name) VALUES ('required');
-INSERT INTO package_priorities (name) VALUES ('standard');
-INSERT INTO package_priorities (name) VALUES ('important');
-INSERT INTO package_priorities (name) VALUES ('optional');
-INSERT INTO package_priorities (name) VALUES ('extra');
+INSERT INTO package_priorities (name, value) VALUES ('required', 1);
+INSERT INTO package_priorities (name, value) VALUES ('standard', 2);
+INSERT INTO package_priorities (name, value) VALUES ('important', 3);
+INSERT INTO package_priorities (name, value) VALUES ('optional', 4);
+INSERT INTO package_priorities (name, value) VALUES ('extra', 5);
 
 CREATE TABLE package_sections (
         name text
-- 
1.6.1.1.352.g2c729