ryxeo-glpi-git / install / update_042_05.php @ b67d8923
Historique | Voir | Annoter | Télécharger (53,4 ko)
| 1 |
<?php
|
|---|---|
| 2 |
/*
|
| 3 |
* @version $Id: update_042_05.php 7763 2009-01-06 18:44:50Z moyo $
|
| 4 |
-------------------------------------------------------------------------
|
| 5 |
GLPI - Gestionnaire Libre de Parc Informatique
|
| 6 |
Copyright (C) 2003-2009 by the INDEPNET Development Team.
|
| 7 |
|
| 8 |
http://indepnet.net/ http://glpi-project.org
|
| 9 |
-------------------------------------------------------------------------
|
| 10 |
|
| 11 |
LICENSE
|
| 12 |
|
| 13 |
This file is part of GLPI.
|
| 14 |
|
| 15 |
GLPI is free software; you can redistribute it and/or modify
|
| 16 |
it under the terms of the GNU General Public License as published by
|
| 17 |
the Free Software Foundation; either version 2 of the License, or
|
| 18 |
(at your option) any later version.
|
| 19 |
|
| 20 |
GLPI is distributed in the hope that it will be useful,
|
| 21 |
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
| 22 |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
| 23 |
GNU General Public License for more details.
|
| 24 |
|
| 25 |
You should have received a copy of the GNU General Public License
|
| 26 |
along with GLPI; if not, write to the Free Software
|
| 27 |
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
| 28 |
--------------------------------------------------------------------------
|
| 29 |
*/
|
| 30 |
|
| 31 |
// ----------------------------------------------------------------------
|
| 32 |
// Original Author of file:
|
| 33 |
// Purpose of file:
|
| 34 |
// ----------------------------------------------------------------------
|
| 35 |
|
| 36 |
/// Update from 0.42 to 0.5
|
| 37 |
function update042to05(){ |
| 38 |
global $DB,$LANG; |
| 39 |
|
| 40 |
echo "<p class='center'>Version 0.5 </p>"; |
| 41 |
|
| 42 |
|
| 43 |
// Augmentation taille itemtype
|
| 44 |
$query = "ALTER TABLE `glpi_event_log` CHANGE `itemtype` `itemtype` VARCHAR(20) NOT NULL ;"; |
| 45 |
$DB->query($query) or die("4204 ".$LANG["update"][90].$DB->error()); |
| 46 |
|
| 47 |
// Correction des itemtype tronqu�
|
| 48 |
$query = "UPDATE `glpi_event_log` SET `itemtype` = 'reservation' WHERE `itemtype` = 'reservatio' ;"; |
| 49 |
$DB->query($query) or die("4204 ".$LANG["update"][90].$DB->error()); |
| 50 |
|
| 51 |
|
| 52 |
/*******************************GLPI 0.5***********************************************/
|
| 53 |
//pass all templates to computers
|
| 54 |
if(!FieldExists("glpi_computers","is_template")) { |
| 55 |
$query = "ALTER TABLE `glpi_computers` ADD `is_template` ENUM('0','1') DEFAULT '0' NOT NULL "; |
| 56 |
$DB->query($query) or die("0.5 alter computers add is_template ".$LANG["update"][90].$DB->error()); |
| 57 |
$query = "ALTER TABLE `glpi_computers` ADD `tplname` VARCHAR(200) DEFAULT NULL "; |
| 58 |
$DB->query($query) or die("0.5 alter computers add tplname ".$LANG["update"][90].$DB->error()); |
| 59 |
|
| 60 |
$query = "Select * from glpi_templates"; |
| 61 |
$result = $DB->query($query); |
| 62 |
|
| 63 |
|
| 64 |
while($line = $DB->fetch_array($result)) { |
| 65 |
$line=addslashes_deep($line); |
| 66 |
$query2 = "INSERT INTO glpi_computers (`ID`,`name`, `osver`, `processor_speed`, `serial`, `otherserial`, `ram`, `hdspace`, `contact`, `contact_num`, `comments`, `achat_date`, `date_fin_garantie`, `maintenance`, `os`, `hdtype`, `sndcard`, `moboard`, `gfxcard`, `network`, `ramtype`, `location`, `processor`, `type`, `is_template`, `tplname`)"; |
| 67 |
|
| 68 |
$query2 .= " VALUES ('','".$line["name"]."', '".$line["osver"]."', '".$line["processor_speed"]."', '".$line["serial"]."', '".$line["otherserial"]."', '".$line["ram"]."', '".$line ["hdspace"]."', '".$line["contact"]."', '".$line["contact_num"]."', '".$line["comments"]."', '".$line["achat_date"]."', '".$line["date_fin_garantie"]."', '".$line["maintenance"]."', '".$line["os"]."', '".$line["hdtype"]."', '".$line["sndcard"]."', '".$line["moboard"]."', '".$line["gfxcard"]."', '".$line["network"]."', '".$line["ramtype"]."', '".$line["location"]."', '".$line["processor"]."', '".$line["type"]."','1','".$line["templname"]."')"; |
| 69 |
//echo $query2;
|
| 70 |
$DB->query($query2) or die("0.5-convert template 2 computers ".$DB->error()); |
| 71 |
} |
| 72 |
$DB->free_result($result); |
| 73 |
$query = "DROP TABLE glpi_templates"; |
| 74 |
$DB->query($query) or die("0.5 drop table templates ".$DB->error()); |
| 75 |
|
| 76 |
$query="SELECT ID FROM glpi_computers WHERE tplname='Blank Template'"; |
| 77 |
$result=$DB->query($query); |
| 78 |
if ($DB->numrows($result)==0){ |
| 79 |
$query="INSERT INTO glpi_computers (is_template,tplname) VALUES ('1','Blank Template')"; |
| 80 |
$DB->query($query) or die("0.5 add blank template ".$LANG["update"][90].$DB->error()); |
| 81 |
} |
| 82 |
$DB->free_result($result); |
| 83 |
} |
| 84 |
|
| 85 |
|
| 86 |
|
| 87 |
|
| 88 |
//New internal peripherals ( devices ) config
|
| 89 |
|
| 90 |
if(!TableExists("glpi_computer_device")) { |
| 91 |
$query = "CREATE TABLE `glpi_computer_device` ( |
| 92 |
`ID` int(11) NOT NULL auto_increment,
|
| 93 |
`specificity` varchar(250) NOT NULL default '',
|
| 94 |
`device_type` tinyint(4) NOT NULL default '0',
|
| 95 |
`FK_device` int(11) NOT NULL default '0',
|
| 96 |
`FK_computers` int(11) NOT NULL default '0',
|
| 97 |
PRIMARY KEY (`ID`),
|
| 98 |
KEY (`device_type`),
|
| 99 |
KEY (`device_type`,`FK_device`),
|
| 100 |
KEY (`FK_computers`)
|
| 101 |
) TYPE=MyISAM;";
|
| 102 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_computer_device` ".$LANG["update"][90].$DB->error()); |
| 103 |
} |
| 104 |
|
| 105 |
if(!TableExists("glpi_device_gfxcard")) { |
| 106 |
$query = "CREATE TABLE `glpi_device_gfxcard` ( |
| 107 |
`ID` int(11) NOT NULL auto_increment,
|
| 108 |
`designation` varchar(120) NOT NULL default '',
|
| 109 |
`ram` varchar(10) NOT NULL default '',
|
| 110 |
`interface` enum('AGP','PCI','PCI-X','Other') NOT NULL default 'AGP',
|
| 111 |
`comment` text NOT NULL,
|
| 112 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 113 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 114 |
PRIMARY KEY (`ID`),
|
| 115 |
KEY(`FK_glpi_enterprise`)
|
| 116 |
) TYPE=MyISAM;";
|
| 117 |
$DB->query($query) or die("0.5 create table `glpi_device_gfxcard` ".$LANG["update"][90].$DB->error()); |
| 118 |
compDpd2Device(GFX_DEVICE,"gfxcard","gfxcard","gfxcard"); |
| 119 |
} |
| 120 |
if(!TableExists("glpi_device_hdd")) { |
| 121 |
$query = "CREATE TABLE `glpi_device_hdd` ( |
| 122 |
`ID` int(11) NOT NULL auto_increment,
|
| 123 |
`designation` varchar(100) NOT NULL default '',
|
| 124 |
`rpm` varchar(20) NOT NULL default '',
|
| 125 |
`interface` enum('IDE','SATA','SCSI') NOT NULL default 'IDE',
|
| 126 |
`cache` varchar(20) NOT NULL default '',
|
| 127 |
`comment` text NOT NULL,
|
| 128 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 129 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 130 |
PRIMARY KEY (`ID`),
|
| 131 |
KEY(`FK_glpi_enterprise`)
|
| 132 |
) TYPE=MyISAM;";
|
| 133 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_device_hdtype` ".$LANG["update"][90].$DB->error()); |
| 134 |
compDpd2Device(HDD_DEVICE,"hdd","hdtype","hdtype","hdspace"); |
| 135 |
} |
| 136 |
if(!TableExists("glpi_device_iface")) { |
| 137 |
$query = "CREATE TABLE `glpi_device_iface` ( |
| 138 |
`ID` int(11) NOT NULL auto_increment,
|
| 139 |
`designation` varchar(120) NOT NULL default '',
|
| 140 |
`bandwidth` varchar(20) NOT NULL default '',
|
| 141 |
`comment` text NOT NULL,
|
| 142 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 143 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 144 |
PRIMARY KEY (`ID`),
|
| 145 |
KEY(`FK_glpi_enterprise`)
|
| 146 |
) TYPE=MyISAM;";
|
| 147 |
$DB->query($query) or die("0.5- CREATE TABLE `glpi_device_iface` ".$LANG["update"][90].$DB->error()); |
| 148 |
compDpd2Device(NETWORK_DEVICE,"iface","network","network"); |
| 149 |
} |
| 150 |
if(!TableExists("glpi_device_moboard")) { |
| 151 |
$query = "CREATE TABLE `glpi_device_moboard` ( |
| 152 |
`ID` int(11) NOT NULL auto_increment,
|
| 153 |
`designation` varchar(100) NOT NULL default '',
|
| 154 |
`chipset` varchar(120) NOT NULL default '',
|
| 155 |
`comment` text NOT NULL,
|
| 156 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 157 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 158 |
PRIMARY KEY (`ID`),
|
| 159 |
KEY(`FK_glpi_enterprise`)
|
| 160 |
) TYPE=MyISAM;";
|
| 161 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_device_moboard` ".$LANG["update"][90].$DB->error()); |
| 162 |
compDpd2Device(MOBOARD_DEVICE,"moboard","moboard","moboard"); |
| 163 |
} |
| 164 |
if(!TableExists("glpi_device_processor")) { |
| 165 |
$query = "CREATE TABLE `glpi_device_processor` ( |
| 166 |
`ID` int(11) NOT NULL auto_increment,
|
| 167 |
`designation` varchar(120) NOT NULL default '',
|
| 168 |
`frequence` int(11) NOT NULL default '0',
|
| 169 |
`comment` text NOT NULL,
|
| 170 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 171 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 172 |
PRIMARY KEY (`ID`),
|
| 173 |
KEY(`FK_glpi_enterprise`)
|
| 174 |
) TYPE=MyISAM;";
|
| 175 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_device_processor` ".$LANG["update"][90].$DB->error()); |
| 176 |
compDpd2Device(PROCESSOR_DEVICE,"processor","processor","processor","processor_speed"); |
| 177 |
} |
| 178 |
if(!TableExists("glpi_device_ram")) { |
| 179 |
$query = "CREATE TABLE `glpi_device_ram` ( |
| 180 |
`ID` int(11) NOT NULL auto_increment,
|
| 181 |
`designation` varchar(100) NOT NULL default '',
|
| 182 |
`type` enum('EDO','DDR','SDRAM','SDRAM-2') NOT NULL default 'EDO',
|
| 183 |
`frequence` varchar(8) NOT NULL default '',
|
| 184 |
`comment` text NOT NULL,
|
| 185 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 186 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 187 |
PRIMARY KEY (`ID`),
|
| 188 |
KEY(`FK_glpi_enterprise`)
|
| 189 |
) TYPE=MyISAM;";
|
| 190 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_device_ram` ".$LANG["update"][90].$DB->error()); |
| 191 |
compDpd2Device(RAM_DEVICE,"ram","ram","ramtype","ram"); |
| 192 |
} |
| 193 |
if(!TableExists("glpi_device_sndcard")) { |
| 194 |
$query = "CREATE TABLE `glpi_device_sndcard` ( |
| 195 |
`ID` int(11) NOT NULL auto_increment,
|
| 196 |
`designation` varchar(120) NOT NULL default '',
|
| 197 |
`type` varchar(100) NOT NULL default '',
|
| 198 |
`comment` text NOT NULL,
|
| 199 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 200 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 201 |
PRIMARY KEY (`ID`),
|
| 202 |
KEY(`FK_glpi_enterprise`)
|
| 203 |
) TYPE=MyISAM;";
|
| 204 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_device_sndcard ".$LANG["update"][90].$DB->error()); |
| 205 |
compDpd2Device(SND_DEVICE,"sndcard","sndcard","sndcard"); |
| 206 |
} |
| 207 |
|
| 208 |
if(!TableExists("glpi_device_power")) { |
| 209 |
$query = "CREATE TABLE glpi_device_power ( |
| 210 |
ID int(11) NOT NULL auto_increment,
|
| 211 |
designation varchar(255) NOT NULL default '',
|
| 212 |
power varchar(20) NOT NULL default '',
|
| 213 |
atx enum('Y','N') NOT NULL default 'Y',
|
| 214 |
`comment` text NOT NULL,
|
| 215 |
FK_glpi_enterprise int(11) NOT NULL default '0',
|
| 216 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 217 |
PRIMARY KEY (`ID`),
|
| 218 |
KEY FK_glpi_enterprise (`FK_glpi_enterprise`)
|
| 219 |
) TYPE=MyISAM;";
|
| 220 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 221 |
} |
| 222 |
|
| 223 |
if(!TableExists("glpi_device_case")) { |
| 224 |
$query = "CREATE TABLE glpi_device_case( |
| 225 |
ID int(11) NOT NULL AUTO_INCREMENT ,
|
| 226 |
designation varchar(255) NOT NULL default '',
|
| 227 |
format enum('Grand', 'Moyen', 'Micro') NOT NULL default 'Moyen',
|
| 228 |
`comment` text NOT NULL ,
|
| 229 |
FK_glpi_enterprise int(11) NOT NULL default '0',
|
| 230 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 231 |
PRIMARY KEY (`ID`) ,
|
| 232 |
KEY FK_glpi_enterprise(`FK_glpi_enterprise`)
|
| 233 |
)TYPE = MyISAM;";
|
| 234 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 235 |
} |
| 236 |
|
| 237 |
if(!TableExists("glpi_device_drive")) { |
| 238 |
$query = "CREATE TABLE `glpi_device_drive` ( |
| 239 |
`ID` INT NOT NULL AUTO_INCREMENT ,
|
| 240 |
`designation` VARCHAR(255) NOT NULL ,
|
| 241 |
`is_writer` ENUM('Y', 'N') DEFAULT 'Y' NOT NULL ,
|
| 242 |
`speed` VARCHAR(30) NOT NULL ,
|
| 243 |
`interface` ENUM('IDE', 'SATA', 'SCSI') NOT NULL ,
|
| 244 |
`comment` TEXT NOT NULL ,
|
| 245 |
`FK_glpi_enterprise` INT NOT NULL ,
|
| 246 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 247 |
KEY FK_glpi_enterprise(`FK_glpi_enterprise`),
|
| 248 |
PRIMARY KEY (`ID`)
|
| 249 |
)TYPE=MyISAM;";
|
| 250 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 251 |
} |
| 252 |
|
| 253 |
if(!TableExists("glpi_device_pci")) { |
| 254 |
$query = "CREATE TABLE glpi_device_pci ( |
| 255 |
ID int(11) NOT NULL auto_increment,
|
| 256 |
designation varchar(255) NOT NULL default '',
|
| 257 |
`comment` text NOT NULL,
|
| 258 |
FK_glpi_enterprise int(11) NOT NULL default '0',
|
| 259 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 260 |
PRIMARY KEY (ID),
|
| 261 |
KEY FK_glpi_enterprise (FK_glpi_enterprise)
|
| 262 |
) TYPE=MyISAM;";
|
| 263 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 264 |
} |
| 265 |
|
| 266 |
if(!TableExists("glpi_device_control")) { |
| 267 |
$query = "CREATE TABLE glpi_device_control ( |
| 268 |
ID int(11) NOT NULL auto_increment,
|
| 269 |
designation varchar(255) NOT NULL default '',
|
| 270 |
interface enum('IDE','SATA','SCSI','USB') NOT NULL default 'IDE',
|
| 271 |
raid enum('Y','N') NOT NULL default 'Y',
|
| 272 |
`comment` text NOT NULL,
|
| 273 |
FK_glpi_enterprise int(11) NOT NULL default '0',
|
| 274 |
`specif_default` VARCHAR(250) NOT NULL,
|
| 275 |
PRIMARY KEY (ID),
|
| 276 |
KEY FK_glpi_enterprise (FK_glpi_enterprise)
|
| 277 |
) TYPE=MyISAM;";
|
| 278 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 279 |
} |
| 280 |
|
| 281 |
|
| 282 |
// END new internal devices.
|
| 283 |
|
| 284 |
if(!TableExists("glpi_enterprises")) { |
| 285 |
$query = "CREATE TABLE `glpi_enterprises` ( |
| 286 |
`ID` int(11) NOT NULL auto_increment,
|
| 287 |
`name` varchar(50) NOT NULL default '',
|
| 288 |
`type` int(11) NOT NULL default '0',
|
| 289 |
`address` text NOT NULL default '',
|
| 290 |
`website` varchar(100) NOT NULL default '',
|
| 291 |
`phonenumber` varchar(20) NOT NULL default '',
|
| 292 |
`comments` text NOT NULL,
|
| 293 |
`deleted` enum('Y','N') NOT NULL default 'N',
|
| 294 |
PRIMARY KEY (`ID`),
|
| 295 |
KEY `deleted` (`deleted`),
|
| 296 |
KEY `type` (`type`)
|
| 297 |
) TYPE=MyISAM;";
|
| 298 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_enterprise ".$LANG["update"][90].$DB->error()); |
| 299 |
} |
| 300 |
|
| 301 |
/// Base connaissance
|
| 302 |
if(!TableExists("glpi_dropdown_kbcategories")) { |
| 303 |
$query="CREATE TABLE `glpi_dropdown_kbcategories` ( |
| 304 |
`ID` int(11) NOT NULL auto_increment,
|
| 305 |
`parentID` int(11) NOT NULL default '0',
|
| 306 |
`name` varchar(255) NOT NULL,
|
| 307 |
PRIMARY KEY (`ID`),
|
| 308 |
KEY(`parentID`),
|
| 309 |
UNIQUE KEY(`parentID`,`name`)
|
| 310 |
) TYPE=MyISAM;";
|
| 311 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_dropdown_kbcategories ".$LANG["update"][90].$DB->error()); |
| 312 |
|
| 313 |
$query="CREATE TABLE `glpi_kbitems` ( |
| 314 |
`ID` int(11) NOT NULL auto_increment,
|
| 315 |
`categoryID` int(11) NOT NULL default '0',
|
| 316 |
`question` text NOT NULL,
|
| 317 |
`answer` text NOT NULL,
|
| 318 |
`faq` enum('yes','no') NOT NULL default 'no',
|
| 319 |
PRIMARY KEY (`ID`),
|
| 320 |
KEY(`categoryID`)
|
| 321 |
) TYPE=MyISAM;";
|
| 322 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_kbitems ".$LANG["update"][90].$DB->error()); |
| 323 |
|
| 324 |
} |
| 325 |
|
| 326 |
// Comment reservation
|
| 327 |
if(!FieldExists("glpi_reservation_resa","comment")) { |
| 328 |
$query = "ALTER TABLE `glpi_reservation_resa` ADD `comment` VARCHAR(255) NOT NULL ;"; |
| 329 |
$DB->query($query) or die("0.5 alter reservation add comment ".$LANG["update"][90].$DB->error()); |
| 330 |
} |
| 331 |
|
| 332 |
// Tracking categorie
|
| 333 |
if(!TableExists("glpi_dropdown_tracking_category")) { |
| 334 |
|
| 335 |
$query= "CREATE TABLE glpi_dropdown_tracking_category ( |
| 336 |
ID int(11) NOT NULL auto_increment,
|
| 337 |
name varchar(255) default NULL,
|
| 338 |
PRIMARY KEY (ID)
|
| 339 |
) TYPE=MyISAM;";
|
| 340 |
$DB->query($query) or die("0.5 CREATE TABLE `glpi_dropdown_tracking_category ".$LANG["update"][90].$DB->error()); |
| 341 |
|
| 342 |
} |
| 343 |
|
| 344 |
if(!FieldExists("glpi_tracking","category")) { |
| 345 |
$query= "ALTER TABLE `glpi_tracking` ADD `category` INT(11) ;"; |
| 346 |
$DB->query($query) or die("0.5 alter tracking add categorie ".$LANG["update"][90].$DB->error()); |
| 347 |
} |
| 348 |
|
| 349 |
// Nouvelle gestion des software et licenses
|
| 350 |
if(!FieldExists("glpi_licenses","oem")) { |
| 351 |
$query = "ALTER TABLE `glpi_licenses` ADD `oem` ENUM('N', 'Y') DEFAULT 'N' NOT NULL , ADD `oem_computer` INT(11) NOT NULL, ADD `buy` ENUM('Y', 'N') DEFAULT 'Y' NOT NULL;"; |
| 352 |
$DB->query($query) or die("0.5 alter licenses add oem + buy ".$LANG["update"][90].$DB->error()); |
| 353 |
|
| 354 |
$query = "ALTER TABLE `glpi_software` ADD `is_update` ENUM('N', 'Y') DEFAULT 'N' NOT NULL , ADD `update_software` INT(11) NOT NULL DEFAULT '-1';"; |
| 355 |
$DB->query($query) or die("0.5 alter software add update ".$LANG["update"][90].$DB->error()); |
| 356 |
} |
| 357 |
|
| 358 |
// Couleur pour les priorit�
|
| 359 |
if(!FieldExists("glpi_config","priority_1")) { |
| 360 |
$query= "ALTER TABLE `glpi_config` ADD `priority_1` VARCHAR(200) DEFAULT '#fff2f2' NOT NULL, ADD `priority_2` VARCHAR(200) DEFAULT '#ffe0e0' NOT NULL, ADD `priority_3` VARCHAR(200) DEFAULT '#ffcece' NOT NULL, ADD `priority_4` VARCHAR(200) DEFAULT '#ffbfbf' NOT NULL, ADD `priority_5` VARCHAR(200) DEFAULT '#ffadad' NOT NULL ;"; |
| 361 |
$DB->query($query) or die("0.5 alter config add priority_X ".$LANG["update"][90].$DB->error()); |
| 362 |
|
| 363 |
} |
| 364 |
|
| 365 |
// Gestion des cartouches
|
| 366 |
if(!TableExists("glpi_cartridges")) { |
| 367 |
$query= "CREATE TABLE `glpi_cartridges` ( |
| 368 |
`ID` int(11) NOT NULL auto_increment,
|
| 369 |
`FK_glpi_cartridges_type` int(11) NOT NULL default '0',
|
| 370 |
`FK_glpi_printers` int(11) NOT NULL default '0',
|
| 371 |
`date_in` date default NULL,
|
| 372 |
`date_use` date default NULL,
|
| 373 |
`date_out` date default NULL,
|
| 374 |
`pages` int(11) NOT NULL default '0',
|
| 375 |
PRIMARY KEY (`ID`),
|
| 376 |
KEY(`FK_glpi_cartridges_type`),
|
| 377 |
KEY(`FK_glpi_printers`)
|
| 378 |
) TYPE=MyISAM;";
|
| 379 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_cartridges ".$LANG["update"][90].$DB->error()); |
| 380 |
|
| 381 |
$query= "CREATE TABLE `glpi_cartridges_type` ( |
| 382 |
`ID` int(11) NOT NULL auto_increment,
|
| 383 |
`name` varchar(255) NOT NULL default '',
|
| 384 |
`ref` varchar(255) NOT NULL default '',
|
| 385 |
`location` int(11) NOT NULL default '0',
|
| 386 |
`type` tinyint(4) NOT NULL default '0',
|
| 387 |
`FK_glpi_enterprise` int(11) NOT NULL default '0',
|
| 388 |
`tech_num` int(11) default '0',
|
| 389 |
`deleted` enum('Y','N') NOT NULL default 'N',
|
| 390 |
`comments` text NOT NULL,
|
| 391 |
PRIMARY KEY (`ID`),
|
| 392 |
KEY(`FK_glpi_enterprise`),
|
| 393 |
KEY(`tech_num`),
|
| 394 |
KEY(`deleted`)
|
| 395 |
) TYPE=MyISAM;";
|
| 396 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_cartridges_type ".$LANG["update"][90].$DB->error()); |
| 397 |
|
| 398 |
$query= "CREATE TABLE `glpi_cartridges_assoc` ( |
| 399 |
`ID` int(11) NOT NULL auto_increment,
|
| 400 |
`FK_glpi_cartridges_type` int(11) NOT NULL default '0',
|
| 401 |
`FK_glpi_type_printer` int(11) NOT NULL default '0',
|
| 402 |
PRIMARY KEY (`ID`),
|
| 403 |
UNIQUE KEY `FK_glpi_type_printer` (`FK_glpi_type_printer`,`FK_glpi_cartridges_type`),
|
| 404 |
KEY(`FK_glpi_cartridges_type`),
|
| 405 |
KEY(`FK_glpi_type_printer`)
|
| 406 |
) TYPE=MyISAM;";
|
| 407 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_cartridges_assoc ".$LANG["update"][90].$DB->error()); |
| 408 |
} |
| 409 |
|
| 410 |
//// DEBUT INSERTION PARTIE GESTION
|
| 411 |
if(!TableExists("glpi_contracts")) { |
| 412 |
$query= "CREATE TABLE `glpi_contacts` ( |
| 413 |
`ID` int(11) NOT NULL auto_increment,
|
| 414 |
`name` varchar(255) NOT NULL default '',
|
| 415 |
`phone` varchar(30) NOT NULL default '',
|
| 416 |
`phone2` varchar(30) NOT NULL default '',
|
| 417 |
`fax` varchar(30) NOT NULL default '',
|
| 418 |
`email` varchar(255) NOT NULL default '',
|
| 419 |
`type` tinyint(4) NOT NULL default '1',
|
| 420 |
`comments` text NOT NULL,
|
| 421 |
`deleted` enum('Y','N') NOT NULL default 'N',
|
| 422 |
PRIMARY KEY (`ID`)
|
| 423 |
) TYPE=MyISAM;";
|
| 424 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_contact ".$LANG["update"][90].$DB->error()); |
| 425 |
|
| 426 |
$query = " CREATE TABLE `glpi_dropdown_enttype` (`ID` INT NOT NULL AUTO_INCREMENT ,`name` VARCHAR(255) NOT NULL ,PRIMARY KEY (`ID`))"; |
| 427 |
$DB->query($query) or die("23 ".$LANG["update"][90].$DB->error()); |
| 428 |
|
| 429 |
|
| 430 |
$query= "CREATE TABLE `glpi_contact_enterprise` ( |
| 431 |
`ID` int(11) NOT NULL auto_increment,
|
| 432 |
`FK_enterprise` int(11) NOT NULL default '0',
|
| 433 |
`FK_contact` int(11) NOT NULL default '0',
|
| 434 |
PRIMARY KEY (`ID`),
|
| 435 |
UNIQUE KEY `FK_enterprise` (`FK_enterprise`,`FK_contact`),
|
| 436 |
KEY(`FK_enterprise`),
|
| 437 |
KEY(`FK_contact`)
|
| 438 |
) TYPE=MyISAM;";
|
| 439 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_contact_enterprise ".$LANG["update"][90].$DB->error()); |
| 440 |
|
| 441 |
$query= "CREATE TABLE `glpi_contracts` ( |
| 442 |
`ID` int(11) NOT NULL auto_increment,
|
| 443 |
`name` varchar(255) NOT NULL default '',
|
| 444 |
`num` varchar(255) NOT NULL default '',
|
| 445 |
`cost` float NOT NULL default '0',
|
| 446 |
`contract_type` int(11) NOT NULL default '0',
|
| 447 |
`begin_date` date default NULL,
|
| 448 |
`duration` tinyint(4) NOT NULL default '0',
|
| 449 |
`notice` tinyint(4) NOT NULL default '0',
|
| 450 |
`periodicity` tinyint(4) NOT NULL default '0',
|
| 451 |
`facturation` tinyint(4) NOT NULL default '0',
|
| 452 |
`bill_type` int(11) NOT NULL default '0',
|
| 453 |
`comments` text NOT NULL,
|
| 454 |
`compta_num` varchar(255) NOT NULL default '',
|
| 455 |
`deleted` enum('Y','N') NOT NULL default 'N',
|
| 456 |
`week_begin_hour` time NOT NULL default '00:00:00',
|
| 457 |
`week_end_hour` time NOT NULL default '00:00:00',
|
| 458 |
`saturday_begin_hour` time NOT NULL default '00:00:00',
|
| 459 |
`saturday_end_hour` time NOT NULL default '00:00:00',
|
| 460 |
`saturday` enum('Y','N') NOT NULL default 'N',
|
| 461 |
`monday_begin_hour` time NOT NULL default '00:00:00',
|
| 462 |
`monday_end_hour` time NOT NULL default '00:00:00',
|
| 463 |
`monday` enum('Y','N') NOT NULL default 'N',
|
| 464 |
PRIMARY KEY (`ID`),
|
| 465 |
KEY `contract_type` (`contract_type`),
|
| 466 |
KEY `begin_date` (`begin_date`),
|
| 467 |
KEY `bill_type` (`bill_type`)
|
| 468 |
) TYPE=MyISAM;";
|
| 469 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_contract ".$LANG["update"][90].$DB->error()); |
| 470 |
|
| 471 |
$query= "CREATE TABLE `glpi_contract_device` ( |
| 472 |
`ID` int(11) NOT NULL auto_increment,
|
| 473 |
`FK_contract` int(11) NOT NULL default '0',
|
| 474 |
`FK_device` int(11) NOT NULL default '0',
|
| 475 |
`device_type` tinyint(4) NOT NULL default '0',
|
| 476 |
PRIMARY KEY (`ID`),
|
| 477 |
UNIQUE KEY `FK_contract` (`FK_contract`,`FK_device`,`device_type`),
|
| 478 |
KEY (`FK_contract`),
|
| 479 |
KEY (`FK_device`,`device_type`)
|
| 480 |
) TYPE=MyISAM;";
|
| 481 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_contract_device ".$LANG["update"][90].$DB->error()); |
| 482 |
|
| 483 |
$query= "CREATE TABLE `glpi_contract_enterprise` ( |
| 484 |
`ID` int(11) NOT NULL auto_increment,
|
| 485 |
`FK_enterprise` int(11) NOT NULL default '0',
|
| 486 |
`FK_contract` int(11) NOT NULL default '0',
|
| 487 |
PRIMARY KEY (`ID`),
|
| 488 |
UNIQUE KEY `FK_enterprise` (`FK_enterprise`,`FK_contract`),
|
| 489 |
KEY (`FK_enterprise`),
|
| 490 |
KEY (`FK_contract`)
|
| 491 |
) TYPE=MyISAM;";
|
| 492 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_contrat_enterprise ".$LANG["update"][90].$DB->error()); |
| 493 |
|
| 494 |
$query= "CREATE TABLE `glpi_infocoms` ( |
| 495 |
`ID` int(11) NOT NULL auto_increment,
|
| 496 |
`FK_device` int(11) NOT NULL default '0',
|
| 497 |
`device_type` tinyint(4) NOT NULL default '0',
|
| 498 |
`buy_date` date NOT NULL default '0000-00-00',
|
| 499 |
`use_date` date NOT NULL default '0000-00-00',
|
| 500 |
`warranty_duration` tinyint(4) NOT NULL default '0',
|
| 501 |
`warranty_info` varchar(255) NOT NULL default '',
|
| 502 |
`FK_enterprise` int(11) default NULL,
|
| 503 |
`num_commande` varchar(50) NOT NULL default '',
|
| 504 |
`bon_livraison` varchar(50) NOT NULL default '',
|
| 505 |
`num_immo` varchar(50) NOT NULL default '',
|
| 506 |
`value` float NOT NULL default '0',
|
| 507 |
`warranty_value` float default NULL,
|
| 508 |
`amort_time` tinyint(4) NOT NULL default '0',
|
| 509 |
`amort_type` varchar(20) NOT NULL default '',
|
| 510 |
`amort_coeff` float NOT NULL default '0',
|
| 511 |
`comments` text NOT NULL,
|
| 512 |
PRIMARY KEY (`ID`),
|
| 513 |
UNIQUE KEY `FK_device` (`FK_device`,`device_type`),
|
| 514 |
KEY `FK_enterprise` (`FK_enterprise`),
|
| 515 |
KEY `buy_date` (`buy_date`)
|
| 516 |
) TYPE=MyISAM;";
|
| 517 |
$DB->query($query) or die("0.5 CREATE TABLE glpi_infocom ".$LANG["update"][90].$DB->error()); |
| 518 |
|
| 519 |
///// Move warranty infos from item to infocoms.
|
| 520 |
|
| 521 |
|
| 522 |
|
| 523 |
// Update Warranty Infos
|
| 524 |
updateWarrantyInfos("glpi_computers",COMPUTER_TYPE); |
| 525 |
updateWarrantyInfos("glpi_printers",PRINTER_TYPE); |
| 526 |
updateWarrantyInfos("glpi_networking",NETWORKING_TYPE); |
| 527 |
updateWarrantyInfos("glpi_monitors",MONITOR_TYPE); |
| 528 |
updateWarrantyInfos("glpi_peripherals",PERIPHERAL_TYPE); |
| 529 |
|
| 530 |
// Update Maintenance Infos
|
| 531 |
if (isMaintenanceUsed()){
|
| 532 |
|
| 533 |
$query="INSERT INTO `glpi_contracts` VALUES (1, 'Maintenance', '', '0', 5, '2005-01-01', 120, 0, 0, 0, 0, '', '', 'N', '00:00:00', '00:00:00', '00:00:00', '00:00:00', 'N', '00:00:00', '00:00:00', 'N');"; |
| 534 |
$result=$DB->query($query) or die("0.5 insert_init for update maintenace ".$LANG["update"][90].$DB->error()); |
| 535 |
|
| 536 |
if ($result){ |
| 537 |
$query="SELECT ID FROM glpi_contracts;"; |
| 538 |
$result=$DB->query($query) or die("0.5 select_init for update maintenace ".$LANG["update"][90].$DB->error()); |
| 539 |
if ($result){ |
| 540 |
$data=$DB->fetch_array($result); |
| 541 |
$IDcontract=$data["ID"]; |
| 542 |
updateMaintenanceInfos("glpi_computers",COMPUTER_TYPE,$IDcontract); |
| 543 |
updateMaintenanceInfos("glpi_printers",PRINTER_TYPE,$IDcontract); |
| 544 |
updateMaintenanceInfos("glpi_networking",NETWORKING_TYPE,$IDcontract); |
| 545 |
updateMaintenanceInfos("glpi_monitors",MONITOR_TYPE,$IDcontract); |
| 546 |
updateMaintenanceInfos("glpi_peripherals",PERIPHERAL_TYPE,$IDcontract); |
| 547 |
} |
| 548 |
} |
| 549 |
} else dropMaintenanceField();
|
| 550 |
|
| 551 |
} |
| 552 |
//// FIN INSERTION PARTIE GESTION
|
| 553 |
|
| 554 |
// Merge de l'OS et de la version
|
| 555 |
if(FieldExists("glpi_computers","osver")) { |
| 556 |
// R�up�ation des couples existants
|
| 557 |
$query="SELECT DISTINCT glpi_computers.os AS ID , glpi_computers.osver AS VERS, glpi_dropdown_os.name as NAME FROM glpi_computers |
| 558 |
LEFT JOIN glpi_dropdown_os ON glpi_dropdown_os.ID=glpi_computers.os ORDER BY glpi_computers.os, glpi_computers.osver";
|
| 559 |
$result=$DB->query($query) or die("0.5 select for update OS ".$LANG["update"][90].$DB->error()); |
| 560 |
$valeur=array(); |
| 561 |
$curros=-1; |
| 562 |
$currvers="-------------------------"; |
| 563 |
while ($data=$DB->fetch_array($result)){ |
| 564 |
// Nouvel OS -> update de l'element de dropdown
|
| 565 |
if ($data["ID"]!=$curros){ |
| 566 |
$curros=$data["ID"]; |
| 567 |
|
| 568 |
if (!empty($data["VERS"])){ |
| 569 |
$query_update="UPDATE glpi_dropdown_os SET name='".$data["NAME"]." - ".$data["VERS"]."' WHERE ID='".$data["ID"]."'"; |
| 570 |
$DB->query($query_update) or die("0.5 update for update OS ".$LANG["update"][90].$DB->error()); |
| 571 |
} |
| 572 |
|
| 573 |
} else { // OS deja mis a jour -> creation d'un nouvel OS et mise a jour des elements |
| 574 |
$newname=$data["NAME"]." - ".$data["VERS"]; |
| 575 |
$query_insert="INSERT INTO glpi_dropdown_os (name) VALUES ('$newname');"; |
| 576 |
$DB->query($query_insert) or die("0.5 insert for update OS ".$LANG["update"][90].$DB->error()); |
| 577 |
$query_select="SELECT ID from glpi_dropdown_os WHERE name = '$newname';"; |
| 578 |
$res=$DB->query($query_select) or die("0.5 select for update OS ".$LANG["update"][90].$DB->error()); |
| 579 |
if ($DB->numrows($res)==1){ |
| 580 |
$query_update="UPDATE glpi_computers SET os='".$DB->result($res,0,"ID")."' WHERE os='".$data["ID"]."' AND osver='".$data["VERS"]."'"; |
| 581 |
$DB->query($query_update) or die("0.5 update2 for update OS ".$LANG["update"][90].$DB->error()); |
| 582 |
} |
| 583 |
|
| 584 |
} |
| 585 |
} |
| 586 |
$DB->free_result($result); |
| 587 |
$query_alter= "ALTER TABLE `glpi_computers` DROP `osver` "; |
| 588 |
$DB->query($query_alter) or die("0.5 alter for update OS ".$LANG["update"][90].$DB->error()); |
| 589 |
} |
| 590 |
|
| 591 |
// Ajout Fabriquant computer
|
| 592 |
if(!FieldExists("glpi_computers","FK_glpi_enterprise")) { |
| 593 |
|
| 594 |
$query = "ALTER TABLE `glpi_computers` ADD `FK_glpi_enterprise` INT(11) DEFAULT '0' NOT NULL ;"; |
| 595 |
$DB->query($query) or die("0.5 add field manufacturer ".$LANG["update"][90].$DB->error()); |
| 596 |
|
| 597 |
|
| 598 |
$query="ALTER TABLE `glpi_computers` ADD INDEX (`FK_glpi_enterprise`)" ; |
| 599 |
$DB->query($query) or die("0.5 alter field manufacturer ".$LANG["update"][90].$DB->error()); |
| 600 |
|
| 601 |
} |
| 602 |
|
| 603 |
// Ajout Fabriquant printer
|
| 604 |
if(!FieldExists("glpi_printers","FK_glpi_enterprise")) { |
| 605 |
|
| 606 |
$query = "ALTER TABLE `glpi_printers` ADD `FK_glpi_enterprise` INT(11) DEFAULT '0' NOT NULL ;"; |
| 607 |
$DB->query($query) or die("0.5 add field manufacturer ".$LANG["update"][90].$DB->error()); |
| 608 |
|
| 609 |
$query="ALTER TABLE `glpi_printers` ADD INDEX (`FK_glpi_enterprise`)" ; |
| 610 |
$DB->query($query) or die("0.5 alter field manufacturer ".$LANG["update"][90].$DB->error()); |
| 611 |
|
| 612 |
|
| 613 |
} |
| 614 |
|
| 615 |
// Ajout Fabriquant networking
|
| 616 |
if(!FieldExists("glpi_networking","FK_glpi_enterprise")) { |
| 617 |
|
| 618 |
$query = "ALTER TABLE `glpi_networking` ADD `FK_glpi_enterprise` INT(11) DEFAULT '0' NOT NULL ;"; |
| 619 |
$DB->query($query) or die("0.5 add field manufacturer ".$LANG["update"][90].$DB->error()); |
| 620 |
|
| 621 |
$query="ALTER TABLE `glpi_networking` ADD INDEX (`FK_glpi_enterprise`)" ; |
| 622 |
$DB->query($query) or die("0.5 alter field manufacturer ".$LANG["update"][90].$DB->error()); |
| 623 |
|
| 624 |
|
| 625 |
} |
| 626 |
|
| 627 |
// Ajout Fabriquant monitor
|
| 628 |
if(!FieldExists("glpi_monitors","FK_glpi_enterprise")) { |
| 629 |
|
| 630 |
$query = "ALTER TABLE `glpi_monitors` ADD `FK_glpi_enterprise` INT(11) DEFAULT '0' NOT NULL ;"; |
| 631 |
$DB->query($query) or die("0.5 add field manufacturer ".$LANG["update"][90].$DB->error()); |
| 632 |
|
| 633 |
$query="ALTER TABLE `glpi_monitors` ADD INDEX (`FK_glpi_enterprise`)" ; |
| 634 |
$DB->query($query) or die("0.5 alter field manufacturer ".$LANG["update"][90].$DB->error()); |
| 635 |
|
| 636 |
|
| 637 |
} |
| 638 |
|
| 639 |
// Ajout Fabriquant software
|
| 640 |
if(!FieldExists("glpi_software","FK_glpi_enterprise")) { |
| 641 |
|
| 642 |
$query = "ALTER TABLE `glpi_software` ADD `FK_glpi_enterprise` INT(11) DEFAULT '0' NOT NULL ;"; |
| 643 |
$DB->query($query) or die("0.5 add field manufacturer ".$LANG["update"][90].$DB->error()); |
| 644 |
|
| 645 |
$query="ALTER TABLE `glpi_software` ADD INDEX (`FK_glpi_enterprise`)" ; |
| 646 |
$DB->query($query) or die("0.5 alter field manufacturer ".$LANG["update"][90].$DB->error()); |
| 647 |
|
| 648 |
|
| 649 |
} |
| 650 |
|
| 651 |
// Ajout Fabriquant peripheral
|
| 652 |
if(!FieldExists("glpi_peripherals","FK_glpi_enterprise")) { |
| 653 |
|
| 654 |
$query = "ALTER TABLE `glpi_peripherals` ADD `FK_glpi_enterprise` INT(11) DEFAULT '0' NOT NULL ;"; |
| 655 |
$DB->query($query) or die("0.5 add field manufacturer ".$LANG["update"][90].$DB->error()); |
| 656 |
|
| 657 |
$query="ALTER TABLE `glpi_peripherals` ADD INDEX (`FK_glpi_enterprise`)" ; |
| 658 |
$DB->query($query) or die("0.5 alter field manufacturer ".$LANG["update"][90].$DB->error()); |
| 659 |
|
| 660 |
|
| 661 |
} |
| 662 |
|
| 663 |
// Ajout deleted peripheral
|
| 664 |
if(!FieldExists("glpi_peripherals","deleted")) { |
| 665 |
|
| 666 |
$query = "ALTER TABLE `glpi_peripherals` ADD `deleted` ENUM('Y', 'N') DEFAULT 'N' NOT NULL ;"; |
| 667 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 668 |
|
| 669 |
$query="ALTER TABLE `glpi_peripherals` ADD INDEX (`deleted`)" ; |
| 670 |
$DB->query($query) or die("0.5 alter field deleted ".$LANG["update"][90].$DB->error()); |
| 671 |
|
| 672 |
|
| 673 |
} |
| 674 |
|
| 675 |
// Ajout deleted software
|
| 676 |
if(!FieldExists("glpi_software","deleted")) { |
| 677 |
|
| 678 |
$query = "ALTER TABLE `glpi_software` ADD `deleted` ENUM('Y', 'N') DEFAULT 'N' NOT NULL ;"; |
| 679 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 680 |
|
| 681 |
$query="ALTER TABLE `glpi_software` ADD INDEX (`deleted`)" ; |
| 682 |
$DB->query($query) or die("0.5 alter field deleted ".$LANG["update"][90].$DB->error()); |
| 683 |
|
| 684 |
|
| 685 |
} |
| 686 |
|
| 687 |
// Ajout deleted monitor
|
| 688 |
if(!FieldExists("glpi_monitors","deleted")) { |
| 689 |
|
| 690 |
$query = "ALTER TABLE `glpi_monitors` ADD `deleted` ENUM('Y', 'N') DEFAULT 'N' NOT NULL ;"; |
| 691 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 692 |
|
| 693 |
$query="ALTER TABLE `glpi_monitors` ADD INDEX (`deleted`)" ; |
| 694 |
$DB->query($query) or die("0.5 alter field deleted ".$LANG["update"][90].$DB->error()); |
| 695 |
|
| 696 |
|
| 697 |
} |
| 698 |
|
| 699 |
// Ajout deleted networking
|
| 700 |
if(!FieldExists("glpi_networking","deleted")) { |
| 701 |
|
| 702 |
$query = "ALTER TABLE `glpi_networking` ADD `deleted` ENUM('Y', 'N') DEFAULT 'N' NOT NULL ;"; |
| 703 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 704 |
|
| 705 |
$query="ALTER TABLE `glpi_networking` ADD INDEX (`deleted`)" ; |
| 706 |
$DB->query($query) or die("0.5 alter field deleted ".$LANG["update"][90].$DB->error()); |
| 707 |
|
| 708 |
|
| 709 |
} |
| 710 |
// Ajout deleted printer
|
| 711 |
if(!FieldExists("glpi_printers","deleted")) { |
| 712 |
|
| 713 |
$query = "ALTER TABLE `glpi_printers` ADD `deleted` ENUM('Y', 'N') DEFAULT 'N' NOT NULL ;"; |
| 714 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 715 |
|
| 716 |
$query="ALTER TABLE `glpi_printers` ADD INDEX (`deleted`)" ; |
| 717 |
$DB->query($query) or die("0.5 alter field deleted ".$LANG["update"][90].$DB->error()); |
| 718 |
|
| 719 |
|
| 720 |
} |
| 721 |
// Ajout deleted computer
|
| 722 |
if(!FieldExists("glpi_computers","deleted")) { |
| 723 |
|
| 724 |
$query = "ALTER TABLE `glpi_computers` ADD `deleted` ENUM('Y', 'N') DEFAULT 'N' NOT NULL ;"; |
| 725 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 726 |
|
| 727 |
$query="ALTER TABLE `glpi_computers` ADD INDEX (`deleted`)" ; |
| 728 |
$DB->query($query) or die("0.5 alter field deleted ".$LANG["update"][90].$DB->error()); |
| 729 |
|
| 730 |
|
| 731 |
} |
| 732 |
|
| 733 |
// Ajout template peripheral
|
| 734 |
if(!FieldExists("glpi_peripherals","is_template")) { |
| 735 |
|
| 736 |
$query = "ALTER TABLE `glpi_peripherals` ADD `is_template` ENUM('0', '1') DEFAULT '0' NOT NULL , ADD `tplname` VARCHAR(255) ;"; |
| 737 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 738 |
|
| 739 |
$query="INSERT INTO glpi_peripherals (is_template,tplname) VALUES ('1','Blank Template')"; |
| 740 |
$DB->query($query) or die("0.5 add blank template ".$LANG["update"][90].$DB->error()); |
| 741 |
|
| 742 |
$query="ALTER TABLE `glpi_peripherals` ADD INDEX (`is_template`)" ; |
| 743 |
$DB->query($query) or die("0.5 alter field is_template ".$LANG["update"][90].$DB->error()); |
| 744 |
|
| 745 |
|
| 746 |
} |
| 747 |
|
| 748 |
// Ajout template software
|
| 749 |
if(!FieldExists("glpi_software","is_template")) { |
| 750 |
|
| 751 |
$query = "ALTER TABLE `glpi_software` ADD `is_template` ENUM('0', '1') DEFAULT '0' NOT NULL , ADD `tplname` VARCHAR(255) ;"; |
| 752 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 753 |
|
| 754 |
$query="INSERT INTO glpi_software (is_template,tplname) VALUES ('1','Blank Template')"; |
| 755 |
$DB->query($query) or die("0.5 add blank template ".$LANG["update"][90].$DB->error()); |
| 756 |
|
| 757 |
$query="ALTER TABLE `glpi_software` ADD INDEX (`is_template`)" ; |
| 758 |
$DB->query($query) or die("0.5 alter field is_template ".$LANG["update"][90].$DB->error()); |
| 759 |
|
| 760 |
} |
| 761 |
|
| 762 |
// Ajout template monitor
|
| 763 |
if(!FieldExists("glpi_monitors","is_template")) { |
| 764 |
|
| 765 |
$query = "ALTER TABLE `glpi_monitors` ADD `is_template` ENUM('0', '1') DEFAULT '0' NOT NULL , ADD `tplname` VARCHAR(255) ;"; |
| 766 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 767 |
|
| 768 |
$query="INSERT INTO glpi_monitors (is_template,tplname) VALUES ('1','Blank Template')"; |
| 769 |
$DB->query($query) or die("0.5 add blank template ".$LANG["update"][90].$DB->error()); |
| 770 |
|
| 771 |
$query="ALTER TABLE `glpi_monitors` ADD INDEX (`is_template`)" ; |
| 772 |
$DB->query($query) or die("0.5 alter field is_template ".$LANG["update"][90].$DB->error()); |
| 773 |
|
| 774 |
|
| 775 |
} |
| 776 |
|
| 777 |
if(!isIndex("glpi_computers", "is_template")) { |
| 778 |
$query = "ALTER TABLE `glpi_computers` ADD INDEX (`is_template`) "; |
| 779 |
$DB->query($query) or die("5 ".$LANG["update"][90].$DB->error()); |
| 780 |
} |
| 781 |
|
| 782 |
// Ajout template networking
|
| 783 |
if(!FieldExists("glpi_networking","is_template")) { |
| 784 |
|
| 785 |
$query = "ALTER TABLE `glpi_networking` ADD `is_template` ENUM('0', '1') DEFAULT '0' NOT NULL , ADD `tplname` VARCHAR(255) ;"; |
| 786 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 787 |
|
| 788 |
$query="INSERT INTO glpi_networking (is_template,tplname) VALUES ('1','Blank Template')"; |
| 789 |
$DB->query($query) or die("0.5 add blank template ".$LANG["update"][90].$DB->error()); |
| 790 |
|
| 791 |
$query="ALTER TABLE `glpi_networking` ADD INDEX (`is_template`)" ; |
| 792 |
$DB->query($query) or die("0.5 alter field is_template ".$LANG["update"][90].$DB->error()); |
| 793 |
|
| 794 |
|
| 795 |
} |
| 796 |
// Ajout template printer
|
| 797 |
if(!FieldExists("glpi_printers","is_template")) { |
| 798 |
|
| 799 |
$query = "ALTER TABLE `glpi_printers` ADD `is_template` ENUM('0', '1') DEFAULT '0' NOT NULL , ADD `tplname` VARCHAR(255) ;"; |
| 800 |
$DB->query($query) or die("0.5 add field deleted ".$LANG["update"][90].$DB->error()); |
| 801 |
|
| 802 |
$query="INSERT INTO glpi_printers (is_template,tplname) VALUES ('1','Blank Template')"; |
| 803 |
$DB->query($query) or die("0.5 add blank template ".$LANG["update"][90].$DB->error()); |
| 804 |
|
| 805 |
$query="ALTER TABLE `glpi_printers` ADD INDEX (`is_template`)" ; |
| 806 |
$DB->query($query) or die("0.5 alter field is_template ".$LANG["update"][90].$DB->error()); |
| 807 |
|
| 808 |
|
| 809 |
|
| 810 |
} |
| 811 |
// Ajout date_mod
|
| 812 |
if(!FieldExists("glpi_printers","date_mod")) { |
| 813 |
$query = "ALTER TABLE `glpi_printers` ADD `date_mod` DATETIME DEFAULT NULL"; |
| 814 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 815 |
|
| 816 |
$query="ALTER TABLE `glpi_printers` ADD INDEX (`date_mod`)" ; |
| 817 |
$DB->query($query) or die("0.5 alter field date_mod ".$LANG["update"][90].$DB->error()); |
| 818 |
|
| 819 |
} |
| 820 |
|
| 821 |
if(!isIndex("glpi_computers", "date_mod")) { |
| 822 |
$query = "ALTER TABLE `glpi_computers` ADD INDEX (`date_mod`) "; |
| 823 |
$DB->query($query) or die("5 ".$LANG["update"][90].$DB->error()); |
| 824 |
} |
| 825 |
|
| 826 |
// Ajout date_mod
|
| 827 |
if(!FieldExists("glpi_monitors","date_mod")) { |
| 828 |
$query = "ALTER TABLE `glpi_monitors` ADD `date_mod` DATETIME DEFAULT NULL"; |
| 829 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 830 |
|
| 831 |
$query="ALTER TABLE `glpi_monitors` ADD INDEX (`date_mod`)" ; |
| 832 |
$DB->query($query) or die("0.5 alter field date_mod ".$LANG["update"][90].$DB->error()); |
| 833 |
} |
| 834 |
|
| 835 |
// Ajout date_mod
|
| 836 |
if(!FieldExists("glpi_software","date_mod")) { |
| 837 |
$query = "ALTER TABLE `glpi_software` ADD `date_mod` DATETIME DEFAULT NULL"; |
| 838 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 839 |
|
| 840 |
$query="ALTER TABLE `glpi_software` ADD INDEX (`date_mod`)" ; |
| 841 |
$DB->query($query) or die("0.5 alter field date_mod ".$LANG["update"][90].$DB->error()); |
| 842 |
} |
| 843 |
|
| 844 |
// Ajout date_mod
|
| 845 |
if(!FieldExists("glpi_networking","date_mod")) { |
| 846 |
$query = "ALTER TABLE `glpi_networking` ADD `date_mod` DATETIME DEFAULT NULL"; |
| 847 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 848 |
|
| 849 |
$query="ALTER TABLE `glpi_networking` ADD INDEX (`date_mod`)" ; |
| 850 |
$DB->query($query) or die("0.5 alter field date_mod ".$LANG["update"][90].$DB->error()); |
| 851 |
} |
| 852 |
|
| 853 |
// Ajout tech_num
|
| 854 |
if(!FieldExists("glpi_computers","tech_num")) { |
| 855 |
$query = "ALTER TABLE `glpi_computers` ADD `tech_num` int(11) NOT NULL default '0' AFTER `contact_num`"; |
| 856 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 857 |
|
| 858 |
$query="ALTER TABLE `glpi_computers` ADD INDEX (`tech_num`)" ; |
| 859 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 860 |
} |
| 861 |
// Ajout tech_num
|
| 862 |
if(!FieldExists("glpi_networking","tech_num")) { |
| 863 |
$query = "ALTER TABLE `glpi_networking` ADD `tech_num` int(11) NOT NULL default '0' AFTER `contact_num`"; |
| 864 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 865 |
|
| 866 |
$query="ALTER TABLE `glpi_networking` ADD INDEX (`tech_num`)" ; |
| 867 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 868 |
} |
| 869 |
// Ajout tech_num
|
| 870 |
if(!FieldExists("glpi_printers","tech_num")) { |
| 871 |
$query = "ALTER TABLE `glpi_printers` ADD `tech_num` int(11) NOT NULL default '0' AFTER `contact_num`"; |
| 872 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 873 |
|
| 874 |
$query="ALTER TABLE `glpi_printers` ADD INDEX (`tech_num`)" ; |
| 875 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 876 |
} |
| 877 |
|
| 878 |
// Ajout tech_num
|
| 879 |
if(!FieldExists("glpi_monitors","tech_num")) { |
| 880 |
$query = "ALTER TABLE `glpi_monitors` ADD `tech_num` int(11) NOT NULL default '0' AFTER `contact_num`"; |
| 881 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 882 |
|
| 883 |
$query="ALTER TABLE `glpi_monitors` ADD INDEX (`tech_num`)" ; |
| 884 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 885 |
} |
| 886 |
|
| 887 |
// Ajout tech_num
|
| 888 |
if(!FieldExists("glpi_software","tech_num")) { |
| 889 |
$query = "ALTER TABLE `glpi_software` ADD `tech_num` int(11) NOT NULL default '0' AFTER `location`"; |
| 890 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 891 |
|
| 892 |
$query="ALTER TABLE `glpi_software` ADD INDEX (`tech_num`)" ; |
| 893 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 894 |
} |
| 895 |
|
| 896 |
// Ajout tech_num
|
| 897 |
if(!FieldExists("glpi_peripherals","tech_num")) { |
| 898 |
$query = "ALTER TABLE `glpi_peripherals` ADD `tech_num` int(11) NOT NULL default '0' AFTER `contact_num`"; |
| 899 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 900 |
|
| 901 |
$query="ALTER TABLE `glpi_peripherals` ADD INDEX (`tech_num`)" ; |
| 902 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 903 |
} |
| 904 |
|
| 905 |
// Ajout tech_num
|
| 906 |
if(!FieldExists("glpi_software","tech_num")) { |
| 907 |
$query = "ALTER TABLE `glpi_software` ADD `tech_num` int(11) NOT NULL default '0'"; |
| 908 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 909 |
|
| 910 |
$query="ALTER TABLE `glpi_software` ADD INDEX (`tech_num`)" ; |
| 911 |
$DB->query($query) or die("0.5 alter field tech_num ".$LANG["update"][90].$DB->error()); |
| 912 |
} |
| 913 |
|
| 914 |
// Ajout tech_num
|
| 915 |
if(!TableExists("glpi_type_docs")) { |
| 916 |
|
| 917 |
$query = "CREATE TABLE glpi_type_docs ( |
| 918 |
ID int(11) NOT NULL auto_increment,
|
| 919 |
name varchar(255) NOT NULL default '',
|
| 920 |
ext varchar(10) NOT NULL default '',
|
| 921 |
icon varchar(255) NOT NULL default '',
|
| 922 |
mime varchar(100) NOT NULL default '',
|
| 923 |
upload enum('Y','N') NOT NULL default 'Y',
|
| 924 |
date_mod datetime default NULL,
|
| 925 |
PRIMARY KEY (ID),
|
| 926 |
UNIQUE KEY extension (ext),
|
| 927 |
KEY (upload)
|
| 928 |
) TYPE=MyISAM;";
|
| 929 |
|
| 930 |
$DB->query($query) or die("Error creating table typedoc ".$query." ".$DB->error()); |
| 931 |
|
| 932 |
|
| 933 |
|
| 934 |
$query = "INSERT INTO glpi_type_docs (ID, name, ext, icon, mime, upload, date_mod) VALUES (1, 'JPEG', 'jpg', 'jpg-dist.png', '', 'Y', '2004-12-13 19:47:21'), |
| 935 |
(2, 'PNG', 'png', 'png-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 936 |
(3, 'GIF', 'gif', 'gif-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 937 |
(4, 'BMP', 'bmp', 'bmp-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 938 |
(5, 'Photoshop', 'psd', 'psd-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 939 |
(6, 'TIFF', 'tif', 'tif-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 940 |
(7, 'AIFF', 'aiff', 'aiff-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 941 |
(8, 'Windows Media', 'asf', 'asf-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 942 |
(9, 'Windows Media', 'avi', 'avi-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 943 |
(44, 'C source', 'c', '', '', 'Y', '2004-12-13 19:47:22'),
|
| 944 |
(27, 'RealAudio', 'rm', 'rm-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 945 |
(16, 'Midi', 'mid', 'mid-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 946 |
(17, 'QuickTime', 'mov', 'mov-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 947 |
(18, 'MP3', 'mp3', 'mp3-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 948 |
(19, 'MPEG', 'mpg', 'mpg-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 949 |
(20, 'Ogg Vorbis', 'ogg', 'ogg-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 950 |
(24, 'QuickTime', 'qt', 'qt-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 951 |
(10, 'BZip', 'bz2', 'bz2-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 952 |
(25, 'RealAudio', 'ra', 'ra-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 953 |
(26, 'RealAudio', 'ram', 'ram-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 954 |
(11, 'Word', 'doc', 'doc-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 955 |
(12, 'DjVu', 'djvu', '', '', 'Y', '2004-12-13 19:47:21'),
|
| 956 |
(42, 'MNG', 'mng', '', '', 'Y', '2004-12-13 19:47:22'),
|
| 957 |
(13, 'PostScript', 'eps', 'ps-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 958 |
(14, 'GZ', 'gz', 'gz-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 959 |
(37, 'WAV', 'wav', 'wav-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 960 |
(15, 'HTML', 'html', 'html-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 961 |
(34, 'Flash', 'swf', '', '', 'Y', '2004-12-13 19:47:22'),
|
| 962 |
(21, 'PDF', 'pdf', 'pdf-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 963 |
(22, 'PowerPoint', 'ppt', 'ppt-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 964 |
(23, 'PostScript', 'ps', 'ps-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 965 |
(40, 'Windows Media', 'wmv', '', '', 'Y', '2004-12-13 19:47:22'),
|
| 966 |
(28, 'RTF', 'rtf', 'rtf-dist.png', '', 'Y', '2004-12-13 19:47:21'),
|
| 967 |
(29, 'StarOffice', 'sdd', 'sdd-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 968 |
(30, 'StarOffice', 'sdw', 'sdw-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 969 |
(31, 'Stuffit', 'sit', 'sit-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 970 |
(43, 'Adobe Illustrator', 'ai', 'ai-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 971 |
(32, 'OpenOffice Impress', 'sxi', 'sxi-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 972 |
(33, 'OpenOffice', 'sxw', 'sxw-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 973 |
(46, 'DVI', 'dvi', 'dvi-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 974 |
(35, 'TGZ', 'tgz', 'tgz-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 975 |
(36, 'texte', 'txt', 'txt-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 976 |
(49, 'RedHat/Mandrake/SuSE', 'rpm', 'rpm-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 977 |
(38, 'Excel', 'xls', 'xls-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 978 |
(39, 'XML', 'xml', 'xml-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 979 |
(41, 'Zip', 'zip', 'zip-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 980 |
(45, 'Debian', 'deb', 'deb-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 981 |
(47, 'C header', 'h', '', '', 'Y', '2004-12-13 19:47:22'),
|
| 982 |
(48, 'Pascal', 'pas', '', '', 'Y', '2004-12-13 19:47:22'),
|
| 983 |
(50, 'OpenOffice Calc', 'sxc', 'sxc-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 984 |
(51, 'LaTeX', 'tex', 'tex-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 985 |
(52, 'GIMP multi-layer', 'xcf', 'xcf-dist.png', '', 'Y', '2004-12-13 19:47:22'),
|
| 986 |
(53, 'JPEG', 'jpeg', 'jpg-dist.png', '', 'Y', '2005-03-07 22:23:17');";
|
| 987 |
|
| 988 |
|
| 989 |
|
| 990 |
|
| 991 |
|
| 992 |
|
| 993 |
$DB->query($query) or die("Error inserting elements in table typedoc ".$query." ".$DB->error()); |
| 994 |
|
| 995 |
} |
| 996 |
|
| 997 |
if(!TableExists("glpi_docs")) { |
| 998 |
|
| 999 |
$query = "CREATE TABLE glpi_docs ( |
| 1000 |
ID int(11) NOT NULL auto_increment,
|
| 1001 |
name varchar(255) NOT NULL default '',
|
| 1002 |
filename varchar(255) NOT NULL default '',
|
| 1003 |
rubrique int(11) NOT NULL default '0',
|
| 1004 |
mime varchar(30) NOT NULL default '',
|
| 1005 |
date_mod datetime NOT NULL default '0000-00-00 00:00:00',
|
| 1006 |
comment text NOT NULL,
|
| 1007 |
deleted enum('Y','N') NOT NULL default 'N',
|
| 1008 |
PRIMARY KEY (ID),
|
| 1009 |
KEY rubrique (rubrique),
|
| 1010 |
KEY deleted (deleted),
|
| 1011 |
KEY date_mod (date_mod)
|
| 1012 |
) TYPE=MyISAM;";
|
| 1013 |
|
| 1014 |
$DB->query($query) or die("Error creating table docs ".$query." ".$DB->error()); |
| 1015 |
} |
| 1016 |
|
| 1017 |
if(!TableExists("glpi_doc_device")) { |
| 1018 |
|
| 1019 |
$query = "CREATE TABLE glpi_doc_device ( |
| 1020 |
ID int(11) NOT NULL auto_increment,
|
| 1021 |
FK_doc int(11) NOT NULL default '0',
|
| 1022 |
FK_device int(11) NOT NULL default '0',
|
| 1023 |
device_type tinyint(4) NOT NULL default '0',
|
| 1024 |
PRIMARY KEY (ID),
|
| 1025 |
UNIQUE KEY FK_doc (FK_doc,FK_device,device_type),
|
| 1026 |
KEY FK_doc_2 (FK_doc),
|
| 1027 |
KEY FK_device (FK_device,device_type)
|
| 1028 |
) TYPE=MyISAM;";
|
| 1029 |
|
| 1030 |
$DB->query($query) or die("Error creating table docs ".$query." ".$DB->error()); |
| 1031 |
} |
| 1032 |
|
| 1033 |
if(!TableExists("glpi_dropdown_rubdocs")) { |
| 1034 |
|
| 1035 |
$query = "CREATE TABLE glpi_dropdown_rubdocs ( |
| 1036 |
ID int(11) NOT NULL auto_increment,
|
| 1037 |
name varchar(255) default NULL,
|
| 1038 |
PRIMARY KEY (ID)
|
| 1039 |
) TYPE=MyISAM;";
|
| 1040 |
$DB->query($query) or die("Error creating table docs ".$query." ".$DB->error()); |
| 1041 |
} |
| 1042 |
|
| 1043 |
if(!isIndex("glpi_contacts", "deleted")) { |
| 1044 |
$query = "ALTER TABLE `glpi_contacts` ADD INDEX `deleted` (`deleted`) "; |
| 1045 |
$DB->query($query) or die("0.5 alter field deleted".$LANG["update"][90].$DB->error()); |
| 1046 |
} |
| 1047 |
|
| 1048 |
if(!isIndex("glpi_contacts", "type")) { |
| 1049 |
$query = "ALTER TABLE `glpi_contacts` ADD INDEX `type` (`type`) "; |
| 1050 |
$DB->query($query) or die("0.5 alter field type ".$LANG["update"][90].$DB->error()); |
| 1051 |
} |
| 1052 |
|
| 1053 |
if(!isIndex("glpi_event_log", "itemtype")) { |
| 1054 |
$query = "ALTER TABLE `glpi_event_log` ADD INDEX (`itemtype`) "; |
| 1055 |
$DB->query($query) or die("0.5 alter field itemtype ".$LANG["update"][90].$DB->error()); |
| 1056 |
} |
| 1057 |
|
| 1058 |
if(!isIndex("glpi_followups", "date")) { |
| 1059 |
$query = "ALTER TABLE `glpi_followups` ADD INDEX (`date`) "; |
| 1060 |
$DB->query($query) or die("0.5 alter field date ".$LANG["update"][90].$DB->error()); |
| 1061 |
} |
| 1062 |
|
| 1063 |
if(!isIndex("glpi_tracking", "category")) { |
| 1064 |
$query = "ALTER TABLE `glpi_tracking` ADD INDEX (`category`) "; |
| 1065 |
$DB->query($query) or die("0.5 alter field category ".$LANG["update"][90].$DB->error()); |
| 1066 |
} |
| 1067 |
|
| 1068 |
if(!FieldExists("glpi_config","date_fiscale")) { |
| 1069 |
$query = "ALTER TABLE `glpi_config` ADD `date_fiscale` date NOT NULL default '2005-12-31'"; |
| 1070 |
$DB->query($query) or die("0.5 add field date_fiscale ".$LANG["update"][90].$DB->error()); |
| 1071 |
} |
| 1072 |
|
| 1073 |
if(!FieldExists("glpi_networking","ifmac")) { |
| 1074 |
$query = "ALTER TABLE `glpi_networking` ADD `ifmac` char(30) NOT NULL default ''"; |
| 1075 |
$DB->query($query) or die("0.5 add field ifmac ".$LANG["update"][90].$DB->error()); |
| 1076 |
} |
| 1077 |
|
| 1078 |
if(!FieldExists("glpi_networking","ifaddr")) { |
| 1079 |
$query = "ALTER TABLE `glpi_networking` ADD `ifaddr` char(30) NOT NULL default ''"; |
| 1080 |
$DB->query($query) or die("0.5 add field ifaddr ".$LANG["update"][90].$DB->error()); |
| 1081 |
} |
| 1082 |
|
| 1083 |
if(!TableExists("glpi_repair_item")) { |
| 1084 |
|
| 1085 |
$query = "CREATE TABLE glpi_repair_item ( |
| 1086 |
ID int(11) NOT NULL auto_increment,
|
| 1087 |
device_type tinyint(4) NOT NULL default '0',
|
| 1088 |
id_device int(11) NOT NULL default '0',
|
| 1089 |
PRIMARY KEY (ID),
|
| 1090 |
KEY device_type (device_type),
|
| 1091 |
KEY device_type_2 (device_type,id_device)
|
| 1092 |
)TYPE=MyISAM;";
|
| 1093 |
|
| 1094 |
$DB->query($query) or die("0.5 create glpirepair_item table ".$LANG["update"][90].$DB->error()); |
| 1095 |
} |
| 1096 |
|
| 1097 |
if(TableExists("glpi_prefs")&&!FieldExists("glpi_prefs","username")) { |
| 1098 |
|
| 1099 |
if(isIndex("glpi_prefs", "user")) { |
| 1100 |
$query = " ALTER TABLE `glpi_prefs` DROP INDEX `user`;"; |
| 1101 |
$DB->query($query) or die("0.5 drop key user ".$LANG["update"][90].$DB->error()); |
| 1102 |
} |
| 1103 |
|
| 1104 |
$query = " ALTER TABLE `glpi_prefs` CHANGE `user` `username` VARCHAR(80) NOT NULL;"; |
| 1105 |
$DB->query($query) or die("0.5 change user to username ".$LANG["update"][90].$DB->error()); |
| 1106 |
$query = "ALTER TABLE `glpi_prefs` ADD UNIQUE (`username`) "; |
| 1107 |
$DB->query($query) or die("0.5 alter field username ".$LANG["update"][90].$DB->error()); |
| 1108 |
} |
| 1109 |
|
| 1110 |
//Mise a jour 0.5 verification des prefs pour chaque user.
|
| 1111 |
if (TableExists("glpi_prefs")){ |
| 1112 |
$query = "select ID, name from glpi_users"; |
| 1113 |
$query2 = "select ID, username from glpi_prefs"; |
| 1114 |
$result = $DB->query($query); |
| 1115 |
$result2 = $DB->query($query2); |
| 1116 |
if($DB->numrows($result) != $DB->numrows($result2)) { |
| 1117 |
$users = array(); |
| 1118 |
$i = 0; |
| 1119 |
while ($line = $DB->fetch_array($result2)) { |
| 1120 |
$prefs[$i] = $line["username"]; |
| 1121 |
$i++;
|
| 1122 |
} |
| 1123 |
while($line = $DB->fetch_array($result)) { |
| 1124 |
if(!in_array($line["name"],$prefs)) { |
| 1125 |
$query_insert = "INSERT INTO `glpi_prefs` (`username` , `tracking_order` , `language`) VALUES ('".$line["name"]."', 'no', 'english')"; |
| 1126 |
$DB->query($query_insert) or die("glpi maj prefs ".$LANG["update"][90].$DB->error()); |
| 1127 |
} |
| 1128 |
} |
| 1129 |
} |
| 1130 |
$DB->free_result($result); |
| 1131 |
$DB->free_result($result2); |
| 1132 |
} |
| 1133 |
|
| 1134 |
|
| 1135 |
} |
| 1136 |
/// Update to 0.5 : date difference used for update
|
| 1137 |
function date_diff($from, $to) { |
| 1138 |
$from=strtotime($from); |
| 1139 |
$to=strtotime($to); |
| 1140 |
if ($from > $to) { |
| 1141 |
$t = $to; |
| 1142 |
$to = $from; |
| 1143 |
$from = $t; |
| 1144 |
} |
| 1145 |
|
| 1146 |
$year1 = date("Y", $from); |
| 1147 |
$year2 = date("Y", $to); |
| 1148 |
$month1 = date("n", $from); |
| 1149 |
$month2 = date("n", $to); |
| 1150 |
|
| 1151 |
if ($month2 < $month1) { |
| 1152 |
$month2 += 12; |
| 1153 |
$year2 --;
|
| 1154 |
} |
| 1155 |
$months = $month2 - $month1; |
| 1156 |
$years = $year2 - $year1; |
| 1157 |
return (12*$years+$months); |
| 1158 |
} |
| 1159 |
|
| 1160 |
/** Update to 0.5 : Update maintenance informations
|
| 1161 |
* @param $table table name
|
| 1162 |
* @param $type item type
|
| 1163 |
* @param $ID item ID
|
| 1164 |
*/
|
| 1165 |
function updateMaintenanceInfos($table,$type,$ID){ |
| 1166 |
global $DB,$LANG; |
| 1167 |
$elements=array(); |
| 1168 |
$query="SELECT ID from $table WHERE maintenance='1'"; |
| 1169 |
$result=$DB->query($query); |
| 1170 |
while ($data=$DB->fetch_array($result)){ |
| 1171 |
$query_insert="INSERT INTO glpi_contract_device (FK_contract,FK_device,device_type) VALUES ('$ID','".$data["ID"]."','$type')"; |
| 1172 |
$result_insert=$DB->query($query_insert) or die("0.5 insert for update maintenance ".$LANG["update"][90].$DB->error()); |
| 1173 |
} |
| 1174 |
$DB->free_result($result); |
| 1175 |
|
| 1176 |
$query_drop = "ALTER TABLE `$table` DROP `maintenance`"; |
| 1177 |
$result_drop=$DB->query($query_drop) or die("0.5 drop for update maintenance ".$LANG["update"][90].$DB->error()); |
| 1178 |
|
| 1179 |
} |
| 1180 |
|
| 1181 |
/** Update to 0.5 : Update warranty informations
|
| 1182 |
* @param $table table name
|
| 1183 |
* @param $type item type
|
| 1184 |
*/
|
| 1185 |
function updateWarrantyInfos($table,$type){ |
| 1186 |
global $DB,$LANG; |
| 1187 |
$elements=array(); |
| 1188 |
$query="SELECT ID,achat_date,date_fin_garantie from $table ORDER BY achat_date,date_fin_garantie"; |
| 1189 |
$result=$DB->query($query) or die("0.5 select for update warranty ".$LANG["update"][90].$DB->error()); |
| 1190 |
while ($data=$DB->fetch_array($result)){ |
| 1191 |
if (($data['achat_date']!="0000-00-00"&&!empty($data['achat_date']))||($data['date_fin_garantie']!="0000-00-00"&&!empty($data['date_fin_garantie']))){ |
| 1192 |
$IDitem=$data['ID']; |
| 1193 |
if ($data['achat_date']=="0000-00-00"&&!empty($data['achat_date'])) $achat_date=date("Y-m-d"); |
| 1194 |
else $achat_date=$data['achat_date']; |
| 1195 |
$duration=0; |
| 1196 |
if ($data['date_fin_garantie']!="0000-00-00"&&!empty($data['date_fin_garantie'])) |
| 1197 |
$duration=round(date_diff($achat_date,$data['date_fin_garantie']),2); |
| 1198 |
$query_insert="INSERT INTO glpi_infocoms (device_type,FK_device,buy_date,warranty_duration) VALUES ('$type','$IDitem','".$achat_date."','$duration')"; |
| 1199 |
$result_insert=$DB->query($query_insert) or die("0.5 insert for update warranty ".$LANG["update"][90].$DB->error()); |
| 1200 |
} |
| 1201 |
} |
| 1202 |
$DB->free_result($result); |
| 1203 |
|
| 1204 |
$query_drop = "ALTER TABLE `$table` DROP `achat_date`"; |
| 1205 |
$result_drop=$DB->query($query_drop) or die("0.5 drop1 for update warranty ".$LANG["update"][90].$DB->error()); |
| 1206 |
$query_drop = "ALTER TABLE `$table` DROP `date_fin_garantie`"; |
| 1207 |
$result_drop=$DB->query($query_drop) or die("0.5 drop2 for update warranty ".$LANG["update"][90].$DB->error()); |
| 1208 |
|
| 1209 |
} |
| 1210 |
/// Update to 0.5 :Is maintenance used ?
|
| 1211 |
function isMaintenanceUsed(){ |
| 1212 |
global $DB,$LANG; |
| 1213 |
$tables=array("glpi_computers","glpi_printers","glpi_monitors","glpi_peripherals","glpi_networking"); |
| 1214 |
foreach ($tables as $key => $table){ |
| 1215 |
$query="SELECT ID from $table WHERE maintenance='1';"; |
| 1216 |
$result=$DB->query($query) or die("0.5 find for update maintenance ".$LANG["update"][90].$DB->error()); |
| 1217 |
if ($DB->numrows($result)>0) return true; |
| 1218 |
} |
| 1219 |
return false; |
| 1220 |
|
| 1221 |
} |
| 1222 |
|
| 1223 |
/// Update to 0.5 :drop maintenance field ?
|
| 1224 |
function dropMaintenanceField(){ |
| 1225 |
global $DB,$LANG; |
| 1226 |
$tables=array("glpi_computers","glpi_printers","glpi_monitors","glpi_peripherals","glpi_networking"); |
| 1227 |
foreach ($tables as $key => $table){ |
| 1228 |
$query="ALTER TABLE `$table` DROP `maintenance`"; |
| 1229 |
$result=$DB->query($query) or die("0.5 alter for update maintenance ".$LANG["update"][90].$DB->error()); |
| 1230 |
} |
| 1231 |
} |
| 1232 |
|
| 1233 |
/**
|
| 1234 |
* Update to 0.5 : Get data from old dropdowns to new devices
|
| 1235 |
*
|
| 1236 |
* This function assure to keep clean data and integrity, during the change from
|
| 1237 |
* computers-dropdown to computers devices. Then delete the unused old elements.
|
| 1238 |
*
|
| 1239 |
* @param $devtype integer the devtype number
|
| 1240 |
* @param $devname string the device table name (end of the name (glpi_device_thisparam))
|
| 1241 |
* @param $dpdname string the dropdown table name (end of the name (glpi_dropdown_thisparam))
|
| 1242 |
* @param $compDpdName string the name of the dropdown foreign key on glpi_computers (eg : hdtype, processor)
|
| 1243 |
* @param $specif string the name of the dropdown value entry on glpi_computer (eg : hdspace, processor_speed) optionnal argument.
|
| 1244 |
* @returns nothing if everything is good, else display mysql query and error.
|
| 1245 |
*/
|
| 1246 |
function compDpd2Device($devtype,$devname,$dpdname,$compDpdName,$specif='') { |
| 1247 |
global $DB,$LANG; |
| 1248 |
$query = "select * from glpi_dropdown_".$dpdname.""; |
| 1249 |
|
| 1250 |
$result = $DB->query($query); |
| 1251 |
while($lndropd = $DB->fetch_array($result)) { |
| 1252 |
$query2 = "insert into glpi_device_".$devname." (designation) values ('".addslashes($lndropd["name"])."')"; |
| 1253 |
$DB->query($query2) or die("unable to transfer ".$dpdname." to ".$devname." ".$LANG["update"][90].$DB->error()); |
| 1254 |
$devid = $DB->insert_id(); |
| 1255 |
$query3 = "select * from glpi_computers where ".$compDpdName." = '".$lndropd["ID"]."'"; |
| 1256 |
$result3 = $DB->query($query3); |
| 1257 |
while($lncomp = $DB->fetch_array($result3)) { |
| 1258 |
$query4 = "insert into glpi_computer_device (device_type, FK_device, FK_computers) values ('$devtype','".$devid."','".$lncomp["ID"]."')"; |
| 1259 |
if(!empty($specif)) { |
| 1260 |
$queryspecif = "SELECT ".$specif." FROM glpi_computers WHERE ID = '".$lncomp["ID"]."'"; |
| 1261 |
if($resultspecif = $DB->query($queryspecif)) { |
| 1262 |
$query4 = "insert into glpi_computer_device (specificity, device_type, FK_device, FK_computers) values ('".$DB->result($resultspecif,0,$specif)."','$devtype','".$devid."','".$lncomp["ID"]."')"; |
| 1263 |
} |
| 1264 |
|
| 1265 |
} |
| 1266 |
$DB->query($query4) or die("unable to migrate from ".$dpdname." to ".$devname." for item computer:".$lncomp["ID"]." ".$LANG["update"][90].$DB->error()); |
| 1267 |
} |
| 1268 |
} |
| 1269 |
$DB->free_result($result); |
| 1270 |
//Delete unused elements (dropdown on the computer table, dropdown table and specif)
|
| 1271 |
$query = "ALTER TABLE glpi_computers drop `".$compDpdName."`"; |
| 1272 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 1273 |
$query = "DROP TABLE `glpi_dropdown_".$dpdname."`"; |
| 1274 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 1275 |
if(!empty($specif)) { |
| 1276 |
$query = "ALTER TABLE glpi_computers drop `".$specif."`"; |
| 1277 |
$DB->query($query) or die("Error : ".$query." ".$DB->error()); |
| 1278 |
} |
| 1279 |
} |
| 1280 |
|
| 1281 |
|
| 1282 |
?>
|