Changeset 5311 for trunk/calendar


Ignore:
Timestamp:
01/05/12 09:51:14 (12 years ago)
Author:
niltonneto
Message:

Ticket #2409 - Corrigido tables_update da API e dos módulos que possuem.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/calendar/setup/tables_update.inc.php

    r5203 r5311  
    1616                                        return; 
    1717                        } 
    18                 }                
     18                } 
    1919                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE ".$table." ADD COLUMN ".$column." ".$attrs); 
    20         }   
    21         $test[] = '0.9.2'; 
    22         function calendar_upgrade0_9_2() 
    23         { 
    24                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.17'; 
    25                 return $GLOBALS['setup_info']['calendar']['currentver']; 
    2620        } 
    27         $test[] = '0.9.17'; 
    28         function calendar_upgrade0_9_17() 
    29         { 
    30                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21'; 
    31                 return $GLOBALS['setup_info']['calendar']['currentver']; 
    32         } 
    33         $test[] = '0.9.20'; 
    34         function calendar_upgrade0_9_20() 
    35         { 
    36                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.21'; 
    37                 return $GLOBALS['setup_info']['calendar']['currentver']; 
    38         }        
    39         $test[] = '0.9.21'; 
    40         function calendar_upgrade0_9_21() 
    41         { 
    42                 addSpecialColumn("phpgw_cal","last_status","char(1) DEFAULT 'N'::bpchar"); 
    43                 addSpecialColumn("phpgw_cal","last_update","int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision)"); 
    44                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.22'; 
    45                 return $GLOBALS['setup_info']['calendar']['currentver']; 
    46         }        
    47         $test[] = '0.9.22'; 
    48         function calendar_upgrade0_9_22() 
    49         { 
    50                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.23'; 
    51                 return $GLOBALS['setup_info']['calendar']['currentver']; 
    52         } 
    53         $test[] = '0.9.23'; 
    54         function calendar_upgrade0_9_23() 
    55         { 
    56                 $GLOBALS['setup_info']['calendar']['currentver'] = '0.9.3'; 
    57                 return $GLOBALS['setup_info']['calendar']['currentver']; 
    58         }        
     21/// Since Expresso 1.2 using Calendar 0.9.3 
    5922        $test[] = '0.9.3'; 
    6023        function calendar_upgrade0_9_3() 
    … …  
    10265        function calendar_upgrade2_0_006() { 
    10366                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.007'; 
    104                 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ALTER COLUMN title TYPE character varying(1024);"); 
    10567                return $GLOBALS['setup_info']['calendar']['currentver']; 
    10668        }                
    10769        $test[] = '2.0.007'; 
    108         function calendar_upgrade2_0_007() { 
    109                 $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.008'; 
    110                 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN organizer character varying(255);"); 
     70        function calendar_upgrade2_0_007() 
     71        { 
     72                $GLOBALS['setup_info']['calendar']['currentver'] = '2.1.000'; 
     73                return $GLOBALS['setup_info']['calendar']['currentver']; 
     74        } 
     75        $test[] = '2.1.000'; 
     76        function calendar_upgrade2_1_000() 
     77        { 
     78                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.000'; 
     79                return $GLOBALS['setup_info']['calendar']['currentver']; 
     80        } 
     81        $test[] = '2.2.000'; 
     82        function calendar_upgrade2_2_000() 
     83        { 
     84                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.1'; 
     85                return $GLOBALS['setup_info']['calendar']['currentver']; 
     86        } 
     87        $test[] = '2.2.1'; 
     88        function calendar_upgrade2_2_1() 
     89        { 
     90                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.6'; 
     91                return $GLOBALS['setup_info']['calendar']['currentver']; 
     92        } 
     93        $test[] = '2.2.6'; 
     94        function calendar_upgrade2_2_6() 
     95        { 
     96                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.8'; 
     97                return $GLOBALS['setup_info']['calendar']['currentver']; 
     98        } 
     99        $test[] = '2.2.8'; 
     100        function calendar_upgrade2_2_8() 
     101        { 
     102                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.10'; 
     103                return $GLOBALS['setup_info']['calendar']['currentver']; 
     104        } 
     105        $test[] = '2.2.10'; 
     106        function calendar_upgrade2_2_10() 
     107        { 
     108            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN notifications_owner INT NOT NULL default '0'"); 
     109                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text"); 
     110            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by varchar(160)"); 
     111            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text"); 
     112            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN organizer character varying(255);"); 
     113                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ALTER title TYPE varchar(1024)"); 
     114                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal_repeats ALTER recur_exception TYPE varchar"); 
     115            $GLOBALS['setup_info']['calendar']['currentver'] = '2.3.0'; 
    111116            return $GLOBALS['setup_info']['calendar']['currentver']; 
    112117        } 
    113          
    114                 $test[] = '2.0.008'; 
    115         function calendar_upgrade2_0_008() { 
    116                 $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.009'; 
    117                 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text;"); 
    118                 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text;"); 
    119                 $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by character varying(160);"); 
    120             return $GLOBALS['setup_info']['calendar']['currentver']; 
     118        $test[] = '2.3.0'; 
     119        function calendar_upgrade2_3_0() 
     120        { 
     121                $GLOBALS['setup_info']['calendar']['currentver'] = '2.4.0'; 
     122                return $GLOBALS['setup_info']['calendar']['currentver']; 
    121123        } 
    122124?> 
Note: See TracChangeset for help on using the changeset viewer.