Changeset 361

Timestamp:

07/21/08 11:02:24 (16 years ago)

Author:

niltonneto

Message:

Modificação de versão;
Criada função especial para adicionar coluna em tabela. Essa
função permite setar o valor DEFAULT com expressões.

Location:

trunk/calendar/setup

Files:

• setup.inc.php (modified) (1 diff)
• tables_update.inc.php (modified) (2 diffs)

trunk/calendar/setup/setup.inc.php

@@ -12 +12 @@
 
         $setup_info['calendar']['name']    = 'calendar';
-        $setup_info['calendar']['version'] = '0.9.22';
+        $setup_info['calendar']['version'] = '0.9.23';
         $setup_info['calendar']['app_order'] = 3;
         $setup_info['calendar']['enable']  = 1;

trunk/calendar/setup/tables_update.inc.php

@@ -9 +9 @@
   *  option) any later version.                                              *
   \**************************************************************************/
+        function addSpecialColumn($table,$column, $attrs){
+                $result = $GLOBALS['phpgw_setup']->db->metadata($table);
+                if($result){
+                        foreach($result as $idx => $col){
+                                if($col['name'] == $column)
+                                        return;
+                        }
+                }               
+                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE ".$table." ADD COLUMN ".$column." ".$attrs);
+        }  
         $test[] = '0.9.2';
         function calendar_upgrade0_9_2()
@@ -30 +40 @@
         function calendar_upgrade0_9_21()
         {
-                /*
-                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cal','last_status',array(
-                        'type' => 'char',
-                        'precision' => '1',
-                        'default' => 'N::bpchar'));
-                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_cal','last_update',array(
-                        'type' => 'int8',
-                        'precision' => '8',
-                        'default' => '(date_part(\'epoch\'::text, (\'now\'::text)::timestamp(3) with time zone) * (1000)::double precision)'));
-                */
-                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar");
-                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)");
-
+                addSpecialColumn("phpgw_cal","last_status","char(1) DEFAULT 'N'::bpchar");
+                addSpecialColumn("phpgw_cal","last_update","int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)");
                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.22';
+                return $GLOBALS['setup_info']['calendar']['currentver'];
+        }       
+        $test[] = '0.9.22';
+        function calendar_upgrade0_9_22()
+        {
+                $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.23';
                 return $GLOBALS['setup_info']['calendar']['currentver'];
         }