X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=add_constraints.sql;h=9b7eb7669d300f9f16865c0445b906b38683c14f;hb=1af29fa5f8b542b7cf18e2c116551f90b5b9b24d;hp=71453e02a3253d76dfafcea67c36b94cd27bcd53;hpb=8e9a5d533c8458eaca33266208f6c347d66dfeef;p=dak.git

diff --git a/add_constraints.sql b/add_constraints.sql
index 71453e02..9b7eb766 100644
--- a/add_constraints.sql
+++ b/add_constraints.sql
@@ -63,6 +63,9 @@ CREATE FUNCTION priority_id_max() RETURNS INT4
 CREATE FUNCTION override_type_id_max() RETURNS INT4
     AS 'SELECT max(id) FROM override_type'
     LANGUAGE 'sql';
+CREATE FUNCTION maintainer_id_max() RETURNS INT4
+    AS 'SELECT max(id) FROM maintainer'
+    LANGUAGE 'sql';
 
 SELECT setval('files_id_seq', files_id_max());
 SELECT setval('source_id_seq', source_id_max());
@@ -73,6 +76,7 @@ SELECT setval('bin_associations_id_seq', bin_associations_id_max());
 SELECT setval('section_id_seq', section_id_max());
 SELECT setval('priority_id_seq', priority_id_max());
 SELECT setval('override_type_id_seq', override_type_id_max());
+SELECT setval('maintainer_id_seq', maintainer_id_max());
 
 -- Vacuum the tables for efficency
 
@@ -103,7 +107,8 @@ GRANT ALL ON architecture, architecture_id_seq, archive,
   maintainer_id_seq, override, override_type, override_type_id_seq,
   priority, priority_id_seq, section, section_id_seq, source,
   source_id_seq, src_associations, src_associations_id_seq, suite,
-  suite_architectures, suite_id_seq, accepted_autobuild TO GROUP ftpmaster;
+  suite_architectures, suite_id_seq, accepted_autobuild, uid,
+  uid_id_seq TO GROUP ftpmaster;
 
 -- Read only access to user 'nobody'
 GRANT SELECT ON architecture, architecture_id_seq, archive,
@@ -114,4 +119,5 @@ GRANT SELECT ON architecture, architecture_id_seq, archive,
   maintainer_id_seq, override, override_type, override_type_id_seq,
   priority, priority_id_seq, section, section_id_seq, source,
   source_id_seq, src_associations, src_associations_id_seq, suite,
-  suite_architectures, suite_id_seq, accepted_autobuild TO PUBLIC;
+  suite_architectures, suite_id_seq, accepted_autobuild, uid,
+  uid_id_seq TO PUBLIC;