[Mapbender-commits] r4512 - branches/2.6/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2009-08-11 06:05:11 -0400 (Tue, 11 Aug 2009)
New Revision: 4512

Modified:
   branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql
Log:
new fields for table mb_user

Modified: branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql
===================================================================
--- branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql	2009-08-10 12:00:58 UTC (rev 4511)
+++ branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql	2009-08-11 10:05:11 UTC (rev 4512)
@@ -122,3 +122,14 @@
 
 ALTER TABLE gui_element ALTER COLUMN e_public SET DEFAULT 1;
 ALTER TABLE gui_element ALTER COLUMN e_public SET NOT NULL;
+
+-- new columns for table mb_user (more information fields + validity date fields)
+ALTER TABLE mb_user ADD COLUMN mb_user_realname varchar(100);
+ALTER TABLE mb_user ADD COLUMN mb_user_street varchar(100);
+ALTER TABLE mb_user ADD COLUMN mb_user_housenumber varchar(50);
+ALTER TABLE mb_user ADD COLUMN mb_user_reference varchar(100);
+ALTER TABLE mb_user ADD COLUMN mb_user_for_attention_of varchar(100);
+ALTER TABLE mb_user ADD COLUMN mb_user_valid_from date;
+ALTER TABLE mb_user ADD COLUMN mb_user_valid_to date;
+ALTER TABLE mb_user ADD COLUMN mb_user_password_ticket varchar(100);
+