From c551da01c32f72ad427d2f9ca3c7a5658239423c Mon Sep 17 00:00:00 2001 From: Mark Hymers Date: Thu, 28 Jul 2011 14:22:02 +0100 Subject: [PATCH] Update schema to rev 64 Signed-off-by: Mark Hymers --- setup/current_schema.sql | 2 +- setup/{schema_63.sql => schema_64.sql} | 9 +++------ 2 files changed, 4 insertions(+), 7 deletions(-) rename setup/{schema_63.sql => schema_64.sql} (99%) diff --git a/setup/current_schema.sql b/setup/current_schema.sql index 72130c95..a793aec9 120000 --- a/setup/current_schema.sql +++ b/setup/current_schema.sql @@ -1 +1 @@ -schema_63.sql \ No newline at end of file +schema_64.sql \ No newline at end of file diff --git a/setup/schema_63.sql b/setup/schema_64.sql similarity index 99% rename from setup/schema_63.sql rename to setup/schema_64.sql index 18f432ca..47521d0e 100644 --- a/setup/schema_63.sql +++ b/setup/schema_64.sql @@ -4948,7 +4948,7 @@ REVOKE ALL ON TABLE changes_pool_files FROM dak; GRANT ALL ON TABLE changes_pool_files TO dak; GRANT SELECT ON TABLE changes_pool_files TO PUBLIC; GRANT ALL ON TABLE changes_pool_files TO ftpmaster; -GRANT INSERT ON TABLE changes_pool_files TO ftpteam; +GRANT DELETE ON TABLE changes_pool_files TO ftpteam; -- @@ -5582,13 +5582,10 @@ GRANT ALL ON TABLE version_checks TO dak; GRANT SELECT ON TABLE version_checks TO PUBLIC; --- --- PostgreSQL database dump complete --- - -- -- PostgreSQL database dump complete -- -- Set schema version -INSERT INTO config (name, value) VALUES ('db_revision', 63); +INSERT INTO config (name, value) VALUES ('db_revision', 64); + -- 2.39.2