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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-19 05:18:23 -0700 (Tue, 19 Jul 2011)
New Revision: 7963

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql
Log:
merged with trunk

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-19 11:46:41 UTC (rev 7962)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql	2011-07-19 12:18:23 UTC (rev 7963)
@@ -1719,6 +1719,7 @@
   CONSTRAINT role_id PRIMARY KEY (role_id)
 );
 
+
 --things to be done for mb_user_mb_group table:
 --drop old constraint
 --Allow to be member in a group with different roles
@@ -1831,7 +1832,6 @@
   CONSTRAINT metadata_pkey PRIMARY KEY (metadata_id)
 --  CONSTRAINT metadata_uuid_key UNIQUE (uuid) -- not used cause this could happen!
 );
-ALTER TABLE mb_metadata OWNER TO postgres;
 
 
 -- Table: ows_relation_metadata
@@ -1853,10 +1853,8 @@
       REFERENCES mb_metadata (metadata_id) MATCH SIMPLE
       ON UPDATE CASCADE ON DELETE CASCADE
 );
-ALTER TABLE ows_relation_metadata OWNER TO postgres;
 
 
-
 CREATE OR REPLACE FUNCTION update_lastchanged_column()
 RETURNS TRIGGER AS $$
 BEGIN