[Mapbender-commits] r6590 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: christoph
Date: 2010-07-12 15:42:05 +0000 (Mon, 12 Jul 2010)
New Revision: 6590

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
unified editSelf, editUser, editFilteredUser
user can no longer delete herself
added fields from other projects
uses class user, no sql in sources

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-07-12 15:41:12 UTC (rev 6589)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-07-12 15:42:05 UTC (rev 6590)
@@ -2517,6 +2517,7 @@
 NOT IN (SELECT fkey_gui_id FROM gui_element_vars WHERE var_name = 'saveWmcTarget'
 AND fkey_e_id = 'loadwmc');
 
+
 -- color pink in body had effect on other elements
 UPDATE gui_element_vars 
 set var_value = 'digitizeGeometryList {position:absolute; top:50px; left:0px;}
@@ -2525,3 +2526,10 @@
 .button {height:18px; width:32px;}'
 where fkey_gui_id = 'gui_digitize' and fkey_e_id = 'digitize'
 and var_name = 'text css';
+
+
+-- more fields in mb_user
+alter table mb_user add column mb_user_firstname character varying(255) DEFAULT ''::character varying;
+alter table mb_user add column mb_user_lastname character varying(255) DEFAULT ''::character varying;
+alter table mb_user add column mb_user_academictitle character varying(255) DEFAULT ''::character varying;
+