source: branches/2.2.0.1/calendar/setup/tables_update.inc.php @ 4217

Revision 4217, 3.7 KB checked in by brunocosta, 13 years ago (diff)

Ticket #1802 - Opção nos agendamentos para enviar notificações como dono.

  • 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['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN notifications_owner INT NOT NULL deafult '0'");
86            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text");
87            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by varchar(160)");
88            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text");
89            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ALTER title TYPE varchar(300)");
90            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal_repeats ALTER recur_exception TYPE varchar");
91            $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.1';
92            return $GLOBALS['setup_info']['calendar']['currentver'];
93        }
94?>
Note: See TracBrowser for help on using the repository browser.