[Mapbender-commits] r1647 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-08-09 09:14:14 -0400 (Thu, 09 Aug 2007)
New Revision: 1647

Modified:
   trunk/mapbender/resources/db/update/update_postgresql_db.sql
Log:
database changes for version 2.5

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-08-09 13:05:34 UTC (rev 1646)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-08-09 13:14:14 UTC (rev 1647)
@@ -1,22 +1,26 @@
 --
 -- database changes in version 2.5
 --
--- notice lnguage plpgsql has to be installed
+-- notice language plpgsql has to be installed
 -- 
 
 
 -- How to install plpgsql? 
 -- createlang plpgsql mapbender
 
--- change in WFS configuration: access to geometries may now be restricted
-
+--
+-- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
+--
 ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50);
 
--- new column for translation
-
+--
+-- table gui_element: new column for translation
+--
 ALTER TABLE gui_element ADD COLUMN e_title VARCHAR(255);
 
---new table for translations
+-- 
+-- new table translation: new table for translations
+-- 
 
 CREATE TABLE translations
 (
@@ -28,8 +32,9 @@
 
 CREATE INDEX msgid_idx ON translations(msgid);
 
---new function for easy translations
-
+-- 
+-- new function gettext for easy translations
+-- 
 CREATE OR REPLACE FUNCTION gettext(locale_arg "text", string "text")
 RETURNS "varchar" AS
 $BODY$