X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate22.py;h=b6fbbb447b37ac776085ca91efeb1449f63fd21f;hb=5d965c34b35048f8a8fab0a7a11f2943d833952d;hp=924e30784ad4a69d3a3a409cdb0db9c1b631e9a5;hpb=12ce63e57c3e6a352da9616c44642fcd8c66fb69;p=dak.git

diff --git a/dak/dakdb/update22.py b/dak/dakdb/update22.py
index 924e3078..b6fbbb44 100755
--- a/dak/dakdb/update22.py
+++ b/dak/dakdb/update22.py
@@ -56,9 +56,12 @@ def do_update(self):
 
         print "Adding policy_queue table"
         c.execute("""CREATE TABLE policy_queue (
-                            id          SERIAL PRIMARY KEY,
-                            queue_name  TEXT NOT NULL UNIQUE,
-                            path        TEXT NOT NULL)""")
+                            id           SERIAL PRIMARY KEY,
+                            queue_name   TEXT NOT NULL UNIQUE,
+                            path         TEXT NOT NULL,
+                            perms        CHAR(4) NOT NULL DEFAULT '0660' CHECK (perms SIMILAR TO '^[0-7][0-7][0-7][0-7]$'),
+                            change_perms CHAR(4) NOT NULL DEFAULT '0660' CHECK (change_perms SIMILAR TO '^[0-7][0-7][0-7][0-7]$')
+                            )""")
 
         print "Copying queues"
         queues = {}
@@ -204,6 +207,9 @@ def do_update(self):
         print "Getting rid of old queue table"
         c.execute("""DROP TABLE queue""")
 
+        print "Sorting out permission columns"
+        c.execute("""UPDATE policy_queue SET perms = '0664' WHERE queue_name IN ('proposedupdates', 'oldproposedupdates')""")
+
         print "Moving known_changes table"
         c.execute("""ALTER TABLE known_changes RENAME TO changes""")