RyXéo » GLPI

<?php

/*

 * @version $Id: update_05_051.php 7763 2009-01-06 18:44:50Z moyo $

 -------------------------------------------------------------------------

 GLPI - Gestionnaire Libre de Parc Informatique

 Copyright (C) 2003-2009 by the INDEPNET Development Team.

 http://indepnet.net/   http://glpi-project.org

 -------------------------------------------------------------------------

 LICENSE

 This file is part of GLPI.

 GLPI 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.

 GLPI is distributed in the hope that it will be useful,

 but WITHOUT ANY WARRANTY; without even the implied warranty of

 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License

 along with GLPI; if not, write to the Free Software

 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 --------------------------------------------------------------------------

 */

// ----------------------------------------------------------------------

// Original Author of file:

// Purpose of file:

// ----------------------------------------------------------------------

/// Update from 0.5 to 0.51

function update05to051(){

        global $DB,$LANG;

        echo "<p class='center'>Version 0.51 </p>";

        /*******************************GLPI 0.51***********************************************/

        if(!FieldExists("glpi_infocoms","facture")) {

                $query = "ALTER TABLE `glpi_infocoms` ADD `facture` char(255) NOT NULL default ''";

                $DB->query($query) or die("0.51 add field facture ".$LANG["update"][90].$DB->error());

        }

        if(!FieldExists("glpi_enterprises","fax")) {

                $query = "ALTER TABLE `glpi_enterprises` ADD `fax` char(255) NOT NULL default ''";

                $DB->query($query) or die("0.51 add field fax ".$LANG["update"][90].$DB->error());

        }

        if(!FieldExists("glpi_docs","link")) {

                $query = "ALTER TABLE `glpi_docs` ADD `link` char(255) NOT NULL default ''";

                $DB->query($query) or die("0.51 add field fax ".$LANG["update"][90].$DB->error());

        }

        if(!TableExists("glpi_dropdown_contact_type")) {

                $query = "CREATE TABLE glpi_dropdown_contact_type (

                        ID int(11) NOT NULL auto_increment,

                           name varchar(255) NOT NULL default '',

                           PRIMARY KEY  (ID)

                                   ) TYPE=MyISAM;";

                $DB->query($query) or die("0.51 add table dropdown_contact_type ".$LANG["update"][90].$DB->error());

                $query="INSERT INTO glpi_dropdown_contact_type (name) VALUES ('".$LANG["financial"][43]."');";

                $DB->query($query) or die("0.51 add entries to dropdown_contact_type ".$LANG["update"][90].$DB->error());

                $query="INSERT INTO glpi_dropdown_contact_type (name) VALUES ('".$LANG["financial"][42]."');";

                $DB->query($query) or die("0.51 add entries to dropdown_contact_type ".$LANG["update"][90].$DB->error());

        }

        if(!FieldExists("glpi_config","cartridges_alarm")) {

                $query = "ALTER TABLE `glpi_config` ADD `cartridges_alarm` int(11) NOT NULL default '10'";

                $DB->query($query) or die("0.51 add field cartridges_alarm ".$LANG["update"][90].$DB->error());

        }

        if(!TableExists("glpi_state_item")) {

                $query = "ALTER TABLE `glpi_repair_item` RENAME `glpi_state_item`;";

                $DB->query($query) or die("0.51 alter glpi_state_item table name ".$LANG["update"][90].$DB->error());

                $query = "ALTER TABLE `glpi_state_item` ADD `state` INT DEFAULT '1';";

                $DB->query($query) or die("0.51 add state field ".$LANG["update"][90].$DB->error());

        }

        if(!TableExists("glpi_dropdown_state")) {

                $query = "CREATE TABLE glpi_dropdown_state (

                        ID int(11) NOT NULL auto_increment,

                           name varchar(255) default NULL,

                           PRIMARY KEY  (ID)

                                   ) TYPE=MyISAM;";

                $DB->query($query) or die("0.51 add state field ".$LANG["update"][90].$DB->error());

        }

}

?>