[Mapbender-commits] r4922 - in trunk/mapbender: http/classes resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: kmq
Date: 2009-11-04 10:07:10 -0500 (Wed, 04 Nov 2009)
New Revision: 4922

Modified:
   trunk/mapbender/http/classes/class_wmc.php
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6_to_2.7rc1_pgsql_UTF-8.sql
Log:
creation timestamp added to wmc database entries

Modified: trunk/mapbender/http/classes/class_wmc.php
===================================================================
--- trunk/mapbender/http/classes/class_wmc.php	2009-11-04 15:02:06 UTC (rev 4921)
+++ trunk/mapbender/http/classes/class_wmc.php	2009-11-04 15:07:10 UTC (rev 4922)
@@ -361,17 +361,17 @@
 
 
             }else{
-              $sql = "INSERT INTO mb_user_wmc VALUES ($1, $2, $3, $4, $5)";
-              $v = array($this->wmc_id, $this->userId, $this->xml, administration::convertOutgoingString($this->wmc_title), time());
-              $t = array("s", "i", "s", "s", "s");
+              $sql = "INSERT INTO mb_user_wmc VALUES ($1, $2, $3, $4, $5, $6)";
+              $v = array($this->wmc_id, $this->userId, $this->xml, administration::convertOutgoingString($this->wmc_title), time(),time());
+              $t = array("s", "i", "s", "s", "s","s");
             }
 
 
           }else{
 
-			$sql = "INSERT INTO mb_user_wmc VALUES ($1, $2, $3, $4, $5)";
-			$v = array($this->wmc_id, $this->userId, $this->xml, administration::convertOutgoingString($this->wmc_title), time());
-			$t = array("s", "i", "s", "s", "s");
+              $sql = "INSERT INTO mb_user_wmc VALUES ($1, $2, $3, $4, $5, $6)";
+              $v = array($this->wmc_id, $this->userId, $this->xml, administration::convertOutgoingString($this->wmc_title), time(),time());
+              $t = array("s", "i", "s", "s", "s","s");
           
           }
 

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6_to_2.7rc1_pgsql_UTF-8.sql	2009-11-04 15:02:06 UTC (rev 4921)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6_to_2.7rc1_pgsql_UTF-8.sql	2009-11-04 15:07:10 UTC (rev 4922)
@@ -476,6 +476,7 @@
 INSERT INTO gui_element_vars (fkey_gui_id,fkey_e_id,var_name,var_value,context,var_type) VALUES('gui_digitize','navFrame','backGroundColor','#c6ced6','set the background-color of the NavFrame' ,'php_var');
 INSERT INTO gui_element_vars (fkey_gui_id,fkey_e_id,var_name,var_value,context,var_type) VALUES('gui_digitize','navFrame','backGroundHoverColor','#9cacbc','set the background-hover-color of the NavFrame' ,'php_var');
 
+ALTER TABLE mb_user_wmc ADD COLUMN
+wmc_timestamp_create INTEGER;
 
 
-