ryxeo-glpi-git / install / mysql / glpi-0.71.3-empty.sql @ b67d8923
Historique | Voir | Annoter | Télécharger (120 ko)
1 | b67d8923 | Eric Seigne | #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'); |