source: branches/2.2/phpgwapi/setup/tables_update.inc.php @ 3104

<?php
        /**************************************************************************\
        * phpGroupWare - Setup                                                     *
        * http://www.phpgroupware.org                                              *
        * --------------------------------------------                             *
        *  This program is free software; you can redistribute it and/or modify it *
        *  under the terms of the GNU General Public License as published by the   *
        *  Free Software Foundation; either version 2 of the License, or (at your  *
        *  option) any later version.                                              *
        \**************************************************************************/

        // Since Expresso 1.2 using API EgroupWare 1.0.0.007 
        $test[] = '1.0.0.007';
        function phpgwapi_upgrade1_0_0_007()
        {

                global $setup_info,$phpgw_setup;

                $phpgw_setup->oProc->AddColumn('phpgw_access_log','browser', array ('type' => 'varchar', 'precision' => 200));
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '1.0.0.008';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];

        }
        
        $test[] = '1.0.0.008';
        function phpgwapi_upgrade1_0_0_008()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.0.pre-alpha';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];

        }

        $test[] = '2.0.0.pre-alpha';
        function phpgwapi_upgrade2_0_0_prealpha()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.000';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
        $test[] = '2.0.000';
        function phpgwapi_upgrade2_0_000()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.001';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
        $test[] = '2.0.001';
        function phpgwapi_upgrade2_0_001()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.002';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }               
        $test[] = '2.0.002';
        function phpgwapi_upgrade2_0_002()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.003';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
        $test[] = '2.0.003';
        function phpgwapi_upgrade2_0_003()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.004';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
        $test[] = '2.0.004';
        function phpgwapi_upgrade2_0_004()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.005';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
        $test[] = '2.0.005';
        function phpgwapi_upgrade2_0_005()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.006';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }                       
        $test[] = '2.0.006';
        function phpgwapi_upgrade2_0_006()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.007';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }       
        $test[] = '2.0.007';
        function phpgwapi_upgrade2_0_007()
        {
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.1.000';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }       
        $test[] = '2.1.000';
        function phpgwapi_upgrade2_1_000()
        {
                global $setup_info,$phpgw_setup;
                $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ALTER COLUMN created TYPE timestamp;");
                $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ALTER COLUMN modified TYPE timestamp;");
                $phpgw_setup->oProc->query("CREATE TABLE phpgw_vfs_quota (directory VARCHAR(100), quota_size INT NOT NULL, PRIMARY KEY (directory));");
                $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ADD COLUMN type integer DEFAULT 0;");
                $phpgw_setup->oProc->query("ALTER TABLE phpgw_vfs ADD COLUMN summary bytea;");
                $phpgw_setup->oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_quota_size',500);");
                $phpgw_setup->oProc->query("INSERT INTO phpgw_config VALUES ('filemanager','filemanager_Max_file_size',20);");
                $phpgw_setup->oProc->query('INSERT INTO phpgw_preferences VALUES (-2,\'filemanager\',\'a:19:{s:4:"name";s:1:"1";s:9:"mime_type";s:1:"1";s:4:"size";s:1:"1";s:7:"created";s:1:"1";s:8:"modified";s:1:"1";s:5:"owner";s:1:"1";s:12:"createdby_id";s:1:"1";s:13:"modifiedby_id";s:1:"1";s:3:"app";s:1:"0";s:7:"comment";s:1:"1";s:7:"version";s:1:"1";s:12:"viewinnewwin";s:1:"1";s:12:"viewonserver";s:1:"1";s:13:"viewtextplain";s:1:"1";s:6:"dotdot";s:1:"1";s:8:"dotfiles";s:1:"1";s:8:"pdf_type";s:8:"portrait";s:14:"pdf_paper_type";s:2:"a4";s:14:"files_per_page";s:3:"200";}\');');
                $phpgw_setup->oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (1,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','', NULL, NULL);");
                $phpgw_setup->oProc->query("INSERT INTO phpgw_vfs (owner_id, createdby_id, modifiedby_id, created, modified, size, mime_type, deleteable, comment, app, directory, name, link_directory, link_name) VALUES (2,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','home', NULL, NULL);");
                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.000';
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
?>