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

Revision 3976, 3.4 KB checked in by rafaelraymundo, 13 years ago (diff)

Ticket #1607 - Incluir um campo Observações na Agenda

  • Property svn:eol-style set to native
  • Property svn:executable set to *
RevLine 
[2]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  \**************************************************************************/
[361]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        } 
[3031]21/// Since Expresso 1.2 using Calendar 0.9.3
[1323]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        }
[1728]28        $test[] = '2.0.000';
29        function calendar_upgrade2_0_000()
30        {
[1835]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        {
[3031]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        {
[3765]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        {
[1728]73                $GLOBALS['setup_info']['calendar']['currentver'] = '2.1.000';
74                return $GLOBALS['setup_info']['calendar']['currentver'];
75        }
[3031]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        }
[3973]82        $test[] = '2.2.000';
83        function calendar_upgrade2_2_000()
[3966]84        {
[3976]85            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text");
[3968]86            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by varchar(160)");
[3973]87            $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text");
88            $GLOBALS['setup_info']['calendar']['currentver'] = '2.2.001';
[3968]89            return $GLOBALS['setup_info']['calendar']['currentver'];
90        }
[3973]91?>
Note: See TracBrowser for help on using the repository browser.