ryxeo-glpi-git / install / mysql / glpi-0.71.3-empty.sql @ b67d8923
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'); |