[Mapbender-commits] r8010 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-28 05:48:18 -0700 (Thu, 28 Jul 2011)
New Revision: 8010

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
Log:
added role_id because else the inserts will run on every update

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-07-27 12:40:00 UTC (rev 8009)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-07-28 12:48:18 UTC (rev 8010)
@@ -1741,11 +1741,11 @@
 
 --things for the role table
 --standard roles:
-INSERT INTO mb_role (role_name,role_description,role_exclude_auth) VALUES ('standard role','No special role - old behaviour.',0);
+INSERT INTO mb_role (role_id,role_name,role_description,role_exclude_auth) VALUES (1,'standard role','No special role - old behaviour.',0);
 
-INSERT INTO mb_role (role_name,role_description,role_exclude_auth) VALUES ('primary','Primary group for a mapbender user.',0);
+INSERT INTO mb_role (role_id,role_name,role_description,role_exclude_auth) VALUES (2,'primary','Primary group for a mapbender user.',0);
 
-INSERT INTO mb_role (role_name,role_description,role_exclude_auth) VALUES ('metadata editor','Group for which the user can edit and publish metadata.',1);
+INSERT INTO mb_role (role_id,role_name,role_description,role_exclude_auth) VALUES (3,'metadata editor','Group for which the user can edit and publish metadata.',1);
 
 --constraint for new role system
 -- ALTER TABLE mb_user_mb_group DROP CONSTRAINT fkey_mb_user_mb_group_role_id;