ryxeo-glpi-git / htdocs / install / mysql / glpi-0.71.3-empty.sql @ 1c14bcc4
Historique | Voir | Annoter | Télécharger (120 ko)
| 1 |
#GLPI Dump database on 2008-10-28 22:19
|
|---|---|
| 2 |
|
| 3 |
### Dump table glpi_alerts
|
| 4 |
|
| 5 |
DROP TABLE IF EXISTS `glpi_alerts`; |
| 6 |
CREATE TABLE `glpi_alerts` ( |
| 7 |
`ID` int(11) NOT NULL auto_increment, |
| 8 |
`device_type` int(11) NOT NULL default '0', |
| 9 |
`FK_device` int(11) NOT NULL default '0', |
| 10 |
`type` int(11) NOT NULL default '0', |
| 11 |
`date` timestamp NOT NULL default CURRENT_TIMESTAMP, |
| 12 |
PRIMARY KEY (`ID`), |
| 13 |
UNIQUE KEY `alert` (`device_type`,`FK_device`,`type`), |
| 14 |
KEY `item` (`device_type`,`FK_device`), |
| 15 |
KEY `device_type` (`device_type`), |
| 16 |
KEY `FK_device` (`FK_device`), |
| 17 |
KEY `type` (`type`), |
| 18 |
KEY `date` (`date`) |
| 19 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 20 |
|
| 21 |
|
| 22 |
### Dump table glpi_auth_ldap
|
| 23 |
|
| 24 |
DROP TABLE IF EXISTS `glpi_auth_ldap`; |
| 25 |
CREATE TABLE `glpi_auth_ldap` ( |
| 26 |
`ID` int(11) NOT NULL auto_increment, |
| 27 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 28 |
`ldap_host` varchar(255) collate utf8_unicode_ci default NULL, |
| 29 |
`ldap_basedn` varchar(255) collate utf8_unicode_ci default NULL, |
| 30 |
`ldap_rootdn` varchar(255) collate utf8_unicode_ci default NULL, |
| 31 |
`ldap_pass` varchar(255) collate utf8_unicode_ci default NULL, |
| 32 |
`ldap_port` varchar(255) collate utf8_unicode_ci default '389', |
| 33 |
`ldap_condition` text collate utf8_unicode_ci, |
| 34 |
`ldap_login` varchar(255) collate utf8_unicode_ci default 'uid', |
| 35 |
`ldap_use_tls` varchar(255) collate utf8_unicode_ci default NULL, |
| 36 |
`ldap_field_group` varchar(255) collate utf8_unicode_ci default NULL, |
| 37 |
`ldap_group_condition` varchar(255) collate utf8_unicode_ci default NULL, |
| 38 |
`ldap_search_for_groups` int(11) NOT NULL default '0', |
| 39 |
`ldap_field_group_member` varchar(255) collate utf8_unicode_ci default NULL, |
| 40 |
`ldap_field_email` varchar(255) collate utf8_unicode_ci default NULL, |
| 41 |
`ldap_field_realname` varchar(255) collate utf8_unicode_ci default NULL, |
| 42 |
`ldap_field_firstname` varchar(255) collate utf8_unicode_ci default NULL, |
| 43 |
`ldap_field_phone` varchar(255) collate utf8_unicode_ci default NULL, |
| 44 |
`ldap_field_phone2` varchar(255) collate utf8_unicode_ci default NULL, |
| 45 |
`ldap_field_mobile` varchar(255) collate utf8_unicode_ci default NULL, |
| 46 |
`ldap_field_comments` text collate utf8_unicode_ci, |
| 47 |
`use_dn` int(1) NOT NULL default '1', |
| 48 |
`timezone` varchar(255) collate utf8_unicode_ci default NULL, |
| 49 |
`ldap_opt_deref` int(1) NOT NULL default '0', |
| 50 |
PRIMARY KEY (`ID`) |
| 51 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 52 |
|
| 53 |
|
| 54 |
### Dump table glpi_auth_ldap_replicate
|
| 55 |
|
| 56 |
DROP TABLE IF EXISTS `glpi_auth_ldap_replicate`; |
| 57 |
CREATE TABLE `glpi_auth_ldap_replicate` ( |
| 58 |
`ID` int(11) NOT NULL auto_increment, |
| 59 |
`server_id` int(11) NOT NULL default '0', |
| 60 |
`ldap_host` varchar(255) collate utf8_unicode_ci default NULL, |
| 61 |
`ldap_port` int(11) NOT NULL default '389', |
| 62 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 63 |
PRIMARY KEY (`ID`) |
| 64 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 65 |
|
| 66 |
|
| 67 |
### Dump table glpi_auth_mail
|
| 68 |
|
| 69 |
DROP TABLE IF EXISTS `glpi_auth_mail`; |
| 70 |
CREATE TABLE `glpi_auth_mail` ( |
| 71 |
`ID` int(11) NOT NULL auto_increment, |
| 72 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 73 |
`imap_auth_server` varchar(255) collate utf8_unicode_ci default NULL, |
| 74 |
`imap_host` varchar(255) collate utf8_unicode_ci default NULL, |
| 75 |
PRIMARY KEY (`ID`) |
| 76 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 77 |
|
| 78 |
|
| 79 |
### Dump table glpi_bookmark
|
| 80 |
|
| 81 |
DROP TABLE IF EXISTS `glpi_bookmark`; |
| 82 |
CREATE TABLE `glpi_bookmark` ( |
| 83 |
`ID` int(11) NOT NULL auto_increment, |
| 84 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 85 |
`type` int(11) NOT NULL default '0', |
| 86 |
`device_type` int(11) NOT NULL default '0', |
| 87 |
`FK_users` int(11) NOT NULL default '0', |
| 88 |
`private` smallint(6) NOT NULL default '1', |
| 89 |
`FK_entities` int(11) NOT NULL default '-1', |
| 90 |
`recursive` smallint(6) NOT NULL default '0', |
| 91 |
`path` varchar(255) collate utf8_unicode_ci default NULL, |
| 92 |
`query` text collate utf8_unicode_ci, |
| 93 |
PRIMARY KEY (`ID`), |
| 94 |
KEY `FK_users` (`FK_users`), |
| 95 |
KEY `private` (`private`), |
| 96 |
KEY `device_type` (`device_type`), |
| 97 |
KEY `recursive` (`recursive`), |
| 98 |
KEY `FK_entities` (`FK_entities`), |
| 99 |
KEY `type` (`type`) |
| 100 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 101 |
|
| 102 |
|
| 103 |
### Dump table glpi_cartridges
|
| 104 |
|
| 105 |
DROP TABLE IF EXISTS `glpi_cartridges`; |
| 106 |
CREATE TABLE `glpi_cartridges` ( |
| 107 |
`ID` int(11) NOT NULL auto_increment, |
| 108 |
`FK_glpi_cartridges_type` int(11) NOT NULL default '0', |
| 109 |
`FK_glpi_printers` int(11) NOT NULL default '0', |
| 110 |
`date_in` date default NULL, |
| 111 |
`date_use` date default NULL, |
| 112 |
`date_out` date default NULL, |
| 113 |
`pages` int(11) NOT NULL default '0', |
| 114 |
PRIMARY KEY (`ID`), |
| 115 |
KEY `FK_glpi_cartridges_type` (`FK_glpi_cartridges_type`), |
| 116 |
KEY `FK_glpi_printers` (`FK_glpi_printers`) |
| 117 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 118 |
|
| 119 |
|
| 120 |
### Dump table glpi_cartridges_assoc
|
| 121 |
|
| 122 |
DROP TABLE IF EXISTS `glpi_cartridges_assoc`; |
| 123 |
CREATE TABLE `glpi_cartridges_assoc` ( |
| 124 |
`ID` int(11) NOT NULL auto_increment, |
| 125 |
`FK_glpi_cartridges_type` int(11) NOT NULL default '0', |
| 126 |
`FK_glpi_dropdown_model_printers` int(11) NOT NULL default '0', |
| 127 |
PRIMARY KEY (`ID`), |
| 128 |
UNIQUE KEY `FK_glpi_type_printer` (`FK_glpi_dropdown_model_printers`,`FK_glpi_cartridges_type`), |
| 129 |
KEY `FK_glpi_cartridges_type` (`FK_glpi_cartridges_type`), |
| 130 |
KEY `FK_glpi_type_printer_2` (`FK_glpi_dropdown_model_printers`) |
| 131 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 132 |
|
| 133 |
|
| 134 |
### Dump table glpi_cartridges_type
|
| 135 |
|
| 136 |
DROP TABLE IF EXISTS `glpi_cartridges_type`; |
| 137 |
CREATE TABLE `glpi_cartridges_type` ( |
| 138 |
`ID` int(11) NOT NULL auto_increment, |
| 139 |
`FK_entities` int(11) NOT NULL default '0', |
| 140 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 141 |
`ref` varchar(255) collate utf8_unicode_ci default NULL, |
| 142 |
`location` int(11) NOT NULL default '0', |
| 143 |
`type` int(11) NOT NULL default '0', |
| 144 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 145 |
`tech_num` int(11) NOT NULL default '0', |
| 146 |
`deleted` smallint(6) NOT NULL default '0', |
| 147 |
`comments` text collate utf8_unicode_ci, |
| 148 |
`alarm` smallint(6) NOT NULL default '10', |
| 149 |
`notes` longtext collate utf8_unicode_ci, |
| 150 |
PRIMARY KEY (`ID`), |
| 151 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 152 |
KEY `tech_num` (`tech_num`), |
| 153 |
KEY `name` (`name`), |
| 154 |
KEY `location` (`location`), |
| 155 |
KEY `type` (`type`), |
| 156 |
KEY `alarm` (`alarm`), |
| 157 |
KEY `FK_entities` (`FK_entities`), |
| 158 |
KEY `deleted` (`deleted`) |
| 159 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 160 |
|
| 161 |
|
| 162 |
### Dump table glpi_computer_device
|
| 163 |
|
| 164 |
DROP TABLE IF EXISTS `glpi_computer_device`; |
| 165 |
CREATE TABLE `glpi_computer_device` ( |
| 166 |
`ID` int(11) NOT NULL auto_increment, |
| 167 |
`specificity` varchar(255) collate utf8_unicode_ci default NULL, |
| 168 |
`device_type` smallint(6) NOT NULL default '0', |
| 169 |
`FK_device` int(11) NOT NULL default '0', |
| 170 |
`FK_computers` int(11) NOT NULL default '0', |
| 171 |
PRIMARY KEY (`ID`), |
| 172 |
KEY `device_type` (`device_type`), |
| 173 |
KEY `device_type_2` (`device_type`,`FK_device`), |
| 174 |
KEY `FK_computers` (`FK_computers`), |
| 175 |
KEY `FK_device` (`FK_device`), |
| 176 |
KEY `specificity` (`specificity`) |
| 177 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 178 |
|
| 179 |
|
| 180 |
### Dump table glpi_computers
|
| 181 |
|
| 182 |
DROP TABLE IF EXISTS `glpi_computers`; |
| 183 |
CREATE TABLE `glpi_computers` ( |
| 184 |
`ID` int(11) NOT NULL auto_increment, |
| 185 |
`FK_entities` int(11) NOT NULL default '0', |
| 186 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 187 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 188 |
`otherserial` varchar(255) collate utf8_unicode_ci default NULL, |
| 189 |
`contact` varchar(255) collate utf8_unicode_ci default NULL, |
| 190 |
`contact_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 191 |
`tech_num` int(11) NOT NULL default '0', |
| 192 |
`comments` text collate utf8_unicode_ci, |
| 193 |
`date_mod` datetime default NULL, |
| 194 |
`os` int(11) NOT NULL default '0', |
| 195 |
`os_version` int(11) NOT NULL default '0', |
| 196 |
`os_sp` int(11) NOT NULL default '0', |
| 197 |
`os_license_number` varchar(255) collate utf8_unicode_ci default NULL, |
| 198 |
`os_license_id` varchar(255) collate utf8_unicode_ci default NULL, |
| 199 |
`auto_update` int(11) NOT NULL default '0', |
| 200 |
`location` int(11) NOT NULL default '0', |
| 201 |
`domain` int(11) NOT NULL default '0', |
| 202 |
`network` int(11) NOT NULL default '0', |
| 203 |
`model` int(11) NOT NULL default '0', |
| 204 |
`type` int(11) NOT NULL default '0', |
| 205 |
`is_template` smallint(6) NOT NULL default '0', |
| 206 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 207 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 208 |
`deleted` smallint(6) NOT NULL default '0', |
| 209 |
`notes` longtext collate utf8_unicode_ci, |
| 210 |
`ocs_import` smallint(6) NOT NULL default '0', |
| 211 |
`FK_users` int(11) NOT NULL default '0', |
| 212 |
`FK_groups` int(11) NOT NULL default '0', |
| 213 |
`state` int(11) NOT NULL default '0', |
| 214 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 215 |
PRIMARY KEY (`ID`), |
| 216 |
KEY `location` (`location`), |
| 217 |
KEY `os` (`os`), |
| 218 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 219 |
KEY `date_mod` (`date_mod`), |
| 220 |
KEY `tech_num` (`tech_num`), |
| 221 |
KEY `name` (`name`), |
| 222 |
KEY `type` (`type`), |
| 223 |
KEY `model` (`model`), |
| 224 |
KEY `FK_groups` (`FK_groups`), |
| 225 |
KEY `FK_users` (`FK_users`), |
| 226 |
KEY `os_sp` (`os_sp`), |
| 227 |
KEY `os_version` (`os_version`), |
| 228 |
KEY `network` (`network`), |
| 229 |
KEY `domain` (`domain`), |
| 230 |
KEY `auto_update` (`auto_update`), |
| 231 |
KEY `ocs_import` (`ocs_import`), |
| 232 |
KEY `FK_entities` (`FK_entities`), |
| 233 |
KEY `is_template` (`is_template`), |
| 234 |
KEY `deleted` (`deleted`) |
| 235 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 236 |
|
| 237 |
|
| 238 |
### Dump table glpi_config
|
| 239 |
|
| 240 |
DROP TABLE IF EXISTS `glpi_config`; |
| 241 |
CREATE TABLE `glpi_config` ( |
| 242 |
`ID` int(11) NOT NULL auto_increment, |
| 243 |
`num_of_events` varchar(255) collate utf8_unicode_ci default NULL, |
| 244 |
`jobs_at_login` varchar(255) collate utf8_unicode_ci default NULL, |
| 245 |
`sendexpire` varchar(255) collate utf8_unicode_ci default NULL, |
| 246 |
`cut` varchar(255) collate utf8_unicode_ci default NULL, |
| 247 |
`expire_events` varchar(255) collate utf8_unicode_ci default NULL, |
| 248 |
`list_limit` int(11) default '20', |
| 249 |
`list_limit_max` int(11) NOT NULL default '50', |
| 250 |
`version` varchar(255) collate utf8_unicode_ci default NULL, |
| 251 |
`logotxt` varchar(255) collate utf8_unicode_ci default NULL, |
| 252 |
`event_loglevel` varchar(255) collate utf8_unicode_ci default NULL, |
| 253 |
`mailing` varchar(255) collate utf8_unicode_ci default NULL, |
| 254 |
`admin_email` varchar(255) collate utf8_unicode_ci default NULL, |
| 255 |
`admin_reply` varchar(255) collate utf8_unicode_ci default NULL, |
| 256 |
`mailing_signature` text collate utf8_unicode_ci, |
| 257 |
`permit_helpdesk` varchar(255) collate utf8_unicode_ci default NULL, |
| 258 |
`default_language` varchar(255) collate utf8_unicode_ci default 'en_GB', |
| 259 |
`priority_1` varchar(255) collate utf8_unicode_ci default '#fff2f2', |
| 260 |
`priority_2` varchar(255) collate utf8_unicode_ci default '#ffe0e0', |
| 261 |
`priority_3` varchar(255) collate utf8_unicode_ci default '#ffcece', |
| 262 |
`priority_4` varchar(255) collate utf8_unicode_ci default '#ffbfbf', |
| 263 |
`priority_5` varchar(255) collate utf8_unicode_ci default '#ffadad', |
| 264 |
`date_fiscale` date NOT NULL default '2005-12-31', |
| 265 |
`cartridges_alarm` int(11) NOT NULL default '10', |
| 266 |
`cas_host` varchar(255) collate utf8_unicode_ci default NULL, |
| 267 |
`cas_port` varchar(255) collate utf8_unicode_ci default NULL, |
| 268 |
`cas_uri` varchar(255) collate utf8_unicode_ci default NULL, |
| 269 |
`cas_logout` varchar(255) collate utf8_unicode_ci default NULL, |
| 270 |
`extra_ldap_server` int(11) NOT NULL default '1', |
| 271 |
`existing_auth_server_field` varchar(255) collate utf8_unicode_ci default NULL, |
| 272 |
`planning_begin` time NOT NULL default '08:00:00', |
| 273 |
`planning_end` time NOT NULL default '20:00:00', |
| 274 |
`utf8_conv` int(11) NOT NULL default '0', |
| 275 |
`auto_assign` smallint(6) NOT NULL default '0', |
| 276 |
`public_faq` smallint(6) NOT NULL default '0', |
| 277 |
`url_base` varchar(255) collate utf8_unicode_ci default NULL, |
| 278 |
`url_in_mail` smallint(6) NOT NULL default '0', |
| 279 |
`text_login` text collate utf8_unicode_ci, |
| 280 |
`auto_update_check` smallint(6) NOT NULL default '0', |
| 281 |
`founded_new_version` varchar(255) collate utf8_unicode_ci default NULL, |
| 282 |
`dropdown_max` int(11) NOT NULL default '100', |
| 283 |
`ajax_wildcard` char(1) collate utf8_unicode_ci default '*', |
| 284 |
`use_ajax` smallint(6) NOT NULL default '0', |
| 285 |
`ajax_limit_count` int(11) NOT NULL default '50', |
| 286 |
`ajax_autocompletion` smallint(6) NOT NULL default '1', |
| 287 |
`auto_add_users` smallint(6) NOT NULL default '1', |
| 288 |
`dateformat` smallint(6) NOT NULL default '0', |
| 289 |
`numberformat` smallint(6) NOT NULL default '0', |
| 290 |
`nextprev_item` varchar(255) collate utf8_unicode_ci default 'name', |
| 291 |
`view_ID` smallint(6) NOT NULL default '0', |
| 292 |
`dropdown_limit` int(11) NOT NULL default '50', |
| 293 |
`ocs_mode` smallint(6) NOT NULL default '0', |
| 294 |
`debug` int(2) NOT NULL default '0', |
| 295 |
`use_cache` smallint(6) NOT NULL default '1', |
| 296 |
`smtp_mode` smallint(6) NOT NULL default '0', |
| 297 |
`smtp_host` varchar(255) collate utf8_unicode_ci default NULL, |
| 298 |
`smtp_port` int(11) NOT NULL default '25', |
| 299 |
`smtp_username` varchar(255) collate utf8_unicode_ci default NULL, |
| 300 |
`smtp_password` varchar(255) collate utf8_unicode_ci default NULL, |
| 301 |
`proxy_name` varchar(255) collate utf8_unicode_ci default NULL, |
| 302 |
`proxy_port` varchar(255) collate utf8_unicode_ci default '8080', |
| 303 |
`proxy_user` varchar(255) collate utf8_unicode_ci default NULL, |
| 304 |
`proxy_password` varchar(255) collate utf8_unicode_ci default NULL, |
| 305 |
`followup_on_update_ticket` smallint(6) NOT NULL default '1', |
| 306 |
`contract_alerts` smallint(6) NOT NULL default '0', |
| 307 |
`infocom_alerts` smallint(6) NOT NULL default '0', |
| 308 |
`licenses_alert` smallint(6) NOT NULL default '0', |
| 309 |
`cartridges_alert` int(11) NOT NULL default '0', |
| 310 |
`consumables_alert` int(11) NOT NULL default '0', |
| 311 |
`keep_tracking_on_delete` int(11) default '1', |
| 312 |
`show_admin_doc` int(11) default '0', |
| 313 |
`time_step` int(11) default '5', |
| 314 |
`decimal_number` int(11) default '2', |
| 315 |
`helpdeskhelp_url` varchar(255) collate utf8_unicode_ci default NULL, |
| 316 |
`centralhelp_url` varchar(255) collate utf8_unicode_ci default NULL, |
| 317 |
`default_rubdoc_tracking` int(11) default '0', |
| 318 |
`monitors_management_restrict` int(1) NOT NULL default '2', |
| 319 |
`phones_management_restrict` int(1) NOT NULL default '2', |
| 320 |
`peripherals_management_restrict` int(1) NOT NULL default '2', |
| 321 |
`printers_management_restrict` int(1) NOT NULL default '2', |
| 322 |
`licenses_management_restrict` int(1) NOT NULL default '2', |
| 323 |
`license_deglobalisation` int(1) NOT NULL default '1', |
| 324 |
`use_errorlog` int(1) NOT NULL default '0', |
| 325 |
`glpi_timezone` varchar(255) collate utf8_unicode_ci default NULL, |
| 326 |
`autoupdate_link_contact` smallint(6) NOT NULL default '1', |
| 327 |
`autoupdate_link_user` smallint(6) NOT NULL default '1', |
| 328 |
`autoupdate_link_group` smallint(6) NOT NULL default '1', |
| 329 |
`autoupdate_link_location` smallint(6) NOT NULL default '1', |
| 330 |
`autoupdate_link_state` smallint(6) NOT NULL default '0', |
| 331 |
`autoclean_link_contact` smallint(6) NOT NULL default '0', |
| 332 |
`autoclean_link_user` smallint(6) NOT NULL default '0', |
| 333 |
`autoclean_link_group` smallint(6) NOT NULL default '0', |
| 334 |
`autoclean_link_location` smallint(6) NOT NULL default '0', |
| 335 |
`autoclean_link_state` smallint(6) NOT NULL default '0', |
| 336 |
`flat_dropdowntree` smallint(6) NOT NULL default '0', |
| 337 |
`autoname_entity` smallint(6) NOT NULL default '1', |
| 338 |
`expand_soft_categorized` int(1) NOT NULL default '1', |
| 339 |
`expand_soft_not_categorized` int(1) NOT NULL default '1', |
| 340 |
`dbreplicate_notify_desynchronization` smallint(6) NOT NULL default '0', |
| 341 |
`dbreplicate_email` varchar(255) collate utf8_unicode_ci default NULL, |
| 342 |
`dbreplicate_maxdelay` int(11) NOT NULL default '3600', |
| 343 |
`category_on_software_delete` int(11) NOT NULL default '0', |
| 344 |
`x509_email_field` varchar(255) collate utf8_unicode_ci default NULL, |
| 345 |
`ticket_title_mandatory` int(1) NOT NULL default '0', |
| 346 |
`ticket_content_mandatory` int(1) NOT NULL default '1', |
| 347 |
`ticket_category_mandatory` int(1) NOT NULL default '0', |
| 348 |
`mailgate_filesize_max` int(11) NOT NULL default '2097152', |
| 349 |
PRIMARY KEY (`ID`) |
| 350 |
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 351 |
|
| 352 |
INSERT INTO glpi_config VALUES ('1','10','0','1','255','30','15','50',' 0.71.5','GLPI powered by indepnet','5','0','admsys@xxxxx.fr',NULL,'SIGNATURE','','fr_FR','#fff2f2','#ffe0e0','#ffcece','#ffbfbf','#ffadad','2005-12-31','10','','','',NULL,'1',NULL,'08:00:00','20:00:00','1','0','0','http://localhost/glpi/','0','','0','','100','*','0','50','1','1','0','0','name','0','50','0','0','1','0',NULL,'25',NULL,NULL,NULL,'8080',NULL,NULL,'1','0','0','0','0','0','0','0','5','2',NULL,NULL,'0','2','2','2','2','2','1','0','0','1','1','1','1','0','0','0','0','0','0','0','1','1','1','0',NULL,'3600','1',NULL,'0','1','0','2097152'); |
| 353 |
|
| 354 |
### Dump table glpi_connect_wire
|
| 355 |
|
| 356 |
DROP TABLE IF EXISTS `glpi_connect_wire`; |
| 357 |
CREATE TABLE `glpi_connect_wire` ( |
| 358 |
`ID` int(11) NOT NULL auto_increment, |
| 359 |
`end1` int(11) NOT NULL default '0', |
| 360 |
`end2` int(11) NOT NULL default '0', |
| 361 |
`type` smallint(6) NOT NULL default '0', |
| 362 |
PRIMARY KEY (`ID`), |
| 363 |
UNIQUE KEY `end1_1` (`end1`,`end2`,`type`), |
| 364 |
KEY `end1` (`end1`), |
| 365 |
KEY `end2` (`end2`), |
| 366 |
KEY `type` (`type`) |
| 367 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 368 |
|
| 369 |
|
| 370 |
### Dump table glpi_consumables
|
| 371 |
|
| 372 |
DROP TABLE IF EXISTS `glpi_consumables`; |
| 373 |
CREATE TABLE `glpi_consumables` ( |
| 374 |
`ID` int(11) NOT NULL auto_increment, |
| 375 |
`FK_glpi_consumables_type` int(11) default NULL, |
| 376 |
`date_in` date default NULL, |
| 377 |
`date_out` date default NULL, |
| 378 |
`id_user` int(11) NOT NULL default '0', |
| 379 |
PRIMARY KEY (`ID`), |
| 380 |
KEY `FK_glpi_cartridges_type` (`FK_glpi_consumables_type`), |
| 381 |
KEY `date_in` (`date_in`), |
| 382 |
KEY `date_out` (`date_out`), |
| 383 |
KEY `id_user` (`id_user`) |
| 384 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 385 |
|
| 386 |
|
| 387 |
### Dump table glpi_consumables_type
|
| 388 |
|
| 389 |
DROP TABLE IF EXISTS `glpi_consumables_type`; |
| 390 |
CREATE TABLE `glpi_consumables_type` ( |
| 391 |
`ID` int(11) NOT NULL auto_increment, |
| 392 |
`FK_entities` int(11) NOT NULL default '0', |
| 393 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 394 |
`ref` varchar(255) collate utf8_unicode_ci default NULL, |
| 395 |
`location` int(11) NOT NULL default '0', |
| 396 |
`type` int(11) NOT NULL default '0', |
| 397 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 398 |
`tech_num` int(11) NOT NULL default '0', |
| 399 |
`deleted` smallint(6) NOT NULL default '0', |
| 400 |
`comments` text collate utf8_unicode_ci, |
| 401 |
`alarm` int(11) NOT NULL default '10', |
| 402 |
`notes` longtext collate utf8_unicode_ci, |
| 403 |
PRIMARY KEY (`ID`), |
| 404 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 405 |
KEY `tech_num` (`tech_num`), |
| 406 |
KEY `name` (`name`), |
| 407 |
KEY `location` (`location`), |
| 408 |
KEY `type` (`type`), |
| 409 |
KEY `alarm` (`alarm`), |
| 410 |
KEY `FK_entities` (`FK_entities`), |
| 411 |
KEY `deleted` (`deleted`) |
| 412 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 413 |
|
| 414 |
|
| 415 |
### Dump table glpi_contact_enterprise
|
| 416 |
|
| 417 |
DROP TABLE IF EXISTS `glpi_contact_enterprise`; |
| 418 |
CREATE TABLE `glpi_contact_enterprise` ( |
| 419 |
`ID` int(11) NOT NULL auto_increment, |
| 420 |
`FK_enterprise` int(11) NOT NULL default '0', |
| 421 |
`FK_contact` int(11) NOT NULL default '0', |
| 422 |
PRIMARY KEY (`ID`), |
| 423 |
UNIQUE KEY `FK_enterprise` (`FK_enterprise`,`FK_contact`), |
| 424 |
KEY `FK_enterprise_2` (`FK_enterprise`), |
| 425 |
KEY `FK_contact` (`FK_contact`) |
| 426 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 427 |
|
| 428 |
|
| 429 |
### Dump table glpi_contacts
|
| 430 |
|
| 431 |
DROP TABLE IF EXISTS `glpi_contacts`; |
| 432 |
CREATE TABLE `glpi_contacts` ( |
| 433 |
`ID` int(11) NOT NULL auto_increment, |
| 434 |
`FK_entities` int(11) NOT NULL default '0', |
| 435 |
`recursive` tinyint(1) NOT NULL default '0', |
| 436 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 437 |
`firstname` varchar(255) collate utf8_unicode_ci default NULL, |
| 438 |
`phone` varchar(255) collate utf8_unicode_ci default NULL, |
| 439 |
`phone2` varchar(255) collate utf8_unicode_ci default NULL, |
| 440 |
`mobile` varchar(255) collate utf8_unicode_ci default NULL, |
| 441 |
`fax` varchar(255) collate utf8_unicode_ci default NULL, |
| 442 |
`email` varchar(255) collate utf8_unicode_ci default NULL, |
| 443 |
`type` int(11) NOT NULL default '0', |
| 444 |
`comments` text collate utf8_unicode_ci, |
| 445 |
`deleted` smallint(6) NOT NULL default '0', |
| 446 |
`notes` longtext collate utf8_unicode_ci, |
| 447 |
PRIMARY KEY (`ID`), |
| 448 |
KEY `type` (`type`), |
| 449 |
KEY `name` (`name`), |
| 450 |
KEY `FK_entities` (`FK_entities`), |
| 451 |
KEY `deleted` (`deleted`) |
| 452 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 453 |
|
| 454 |
|
| 455 |
### Dump table glpi_contract_device
|
| 456 |
|
| 457 |
DROP TABLE IF EXISTS `glpi_contract_device`; |
| 458 |
CREATE TABLE `glpi_contract_device` ( |
| 459 |
`ID` int(11) NOT NULL auto_increment, |
| 460 |
`FK_contract` int(11) NOT NULL default '0', |
| 461 |
`FK_device` int(11) NOT NULL default '0', |
| 462 |
`device_type` smallint(6) NOT NULL default '0', |
| 463 |
PRIMARY KEY (`ID`), |
| 464 |
UNIQUE KEY `FK_contract` (`FK_contract`,`FK_device`,`device_type`), |
| 465 |
KEY `FK_contract_2` (`FK_contract`), |
| 466 |
KEY `FK_device` (`FK_device`,`device_type`), |
| 467 |
KEY `device_type` (`device_type`) |
| 468 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 469 |
|
| 470 |
|
| 471 |
### Dump table glpi_contract_enterprise
|
| 472 |
|
| 473 |
DROP TABLE IF EXISTS `glpi_contract_enterprise`; |
| 474 |
CREATE TABLE `glpi_contract_enterprise` ( |
| 475 |
`ID` int(11) NOT NULL auto_increment, |
| 476 |
`FK_enterprise` int(11) NOT NULL default '0', |
| 477 |
`FK_contract` int(11) NOT NULL default '0', |
| 478 |
PRIMARY KEY (`ID`), |
| 479 |
UNIQUE KEY `FK_enterprise` (`FK_enterprise`,`FK_contract`), |
| 480 |
KEY `FK_enterprise_2` (`FK_enterprise`), |
| 481 |
KEY `FK_contract` (`FK_contract`) |
| 482 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 483 |
|
| 484 |
|
| 485 |
### Dump table glpi_contracts
|
| 486 |
|
| 487 |
DROP TABLE IF EXISTS `glpi_contracts`; |
| 488 |
CREATE TABLE `glpi_contracts` ( |
| 489 |
`ID` int(11) NOT NULL auto_increment, |
| 490 |
`FK_entities` int(11) NOT NULL default '0', |
| 491 |
`recursive` tinyint(1) NOT NULL default '0', |
| 492 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 493 |
`num` varchar(255) collate utf8_unicode_ci default NULL, |
| 494 |
`cost` float NOT NULL default '0', |
| 495 |
`contract_type` int(11) NOT NULL default '0', |
| 496 |
`begin_date` date default NULL, |
| 497 |
`duration` smallint(6) NOT NULL default '0', |
| 498 |
`notice` smallint(6) NOT NULL default '0', |
| 499 |
`periodicity` smallint(6) NOT NULL default '0', |
| 500 |
`facturation` smallint(6) NOT NULL default '0', |
| 501 |
`bill_type` int(11) NOT NULL default '0', |
| 502 |
`comments` text collate utf8_unicode_ci, |
| 503 |
`compta_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 504 |
`deleted` smallint(6) NOT NULL default '0', |
| 505 |
`week_begin_hour` time NOT NULL default '00:00:00', |
| 506 |
`week_end_hour` time NOT NULL default '00:00:00', |
| 507 |
`saturday_begin_hour` time NOT NULL default '00:00:00', |
| 508 |
`saturday_end_hour` time NOT NULL default '00:00:00', |
| 509 |
`saturday` smallint(6) NOT NULL default '0', |
| 510 |
`monday_begin_hour` time NOT NULL default '00:00:00', |
| 511 |
`monday_end_hour` time NOT NULL default '00:00:00', |
| 512 |
`monday` smallint(6) NOT NULL default '0', |
| 513 |
`device_countmax` int(11) NOT NULL default '0', |
| 514 |
`notes` longtext collate utf8_unicode_ci, |
| 515 |
`alert` smallint(6) NOT NULL default '0', |
| 516 |
`renewal` smallint(6) NOT NULL default '0', |
| 517 |
PRIMARY KEY (`ID`), |
| 518 |
KEY `contract_type` (`contract_type`), |
| 519 |
KEY `begin_date` (`begin_date`), |
| 520 |
KEY `bill_type` (`bill_type`), |
| 521 |
KEY `name` (`name`), |
| 522 |
KEY `FK_entities` (`FK_entities`), |
| 523 |
KEY `deleted` (`deleted`) |
| 524 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 525 |
|
| 526 |
|
| 527 |
### Dump table glpi_device_case
|
| 528 |
|
| 529 |
DROP TABLE IF EXISTS `glpi_device_case`; |
| 530 |
CREATE TABLE `glpi_device_case` ( |
| 531 |
`ID` int(11) NOT NULL auto_increment, |
| 532 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 533 |
`type` int(11) NOT NULL default '0', |
| 534 |
`comment` text collate utf8_unicode_ci, |
| 535 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 536 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 537 |
PRIMARY KEY (`ID`), |
| 538 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 539 |
KEY `designation` (`designation`) |
| 540 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 541 |
|
| 542 |
|
| 543 |
### Dump table glpi_device_control
|
| 544 |
|
| 545 |
DROP TABLE IF EXISTS `glpi_device_control`; |
| 546 |
CREATE TABLE `glpi_device_control` ( |
| 547 |
`ID` int(11) NOT NULL auto_increment, |
| 548 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 549 |
`raid` smallint(6) NOT NULL default '0', |
| 550 |
`comment` text collate utf8_unicode_ci, |
| 551 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 552 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 553 |
`interface` int(11) NOT NULL default '0', |
| 554 |
PRIMARY KEY (`ID`), |
| 555 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 556 |
KEY `designation` (`designation`), |
| 557 |
KEY `interface` (`interface`) |
| 558 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 559 |
|
| 560 |
|
| 561 |
### Dump table glpi_device_drive
|
| 562 |
|
| 563 |
DROP TABLE IF EXISTS `glpi_device_drive`; |
| 564 |
CREATE TABLE `glpi_device_drive` ( |
| 565 |
`ID` int(11) NOT NULL auto_increment, |
| 566 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 567 |
`is_writer` smallint(6) NOT NULL default '1', |
| 568 |
`speed` varchar(255) collate utf8_unicode_ci default NULL, |
| 569 |
`comment` text collate utf8_unicode_ci, |
| 570 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 571 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 572 |
`interface` int(11) NOT NULL default '0', |
| 573 |
PRIMARY KEY (`ID`), |
| 574 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 575 |
KEY `designation` (`designation`), |
| 576 |
KEY `interface` (`interface`) |
| 577 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 578 |
|
| 579 |
|
| 580 |
### Dump table glpi_device_gfxcard
|
| 581 |
|
| 582 |
DROP TABLE IF EXISTS `glpi_device_gfxcard`; |
| 583 |
CREATE TABLE `glpi_device_gfxcard` ( |
| 584 |
`ID` int(11) NOT NULL auto_increment, |
| 585 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 586 |
`interface` varchar(255) collate utf8_unicode_ci default 'PCI-X', |
| 587 |
`comment` text collate utf8_unicode_ci, |
| 588 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 589 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 590 |
PRIMARY KEY (`ID`), |
| 591 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 592 |
KEY `designation` (`designation`) |
| 593 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 594 |
|
| 595 |
|
| 596 |
### Dump table glpi_device_hdd
|
| 597 |
|
| 598 |
DROP TABLE IF EXISTS `glpi_device_hdd`; |
| 599 |
CREATE TABLE `glpi_device_hdd` ( |
| 600 |
`ID` int(11) NOT NULL auto_increment, |
| 601 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 602 |
`rpm` varchar(255) collate utf8_unicode_ci default NULL, |
| 603 |
`interface` int(11) NOT NULL default '0', |
| 604 |
`cache` varchar(255) collate utf8_unicode_ci default NULL, |
| 605 |
`comment` text collate utf8_unicode_ci, |
| 606 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 607 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 608 |
PRIMARY KEY (`ID`), |
| 609 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 610 |
KEY `designation` (`designation`), |
| 611 |
KEY `interface` (`interface`) |
| 612 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 613 |
|
| 614 |
|
| 615 |
### Dump table glpi_device_iface
|
| 616 |
|
| 617 |
DROP TABLE IF EXISTS `glpi_device_iface`; |
| 618 |
CREATE TABLE `glpi_device_iface` ( |
| 619 |
`ID` int(11) NOT NULL auto_increment, |
| 620 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 621 |
`bandwidth` varchar(255) collate utf8_unicode_ci default NULL, |
| 622 |
`comment` text collate utf8_unicode_ci, |
| 623 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 624 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 625 |
PRIMARY KEY (`ID`), |
| 626 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 627 |
KEY `designation` (`designation`) |
| 628 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 629 |
|
| 630 |
|
| 631 |
### Dump table glpi_device_moboard
|
| 632 |
|
| 633 |
DROP TABLE IF EXISTS `glpi_device_moboard`; |
| 634 |
CREATE TABLE `glpi_device_moboard` ( |
| 635 |
`ID` int(11) NOT NULL auto_increment, |
| 636 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 637 |
`chipset` varchar(255) collate utf8_unicode_ci default NULL, |
| 638 |
`comment` text collate utf8_unicode_ci, |
| 639 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 640 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 641 |
PRIMARY KEY (`ID`), |
| 642 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 643 |
KEY `designation` (`designation`) |
| 644 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 645 |
|
| 646 |
|
| 647 |
### Dump table glpi_device_pci
|
| 648 |
|
| 649 |
DROP TABLE IF EXISTS `glpi_device_pci`; |
| 650 |
CREATE TABLE `glpi_device_pci` ( |
| 651 |
`ID` int(11) NOT NULL auto_increment, |
| 652 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 653 |
`comment` text collate utf8_unicode_ci, |
| 654 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 655 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 656 |
PRIMARY KEY (`ID`), |
| 657 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 658 |
KEY `designation` (`designation`) |
| 659 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 660 |
|
| 661 |
|
| 662 |
### Dump table glpi_device_power
|
| 663 |
|
| 664 |
DROP TABLE IF EXISTS `glpi_device_power`; |
| 665 |
CREATE TABLE `glpi_device_power` ( |
| 666 |
`ID` int(11) NOT NULL auto_increment, |
| 667 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 668 |
`power` varchar(255) collate utf8_unicode_ci default NULL, |
| 669 |
`atx` smallint(6) NOT NULL default '1', |
| 670 |
`comment` text collate utf8_unicode_ci, |
| 671 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 672 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 673 |
PRIMARY KEY (`ID`), |
| 674 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 675 |
KEY `designation` (`designation`) |
| 676 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 677 |
|
| 678 |
|
| 679 |
### Dump table glpi_device_processor
|
| 680 |
|
| 681 |
DROP TABLE IF EXISTS `glpi_device_processor`; |
| 682 |
CREATE TABLE `glpi_device_processor` ( |
| 683 |
`ID` int(11) NOT NULL auto_increment, |
| 684 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 685 |
`frequence` int(11) NOT NULL default '0', |
| 686 |
`comment` text collate utf8_unicode_ci, |
| 687 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 688 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 689 |
PRIMARY KEY (`ID`), |
| 690 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 691 |
KEY `designation` (`designation`) |
| 692 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 693 |
|
| 694 |
|
| 695 |
### Dump table glpi_device_ram
|
| 696 |
|
| 697 |
DROP TABLE IF EXISTS `glpi_device_ram`; |
| 698 |
CREATE TABLE `glpi_device_ram` ( |
| 699 |
`ID` int(11) NOT NULL auto_increment, |
| 700 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 701 |
`frequence` varchar(255) collate utf8_unicode_ci default NULL, |
| 702 |
`comment` text collate utf8_unicode_ci, |
| 703 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 704 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 705 |
`type` int(11) NOT NULL default '0', |
| 706 |
PRIMARY KEY (`ID`), |
| 707 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 708 |
KEY `designation` (`designation`), |
| 709 |
KEY `type` (`type`) |
| 710 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 711 |
|
| 712 |
|
| 713 |
### Dump table glpi_device_sndcard
|
| 714 |
|
| 715 |
DROP TABLE IF EXISTS `glpi_device_sndcard`; |
| 716 |
CREATE TABLE `glpi_device_sndcard` ( |
| 717 |
`ID` int(11) NOT NULL auto_increment, |
| 718 |
`designation` varchar(255) collate utf8_unicode_ci default NULL, |
| 719 |
`type` varchar(255) collate utf8_unicode_ci default NULL, |
| 720 |
`comment` text collate utf8_unicode_ci, |
| 721 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 722 |
`specif_default` varchar(255) collate utf8_unicode_ci default NULL, |
| 723 |
PRIMARY KEY (`ID`), |
| 724 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 725 |
KEY `designation` (`designation`) |
| 726 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 727 |
|
| 728 |
|
| 729 |
### Dump table glpi_display
|
| 730 |
|
| 731 |
DROP TABLE IF EXISTS `glpi_display`; |
| 732 |
CREATE TABLE `glpi_display` ( |
| 733 |
`ID` int(11) NOT NULL auto_increment, |
| 734 |
`type` smallint(6) NOT NULL default '0', |
| 735 |
`num` smallint(6) NOT NULL default '0', |
| 736 |
`rank` smallint(6) NOT NULL default '0', |
| 737 |
`FK_users` int(11) NOT NULL default '0', |
| 738 |
PRIMARY KEY (`ID`), |
| 739 |
UNIQUE KEY `type_2` (`type`,`num`,`FK_users`), |
| 740 |
KEY `type` (`type`), |
| 741 |
KEY `rank` (`rank`), |
| 742 |
KEY `num` (`num`), |
| 743 |
KEY `FK_users` (`FK_users`) |
| 744 |
) ENGINE=MyISAM AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 745 |
|
| 746 |
INSERT INTO glpi_display VALUES ('32','1','4','4','0'); |
| 747 |
INSERT INTO glpi_display VALUES ('34','1','6','6','0'); |
| 748 |
INSERT INTO glpi_display VALUES ('33','1','5','5','0'); |
| 749 |
INSERT INTO glpi_display VALUES ('31','1','8','3','0'); |
| 750 |
INSERT INTO glpi_display VALUES ('30','1','23','2','0'); |
| 751 |
INSERT INTO glpi_display VALUES ('86','12','3','1','0'); |
| 752 |
INSERT INTO glpi_display VALUES ('49','4','31','1','0'); |
| 753 |
INSERT INTO glpi_display VALUES ('50','4','23','2','0'); |
| 754 |
INSERT INTO glpi_display VALUES ('51','4','3','3','0'); |
| 755 |
INSERT INTO glpi_display VALUES ('52','4','4','4','0'); |
| 756 |
INSERT INTO glpi_display VALUES ('44','3','31','1','0'); |
| 757 |
INSERT INTO glpi_display VALUES ('38','2','31','1','0'); |
| 758 |
INSERT INTO glpi_display VALUES ('39','2','23','2','0'); |
| 759 |
INSERT INTO glpi_display VALUES ('45','3','23','2','0'); |
| 760 |
INSERT INTO glpi_display VALUES ('46','3','3','3','0'); |
| 761 |
INSERT INTO glpi_display VALUES ('63','6','4','3','0'); |
| 762 |
INSERT INTO glpi_display VALUES ('62','6','5','2','0'); |
| 763 |
INSERT INTO glpi_display VALUES ('61','6','23','1','0'); |
| 764 |
INSERT INTO glpi_display VALUES ('83','11','4','2','0'); |
| 765 |
INSERT INTO glpi_display VALUES ('82','11','3','1','0'); |
| 766 |
INSERT INTO glpi_display VALUES ('57','5','3','3','0'); |
| 767 |
INSERT INTO glpi_display VALUES ('56','5','23','2','0'); |
| 768 |
INSERT INTO glpi_display VALUES ('55','5','31','1','0'); |
| 769 |
INSERT INTO glpi_display VALUES ('29','1','31','1','0'); |
| 770 |
INSERT INTO glpi_display VALUES ('35','1','3','7','0'); |
| 771 |
INSERT INTO glpi_display VALUES ('36','1','19','8','0'); |
| 772 |
INSERT INTO glpi_display VALUES ('37','1','17','9','0'); |
| 773 |
INSERT INTO glpi_display VALUES ('40','2','3','3','0'); |
| 774 |
INSERT INTO glpi_display VALUES ('41','2','4','4','0'); |
| 775 |
INSERT INTO glpi_display VALUES ('42','2','11','6','0'); |
| 776 |
INSERT INTO glpi_display VALUES ('43','2','9','7','0'); |
| 777 |
INSERT INTO glpi_display VALUES ('47','3','4','4','0'); |
| 778 |
INSERT INTO glpi_display VALUES ('48','3','9','6','0'); |
| 779 |
INSERT INTO glpi_display VALUES ('53','4','9','6','0'); |
| 780 |
INSERT INTO glpi_display VALUES ('54','4','7','7','0'); |
| 781 |
INSERT INTO glpi_display VALUES ('58','5','4','4','0'); |
| 782 |
INSERT INTO glpi_display VALUES ('59','5','9','6','0'); |
| 783 |
INSERT INTO glpi_display VALUES ('60','5','7','7','0'); |
| 784 |
INSERT INTO glpi_display VALUES ('64','7','3','1','0'); |
| 785 |
INSERT INTO glpi_display VALUES ('65','7','4','2','0'); |
| 786 |
INSERT INTO glpi_display VALUES ('66','7','5','3','0'); |
| 787 |
INSERT INTO glpi_display VALUES ('67','7','6','4','0'); |
| 788 |
INSERT INTO glpi_display VALUES ('68','7','9','5','0'); |
| 789 |
INSERT INTO glpi_display VALUES ('69','8','9','1','0'); |
| 790 |
INSERT INTO glpi_display VALUES ('70','8','3','2','0'); |
| 791 |
INSERT INTO glpi_display VALUES ('71','8','4','3','0'); |
| 792 |
INSERT INTO glpi_display VALUES ('72','8','5','4','0'); |
| 793 |
INSERT INTO glpi_display VALUES ('73','8','10','5','0'); |
| 794 |
INSERT INTO glpi_display VALUES ('74','8','6','6','0'); |
| 795 |
INSERT INTO glpi_display VALUES ('75','10','4','1','0'); |
| 796 |
INSERT INTO glpi_display VALUES ('76','10','3','2','0'); |
| 797 |
INSERT INTO glpi_display VALUES ('77','10','5','3','0'); |
| 798 |
INSERT INTO glpi_display VALUES ('78','10','6','4','0'); |
| 799 |
INSERT INTO glpi_display VALUES ('79','10','7','5','0'); |
| 800 |
INSERT INTO glpi_display VALUES ('80','10','11','6','0'); |
| 801 |
INSERT INTO glpi_display VALUES ('84','11','5','3','0'); |
| 802 |
INSERT INTO glpi_display VALUES ('85','11','6','4','0'); |
| 803 |
INSERT INTO glpi_display VALUES ('88','12','6','2','0'); |
| 804 |
INSERT INTO glpi_display VALUES ('89','12','4','3','0'); |
| 805 |
INSERT INTO glpi_display VALUES ('90','12','5','4','0'); |
| 806 |
INSERT INTO glpi_display VALUES ('91','13','3','1','0'); |
| 807 |
INSERT INTO glpi_display VALUES ('92','13','4','2','0'); |
| 808 |
INSERT INTO glpi_display VALUES ('93','13','7','3','0'); |
| 809 |
INSERT INTO glpi_display VALUES ('94','13','5','4','0'); |
| 810 |
INSERT INTO glpi_display VALUES ('95','13','6','5','0'); |
| 811 |
INSERT INTO glpi_display VALUES ('96','15','3','1','0'); |
| 812 |
INSERT INTO glpi_display VALUES ('98','15','5','3','0'); |
| 813 |
INSERT INTO glpi_display VALUES ('99','15','6','4','0'); |
| 814 |
INSERT INTO glpi_display VALUES ('100','15','7','5','0'); |
| 815 |
INSERT INTO glpi_display VALUES ('101','17','3','1','0'); |
| 816 |
INSERT INTO glpi_display VALUES ('102','17','4','2','0'); |
| 817 |
INSERT INTO glpi_display VALUES ('103','17','5','3','0'); |
| 818 |
INSERT INTO glpi_display VALUES ('104','17','6','4','0'); |
| 819 |
INSERT INTO glpi_display VALUES ('105','2','40','5','0'); |
| 820 |
INSERT INTO glpi_display VALUES ('106','3','40','5','0'); |
| 821 |
INSERT INTO glpi_display VALUES ('107','4','40','5','0'); |
| 822 |
INSERT INTO glpi_display VALUES ('108','5','40','5','0'); |
| 823 |
INSERT INTO glpi_display VALUES ('109','15','8','6','0'); |
| 824 |
INSERT INTO glpi_display VALUES ('110','23','31','1','0'); |
| 825 |
INSERT INTO glpi_display VALUES ('111','23','23','2','0'); |
| 826 |
INSERT INTO glpi_display VALUES ('112','23','3','3','0'); |
| 827 |
INSERT INTO glpi_display VALUES ('113','23','4','4','0'); |
| 828 |
INSERT INTO glpi_display VALUES ('114','23','40','5','0'); |
| 829 |
INSERT INTO glpi_display VALUES ('115','23','9','6','0'); |
| 830 |
INSERT INTO glpi_display VALUES ('116','23','7','7','0'); |
| 831 |
INSERT INTO glpi_display VALUES ('117','27','16','1','0'); |
| 832 |
INSERT INTO glpi_display VALUES ('118','22','31','1','0'); |
| 833 |
INSERT INTO glpi_display VALUES ('119','29','4','1','0'); |
| 834 |
INSERT INTO glpi_display VALUES ('120','29','3','2','0'); |
| 835 |
INSERT INTO glpi_display VALUES ('121','35','80','1','0'); |
| 836 |
|
| 837 |
### Dump table glpi_doc_device
|
| 838 |
|
| 839 |
DROP TABLE IF EXISTS `glpi_doc_device`; |
| 840 |
CREATE TABLE `glpi_doc_device` ( |
| 841 |
`ID` int(11) NOT NULL auto_increment, |
| 842 |
`FK_doc` int(11) NOT NULL default '0', |
| 843 |
`FK_device` int(11) NOT NULL default '0', |
| 844 |
`device_type` smallint(6) NOT NULL default '0', |
| 845 |
PRIMARY KEY (`ID`), |
| 846 |
UNIQUE KEY `FK_doc` (`FK_doc`,`FK_device`,`device_type`), |
| 847 |
KEY `FK_doc_2` (`FK_doc`), |
| 848 |
KEY `FK_device` (`FK_device`,`device_type`), |
| 849 |
KEY `device_type` (`device_type`) |
| 850 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 851 |
|
| 852 |
|
| 853 |
### Dump table glpi_docs
|
| 854 |
|
| 855 |
DROP TABLE IF EXISTS `glpi_docs`; |
| 856 |
CREATE TABLE `glpi_docs` ( |
| 857 |
`ID` int(11) NOT NULL auto_increment, |
| 858 |
`FK_entities` int(11) NOT NULL default '0', |
| 859 |
`recursive` tinyint(1) NOT NULL default '0', |
| 860 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 861 |
`filename` varchar(255) collate utf8_unicode_ci default NULL, |
| 862 |
`rubrique` int(11) NOT NULL default '0', |
| 863 |
`mime` varchar(255) collate utf8_unicode_ci default NULL, |
| 864 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 865 |
`comments` text collate utf8_unicode_ci, |
| 866 |
`deleted` smallint(6) NOT NULL default '0', |
| 867 |
`link` varchar(255) collate utf8_unicode_ci default NULL, |
| 868 |
`notes` longtext collate utf8_unicode_ci, |
| 869 |
`FK_users` int(11) NOT NULL default '0', |
| 870 |
`FK_tracking` int(11) NOT NULL default '0', |
| 871 |
PRIMARY KEY (`ID`), |
| 872 |
KEY `rubrique` (`rubrique`), |
| 873 |
KEY `date_mod` (`date_mod`), |
| 874 |
KEY `name` (`name`), |
| 875 |
KEY `FK_users` (`FK_users`), |
| 876 |
KEY `FK_tracking` (`FK_tracking`), |
| 877 |
KEY `FK_entities` (`FK_entities`), |
| 878 |
KEY `deleted` (`deleted`) |
| 879 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 880 |
|
| 881 |
|
| 882 |
### Dump table glpi_dropdown_auto_update
|
| 883 |
|
| 884 |
DROP TABLE IF EXISTS `glpi_dropdown_auto_update`; |
| 885 |
CREATE TABLE `glpi_dropdown_auto_update` ( |
| 886 |
`ID` int(11) NOT NULL auto_increment, |
| 887 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 888 |
`comments` text collate utf8_unicode_ci, |
| 889 |
PRIMARY KEY (`ID`), |
| 890 |
KEY `name` (`name`) |
| 891 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 892 |
|
| 893 |
|
| 894 |
### Dump table glpi_dropdown_budget
|
| 895 |
|
| 896 |
DROP TABLE IF EXISTS `glpi_dropdown_budget`; |
| 897 |
CREATE TABLE `glpi_dropdown_budget` ( |
| 898 |
`ID` int(11) NOT NULL auto_increment, |
| 899 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 900 |
`comments` text collate utf8_unicode_ci, |
| 901 |
PRIMARY KEY (`ID`), |
| 902 |
KEY `name` (`name`) |
| 903 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 904 |
|
| 905 |
|
| 906 |
### Dump table glpi_dropdown_cartridge_type
|
| 907 |
|
| 908 |
DROP TABLE IF EXISTS `glpi_dropdown_cartridge_type`; |
| 909 |
CREATE TABLE `glpi_dropdown_cartridge_type` ( |
| 910 |
`ID` int(11) NOT NULL auto_increment, |
| 911 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 912 |
`comments` text collate utf8_unicode_ci, |
| 913 |
PRIMARY KEY (`ID`), |
| 914 |
KEY `name` (`name`) |
| 915 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 916 |
|
| 917 |
|
| 918 |
### Dump table glpi_dropdown_case_type
|
| 919 |
|
| 920 |
DROP TABLE IF EXISTS `glpi_dropdown_case_type`; |
| 921 |
CREATE TABLE `glpi_dropdown_case_type` ( |
| 922 |
`ID` int(11) NOT NULL auto_increment, |
| 923 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 924 |
`comments` text collate utf8_unicode_ci, |
| 925 |
PRIMARY KEY (`ID`), |
| 926 |
KEY `name` (`name`) |
| 927 |
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 928 |
|
| 929 |
INSERT INTO glpi_dropdown_case_type VALUES ('1','Grand',NULL); |
| 930 |
INSERT INTO glpi_dropdown_case_type VALUES ('2','Moyen',NULL); |
| 931 |
INSERT INTO glpi_dropdown_case_type VALUES ('3','Micro',NULL); |
| 932 |
|
| 933 |
### Dump table glpi_dropdown_consumable_type
|
| 934 |
|
| 935 |
DROP TABLE IF EXISTS `glpi_dropdown_consumable_type`; |
| 936 |
CREATE TABLE `glpi_dropdown_consumable_type` ( |
| 937 |
`ID` int(11) NOT NULL auto_increment, |
| 938 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 939 |
`comments` text collate utf8_unicode_ci, |
| 940 |
PRIMARY KEY (`ID`), |
| 941 |
KEY `name` (`name`) |
| 942 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 943 |
|
| 944 |
|
| 945 |
### Dump table glpi_dropdown_contact_type
|
| 946 |
|
| 947 |
DROP TABLE IF EXISTS `glpi_dropdown_contact_type`; |
| 948 |
CREATE TABLE `glpi_dropdown_contact_type` ( |
| 949 |
`ID` int(11) NOT NULL auto_increment, |
| 950 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 951 |
`comments` text collate utf8_unicode_ci, |
| 952 |
PRIMARY KEY (`ID`), |
| 953 |
KEY `name` (`name`) |
| 954 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 955 |
|
| 956 |
|
| 957 |
### Dump table glpi_dropdown_contract_type
|
| 958 |
|
| 959 |
DROP TABLE IF EXISTS `glpi_dropdown_contract_type`; |
| 960 |
CREATE TABLE `glpi_dropdown_contract_type` ( |
| 961 |
`ID` int(11) NOT NULL auto_increment, |
| 962 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 963 |
`comments` text collate utf8_unicode_ci, |
| 964 |
PRIMARY KEY (`ID`), |
| 965 |
KEY `name` (`name`) |
| 966 |
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 967 |
|
| 968 |
INSERT INTO glpi_dropdown_contract_type VALUES ('1','Prêt',NULL); |
| 969 |
INSERT INTO glpi_dropdown_contract_type VALUES ('2','Location',NULL); |
| 970 |
INSERT INTO glpi_dropdown_contract_type VALUES ('3','Leasing',NULL); |
| 971 |
INSERT INTO glpi_dropdown_contract_type VALUES ('4','Assurances',NULL); |
| 972 |
INSERT INTO glpi_dropdown_contract_type VALUES ('5','Maintenance Hardware',NULL); |
| 973 |
INSERT INTO glpi_dropdown_contract_type VALUES ('6','Maintenance Software',NULL); |
| 974 |
INSERT INTO glpi_dropdown_contract_type VALUES ('7','Prestation',NULL); |
| 975 |
|
| 976 |
### Dump table glpi_dropdown_domain
|
| 977 |
|
| 978 |
DROP TABLE IF EXISTS `glpi_dropdown_domain`; |
| 979 |
CREATE TABLE `glpi_dropdown_domain` ( |
| 980 |
`ID` int(11) NOT NULL auto_increment, |
| 981 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 982 |
`comments` text collate utf8_unicode_ci, |
| 983 |
PRIMARY KEY (`ID`), |
| 984 |
KEY `name` (`name`) |
| 985 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 986 |
|
| 987 |
|
| 988 |
### Dump table glpi_dropdown_enttype
|
| 989 |
|
| 990 |
DROP TABLE IF EXISTS `glpi_dropdown_enttype`; |
| 991 |
CREATE TABLE `glpi_dropdown_enttype` ( |
| 992 |
`ID` int(11) NOT NULL auto_increment, |
| 993 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 994 |
`comments` text collate utf8_unicode_ci, |
| 995 |
PRIMARY KEY (`ID`), |
| 996 |
KEY `name` (`name`) |
| 997 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 998 |
|
| 999 |
|
| 1000 |
### Dump table glpi_dropdown_firmware
|
| 1001 |
|
| 1002 |
DROP TABLE IF EXISTS `glpi_dropdown_firmware`; |
| 1003 |
CREATE TABLE `glpi_dropdown_firmware` ( |
| 1004 |
`ID` int(11) NOT NULL auto_increment, |
| 1005 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1006 |
`comments` text collate utf8_unicode_ci, |
| 1007 |
PRIMARY KEY (`ID`), |
| 1008 |
KEY `name` (`name`) |
| 1009 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1010 |
|
| 1011 |
|
| 1012 |
### Dump table glpi_dropdown_iface
|
| 1013 |
|
| 1014 |
DROP TABLE IF EXISTS `glpi_dropdown_iface`; |
| 1015 |
CREATE TABLE `glpi_dropdown_iface` ( |
| 1016 |
`ID` int(11) NOT NULL auto_increment, |
| 1017 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1018 |
`comments` text collate utf8_unicode_ci, |
| 1019 |
PRIMARY KEY (`ID`), |
| 1020 |
KEY `name` (`name`) |
| 1021 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1022 |
|
| 1023 |
|
| 1024 |
### Dump table glpi_dropdown_interface
|
| 1025 |
|
| 1026 |
DROP TABLE IF EXISTS `glpi_dropdown_interface`; |
| 1027 |
CREATE TABLE `glpi_dropdown_interface` ( |
| 1028 |
`ID` int(11) NOT NULL auto_increment, |
| 1029 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1030 |
`comments` text collate utf8_unicode_ci, |
| 1031 |
PRIMARY KEY (`ID`), |
| 1032 |
KEY `name` (`name`) |
| 1033 |
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1034 |
|
| 1035 |
INSERT INTO glpi_dropdown_interface VALUES ('1','IDE',NULL); |
| 1036 |
INSERT INTO glpi_dropdown_interface VALUES ('2','SATA',NULL); |
| 1037 |
INSERT INTO glpi_dropdown_interface VALUES ('3','SCSI',NULL); |
| 1038 |
INSERT INTO glpi_dropdown_interface VALUES ('4','USB',NULL); |
| 1039 |
|
| 1040 |
### Dump table glpi_dropdown_kbcategories
|
| 1041 |
|
| 1042 |
DROP TABLE IF EXISTS `glpi_dropdown_kbcategories`; |
| 1043 |
CREATE TABLE `glpi_dropdown_kbcategories` ( |
| 1044 |
`ID` int(11) NOT NULL auto_increment, |
| 1045 |
`parentID` int(11) NOT NULL default '0', |
| 1046 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1047 |
`completename` text collate utf8_unicode_ci, |
| 1048 |
`comments` text collate utf8_unicode_ci, |
| 1049 |
`level` int(11) NOT NULL default '0', |
| 1050 |
PRIMARY KEY (`ID`), |
| 1051 |
UNIQUE KEY `parentID_2` (`parentID`,`name`), |
| 1052 |
KEY `parentID` (`parentID`), |
| 1053 |
KEY `name` (`name`) |
| 1054 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1055 |
|
| 1056 |
|
| 1057 |
### Dump table glpi_dropdown_locations
|
| 1058 |
|
| 1059 |
DROP TABLE IF EXISTS `glpi_dropdown_locations`; |
| 1060 |
CREATE TABLE `glpi_dropdown_locations` ( |
| 1061 |
`ID` int(11) NOT NULL auto_increment, |
| 1062 |
`FK_entities` int(11) NOT NULL default '0', |
| 1063 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1064 |
`parentID` int(11) NOT NULL default '0', |
| 1065 |
`completename` text collate utf8_unicode_ci, |
| 1066 |
`comments` text collate utf8_unicode_ci, |
| 1067 |
`level` int(11) NOT NULL default '0', |
| 1068 |
PRIMARY KEY (`ID`), |
| 1069 |
UNIQUE KEY `name` (`name`,`parentID`,`FK_entities`), |
| 1070 |
KEY `parentID` (`parentID`), |
| 1071 |
KEY `FK_entities` (`FK_entities`) |
| 1072 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1073 |
|
| 1074 |
|
| 1075 |
### Dump table glpi_dropdown_manufacturer
|
| 1076 |
|
| 1077 |
DROP TABLE IF EXISTS `glpi_dropdown_manufacturer`; |
| 1078 |
CREATE TABLE `glpi_dropdown_manufacturer` ( |
| 1079 |
`ID` int(11) NOT NULL auto_increment, |
| 1080 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1081 |
`comments` text collate utf8_unicode_ci, |
| 1082 |
PRIMARY KEY (`ID`), |
| 1083 |
KEY `name` (`name`) |
| 1084 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1085 |
|
| 1086 |
|
| 1087 |
### Dump table glpi_dropdown_model
|
| 1088 |
|
| 1089 |
DROP TABLE IF EXISTS `glpi_dropdown_model`; |
| 1090 |
CREATE TABLE `glpi_dropdown_model` ( |
| 1091 |
`ID` int(11) NOT NULL auto_increment, |
| 1092 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1093 |
`comments` text collate utf8_unicode_ci, |
| 1094 |
PRIMARY KEY (`ID`), |
| 1095 |
KEY `name` (`name`) |
| 1096 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1097 |
|
| 1098 |
|
| 1099 |
### Dump table glpi_dropdown_model_monitors
|
| 1100 |
|
| 1101 |
DROP TABLE IF EXISTS `glpi_dropdown_model_monitors`; |
| 1102 |
CREATE TABLE `glpi_dropdown_model_monitors` ( |
| 1103 |
`ID` int(11) NOT NULL auto_increment, |
| 1104 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1105 |
`comments` text collate utf8_unicode_ci, |
| 1106 |
PRIMARY KEY (`ID`), |
| 1107 |
KEY `name` (`name`) |
| 1108 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1109 |
|
| 1110 |
|
| 1111 |
### Dump table glpi_dropdown_model_networking
|
| 1112 |
|
| 1113 |
DROP TABLE IF EXISTS `glpi_dropdown_model_networking`; |
| 1114 |
CREATE TABLE `glpi_dropdown_model_networking` ( |
| 1115 |
`ID` int(11) NOT NULL auto_increment, |
| 1116 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1117 |
`comments` text collate utf8_unicode_ci, |
| 1118 |
PRIMARY KEY (`ID`), |
| 1119 |
KEY `name` (`name`) |
| 1120 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1121 |
|
| 1122 |
|
| 1123 |
### Dump table glpi_dropdown_model_peripherals
|
| 1124 |
|
| 1125 |
DROP TABLE IF EXISTS `glpi_dropdown_model_peripherals`; |
| 1126 |
CREATE TABLE `glpi_dropdown_model_peripherals` ( |
| 1127 |
`ID` int(11) NOT NULL auto_increment, |
| 1128 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1129 |
`comments` text collate utf8_unicode_ci, |
| 1130 |
PRIMARY KEY (`ID`), |
| 1131 |
KEY `name` (`name`) |
| 1132 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1133 |
|
| 1134 |
|
| 1135 |
### Dump table glpi_dropdown_model_phones
|
| 1136 |
|
| 1137 |
DROP TABLE IF EXISTS `glpi_dropdown_model_phones`; |
| 1138 |
CREATE TABLE `glpi_dropdown_model_phones` ( |
| 1139 |
`ID` int(11) NOT NULL auto_increment, |
| 1140 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1141 |
`comments` text collate utf8_unicode_ci, |
| 1142 |
PRIMARY KEY (`ID`), |
| 1143 |
KEY `name` (`name`) |
| 1144 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1145 |
|
| 1146 |
|
| 1147 |
### Dump table glpi_dropdown_model_printers
|
| 1148 |
|
| 1149 |
DROP TABLE IF EXISTS `glpi_dropdown_model_printers`; |
| 1150 |
CREATE TABLE `glpi_dropdown_model_printers` ( |
| 1151 |
`ID` int(11) NOT NULL auto_increment, |
| 1152 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1153 |
`comments` text collate utf8_unicode_ci, |
| 1154 |
PRIMARY KEY (`ID`), |
| 1155 |
KEY `name` (`name`) |
| 1156 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1157 |
|
| 1158 |
|
| 1159 |
### Dump table glpi_dropdown_netpoint
|
| 1160 |
|
| 1161 |
DROP TABLE IF EXISTS `glpi_dropdown_netpoint`; |
| 1162 |
CREATE TABLE `glpi_dropdown_netpoint` ( |
| 1163 |
`ID` int(11) NOT NULL auto_increment, |
| 1164 |
`FK_entities` int(11) NOT NULL default '0', |
| 1165 |
`location` int(11) NOT NULL default '0', |
| 1166 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1167 |
`comments` text collate utf8_unicode_ci, |
| 1168 |
PRIMARY KEY (`ID`), |
| 1169 |
KEY `location` (`location`), |
| 1170 |
KEY `name` (`name`), |
| 1171 |
KEY `FK_entities` (`FK_entities`) |
| 1172 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1173 |
|
| 1174 |
|
| 1175 |
### Dump table glpi_dropdown_network
|
| 1176 |
|
| 1177 |
DROP TABLE IF EXISTS `glpi_dropdown_network`; |
| 1178 |
CREATE TABLE `glpi_dropdown_network` ( |
| 1179 |
`ID` int(11) NOT NULL auto_increment, |
| 1180 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1181 |
`comments` text collate utf8_unicode_ci, |
| 1182 |
PRIMARY KEY (`ID`), |
| 1183 |
KEY `name` (`name`) |
| 1184 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1185 |
|
| 1186 |
|
| 1187 |
### Dump table glpi_dropdown_os
|
| 1188 |
|
| 1189 |
DROP TABLE IF EXISTS `glpi_dropdown_os`; |
| 1190 |
CREATE TABLE `glpi_dropdown_os` ( |
| 1191 |
`ID` int(11) NOT NULL auto_increment, |
| 1192 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1193 |
`comments` text collate utf8_unicode_ci, |
| 1194 |
PRIMARY KEY (`ID`), |
| 1195 |
KEY `name` (`name`) |
| 1196 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1197 |
|
| 1198 |
|
| 1199 |
### Dump table glpi_dropdown_os_sp
|
| 1200 |
|
| 1201 |
DROP TABLE IF EXISTS `glpi_dropdown_os_sp`; |
| 1202 |
CREATE TABLE `glpi_dropdown_os_sp` ( |
| 1203 |
`ID` int(11) NOT NULL auto_increment, |
| 1204 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1205 |
`comments` text collate utf8_unicode_ci, |
| 1206 |
PRIMARY KEY (`ID`), |
| 1207 |
KEY `name` (`name`) |
| 1208 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1209 |
|
| 1210 |
|
| 1211 |
### Dump table glpi_dropdown_os_version
|
| 1212 |
|
| 1213 |
DROP TABLE IF EXISTS `glpi_dropdown_os_version`; |
| 1214 |
CREATE TABLE `glpi_dropdown_os_version` ( |
| 1215 |
`ID` int(11) NOT NULL auto_increment, |
| 1216 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1217 |
`comments` text collate utf8_unicode_ci, |
| 1218 |
PRIMARY KEY (`ID`), |
| 1219 |
KEY `name` (`name`) |
| 1220 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1221 |
|
| 1222 |
|
| 1223 |
### Dump table glpi_dropdown_phone_power
|
| 1224 |
|
| 1225 |
DROP TABLE IF EXISTS `glpi_dropdown_phone_power`; |
| 1226 |
CREATE TABLE `glpi_dropdown_phone_power` ( |
| 1227 |
`ID` int(11) NOT NULL auto_increment, |
| 1228 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1229 |
`comments` text collate utf8_unicode_ci, |
| 1230 |
PRIMARY KEY (`ID`), |
| 1231 |
KEY `name` (`name`) |
| 1232 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1233 |
|
| 1234 |
|
| 1235 |
### Dump table glpi_dropdown_ram_type
|
| 1236 |
|
| 1237 |
DROP TABLE IF EXISTS `glpi_dropdown_ram_type`; |
| 1238 |
CREATE TABLE `glpi_dropdown_ram_type` ( |
| 1239 |
`ID` int(11) NOT NULL auto_increment, |
| 1240 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1241 |
`comments` text collate utf8_unicode_ci, |
| 1242 |
PRIMARY KEY (`ID`), |
| 1243 |
KEY `name` (`name`) |
| 1244 |
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1245 |
|
| 1246 |
INSERT INTO glpi_dropdown_ram_type VALUES ('1','EDO',NULL); |
| 1247 |
INSERT INTO glpi_dropdown_ram_type VALUES ('2','DDR',NULL); |
| 1248 |
INSERT INTO glpi_dropdown_ram_type VALUES ('3','SDRAM',NULL); |
| 1249 |
INSERT INTO glpi_dropdown_ram_type VALUES ('4','SDRAM-2',NULL); |
| 1250 |
|
| 1251 |
### Dump table glpi_dropdown_rubdocs
|
| 1252 |
|
| 1253 |
DROP TABLE IF EXISTS `glpi_dropdown_rubdocs`; |
| 1254 |
CREATE TABLE `glpi_dropdown_rubdocs` ( |
| 1255 |
`ID` int(11) NOT NULL auto_increment, |
| 1256 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1257 |
`comments` text collate utf8_unicode_ci, |
| 1258 |
PRIMARY KEY (`ID`), |
| 1259 |
KEY `name` (`name`) |
| 1260 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1261 |
|
| 1262 |
|
| 1263 |
### Dump table glpi_dropdown_software_category
|
| 1264 |
|
| 1265 |
DROP TABLE IF EXISTS `glpi_dropdown_software_category`; |
| 1266 |
CREATE TABLE `glpi_dropdown_software_category` ( |
| 1267 |
`ID` int(11) NOT NULL auto_increment, |
| 1268 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1269 |
`comments` text collate utf8_unicode_ci, |
| 1270 |
PRIMARY KEY (`ID`) |
| 1271 |
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1272 |
|
| 1273 |
INSERT INTO glpi_dropdown_software_category VALUES ('1','FUSION',NULL); |
| 1274 |
|
| 1275 |
### Dump table glpi_dropdown_state
|
| 1276 |
|
| 1277 |
DROP TABLE IF EXISTS `glpi_dropdown_state`; |
| 1278 |
CREATE TABLE `glpi_dropdown_state` ( |
| 1279 |
`ID` int(11) NOT NULL auto_increment, |
| 1280 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1281 |
`comments` text collate utf8_unicode_ci, |
| 1282 |
PRIMARY KEY (`ID`), |
| 1283 |
KEY `name` (`name`) |
| 1284 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1285 |
|
| 1286 |
|
| 1287 |
### Dump table glpi_dropdown_tracking_category
|
| 1288 |
|
| 1289 |
DROP TABLE IF EXISTS `glpi_dropdown_tracking_category`; |
| 1290 |
CREATE TABLE `glpi_dropdown_tracking_category` ( |
| 1291 |
`ID` int(11) NOT NULL auto_increment, |
| 1292 |
`parentID` int(11) NOT NULL default '0', |
| 1293 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1294 |
`completename` text collate utf8_unicode_ci, |
| 1295 |
`comments` text collate utf8_unicode_ci, |
| 1296 |
`level` int(11) NOT NULL default '0', |
| 1297 |
PRIMARY KEY (`ID`), |
| 1298 |
KEY `name` (`name`), |
| 1299 |
KEY `parentID` (`parentID`) |
| 1300 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1301 |
|
| 1302 |
|
| 1303 |
### Dump table glpi_dropdown_vlan
|
| 1304 |
|
| 1305 |
DROP TABLE IF EXISTS `glpi_dropdown_vlan`; |
| 1306 |
CREATE TABLE `glpi_dropdown_vlan` ( |
| 1307 |
`ID` int(11) NOT NULL auto_increment, |
| 1308 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1309 |
`comments` text collate utf8_unicode_ci, |
| 1310 |
PRIMARY KEY (`ID`), |
| 1311 |
KEY `name` (`name`) |
| 1312 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1313 |
|
| 1314 |
|
| 1315 |
### Dump table glpi_enterprises
|
| 1316 |
|
| 1317 |
DROP TABLE IF EXISTS `glpi_enterprises`; |
| 1318 |
CREATE TABLE `glpi_enterprises` ( |
| 1319 |
`ID` int(11) NOT NULL auto_increment, |
| 1320 |
`FK_entities` int(11) NOT NULL default '0', |
| 1321 |
`recursive` tinyint(1) NOT NULL default '0', |
| 1322 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1323 |
`type` int(11) NOT NULL default '0', |
| 1324 |
`address` text collate utf8_unicode_ci, |
| 1325 |
`postcode` varchar(255) collate utf8_unicode_ci default NULL, |
| 1326 |
`town` varchar(255) collate utf8_unicode_ci default NULL, |
| 1327 |
`state` varchar(255) collate utf8_unicode_ci default NULL, |
| 1328 |
`country` varchar(255) collate utf8_unicode_ci default NULL, |
| 1329 |
`website` varchar(255) collate utf8_unicode_ci default NULL, |
| 1330 |
`phonenumber` varchar(255) collate utf8_unicode_ci default NULL, |
| 1331 |
`comments` text collate utf8_unicode_ci, |
| 1332 |
`deleted` smallint(6) NOT NULL default '0', |
| 1333 |
`fax` varchar(255) collate utf8_unicode_ci default NULL, |
| 1334 |
`email` varchar(255) collate utf8_unicode_ci default NULL, |
| 1335 |
`notes` longtext collate utf8_unicode_ci, |
| 1336 |
PRIMARY KEY (`ID`), |
| 1337 |
KEY `type` (`type`), |
| 1338 |
KEY `name` (`name`), |
| 1339 |
KEY `FK_entities` (`FK_entities`), |
| 1340 |
KEY `deleted` (`deleted`) |
| 1341 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1342 |
|
| 1343 |
|
| 1344 |
### Dump table glpi_entities
|
| 1345 |
|
| 1346 |
DROP TABLE IF EXISTS `glpi_entities`; |
| 1347 |
CREATE TABLE `glpi_entities` ( |
| 1348 |
`ID` int(11) NOT NULL auto_increment, |
| 1349 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1350 |
`parentID` int(11) NOT NULL default '0', |
| 1351 |
`completename` text collate utf8_unicode_ci, |
| 1352 |
`comments` text collate utf8_unicode_ci, |
| 1353 |
`level` int(11) NOT NULL default '0', |
| 1354 |
PRIMARY KEY (`ID`), |
| 1355 |
UNIQUE KEY `name` (`name`,`parentID`), |
| 1356 |
KEY `parentID` (`parentID`) |
| 1357 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1358 |
|
| 1359 |
|
| 1360 |
### Dump table glpi_entities_data
|
| 1361 |
|
| 1362 |
DROP TABLE IF EXISTS `glpi_entities_data`; |
| 1363 |
CREATE TABLE `glpi_entities_data` ( |
| 1364 |
`ID` int(11) NOT NULL auto_increment, |
| 1365 |
`FK_entities` int(11) NOT NULL default '0', |
| 1366 |
`address` text collate utf8_unicode_ci, |
| 1367 |
`postcode` varchar(255) collate utf8_unicode_ci default NULL, |
| 1368 |
`town` varchar(255) collate utf8_unicode_ci default NULL, |
| 1369 |
`state` varchar(255) collate utf8_unicode_ci default NULL, |
| 1370 |
`country` varchar(255) collate utf8_unicode_ci default NULL, |
| 1371 |
`website` varchar(255) collate utf8_unicode_ci default NULL, |
| 1372 |
`phonenumber` varchar(255) collate utf8_unicode_ci default NULL, |
| 1373 |
`fax` varchar(255) collate utf8_unicode_ci default NULL, |
| 1374 |
`email` varchar(255) collate utf8_unicode_ci default NULL, |
| 1375 |
`admin_email` varchar(255) collate utf8_unicode_ci default NULL, |
| 1376 |
`admin_reply` varchar(255) collate utf8_unicode_ci default NULL, |
| 1377 |
`notes` longtext collate utf8_unicode_ci, |
| 1378 |
PRIMARY KEY (`ID`), |
| 1379 |
UNIQUE KEY `FK_entities` (`FK_entities`) |
| 1380 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1381 |
|
| 1382 |
|
| 1383 |
### Dump table glpi_event_log
|
| 1384 |
|
| 1385 |
DROP TABLE IF EXISTS `glpi_event_log`; |
| 1386 |
CREATE TABLE `glpi_event_log` ( |
| 1387 |
`ID` int(11) NOT NULL auto_increment, |
| 1388 |
`item` int(11) NOT NULL default '0', |
| 1389 |
`itemtype` varchar(255) collate utf8_unicode_ci default NULL, |
| 1390 |
`date` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1391 |
`service` varchar(255) collate utf8_unicode_ci default NULL, |
| 1392 |
`level` smallint(6) NOT NULL default '0', |
| 1393 |
`message` text collate utf8_unicode_ci, |
| 1394 |
PRIMARY KEY (`ID`), |
| 1395 |
KEY `comp` (`item`), |
| 1396 |
KEY `date` (`date`), |
| 1397 |
KEY `itemtype` (`itemtype`) |
| 1398 |
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1399 |
|
| 1400 |
|
| 1401 |
### Dump table glpi_followups
|
| 1402 |
|
| 1403 |
DROP TABLE IF EXISTS `glpi_followups`; |
| 1404 |
CREATE TABLE `glpi_followups` ( |
| 1405 |
`ID` int(11) NOT NULL auto_increment, |
| 1406 |
`tracking` int(11) default NULL, |
| 1407 |
`date` datetime default NULL, |
| 1408 |
`author` int(11) NOT NULL default '0', |
| 1409 |
`contents` text collate utf8_unicode_ci, |
| 1410 |
`private` int(1) NOT NULL default '0', |
| 1411 |
`realtime` float NOT NULL default '0', |
| 1412 |
PRIMARY KEY (`ID`), |
| 1413 |
KEY `tracking` (`tracking`), |
| 1414 |
KEY `author` (`author`), |
| 1415 |
KEY `date` (`date`) |
| 1416 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1417 |
|
| 1418 |
|
| 1419 |
### Dump table glpi_groups
|
| 1420 |
|
| 1421 |
DROP TABLE IF EXISTS `glpi_groups`; |
| 1422 |
CREATE TABLE `glpi_groups` ( |
| 1423 |
`ID` int(11) NOT NULL auto_increment, |
| 1424 |
`FK_entities` int(11) NOT NULL default '0', |
| 1425 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1426 |
`comments` text collate utf8_unicode_ci, |
| 1427 |
`FK_users` int(11) NOT NULL default '0', |
| 1428 |
`ldap_field` varchar(255) collate utf8_unicode_ci default NULL, |
| 1429 |
`ldap_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 1430 |
`ldap_group_dn` varchar(255) collate utf8_unicode_ci default NULL, |
| 1431 |
PRIMARY KEY (`ID`), |
| 1432 |
KEY `name` (`name`), |
| 1433 |
KEY `ldap_field` (`ldap_field`), |
| 1434 |
KEY `FK_entities` (`FK_entities`) |
| 1435 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1436 |
|
| 1437 |
|
| 1438 |
### Dump table glpi_history
|
| 1439 |
|
| 1440 |
DROP TABLE IF EXISTS `glpi_history`; |
| 1441 |
CREATE TABLE `glpi_history` ( |
| 1442 |
`ID` int(11) NOT NULL auto_increment, |
| 1443 |
`FK_glpi_device` int(11) NOT NULL default '0', |
| 1444 |
`device_type` smallint(6) NOT NULL default '0', |
| 1445 |
`device_internal_type` int(11) default '0', |
| 1446 |
`linked_action` smallint(6) NOT NULL default '0', |
| 1447 |
`user_name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1448 |
`date_mod` datetime default NULL, |
| 1449 |
`id_search_option` int(11) NOT NULL default '0', |
| 1450 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 1451 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 1452 |
PRIMARY KEY (`ID`), |
| 1453 |
KEY `FK_glpi_device` (`FK_glpi_device`), |
| 1454 |
KEY `device_type` (`device_type`), |
| 1455 |
KEY `device_internal_type` (`device_internal_type`), |
| 1456 |
KEY `date_mod` (`date_mod`) |
| 1457 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1458 |
|
| 1459 |
|
| 1460 |
### Dump table glpi_infocoms
|
| 1461 |
|
| 1462 |
DROP TABLE IF EXISTS `glpi_infocoms`; |
| 1463 |
CREATE TABLE `glpi_infocoms` ( |
| 1464 |
`ID` int(11) NOT NULL auto_increment, |
| 1465 |
`FK_device` int(11) NOT NULL default '0', |
| 1466 |
`device_type` smallint(6) NOT NULL default '0', |
| 1467 |
`buy_date` date NOT NULL default '0000-00-00', |
| 1468 |
`use_date` date NOT NULL default '0000-00-00', |
| 1469 |
`warranty_duration` smallint(6) NOT NULL default '0', |
| 1470 |
`warranty_info` varchar(255) collate utf8_unicode_ci default NULL, |
| 1471 |
`FK_enterprise` int(11) NOT NULL default '0', |
| 1472 |
`num_commande` varchar(255) collate utf8_unicode_ci default NULL, |
| 1473 |
`bon_livraison` varchar(255) collate utf8_unicode_ci default NULL, |
| 1474 |
`num_immo` varchar(255) collate utf8_unicode_ci default NULL, |
| 1475 |
`value` decimal(20,4) NOT NULL default '0.0000', |
| 1476 |
`warranty_value` decimal(20,4) NOT NULL default '0.0000', |
| 1477 |
`amort_time` smallint(6) NOT NULL default '0', |
| 1478 |
`amort_type` smallint(6) NOT NULL default '0', |
| 1479 |
`amort_coeff` float NOT NULL default '0', |
| 1480 |
`comments` text collate utf8_unicode_ci, |
| 1481 |
`facture` varchar(255) collate utf8_unicode_ci default NULL, |
| 1482 |
`budget` int(11) NOT NULL default '0', |
| 1483 |
`alert` smallint(6) NOT NULL default '0', |
| 1484 |
PRIMARY KEY (`ID`), |
| 1485 |
UNIQUE KEY `FK_device` (`FK_device`,`device_type`), |
| 1486 |
KEY `FK_enterprise` (`FK_enterprise`), |
| 1487 |
KEY `buy_date` (`buy_date`), |
| 1488 |
KEY `budget` (`budget`), |
| 1489 |
KEY `alert` (`alert`) |
| 1490 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1491 |
|
| 1492 |
|
| 1493 |
### Dump table glpi_inst_software
|
| 1494 |
|
| 1495 |
DROP TABLE IF EXISTS `glpi_inst_software`; |
| 1496 |
CREATE TABLE `glpi_inst_software` ( |
| 1497 |
`ID` int(11) NOT NULL auto_increment, |
| 1498 |
`cID` int(11) NOT NULL default '0', |
| 1499 |
`license` int(11) NOT NULL default '0', |
| 1500 |
PRIMARY KEY (`ID`), |
| 1501 |
KEY `cID` (`cID`), |
| 1502 |
KEY `sID` (`license`) |
| 1503 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1504 |
|
| 1505 |
|
| 1506 |
### Dump table glpi_kbitems
|
| 1507 |
|
| 1508 |
DROP TABLE IF EXISTS `glpi_kbitems`; |
| 1509 |
CREATE TABLE `glpi_kbitems` ( |
| 1510 |
`ID` int(11) NOT NULL auto_increment, |
| 1511 |
`FK_entities` int(11) NOT NULL default '0', |
| 1512 |
`recursive` tinyint(1) NOT NULL default '1', |
| 1513 |
`categoryID` int(11) NOT NULL default '0', |
| 1514 |
`question` text collate utf8_unicode_ci, |
| 1515 |
`answer` longtext collate utf8_unicode_ci, |
| 1516 |
`faq` smallint(6) NOT NULL default '0', |
| 1517 |
`author` int(11) NOT NULL default '0', |
| 1518 |
`view` int(11) NOT NULL default '0', |
| 1519 |
`date` datetime default NULL, |
| 1520 |
`date_mod` datetime default NULL, |
| 1521 |
PRIMARY KEY (`ID`), |
| 1522 |
KEY `categoryID` (`categoryID`), |
| 1523 |
KEY `author` (`author`), |
| 1524 |
KEY `faq` (`faq`), |
| 1525 |
KEY `FK_entities` (`FK_entities`), |
| 1526 |
FULLTEXT KEY `fulltext` (`question`,`answer`) |
| 1527 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1528 |
|
| 1529 |
|
| 1530 |
### Dump table glpi_licenses
|
| 1531 |
|
| 1532 |
DROP TABLE IF EXISTS `glpi_licenses`; |
| 1533 |
CREATE TABLE `glpi_licenses` ( |
| 1534 |
`ID` int(15) NOT NULL auto_increment, |
| 1535 |
`sID` int(15) NOT NULL default '0', |
| 1536 |
`version` varchar(255) collate utf8_unicode_ci default NULL, |
| 1537 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1538 |
`expire` date default NULL, |
| 1539 |
`oem` smallint(6) NOT NULL default '0', |
| 1540 |
`oem_computer` int(11) NOT NULL default '0', |
| 1541 |
`buy` smallint(6) NOT NULL default '1', |
| 1542 |
`comments` text collate utf8_unicode_ci, |
| 1543 |
PRIMARY KEY (`ID`), |
| 1544 |
KEY `sID` (`sID`), |
| 1545 |
KEY `oem_computer` (`oem_computer`), |
| 1546 |
KEY `serial` (`serial`), |
| 1547 |
KEY `expire` (`expire`), |
| 1548 |
KEY `oem` (`oem`), |
| 1549 |
KEY `buy` (`buy`) |
| 1550 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1551 |
|
| 1552 |
|
| 1553 |
### Dump table glpi_links
|
| 1554 |
|
| 1555 |
DROP TABLE IF EXISTS `glpi_links`; |
| 1556 |
CREATE TABLE `glpi_links` ( |
| 1557 |
`ID` int(11) NOT NULL auto_increment, |
| 1558 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1559 |
`link` varchar(255) collate utf8_unicode_ci default NULL, |
| 1560 |
`data` text collate utf8_unicode_ci, |
| 1561 |
PRIMARY KEY (`ID`) |
| 1562 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1563 |
|
| 1564 |
|
| 1565 |
### Dump table glpi_links_device
|
| 1566 |
|
| 1567 |
DROP TABLE IF EXISTS `glpi_links_device`; |
| 1568 |
CREATE TABLE `glpi_links_device` ( |
| 1569 |
`ID` int(11) NOT NULL auto_increment, |
| 1570 |
`FK_links` int(11) NOT NULL default '0', |
| 1571 |
`device_type` int(11) NOT NULL default '0', |
| 1572 |
PRIMARY KEY (`ID`), |
| 1573 |
UNIQUE KEY `device_type_2` (`device_type`,`FK_links`), |
| 1574 |
KEY `device_type` (`device_type`), |
| 1575 |
KEY `FK_links` (`FK_links`) |
| 1576 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1577 |
|
| 1578 |
|
| 1579 |
### Dump table glpi_mailgate
|
| 1580 |
|
| 1581 |
DROP TABLE IF EXISTS `glpi_mailgate`; |
| 1582 |
CREATE TABLE `glpi_mailgate` ( |
| 1583 |
`ID` int(11) NOT NULL auto_increment, |
| 1584 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1585 |
`FK_entities` int(11) NOT NULL default '0', |
| 1586 |
`host` varchar(255) collate utf8_unicode_ci default NULL, |
| 1587 |
`login` varchar(255) collate utf8_unicode_ci default NULL, |
| 1588 |
`password` varchar(255) collate utf8_unicode_ci default NULL, |
| 1589 |
PRIMARY KEY (`ID`) |
| 1590 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1591 |
|
| 1592 |
|
| 1593 |
### Dump table glpi_mailing
|
| 1594 |
|
| 1595 |
DROP TABLE IF EXISTS `glpi_mailing`; |
| 1596 |
CREATE TABLE `glpi_mailing` ( |
| 1597 |
`ID` int(11) NOT NULL auto_increment, |
| 1598 |
`type` varchar(255) collate utf8_unicode_ci default NULL, |
| 1599 |
`FK_item` int(11) NOT NULL default '0', |
| 1600 |
`item_type` int(11) NOT NULL default '0', |
| 1601 |
PRIMARY KEY (`ID`), |
| 1602 |
UNIQUE KEY `mailings` (`type`,`FK_item`,`item_type`), |
| 1603 |
KEY `type` (`type`), |
| 1604 |
KEY `FK_item` (`FK_item`), |
| 1605 |
KEY `item_type` (`item_type`), |
| 1606 |
KEY `items` (`item_type`,`FK_item`) |
| 1607 |
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1608 |
|
| 1609 |
INSERT INTO glpi_mailing VALUES ('1','resa','3','1'); |
| 1610 |
INSERT INTO glpi_mailing VALUES ('2','resa','1','1'); |
| 1611 |
INSERT INTO glpi_mailing VALUES ('3','new','3','2'); |
| 1612 |
INSERT INTO glpi_mailing VALUES ('4','new','1','1'); |
| 1613 |
INSERT INTO glpi_mailing VALUES ('5','update','1','1'); |
| 1614 |
INSERT INTO glpi_mailing VALUES ('6','followup','1','1'); |
| 1615 |
INSERT INTO glpi_mailing VALUES ('7','finish','1','1'); |
| 1616 |
INSERT INTO glpi_mailing VALUES ('8','update','2','1'); |
| 1617 |
INSERT INTO glpi_mailing VALUES ('9','update','4','1'); |
| 1618 |
INSERT INTO glpi_mailing VALUES ('10','new','3','1'); |
| 1619 |
INSERT INTO glpi_mailing VALUES ('11','update','3','1'); |
| 1620 |
INSERT INTO glpi_mailing VALUES ('12','followup','3','1'); |
| 1621 |
INSERT INTO glpi_mailing VALUES ('13','finish','3','1'); |
| 1622 |
|
| 1623 |
### Dump table glpi_monitors
|
| 1624 |
|
| 1625 |
DROP TABLE IF EXISTS `glpi_monitors`; |
| 1626 |
CREATE TABLE `glpi_monitors` ( |
| 1627 |
`ID` int(10) NOT NULL auto_increment, |
| 1628 |
`FK_entities` int(11) NOT NULL default '0', |
| 1629 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1630 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1631 |
`contact` varchar(255) collate utf8_unicode_ci default NULL, |
| 1632 |
`contact_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 1633 |
`tech_num` int(11) NOT NULL default '0', |
| 1634 |
`comments` text collate utf8_unicode_ci, |
| 1635 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1636 |
`otherserial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1637 |
`size` int(3) NOT NULL default '0', |
| 1638 |
`flags_micro` smallint(6) NOT NULL default '0', |
| 1639 |
`flags_speaker` smallint(6) NOT NULL default '0', |
| 1640 |
`flags_subd` smallint(6) NOT NULL default '0', |
| 1641 |
`flags_bnc` smallint(6) NOT NULL default '0', |
| 1642 |
`flags_dvi` smallint(6) NOT NULL default '0', |
| 1643 |
`flags_pivot` smallint(6) NOT NULL default '0', |
| 1644 |
`location` int(11) NOT NULL default '0', |
| 1645 |
`type` int(11) NOT NULL default '0', |
| 1646 |
`model` int(11) NOT NULL default '0', |
| 1647 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 1648 |
`is_global` smallint(6) NOT NULL default '0', |
| 1649 |
`deleted` smallint(6) NOT NULL default '0', |
| 1650 |
`is_template` smallint(6) NOT NULL default '0', |
| 1651 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 1652 |
`notes` longtext collate utf8_unicode_ci, |
| 1653 |
`FK_users` int(11) NOT NULL default '0', |
| 1654 |
`FK_groups` int(11) NOT NULL default '0', |
| 1655 |
`state` int(11) NOT NULL default '0', |
| 1656 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 1657 |
PRIMARY KEY (`ID`), |
| 1658 |
KEY `ID` (`ID`), |
| 1659 |
KEY `location` (`location`), |
| 1660 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 1661 |
KEY `tech_num` (`tech_num`), |
| 1662 |
KEY `name` (`name`), |
| 1663 |
KEY `type` (`type`), |
| 1664 |
KEY `model` (`model`), |
| 1665 |
KEY `FK_groups` (`FK_groups`), |
| 1666 |
KEY `FK_users` (`FK_users`), |
| 1667 |
KEY `FK_entities` (`FK_entities`), |
| 1668 |
KEY `is_template` (`is_template`), |
| 1669 |
KEY `is_global` (`is_global`), |
| 1670 |
KEY `deleted` (`deleted`) |
| 1671 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1672 |
|
| 1673 |
|
| 1674 |
### Dump table glpi_networking
|
| 1675 |
|
| 1676 |
DROP TABLE IF EXISTS `glpi_networking`; |
| 1677 |
CREATE TABLE `glpi_networking` ( |
| 1678 |
`ID` int(11) NOT NULL auto_increment, |
| 1679 |
`FK_entities` int(11) NOT NULL default '0', |
| 1680 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1681 |
`ram` varchar(255) collate utf8_unicode_ci default NULL, |
| 1682 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1683 |
`otherserial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1684 |
`contact` varchar(255) collate utf8_unicode_ci default NULL, |
| 1685 |
`contact_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 1686 |
`tech_num` int(11) NOT NULL default '0', |
| 1687 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1688 |
`comments` text collate utf8_unicode_ci, |
| 1689 |
`location` int(11) NOT NULL default '0', |
| 1690 |
`domain` int(11) NOT NULL default '0', |
| 1691 |
`network` int(11) NOT NULL default '0', |
| 1692 |
`type` int(11) NOT NULL default '0', |
| 1693 |
`model` int(11) NOT NULL default '0', |
| 1694 |
`firmware` int(11) NOT NULL default '0', |
| 1695 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 1696 |
`deleted` smallint(6) NOT NULL default '0', |
| 1697 |
`is_template` smallint(6) NOT NULL default '0', |
| 1698 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 1699 |
`ifmac` varchar(255) collate utf8_unicode_ci default NULL, |
| 1700 |
`ifaddr` varchar(255) collate utf8_unicode_ci default NULL, |
| 1701 |
`notes` longtext collate utf8_unicode_ci, |
| 1702 |
`FK_users` int(11) NOT NULL default '0', |
| 1703 |
`FK_groups` int(11) NOT NULL default '0', |
| 1704 |
`state` int(11) NOT NULL default '0', |
| 1705 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 1706 |
PRIMARY KEY (`ID`), |
| 1707 |
KEY `location` (`location`), |
| 1708 |
KEY `firmware` (`firmware`), |
| 1709 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 1710 |
KEY `tech_num` (`tech_num`), |
| 1711 |
KEY `name` (`name`), |
| 1712 |
KEY `type` (`type`), |
| 1713 |
KEY `model` (`model`), |
| 1714 |
KEY `FK_groups` (`FK_groups`), |
| 1715 |
KEY `FK_users` (`FK_users`), |
| 1716 |
KEY `network` (`network`), |
| 1717 |
KEY `domain` (`domain`), |
| 1718 |
KEY `FK_entities` (`FK_entities`), |
| 1719 |
KEY `is_template` (`is_template`), |
| 1720 |
KEY `deleted` (`deleted`) |
| 1721 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1722 |
|
| 1723 |
|
| 1724 |
### Dump table glpi_networking_ports
|
| 1725 |
|
| 1726 |
DROP TABLE IF EXISTS `glpi_networking_ports`; |
| 1727 |
CREATE TABLE `glpi_networking_ports` ( |
| 1728 |
`ID` int(11) NOT NULL auto_increment, |
| 1729 |
`on_device` int(11) NOT NULL default '0', |
| 1730 |
`device_type` smallint(6) NOT NULL default '0', |
| 1731 |
`logical_number` int(11) NOT NULL default '0', |
| 1732 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1733 |
`ifaddr` varchar(255) collate utf8_unicode_ci default NULL, |
| 1734 |
`ifmac` varchar(255) collate utf8_unicode_ci default NULL, |
| 1735 |
`iface` int(11) NOT NULL default '0', |
| 1736 |
`netpoint` int(11) NOT NULL default '0', |
| 1737 |
`netmask` varchar(255) collate utf8_unicode_ci default NULL, |
| 1738 |
`gateway` varchar(255) collate utf8_unicode_ci default NULL, |
| 1739 |
`subnet` varchar(255) collate utf8_unicode_ci default NULL, |
| 1740 |
PRIMARY KEY (`ID`), |
| 1741 |
KEY `on_device` (`on_device`,`device_type`), |
| 1742 |
KEY `netpoint` (`netpoint`), |
| 1743 |
KEY `on_device_2` (`on_device`), |
| 1744 |
KEY `device_type` (`device_type`), |
| 1745 |
KEY `iface` (`iface`) |
| 1746 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1747 |
|
| 1748 |
|
| 1749 |
### Dump table glpi_networking_vlan
|
| 1750 |
|
| 1751 |
DROP TABLE IF EXISTS `glpi_networking_vlan`; |
| 1752 |
CREATE TABLE `glpi_networking_vlan` ( |
| 1753 |
`ID` int(11) NOT NULL auto_increment, |
| 1754 |
`FK_port` int(11) NOT NULL default '0', |
| 1755 |
`FK_vlan` int(11) NOT NULL default '0', |
| 1756 |
PRIMARY KEY (`ID`), |
| 1757 |
UNIQUE KEY `FK_port_2` (`FK_port`,`FK_vlan`), |
| 1758 |
KEY `FK_port` (`FK_port`), |
| 1759 |
KEY `FK_vlan` (`FK_vlan`) |
| 1760 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1761 |
|
| 1762 |
|
| 1763 |
### Dump table glpi_networking_wire
|
| 1764 |
|
| 1765 |
DROP TABLE IF EXISTS `glpi_networking_wire`; |
| 1766 |
CREATE TABLE `glpi_networking_wire` ( |
| 1767 |
`ID` int(11) NOT NULL auto_increment, |
| 1768 |
`end1` int(11) NOT NULL default '0', |
| 1769 |
`end2` int(11) NOT NULL default '0', |
| 1770 |
PRIMARY KEY (`ID`), |
| 1771 |
UNIQUE KEY `end1_1` (`end1`,`end2`), |
| 1772 |
KEY `end1` (`end1`), |
| 1773 |
KEY `end2` (`end2`) |
| 1774 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1775 |
|
| 1776 |
|
| 1777 |
### Dump table glpi_ocs_admin_link
|
| 1778 |
|
| 1779 |
DROP TABLE IF EXISTS `glpi_ocs_admin_link`; |
| 1780 |
CREATE TABLE `glpi_ocs_admin_link` ( |
| 1781 |
`ID` int(10) unsigned NOT NULL auto_increment, |
| 1782 |
`glpi_column` varchar(255) collate utf8_unicode_ci default NULL, |
| 1783 |
`ocs_column` varchar(255) collate utf8_unicode_ci default NULL, |
| 1784 |
`ocs_server_id` int(11) NOT NULL, |
| 1785 |
PRIMARY KEY (`ID`) |
| 1786 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1787 |
|
| 1788 |
|
| 1789 |
### Dump table glpi_ocs_config
|
| 1790 |
|
| 1791 |
DROP TABLE IF EXISTS `glpi_ocs_config`; |
| 1792 |
CREATE TABLE `glpi_ocs_config` ( |
| 1793 |
`ID` int(11) NOT NULL auto_increment, |
| 1794 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1795 |
`ocs_db_user` varchar(255) collate utf8_unicode_ci default NULL, |
| 1796 |
`ocs_db_passwd` varchar(255) collate utf8_unicode_ci default NULL, |
| 1797 |
`ocs_db_host` varchar(255) collate utf8_unicode_ci default NULL, |
| 1798 |
`ocs_db_name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1799 |
`checksum` int(11) NOT NULL default '0', |
| 1800 |
`import_periph` int(2) NOT NULL default '0', |
| 1801 |
`import_monitor` int(2) NOT NULL default '0', |
| 1802 |
`import_software` int(2) NOT NULL default '0', |
| 1803 |
`import_software_buy` int(11) NOT NULL default '1', |
| 1804 |
`import_software_licensetype` varchar(255) collate utf8_unicode_ci default 'global', |
| 1805 |
`import_printer` int(2) NOT NULL default '0', |
| 1806 |
`import_general_name` int(2) NOT NULL default '0', |
| 1807 |
`import_general_os` int(2) NOT NULL default '0', |
| 1808 |
`import_general_serial` int(2) NOT NULL default '0', |
| 1809 |
`import_general_model` int(2) NOT NULL default '0', |
| 1810 |
`import_general_enterprise` int(2) NOT NULL default '0', |
| 1811 |
`import_general_type` int(2) NOT NULL default '0', |
| 1812 |
`import_general_domain` int(2) NOT NULL default '0', |
| 1813 |
`import_general_contact` int(2) NOT NULL default '0', |
| 1814 |
`import_general_comments` int(2) NOT NULL default '0', |
| 1815 |
`import_device_processor` int(2) NOT NULL default '0', |
| 1816 |
`import_device_memory` int(2) NOT NULL default '0', |
| 1817 |
`import_device_hdd` int(2) NOT NULL default '0', |
| 1818 |
`import_device_iface` int(2) NOT NULL default '0', |
| 1819 |
`import_device_gfxcard` int(2) NOT NULL default '0', |
| 1820 |
`import_device_sound` int(2) NOT NULL default '0', |
| 1821 |
`import_device_drives` int(2) NOT NULL default '0', |
| 1822 |
`import_device_ports` int(2) NOT NULL default '0', |
| 1823 |
`import_device_modems` int(2) NOT NULL default '0', |
| 1824 |
`import_registry` int(11) NOT NULL default '0', |
| 1825 |
`import_os_serial` int(2) default NULL, |
| 1826 |
`import_ip` int(2) NOT NULL default '0', |
| 1827 |
`import_monitor_comments` int(2) NOT NULL default '0', |
| 1828 |
`import_software_comments` int(11) NOT NULL default '0', |
| 1829 |
`default_state` int(11) NOT NULL default '0', |
| 1830 |
`tag_limit` varchar(255) collate utf8_unicode_ci default NULL, |
| 1831 |
`use_soft_dict` char(1) collate utf8_unicode_ci default '1', |
| 1832 |
`cron_sync_number` int(11) default '1', |
| 1833 |
`is_template` smallint(6) NOT NULL default '0', |
| 1834 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 1835 |
`date_mod` datetime default NULL, |
| 1836 |
`deconnection_behavior` varchar(255) collate utf8_unicode_ci default NULL, |
| 1837 |
`glpi_link_enabled` int(1) NOT NULL, |
| 1838 |
`link_ip` int(1) NOT NULL, |
| 1839 |
`link_name` int(1) NOT NULL, |
| 1840 |
`link_mac_address` int(1) NOT NULL, |
| 1841 |
`link_serial` int(1) NOT NULL, |
| 1842 |
`link_if_status` int(11) NOT NULL default '0', |
| 1843 |
`ocs_url` varchar(255) collate utf8_unicode_ci default NULL, |
| 1844 |
PRIMARY KEY (`ID`), |
| 1845 |
KEY `is_template` (`is_template`) |
| 1846 |
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1847 |
|
| 1848 |
INSERT INTO glpi_ocs_config VALUES ('1','localhost','ocs','ocs','localhost','ocsweb','0','0','0','0','1','global','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',NULL,'0','0','0','0','','1','1','0',NULL,NULL,NULL,'0','0','0','0','0','0',''); |
| 1849 |
|
| 1850 |
### Dump table glpi_ocs_link
|
| 1851 |
|
| 1852 |
DROP TABLE IF EXISTS `glpi_ocs_link`; |
| 1853 |
CREATE TABLE `glpi_ocs_link` ( |
| 1854 |
`ID` int(11) NOT NULL auto_increment, |
| 1855 |
`glpi_id` int(11) NOT NULL default '0', |
| 1856 |
`ocs_id` int(11) NOT NULL default '0', |
| 1857 |
`ocs_deviceid` varchar(255) collate utf8_unicode_ci default NULL, |
| 1858 |
`auto_update` int(2) NOT NULL default '1', |
| 1859 |
`last_update` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1860 |
`last_ocs_update` datetime default NULL, |
| 1861 |
`computer_update` longtext collate utf8_unicode_ci, |
| 1862 |
`import_device` longtext collate utf8_unicode_ci, |
| 1863 |
`import_software` longtext collate utf8_unicode_ci, |
| 1864 |
`import_monitor` longtext collate utf8_unicode_ci, |
| 1865 |
`import_peripheral` longtext collate utf8_unicode_ci, |
| 1866 |
`import_printers` longtext collate utf8_unicode_ci, |
| 1867 |
`ocs_server_id` int(11) NOT NULL default '0', |
| 1868 |
`import_ip` longtext collate utf8_unicode_ci, |
| 1869 |
`ocs_agent_version` varchar(255) collate utf8_unicode_ci default NULL, |
| 1870 |
PRIMARY KEY (`ID`), |
| 1871 |
UNIQUE KEY `ocs_server_id` (`ocs_server_id`,`ocs_id`), |
| 1872 |
KEY `glpi_id` (`glpi_id`), |
| 1873 |
KEY `auto_update` (`auto_update`), |
| 1874 |
KEY `last_update` (`last_update`), |
| 1875 |
KEY `ocs_deviceid` (`ocs_deviceid`), |
| 1876 |
KEY `last_ocs_update` (`ocs_server_id`,`last_ocs_update`) |
| 1877 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1878 |
|
| 1879 |
|
| 1880 |
### Dump table glpi_peripherals
|
| 1881 |
|
| 1882 |
DROP TABLE IF EXISTS `glpi_peripherals`; |
| 1883 |
CREATE TABLE `glpi_peripherals` ( |
| 1884 |
`ID` int(11) NOT NULL auto_increment, |
| 1885 |
`FK_entities` int(11) NOT NULL default '0', |
| 1886 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1887 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1888 |
`contact` varchar(255) collate utf8_unicode_ci default NULL, |
| 1889 |
`contact_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 1890 |
`tech_num` int(11) NOT NULL default '0', |
| 1891 |
`comments` text collate utf8_unicode_ci, |
| 1892 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1893 |
`otherserial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1894 |
`location` int(11) NOT NULL default '0', |
| 1895 |
`type` int(11) NOT NULL default '0', |
| 1896 |
`model` int(11) NOT NULL default '0', |
| 1897 |
`brand` varchar(255) collate utf8_unicode_ci default NULL, |
| 1898 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 1899 |
`is_global` smallint(6) NOT NULL default '0', |
| 1900 |
`deleted` smallint(6) NOT NULL default '0', |
| 1901 |
`is_template` smallint(6) NOT NULL default '0', |
| 1902 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 1903 |
`notes` longtext collate utf8_unicode_ci, |
| 1904 |
`FK_users` int(11) NOT NULL default '0', |
| 1905 |
`FK_groups` int(11) NOT NULL default '0', |
| 1906 |
`state` int(11) NOT NULL default '0', |
| 1907 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 1908 |
PRIMARY KEY (`ID`), |
| 1909 |
KEY `location` (`location`), |
| 1910 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 1911 |
KEY `tech_num` (`tech_num`), |
| 1912 |
KEY `name` (`name`), |
| 1913 |
KEY `type` (`type`), |
| 1914 |
KEY `model` (`model`), |
| 1915 |
KEY `FK_groups` (`FK_groups`), |
| 1916 |
KEY `FK_users` (`FK_users`), |
| 1917 |
KEY `FK_entities` (`FK_entities`), |
| 1918 |
KEY `is_template` (`is_template`), |
| 1919 |
KEY `is_global` (`is_global`), |
| 1920 |
KEY `deleted` (`deleted`) |
| 1921 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1922 |
|
| 1923 |
|
| 1924 |
### Dump table glpi_phones
|
| 1925 |
|
| 1926 |
DROP TABLE IF EXISTS `glpi_phones`; |
| 1927 |
CREATE TABLE `glpi_phones` ( |
| 1928 |
`ID` int(11) NOT NULL auto_increment, |
| 1929 |
`FK_entities` int(11) NOT NULL default '0', |
| 1930 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1931 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1932 |
`contact` varchar(255) collate utf8_unicode_ci default NULL, |
| 1933 |
`contact_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 1934 |
`tech_num` int(11) NOT NULL default '0', |
| 1935 |
`comments` text collate utf8_unicode_ci, |
| 1936 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1937 |
`otherserial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1938 |
`firmware` varchar(255) collate utf8_unicode_ci default NULL, |
| 1939 |
`location` int(11) NOT NULL default '0', |
| 1940 |
`type` int(11) NOT NULL default '0', |
| 1941 |
`model` int(11) NOT NULL default '0', |
| 1942 |
`brand` varchar(255) collate utf8_unicode_ci default NULL, |
| 1943 |
`power` int(11) NOT NULL default '0', |
| 1944 |
`number_line` varchar(255) collate utf8_unicode_ci default NULL, |
| 1945 |
`flags_casque` smallint(6) NOT NULL default '0', |
| 1946 |
`flags_hp` smallint(6) NOT NULL default '0', |
| 1947 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 1948 |
`is_global` smallint(6) NOT NULL default '0', |
| 1949 |
`deleted` smallint(6) NOT NULL default '0', |
| 1950 |
`is_template` smallint(6) NOT NULL default '0', |
| 1951 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 1952 |
`notes` longtext collate utf8_unicode_ci, |
| 1953 |
`FK_users` int(11) NOT NULL default '0', |
| 1954 |
`FK_groups` int(11) NOT NULL default '0', |
| 1955 |
`state` int(11) NOT NULL default '0', |
| 1956 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 1957 |
PRIMARY KEY (`ID`), |
| 1958 |
KEY `name` (`name`), |
| 1959 |
KEY `location` (`location`), |
| 1960 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 1961 |
KEY `tech_num` (`tech_num`), |
| 1962 |
KEY `type` (`type`), |
| 1963 |
KEY `model` (`model`), |
| 1964 |
KEY `FK_groups` (`FK_groups`), |
| 1965 |
KEY `FK_users` (`FK_users`), |
| 1966 |
KEY `power` (`power`), |
| 1967 |
KEY `FK_entities` (`FK_entities`), |
| 1968 |
KEY `is_template` (`is_template`), |
| 1969 |
KEY `is_global` (`is_global`), |
| 1970 |
KEY `deleted` (`deleted`) |
| 1971 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1972 |
|
| 1973 |
|
| 1974 |
### Dump table glpi_printers
|
| 1975 |
|
| 1976 |
DROP TABLE IF EXISTS `glpi_printers`; |
| 1977 |
CREATE TABLE `glpi_printers` ( |
| 1978 |
`ID` int(10) NOT NULL auto_increment, |
| 1979 |
`FK_entities` int(11) NOT NULL default '0', |
| 1980 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 1981 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1982 |
`contact` varchar(255) collate utf8_unicode_ci default NULL, |
| 1983 |
`contact_num` varchar(255) collate utf8_unicode_ci default NULL, |
| 1984 |
`tech_num` int(11) NOT NULL default '0', |
| 1985 |
`serial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1986 |
`otherserial` varchar(255) collate utf8_unicode_ci default NULL, |
| 1987 |
`flags_serial` smallint(6) NOT NULL default '0', |
| 1988 |
`flags_par` smallint(6) NOT NULL default '0', |
| 1989 |
`flags_usb` smallint(6) NOT NULL default '0', |
| 1990 |
`comments` text collate utf8_unicode_ci, |
| 1991 |
`ramSize` varchar(255) collate utf8_unicode_ci default NULL, |
| 1992 |
`location` int(11) NOT NULL default '0', |
| 1993 |
`domain` int(11) NOT NULL default '0', |
| 1994 |
`network` int(11) NOT NULL default '0', |
| 1995 |
`type` int(11) NOT NULL default '0', |
| 1996 |
`model` int(11) NOT NULL default '0', |
| 1997 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 1998 |
`is_global` smallint(6) NOT NULL default '0', |
| 1999 |
`deleted` smallint(6) NOT NULL default '0', |
| 2000 |
`is_template` smallint(6) NOT NULL default '0', |
| 2001 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 2002 |
`initial_pages` varchar(255) collate utf8_unicode_ci default NULL, |
| 2003 |
`notes` longtext collate utf8_unicode_ci, |
| 2004 |
`FK_users` int(11) NOT NULL default '0', |
| 2005 |
`FK_groups` int(11) NOT NULL default '0', |
| 2006 |
`state` int(11) NOT NULL default '0', |
| 2007 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 2008 |
PRIMARY KEY (`ID`), |
| 2009 |
KEY `location` (`location`), |
| 2010 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 2011 |
KEY `tech_num` (`tech_num`), |
| 2012 |
KEY `name` (`name`), |
| 2013 |
KEY `type` (`type`), |
| 2014 |
KEY `model` (`model`), |
| 2015 |
KEY `FK_groups` (`FK_groups`), |
| 2016 |
KEY `FK_users` (`FK_users`), |
| 2017 |
KEY `network` (`network`), |
| 2018 |
KEY `domain` (`domain`), |
| 2019 |
KEY `FK_entities` (`FK_entities`), |
| 2020 |
KEY `is_template` (`is_template`), |
| 2021 |
KEY `is_global` (`is_global`), |
| 2022 |
KEY `deleted` (`deleted`) |
| 2023 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2024 |
|
| 2025 |
|
| 2026 |
### Dump table glpi_profiles
|
| 2027 |
|
| 2028 |
DROP TABLE IF EXISTS `glpi_profiles`; |
| 2029 |
CREATE TABLE `glpi_profiles` ( |
| 2030 |
`ID` int(11) NOT NULL auto_increment, |
| 2031 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2032 |
`interface` varchar(255) collate utf8_unicode_ci default 'helpdesk', |
| 2033 |
`is_default` smallint(6) NOT NULL default '0', |
| 2034 |
`computer` char(1) collate utf8_unicode_ci default NULL, |
| 2035 |
`monitor` char(1) collate utf8_unicode_ci default NULL, |
| 2036 |
`software` char(1) collate utf8_unicode_ci default NULL, |
| 2037 |
`networking` char(1) collate utf8_unicode_ci default NULL, |
| 2038 |
`printer` char(1) collate utf8_unicode_ci default NULL, |
| 2039 |
`peripheral` char(1) collate utf8_unicode_ci default NULL, |
| 2040 |
`cartridge` char(1) collate utf8_unicode_ci default NULL, |
| 2041 |
`consumable` char(1) collate utf8_unicode_ci default NULL, |
| 2042 |
`phone` char(1) collate utf8_unicode_ci default NULL, |
| 2043 |
`notes` char(1) collate utf8_unicode_ci default NULL, |
| 2044 |
`contact_enterprise` char(1) collate utf8_unicode_ci default NULL, |
| 2045 |
`document` char(1) collate utf8_unicode_ci default NULL, |
| 2046 |
`contract_infocom` char(1) collate utf8_unicode_ci default NULL, |
| 2047 |
`knowbase` char(1) collate utf8_unicode_ci default NULL, |
| 2048 |
`faq` char(1) collate utf8_unicode_ci default NULL, |
| 2049 |
`reservation_helpdesk` char(1) collate utf8_unicode_ci default NULL, |
| 2050 |
`reservation_central` char(1) collate utf8_unicode_ci default NULL, |
| 2051 |
`reports` char(1) collate utf8_unicode_ci default NULL, |
| 2052 |
`ocsng` char(1) collate utf8_unicode_ci default NULL, |
| 2053 |
`view_ocsng` char(1) collate utf8_unicode_ci default NULL, |
| 2054 |
`sync_ocsng` char(1) collate utf8_unicode_ci default NULL, |
| 2055 |
`dropdown` char(1) collate utf8_unicode_ci default NULL, |
| 2056 |
`entity_dropdown` char(1) collate utf8_unicode_ci default NULL, |
| 2057 |
`device` char(1) collate utf8_unicode_ci default NULL, |
| 2058 |
`typedoc` char(1) collate utf8_unicode_ci default NULL, |
| 2059 |
`link` char(1) collate utf8_unicode_ci default NULL, |
| 2060 |
`config` char(1) collate utf8_unicode_ci default NULL, |
| 2061 |
`rule_tracking` char(1) collate utf8_unicode_ci default NULL, |
| 2062 |
`rule_ocs` char(1) collate utf8_unicode_ci default NULL, |
| 2063 |
`rule_ldap` char(1) collate utf8_unicode_ci default NULL, |
| 2064 |
`rule_softwarecategories` char(1) collate utf8_unicode_ci default NULL, |
| 2065 |
`search_config` char(1) collate utf8_unicode_ci default NULL, |
| 2066 |
`search_config_global` char(1) collate utf8_unicode_ci default NULL, |
| 2067 |
`check_update` char(1) collate utf8_unicode_ci default NULL, |
| 2068 |
`profile` char(1) collate utf8_unicode_ci default NULL, |
| 2069 |
`user` char(1) collate utf8_unicode_ci default NULL, |
| 2070 |
`user_auth_method` char(1) collate utf8_unicode_ci default NULL, |
| 2071 |
`group` char(1) collate utf8_unicode_ci default NULL, |
| 2072 |
`entity` char(1) collate utf8_unicode_ci default NULL, |
| 2073 |
`transfer` char(1) collate utf8_unicode_ci default NULL, |
| 2074 |
`logs` char(1) collate utf8_unicode_ci default NULL, |
| 2075 |
`reminder_public` char(1) collate utf8_unicode_ci default NULL, |
| 2076 |
`bookmark_public` char(1) collate utf8_unicode_ci default NULL, |
| 2077 |
`backup` char(1) collate utf8_unicode_ci default NULL, |
| 2078 |
`create_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2079 |
`delete_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2080 |
`comment_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2081 |
`comment_all_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2082 |
`update_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2083 |
`own_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2084 |
`steal_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2085 |
`assign_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2086 |
`show_all_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2087 |
`show_assign_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2088 |
`show_full_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2089 |
`observe_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2090 |
`update_followups` char(1) collate utf8_unicode_ci default NULL, |
| 2091 |
`show_planning` char(1) collate utf8_unicode_ci default NULL, |
| 2092 |
`show_group_planning` char(1) collate utf8_unicode_ci default NULL, |
| 2093 |
`show_all_planning` char(1) collate utf8_unicode_ci default NULL, |
| 2094 |
`statistic` char(1) collate utf8_unicode_ci default NULL, |
| 2095 |
`password_update` char(1) collate utf8_unicode_ci default NULL, |
| 2096 |
`helpdesk_hardware` smallint(6) NOT NULL default '0', |
| 2097 |
`helpdesk_hardware_type` int(11) NOT NULL default '0', |
| 2098 |
`show_group_ticket` char(1) collate utf8_unicode_ci default NULL, |
| 2099 |
`show_group_hardware` char(1) collate utf8_unicode_ci default NULL, |
| 2100 |
`rule_dictionnary_software` varchar(1) collate utf8_unicode_ci default NULL, |
| 2101 |
`rule_dictionnary_dropdown` varchar(1) collate utf8_unicode_ci default NULL, |
| 2102 |
PRIMARY KEY (`ID`), |
| 2103 |
KEY `interface` (`interface`) |
| 2104 |
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2105 |
|
| 2106 |
INSERT INTO glpi_profiles VALUES ('1','post-only','helpdesk','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'r','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,'1','1','8388674','0','0',NULL,NULL); |
| 2107 |
INSERT INTO glpi_profiles VALUES ('2','normal','central','0','r','r','r','r','r','r','r','r','r','r','r','r','r','r','r','1','r','r',NULL,'r',NULL,NULL,NULL,NULL,'r','r',NULL,NULL,NULL,NULL,NULL,'w',NULL,'r',NULL,'r','r','r',NULL,NULL,NULL,NULL,NULL,NULL,'1','1','1','0','0','1','0','0','1','1','0','1','0','1','0','0','1','1','1','8388674','0','0',NULL,NULL); |
| 2108 |
INSERT INTO glpi_profiles VALUES ('3','admin','central','0','w','w','w','w','w','w','w','w','w','w','w','w','w','w','w','1','w','r','w','r','w','w','w','w','w','w',NULL,NULL,NULL,NULL,NULL,'w','w','r','r','w','w','w',NULL,NULL,NULL,NULL,NULL,NULL,'1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','3','8388674','0','0',NULL,NULL); |
| 2109 |
INSERT INTO glpi_profiles VALUES ('4','super-admin','central','0','w','w','w','w','w','w','w','w','w','w','w','w','w','w','w','1','w','r','w','r','w','w','w','w','w','w','w','w','w','w','w','w','w','r','w','w','w','w','w','w','r','w','w','w','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','3','8388674','0','0','w','w'); |
| 2110 |
|
| 2111 |
### Dump table glpi_registry
|
| 2112 |
|
| 2113 |
DROP TABLE IF EXISTS `glpi_registry`; |
| 2114 |
CREATE TABLE `glpi_registry` ( |
| 2115 |
`ID` int(10) NOT NULL auto_increment, |
| 2116 |
`computer_id` int(10) NOT NULL default '0', |
| 2117 |
`registry_hive` varchar(255) collate utf8_unicode_ci default NULL, |
| 2118 |
`registry_path` varchar(255) collate utf8_unicode_ci default NULL, |
| 2119 |
`registry_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2120 |
`registry_ocs_name` char(255) collate utf8_unicode_ci default NULL, |
| 2121 |
PRIMARY KEY (`ID`), |
| 2122 |
KEY `computer_id` (`computer_id`) |
| 2123 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2124 |
|
| 2125 |
|
| 2126 |
### Dump table glpi_reminder
|
| 2127 |
|
| 2128 |
DROP TABLE IF EXISTS `glpi_reminder`; |
| 2129 |
CREATE TABLE `glpi_reminder` ( |
| 2130 |
`ID` int(11) NOT NULL auto_increment, |
| 2131 |
`FK_entities` int(11) NOT NULL default '0', |
| 2132 |
`date` datetime default NULL, |
| 2133 |
`FK_users` int(11) NOT NULL default '0', |
| 2134 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2135 |
`text` text collate utf8_unicode_ci, |
| 2136 |
`private` tinyint(1) NOT NULL default '1', |
| 2137 |
`recursive` tinyint(1) NOT NULL default '0', |
| 2138 |
`begin` datetime default NULL, |
| 2139 |
`end` datetime default NULL, |
| 2140 |
`rv` smallint(6) NOT NULL default '0', |
| 2141 |
`date_mod` datetime default NULL, |
| 2142 |
`state` smallint(6) NOT NULL default '0', |
| 2143 |
PRIMARY KEY (`ID`), |
| 2144 |
KEY `date` (`date`), |
| 2145 |
KEY `begin` (`begin`), |
| 2146 |
KEY `end` (`end`), |
| 2147 |
KEY `FK_entities` (`FK_entities`), |
| 2148 |
KEY `rv` (`rv`), |
| 2149 |
KEY `FK_users` (`FK_users`), |
| 2150 |
KEY `recursive` (`recursive`), |
| 2151 |
KEY `private` (`private`) |
| 2152 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2153 |
|
| 2154 |
|
| 2155 |
### Dump table glpi_reservation_item
|
| 2156 |
|
| 2157 |
DROP TABLE IF EXISTS `glpi_reservation_item`; |
| 2158 |
CREATE TABLE `glpi_reservation_item` ( |
| 2159 |
`ID` int(11) NOT NULL auto_increment, |
| 2160 |
`device_type` smallint(6) NOT NULL default '0', |
| 2161 |
`id_device` int(11) NOT NULL default '0', |
| 2162 |
`comments` text collate utf8_unicode_ci, |
| 2163 |
`active` smallint(6) NOT NULL default '1', |
| 2164 |
PRIMARY KEY (`ID`), |
| 2165 |
KEY `device_type` (`device_type`), |
| 2166 |
KEY `device_type_2` (`device_type`,`id_device`) |
| 2167 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2168 |
|
| 2169 |
|
| 2170 |
### Dump table glpi_reservation_resa
|
| 2171 |
|
| 2172 |
DROP TABLE IF EXISTS `glpi_reservation_resa`; |
| 2173 |
CREATE TABLE `glpi_reservation_resa` ( |
| 2174 |
`ID` bigint(20) NOT NULL auto_increment, |
| 2175 |
`id_item` int(11) NOT NULL default '0', |
| 2176 |
`begin` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2177 |
`end` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2178 |
`id_user` int(11) NOT NULL default '0', |
| 2179 |
`comment` text collate utf8_unicode_ci, |
| 2180 |
PRIMARY KEY (`ID`), |
| 2181 |
KEY `id_item` (`id_item`), |
| 2182 |
KEY `id_user` (`id_user`), |
| 2183 |
KEY `begin` (`begin`), |
| 2184 |
KEY `end` (`end`) |
| 2185 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2186 |
|
| 2187 |
|
| 2188 |
### Dump table glpi_rule_cache_manufacturer
|
| 2189 |
|
| 2190 |
DROP TABLE IF EXISTS `glpi_rule_cache_manufacturer`; |
| 2191 |
CREATE TABLE `glpi_rule_cache_manufacturer` ( |
| 2192 |
`ID` int(11) NOT NULL auto_increment, |
| 2193 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2194 |
`rule_id` int(11) NOT NULL default '0', |
| 2195 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2196 |
PRIMARY KEY (`ID`), |
| 2197 |
KEY `rule_id` (`rule_id`), |
| 2198 |
KEY `old_value` (`old_value`) |
| 2199 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2200 |
|
| 2201 |
|
| 2202 |
### Dump table glpi_rule_cache_model_computer
|
| 2203 |
|
| 2204 |
DROP TABLE IF EXISTS `glpi_rule_cache_model_computer`; |
| 2205 |
CREATE TABLE `glpi_rule_cache_model_computer` ( |
| 2206 |
`ID` int(11) NOT NULL auto_increment, |
| 2207 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2208 |
`rule_id` int(11) NOT NULL default '0', |
| 2209 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2210 |
`manufacturer` varchar(255) collate utf8_unicode_ci default NULL, |
| 2211 |
PRIMARY KEY (`ID`), |
| 2212 |
KEY `rule_id` (`rule_id`), |
| 2213 |
KEY `old_value` (`old_value`) |
| 2214 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2215 |
|
| 2216 |
|
| 2217 |
### Dump table glpi_rule_cache_model_monitor
|
| 2218 |
|
| 2219 |
DROP TABLE IF EXISTS `glpi_rule_cache_model_monitor`; |
| 2220 |
CREATE TABLE `glpi_rule_cache_model_monitor` ( |
| 2221 |
`ID` int(11) NOT NULL auto_increment, |
| 2222 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2223 |
`rule_id` int(11) NOT NULL default '0', |
| 2224 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2225 |
`manufacturer` varchar(255) collate utf8_unicode_ci default NULL, |
| 2226 |
PRIMARY KEY (`ID`), |
| 2227 |
KEY `rule_id` (`rule_id`), |
| 2228 |
KEY `old_value` (`old_value`) |
| 2229 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2230 |
|
| 2231 |
|
| 2232 |
### Dump table glpi_rule_cache_model_networking
|
| 2233 |
|
| 2234 |
DROP TABLE IF EXISTS `glpi_rule_cache_model_networking`; |
| 2235 |
CREATE TABLE `glpi_rule_cache_model_networking` ( |
| 2236 |
`ID` int(11) NOT NULL auto_increment, |
| 2237 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2238 |
`rule_id` int(11) NOT NULL default '0', |
| 2239 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2240 |
`manufacturer` varchar(255) collate utf8_unicode_ci default NULL, |
| 2241 |
PRIMARY KEY (`ID`), |
| 2242 |
KEY `rule_id` (`rule_id`), |
| 2243 |
KEY `old_value` (`old_value`) |
| 2244 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2245 |
|
| 2246 |
|
| 2247 |
### Dump table glpi_rule_cache_model_peripheral
|
| 2248 |
|
| 2249 |
DROP TABLE IF EXISTS `glpi_rule_cache_model_peripheral`; |
| 2250 |
CREATE TABLE `glpi_rule_cache_model_peripheral` ( |
| 2251 |
`ID` int(11) NOT NULL auto_increment, |
| 2252 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2253 |
`rule_id` int(11) NOT NULL default '0', |
| 2254 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2255 |
`manufacturer` varchar(255) collate utf8_unicode_ci default NULL, |
| 2256 |
PRIMARY KEY (`ID`), |
| 2257 |
KEY `rule_id` (`rule_id`), |
| 2258 |
KEY `old_value` (`old_value`) |
| 2259 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2260 |
|
| 2261 |
|
| 2262 |
### Dump table glpi_rule_cache_model_phone
|
| 2263 |
|
| 2264 |
DROP TABLE IF EXISTS `glpi_rule_cache_model_phone`; |
| 2265 |
CREATE TABLE `glpi_rule_cache_model_phone` ( |
| 2266 |
`ID` int(11) NOT NULL auto_increment, |
| 2267 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2268 |
`rule_id` int(11) NOT NULL default '0', |
| 2269 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2270 |
`manufacturer` varchar(255) collate utf8_unicode_ci default NULL, |
| 2271 |
PRIMARY KEY (`ID`), |
| 2272 |
KEY `rule_id` (`rule_id`), |
| 2273 |
KEY `old_value` (`old_value`) |
| 2274 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2275 |
|
| 2276 |
|
| 2277 |
### Dump table glpi_rule_cache_model_printer
|
| 2278 |
|
| 2279 |
DROP TABLE IF EXISTS `glpi_rule_cache_model_printer`; |
| 2280 |
CREATE TABLE `glpi_rule_cache_model_printer` ( |
| 2281 |
`ID` int(11) NOT NULL auto_increment, |
| 2282 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2283 |
`rule_id` int(11) NOT NULL default '0', |
| 2284 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2285 |
`manufacturer` varchar(255) collate utf8_unicode_ci default NULL, |
| 2286 |
PRIMARY KEY (`ID`), |
| 2287 |
KEY `rule_id` (`rule_id`), |
| 2288 |
KEY `old_value` (`old_value`) |
| 2289 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2290 |
|
| 2291 |
|
| 2292 |
### Dump table glpi_rule_cache_os
|
| 2293 |
|
| 2294 |
DROP TABLE IF EXISTS `glpi_rule_cache_os`; |
| 2295 |
CREATE TABLE `glpi_rule_cache_os` ( |
| 2296 |
`ID` int(11) NOT NULL auto_increment, |
| 2297 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2298 |
`rule_id` int(11) NOT NULL default '0', |
| 2299 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2300 |
PRIMARY KEY (`ID`), |
| 2301 |
KEY `rule_id` (`rule_id`), |
| 2302 |
KEY `old_value` (`old_value`) |
| 2303 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2304 |
|
| 2305 |
|
| 2306 |
### Dump table glpi_rule_cache_os_sp
|
| 2307 |
|
| 2308 |
DROP TABLE IF EXISTS `glpi_rule_cache_os_sp`; |
| 2309 |
CREATE TABLE `glpi_rule_cache_os_sp` ( |
| 2310 |
`ID` int(11) NOT NULL auto_increment, |
| 2311 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2312 |
`rule_id` int(11) NOT NULL default '0', |
| 2313 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2314 |
PRIMARY KEY (`ID`), |
| 2315 |
KEY `rule_id` (`rule_id`), |
| 2316 |
KEY `old_value` (`old_value`) |
| 2317 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2318 |
|
| 2319 |
|
| 2320 |
### Dump table glpi_rule_cache_os_version
|
| 2321 |
|
| 2322 |
DROP TABLE IF EXISTS `glpi_rule_cache_os_version`; |
| 2323 |
CREATE TABLE `glpi_rule_cache_os_version` ( |
| 2324 |
`ID` int(11) NOT NULL auto_increment, |
| 2325 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2326 |
`rule_id` int(11) NOT NULL default '0', |
| 2327 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2328 |
PRIMARY KEY (`ID`), |
| 2329 |
KEY `rule_id` (`rule_id`), |
| 2330 |
KEY `old_value` (`old_value`) |
| 2331 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2332 |
|
| 2333 |
|
| 2334 |
### Dump table glpi_rule_cache_software
|
| 2335 |
|
| 2336 |
DROP TABLE IF EXISTS `glpi_rule_cache_software`; |
| 2337 |
CREATE TABLE `glpi_rule_cache_software` ( |
| 2338 |
`ID` int(11) NOT NULL auto_increment, |
| 2339 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2340 |
`manufacturer` varchar(255) collate utf8_unicode_ci NOT NULL, |
| 2341 |
`rule_id` int(11) NOT NULL default '0', |
| 2342 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2343 |
`version` varchar(255) collate utf8_unicode_ci default NULL, |
| 2344 |
`new_manufacturer` varchar(255) collate utf8_unicode_ci NOT NULL, |
| 2345 |
`ignore_ocs_import` varchar(255) collate utf8_unicode_ci default NULL, |
| 2346 |
PRIMARY KEY (`ID`), |
| 2347 |
KEY `rule_id` (`rule_id`), |
| 2348 |
KEY `old_value` (`old_value`) |
| 2349 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2350 |
|
| 2351 |
|
| 2352 |
### Dump table glpi_rule_cache_type_computer
|
| 2353 |
|
| 2354 |
DROP TABLE IF EXISTS `glpi_rule_cache_type_computer`; |
| 2355 |
CREATE TABLE `glpi_rule_cache_type_computer` ( |
| 2356 |
`ID` int(11) NOT NULL auto_increment, |
| 2357 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2358 |
`rule_id` int(11) NOT NULL default '0', |
| 2359 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2360 |
PRIMARY KEY (`ID`), |
| 2361 |
KEY `rule_id` (`rule_id`), |
| 2362 |
KEY `old_value` (`old_value`) |
| 2363 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2364 |
|
| 2365 |
|
| 2366 |
### Dump table glpi_rule_cache_type_monitor
|
| 2367 |
|
| 2368 |
DROP TABLE IF EXISTS `glpi_rule_cache_type_monitor`; |
| 2369 |
CREATE TABLE `glpi_rule_cache_type_monitor` ( |
| 2370 |
`ID` int(11) NOT NULL auto_increment, |
| 2371 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2372 |
`rule_id` int(11) NOT NULL default '0', |
| 2373 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2374 |
PRIMARY KEY (`ID`), |
| 2375 |
KEY `rule_id` (`rule_id`), |
| 2376 |
KEY `old_value` (`old_value`) |
| 2377 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2378 |
|
| 2379 |
|
| 2380 |
### Dump table glpi_rule_cache_type_networking
|
| 2381 |
|
| 2382 |
DROP TABLE IF EXISTS `glpi_rule_cache_type_networking`; |
| 2383 |
CREATE TABLE `glpi_rule_cache_type_networking` ( |
| 2384 |
`ID` int(11) NOT NULL auto_increment, |
| 2385 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2386 |
`rule_id` int(11) NOT NULL default '0', |
| 2387 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2388 |
PRIMARY KEY (`ID`), |
| 2389 |
KEY `rule_id` (`rule_id`), |
| 2390 |
KEY `old_value` (`old_value`) |
| 2391 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2392 |
|
| 2393 |
|
| 2394 |
### Dump table glpi_rule_cache_type_peripheral
|
| 2395 |
|
| 2396 |
DROP TABLE IF EXISTS `glpi_rule_cache_type_peripheral`; |
| 2397 |
CREATE TABLE `glpi_rule_cache_type_peripheral` ( |
| 2398 |
`ID` int(11) NOT NULL auto_increment, |
| 2399 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2400 |
`rule_id` int(11) NOT NULL default '0', |
| 2401 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2402 |
PRIMARY KEY (`ID`), |
| 2403 |
KEY `rule_id` (`rule_id`), |
| 2404 |
KEY `old_value` (`old_value`) |
| 2405 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2406 |
|
| 2407 |
|
| 2408 |
### Dump table glpi_rule_cache_type_phone
|
| 2409 |
|
| 2410 |
DROP TABLE IF EXISTS `glpi_rule_cache_type_phone`; |
| 2411 |
CREATE TABLE `glpi_rule_cache_type_phone` ( |
| 2412 |
`ID` int(11) NOT NULL auto_increment, |
| 2413 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2414 |
`rule_id` int(11) NOT NULL default '0', |
| 2415 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2416 |
PRIMARY KEY (`ID`), |
| 2417 |
KEY `rule_id` (`rule_id`), |
| 2418 |
KEY `old_value` (`old_value`) |
| 2419 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2420 |
|
| 2421 |
|
| 2422 |
### Dump table glpi_rule_cache_type_printer
|
| 2423 |
|
| 2424 |
DROP TABLE IF EXISTS `glpi_rule_cache_type_printer`; |
| 2425 |
CREATE TABLE `glpi_rule_cache_type_printer` ( |
| 2426 |
`ID` int(11) NOT NULL auto_increment, |
| 2427 |
`old_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2428 |
`rule_id` int(11) NOT NULL default '0', |
| 2429 |
`new_value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2430 |
PRIMARY KEY (`ID`), |
| 2431 |
KEY `rule_id` (`rule_id`), |
| 2432 |
KEY `old_value` (`old_value`) |
| 2433 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2434 |
|
| 2435 |
|
| 2436 |
### Dump table glpi_rules_actions
|
| 2437 |
|
| 2438 |
DROP TABLE IF EXISTS `glpi_rules_actions`; |
| 2439 |
CREATE TABLE `glpi_rules_actions` ( |
| 2440 |
`ID` int(11) NOT NULL auto_increment, |
| 2441 |
`FK_rules` int(11) NOT NULL default '0', |
| 2442 |
`action_type` varchar(255) collate utf8_unicode_ci default NULL, |
| 2443 |
`field` varchar(255) collate utf8_unicode_ci default NULL, |
| 2444 |
`value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2445 |
PRIMARY KEY (`ID`), |
| 2446 |
KEY `FK_rules` (`FK_rules`) |
| 2447 |
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2448 |
|
| 2449 |
INSERT INTO glpi_rules_actions VALUES ('1','1','assign','FK_entities','0'); |
| 2450 |
INSERT INTO glpi_rules_actions VALUES ('2','2','assign','FK_entities','0'); |
| 2451 |
|
| 2452 |
### Dump table glpi_rules_criterias
|
| 2453 |
|
| 2454 |
DROP TABLE IF EXISTS `glpi_rules_criterias`; |
| 2455 |
CREATE TABLE `glpi_rules_criterias` ( |
| 2456 |
`ID` int(11) NOT NULL auto_increment, |
| 2457 |
`FK_rules` int(11) NOT NULL default '0', |
| 2458 |
`criteria` varchar(255) collate utf8_unicode_ci default NULL, |
| 2459 |
`condition` smallint(4) NOT NULL default '0', |
| 2460 |
`pattern` varchar(255) collate utf8_unicode_ci default NULL, |
| 2461 |
PRIMARY KEY (`ID`), |
| 2462 |
KEY `FK_rules` (`FK_rules`) |
| 2463 |
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2464 |
|
| 2465 |
INSERT INTO glpi_rules_criterias VALUES ('1','1','TAG','0','*'); |
| 2466 |
INSERT INTO glpi_rules_criterias VALUES ('2','2','uid','0','*'); |
| 2467 |
INSERT INTO glpi_rules_criterias VALUES ('3','2','samaccountname','0','*'); |
| 2468 |
INSERT INTO glpi_rules_criterias VALUES ('4','2','MAIL_EMAIL','0','*'); |
| 2469 |
|
| 2470 |
### Dump table glpi_rules_descriptions
|
| 2471 |
|
| 2472 |
DROP TABLE IF EXISTS `glpi_rules_descriptions`; |
| 2473 |
CREATE TABLE `glpi_rules_descriptions` ( |
| 2474 |
`ID` int(11) NOT NULL auto_increment, |
| 2475 |
`FK_entities` int(11) NOT NULL default '-1', |
| 2476 |
`rule_type` smallint(4) NOT NULL default '0', |
| 2477 |
`ranking` int(11) NOT NULL default '0', |
| 2478 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2479 |
`description` text collate utf8_unicode_ci, |
| 2480 |
`match` varchar(255) collate utf8_unicode_ci default NULL, |
| 2481 |
`active` int(1) NOT NULL default '1', |
| 2482 |
`comments` text collate utf8_unicode_ci, |
| 2483 |
PRIMARY KEY (`ID`) |
| 2484 |
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2485 |
|
| 2486 |
INSERT INTO glpi_rules_descriptions VALUES ('1','-1','0','0','Root','','AND','1',NULL); |
| 2487 |
INSERT INTO glpi_rules_descriptions VALUES ('2','-1','1','1','Root','','OR','1',NULL); |
| 2488 |
|
| 2489 |
### Dump table glpi_rules_ldap_parameters
|
| 2490 |
|
| 2491 |
DROP TABLE IF EXISTS `glpi_rules_ldap_parameters`; |
| 2492 |
CREATE TABLE `glpi_rules_ldap_parameters` ( |
| 2493 |
`ID` int(11) NOT NULL auto_increment, |
| 2494 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2495 |
`value` varchar(255) collate utf8_unicode_ci default NULL, |
| 2496 |
`rule_type` smallint(6) NOT NULL default '1', |
| 2497 |
PRIMARY KEY (`ID`) |
| 2498 |
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2499 |
|
| 2500 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('1','(LDAP)Organization','o','1'); |
| 2501 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('2','(LDAP)Common Name','cn','1'); |
| 2502 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('3','(LDAP)Department Number','departmentnumber','1'); |
| 2503 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('4','(LDAP)Email','mail','1'); |
| 2504 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('5','Object Class','objectclass','1'); |
| 2505 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('6','(LDAP)User ID','uid','1'); |
| 2506 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('7','(LDAP)Telephone Number','phone','1'); |
| 2507 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('8','(LDAP)Employee Number','employeenumber','1'); |
| 2508 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('9','(LDAP)Manager','manager','1'); |
| 2509 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('10','(LDAP)DistinguishedName','dn','1'); |
| 2510 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('11','(AD)DistinguishedName','distinguishedname','1'); |
| 2511 |
INSERT INTO glpi_rules_ldap_parameters VALUES ('12','(AD)User ID','samaccountname','1'); |
| 2512 |
|
| 2513 |
### Dump table glpi_software
|
| 2514 |
|
| 2515 |
DROP TABLE IF EXISTS `glpi_software`; |
| 2516 |
CREATE TABLE `glpi_software` ( |
| 2517 |
`ID` int(11) NOT NULL auto_increment, |
| 2518 |
`FK_entities` int(11) NOT NULL default '0', |
| 2519 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2520 |
`comments` text collate utf8_unicode_ci, |
| 2521 |
`location` int(11) NOT NULL default '0', |
| 2522 |
`tech_num` int(11) NOT NULL default '0', |
| 2523 |
`platform` int(11) NOT NULL default '0', |
| 2524 |
`is_update` smallint(6) NOT NULL default '0', |
| 2525 |
`update_software` int(11) NOT NULL default '-1', |
| 2526 |
`FK_glpi_enterprise` int(11) NOT NULL default '0', |
| 2527 |
`deleted` smallint(6) NOT NULL default '0', |
| 2528 |
`is_template` smallint(6) NOT NULL default '0', |
| 2529 |
`tplname` varchar(255) collate utf8_unicode_ci default NULL, |
| 2530 |
`date_mod` datetime default NULL, |
| 2531 |
`notes` longtext collate utf8_unicode_ci, |
| 2532 |
`FK_users` int(11) NOT NULL default '0', |
| 2533 |
`FK_groups` int(11) NOT NULL default '0', |
| 2534 |
`state` int(11) NOT NULL default '0', |
| 2535 |
`ticket_tco` decimal(20,4) default '0.0000', |
| 2536 |
`helpdesk_visible` int(11) NOT NULL default '1', |
| 2537 |
`category` int(11) NOT NULL default '0', |
| 2538 |
PRIMARY KEY (`ID`), |
| 2539 |
KEY `platform` (`platform`), |
| 2540 |
KEY `location` (`location`), |
| 2541 |
KEY `FK_glpi_enterprise` (`FK_glpi_enterprise`), |
| 2542 |
KEY `date_mod` (`date_mod`), |
| 2543 |
KEY `tech_num` (`tech_num`), |
| 2544 |
KEY `name` (`name`), |
| 2545 |
KEY `FK_groups` (`FK_groups`), |
| 2546 |
KEY `FK_users` (`FK_users`), |
| 2547 |
KEY `update_software` (`update_software`), |
| 2548 |
KEY `FK_entities` (`FK_entities`), |
| 2549 |
KEY `is_template` (`is_template`), |
| 2550 |
KEY `is_update` (`is_update`), |
| 2551 |
KEY `deleted` (`deleted`) |
| 2552 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2553 |
|
| 2554 |
|
| 2555 |
### Dump table glpi_tracking
|
| 2556 |
|
| 2557 |
DROP TABLE IF EXISTS `glpi_tracking`; |
| 2558 |
CREATE TABLE `glpi_tracking` ( |
| 2559 |
`ID` int(11) NOT NULL auto_increment, |
| 2560 |
`FK_entities` int(11) NOT NULL default '0', |
| 2561 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2562 |
`date` datetime default NULL, |
| 2563 |
`closedate` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2564 |
`date_mod` datetime default NULL, |
| 2565 |
`status` varchar(255) collate utf8_unicode_ci default 'new', |
| 2566 |
`author` int(11) NOT NULL default '0', |
| 2567 |
`recipient` int(11) NOT NULL default '0', |
| 2568 |
`FK_group` int(11) NOT NULL default '0', |
| 2569 |
`request_type` smallint(6) NOT NULL default '0', |
| 2570 |
`assign` int(11) NOT NULL default '0', |
| 2571 |
`assign_ent` int(11) NOT NULL default '0', |
| 2572 |
`assign_group` int(11) NOT NULL default '0', |
| 2573 |
`device_type` int(11) NOT NULL default '0', |
| 2574 |
`computer` int(11) NOT NULL default '0', |
| 2575 |
`contents` longtext collate utf8_unicode_ci, |
| 2576 |
`priority` smallint(6) NOT NULL default '1', |
| 2577 |
`uemail` varchar(255) collate utf8_unicode_ci default NULL, |
| 2578 |
`emailupdates` smallint(6) NOT NULL default '0', |
| 2579 |
`realtime` float NOT NULL default '0', |
| 2580 |
`category` int(11) NOT NULL default '0', |
| 2581 |
`cost_time` decimal(20,4) NOT NULL default '0.0000', |
| 2582 |
`cost_fixed` decimal(20,4) NOT NULL default '0.0000', |
| 2583 |
`cost_material` decimal(20,4) NOT NULL default '0.0000', |
| 2584 |
PRIMARY KEY (`ID`), |
| 2585 |
KEY `computer` (`computer`), |
| 2586 |
KEY `author` (`author`), |
| 2587 |
KEY `assign` (`assign`), |
| 2588 |
KEY `date` (`date`), |
| 2589 |
KEY `closedate` (`closedate`), |
| 2590 |
KEY `status` (`status`), |
| 2591 |
KEY `category` (`category`), |
| 2592 |
KEY `FK_group` (`FK_group`), |
| 2593 |
KEY `assign_ent` (`assign_ent`), |
| 2594 |
KEY `device_type` (`device_type`), |
| 2595 |
KEY `priority` (`priority`), |
| 2596 |
KEY `request_type` (`request_type`), |
| 2597 |
KEY `FK_entities` (`FK_entities`), |
| 2598 |
KEY `recipient` (`recipient`), |
| 2599 |
KEY `assign_group` (`assign_group`) |
| 2600 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2601 |
|
| 2602 |
|
| 2603 |
### Dump table glpi_tracking_planning
|
| 2604 |
|
| 2605 |
DROP TABLE IF EXISTS `glpi_tracking_planning`; |
| 2606 |
CREATE TABLE `glpi_tracking_planning` ( |
| 2607 |
`ID` bigint(20) NOT NULL auto_increment, |
| 2608 |
`id_followup` int(11) NOT NULL default '0', |
| 2609 |
`id_assign` int(11) NOT NULL default '0', |
| 2610 |
`begin` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2611 |
`end` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2612 |
`state` smallint(6) NOT NULL default '1', |
| 2613 |
PRIMARY KEY (`ID`), |
| 2614 |
KEY `begin` (`begin`), |
| 2615 |
KEY `end` (`end`), |
| 2616 |
KEY `id_assign` (`id_assign`), |
| 2617 |
KEY `id_followup` (`id_followup`) |
| 2618 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2619 |
|
| 2620 |
|
| 2621 |
### Dump table glpi_transfers
|
| 2622 |
|
| 2623 |
DROP TABLE IF EXISTS `glpi_transfers`; |
| 2624 |
CREATE TABLE `glpi_transfers` ( |
| 2625 |
`ID` int(11) NOT NULL auto_increment, |
| 2626 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2627 |
`keep_tickets` smallint(6) NOT NULL default '0', |
| 2628 |
`keep_networklinks` smallint(6) NOT NULL default '0', |
| 2629 |
`keep_reservations` smallint(6) NOT NULL default '0', |
| 2630 |
`keep_history` smallint(6) NOT NULL default '0', |
| 2631 |
`keep_devices` smallint(6) NOT NULL default '0', |
| 2632 |
`keep_infocoms` smallint(6) NOT NULL default '0', |
| 2633 |
`keep_dc_monitor` smallint(6) NOT NULL default '0', |
| 2634 |
`clean_dc_monitor` smallint(6) NOT NULL default '0', |
| 2635 |
`keep_dc_phone` smallint(6) NOT NULL default '0', |
| 2636 |
`clean_dc_phone` smallint(6) NOT NULL default '0', |
| 2637 |
`keep_dc_peripheral` smallint(6) NOT NULL default '0', |
| 2638 |
`clean_dc_peripheral` smallint(6) NOT NULL default '0', |
| 2639 |
`keep_dc_printer` smallint(6) NOT NULL default '0', |
| 2640 |
`clean_dc_printer` smallint(6) NOT NULL default '0', |
| 2641 |
`keep_enterprises` smallint(6) NOT NULL default '0', |
| 2642 |
`clean_enterprises` smallint(6) NOT NULL default '0', |
| 2643 |
`keep_contacts` smallint(6) NOT NULL default '0', |
| 2644 |
`clean_contacts` smallint(6) NOT NULL default '0', |
| 2645 |
`keep_contracts` smallint(6) NOT NULL default '0', |
| 2646 |
`clean_contracts` smallint(6) NOT NULL default '0', |
| 2647 |
`keep_softwares` smallint(6) NOT NULL default '0', |
| 2648 |
`clean_softwares` smallint(6) NOT NULL default '0', |
| 2649 |
`keep_documents` smallint(6) NOT NULL default '0', |
| 2650 |
`clean_documents` smallint(6) NOT NULL default '0', |
| 2651 |
`keep_cartridges_type` smallint(6) NOT NULL default '0', |
| 2652 |
`clean_cartridges_type` smallint(6) NOT NULL default '0', |
| 2653 |
`keep_cartridges` smallint(6) NOT NULL default '0', |
| 2654 |
`keep_consumables` smallint(6) NOT NULL default '0', |
| 2655 |
PRIMARY KEY (`ID`) |
| 2656 |
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2657 |
|
| 2658 |
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'); |
| 2659 |
|
| 2660 |
### Dump table glpi_type_computers
|
| 2661 |
|
| 2662 |
DROP TABLE IF EXISTS `glpi_type_computers`; |
| 2663 |
CREATE TABLE `glpi_type_computers` ( |
| 2664 |
`ID` int(11) NOT NULL auto_increment, |
| 2665 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2666 |
`comments` text collate utf8_unicode_ci, |
| 2667 |
PRIMARY KEY (`ID`), |
| 2668 |
KEY `name` (`name`) |
| 2669 |
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2670 |
|
| 2671 |
INSERT INTO glpi_type_computers VALUES ('1','Serveur',NULL); |
| 2672 |
|
| 2673 |
### Dump table glpi_type_docs
|
| 2674 |
|
| 2675 |
DROP TABLE IF EXISTS `glpi_type_docs`; |
| 2676 |
CREATE TABLE `glpi_type_docs` ( |
| 2677 |
`ID` int(11) NOT NULL auto_increment, |
| 2678 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2679 |
`ext` varchar(255) collate utf8_unicode_ci default NULL, |
| 2680 |
`icon` varchar(255) collate utf8_unicode_ci default NULL, |
| 2681 |
`mime` varchar(255) collate utf8_unicode_ci default NULL, |
| 2682 |
`upload` smallint(6) NOT NULL default '1', |
| 2683 |
`date_mod` datetime default NULL, |
| 2684 |
PRIMARY KEY (`ID`), |
| 2685 |
UNIQUE KEY `extension` (`ext`), |
| 2686 |
KEY `name` (`name`), |
| 2687 |
KEY `upload` (`upload`) |
| 2688 |
) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2689 |
|
| 2690 |
INSERT INTO glpi_type_docs VALUES ('1','JPEG','jpg','jpg-dist.png','','1','2004-12-13 19:47:21'); |
| 2691 |
INSERT INTO glpi_type_docs VALUES ('2','PNG','png','png-dist.png','','1','2004-12-13 19:47:21'); |
| 2692 |
INSERT INTO glpi_type_docs VALUES ('3','GIF','gif','gif-dist.png','','1','2004-12-13 19:47:21'); |
| 2693 |
INSERT INTO glpi_type_docs VALUES ('4','BMP','bmp','bmp-dist.png','','1','2004-12-13 19:47:21'); |
| 2694 |
INSERT INTO glpi_type_docs VALUES ('5','Photoshop','psd','psd-dist.png','','1','2004-12-13 19:47:21'); |
| 2695 |
INSERT INTO glpi_type_docs VALUES ('6','TIFF','tif','tif-dist.png','','1','2004-12-13 19:47:21'); |
| 2696 |
INSERT INTO glpi_type_docs VALUES ('7','AIFF','aiff','aiff-dist.png','','1','2004-12-13 19:47:21'); |
| 2697 |
INSERT INTO glpi_type_docs VALUES ('8','Windows Media','asf','asf-dist.png','','1','2004-12-13 19:47:21'); |
| 2698 |
INSERT INTO glpi_type_docs VALUES ('9','Windows Media','avi','avi-dist.png','','1','2004-12-13 19:47:21'); |
| 2699 |
INSERT INTO glpi_type_docs VALUES ('44','C source','c','','','1','2004-12-13 19:47:22'); |
| 2700 |
INSERT INTO glpi_type_docs VALUES ('27','RealAudio','rm','rm-dist.png','','1','2004-12-13 19:47:21'); |
| 2701 |
INSERT INTO glpi_type_docs VALUES ('16','Midi','mid','mid-dist.png','','1','2004-12-13 19:47:21'); |
| 2702 |
INSERT INTO glpi_type_docs VALUES ('17','QuickTime','mov','mov-dist.png','','1','2004-12-13 19:47:21'); |
| 2703 |
INSERT INTO glpi_type_docs VALUES ('18','MP3','mp3','mp3-dist.png','','1','2004-12-13 19:47:21'); |
| 2704 |
INSERT INTO glpi_type_docs VALUES ('19','MPEG','mpg','mpg-dist.png','','1','2004-12-13 19:47:21'); |
| 2705 |
INSERT INTO glpi_type_docs VALUES ('20','Ogg Vorbis','ogg','ogg-dist.png','','1','2004-12-13 19:47:21'); |
| 2706 |
INSERT INTO glpi_type_docs VALUES ('24','QuickTime','qt','qt-dist.png','','1','2004-12-13 19:47:21'); |
| 2707 |
INSERT INTO glpi_type_docs VALUES ('10','BZip','bz2','bz2-dist.png','','1','2004-12-13 19:47:21'); |
| 2708 |
INSERT INTO glpi_type_docs VALUES ('25','RealAudio','ra','ra-dist.png','','1','2004-12-13 19:47:21'); |
| 2709 |
INSERT INTO glpi_type_docs VALUES ('26','RealAudio','ram','ram-dist.png','','1','2004-12-13 19:47:21'); |
| 2710 |
INSERT INTO glpi_type_docs VALUES ('11','Word','doc','doc-dist.png','','1','2004-12-13 19:47:21'); |
| 2711 |
INSERT INTO glpi_type_docs VALUES ('12','DjVu','djvu','','','1','2004-12-13 19:47:21'); |
| 2712 |
INSERT INTO glpi_type_docs VALUES ('42','MNG','mng','','','1','2004-12-13 19:47:22'); |
| 2713 |
INSERT INTO glpi_type_docs VALUES ('13','PostScript','eps','ps-dist.png','','1','2004-12-13 19:47:21'); |
| 2714 |
INSERT INTO glpi_type_docs VALUES ('14','GZ','gz','gz-dist.png','','1','2004-12-13 19:47:21'); |
| 2715 |
INSERT INTO glpi_type_docs VALUES ('37','WAV','wav','wav-dist.png','','1','2004-12-13 19:47:22'); |
| 2716 |
INSERT INTO glpi_type_docs VALUES ('15','HTML','html','html-dist.png','','1','2004-12-13 19:47:21'); |
| 2717 |
INSERT INTO glpi_type_docs VALUES ('34','Flash','swf','','','1','2004-12-13 19:47:22'); |
| 2718 |
INSERT INTO glpi_type_docs VALUES ('21','PDF','pdf','pdf-dist.png','','1','2004-12-13 19:47:21'); |
| 2719 |
INSERT INTO glpi_type_docs VALUES ('22','PowerPoint','ppt','ppt-dist.png','','1','2004-12-13 19:47:21'); |
| 2720 |
INSERT INTO glpi_type_docs VALUES ('23','PostScript','ps','ps-dist.png','','1','2004-12-13 19:47:21'); |
| 2721 |
INSERT INTO glpi_type_docs VALUES ('40','Windows Media','wmv','','','1','2004-12-13 19:47:22'); |
| 2722 |
INSERT INTO glpi_type_docs VALUES ('28','RTF','rtf','rtf-dist.png','','1','2004-12-13 19:47:21'); |
| 2723 |
INSERT INTO glpi_type_docs VALUES ('29','StarOffice','sdd','sdd-dist.png','','1','2004-12-13 19:47:22'); |
| 2724 |
INSERT INTO glpi_type_docs VALUES ('30','StarOffice','sdw','sdw-dist.png','','1','2004-12-13 19:47:22'); |
| 2725 |
INSERT INTO glpi_type_docs VALUES ('31','Stuffit','sit','sit-dist.png','','1','2004-12-13 19:47:22'); |
| 2726 |
INSERT INTO glpi_type_docs VALUES ('43','Adobe Illustrator','ai','ai-dist.png','','1','2004-12-13 19:47:22'); |
| 2727 |
INSERT INTO glpi_type_docs VALUES ('32','OpenOffice Impress','sxi','sxi-dist.png','','1','2004-12-13 19:47:22'); |
| 2728 |
INSERT INTO glpi_type_docs VALUES ('33','OpenOffice','sxw','sxw-dist.png','','1','2004-12-13 19:47:22'); |
| 2729 |
INSERT INTO glpi_type_docs VALUES ('46','DVI','dvi','dvi-dist.png','','1','2004-12-13 19:47:22'); |
| 2730 |
INSERT INTO glpi_type_docs VALUES ('35','TGZ','tgz','tgz-dist.png','','1','2004-12-13 19:47:22'); |
| 2731 |
INSERT INTO glpi_type_docs VALUES ('36','texte','txt','txt-dist.png','','1','2004-12-13 19:47:22'); |
| 2732 |
INSERT INTO glpi_type_docs VALUES ('49','RedHat/Mandrake/SuSE','rpm','rpm-dist.png','','1','2004-12-13 19:47:22'); |
| 2733 |
INSERT INTO glpi_type_docs VALUES ('38','Excel','xls','xls-dist.png','','1','2004-12-13 19:47:22'); |
| 2734 |
INSERT INTO glpi_type_docs VALUES ('39','XML','xml','xml-dist.png','','1','2004-12-13 19:47:22'); |
| 2735 |
INSERT INTO glpi_type_docs VALUES ('41','Zip','zip','zip-dist.png','','1','2004-12-13 19:47:22'); |
| 2736 |
INSERT INTO glpi_type_docs VALUES ('45','Debian','deb','deb-dist.png','','1','2004-12-13 19:47:22'); |
| 2737 |
INSERT INTO glpi_type_docs VALUES ('47','C header','h','','','1','2004-12-13 19:47:22'); |
| 2738 |
INSERT INTO glpi_type_docs VALUES ('48','Pascal','pas','','','1','2004-12-13 19:47:22'); |
| 2739 |
INSERT INTO glpi_type_docs VALUES ('50','OpenOffice Calc','sxc','sxc-dist.png','','1','2004-12-13 19:47:22'); |
| 2740 |
INSERT INTO glpi_type_docs VALUES ('51','LaTeX','tex','tex-dist.png','','1','2004-12-13 19:47:22'); |
| 2741 |
INSERT INTO glpi_type_docs VALUES ('52','GIMP multi-layer','xcf','xcf-dist.png','','1','2004-12-13 19:47:22'); |
| 2742 |
INSERT INTO glpi_type_docs VALUES ('53','JPEG','jpeg','jpg-dist.png','','1','2005-03-07 22:23:17'); |
| 2743 |
INSERT INTO glpi_type_docs VALUES ('54','Oasis Open Office Writer','odt','odt-dist.png','','1','2006-01-21 17:41:13'); |
| 2744 |
INSERT INTO glpi_type_docs VALUES ('55','Oasis Open Office Calc','ods','ods-dist.png','','1','2006-01-21 17:41:31'); |
| 2745 |
INSERT INTO glpi_type_docs VALUES ('56','Oasis Open Office Impress','odp','odp-dist.png','','1','2006-01-21 17:42:54'); |
| 2746 |
INSERT INTO glpi_type_docs VALUES ('57','Oasis Open Office Impress Template','otp','odp-dist.png','','1','2006-01-21 17:43:58'); |
| 2747 |
INSERT INTO glpi_type_docs VALUES ('58','Oasis Open Office Writer Template','ott','odt-dist.png','','1','2006-01-21 17:44:41'); |
| 2748 |
INSERT INTO glpi_type_docs VALUES ('59','Oasis Open Office Calc Template','ots','ods-dist.png','','1','2006-01-21 17:45:30'); |
| 2749 |
INSERT INTO glpi_type_docs VALUES ('60','Oasis Open Office Math','odf','odf-dist.png','','1','2006-01-21 17:48:05'); |
| 2750 |
INSERT INTO glpi_type_docs VALUES ('61','Oasis Open Office Draw','odg','odg-dist.png','','1','2006-01-21 17:48:31'); |
| 2751 |
INSERT INTO glpi_type_docs VALUES ('62','Oasis Open Office Draw Template','otg','odg-dist.png','','1','2006-01-21 17:49:46'); |
| 2752 |
INSERT INTO glpi_type_docs VALUES ('63','Oasis Open Office Base','odb','odb-dist.png','','1','2006-01-21 18:03:34'); |
| 2753 |
INSERT INTO glpi_type_docs VALUES ('64','Oasis Open Office HTML','oth','oth-dist.png','','1','2006-01-21 18:05:27'); |
| 2754 |
INSERT INTO glpi_type_docs VALUES ('65','Oasis Open Office Writer Master','odm','odm-dist.png','','1','2006-01-21 18:06:34'); |
| 2755 |
INSERT INTO glpi_type_docs VALUES ('66','Oasis Open Office Chart','odc','','','1','2006-01-21 18:07:48'); |
| 2756 |
INSERT INTO glpi_type_docs VALUES ('67','Oasis Open Office Image','odi','','','1','2006-01-21 18:08:18'); |
| 2757 |
|
| 2758 |
### Dump table glpi_type_monitors
|
| 2759 |
|
| 2760 |
DROP TABLE IF EXISTS `glpi_type_monitors`; |
| 2761 |
CREATE TABLE `glpi_type_monitors` ( |
| 2762 |
`ID` int(11) NOT NULL auto_increment, |
| 2763 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2764 |
`comments` text collate utf8_unicode_ci, |
| 2765 |
PRIMARY KEY (`ID`), |
| 2766 |
KEY `name` (`name`) |
| 2767 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2768 |
|
| 2769 |
|
| 2770 |
### Dump table glpi_type_networking
|
| 2771 |
|
| 2772 |
DROP TABLE IF EXISTS `glpi_type_networking`; |
| 2773 |
CREATE TABLE `glpi_type_networking` ( |
| 2774 |
`ID` int(11) NOT NULL auto_increment, |
| 2775 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2776 |
`comments` text collate utf8_unicode_ci, |
| 2777 |
PRIMARY KEY (`ID`), |
| 2778 |
KEY `name` (`name`) |
| 2779 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2780 |
|
| 2781 |
|
| 2782 |
### Dump table glpi_type_peripherals
|
| 2783 |
|
| 2784 |
DROP TABLE IF EXISTS `glpi_type_peripherals`; |
| 2785 |
CREATE TABLE `glpi_type_peripherals` ( |
| 2786 |
`ID` int(11) NOT NULL auto_increment, |
| 2787 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2788 |
`comments` text collate utf8_unicode_ci, |
| 2789 |
PRIMARY KEY (`ID`), |
| 2790 |
KEY `name` (`name`) |
| 2791 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2792 |
|
| 2793 |
|
| 2794 |
### Dump table glpi_type_phones
|
| 2795 |
|
| 2796 |
DROP TABLE IF EXISTS `glpi_type_phones`; |
| 2797 |
CREATE TABLE `glpi_type_phones` ( |
| 2798 |
`ID` int(11) NOT NULL auto_increment, |
| 2799 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2800 |
`comments` text collate utf8_unicode_ci, |
| 2801 |
PRIMARY KEY (`ID`), |
| 2802 |
KEY `name` (`name`) |
| 2803 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2804 |
|
| 2805 |
|
| 2806 |
### Dump table glpi_type_printers
|
| 2807 |
|
| 2808 |
DROP TABLE IF EXISTS `glpi_type_printers`; |
| 2809 |
CREATE TABLE `glpi_type_printers` ( |
| 2810 |
`ID` int(11) NOT NULL auto_increment, |
| 2811 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2812 |
`comments` text collate utf8_unicode_ci, |
| 2813 |
PRIMARY KEY (`ID`), |
| 2814 |
KEY `name` (`name`) |
| 2815 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2816 |
|
| 2817 |
|
| 2818 |
### Dump table glpi_users
|
| 2819 |
|
| 2820 |
DROP TABLE IF EXISTS `glpi_users`; |
| 2821 |
CREATE TABLE `glpi_users` ( |
| 2822 |
`ID` int(11) NOT NULL auto_increment, |
| 2823 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
| 2824 |
`password` varchar(255) collate utf8_unicode_ci default NULL, |
| 2825 |
`password_md5` varchar(255) collate utf8_unicode_ci default NULL, |
| 2826 |
`email` varchar(255) collate utf8_unicode_ci default NULL, |
| 2827 |
`phone` varchar(255) collate utf8_unicode_ci default NULL, |
| 2828 |
`phone2` varchar(255) collate utf8_unicode_ci default NULL, |
| 2829 |
`mobile` varchar(255) collate utf8_unicode_ci default NULL, |
| 2830 |
`realname` varchar(255) collate utf8_unicode_ci default NULL, |
| 2831 |
`firstname` varchar(255) collate utf8_unicode_ci default NULL, |
| 2832 |
`location` int(11) default NULL, |
| 2833 |
`tracking_order` smallint(6) NOT NULL default '0', |
| 2834 |
`language` varchar(255) collate utf8_unicode_ci default NULL, |
| 2835 |
`list_limit` int(11) NOT NULL default '20', |
| 2836 |
`active` int(2) NOT NULL default '1', |
| 2837 |
`comments` text collate utf8_unicode_ci, |
| 2838 |
`id_auth` int(11) NOT NULL default '-1', |
| 2839 |
`auth_method` int(11) NOT NULL default '-1', |
| 2840 |
`last_login` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2841 |
`date_mod` datetime NOT NULL default '0000-00-00 00:00:00', |
| 2842 |
`deleted` smallint(6) NOT NULL default '0', |
| 2843 |
`FK_profiles` int(11) NOT NULL default '0', |
| 2844 |
`FK_entities` int(11) NOT NULL default '0', |
| 2845 |
PRIMARY KEY (`ID`), |
| 2846 |
UNIQUE KEY `name` (`name`), |
| 2847 |
KEY `location` (`location`), |
| 2848 |
KEY `firstname` (`firstname`), |
| 2849 |
KEY `realname` (`realname`), |
| 2850 |
KEY `deleted` (`deleted`) |
| 2851 |
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2852 |
|
| 2853 |
INSERT INTO glpi_users VALUES ('2','glpi','','41ece51526515624ff89973668497d00','','','','','',NULL,'0','1','fr_FR','20','1',NULL,'-1','1','2008-10-28 22:19:29','2007-09-29 15:51:43','0','0','0'); |
| 2854 |
INSERT INTO glpi_users VALUES ('3','post-only','*5683D7F638D6598D057638B1957F194E4CA974FB','3177926a7314de24680a9938aaa97703','','','','','',NULL,'0','0','en_GB','20','1',NULL,'-1','-1','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0'); |
| 2855 |
INSERT INTO glpi_users VALUES ('4','tech','*B09F1B2C210DEEA69C662977CC69C6C461965B09','d9f9133fb120cd6096870bc2b496805b','','','','','',NULL,'0','1','fr_FR','20','1',NULL,'-1','-1','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0'); |
| 2856 |
INSERT INTO glpi_users VALUES ('5','normal','*F3F91B23FC1DB728B49B1F22DEE3D7A839E10F0E','fea087517c26fadd409bd4b9dc642555','','','','','',NULL,'0','0','en_GB','20','1',NULL,'-1','-1','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0'); |
| 2857 |
|
| 2858 |
### Dump table glpi_users_groups
|
| 2859 |
|
| 2860 |
DROP TABLE IF EXISTS `glpi_users_groups`; |
| 2861 |
CREATE TABLE `glpi_users_groups` ( |
| 2862 |
`ID` int(11) NOT NULL auto_increment, |
| 2863 |
`FK_users` int(11) NOT NULL default '0', |
| 2864 |
`FK_groups` int(11) NOT NULL default '0', |
| 2865 |
PRIMARY KEY (`ID`), |
| 2866 |
UNIQUE KEY `FK_users` (`FK_users`,`FK_groups`), |
| 2867 |
KEY `FK_users_2` (`FK_users`), |
| 2868 |
KEY `FK_groups` (`FK_groups`) |
| 2869 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2870 |
|
| 2871 |
|
| 2872 |
### Dump table glpi_users_profiles
|
| 2873 |
|
| 2874 |
DROP TABLE IF EXISTS `glpi_users_profiles`; |
| 2875 |
CREATE TABLE `glpi_users_profiles` ( |
| 2876 |
`ID` int(11) NOT NULL auto_increment, |
| 2877 |
`FK_users` int(11) NOT NULL default '0', |
| 2878 |
`FK_profiles` int(11) NOT NULL default '0', |
| 2879 |
`FK_entities` int(11) NOT NULL default '0', |
| 2880 |
`recursive` smallint(6) NOT NULL default '1', |
| 2881 |
`dynamic` smallint(6) NOT NULL default '0', |
| 2882 |
PRIMARY KEY (`ID`), |
| 2883 |
KEY `FK_users` (`FK_users`), |
| 2884 |
KEY `FK_profiles` (`FK_profiles`), |
| 2885 |
KEY `FK_entities` (`FK_entities`), |
| 2886 |
KEY `recursive` (`recursive`) |
| 2887 |
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 2888 |
|
| 2889 |
INSERT INTO glpi_users_profiles VALUES ('2','2','4','0','1','0'); |
| 2890 |
INSERT INTO glpi_users_profiles VALUES ('3','3','1','0','1','0'); |
| 2891 |
INSERT INTO glpi_users_profiles VALUES ('4','4','4','0','1','0'); |
| 2892 |
INSERT INTO glpi_users_profiles VALUES ('5','5','2','0','1','0'); |