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

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2014-02-28 10:40:09 -0800 (Fri, 28 Feb 2014)
New Revision: 8788

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
Bugfix for new feature info log module

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-02-28 18:28:54 UTC (rev 8787)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2014-02-28 18:40:09 UTC (rev 8788)
@@ -287,8 +287,8 @@
 ALTER TABLE mb_proxy_log ADD COLUMN request_type character varying(15);
 ALTER TABLE mb_proxy_log ADD COLUMN log_id serial;
 ALTER TABLE mb_proxy_log ADD PRIMARY KEY (log_id);
+ALTER TABLE mb_proxy_log SET WITH OIDS;
 
-
 --neue Anwendung Owsproxy_csv
 INSERT INTO gui (gui_id, gui_name, gui_description, gui_public) VALUES ('Owsproxy_csv','Owsproxy_csv','GUI combining most of the Mapbender functionality',1);
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Owsproxy_csv','i18n',1,0,'Internationalization module, collects data from all elements and sends them to the server in a single POST request. The strings are translated via gettext only.','Internationalization','div','','',NULL ,NULL,NULL ,NULL,NULL ,'','','div','../plugins/mb_i18n.js','','','','http://www.mapbender.org/Gettext');
@@ -356,11 +356,11 @@
 --ergänze Eintrag owsproxy_calc_collection in Target von Element menu_wms in Administration_DE
 UPDATE gui_element SET e_target = replace(e_target, 'owsproxy_collection', 'owsproxy_collection,owsproxy_calc_collection') WHERE fkey_gui_id = 'Administration_DE' AND e_id = 'menu_wms';
 
--- Column: wms_proxylog_fi
+-- Column: wms_proxy_log_fi
 
--- ALTER TABLE wms DROP COLUMN wms_proxylog_fi;
+-- ALTER TABLE wms DROP COLUMN wms_proxy_log_fi;
 
-ALTER TABLE wms ADD COLUMN wms_proxylog_fi integer;
+ALTER TABLE wms ADD COLUMN wms_proxy_log_fi integer;
 
 -- Column: wms_price_fi