ryxeo-glpi-git / install / update_0681_07.php @ b67d8923
Historique | Voir | Annoter | Télécharger (70,6 ko)
| 1 |
<?php
|
|---|---|
| 2 |
|
| 3 |
|
| 4 |
/*
|
| 5 |
* @version $Id: update_0681_07.php 7763 2009-01-06 18:44:50Z moyo $
|
| 6 |
-------------------------------------------------------------------------
|
| 7 |
GLPI - Gestionnaire Libre de Parc Informatique
|
| 8 |
Copyright (C) 2003-2009 by the INDEPNET Development Team.
|
| 9 |
|
| 10 |
http://indepnet.net/ http://glpi-project.org
|
| 11 |
-------------------------------------------------------------------------
|
| 12 |
|
| 13 |
LICENSE
|
| 14 |
|
| 15 |
This file is part of GLPI.
|
| 16 |
|
| 17 |
GLPI is free software; you can redistribute it and/or modify
|
| 18 |
it under the terms of the GNU General Public License as published by
|
| 19 |
the Free Software Foundation; either version 2 of the License, or
|
| 20 |
(at your option) any later version.
|
| 21 |
|
| 22 |
GLPI is distributed in the hope that it will be useful,
|
| 23 |
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
| 24 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
| 25 |
GNU General Public License for more details.
|
| 26 |
|
| 27 |
You should have received a copy of the GNU General Public License
|
| 28 |
along with GLPI; if not, write to the Free Software
|
| 29 |
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
| 30 |
--------------------------------------------------------------------------
|
| 31 |
*/
|
| 32 |
|
| 33 |
// ----------------------------------------------------------------------
|
| 34 |
// Original Author of file:
|
| 35 |
// Purpose of file:
|
| 36 |
// ----------------------------------------------------------------------
|
| 37 |
|
| 38 |
/// Update from 0.68.1 to 0.7
|
| 39 |
function update0681to07() { |
| 40 |
global $DB, $CFG_GLPI, $LANG, $LINK_ID_TABLE; |
| 41 |
|
| 42 |
@mysql_query("SET NAMES 'latin1'",$DB->dbh); |
| 43 |
|
| 44 |
// Improve user table :
|
| 45 |
if (!isIndex("glpi_users", "firstname")) { |
| 46 |
$query = "ALTER TABLE `glpi_users` ADD INDEX ( `firstname` )"; |
| 47 |
$DB->query($query) or die("0.7 alter users add index on firstname " . $LANG["update"][90] . $DB->error()); |
| 48 |
} |
| 49 |
if (!isIndex("glpi_users", "realname")) { |
| 50 |
$query = "ALTER TABLE `glpi_users` ADD INDEX ( `realname` )"; |
| 51 |
$DB->query($query) or die("0.7 alter users add index on realname " . $LANG["update"][90] . $DB->error()); |
| 52 |
} |
| 53 |
// Decimal problem
|
| 54 |
if (FieldExists("glpi_infocoms", "value")) { |
| 55 |
$query = "ALTER TABLE `glpi_infocoms` CHANGE `value` `value` DECIMAL( 20, 4 ) NOT NULL DEFAULT '0';"; |
| 56 |
$DB->query($query) or die("0.7 alter value in glpi_infocoms " . $LANG["update"][90] . $DB->error()); |
| 57 |
} |
| 58 |
if (FieldExists("glpi_infocoms", "warranty_value")) { |
| 59 |
$query = "ALTER TABLE `glpi_infocoms` CHANGE warranty_value warranty_value DECIMAL( 20, 4 ) NOT NULL DEFAULT '0';"; |
| 60 |
$DB->query($query) or die("0.7 alter warranty_value in glpi_infocoms " . $LANG["update"][90] . $DB->error()); |
| 61 |
} |
| 62 |
if (FieldExists("glpi_tracking", "cost_time")) { |
| 63 |
$query = "ALTER TABLE `glpi_tracking` CHANGE cost_time cost_time DECIMAL( 20, 4 ) NOT NULL DEFAULT '0';"; |
| 64 |
$DB->query($query) or die("0.7 alter cost_time in glpi_tracking " . $LANG["update"][90] . $DB->error()); |
| 65 |
} |
| 66 |
if (FieldExists("glpi_tracking", "cost_fixed")) { |
| 67 |
$query = "ALTER TABLE `glpi_tracking` CHANGE cost_fixed cost_fixed DECIMAL( 20, 4 ) NOT NULL DEFAULT '0';"; |
| 68 |
$DB->query($query) or die("0.7 alter cost_fixed in glpi_tracking " . $LANG["update"][90] . $DB->error()); |
| 69 |
} |
| 70 |
if (FieldExists("glpi_tracking", "cost_material")) { |
| 71 |
$query = "ALTER TABLE `glpi_tracking` CHANGE cost_material cost_material DECIMAL( 20, 4 ) NOT NULL DEFAULT '0';"; |
| 72 |
$DB->query($query) or die("0.7 alter cost_material in glpi_tracking " . $LANG["update"][90] . $DB->error()); |
| 73 |
} |
| 74 |
if (!FieldExists("glpi_config", "decimal_number")) { |
| 75 |
$query = "ALTER TABLE `glpi_config` ADD `decimal_number` INT DEFAULT '2';"; |
| 76 |
$DB->query($query) or die("0.7 add decimal_number in glpi_config " . $LANG["update"][90] . $DB->error()); |
| 77 |
} |
| 78 |
$CFG_GLPI["decimal_number"] = 2; |
| 79 |
|
| 80 |
if (!FieldExists("glpi_config", "cas_logout")) { |
| 81 |
$query = "ALTER TABLE `glpi_config` ADD `cas_logout` VARCHAR( 255 ) NULL AFTER `cas_uri`;"; |
| 82 |
$DB->query($query) or die("0.7 add cas_logout in glpi_config " . $LANG["update"][90] . $DB->error()); |
| 83 |
} |
| 84 |
|
| 85 |
if (!isIndex("glpi_computer_device", "specificity")) { |
| 86 |
$query = "ALTER TABLE `glpi_computer_device` ADD INDEX ( `specificity` )"; |
| 87 |
$DB->query($query) or die("0.7 add index specificity in glpi_computer_device " . $LANG["update"][90] . $DB->error()); |
| 88 |
} |
| 89 |
|
| 90 |
if (!FieldExists("glpi_docs", "comments")) { |
| 91 |
$query = "ALTER TABLE `glpi_docs` CHANGE `comment` `comments` TEXT DEFAULT NULL "; |
| 92 |
$DB->query($query) or die("0.7 alter docs.comment to be comments" . $LANG["update"][90] . $DB->error()); |
| 93 |
|
| 94 |
} |
| 95 |
// Update polish langage file
|
| 96 |
$query = "UPDATE glpi_users SET language='pl_PL' WHERE language='po_PO'"; |
| 97 |
$DB->query($query) or die("0.7 update polish lang file " . $LANG["update"][90] . $DB->error()); |
| 98 |
|
| 99 |
// Add show_group_hardware
|
| 100 |
if (!FieldExists("glpi_profiles", "show_group_hardware")) { |
| 101 |
$query = "ALTER TABLE `glpi_profiles` ADD `show_group_hardware` CHAR( 1 ) NULL DEFAULT '0';"; |
| 102 |
$DB->query($query) or die("0.7 alter glpi_profiles add show_group_hardware" . $LANG["update"][90] . $DB->error()); |
| 103 |
$query = "UPDATE glpi_profiles SET `show_group_hardware`=`show_group_ticket`"; |
| 104 |
$DB->query($query) or die("0.7 alter glpi_profiles add show_group_hardware" . $LANG["update"][90] . $DB->error()); |
| 105 |
} |
| 106 |
|
| 107 |
// Clean doc association
|
| 108 |
if (FieldExists("glpi_doc_device", "is_template")) { |
| 109 |
$query = "ALTER TABLE `glpi_doc_device` DROP `is_template`"; |
| 110 |
$DB->query($query) or die("0.7 delete is_template from glpi_doc_device" . $LANG["update"][90] . $DB->error()); |
| 111 |
} |
| 112 |
|
| 113 |
// Clean contract association
|
| 114 |
if (FieldExists("glpi_contract_device", "is_template")) { |
| 115 |
$query = "ALTER TABLE `glpi_contract_device` DROP `is_template`"; |
| 116 |
$DB->query($query) or die("0.7 delete is_template from glpi_contract_device" . $LANG["update"][90] . $DB->error()); |
| 117 |
} |
| 118 |
|
| 119 |
|
| 120 |
|
| 121 |
//// ENTITY MANAGEMENT
|
| 122 |
|
| 123 |
if (!TableExists("glpi_entities")) { |
| 124 |
$query = "CREATE TABLE `glpi_entities` ( |
| 125 |
`ID` int(11) NOT NULL auto_increment,
|
| 126 |
`name` varchar(255) NOT NULL,
|
| 127 |
`parentID` int(11) NOT NULL default '0',
|
| 128 |
`completename` text NOT NULL,
|
| 129 |
`comments` text,
|
| 130 |
`level` int(11) default NULL,
|
| 131 |
PRIMARY KEY (`ID`),
|
| 132 |
UNIQUE KEY `name` (`name`,`parentID`),
|
| 133 |
KEY `parentID` (`parentID`)
|
| 134 |
) ENGINE=MyISAM;";
|
| 135 |
$DB->query($query) or die("0.7 create glpi_entities " . $LANG["update"][90] . $DB->error()); |
| 136 |
} |
| 137 |
|
| 138 |
if (!TableExists("glpi_entities_data")) { |
| 139 |
$query = "CREATE TABLE `glpi_entities_data` ( |
| 140 |
`ID` int(11) NOT NULL auto_increment,
|
| 141 |
`FK_entities` int(11) NOT NULL default '0',
|
| 142 |
`address` text,
|
| 143 |
`postcode` varchar(255) default NULL,
|
| 144 |
`town` varchar(255) default NULL,
|
| 145 |
`state` varchar(255) default NULL,
|
| 146 |
`country` varchar(255) default NULL,
|
| 147 |
`website` varchar(200) default NULL,
|
| 148 |
`phonenumber` varchar(200) default NULL,
|
| 149 |
`fax` varchar(255) default NULL,
|
| 150 |
`email` varchar(255) default NULL,
|
| 151 |
`notes` longtext,
|
| 152 |
PRIMARY KEY (`ID`),
|
| 153 |
UNIQUE KEY `FK_entities` (`FK_entities`)
|
| 154 |
) ENGINE=MyISAM ;";
|
| 155 |
|
| 156 |
$DB->query($query) or die("0.7 create glpi_entities_data " . $LANG["update"][90] . $DB->error()); |
| 157 |
} |
| 158 |
|
| 159 |
// Add default profile to all users without any profile
|
| 160 |
$query="SELECT ID FROM glpi_profiles WHERE is_default='1'"; |
| 161 |
if ($result=$DB->query($query)){ |
| 162 |
if ($DB->numrows($result)>0){ |
| 163 |
$IDprof=$DB->result($result,0,0); |
| 164 |
$query="SELECT glpi_users.ID |
| 165 |
FROM glpi_users LEFT JOIN glpi_users_profiles ON (glpi_users_profiles.FK_users = glpi_users.ID )
|
| 166 |
WHERE glpi_users_profiles.ID IS NULL";
|
| 167 |
if ($result=$DB->query($query)){ |
| 168 |
if ($DB->numrows($result)>0){ |
| 169 |
while ($data=$DB->fetch_assoc($result)){ |
| 170 |
$query="INSERT INTO glpi_users_profiles (`FK_users` ,`FK_profiles`) VALUES ('".$data['ID']."','$IDprof') "; |
| 171 |
$DB->query($query); |
| 172 |
} |
| 173 |
} |
| 174 |
} |
| 175 |
|
| 176 |
} |
| 177 |
} |
| 178 |
|
| 179 |
|
| 180 |
|
| 181 |
if (!FieldExists("glpi_users_profiles", "FK_entities")) { |
| 182 |
// Clean Datas
|
| 183 |
$query = "DELETE FROM glpi_users_profiles WHERE FK_users='0'"; |
| 184 |
$DB->query($query) or die("0.7 clean datas of glpi_users_profiles " . $LANG["update"][90] . $DB->error()); |
| 185 |
|
| 186 |
$query = " ALTER TABLE `glpi_users_profiles` ADD `FK_entities` INT NOT NULL DEFAULT '0', |
| 187 |
ADD `recursive` SMALLINT NOT NULL DEFAULT '1',
|
| 188 |
ADD `dynamic` SMALLINT NOT NULL DEFAULT '0' ";
|
| 189 |
$DB->query($query) or die("0.7 alter glpi_users_profiles " . $LANG["update"][90] . $DB->error()); |
| 190 |
} |
| 191 |
// Correct for clean active field for beta users
|
| 192 |
if (FieldExists("glpi_users_profiles", "active")) { |
| 193 |
$query = "ALTER TABLE `glpi_users_profiles` DROP `active` "; |
| 194 |
$DB->query($query) or die("0.7 clean active field for beta of glpi_users_profiles " . $LANG["update"][90] . $DB->error()); |
| 195 |
} |
| 196 |
if (!FieldExists("glpi_users", "active")) { |
| 197 |
$query = "ALTER TABLE `glpi_users` ADD `active` INT(2) NOT NULL DEFAULT '1' "; |
| 198 |
$DB->query($query) or die("0.7 add active field for beta of glpi_users " . $LANG["update"][90] . $DB->error()); |
| 199 |
if (!isIndex("glpi_users", "active")) { |
| 200 |
$query = "ALTER TABLE `glpi_users` ADD INDEX (`active`);"; |
| 201 |
$DB->query($query) or die("0.7 add index active in glpi_users " . $LANG["update"][90] . $DB->error()); |
| 202 |
} |
| 203 |
} |
| 204 |
|
| 205 |
// Add entity tags to tables
|
| 206 |
$tables = array ( |
| 207 |
"glpi_cartridges_type",
|
| 208 |
"glpi_computers",
|
| 209 |
"glpi_consumables_type",
|
| 210 |
"glpi_contacts",
|
| 211 |
"glpi_contracts",
|
| 212 |
"glpi_docs",
|
| 213 |
"glpi_dropdown_locations",
|
| 214 |
"glpi_dropdown_netpoint",
|
| 215 |
"glpi_enterprises",
|
| 216 |
"glpi_groups",
|
| 217 |
"glpi_monitors",
|
| 218 |
"glpi_networking",
|
| 219 |
"glpi_peripherals",
|
| 220 |
"glpi_phones",
|
| 221 |
"glpi_printers",
|
| 222 |
"glpi_reminder",
|
| 223 |
"glpi_software",
|
| 224 |
"glpi_tracking"
|
| 225 |
); |
| 226 |
// "glpi_kbitems","glpi_dropdown_kbcategories", -> easier to manage
|
| 227 |
// "glpi_followups" -> always link to tracking ?
|
| 228 |
// "glpi_licenses" -> always link to software ?
|
| 229 |
// "glpi_infocoms" -> always link to item ? PB on reports stats ?
|
| 230 |
// "glpi_links" -> global items easier to manage
|
| 231 |
// "glpi_reservation_item", "glpi_state_item" -> always link to item ? but info maybe needed
|
| 232 |
foreach ($tables as $tbl) { |
| 233 |
if (!FieldExists($tbl, "FK_entities")) { |
| 234 |
$query = "ALTER TABLE `" . $tbl . "` ADD `FK_entities` INT NOT NULL DEFAULT '0' AFTER `ID`"; |
| 235 |
$DB->query($query) or die("0.7 add FK_entities in $tbl " . $LANG["update"][90] . $DB->error()); |
| 236 |
} |
| 237 |
|
| 238 |
if (!isIndex($tbl, "FK_entities")) { |
| 239 |
$query = "ALTER TABLE `" . $tbl . "` ADD INDEX (`FK_entities`)"; |
| 240 |
$DB->query($query) or die("0.7 add index FK_entities in $tbl " . $LANG["update"][90] . $DB->error()); |
| 241 |
} |
| 242 |
} |
| 243 |
|
| 244 |
// Regenerate Indexes :
|
| 245 |
$tables = array ( |
| 246 |
"glpi_dropdown_locations"
|
| 247 |
); |
| 248 |
foreach ($tables as $tbl) { |
| 249 |
if (isIndex($tbl, "name")) { |
| 250 |
$query = "ALTER TABLE `$tbl` DROP INDEX `name`;"; |
| 251 |
$DB->query($query) or die("0.7 drop index name in $tbl " . $LANG["update"][90] . $DB->error()); |
| 252 |
} |
| 253 |
if (isIndex($tbl, "parentID_2")) { |
| 254 |
$query = "ALTER TABLE `$tbl` DROP INDEX `parentID_2`;"; |
| 255 |
$DB->query($query) or die("0.7 drop index name in $tbl " . $LANG["update"][90] . $DB->error()); |
| 256 |
} |
| 257 |
$query = "ALTER TABLE `$tbl` ADD UNIQUE(`name`,`parentID`,`FK_entities`);"; |
| 258 |
$DB->query($query) or die("0.7 add index name in $tbl " . $LANG["update"][90] . $DB->error()); |
| 259 |
|
| 260 |
} |
| 261 |
|
| 262 |
if (isIndex("glpi_users_profiles", "FK_users_profiles")) { |
| 263 |
$query = "ALTER TABLE `glpi_users_profiles` DROP INDEX `FK_users_profiles`;"; |
| 264 |
$DB->query($query) or die("0.7 drop index FK_users_profiles in glpi_users_profiles " . $LANG["update"][90] . $DB->error()); |
| 265 |
} |
| 266 |
|
| 267 |
if (!isIndex("glpi_users_profiles", "FK_entities")) { |
| 268 |
$query = "ALTER TABLE `glpi_users_profiles` ADD INDEX (`FK_entities`);"; |
| 269 |
$DB->query($query) or die("0.7 add index FK_entities in glpi_users_profiles " . $LANG["update"][90] . $DB->error()); |
| 270 |
} |
| 271 |
|
| 272 |
if (!isIndex("glpi_users_profiles", "recursive")) { |
| 273 |
$query = "ALTER TABLE `glpi_users_profiles` ADD INDEX (`recursive`);"; |
| 274 |
$DB->query($query) or die("0.7 add index recursive in glpi_users_profiles " . $LANG["update"][90] . $DB->error()); |
| 275 |
} |
| 276 |
|
| 277 |
//// MULTIAUTH MANAGEMENT
|
| 278 |
|
| 279 |
if (!TableExists("glpi_auth_ldap")) { |
| 280 |
$query = "CREATE TABLE `glpi_auth_ldap` ( |
| 281 |
`ID` int(11) NOT NULL auto_increment,
|
| 282 |
`name` varchar(255) NOT NULL,
|
| 283 |
`ldap_host` varchar(255) default NULL,
|
| 284 |
`ldap_basedn` varchar(255) default NULL,
|
| 285 |
`ldap_rootdn` varchar(255) default NULL,
|
| 286 |
`ldap_pass` varchar(255) default NULL,
|
| 287 |
`ldap_port` varchar(255) NOT NULL default '389',
|
| 288 |
`ldap_condition` varchar(255) default NULL,
|
| 289 |
`ldap_login` varchar(255) NOT NULL default 'uid',
|
| 290 |
`ldap_use_tls` varchar(255) NOT NULL default '0',
|
| 291 |
`ldap_field_group` varchar(255) default NULL,
|
| 292 |
`ldap_group_condition` varchar(255) default NULL,
|
| 293 |
`ldap_search_for_groups` int NOT NULL default '0',
|
| 294 |
`ldap_field_group_member` varchar(255) default NULL,
|
| 295 |
`ldap_field_email` varchar(255) default NULL,
|
| 296 |
`ldap_field_realname` varchar(255) default NULL,
|
| 297 |
`ldap_field_firstname` varchar(255) default NULL,
|
| 298 |
`ldap_field_phone` varchar(255) default NULL,
|
| 299 |
`ldap_field_phone2` varchar(255) default NULL,
|
| 300 |
`ldap_field_mobile` varchar(255) default NULL,
|
| 301 |
`ldap_field_comments` TEXT default NULL,
|
| 302 |
PRIMARY KEY (`ID`)
|
| 303 |
) ENGINE=MyISAM;";
|
| 304 |
$DB->query($query) or die("0.7 create glpi_auth_ldap " . $LANG["update"][90] . $DB->error()); |
| 305 |
|
| 306 |
$query = "select * from glpi_config WHERE ID=1"; |
| 307 |
$result = $DB->query($query); |
| 308 |
$config = $DB->fetch_array($result); |
| 309 |
|
| 310 |
if (!empty ($config["ldap_host"])) { |
| 311 |
|
| 312 |
//Transfer ldap informations into the new table
|
| 313 |
|
| 314 |
$query = "INSERT INTO `glpi_auth_ldap` VALUES |
| 315 |
(NULL, '" . $config["ldap_host"] . "', '" . $config["ldap_host"] . "', '" . $config["ldap_basedn"] . "', '" . $config["ldap_rootdn"] . "', '" . $config["ldap_pass"] . "', " . $config["ldap_port"] . ", '" . $config["ldap_condition"] . "', '" . $config["ldap_login"] . "', '" . $config["ldap_use_tls"] . "', '" . $config["ldap_field_group"] . "', |
| 316 |
'" . $config["ldap_condition"] . "', " . $config["ldap_search_for_groups"] . ", '" . $config["ldap_field_group_member"] . "', |
| 317 |
'" . $config["ldap_field_email"] . "', '" . $config["ldap_field_realname"] . "', '" . $config["ldap_field_firstname"] . "', |
| 318 |
'" . $config["ldap_field_phone"] . "', '" . $config["ldap_field_phone2"] . "', '" . $config["ldap_field_mobile"] . "',NULL);"; |
| 319 |
$DB->query($query) or die("0.7 transfert of ldap parameters into glpi_auth_ldap " . $LANG["update"][90] . $DB->error()); |
| 320 |
} |
| 321 |
|
| 322 |
$query = "ALTER TABLE `glpi_config` |
| 323 |
DROP `ldap_field_email`,
|
| 324 |
DROP `ldap_port`,
|
| 325 |
DROP `ldap_host`,
|
| 326 |
DROP `ldap_basedn`,
|
| 327 |
DROP `ldap_rootdn`,
|
| 328 |
DROP `ldap_pass`,
|
| 329 |
DROP `ldap_field_location`,
|
| 330 |
DROP `ldap_field_realname`,
|
| 331 |
DROP `ldap_field_firstname`,
|
| 332 |
DROP `ldap_field_phone`,
|
| 333 |
DROP `ldap_field_phone2`,
|
| 334 |
DROP `ldap_field_mobile`,
|
| 335 |
DROP `ldap_condition`,
|
| 336 |
DROP `ldap_login`,
|
| 337 |
DROP `ldap_use_tls`,
|
| 338 |
DROP `ldap_field_group`,
|
| 339 |
DROP `ldap_group_condition`,
|
| 340 |
DROP `ldap_search_for_groups`,
|
| 341 |
DROP `ldap_field_group_member`;";
|
| 342 |
$DB->query($query) or die("0.7 drop ldap fields from glpi_config " . $LANG["update"][90] . $DB->error()); |
| 343 |
|
| 344 |
} |
| 345 |
if (!FieldExists("glpi_users", "id_auth")) { |
| 346 |
$query = "ALTER TABLE glpi_users ADD `id_auth` INT NOT NULL DEFAULT '-1', |
| 347 |
ADD `auth_method` INT NOT NULL DEFAULT '-1',
|
| 348 |
ADD `last_login` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
|
| 349 |
ADD `date_mod` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'";
|
| 350 |
$DB->query($query) or die("0.7 add auth_method & id_method in glpi_users " . $LANG["update"][90] . $DB->error()); |
| 351 |
} |
| 352 |
|
| 353 |
if (!TableExists("glpi_auth_mail")) { |
| 354 |
$query = "CREATE TABLE `glpi_auth_mail` ( |
| 355 |
`ID` int(11) NOT NULL auto_increment,
|
| 356 |
`name` varchar(255) NOT NULL,
|
| 357 |
`imap_auth_server` varchar(200) default NULL,
|
| 358 |
`imap_host` varchar(200) default NULL,
|
| 359 |
PRIMARY KEY (`ID`)
|
| 360 |
) ENGINE=MyISAM ;";
|
| 361 |
|
| 362 |
$DB->query($query) or die("0.7 create glpi_auth_mail " . $LANG["update"][90] . $DB->error()); |
| 363 |
|
| 364 |
$query = "select * from glpi_config WHERE ID=1"; |
| 365 |
$result = $DB->query($query); |
| 366 |
$config = $DB->fetch_array($result); |
| 367 |
|
| 368 |
if (!empty ($config["imap_host"])) { |
| 369 |
|
| 370 |
//Transfer ldap informations into the new table
|
| 371 |
$query = "INSERT INTO `glpi_auth_mail` VALUES |
| 372 |
(NULL, '" . $config["imap_host"] . "', '" . $config["imap_auth_server"] . "', '" . $config["imap_host"] . "');"; |
| 373 |
$DB->query($query) or die("0.7 transfert of mail parameters into glpi_auth_mail " . $LANG["update"][90] . $DB->error()); |
| 374 |
|
| 375 |
} |
| 376 |
|
| 377 |
$query = "ALTER TABLE `glpi_config` |
| 378 |
DROP `imap_auth_server`,
|
| 379 |
DROP `imap_host`";
|
| 380 |
$DB->query($query) or die("0.7 drop mail fields from glpi_config " . $LANG["update"][90] . $DB->error()); |
| 381 |
|
| 382 |
} |
| 383 |
|
| 384 |
// Clean state_item -> add a field from tables
|
| 385 |
if (TableExists("glpi_state_item")) { |
| 386 |
$state_type = array ( |
| 387 |
SOFTWARE_TYPE,
|
| 388 |
COMPUTER_TYPE,
|
| 389 |
PRINTER_TYPE,
|
| 390 |
MONITOR_TYPE,
|
| 391 |
PERIPHERAL_TYPE,
|
| 392 |
NETWORKING_TYPE,
|
| 393 |
PHONE_TYPE
|
| 394 |
); |
| 395 |
foreach ($state_type as $type) { |
| 396 |
$table = $LINK_ID_TABLE[$type]; |
| 397 |
if (!FieldExists($table, "state")) { |
| 398 |
$query = "ALTER TABLE `$table` ADD `state` INT NOT NULL DEFAULT '0';"; |
| 399 |
$DB->query($query) or die("0.7 add state field to $table " . $LANG["update"][90] . $DB->error()); |
| 400 |
$query2 = "SELECT * FROM glpi_state_item WHERE device_type='$type'"; |
| 401 |
$result = $DB->query($query2); |
| 402 |
if ($DB->numrows($result)) { |
| 403 |
while ($data = $DB->fetch_array($result)) { |
| 404 |
$query3 = "UPDATE $table SET state='" . $data["state"] . "' WHERE ID ='" . $data["id_device"] . "'"; |
| 405 |
$DB->query($query3) or die("0.7 update state field value to $table " . $LANG["update"][90] . $DB->error()); |
| 406 |
} |
| 407 |
} |
| 408 |
} |
| 409 |
} |
| 410 |
$query = "DROP TABLE `glpi_state_item` "; |
| 411 |
$DB->query($query) or die("0.7 drop table state_item " . $LANG["update"][90] . $DB->error()); |
| 412 |
$query = "INSERT INTO `glpi_display` (`type`, `num`, `rank`, `FK_users`) VALUES (22, 31, 1, 0);"; |
| 413 |
$DB->query($query) or die("0.7 add default search for states " . $LANG["update"][90] . $DB->error()); |
| 414 |
// Add for reservation
|
| 415 |
$query = "INSERT INTO `glpi_display` (`type`, `num`, `rank`, `FK_users`) VALUES ( 29, 4, 1, 0);"; |
| 416 |
$DB->query($query) or die("0.7 add defaul search for reservation " . $LANG["update"][90] . $DB->error()); |
| 417 |
$query = "INSERT INTO `glpi_display` (`type`, `num`, `rank`, `FK_users`) VALUES ( 29, 3, 2, 0);"; |
| 418 |
$DB->query($query) or die("0.7 add defaul search for reservation " . $LANG["update"][90] . $DB->error()); |
| 419 |
} |
| 420 |
|
| 421 |
// Add ticket_tco for hardwares
|
| 422 |
$tco_tbl = array ( |
| 423 |
COMPUTER_TYPE,
|
| 424 |
NETWORKING_TYPE,
|
| 425 |
PRINTER_TYPE,
|
| 426 |
MONITOR_TYPE,
|
| 427 |
PERIPHERAL_TYPE,
|
| 428 |
SOFTWARE_TYPE,
|
| 429 |
PHONE_TYPE
|
| 430 |
); |
| 431 |
include (GLPI_ROOT . "/inc/tracking.function.php"); |
| 432 |
|
| 433 |
foreach ($tco_tbl as $type) { |
| 434 |
$table = $LINK_ID_TABLE[$type]; |
| 435 |
if (!FieldExists($table, "ticket_tco")) { |
| 436 |
$query = "ALTER TABLE `$table` ADD `ticket_tco` DECIMAL( 20, 4 ) DEFAULT '0.0000';"; |
| 437 |
$DB->query($query) or die("0.7 alter $table add ticket_tco" . $LANG["update"][90] . $DB->error()); |
| 438 |
// Update values
|
| 439 |
$query = "SELECT DISTINCT device_type, computer |
| 440 |
FROM glpi_tracking
|
| 441 |
WHERE device_type = '$type' AND (cost_time>0
|
| 442 |
OR cost_fixed>0
|
| 443 |
OR cost_material>0)";
|
| 444 |
$result = $DB->query($query) or die("0.7 update ticket_tco" . $LANG["update"][90] . $DB->error()); |
| 445 |
if ($DB->numrows($result)) { |
| 446 |
while ($data = $DB->fetch_array($result)) { |
| 447 |
$query2 = "UPDATE $table SET ticket_tco='" . computeTicketTco($type, $data["computer"]) . "' |
| 448 |
WHERE ID='" . $data["computer"] . "';"; |
| 449 |
$DB->query($query2) or die("0.7 update ticket_tco" . $LANG["update"][90] . $DB->error()); |
| 450 |
} |
| 451 |
} |
| 452 |
} |
| 453 |
} |
| 454 |
if (!FieldExists("glpi_software", "helpdesk_visible")) { |
| 455 |
$query = "ALTER TABLE glpi_software ADD `helpdesk_visible` INT NOT NULL default '1'"; |
| 456 |
$DB->query($query) or die("0.7 add helpdesk_visible in glpi_software " . $LANG["update"][90] . $DB->error()); |
| 457 |
} |
| 458 |
|
| 459 |
if (!TableExists("glpi_dropdown_manufacturer")) { |
| 460 |
|
| 461 |
$query = "CREATE TABLE `glpi_dropdown_manufacturer` ( |
| 462 |
`ID` int(11) NOT NULL auto_increment,
|
| 463 |
`name` varchar(255) NOT NULL,
|
| 464 |
`comments` text,
|
| 465 |
PRIMARY KEY (`ID`),
|
| 466 |
KEY `name` (`name`)
|
| 467 |
) ENGINE=MyISAM ;";
|
| 468 |
$DB->query($query) or die("0.7 add dropdown_manufacturer table " . $LANG["update"][90] . $DB->error()); |
| 469 |
} |
| 470 |
if (countElementsInTable("glpi_dropdown_manufacturer")==0){ |
| 471 |
|
| 472 |
// Fill table
|
| 473 |
$query = "SELECT * FROM glpi_enterprises ORDER BY ID"; |
| 474 |
if ($result = $DB->query($query)) { |
| 475 |
if ($DB->numrows($result)) { |
| 476 |
while ($data = $DB->fetch_assoc($result)) { |
| 477 |
$data = addslashes_deep($data); |
| 478 |
|
| 479 |
$comments = ""; |
| 480 |
if (!empty ($data['address'])) { |
| 481 |
if (!empty ($comments)) |
| 482 |
$comments .= "\n"; |
| 483 |
$comments .= $LANG["financial"][44] . ":\n"; |
| 484 |
$comments .= $data['address']; |
| 485 |
} |
| 486 |
if (!empty ($data['postcode']) || !empty ($data['town'])) { |
| 487 |
if (!empty ($comments)) |
| 488 |
$comments .= $LANG["financial"][44] . ":\n"; |
| 489 |
$comments .= $data['postcode'] . " " . $data['town']; |
| 490 |
} |
| 491 |
if (!empty ($data['state']) || !empty ($data['country'])) { |
| 492 |
if (!empty ($comments)) |
| 493 |
$comments .= $LANG["financial"][44] . ":\n"; |
| 494 |
$comments .= $data['country'] . " " . $data['state']; |
| 495 |
} |
| 496 |
if (!empty ($data['website'])) { |
| 497 |
if (!empty ($comments)) |
| 498 |
$comments .= "\n"; |
| 499 |
$comments .= $LANG["financial"][45] . ": "; |
| 500 |
$comments .= $data['website']; |
| 501 |
} |
| 502 |
if (!empty ($data['phonenumber'])) { |
| 503 |
if (!empty ($comments)) |
| 504 |
$comments .= "\n"; |
| 505 |
$comments .= $LANG["help"][35] . ": "; |
| 506 |
$comments .= $data['phonenumber']; |
| 507 |
} |
| 508 |
if (!empty ($data['fax'])) { |
| 509 |
if (!empty ($comments)) |
| 510 |
$comments .= "\n"; |
| 511 |
$comments .= $LANG["financial"][30] . ": "; |
| 512 |
$comments .= $data['fax']; |
| 513 |
} |
| 514 |
if (!empty ($data['email'])) { |
| 515 |
if (!empty ($comments)) |
| 516 |
$comments .= "\n"; |
| 517 |
$comments .= $LANG["setup"][14] . ": "; |
| 518 |
$comments .= $data['email']; |
| 519 |
} |
| 520 |
if (!empty ($data['comments'])) { |
| 521 |
if (!empty ($comments)) |
| 522 |
$comments .= "\n"; |
| 523 |
$comments .= $data['comments']; |
| 524 |
} |
| 525 |
if (!empty ($data['notes'])) { |
| 526 |
if (!empty ($comments)) |
| 527 |
$comments .= "\n"; |
| 528 |
$comments .= $data['notes']; |
| 529 |
} |
| 530 |
|
| 531 |
$query2 = "INSERT INTO `glpi_dropdown_manufacturer` (ID,name,comments) VALUES ('" . $data['ID'] . "','" . $data['name'] . "','".$comments."')"; |
| 532 |
$DB->query($query2) or die("0.7 add manufacturer item " . $LANG["update"][90] . $DB->error()); |
| 533 |
} |
| 534 |
} |
| 535 |
} |
| 536 |
} |
| 537 |
|
| 538 |
if (isIndex("glpi_ocs_link", "ocs_id_2")) { |
| 539 |
$query = "ALTER TABLE `glpi_ocs_link` DROP INDEX `ocs_id_2` "; |
| 540 |
$DB->query($query) or die("0.7 alter ocs_link clean index ocs_id " . $LANG["update"][90] . $DB->error()); |
| 541 |
} |
| 542 |
|
| 543 |
if (isIndex("glpi_ocs_link", "ocs_id")) { |
| 544 |
$query = "ALTER TABLE `glpi_ocs_link` DROP INDEX `ocs_id` "; |
| 545 |
$DB->query($query) or die("0.7 alter ocs_link clean index ocs_id " . $LANG["update"][90] . $DB->error()); |
| 546 |
} |
| 547 |
|
| 548 |
|
| 549 |
if (!FieldExists("glpi_ocs_link", "ocs_server_id")) { |
| 550 |
$query = "ALTER TABLE glpi_ocs_link ADD `ocs_server_id` int(11) NOT NULL"; |
| 551 |
$DB->query($query) or die("0.7 add ocs_server_id in glpi_ocs_link " . $LANG["update"][90] . $DB->error()); |
| 552 |
$query = "update glpi_ocs_link set ocs_server_id=1"; |
| 553 |
$DB->query($query) or die("0.7 update ocs_server_id=1 in glpi_ocs_link " . $LANG["update"][90] . $DB->error()); |
| 554 |
} |
| 555 |
|
| 556 |
if (!isIndex("glpi_ocs_link", "ocs_server_id")) { |
| 557 |
// Clean duplicates
|
| 558 |
$query="SELECT COUNT(*) as CPT, ocs_id FROM glpi_ocs_link GROUP BY ocs_id HAVING CPT >1"; |
| 559 |
if ($result=$DB->query($query)){ |
| 560 |
if ($DB->numrows($result)>0){ |
| 561 |
while ($data=$DB->fetch_array($result)){ |
| 562 |
// Skip first
|
| 563 |
$query="SELECT ID FROM glpi_ocs_link WHERE ocs_id = '".$data['ocs_id']."' ORDER BY last_update DESC LIMIT 1,99999"; |
| 564 |
if ($result2=$DB->query($query)){ |
| 565 |
if ($DB->numrows($result2)){ |
| 566 |
while ($data2=$DB->fetch_array($result2)){ |
| 567 |
$query="DELETE FROM glpi_ocs_link WHERE ID ='".$data2['ID']."'"; |
| 568 |
$DB->query($query) or die("0.7 clean to update ocs_server_id=1 in glpi_ocs_link " . $LANG["update"][90] . $DB->error()); |
| 569 |
} |
| 570 |
} |
| 571 |
} |
| 572 |
} |
| 573 |
} |
| 574 |
} |
| 575 |
|
| 576 |
|
| 577 |
|
| 578 |
$query = "ALTER TABLE `glpi_ocs_link` ADD UNIQUE `ocs_server_id` (`ocs_server_id` ,`ocs_id`);"; |
| 579 |
$DB->query($query) or die("0.7 alter ocs_link add index ocs_server_id " . $LANG["update"][90] . $DB->error()); |
| 580 |
} |
| 581 |
|
| 582 |
if (!isIndex("glpi_ocs_link", "`ocs_deviceid`")) { |
| 583 |
$query = "ALTER TABLE `glpi_ocs_link` ADD INDEX ( `ocs_deviceid` )"; |
| 584 |
$DB->query($query) or die("0.7 alter ocs_link add index ocs_deviceid " . $LANG["update"][90] . $DB->error()); |
| 585 |
} |
| 586 |
|
| 587 |
if (!FieldExists("glpi_ocs_config", "tplname")) { |
| 588 |
$query = "ALTER TABLE glpi_ocs_config ADD `name` varchar(200) default NULL AFTER `ID`, ADD `is_template` enum('0','1') NOT NULL default '0', ADD `tplname` varchar(200) default NULL, ADD `date_mod` datetime default NULL"; |
| 589 |
$DB->query($query) or die("0.7 add name, is_template, tplname, date_mod in glpi_ocs_link " . $LANG["update"][90] . $DB->error()); |
| 590 |
$query = "update glpi_ocs_config set name=ocs_db_host"; |
| 591 |
$DB->query($query) or die("0.7 add name in glpi_ocs_config " . $LANG["update"][90] . $DB->error()); |
| 592 |
} |
| 593 |
|
| 594 |
if (!FieldExists("glpi_ocs_config", "import_registry")) { |
| 595 |
$query = "ALTER TABLE glpi_ocs_config ADD `import_registry` INT NOT NULL default '0' AFTER `import_device_modems`"; |
| 596 |
$DB->query($query) or die("0.7 add import_registry in glpi_ocs_config " . $LANG["update"][90] . $DB->error()); |
| 597 |
} |
| 598 |
if (FieldExists("glpi_ocs_config", "import_tag_field")) { |
| 599 |
$query = "ALTER TABLE glpi_ocs_config DROP `import_tag_field`;"; |
| 600 |
$DB->query($query) or die("0.7 drop import_tag_field in glpi_ocs_config " . $LANG["update"][90] . $DB->error()); |
| 601 |
} |
| 602 |
|
| 603 |
if (!FieldExists("glpi_ocs_config", "import_software_licensetype")) { |
| 604 |
$query = "ALTER TABLE glpi_ocs_config ADD `import_software_licensetype` VARCHAR(255) DEFAULT 'global' AFTER `import_software`"; |
| 605 |
$DB->query($query) or die("0.7 add import_software_licensetype in glpi_ocs_config " . $LANG["update"][90] . $DB->error()); |
| 606 |
} |
| 607 |
|
| 608 |
if (!FieldExists("glpi_ocs_config", "import_software_buy")) { |
| 609 |
$query = "ALTER TABLE glpi_ocs_config ADD `import_software_buy` INT NOT NULL DEFAULT '1' AFTER `import_software`"; |
| 610 |
$DB->query($query) or die("0.7 add import_software_buy in glpi_ocs_config " . $LANG["update"][90] . $DB->error()); |
| 611 |
} |
| 612 |
|
| 613 |
if (!TableExists("glpi_registry")) { |
| 614 |
$query = "CREATE TABLE `glpi_registry` ( |
| 615 |
`ID` int(10) NOT NULL auto_increment,
|
| 616 |
`computer_id` int(10) NOT NULL DEFAULT '0',
|
| 617 |
`registry_hive` varchar(45) NOT NULL,
|
| 618 |
`registry_path` varchar(255) NOT NULL,
|
| 619 |
`registry_value` varchar(255) NOT NULL,
|
| 620 |
PRIMARY KEY (`ID`),
|
| 621 |
KEY `computer_id` (`computer_id`)
|
| 622 |
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;";
|
| 623 |
$DB->query($query) or die("0.7 add glpi_registry table " . $LANG["update"][90] . $DB->error()); |
| 624 |
|
| 625 |
} |
| 626 |
|
| 627 |
if (!FieldExists("glpi_ocs_link", "import_ip")) { |
| 628 |
$query = "ALTER TABLE `glpi_ocs_link` ADD COLUMN `import_ip` LONGTEXT"; |
| 629 |
$DB->query($query) or die("0.7 add import_ip in glpi_ocs_link" . $LANG["update"][90] . $DB->error()); |
| 630 |
} |
| 631 |
|
| 632 |
|
| 633 |
//// Enum clean
|
| 634 |
// Enum 0-1
|
| 635 |
$enum01 = array (); |
| 636 |
$template_tables = array ( |
| 637 |
"glpi_computers",
|
| 638 |
"glpi_networking",
|
| 639 |
"glpi_printers",
|
| 640 |
"glpi_monitors",
|
| 641 |
"glpi_peripherals",
|
| 642 |
"glpi_software",
|
| 643 |
"glpi_phones",
|
| 644 |
"glpi_ocs_config"
|
| 645 |
); |
| 646 |
|
| 647 |
foreach ($template_tables as $table) { |
| 648 |
if (!isset ($enum01[$table])) { |
| 649 |
$enum01[$table] = array (); |
| 650 |
} |
| 651 |
$enum01[$table][] = "is_template"; |
| 652 |
} |
| 653 |
$enum01["glpi_config"][] = "auto_assign"; |
| 654 |
$enum01["glpi_config"][] = "public_faq"; |
| 655 |
$enum01["glpi_config"][] = "url_in_mail"; |
| 656 |
$enum01["glpi_profiles"][] = "is_default"; |
| 657 |
|
| 658 |
$enum01["glpi_monitors"][] = "is_global"; |
| 659 |
$enum01["glpi_peripherals"][] = "is_global"; |
| 660 |
$enum01["glpi_phones"][] = "is_global"; |
| 661 |
$enum01["glpi_printers"][] = "is_global"; |
| 662 |
$enum01["glpi_reminder"][] = "rv"; |
| 663 |
$enum01["glpi_contract_device"][] = "is_template"; |
| 664 |
$enum01["glpi_doc_device"][] = "is_template"; |
| 665 |
|
| 666 |
foreach ($enum01 as $table => $fields) { |
| 667 |
foreach ($fields as $key => $field) { |
| 668 |
if (FieldExists($table, $field)) { |
| 669 |
|
| 670 |
$query = "ALTER TABLE `$table` ADD `tmp_convert_enum` SMALLINT NOT NULL DEFAULT '0' AFTER `$field` "; |
| 671 |
$DB->query($query) or die("0.7 alter $table add new field tmp_convert_enum " . $LANG["update"][90] . $DB->error()); |
| 672 |
|
| 673 |
$query = "UPDATE `$table` SET tmp_convert_enum='1' WHERE $field='1';"; |
| 674 |
$DB->query($query) or die("0.7 update $table to set correct values to alod enum01 $field " . $LANG["update"][90] . $DB->error()); |
| 675 |
$query = "UPDATE `$table` SET tmp_convert_enum='0' WHERE $field='0';"; |
| 676 |
$DB->query($query) or die("0.7 update $table to set correct values to alod enum01 $field " . $LANG["update"][90] . $DB->error()); |
| 677 |
|
| 678 |
$query = "ALTER TABLE `$table` DROP `$field` "; |
| 679 |
$DB->query($query) or die("0.7 alter $table drop tmp enum field " . $LANG["update"][90] . $DB->error()); |
| 680 |
|
| 681 |
$query = "ALTER TABLE `$table` CHANGE `tmp_convert_enum` `$field` SMALLINT NOT NULL DEFAULT '0'"; |
| 682 |
$DB->query($query) or die("0.7 alter $table move enum $field to tmp field " . $LANG["update"][90] . $DB->error()); |
| 683 |
|
| 684 |
if ($table != "glpi_config" && $table != "glpi_profiles") { |
| 685 |
$query = "ALTER TABLE `$table` ADD KEY (`$field`)"; |
| 686 |
$DB->query($query) or die("0.7 alter $table add deleted key " . $LANG["update"][90] . $DB->error()); |
| 687 |
} |
| 688 |
} |
| 689 |
} |
| 690 |
} |
| 691 |
|
| 692 |
$enumYN["N"]["glpi_contracts"][] = "monday"; // N |
| 693 |
$enumYN["N"]["glpi_contracts"][] = "saturday"; // N |
| 694 |
$enumYN["Y"]["glpi_device_drive"][] = "is_writer"; // Y |
| 695 |
$enumYN["N"]["glpi_device_control"][] = "raid"; // Y -> N |
| 696 |
$enumYN["Y"]["glpi_device_power"][] = "atx"; // Y |
| 697 |
$enumYN["N"]["glpi_licenses"][] = "oem"; // N |
| 698 |
$enumYN["Y"]["glpi_licenses"][] = "buy"; // Y |
| 699 |
$enumYN["N"]["glpi_software"][] = "is_update"; // N |
| 700 |
$enumYN["Y"]["glpi_type_docs"][] = "upload"; // Y |
| 701 |
|
| 702 |
$deleted_tables = array ( |
| 703 |
"glpi_computers",
|
| 704 |
"glpi_networking",
|
| 705 |
"glpi_printers",
|
| 706 |
"glpi_monitors",
|
| 707 |
"glpi_peripherals",
|
| 708 |
"glpi_software",
|
| 709 |
"glpi_cartridges_type",
|
| 710 |
"glpi_contracts",
|
| 711 |
"glpi_contacts",
|
| 712 |
"glpi_enterprises",
|
| 713 |
"glpi_docs",
|
| 714 |
"glpi_phones",
|
| 715 |
"glpi_consumables_type"
|
| 716 |
); |
| 717 |
|
| 718 |
foreach ($deleted_tables as $table) { |
| 719 |
if (!isset ($enum01[$table])) { |
| 720 |
$enum01[$table] = array (); |
| 721 |
} |
| 722 |
$enumYN["N"][$table][] = "deleted"; |
| 723 |
} |
| 724 |
|
| 725 |
foreach ($enumYN as $default => $tmptbl) |
| 726 |
foreach ($tmptbl as $table => $fields) { |
| 727 |
foreach ($fields as $key => $field) { |
| 728 |
if (FieldExists($table, $field)) { |
| 729 |
|
| 730 |
$newdef = 0; |
| 731 |
if ($default == "Y") { |
| 732 |
$newdef = 1; |
| 733 |
} |
| 734 |
|
| 735 |
$query = "ALTER TABLE `$table` ADD `tmp_convert_enum` SMALLINT NOT NULL DEFAULT '$newdef' AFTER `$field` "; |
| 736 |
$DB->query($query) or die("0.7 alter $table add new field tmp_convert_enum " . $LANG["update"][90] . $DB->error()); |
| 737 |
|
| 738 |
$query = "UPDATE `$table` SET tmp_convert_enum='1' WHERE $field='Y';"; |
| 739 |
$DB->query($query) or die("0.7 update $table to set correct values to alod enum01 $field " . $LANG["update"][90] . $DB->error()); |
| 740 |
$query = "UPDATE `$table` SET tmp_convert_enum='0' WHERE $field='N';"; |
| 741 |
$DB->query($query) or die("0.7 update $table to set correct values to alod enum01 $field " . $LANG["update"][90] . $DB->error()); |
| 742 |
|
| 743 |
$query = "ALTER TABLE `$table` DROP `$field` "; |
| 744 |
$DB->query($query) or die("0.7 alter $table drop tmp enum field " . $LANG["update"][90] . $DB->error()); |
| 745 |
|
| 746 |
$query = "ALTER TABLE `$table` CHANGE `tmp_convert_enum` `$field` SMALLINT NOT NULL DEFAULT '$newdef'"; |
| 747 |
$DB->query($query) or die("0.7 alter $table move enum $field to tmp field " . $LANG["update"][90] . $DB->error()); |
| 748 |
|
| 749 |
if ($field == "deleted" || $table == "glpi_licenses" || $table == "glpi_software" || $table == "glpi_type_docs") { |
| 750 |
$query = "ALTER TABLE `$table` ADD KEY (`$field`)"; |
| 751 |
$DB->query($query) or die("0.7 alter $table add deleted key " . $LANG["update"][90] . $DB->error()); |
| 752 |
} |
| 753 |
} |
| 754 |
} |
| 755 |
} |
| 756 |
|
| 757 |
if (FieldExists("glpi_tracking", "is_group")) { |
| 758 |
$query = "ALTER TABLE glpi_tracking DROP `is_group`"; |
| 759 |
$DB->query($query) or die("0.7 drop is_group from tracking " . $LANG["update"][90] . $DB->error()); |
| 760 |
} |
| 761 |
|
| 762 |
$enumYesNo["glpi_kbitems"][] = "faq"; |
| 763 |
$enumYesNo["glpi_tracking"][] = "emailupdates"; |
| 764 |
$enumYesNo["glpi_users"][] = "tracking_order"; |
| 765 |
|
| 766 |
foreach ($enumYesNo as $table => $fields) { |
| 767 |
foreach ($fields as $key => $field) { |
| 768 |
if (FieldExists($table, $field)) { |
| 769 |
|
| 770 |
$query = "ALTER TABLE `$table` ADD `tmp_convert_enum` SMALLINT NOT NULL DEFAULT '0' AFTER `$field` "; |
| 771 |
$DB->query($query) or die("0.7 alter $table add new field tmp_convert_enum " . $LANG["update"][90] . $DB->error()); |
| 772 |
|
| 773 |
$query = "UPDATE `$table` SET tmp_convert_enum='1' WHERE $field='yes';"; |
| 774 |
$DB->query($query) or die("0.7 update $table to set correct values to alod enum01 $field " . $LANG["update"][90] . $DB->error()); |
| 775 |
$query = "UPDATE `$table` SET tmp_convert_enum='0' WHERE $field='no';"; |
| 776 |
$DB->query($query) or die("0.7 update $table to set correct values to alod enum01 $field " . $LANG["update"][90] . $DB->error()); |
| 777 |
|
| 778 |
$query = "ALTER TABLE `$table` DROP `$field` "; |
| 779 |
$DB->query($query) or die("0.7 alter $table drop tmp enum field " . $LANG["update"][90] . $DB->error()); |
| 780 |
|
| 781 |
$query = "ALTER TABLE `$table` CHANGE `tmp_convert_enum` `$field` SMALLINT NOT NULL DEFAULT '0'"; |
| 782 |
$DB->query($query) or die("0.7 alter $table move enum $field to tmp field " . $LANG["update"][90] . $DB->error()); |
| 783 |
|
| 784 |
if ($table == "glpi_kbitems") { |
| 785 |
$query = "ALTER TABLE `$table` ADD KEY (`$field`)"; |
| 786 |
$DB->query($query) or die("0.7 alter $table add deleted key " . $LANG["update"][90] . $DB->error()); |
| 787 |
} |
| 788 |
} |
| 789 |
} |
| 790 |
} |
| 791 |
// Reste enum : glpi_tracking.status et glpi_device_gfxcard.interface
|
| 792 |
if (FieldExists("glpi_tracking", "status")) { |
| 793 |
$query = "ALTER TABLE `glpi_tracking` CHANGE `status` `status` VARCHAR( 255 ) DEFAULT 'new'"; |
| 794 |
$DB->query($query) or die("0.7 alter status from tracking " . $LANG["update"][90] . $DB->error()); |
| 795 |
} |
| 796 |
|
| 797 |
if (FieldExists("glpi_device_gfxcard", "interface")) { |
| 798 |
$query = "ALTER TABLE `glpi_device_gfxcard` CHANGE `interface` `interface` VARCHAR( 255 ) NULL DEFAULT 'PCI-X'"; |
| 799 |
$DB->query($query) or die("0.7 alter interface from glpi_device_gfxcard " . $LANG["update"][90] . $DB->error()); |
| 800 |
} |
| 801 |
|
| 802 |
if (!TableExists("glpi_rules_actions")) { |
| 803 |
$query = "CREATE TABLE `glpi_rules_actions` ( |
| 804 |
`ID` int(11) NOT NULL auto_increment,
|
| 805 |
`FK_rules` int(11) NOT NULL DEFAULT '0',
|
| 806 |
`action_type` varchar(255) NOT NULL,
|
| 807 |
`field` varchar(255) NOT NULL,
|
| 808 |
`value` varchar(255) NOT NULL,
|
| 809 |
PRIMARY KEY (`ID`),
|
| 810 |
KEY `FK_rules` (`FK_rules`)
|
| 811 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| 812 |
";
|
| 813 |
$DB->query($query) or die("0.7 add table glpi_rules_descriptions" . $LANG["update"][90] . $DB->error()); |
| 814 |
|
| 815 |
} |
| 816 |
|
| 817 |
if (!TableExists("glpi_rules_criterias")) { |
| 818 |
$query = "CREATE TABLE `glpi_rules_criterias` ( |
| 819 |
`ID` int(11) NOT NULL auto_increment,
|
| 820 |
`FK_rules` int(11) NOT NULL DEFAULT '0',
|
| 821 |
`criteria` varchar(255) NOT NULL,
|
| 822 |
`condition` smallint(4) NOT NULL DEFAULT '0',
|
| 823 |
`pattern` varchar(255) NOT NULL,
|
| 824 |
PRIMARY KEY (`ID`),
|
| 825 |
KEY `FK_rules` (`FK_rules`)
|
| 826 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
|
| 827 |
$DB->query($query) or die("0.7 add table glpi_rules_criterias" . $LANG["update"][90] . $DB->error()); |
| 828 |
|
| 829 |
} |
| 830 |
|
| 831 |
if (!TableExists("glpi_rules_descriptions")) { |
| 832 |
$query = "CREATE TABLE `glpi_rules_descriptions` ( |
| 833 |
`ID` int(11) NOT NULL auto_increment,
|
| 834 |
`FK_entities` int(11) NOT NULL default '-1',
|
| 835 |
`rule_type` smallint(4) NOT NULL DEFAULT '0',
|
| 836 |
`ranking` int(11) NOT NULL DEFAULT '0',
|
| 837 |
`name` varchar(255) NOT NULL,
|
| 838 |
`description` text NOT NULL,
|
| 839 |
`match` varchar(255) NOT NULL,
|
| 840 |
PRIMARY KEY (`ID`)
|
| 841 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
|
| 842 |
$DB->query($query) or die("0.7 add table glpi_rules_actions" . $LANG["update"][90] . $DB->error()); |
| 843 |
|
| 844 |
} |
| 845 |
|
| 846 |
if (!FieldExists("glpi_config", "use_cache")) { |
| 847 |
$query = "ALTER TABLE `glpi_config` ADD `use_cache` SMALLINT NOT NULL DEFAULT '1' AFTER `debug` ;"; |
| 848 |
$DB->query($query) or die("0.7 alter config add use_cache " . $LANG["update"][90] . $DB->error()); |
| 849 |
} |
| 850 |
|
| 851 |
if (TableExists("glpi_rules_descriptions")) { |
| 852 |
//If no rule exists, then create a default one
|
| 853 |
$query = "SELECT ID from glpi_rules_descriptions"; |
| 854 |
$result = $DB->query($query); |
| 855 |
if ($DB->numrows($result) ==0) |
| 856 |
{
|
| 857 |
//Insert rule to affect machines in the Root entity
|
| 858 |
$query ="INSERT INTO `glpi_rules_descriptions` (`FK_entities`, `rule_type`, `ranking`, `name`, `description`, `match`) VALUES (-1, 0, 0, 'Root', '', 'AND');"; |
| 859 |
$DB->query($query) or die("0.7 add default ocs affectation rule" . $LANG["update"][90] . $DB->error()); |
| 860 |
|
| 861 |
$query = "SELECT ID from glpi_rules_descriptions WHERE name='Root' AND rule_type=".RULE_OCS_AFFECT_COMPUTER; |
| 862 |
$result = $DB->query($query); |
| 863 |
//Get the defaut rule's ID
|
| 864 |
$datas = $DB->fetch_array($result); |
| 865 |
|
| 866 |
$query="INSERT INTO `glpi_rules_criterias` (`FK_rules`, `criteria`, `condition`, `pattern`) VALUES (".$datas["ID"].", 'TAG', 0, '*');"; |
| 867 |
$DB->query($query) or die("0.7 add default ocs criterias" . $LANG["update"][90] . $DB->error()); |
| 868 |
|
| 869 |
$query="INSERT INTO `glpi_rules_actions` (`FK_rules`, `action_type`, `field`, `value`) VALUES (".$datas["ID"].", 'assign', 'FK_entities', '0');"; |
| 870 |
$DB->query($query) or die("0.7 add default ocs actions" . $LANG["update"][90] . $DB->error()); |
| 871 |
|
| 872 |
//Insert rule to affect users from LDAP to the root entity
|
| 873 |
$query ="INSERT INTO `glpi_rules_descriptions` (`FK_entities`, `rule_type`, `ranking`, `name`, `description`, `match`) VALUES (-1, ".RULE_AFFECT_RIGHTS.", 1, 'Root', '', 'OR');"; |
| 874 |
$DB->query($query) or die("0.7 add default right affectation rule" . $LANG["update"][90] . $DB->error()); |
| 875 |
|
| 876 |
$query = "SELECT ID from glpi_rules_descriptions WHERE name='Root' AND rule_type=".RULE_AFFECT_RIGHTS; |
| 877 |
$result = $DB->query($query); |
| 878 |
//Get the defaut rule's ID
|
| 879 |
$datas = $DB->fetch_array($result); |
| 880 |
|
| 881 |
//Criterias
|
| 882 |
$query="INSERT INTO `glpi_rules_criterias` (`FK_rules`, `criteria`, `condition`, `pattern`) VALUES (".$datas["ID"].", 'uid', 0, '*');"; |
| 883 |
$DB->query($query) or die("0.7 add default right criterias" . $LANG["update"][90] . $DB->error()); |
| 884 |
|
| 885 |
$query="INSERT INTO `glpi_rules_criterias` (`FK_rules`, `criteria`, `condition`, `pattern`) VALUES (".$datas["ID"].", 'samaccountname', 0, '*');"; |
| 886 |
$DB->query($query) or die("0.7 add default right criterias" . $LANG["update"][90] . $DB->error()); |
| 887 |
|
| 888 |
$query="INSERT INTO `glpi_rules_criterias` (`FK_rules`, `criteria`, `condition`, `pattern`) VALUES (".$datas["ID"].", 'MAIL_EMAIL', 0, '*');"; |
| 889 |
$DB->query($query) or die("0.7 add default right criterias" . $LANG["update"][90] . $DB->error()); |
| 890 |
|
| 891 |
//Action
|
| 892 |
$query="INSERT INTO `glpi_rules_actions` (`FK_rules`, `action_type`, `field`, `value`) VALUES (".$datas["ID"].", 'assign', 'FK_entities', '0');"; |
| 893 |
$DB->query($query) or die("0.7 add default right actions" . $LANG["update"][90] . $DB->error()); |
| 894 |
|
| 895 |
} |
| 896 |
} |
| 897 |
|
| 898 |
if (!TableExists("glpi_ocs_admin_link")){ |
| 899 |
$query = "CREATE TABLE `glpi_ocs_admin_link` ( |
| 900 |
`ID` int(10) unsigned NOT NULL auto_increment,
|
| 901 |
`glpi_column` varchar(255) NULL,
|
| 902 |
`ocs_column` varchar(255) NULL,
|
| 903 |
`ocs_server_id` int(11) NOT NULL,
|
| 904 |
PRIMARY KEY (`ID`)
|
| 905 |
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;";
|
| 906 |
$DB->query($query) or die("0.7 add table glpi_ocs_admin_link" . $LANG["update"][90] . $DB->error()); |
| 907 |
} |
| 908 |
|
| 909 |
// Add title to tracking
|
| 910 |
if (!FieldExists("glpi_tracking", "name")) { |
| 911 |
$query = "ALTER TABLE `glpi_tracking` ADD `name` varchar(255) NULL AFTER `FK_entities`"; |
| 912 |
$DB->query($query) or die("0.7 alter tracking add name" . $LANG["update"][90] . $DB->error()); |
| 913 |
$query="UPDATE glpi_tracking SET name=SUBSTRING(REPLACE(contents,'\n',' '),1,50);"; |
| 914 |
$DB->query($query) or die("0.7 update title of glpi_tracking" . $LANG["update"][90] . $DB->error()); |
| 915 |
} |
| 916 |
if (FieldExists("glpi_reminder", "title")) { |
| 917 |
$query = "ALTER TABLE `glpi_reminder` CHANGE `title` `title` VARCHAR( 255 ) NULL DEFAULT NULL "; |
| 918 |
$DB->query($query) or die("0.7 alter title in glpi_reminder" . $LANG["update"][90] . $DB->error()); |
| 919 |
} |
| 920 |
|
| 921 |
if (!TableExists("glpi_rules_ldap_parameters")){ |
| 922 |
$query = "CREATE TABLE `glpi_rules_ldap_parameters` ( |
| 923 |
`ID` int(11) NOT NULL auto_increment,
|
| 924 |
`name` varchar(255) NOT NULL,
|
| 925 |
`value` varchar(255) NOT NULL,
|
| 926 |
`rule_type` smallint(6) NOT NULL default '1',
|
| 927 |
PRIMARY KEY (`ID`)
|
| 928 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
|
| 929 |
$DB->query($query) or die("0.7 add table glpi_rules_ldap_parameters" . $LANG["update"][90] . $DB->error()); |
| 930 |
|
| 931 |
$query = "INSERT INTO `glpi_rules_ldap_parameters` (`ID`, `name`, `value`, `rule_type`) VALUES |
| 932 |
(1, '(LDAP)Organization', 'o', 1),
|
| 933 |
(2, '(LDAP)Common Name', 'cn', 1),
|
| 934 |
(3, '(LDAP)Department Number', 'departmentnumber', 1),
|
| 935 |
(4, '(LDAP)Email', 'mail', 1),
|
| 936 |
(5, 'Object Class', 'objectclass', 1),
|
| 937 |
(6, '(LDAP)User ID', 'uid', 1),
|
| 938 |
(7, '(LDAP)Telephone Number', 'phone', 1),
|
| 939 |
(8, '(LDAP)Employee Number', 'employeenumber', 1),
|
| 940 |
(9, '(LDAP)Manager', 'manager', 1),
|
| 941 |
(10, '(LDAP)DistinguishedName', 'dn', 1),
|
| 942 |
(11, '(AD)DistinguishedName', 'distinguishedname', 1),
|
| 943 |
(12, '(AD)User ID', 'samaccountname', 1);";
|
| 944 |
|
| 945 |
$DB->query($query) or die("0.7 add standard values to glpi_rules_ldap_parameters " . $LANG["update"][90] . $DB->error()); |
| 946 |
|
| 947 |
} |
| 948 |
|
| 949 |
if (!FieldExists("glpi_config", "helpdeskhelp_url")) { |
| 950 |
$query = "ALTER TABLE `glpi_config` ADD `helpdeskhelp_url` VARCHAR( 255 ) NULL DEFAULT NULL "; |
| 951 |
$DB->query($query) or die("0.7 add helpdeskhelp_url in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 952 |
} |
| 953 |
if (!FieldExists("glpi_config", "centralhelp_url")) { |
| 954 |
$query = "ALTER TABLE `glpi_config` ADD `centralhelp_url` VARCHAR( 255 ) NULL DEFAULT NULL "; |
| 955 |
$DB->query($query) or die("0.7 add centralhelp_url in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 956 |
} |
| 957 |
|
| 958 |
if (!FieldExists("glpi_config", "default_rubdoc_tracking")) { |
| 959 |
$query = "ALTER TABLE `glpi_config` ADD `default_rubdoc_tracking` int(11) default '0' "; |
| 960 |
$DB->query($query) or die("0.7 add default_rubdoc_tracking in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 961 |
} |
| 962 |
|
| 963 |
if (!FieldExists("glpi_users", "deleted")) { |
| 964 |
$query = "ALTER TABLE `glpi_users` ADD `deleted` SMALLINT NOT NULL DEFAULT 0 "; |
| 965 |
$DB->query($query) or die("0.7 add deleted in glpi_users" . $LANG["update"][90] . $DB->error()); |
| 966 |
$query = "ALTER TABLE `glpi_users` ADD KEY (`deleted`)"; |
| 967 |
$DB->query($query) or die("0.7 add key deleted in glpi_users" . $LANG["update"][90] . $DB->error()); |
| 968 |
} |
| 969 |
|
| 970 |
if (!FieldExists("glpi_reservation_item", "active")) { |
| 971 |
$query = "ALTER TABLE `glpi_reservation_item` ADD `active` smallint(6) NOT NULL default '1' "; |
| 972 |
$DB->query($query) or die("0.7 add active in glpi_reservation_item" . $LANG["update"][90] . $DB->error()); |
| 973 |
} |
| 974 |
|
| 975 |
if (!FieldExists("glpi_tracking_planning", "state")) { |
| 976 |
$query = "ALTER TABLE `glpi_tracking_planning` ADD `state` smallint(6) NOT NULL default '1' "; |
| 977 |
$DB->query($query) or die("0.7 add state in glpi_tracking_planning" . $LANG["update"][90] . $DB->error()); |
| 978 |
$query="UPDATE `glpi_tracking_planning` SET state='2' WHERE end < NOW()"; |
| 979 |
$DB->query($query) or die("0.7 update values of state in glpi_tracking_planning" . $LANG["update"][90] . $DB->error()); |
| 980 |
} |
| 981 |
|
| 982 |
if (!FieldExists("glpi_reminder", "state")) { |
| 983 |
$query = "ALTER TABLE `glpi_reminder` ADD `state` smallint(6) NOT NULL default '0' "; |
| 984 |
$DB->query($query) or die("0.7 add state in glpi_reminder" . $LANG["update"][90] . $DB->error()); |
| 985 |
} |
| 986 |
|
| 987 |
|
| 988 |
if (!FieldExists("glpi_tracking", "recipient")) { |
| 989 |
$query = "ALTER TABLE `glpi_tracking` ADD `recipient` INT NOT NULL DEFAULT '0' AFTER `author` "; |
| 990 |
$DB->query($query) or die("0.7 add recipient in glpi_tracking" . $LANG["update"][90] . $DB->error()); |
| 991 |
$query = "UPDATE `glpi_tracking` SET recipient = author"; |
| 992 |
$DB->query($query) or die("0.7 update recipient in glpi_tracking" . $LANG["update"][90] . $DB->error()); |
| 993 |
|
| 994 |
} |
| 995 |
if (!isIndex("glpi_tracking","recipient")){ |
| 996 |
$query="ALTER TABLE `glpi_tracking` ADD INDEX ( `recipient` ) "; |
| 997 |
$DB->query($query) or die("0.7 add recipient index in glpi_tracking" . $LANG["update"][90] . $DB->error()); |
| 998 |
} |
| 999 |
|
| 1000 |
if (!FieldExists("glpi_ocs_config", "deconnection_behavior")) { |
| 1001 |
$query = "ALTER TABLE `glpi_ocs_config` ADD COLUMN `deconnection_behavior` VARCHAR(45)"; |
| 1002 |
$DB->query($query) or die("0.7 add state in glpi_reminder" . $LANG["update"][90] . $DB->error()); |
| 1003 |
} |
| 1004 |
|
| 1005 |
// Rights
|
| 1006 |
if (!FieldExists("glpi_profiles", "search_config_global")) { |
| 1007 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `search_config_global` char(1) default NULL AFTER `search_config`"; |
| 1008 |
$DB->query($query) or die("0.7 add search_config_global in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1009 |
$query = "UPDATE `glpi_profiles` SET `search_config_global` = search_config"; |
| 1010 |
$DB->query($query) or die("0.7 update search_config_global values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1011 |
$query = "UPDATE `glpi_profiles` SET `search_config` = 'w' WHERE interface='central'"; |
| 1012 |
$DB->query($query) or die("0.7 update search_confi values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1013 |
} |
| 1014 |
if (!FieldExists("glpi_profiles", "entity")) { |
| 1015 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `entity` char(1) default NULL AFTER `group`"; |
| 1016 |
$DB->query($query) or die("0.7 add entity in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1017 |
$query = "UPDATE `glpi_profiles` SET `entity` = config"; |
| 1018 |
$DB->query($query) or die("0.7 update entity values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1019 |
} |
| 1020 |
if (!FieldExists("glpi_profiles", "entity_dropdown")) { |
| 1021 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `entity_dropdown` char(1) default NULL AFTER `dropdown`"; |
| 1022 |
$DB->query($query) or die("0.7 add entity_dropdown in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1023 |
$query = "UPDATE `glpi_profiles` SET `entity_dropdown` = dropdown"; |
| 1024 |
$DB->query($query) or die("0.7 update entity_dropdown values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1025 |
} |
| 1026 |
if (!FieldExists("glpi_profiles", "sync_ocsng")) { |
| 1027 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `sync_ocsng` char(1) default NULL AFTER `ocsng`"; |
| 1028 |
$DB->query($query) or die("0.7 add sync_ocsng in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1029 |
$query = "UPDATE `glpi_profiles` SET `sync_ocsng` = ocsng"; |
| 1030 |
$DB->query($query) or die("0.7 update sync_ocsng values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1031 |
} |
| 1032 |
if (!FieldExists("glpi_profiles", "view_ocsng")) { |
| 1033 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `view_ocsng` char(1) default NULL AFTER `ocsng`"; |
| 1034 |
$DB->query($query) or die("0.7 add view_ocsng in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1035 |
$query = "UPDATE `glpi_profiles` SET `view_ocsng` = 'r' WHERE interface='central'"; |
| 1036 |
$DB->query($query) or die("0.7 update view_ocsng values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1037 |
} |
| 1038 |
if (!FieldExists("glpi_profiles", "rule_ldap")) { |
| 1039 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `rule_ldap` char(1) default NULL AFTER `config`"; |
| 1040 |
$DB->query($query) or die("0.7 add rule_ldap in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1041 |
$query = "UPDATE `glpi_profiles` SET `rule_ldap` = config"; |
| 1042 |
$DB->query($query) or die("0.7 update rule_ldap values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1043 |
} |
| 1044 |
if (!FieldExists("glpi_profiles", "rule_ocs")) { |
| 1045 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `rule_ocs` char(1) default NULL AFTER `config`"; |
| 1046 |
$DB->query($query) or die("0.7 add rule_ocs in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1047 |
$query = "UPDATE `glpi_profiles` SET `rule_ocs` = config"; |
| 1048 |
$DB->query($query) or die("0.7 update rule_ocs values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1049 |
} |
| 1050 |
if (!FieldExists("glpi_profiles", "rule_tracking")) { |
| 1051 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `rule_tracking` char(1) default NULL AFTER `config`"; |
| 1052 |
$DB->query($query) or die("0.7 add rule_tracking in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1053 |
$query = "UPDATE `glpi_profiles` SET `rule_tracking` = config"; |
| 1054 |
$DB->query($query) or die("0.7 update rule_tracking values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1055 |
} |
| 1056 |
if (!FieldExists("glpi_profiles", "update_followups")) { |
| 1057 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `update_followups` char(1) default NULL AFTER `observe_ticket`"; |
| 1058 |
$DB->query($query) or die("0.7 add update_followups in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1059 |
$query = "UPDATE `glpi_profiles` SET `update_followups` = show_full_ticket"; |
| 1060 |
$DB->query($query) or die("0.7 update update_followups values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1061 |
} |
| 1062 |
|
| 1063 |
//Software version's modifications
|
| 1064 |
//First add the version field to the licenses table
|
| 1065 |
if (!FieldExists("glpi_licenses", "version")) { |
| 1066 |
$query = "ALTER TABLE `glpi_licenses` ADD COLUMN `version` varchar(255) default NULL AFTER `sID`"; |
| 1067 |
$DB->query($query) or die("0.7 add version in glpi_licenses" . $LANG["update"][90] . $DB->error()); |
| 1068 |
|
| 1069 |
$sql = "SELECT ID, version FROM glpi_software"; |
| 1070 |
$result = $DB->query($sql); |
| 1071 |
if ($DB->numrows($result)>0) |
| 1072 |
{
|
| 1073 |
while ($soft = $DB->fetch_array($result)) |
| 1074 |
{
|
| 1075 |
$sql = "UPDATE glpi_licenses SET version='".$soft["version"]."' WHERE sID=".$soft["ID"]; |
| 1076 |
$DB->query($sql); |
| 1077 |
} |
| 1078 |
} |
| 1079 |
|
| 1080 |
} |
| 1081 |
|
| 1082 |
|
| 1083 |
if (FieldExists("glpi_software", "version")) { |
| 1084 |
$query = "ALTER TABLE `glpi_software` DROP `version`"; |
| 1085 |
$DB->query($query) or die("0.7 delete version in glpi_software" . $LANG["update"][90] . $DB->error()); |
| 1086 |
} |
| 1087 |
|
| 1088 |
// CLean multiple free / global licenses
|
| 1089 |
|
| 1090 |
$query= "SELECT count(*) as CPT, glpi_licenses.* |
| 1091 |
FROM `glpi_licenses`
|
| 1092 |
WHERE `serial` = 'global' OR `serial` = 'free'
|
| 1093 |
GROUP BY sID, serial, expire, buy
|
| 1094 |
HAVING CPT > 1";
|
| 1095 |
$result=$DB->query($query) or die("0.7 check multiple free global licenses " . $LANG["update"][90] . $DB->error()); |
| 1096 |
if ($DB->numrows($result)){ |
| 1097 |
while ($data=$DB->fetch_array($result)){ |
| 1098 |
// Get licenses AND installations
|
| 1099 |
$expire_search=""; |
| 1100 |
if ($data['expire']=="") |
| 1101 |
$expire_search=" AND glpi_licenses.expire IS NULL"; |
| 1102 |
else $expire_search=" AND glpi_licenses.expire = '".$data['expire']."'"; |
| 1103 |
|
| 1104 |
$query="SELECT glpi_licenses.ID FROM glpi_licenses |
| 1105 |
WHERE serial ='".$data['serial']."' AND sID ='".$data['sID']."' $expire_search AND buy ='".$data['buy']."'"; |
| 1106 |
$result2=$DB->query($query); |
| 1107 |
if ($DB->numrows($result2)){ |
| 1108 |
$licIDs=array(); |
| 1109 |
while ($data2=$DB->fetch_array($result2)){ |
| 1110 |
$licIDs[]=$data2['ID']; |
| 1111 |
} |
| 1112 |
if (count($licIDs)>1){ |
| 1113 |
$refID=array_pop($licIDs); |
| 1114 |
$query="UPDATE glpi_inst_software SET license = '$refID' WHERE license IN ("; |
| 1115 |
$first=true; |
| 1116 |
foreach ($licIDs as $id){ |
| 1117 |
if ($first) $first=false; |
| 1118 |
else $query.=","; |
| 1119 |
$query.=$id; |
| 1120 |
$query_del="DELETE FROM glpi_licenses WHERE ID = $id"; |
| 1121 |
$DB->query($query_del); |
| 1122 |
} |
| 1123 |
$query.=")"; |
| 1124 |
$DB->query($query); |
| 1125 |
} |
| 1126 |
} |
| 1127 |
} |
| 1128 |
} |
| 1129 |
|
| 1130 |
// Clean multiple reservation item
|
| 1131 |
$query= "SELECT count(*) as CPT, glpi_reservation_item.* |
| 1132 |
FROM `glpi_reservation_item`
|
| 1133 |
GROUP BY device_type, id_device
|
| 1134 |
HAVING CPT > 1";
|
| 1135 |
$result=$DB->query($query) or die("0.7 check multiple free global licenses " . $LANG["update"][90] . $DB->error()); |
| 1136 |
if ($DB->numrows($result)){ |
| 1137 |
while ($data=$DB->fetch_array($result)){ |
| 1138 |
$refID=$data['ID']; |
| 1139 |
// Get duplicates
|
| 1140 |
$query2="SELECT * FROM `glpi_reservation_item` WHERE device_type='".$data['device_type']."' AND id_device='".$data['id_device']."' AND ID <> '$refID'"; |
| 1141 |
$result2=$DB->query($query2); |
| 1142 |
if ($DB->numrows($result2)){ |
| 1143 |
while ($data2=$DB->fetch_array($result2)){ |
| 1144 |
// Update réservations
|
| 1145 |
$query="UPDATE glpi_reservation_resa SET id_item='$refID' WHERE id_item='".$data2['ID']."'"; |
| 1146 |
$DB->query($query); |
| 1147 |
// Delete Reservation Item
|
| 1148 |
$query="DELETE FROM `glpi_reservation_item` WHERE ID = '".$data2['ID']."'"; |
| 1149 |
$DB->query($query); |
| 1150 |
} |
| 1151 |
} |
| 1152 |
|
| 1153 |
} |
| 1154 |
} |
| 1155 |
|
| 1156 |
if (!FieldExists("glpi_networking_ports", "netmask")) { |
| 1157 |
$query = "ALTER TABLE `glpi_networking_ports` ADD COLUMN `netmask` VARCHAR( 255 ) NULL DEFAULT NULL"; |
| 1158 |
$DB->query($query) or die("0.7 add netmask in glpi_networking_ports" . $LANG["update"][90] . $DB->error()); |
| 1159 |
} |
| 1160 |
|
| 1161 |
if (!FieldExists("glpi_networking_ports", "gateway")) { |
| 1162 |
$query = "ALTER TABLE `glpi_networking_ports` ADD COLUMN `gateway` VARCHAR( 255 ) NULL DEFAULT NULL"; |
| 1163 |
$DB->query($query) or die("0.7 add gateway in glpi_networking_ports" . $LANG["update"][90] . $DB->error()); |
| 1164 |
} |
| 1165 |
if (!FieldExists("glpi_networking_ports", "subnet")) { |
| 1166 |
$query = "ALTER TABLE `glpi_networking_ports` ADD COLUMN subnet VARCHAR( 255 ) NULL DEFAULT NULL"; |
| 1167 |
$DB->query($query) or die("0.7 add subnet in glpi_networking_ports" . $LANG["update"][90] . $DB->error()); |
| 1168 |
} |
| 1169 |
if (FieldExists("glpi_networking_ports", "name")) { |
| 1170 |
$query = "ALTER TABLE `glpi_networking_ports` CHANGE `name` `name` VARCHAR( 255 ) NULL DEFAULT NULL , |
| 1171 |
CHANGE `ifaddr` `ifaddr` VARCHAR( 255 ) NULL DEFAULT NULL ,
|
| 1172 |
CHANGE `ifmac` `ifmac` VARCHAR( 255 ) NULL DEFAULT NULL ";
|
| 1173 |
$DB->query($query) or die("0.7 alter networking_ports fields" . $LANG["update"][90] . $DB->error()); |
| 1174 |
} |
| 1175 |
// mailgate
|
| 1176 |
if (!TableExists("glpi_mailgate")) { |
| 1177 |
$query = "CREATE TABLE `glpi_mailgate` ( |
| 1178 |
`ID` int(11) NOT NULL auto_increment,
|
| 1179 |
`name` varchar(255) collate utf8_unicode_ci default NULL,
|
| 1180 |
`FK_entities` int(11) NOT NULL default '0',
|
| 1181 |
`host` varchar(255) collate utf8_unicode_ci NOT NULL,
|
| 1182 |
`login` varchar(255) collate utf8_unicode_ci NOT NULL,
|
| 1183 |
`password` varchar(255) collate utf8_unicode_ci NOT NULL,
|
| 1184 |
PRIMARY KEY (`ID`)
|
| 1185 |
) ENGINE=MyISAM ;";
|
| 1186 |
$DB->query($query) or die("0.7 add glpi_mailgate" . $LANG["update"][90] . $DB->error()); |
| 1187 |
$query = "INSERT INTO `glpi_display` ( `type`, `num`, `rank`, `FK_users`) VALUES (35, 80, 1, 0);"; |
| 1188 |
$DB->query($query) or die("0.7 add glpi_mailgate display values" . $LANG["update"][90] . $DB->error()); |
| 1189 |
} |
| 1190 |
|
| 1191 |
if (!FieldExists("glpi_computers", "os_license_number")) { |
| 1192 |
$query = "ALTER TABLE `glpi_computers` ADD COLUMN `os_license_number` VARCHAR( 255 ) NULL DEFAULT NULL AFTER os_sp;"; |
| 1193 |
$DB->query($query) or die("0.7 alter glpi_computers field" . $LANG["computers"][10] . $DB->error()); |
| 1194 |
} |
| 1195 |
|
| 1196 |
if (!FieldExists("glpi_computers", "os_license_id")) { |
| 1197 |
$query = "ALTER TABLE `glpi_computers` ADD COLUMN `os_license_id` VARCHAR( 255 ) NULL DEFAULT NULL AFTER os_license_number;"; |
| 1198 |
$DB->query($query) or die("0.7 alter glpi_computers field" . $LANG["computers"][10] . $DB->error()); |
| 1199 |
} |
| 1200 |
|
| 1201 |
if (!FieldExists("glpi_ocs_config", "import_os_serial")) { |
| 1202 |
$query = "ALTER TABLE `glpi_ocs_config` ADD `import_os_serial` INT( 2 ) NULL AFTER `import_registry` ;"; |
| 1203 |
$DB->query($query) or die("0.7 alter glpi_computers field import_ocs_serial " . $DB->error()); |
| 1204 |
} |
| 1205 |
|
| 1206 |
if (!FieldExists("glpi_auth_ldap", "use_dn")) { |
| 1207 |
$query = "ALTER TABLE `glpi_auth_ldap` ADD `use_dn` INT( 1 ) NOT NULL DEFAULT '1';"; |
| 1208 |
$DB->query($query) or die("0.7 alter glpi_computers field use_dn " . $DB->error()); |
| 1209 |
} |
| 1210 |
|
| 1211 |
if (!FieldExists("glpi_config", "monitors_management_restrict")) { |
| 1212 |
$query = "ALTER TABLE `glpi_config` ADD `monitors_management_restrict` INT( 1 ) NOT NULL DEFAULT '2';"; |
| 1213 |
$DB->query($query) or die("0.7 alter glpi_computers field monitors_management_restrict " . $DB->error()); |
| 1214 |
} |
| 1215 |
|
| 1216 |
if (!FieldExists("glpi_config", "phones_management_restrict")) { |
| 1217 |
$query = "ALTER TABLE `glpi_config` ADD `phones_management_restrict` INT( 1 ) NOT NULL DEFAULT '2';"; |
| 1218 |
$DB->query($query) or die("0.7 alter glpi_computers field phones_management_restrict " . $DB->error()); |
| 1219 |
} |
| 1220 |
|
| 1221 |
if (!FieldExists("glpi_config", "peripherals_management_restrict")) { |
| 1222 |
$query = "ALTER TABLE `glpi_config` ADD `peripherals_management_restrict` INT( 1 ) NOT NULL DEFAULT '2';"; |
| 1223 |
$DB->query($query) or die("0.7 alter glpi_computers field peripherals_management_restrict " . $DB->error()); |
| 1224 |
} |
| 1225 |
|
| 1226 |
if (!FieldExists("glpi_config", "printers_management_restrict")) { |
| 1227 |
$query = "ALTER TABLE `glpi_config` ADD `printers_management_restrict` INT( 1 ) NOT NULL DEFAULT '2';"; |
| 1228 |
$DB->query($query) or die("0.7 alter glpi_computers field printers_management_restrict " . $DB->error()); |
| 1229 |
} |
| 1230 |
|
| 1231 |
if (!FieldExists("glpi_config", "licenses_management_restrict")) { |
| 1232 |
$query = "ALTER TABLE `glpi_config` ADD `licenses_management_restrict` INT( 1 ) NOT NULL DEFAULT '2';"; |
| 1233 |
$DB->query($query) or die("0.7 alter glpi_computers field licenses_management_restrict " . $DB->error()); |
| 1234 |
} |
| 1235 |
|
| 1236 |
if (!FieldExists("glpi_config", "license_deglobalisation")) { |
| 1237 |
$query = "ALTER TABLE `glpi_config` ADD `license_deglobalisation` INT( 1 ) NOT NULL DEFAULT '1';"; |
| 1238 |
$DB->query($query) or die("0.7 alter glpi_computers field license_deglobalisation " . $DB->error()); |
| 1239 |
} |
| 1240 |
|
| 1241 |
if (!FieldExists("glpi_registry", "registry_ocs_name")) { |
| 1242 |
$query = "ALTER TABLE `glpi_registry` ADD COLUMN `registry_ocs_name` char(255) NOT NULL default ''"; |
| 1243 |
$DB->query($query) or die("0.7 add registry_ocs_name in glpi_registry" . $LANG["update"][90] . $DB->error()); |
| 1244 |
} |
| 1245 |
|
| 1246 |
if (!FieldExists("glpi_config", "use_errorlog")) { |
| 1247 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `use_errorlog` INT( 1 ) NOT NULL default 0"; |
| 1248 |
$DB->query($query) or die("0.7 add use_errorlog in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1249 |
} |
| 1250 |
|
| 1251 |
if (!FieldExists("glpi_config", "glpi_timezone")) { |
| 1252 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `glpi_timezone` VARCHAR( 4 ) NOT NULL default 0"; |
| 1253 |
$DB->query($query) or die("0.7 add glpi_timezone in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1254 |
} |
| 1255 |
|
| 1256 |
if (!FieldExists("glpi_auth_ldap", "timezone")) { |
| 1257 |
$query = "ALTER TABLE `glpi_auth_ldap` ADD COLUMN `timezone` VARCHAR( 4 ) NOT NULL default 0"; |
| 1258 |
$DB->query($query) or die("0.7 add timezone in glpi_auth_ldap" . $LANG["update"][90] . $DB->error()); |
| 1259 |
} |
| 1260 |
|
| 1261 |
if (!FieldExists("glpi_ocs_config","glpi_link_enabled")) |
| 1262 |
{
|
| 1263 |
$query="ALTER TABLE `glpi_ocs_config` ADD COLUMN `glpi_link_enabled` int(1) NOT NULL, |
| 1264 |
ADD COLUMN `link_ip` int(1) NOT NULL,
|
| 1265 |
ADD COLUMN `link_name` int(1) NOT NULL,
|
| 1266 |
ADD COLUMN `link_mac_address` int(1) NOT NULL,
|
| 1267 |
ADD COLUMN `link_serial` int(1) NOT NULL,
|
| 1268 |
ADD COLUMN `link_if_status` int(11) NOT NULL default '0'";
|
| 1269 |
$DB->query($query) or die("0.7 add glpi_link fields in glpi_ocs_config" . $LANG["update"][90] . $DB->error()); |
| 1270 |
} |
| 1271 |
$intnull=array("glpi_alerts" => array("device_type","FK_device","type"), |
| 1272 |
"glpi_cartridges_type"=>array("tech_num"), |
| 1273 |
"glpi_computers"=>array("FK_users","FK_groups"), |
| 1274 |
"glpi_consumables_type"=>array("tech_num"), |
| 1275 |
"glpi_contacts"=>array("type"), |
| 1276 |
"glpi_device_case"=>array("type"), |
| 1277 |
"glpi_device_control"=>array("interface"), |
| 1278 |
"glpi_device_drive"=>array("interface"), |
| 1279 |
"glpi_dropdown_kbcategories"=>array("level"), |
| 1280 |
"glpi_dropdown_locations"=>array("level"), |
| 1281 |
"glpi_dropdown_tracking_category"=>array("level"), |
| 1282 |
"glpi_entities"=>array("level"), |
| 1283 |
"glpi_infocoms"=>array("FK_enterprise","budget"), |
| 1284 |
"glpi_monitors"=>array("type","model","FK_users","FK_groups"), |
| 1285 |
"glpi_networking"=>array("type","model","firmware","FK_users","FK_groups"), |
| 1286 |
"glpi_networking_ports"=>array("iface","netpoint"), |
| 1287 |
"glpi_ocs_link"=>array("ocs_server_id"), |
| 1288 |
"glpi_peripherals"=>array("model","FK_users","FK_groups"), |
| 1289 |
"glpi_phones"=>array("model","FK_users","FK_groups"), |
| 1290 |
"glpi_printers"=>array("type","model","FK_users","FK_groups"), |
| 1291 |
"glpi_software"=>array("location","platform","FK_users","FK_groups"), |
| 1292 |
"glpi_tracking"=>array("computer"), |
| 1293 |
"glpi_users_groups"=>array("FK_users","FK_groups"), |
| 1294 |
); |
| 1295 |
|
| 1296 |
foreach ($intnull as $table => $fields){ |
| 1297 |
foreach ($fields as $field){ |
| 1298 |
if (FieldExists($table, $field)) { |
| 1299 |
$query = "UPDATE `$table` SET `$field`=0 WHERE $field IS NULL;"; |
| 1300 |
$DB->query($query) or die("0.7 update datas in $table for NULL values " . $DB->error()); |
| 1301 |
$query = "ALTER TABLE `$table` CHANGE `$field` `$field` INT NOT NULL DEFAULT '0'"; |
| 1302 |
$DB->query($query) or die("0.7 alter $field in $table" . $DB->error()); |
| 1303 |
} else {
|
| 1304 |
// Error field does not exists : correct it
|
| 1305 |
$query = "ALTER TABLE `$table` ADD COLUMN `$field` INT NOT NULL DEFAULT '0'"; |
| 1306 |
$DB->query($query) or die("0.7 add $field in $table" . $DB->error()); |
| 1307 |
} |
| 1308 |
} |
| 1309 |
} |
| 1310 |
// Clean history
|
| 1311 |
$query = "DELETE FROM `glpi_history` WHERE `linked_action`=0 AND `device_internal_type`=0 AND `old_value`=`new_value` AND `old_value` IS NOT NULL AND `old_value`!='';"; |
| 1312 |
$DB->query($query) or die("0.7 clean glpi_history " . $DB->error()); |
| 1313 |
|
| 1314 |
$query = "DELETE FROM `glpi_display` WHERE `type`=".USER_TYPE." AND (`num`=4 );"; |
| 1315 |
$DB->query($query) or die("0.7 clean glpi_display for glpi_users " . $DB->error()); |
| 1316 |
|
| 1317 |
// Add fields to block auto updates on linked items
|
| 1318 |
if (!FieldExists("glpi_config", "autoupdate_link_contact")) { |
| 1319 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `autoupdate_link_contact` smallint(6) NOT NULL default '1'"; |
| 1320 |
$DB->query($query) or die("0.7 add autoupdate_link_contact in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1321 |
} |
| 1322 |
if (!FieldExists("glpi_config", "autoupdate_link_user")) { |
| 1323 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `autoupdate_link_user` smallint(6) NOT NULL default '1'"; |
| 1324 |
$DB->query($query) or die("0.7 add autoupdate_link_user in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1325 |
} |
| 1326 |
if (!FieldExists("glpi_config", "autoupdate_link_group")) { |
| 1327 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `autoupdate_link_group` smallint(6) NOT NULL default '1'"; |
| 1328 |
$DB->query($query) or die("0.7 add autoupdate_link_group in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1329 |
} |
| 1330 |
if (!FieldExists("glpi_config", "autoupdate_link_location")) { |
| 1331 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `autoupdate_link_location` smallint(6) NOT NULL default '1'"; |
| 1332 |
$DB->query($query) or die("0.7 add autoupdate_link_location in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1333 |
} |
| 1334 |
|
| 1335 |
// Flat dropdowntree
|
| 1336 |
if (!FieldExists("glpi_config", "flat_dropdowntree")) { |
| 1337 |
$query = "ALTER TABLE `glpi_config` ADD COLUMN `flat_dropdowntree` smallint(6) NOT NULL default '0'"; |
| 1338 |
$DB->query($query) or die("0.7 add flat_dropdowntree in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1339 |
} |
| 1340 |
if (FieldExists("glpi_config", "mailing_signature")) { |
| 1341 |
$query = "ALTER TABLE `glpi_config` CHANGE `mailing_signature` `mailing_signature` TEXT NULL "; |
| 1342 |
$DB->query($query) or die("0.7 alter mailing signature in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1343 |
} |
| 1344 |
|
| 1345 |
//Software categories
|
| 1346 |
if (!TableExists("glpi_dropdown_software_category")) |
| 1347 |
{
|
| 1348 |
$query="CREATE TABLE `glpi_dropdown_software_category` ( |
| 1349 |
`ID` int(11) NOT NULL auto_increment,
|
| 1350 |
`name` varchar(255) default NULL,
|
| 1351 |
`comments` text,
|
| 1352 |
PRIMARY KEY (`ID`)
|
| 1353 |
) ENGINE=MyISAM ";
|
| 1354 |
$DB->query($query) or die("0.7 add table glpi_dropdown_software_category" . $LANG["update"][90] . $DB->error()); |
| 1355 |
} |
| 1356 |
if (!FieldExists("glpi_profiles", "rule_softwarecategories")) { |
| 1357 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `rule_softwarecategories` char(1) default NULL AFTER `rule_ldap`"; |
| 1358 |
$DB->query($query) or die("0.7 add rule_softwarecategories in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1359 |
$query = "UPDATE `glpi_profiles` SET `rule_softwarecategories` = config"; |
| 1360 |
$DB->query($query) or die("0.7 update rule_softwarecategories values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1361 |
} |
| 1362 |
if (!FieldExists("glpi_software", "category")) { |
| 1363 |
$query = "ALTER TABLE `glpi_software` ADD `category` INT( 11 ) NOT NULL DEFAULT '0';"; |
| 1364 |
$DB->query($query) or die("0.7 alter category in glpi_software" . $LANG["update"][90] . $DB->error()); |
| 1365 |
} |
| 1366 |
|
| 1367 |
if (!FieldExists("glpi_ocs_config", "import_monitor_comments")) { |
| 1368 |
$query = "ALTER TABLE `glpi_ocs_config` ADD `import_monitor_comments` INT( 2 ) NOT NULL DEFAULT '0' AFTER `import_ip`"; |
| 1369 |
$DB->query($query) or die("0.7 alter import_monitor_comments in glpi_ocs_config" . $LANG["update"][90] . $DB->error()); |
| 1370 |
} |
| 1371 |
|
| 1372 |
if (!FieldExists("glpi_ocs_config", "import_software_comments")) { |
| 1373 |
$query = "ALTER TABLE `glpi_ocs_config` ADD `import_software_comments` INT NOT NULL DEFAULT '0' AFTER `import_monitor_comments`"; |
| 1374 |
$DB->query($query) or die("0.7 alter import_software_comments in glpi_ocs_config" . $LANG["update"][90] . $DB->error()); |
| 1375 |
} |
| 1376 |
|
| 1377 |
if (FieldExists("glpi_device_gfxcard", "ram")) { |
| 1378 |
//Update gfxcard memory management
|
| 1379 |
$query = "UPDATE glpi_device_gfxcard SET specif_default=ram"; |
| 1380 |
$DB->query($query) or die("0.7 glpi_device_gfxcard" . $LANG["update"][90] . $DB->error()); |
| 1381 |
|
| 1382 |
$query="ALTER TABLE `glpi_device_gfxcard` DROP `ram`"; |
| 1383 |
$DB->query($query) or die("0.7 delete 'ram' field from glpi_device_gfxcard" . $LANG["update"][90] . $DB->error()); |
| 1384 |
} |
| 1385 |
|
| 1386 |
if (FieldExists("glpi_config", "list_limit")) { |
| 1387 |
//Update gfxcard memory management
|
| 1388 |
$query = "ALTER TABLE `glpi_config` CHANGE `list_limit` `list_limit` INT NULL DEFAULT '20'"; |
| 1389 |
$DB->query($query) or die("0.7 alter list_limit in config" . $LANG["update"][90] . $DB->error()); |
| 1390 |
} |
| 1391 |
if (!FieldExists("glpi_config", "list_limit_max")) { |
| 1392 |
//Update gfxcard memory management
|
| 1393 |
$query = "ALTER TABLE `glpi_config` ADD `list_limit_max` INT NOT NULL DEFAULT '50' AFTER `list_limit` ;"; |
| 1394 |
$DB->query($query) or die("0.7 add list_limit_max in config" . $LANG["update"][90] . $DB->error()); |
| 1395 |
} |
| 1396 |
|
| 1397 |
if (!FieldExists("glpi_users", "list_limit")) { |
| 1398 |
//Update gfxcard memory management
|
| 1399 |
$query = "ALTER TABLE `glpi_users` ADD `list_limit` INT NOT NULL DEFAULT '20' AFTER `language` ;"; |
| 1400 |
$DB->query($query) or die("0.7 add list_limit_max in users" . $LANG["update"][90] . $DB->error()); |
| 1401 |
} |
| 1402 |
|
| 1403 |
if (!FieldExists("glpi_config", "autoname_entity")) { |
| 1404 |
$query = "ALTER TABLE `glpi_config` ADD `autoname_entity` smallint(6) NOT NULL default '1' "; |
| 1405 |
$DB->query($query) or die("0.7 add autoname_entity in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1406 |
} |
| 1407 |
|
| 1408 |
if (!FieldExists("glpi_profiles", "rule_tracking")) { |
| 1409 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `rule_tracking` char(1) default NULL AFTER `config`"; |
| 1410 |
$DB->query($query) or die("0.7 add rule_tracking in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1411 |
$query = "UPDATE `glpi_profiles` SET `rule_tracking` = config"; |
| 1412 |
$DB->query($query) or die("0.7 update rule_tracking values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1413 |
} |
| 1414 |
|
| 1415 |
if (FieldExists("glpi_profiles", "show_ticket")) { |
| 1416 |
$query = "ALTER TABLE `glpi_profiles` CHANGE `show_ticket` `show_all_ticket` CHAR( 1 ) DEFAULT NULL "; |
| 1417 |
$DB->query($query) or die("0.7 rename show_ticket to show_all_ticket in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1418 |
} |
| 1419 |
|
| 1420 |
if (!FieldExists("glpi_profiles", "show_assign_ticket")) { |
| 1421 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `show_assign_ticket` char(1) default NULL AFTER `show_all_ticket`"; |
| 1422 |
$DB->query($query) or die("0.7 add show_assign_ticket in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1423 |
$query = "UPDATE `glpi_profiles` SET `show_assign_ticket` = show_all_ticket"; |
| 1424 |
$DB->query($query) or die("0.7 update show_assign_ticket values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1425 |
} |
| 1426 |
|
| 1427 |
|
| 1428 |
if (!FieldExists("glpi_tracking", "assign_group")) { |
| 1429 |
$query = "ALTER TABLE `glpi_tracking` ADD `assign_group` INT NOT NULL DEFAULT '0' AFTER `assign_ent` ;"; |
| 1430 |
$DB->query($query) or die("0.7 add assign_group in tracking" . $LANG["update"][90] . $DB->error()); |
| 1431 |
$query = "ALTER TABLE `glpi_tracking` ADD INDEX ( `assign_group` ) ;"; |
| 1432 |
$DB->query($query) or die("0.7 add index on assign_group in tracking" . $LANG["update"][90] . $DB->error()); |
| 1433 |
} |
| 1434 |
|
| 1435 |
if (!FieldExists("glpi_config", "expand_soft_categorized")) { |
| 1436 |
$query = "ALTER TABLE `glpi_config` ADD `expand_soft_categorized` int(1) NOT NULL DEFAULT '1';"; |
| 1437 |
$DB->query($query) or die("0.7 add expand_soft_categorized in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1438 |
} |
| 1439 |
if (!FieldExists("glpi_config", "expand_soft_not_categorized")) { |
| 1440 |
$query = "ALTER TABLE `glpi_config` ADD `expand_soft_not_categorized` int(1) NOT NULL DEFAULT '1';"; |
| 1441 |
$DB->query($query) or die("0.7 add expand_soft_not_categorized in glpi_config" . $LANG["update"][90] . $DB->error()); |
| 1442 |
} |
| 1443 |
|
| 1444 |
// Clean history
|
| 1445 |
$query = "SELECT DISTINCT device_type FROM glpi_history"; |
| 1446 |
if ($result = $DB->query($query)){ |
| 1447 |
if ($DB->numrows($result)>0){ |
| 1448 |
while ($data = $DB->fetch_array($result)){ |
| 1449 |
$query2=" DELETE FROM glpi_history WHERE glpi_history.device_type='".$data['device_type']."' AND |
| 1450 |
glpi_history.FK_glpi_device NOT IN (SELECT ID FROM ".$LINK_ID_TABLE[$data['device_type']].")"; |
| 1451 |
$DB->query($query2); |
| 1452 |
} |
| 1453 |
} |
| 1454 |
} |
| 1455 |
|
| 1456 |
if (!TableExists("glpi_transfers")) { |
| 1457 |
$query="CREATE TABLE `glpi_transfers` ( |
| 1458 |
`ID` int(11) NOT NULL auto_increment,
|
| 1459 |
`name` varchar(255) NOT NULL,
|
| 1460 |
`keep_tickets` tinyint(4) NOT NULL default '0',
|
| 1461 |
`keep_networklinks` tinyint(4) NOT NULL default '0',
|
| 1462 |
`keep_reservations` tinyint(4) NOT NULL default '0',
|
| 1463 |
`keep_history` tinyint(4) NOT NULL default '0',
|
| 1464 |
`keep_devices` tinyint(4) NOT NULL default '0',
|
| 1465 |
`keep_infocoms` tinyint(4) NOT NULL default '0',
|
| 1466 |
`keep_dc_monitor` tinyint(4) NOT NULL default '0',
|
| 1467 |
`clean_dc_monitor` tinyint(4) NOT NULL default '0',
|
| 1468 |
`keep_dc_phone` tinyint(4) NOT NULL default '0',
|
| 1469 |
`clean_dc_phone` tinyint(4) NOT NULL default '0',
|
| 1470 |
`keep_dc_peripheral` tinyint(4) NOT NULL default '0',
|
| 1471 |
`clean_dc_peripheral` tinyint(4) NOT NULL default '0',
|
| 1472 |
`keep_dc_printer` tinyint(4) NOT NULL default '0',
|
| 1473 |
`clean_dc_printer` tinyint(4) NOT NULL default '0',
|
| 1474 |
`keep_enterprises` tinyint(4) NOT NULL default '0',
|
| 1475 |
`clean_enterprises` tinyint(4) NOT NULL default '0',
|
| 1476 |
`keep_contacts` tinyint(4) NOT NULL default '0',
|
| 1477 |
`clean_contacts` tinyint(4) NOT NULL default '0',
|
| 1478 |
`keep_contracts` tinyint(4) NOT NULL default '0',
|
| 1479 |
`clean_contracts` tinyint(4) NOT NULL default '0',
|
| 1480 |
`keep_softwares` tinyint(4) NOT NULL default '0',
|
| 1481 |
`clean_softwares` tinyint(4) NOT NULL default '0',
|
| 1482 |
`keep_documents` tinyint(4) NOT NULL default '0',
|
| 1483 |
`clean_documents` tinyint(4) NOT NULL default '0',
|
| 1484 |
`keep_cartridges_type` tinyint(4) NOT NULL default '0',
|
| 1485 |
`clean_cartridges_type` tinyint(4) NOT NULL default '0',
|
| 1486 |
`keep_cartridges` tinyint(4) NOT NULL default '0',
|
| 1487 |
`keep_consumables` tinyint(4) NOT NULL default '0',
|
| 1488 |
PRIMARY KEY (`ID`)
|
| 1489 |
) ENGINE=MyISAM ;";
|
| 1490 |
$DB->query($query) or die("0.7 add glpi_transfers " . $LANG["update"][90] . $DB->error()); |
| 1491 |
$query="INSERT INTO glpi_transfers VALUES ('1','complete','2','2','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1'); |
| 1492 |
";
|
| 1493 |
$DB->query($query) or die("0.7 insert transfer default values" . $LANG["update"][90] . $DB->error()); |
| 1494 |
} |
| 1495 |
|
| 1496 |
if (!FieldExists("glpi_profiles", "transfer")) { |
| 1497 |
$query = "ALTER TABLE `glpi_profiles` ADD COLUMN `transfer` char(1) default NULL AFTER `entity`"; |
| 1498 |
$DB->query($query) or die("0.7 add transfer in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1499 |
$query = "UPDATE `glpi_profiles` SET `transfer` = entity"; |
| 1500 |
$DB->query($query) or die("0.7 update transfer values in glpi_profiles" . $LANG["update"][90] . $DB->error()); |
| 1501 |
} |
| 1502 |
|
| 1503 |
// Need for update from SVN version
|
| 1504 |
if (!FieldExists("glpi_users", "location")) { |
| 1505 |
$query = "ALTER TABLE `glpi_users` ADD `location` int(11) NOT NULL DEFAULT 0;"; |
| 1506 |
$DB->query($query) or die("0.7 add location in users if not present for compatibility " . $LANG["update"][90] . $DB->error()); |
| 1507 |
} |
| 1508 |
|
| 1509 |
if (!FieldExists("glpi_ocs_config", "ocs_url")) { |
| 1510 |
$query = "ALTER TABLE `glpi_ocs_config` ADD `ocs_url` VARCHAR( 255 ) NOT NULL ;"; |
| 1511 |
$DB->query($query) or die("0.7 add ocs_url in glpi_ocs_config if not present for compatibility " . $LANG["update"][90] . $DB->error()); |
| 1512 |
} |
| 1513 |
|
| 1514 |
if (!FieldExists("glpi_ocs_link", "ocs_agent_version")) { |
| 1515 |
$query = "ALTER TABLE `glpi_ocs_link` ADD `ocs_agent_version` VARCHAR( 255 ) default NULL ;"; |
| 1516 |
$DB->query($query) or die("0.7 add ocs_agent_version in glpi_ocs_link if not present for compatibility " . $LANG["update"][90] . $DB->error()); |
| 1517 |
} |
| 1518 |
if (!isIndex("glpi_history", "date_mod")) { |
| 1519 |
$query = "ALTER TABLE `glpi_history` ADD INDEX ( `date_mod` )"; |
| 1520 |
$DB->query($query) or die("0.7 alter history add index on date_mod " . $LANG["update"][90] . $DB->error()); |
| 1521 |
} |
| 1522 |
|
| 1523 |
} // fin 0.7 #####################################################################################
|
| 1524 |
?>
|