source: branches/2.3/calendar/setup/tables_update.inc.php @ 5156

Revision 5156, 4.2 KB checked in by brunocosta, 9 years ago (diff)

Ticket #2142 - Ajuste do setup para publicação da versão 2.3.0

  • Property svn:eol-style set to native
  • Property svn:executable set to *
Line 
1<?php
2  /**************************************************************************\
3  * eGroupWare - Setup                                                       *
4  * http://www.egroupware.org                                                *
5  * --------------------------------------------                             *
6  *  This program is free software; you can redistribute it and/or modify it *
7  *  under the terms of the GNU General Public License as published by the   *
8  *  Free Software Foundation; either version 2 of the License, or (at your  *
9  *  option) any later version.                                              *
10  \**************************************************************************/
11        function addSpecialColumn($table,$column, $attrs){
12                $result = $GLOBALS['phpgw_setup']->db->metadata($table);
13                if($result){
14                        foreach($result as $idx => $col){
15                                if($col['name'] == $column)
16                                        return;
17                        }
18                }
19                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE ".$table." ADD COLUMN ".$column." ".$attrs);
20        }
21/// Since Expresso 1.2 using Calendar 0.9.3
22        $test[] = '0.9.3';
23        function calendar_upgrade0_9_3()
24        {
25                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.000';
26                return $GLOBALS['setup_info']['calendar']['currentver'];
27        }
28        $test[] = '2.0.000';
29        function calendar_upgrade2_0_000()
30        {
31                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.001';
32                return $GLOBALS['setup_info']['calendar']['currentver'];
33        }
34        $test[] = '2.0.001';
35        function calendar_upgrade2_0_001()
36        {
37                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.002';
38                return $GLOBALS['setup_info']['calendar']['currentver'];
39        }
40        $test[] = '2.0.002';
41        function calendar_upgrade2_0_002()
42        {
43                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.003';
44                return $GLOBALS['setup_info']['calendar']['currentver'];
45        }
46        $test[] = '2.0.003';
47        function calendar_upgrade2_0_003()
48        {
49                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.004';
50                return $GLOBALS['setup_info']['calendar']['currentver'];
51        }
52        $test[] = '2.0.004';
53        function calendar_upgrade2_0_004()
54        {
55                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.005';
56                return $GLOBALS['setup_info']['calendar']['currentver'];
57        }
58        $test[] = '2.0.005';
59        function calendar_upgrade2_0_005()
60        {
61                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.006';
62                return $GLOBALS['setup_info']['calendar']['currentver'];
63        }
64        $test[] = '2.0.006';
65        function calendar_upgrade2_0_006()
66        {
67                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.007';
68                return $GLOBALS['setup_info']['calendar']['currentver'];
69        }
70        $test[] = '2.0.007';
71        function calendar_upgrade2_0_007()
72        {
73                $GLOBALS['setup_info']['calendar']['currentver'] = '2.1.000';
74                return $GLOBALS['setup_info']['calendar']['currentver'];
75        }
76        $test[] = '2.1.000';
77        function calendar_upgrade2_1_000()
78        {
79                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.000';
80                return $GLOBALS['setup_info']['calendar']['currentver'];
81        }
82        $test[] = '2.2.000';
83        function calendar_upgrade2_2_000()
84        {
85                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.1';
86                return $GLOBALS['setup_info']['calendar']['currentver'];
87        }
88        $test[] = '2.2.1';
89        function calendar_upgrade2_2_1()
90        {
91                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.6';
92                return $GLOBALS['setup_info']['calendar']['currentver'];
93        }
94        $test[] = '2.2.6';
95        function calendar_upgrade2_2_6()
96        {
97                $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.8';
98                return $GLOBALS['setup_info']['calendar']['currentver'];
99        }
100        $test[] = '2.2.8';
101        function calendar_upgrade2_2_8()
102        {
103            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN notifications_owner INT NOT NULL default '0'");
104            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text");
105            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by varchar(160)");
106            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text");
107            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ALTER title TYPE varchar(300)");
108            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal_repeats ALTER recur_exception TYPE varchar");
109            $GLOBALS['setup_info']['calendar']['currentver'] = '2.3.0';
110            return $GLOBALS['setup_info']['calendar']['currentver'];
111        }
112?>
Note: See TracBrowser for help on using the repository browser.