glpi-empty.sql 315 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
--
-- ---------------------------------------------------------------------
-- GLPI - Gestionnaire Libre de Parc Informatique
-- Copyright (C) 2015-2021 Teclib' and contributors.
--
-- http://glpi-project.org
--
-- based on GLPI - Gestionnaire Libre de Parc Informatique
-- Copyright (C) 2003-2014 by the INDEPNET Development Team.
--
-- ---------------------------------------------------------------------
--
-- LICENSE
--
-- This file is part of GLPI.
--
-- GLPI is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- (at your option) any later version.
--
-- GLPI is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with GLPI. If not, see <http://www.gnu.org/licenses/>.
-- ---------------------------------------------------------------------
--
31
32
33

### Dump table glpi_alerts

34
35
SET FOREIGN_KEY_CHECKS=0;

36
37
DROP TABLE IF EXISTS `glpi_alerts`;
CREATE TABLE `glpi_alerts` (
38
  `id` int NOT NULL AUTO_INCREMENT,
39
  `itemtype` varchar(100) NOT NULL,
40
41
  `items_id` int NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '0' COMMENT 'see define.php ALERT_* constant',
42
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
43
44
45
46
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`type`),
  KEY `type` (`type`),
  KEY `date` (`date`)
47
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
48
49
50
51
52
53


### Dump table glpi_authldapreplicates

DROP TABLE IF EXISTS `glpi_authldapreplicates`;
CREATE TABLE `glpi_authldapreplicates` (
54
55
  `id` int NOT NULL AUTO_INCREMENT,
  `authldaps_id` int NOT NULL DEFAULT '0',
56
  `host` varchar(255) DEFAULT NULL,
57
  `port` int NOT NULL DEFAULT '389',
58
  `name` varchar(255) DEFAULT NULL,
59
  `timeout` int NOT NULL DEFAULT '10',
60
61
  PRIMARY KEY (`id`),
  KEY `authldaps_id` (`authldaps_id`)
62
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
63
64
65
66
67
68


### Dump table glpi_authldaps

DROP TABLE IF EXISTS `glpi_authldaps`;
CREATE TABLE `glpi_authldaps` (
69
  `id` int NOT NULL AUTO_INCREMENT,
70
71
72
73
  `name` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `basedn` varchar(255) DEFAULT NULL,
  `rootdn` varchar(255) DEFAULT NULL,
74
  `port` int NOT NULL DEFAULT '389',
75
76
77
  `condition` text,
  `login_field` varchar(255) DEFAULT 'uid',
  `sync_field` varchar(255) DEFAULT NULL,
78
  `use_tls` tinyint NOT NULL DEFAULT '0',
79
80
  `group_field` varchar(255) DEFAULT NULL,
  `group_condition` text,
81
  `group_search_type` int NOT NULL DEFAULT '0',
82
83
84
85
86
87
88
89
  `group_member_field` varchar(255) DEFAULT NULL,
  `email1_field` varchar(255) DEFAULT NULL,
  `realname_field` varchar(255) DEFAULT NULL,
  `firstname_field` varchar(255) DEFAULT NULL,
  `phone_field` varchar(255) DEFAULT NULL,
  `phone2_field` varchar(255) DEFAULT NULL,
  `mobile_field` varchar(255) DEFAULT NULL,
  `comment_field` varchar(255) DEFAULT NULL,
90
91
92
  `use_dn` tinyint NOT NULL DEFAULT '1',
  `time_offset` int NOT NULL DEFAULT '0' COMMENT 'in seconds',
  `deref_option` int NOT NULL DEFAULT '0',
93
94
95
96
97
  `title_field` varchar(255) DEFAULT NULL,
  `category_field` varchar(255) DEFAULT NULL,
  `language_field` varchar(255) DEFAULT NULL,
  `entity_field` varchar(255) DEFAULT NULL,
  `entity_condition` text,
98
  `date_mod` timestamp NULL DEFAULT NULL,
99
  `comment` text,
100
101
  `is_default` tinyint NOT NULL DEFAULT '0',
  `is_active` tinyint NOT NULL DEFAULT '0',
102
103
104
105
106
107
108
  `rootdn_passwd` varchar(255) DEFAULT NULL,
  `registration_number_field` varchar(255) DEFAULT NULL,
  `email2_field` varchar(255) DEFAULT NULL,
  `email3_field` varchar(255) DEFAULT NULL,
  `email4_field` varchar(255) DEFAULT NULL,
  `location_field` varchar(255) DEFAULT NULL,
  `responsible_field` varchar(255) DEFAULT NULL,
109
110
111
  `pagesize` int NOT NULL DEFAULT '0',
  `ldap_maxlimit` int NOT NULL DEFAULT '0',
  `can_support_pagesize` tinyint NOT NULL DEFAULT '0',
112
  `picture_field` varchar(255) DEFAULT NULL,
113
  `date_creation` timestamp NULL DEFAULT NULL,
114
  `inventory_domain` varchar(255) DEFAULT NULL,
115
116
117
  `tls_certfile` text,
  `tls_keyfile` text,
  `use_bind` tinyint NOT NULL DEFAULT '1',
118
  `timeout` int NOT NULL DEFAULT '10',
119
120
121
122
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `is_default` (`is_default`),
  KEY `is_active` (`is_active`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
123
124
  KEY `date_creation` (`date_creation`),
  KEY `sync_field` (`sync_field`)
125
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
126
127
128
129
130
131


### Dump table glpi_authmails

DROP TABLE IF EXISTS `glpi_authmails`;
CREATE TABLE `glpi_authmails` (
132
  `id` int NOT NULL AUTO_INCREMENT,
133
134
135
  `name` varchar(255) DEFAULT NULL,
  `connect_string` varchar(255) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
136
  `date_mod` timestamp NULL DEFAULT NULL,
137
  `comment` text,
138
  `is_active` tinyint NOT NULL DEFAULT '0',
139
140
141
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `is_active` (`is_active`)
142
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
143
144
145
146
147

### Dump table glpi_apiclients

DROP TABLE IF EXISTS `glpi_apiclients`;
CREATE TABLE `glpi_apiclients` (
148
  `id` int NOT NULL AUTO_INCREMENT,
149
150
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
151
  `name` varchar(255) DEFAULT NULL,
152
  `date_mod` timestamp NULL DEFAULT NULL,
153
154
155
156
157
  `is_active` tinyint NOT NULL DEFAULT '0',
  `ipv4_range_start` bigint DEFAULT NULL,
  `ipv4_range_end` bigint DEFAULT NULL,
  `ipv6` varchar(255) DEFAULT NULL,
  `app_token` varchar(255) DEFAULT NULL,
158
  `app_token_date` timestamp NULL DEFAULT NULL,
159
  `dolog_method` tinyint NOT NULL DEFAULT '0',
160
  `comment` text,
161
162
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
163
164
165
  KEY `is_active` (`is_active`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
166
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
167
168
169
170
171
172


### Dump table glpi_autoupdatesystems

DROP TABLE IF EXISTS `glpi_autoupdatesystems`;
CREATE TABLE `glpi_autoupdatesystems` (
173
  `id` int NOT NULL AUTO_INCREMENT,
174
175
  `name` varchar(255) DEFAULT NULL,
  `comment` text,
176
177
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
178
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
179
180
181
182
183
184


### Dump table glpi_blacklistedmailcontents

DROP TABLE IF EXISTS `glpi_blacklistedmailcontents`;
CREATE TABLE `glpi_blacklistedmailcontents` (
185
  `id` int NOT NULL AUTO_INCREMENT,
186
187
188
  `name` varchar(255) DEFAULT NULL,
  `content` text,
  `comment` text,
189
190
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
191
192
193
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
194
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
195
196
197
198
199
200


### Dump table glpi_blacklists

DROP TABLE IF EXISTS `glpi_blacklists`;
CREATE TABLE `glpi_blacklists` (
201
202
  `id` int NOT NULL AUTO_INCREMENT,
  `type` int NOT NULL DEFAULT '0',
203
204
205
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `comment` text,
206
207
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
208
209
210
211
212
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
213
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
214
215


Johan Cwiklinski's avatar
Johan Cwiklinski committed
216
### Dump table glpi_savedsearches
217

Johan Cwiklinski's avatar
Johan Cwiklinski committed
218
219
DROP TABLE IF EXISTS `glpi_savedsearches`;
CREATE TABLE `glpi_savedsearches` (
220
  `id` int NOT NULL AUTO_INCREMENT,
221
  `name` varchar(255) DEFAULT NULL,
222
  `type` int NOT NULL DEFAULT '0' COMMENT 'see SavedSearch:: constants',
223
  `itemtype` varchar(100) NOT NULL,
224
225
226
227
  `users_id` int NOT NULL DEFAULT '0',
  `is_private` tinyint NOT NULL DEFAULT '1',
  `entities_id` int NOT NULL DEFAULT '-1',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
228
229
  `path` varchar(255) DEFAULT NULL,
  `query` text,
230
231
  `last_execution_time` int DEFAULT NULL,
  `do_count` tinyint NOT NULL DEFAULT '2' COMMENT 'Do or do not count results on list display see SavedSearch::COUNT_* constants',
232
  `last_execution_date` timestamp NULL DEFAULT NULL,
233
  `counter` int NOT NULL DEFAULT '0',
234
235
236
237
238
239
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `itemtype` (`itemtype`),
  KEY `entities_id` (`entities_id`),
  KEY `users_id` (`users_id`),
  KEY `is_private` (`is_private`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
240
241
  KEY `is_recursive` (`is_recursive`),
  KEY `last_execution_time` (`last_execution_time`),
242
  KEY `last_execution_date` (`last_execution_date`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
243
  KEY `do_count` (`do_count`)
244
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
245
246


Johan Cwiklinski's avatar
Johan Cwiklinski committed
247
### Dump table glpi_savedsearches_users
248

Johan Cwiklinski's avatar
Johan Cwiklinski committed
249
250
DROP TABLE IF EXISTS `glpi_savedsearches_users`;
CREATE TABLE `glpi_savedsearches_users` (
251
252
  `id` int NOT NULL AUTO_INCREMENT,
  `users_id` int NOT NULL DEFAULT '0',
253
  `itemtype` varchar(100) NOT NULL,
254
  `savedsearches_id` int NOT NULL DEFAULT '0',
255
256
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`users_id`,`itemtype`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
257
  KEY `savedsearches_id` (`savedsearches_id`)
258
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
259
260


261
262
263
264
### Dump table glpi_savedsearches_alerts

DROP TABLE IF EXISTS `glpi_savedsearches_alerts`;
CREATE TABLE `glpi_savedsearches_alerts` (
265
266
  `id` int NOT NULL AUTO_INCREMENT,
  `savedsearches_id` int NOT NULL DEFAULT '0',
267
  `name` varchar(255) DEFAULT NULL,
268
269
270
  `is_active` tinyint NOT NULL DEFAULT '0',
  `operator` tinyint NOT NULL,
  `value` int NOT NULL,
271
272
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
273
  PRIMARY KEY (`id`),
274
  UNIQUE KEY `unicity` (`savedsearches_id`,`operator`,`value`),
275
276
277
  KEY `name` (`name`),
  KEY `is_active` (`is_active`),
  KEY `date_mod` (`date_mod`),
278
279
  KEY `date_creation` (`date_creation`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
280
281


282
283
284
285
### Dump table glpi_budgets

DROP TABLE IF EXISTS `glpi_budgets`;
CREATE TABLE `glpi_budgets` (
286
  `id` int NOT NULL AUTO_INCREMENT,
287
  `name` varchar(255) DEFAULT NULL,
288
289
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
290
  `comment` text,
291
  `is_deleted` tinyint NOT NULL DEFAULT '0',
292
293
294
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `value` decimal(20,4) NOT NULL DEFAULT '0.0000',
295
  `is_template` tinyint NOT NULL DEFAULT '0',
296
  `template_name` varchar(255) DEFAULT NULL,
297
298
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
299
300
  `locations_id` int NOT NULL DEFAULT '0',
  `budgettypes_id` int NOT NULL DEFAULT '0',
301
302
303
304
305
306
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `is_recursive` (`is_recursive`),
  KEY `entities_id` (`entities_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `begin_date` (`begin_date`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
307
  KEY `end_date` (`end_date`),
308
309
310
311
312
  KEY `is_template` (`is_template`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`),
  KEY `locations_id` (`locations_id`),
  KEY `budgettypes_id` (`budgettypes_id`)
313
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
314
315
316
317
318
319


### Dump table glpi_budgettypes

DROP TABLE IF EXISTS `glpi_budgettypes`;
CREATE TABLE `glpi_budgettypes` (
320
  `id` int NOT NULL AUTO_INCREMENT,
321
322
  `name` varchar(255) DEFAULT NULL,
  `comment` text,
323
324
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
325
326
327
328
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
329
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
330

Walid Nouh's avatar
Walid Nouh committed
331
332
333
334
### Dump table glpi_businesscriticities

DROP TABLE IF EXISTS `glpi_businesscriticities`;
CREATE TABLE `glpi_businesscriticities` (
335
  `id` int NOT NULL AUTO_INCREMENT,
336
  `name` varchar(255) DEFAULT NULL,
337
338
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
339
  `comment` text,
340
341
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
342
  `businesscriticities_id` int NOT NULL DEFAULT '0',
343
  `completename` text,
344
  `level` int NOT NULL DEFAULT '0',
345
346
  `ancestors_cache` longtext,
  `sons_cache` longtext,
Walid Nouh's avatar
Walid Nouh committed
347
  PRIMARY KEY (`id`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
348
  UNIQUE KEY `unicity` (`businesscriticities_id`,`name`),
349
  KEY `name` (`name`),
Walid Nouh's avatar
Walid Nouh committed
350
  KEY `date_mod` (`date_mod`),
351
352
353
  KEY `date_creation` (`date_creation`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
354
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
Walid Nouh's avatar
Walid Nouh committed
355

356
357
358
359
360

### Dump table glpi_calendars

DROP TABLE IF EXISTS `glpi_calendars`;
CREATE TABLE `glpi_calendars` (
361
  `id` int NOT NULL AUTO_INCREMENT,
362
  `name` varchar(255) DEFAULT NULL,
363
364
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
365
  `comment` text,
366
  `date_mod` timestamp NULL DEFAULT NULL,
367
  `cache_duration` text,
368
  `date_creation` timestamp NULL DEFAULT NULL,
369
370
371
372
373
374
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
375
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
376
377
378
379
380
381


### Dump table glpi_calendars_holidays

DROP TABLE IF EXISTS `glpi_calendars_holidays`;
CREATE TABLE `glpi_calendars_holidays` (
382
383
384
  `id` int NOT NULL AUTO_INCREMENT,
  `calendars_id` int NOT NULL DEFAULT '0',
  `holidays_id` int NOT NULL DEFAULT '0',
385
386
387
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`calendars_id`,`holidays_id`),
  KEY `holidays_id` (`holidays_id`)
388
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
389
390
391
392
393
394


### Dump table glpi_calendarsegments

DROP TABLE IF EXISTS `glpi_calendarsegments`;
CREATE TABLE `glpi_calendarsegments` (
395
396
397
398
399
  `id` int NOT NULL AUTO_INCREMENT,
  `calendars_id` int NOT NULL DEFAULT '0',
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
  `day` tinyint NOT NULL DEFAULT '1' COMMENT 'numer of the day based on date(w)',
400
401
402
403
  `begin` time DEFAULT NULL,
  `end` time DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calendars_id` (`calendars_id`),
404
405
406
  KEY `day` (`day`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`)
407
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
408
409
410
411
412
413


### Dump table glpi_cartridgeitems

DROP TABLE IF EXISTS `glpi_cartridgeitems`;
CREATE TABLE `glpi_cartridgeitems` (
414
415
416
  `id` int NOT NULL AUTO_INCREMENT,
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
417
418
  `name` varchar(255) DEFAULT NULL,
  `ref` varchar(255) DEFAULT NULL,
419
420
421
422
423
424
  `locations_id` int NOT NULL DEFAULT '0',
  `cartridgeitemtypes_id` int NOT NULL DEFAULT '0',
  `manufacturers_id` int NOT NULL DEFAULT '0',
  `users_id_tech` int NOT NULL DEFAULT '0',
  `groups_id_tech` int NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
425
  `comment` text,
426
  `alarm_threshold` int NOT NULL DEFAULT '10',
427
428
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
429
430
431
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
432
  KEY `is_recursive` (`is_recursive`),
433
434
435
436
437
438
439
440
441
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `locations_id` (`locations_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `cartridgeitemtypes_id` (`cartridgeitemtypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `alarm_threshold` (`alarm_threshold`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
442
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
443

444
445
DROP TABLE IF EXISTS `glpi_printers_cartridgeinfos`;
CREATE TABLE `glpi_printers_cartridgeinfos` (
446
447
  `id` int NOT NULL AUTO_INCREMENT,
  `printers_id` int NOT NULL,
448
449
  `property` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
450
451
452
453
454
455
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `printers_id` (`printers_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
456
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
457
458
459
460
461

### Dump table glpi_cartridgeitems_printermodels

DROP TABLE IF EXISTS `glpi_cartridgeitems_printermodels`;
CREATE TABLE `glpi_cartridgeitems_printermodels` (
462
463
464
  `id` int NOT NULL AUTO_INCREMENT,
  `cartridgeitems_id` int NOT NULL DEFAULT '0',
  `printermodels_id` int NOT NULL DEFAULT '0',
465
466
467
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`printermodels_id`,`cartridgeitems_id`),
  KEY `cartridgeitems_id` (`cartridgeitems_id`)
468
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
469
470
471
472
473
474


### Dump table glpi_cartridgeitemtypes

DROP TABLE IF EXISTS `glpi_cartridgeitemtypes`;
CREATE TABLE `glpi_cartridgeitemtypes` (
475
  `id` int NOT NULL AUTO_INCREMENT,
476
477
  `name` varchar(255) DEFAULT NULL,
  `comment` text,
478
479
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
480
481
482
483
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
484
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
485
486
487
488
489
490


### Dump table glpi_cartridges

DROP TABLE IF EXISTS `glpi_cartridges`;
CREATE TABLE `glpi_cartridges` (
491
492
493
494
  `id` int NOT NULL AUTO_INCREMENT,
  `entities_id` int NOT NULL DEFAULT '0',
  `cartridgeitems_id` int NOT NULL DEFAULT '0',
  `printers_id` int NOT NULL DEFAULT '0',
495
496
497
  `date_in` date DEFAULT NULL,
  `date_use` date DEFAULT NULL,
  `date_out` date DEFAULT NULL,
498
  `pages` int NOT NULL DEFAULT '0',
499
500
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
501
502
503
504
505
506
  PRIMARY KEY (`id`),
  KEY `cartridgeitems_id` (`cartridgeitems_id`),
  KEY `printers_id` (`printers_id`),
  KEY `entities_id` (`entities_id`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
507
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
508
509


510
511
512
513
### Dump table glpi_certificates

DROP TABLE IF EXISTS `glpi_certificates`;
CREATE TABLE `glpi_certificates` (
514
  `id` int NOT NULL AUTO_INCREMENT,
515
516
517
  `name` varchar(255) DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
518
519
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
520
  `comment` text,
521
522
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_template` tinyint NOT NULL DEFAULT '0',
523
  `template_name` varchar(255) DEFAULT NULL,
524
  `certificatetypes_id` int NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_certificatetypes (id)',
525
526
  `dns_name` varchar(255) DEFAULT NULL,
  `dns_suffix` varchar(255) DEFAULT NULL,
527
528
529
530
  `users_id_tech` int NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_users (id)',
  `groups_id_tech` int NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_groups (id)',
  `locations_id` int NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_locations (id)',
  `manufacturers_id` int NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_manufacturers (id)',
531
532
  `contact` varchar(255) DEFAULT NULL,
  `contact_num` varchar(255) DEFAULT NULL,
533
534
535
  `users_id` int NOT NULL DEFAULT '0',
  `groups_id` int NOT NULL DEFAULT '0',
  `is_autosign` tinyint NOT NULL DEFAULT '0',
536
  `date_expiration` date DEFAULT NULL,
537
  `states_id` int NOT NULL DEFAULT '0' COMMENT 'RELATION to states (id)',
538
539
540
  `command` text,
  `certificate_request` text,
  `certificate_item` text,
541
542
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
543
544
545
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
546
  KEY `is_recursive` (`is_recursive`),
547
548
549
550
551
552
553
554
555
556
557
558
  KEY `is_template` (`is_template`),
  KEY `is_deleted` (`is_deleted`),
  KEY `certificatetypes_id` (`certificatetypes_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `groups_id` (`groups_id`),
  KEY `users_id` (`users_id`),
  KEY `locations_id` (`locations_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `states_id` (`states_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
559
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
560
561
562
563
564
565


### Dump table glpi_certificates_items

DROP TABLE IF EXISTS `glpi_certificates_items`;
CREATE TABLE `glpi_certificates_items` (
566
567
568
  `id` int NOT NULL AUTO_INCREMENT,
  `certificates_id` int NOT NULL DEFAULT '0',
  `items_id` int NOT NULL DEFAULT '0' COMMENT 'RELATION to various tables, according to itemtype (id)',
569
  `itemtype` varchar(100) NOT NULL COMMENT 'see .class.php file',
570
571
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
572
573
574
575
576
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`certificates_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
577
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
578
579
580
581
582
583


### Dump table glpi_certificatetypes

DROP TABLE IF EXISTS `glpi_certificatetypes`;
CREATE TABLE `glpi_certificatetypes` (
584
585
586
  `id` int NOT NULL AUTO_INCREMENT,
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
587
588
  `name` varchar(255) DEFAULT NULL,
  `comment` text,
589
590
  `date_creation` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
591
592
593
594
595
596
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `name` (`name`),
  KEY `date_creation` (`date_creation`),
  KEY `date_mod` (`date_mod`)
597
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
598
599


600
601
602
603
### Dump table glpi_changecosts

DROP TABLE IF EXISTS `glpi_changecosts`;
CREATE TABLE `glpi_changecosts` (
604
605
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
606
607
  `name` varchar(255) DEFAULT NULL,
  `comment` text,
608
609
  `begin_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
610
  `actiontime` int NOT NULL DEFAULT '0',
611
612
613
  `cost_time` decimal(20,4) NOT NULL DEFAULT '0.0000',
  `cost_fixed` decimal(20,4) NOT NULL DEFAULT '0.0000',
  `cost_material` decimal(20,4) NOT NULL DEFAULT '0.0000',
614
615
616
  `budgets_id` int NOT NULL DEFAULT '0',
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
617
618
619
620
621
622
623
624
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `changes_id` (`changes_id`),
  KEY `begin_date` (`begin_date`),
  KEY `end_date` (`end_date`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `budgets_id` (`budgets_id`)
625
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
626
627
628
629
630
631


### Dump table glpi_changes

DROP TABLE IF EXISTS `glpi_changes`;
CREATE TABLE `glpi_changes` (
632
  `id` int NOT NULL AUTO_INCREMENT,
633
  `name` varchar(255) DEFAULT NULL,
634
635
636
637
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
638
  `content` longtext,
639
640
641
642
643
  `date_mod` timestamp NULL DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  `solvedate` timestamp NULL DEFAULT NULL,
  `closedate` timestamp NULL DEFAULT NULL,
  `time_to_resolve` timestamp NULL DEFAULT NULL,
644
645
646
647
648
649
  `users_id_recipient` int NOT NULL DEFAULT '0',
  `users_id_lastupdater` int NOT NULL DEFAULT '0',
  `urgency` int NOT NULL DEFAULT '1',
  `impact` int NOT NULL DEFAULT '1',
  `priority` int NOT NULL DEFAULT '1',
  `itilcategories_id` int NOT NULL DEFAULT '0',
650
651
652
653
654
  `impactcontent` longtext,
  `controlistcontent` longtext,
  `rolloutplancontent` longtext,
  `backoutplancontent` longtext,
  `checklistcontent` longtext,
655
656
657
  `global_validation` int NOT NULL DEFAULT '1',
  `validation_percent` int NOT NULL DEFAULT '0',
  `actiontime` int NOT NULL DEFAULT '0',
658
  `begin_waiting_date` timestamp NULL DEFAULT NULL,
659
660
661
  `waiting_duration` int NOT NULL DEFAULT '0',
  `close_delay_stat` int NOT NULL DEFAULT '0',
  `solve_delay_stat` int NOT NULL DEFAULT '0',
662
  `date_creation` timestamp NULL DEFAULT NULL,
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `is_deleted` (`is_deleted`),
  KEY `date` (`date`),
  KEY `closedate` (`closedate`),
  KEY `status` (`status`),
  KEY `priority` (`priority`),
  KEY `date_mod` (`date_mod`),
  KEY `itilcategories_id` (`itilcategories_id`),
  KEY `users_id_recipient` (`users_id_recipient`),
  KEY `solvedate` (`solvedate`),
  KEY `urgency` (`urgency`),
  KEY `impact` (`impact`),
678
  KEY `time_to_resolve` (`time_to_resolve`),
679
680
681
  KEY `global_validation` (`global_validation`),
  KEY `users_id_lastupdater` (`users_id_lastupdater`),
  KEY `date_creation` (`date_creation`)
682
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
683
684
685
686
687
688


### Dump table glpi_changes_groups

DROP TABLE IF EXISTS `glpi_changes_groups`;
CREATE TABLE `glpi_changes_groups` (
689
690
691
692
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
  `groups_id` int NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '1',
693
694
695
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`type`,`groups_id`),
  KEY `group` (`groups_id`,`type`)
696
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
697
698
699
700
701
702


### Dump table glpi_changes_items

DROP TABLE IF EXISTS `glpi_changes_items`;
CREATE TABLE `glpi_changes_items` (
703
704
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
705
  `itemtype` varchar(100) DEFAULT NULL,
706
  `items_id` int NOT NULL DEFAULT '0',
707
708
709
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`itemtype`,`items_id`),
  KEY `item` (`itemtype`,`items_id`)
710
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
711
712
713
714
715
716


### Dump table glpi_changes_problems

DROP TABLE IF EXISTS `glpi_changes_problems`;
CREATE TABLE `glpi_changes_problems` (
717
718
719
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
  `problems_id` int NOT NULL DEFAULT '0',
720
721
722
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`problems_id`),
  KEY `problems_id` (`problems_id`)
723
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
724
725
726
727
728
729


### Dump table glpi_changes_suppliers

DROP TABLE IF EXISTS `glpi_changes_suppliers`;
CREATE TABLE `glpi_changes_suppliers` (
730
731
732
733
734
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
  `suppliers_id` int NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '1',
  `use_notification` tinyint NOT NULL DEFAULT '0',
735
  `alternative_email` varchar(255) DEFAULT NULL,
736
737
738
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`type`,`suppliers_id`),
  KEY `group` (`suppliers_id`,`type`)
739
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
740
741
742
743
744
745


### Dump table glpi_changes_tickets

DROP TABLE IF EXISTS `glpi_changes_tickets`;
CREATE TABLE `glpi_changes_tickets` (
746
747
748
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
  `tickets_id` int NOT NULL DEFAULT '0',
749
750
751
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`tickets_id`),
  KEY `tickets_id` (`tickets_id`)
752
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
753
754
755
756
757
758


### Dump table glpi_changes_users

DROP TABLE IF EXISTS `glpi_changes_users`;
CREATE TABLE `glpi_changes_users` (
759
760
761
762
763
  `id` int NOT NULL AUTO_INCREMENT,
  `changes_id` int NOT NULL DEFAULT '0',
  `users_id` int NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '1',
  `use_notification` tinyint NOT NULL DEFAULT '0',
764
  `alternative_email` varchar(255) DEFAULT NULL,
765
766
767
  PRIMARY KEY (`id`),
  UNIQUE KEY `unicity` (`changes_id`,`type`,`users_id`,`alternative_email`),
  KEY `user` (`users_id`,`type`)
768
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
769
770
771
772
773
774


### Dump table glpi_changetasks

DROP TABLE IF EXISTS `glpi_changetasks`;
CREATE TABLE `glpi_changetasks` (
775
  `id` int NOT NULL AUTO_INCREMENT,
776
  `uuid` varchar(255) DEFAULT NULL,
777
778
779
  `changes_id` int NOT NULL DEFAULT '0',
  `taskcategories_id` int NOT NULL DEFAULT '0',
  `state` int NOT NULL DEFAULT '0',
780
781
782
  `date` timestamp NULL DEFAULT NULL,
  `begin` timestamp NULL DEFAULT NULL,
  `end` timestamp NULL DEFAULT NULL,
783
784
785
  `users_id` int NOT NULL DEFAULT '0',
  `users_id_editor` int NOT NULL DEFAULT '0',
  `users_id_tech` int NOT NULL DEFAULT '0',
786
  `groups_id_tech` int NOT NULL DEFAULT '0',
787
  `content` longtext,
788
  `actiontime` int NOT NULL DEFAULT '0',
789
790
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
791
792
793
  `tasktemplates_id` int NOT NULL DEFAULT '0',
  `timeline_position` tinyint NOT NULL DEFAULT '0',
  `is_private` tinyint NOT NULL DEFAULT '0',
794
  PRIMARY KEY (`id`),
Cédric Anne's avatar
Cédric Anne committed
795
  UNIQUE KEY `uuid` (`uuid`),
796
797
798
  KEY `changes_id` (`changes_id`),
  KEY `state` (`state`),
  KEY `users_id` (`users_id`),
799
  KEY `users_id_editor` (`users_id_editor`),
800
801
802
803
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `date` (`date`),
  KEY `date_mod` (`date_mod`),
Johan Cwiklinski's avatar
Johan Cwiklinski committed
804
  KEY `date_creation` (`date_creation`),
805
806
  KEY `begin` (`begin`),
  KEY `end` (`end`),
807
  KEY `taskcategories_id` (`taskcategories_id`),
808
809
  KEY `tasktemplates_id` (`tasktemplates_id`),
  KEY `is_private` (`is_private`)
810
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
811
812
813
814
815
816


### Dump table glpi_changevalidations

DROP TABLE IF EXISTS `glpi_changevalidations`;
CREATE TABLE `glpi_changevalidations` (
817
818
819
820
821
822
  `id` int NOT NULL AUTO_INCREMENT,
  `entities_id` int NOT NULL DEFAULT '0',
  `is_recursive` tinyint NOT NULL DEFAULT '0',
  `users_id` int NOT NULL DEFAULT '0',
  `changes_id` int NOT NULL DEFAULT '0',
  `users_id_validate` int NOT NULL DEFAULT '0',
823
824
  `comment_submission` text,
  `comment_validation` text,
825
  `status` int NOT NULL DEFAULT '2',
826
827
  `submission_date` timestamp NULL DEFAULT NULL,
  `validation_date` timestamp NULL DEFAULT NULL,
828
  `timeline_position` tinyint NOT NULL DEFAULT '0',
829
830
831
832
833
834
835
836
837
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_recursive` (`is_recursive`),
  KEY `users_id` (`users_id`),
  KEY `users_id_validate` (`users_id_validate`),
  KEY `changes_id` (`changes_id`),
  KEY `submission_date` (`submission_date`),
  KEY `validation_date` (`validation_date`),
  KEY `status` (`status`)
838
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
839
840
841
842
843
844


### Dump table glpi_computerantiviruses

DROP TABLE IF EXISTS `glpi_computerantiviruses`;
CREATE TABLE `glpi_computerantiviruses` (
845
846
  `id` int NOT NULL AUTO_INCREMENT,
  `computers_id` int NOT NULL DEFAULT '0',
847
  `name` varchar(255) DEFAULT NULL,
848
  `manufacturers_id` int NOT NULL DEFAULT '0',
849
850
  `antivirus_version` varchar(255) DEFAULT NULL,
  `signature_version` varchar(255) DEFAULT NULL,
851
852
853
854
  `is_active` tinyint NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_uptodate` tinyint NOT NULL DEFAULT '0',
  `is_dynamic` tinyint NOT NULL DEFAULT '0',
855
856
857
  `date_expiration` timestamp NULL DEFAULT NULL,
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
858
859
860
861
862
863
864
865
866
867
868
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `antivirus_version` (`antivirus_version`),
  KEY `signature_version` (`signature_version`),
  KEY `is_active` (`is_active`),
  KEY `is_uptodate` (`is_uptodate`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `is_deleted` (`is_deleted`),
  KEY `computers_id` (`computers_id`),
  KEY `date_expiration` (`date_expiration`),
  KEY `date_mod` (`date_mod`),
869
870
  KEY `date_creation` (`date_creation`),
  KEY `manufacturers_id` (`manufacturers_id`)
871
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
872
873


Johan Cwiklinski's avatar
Johan Cwiklinski committed
874
### Dump table glpi_items_disks
875

Johan Cwiklinski's avatar
Johan Cwiklinski committed
876
877
DROP TABLE IF EXISTS `glpi_items_disks`;
CREATE TABLE `glpi_items_disks` (
878
879
  `id` int NOT NULL AUTO_INCREMENT,
  `entities_id` int NOT NULL DEFAULT '0',
880
  `itemtype` varchar(255) DEFAULT NULL,
881
  `items_id` int NOT NULL DEFAULT '0',
882
883
884
  `name` varchar(255) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `mountpoint` varchar(255) DEFAULT NULL,
885
886
887
888
889
890
  `filesystems_id` int NOT NULL DEFAULT '0',
  `totalsize` int NOT NULL DEFAULT '0',
  `freesize` int NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_dynamic` tinyint NOT NULL DEFAULT '0',
  `encryption_status` int NOT NULL DEFAULT '0',
891
892
893
  `encryption_tool` varchar(255) DEFAULT NULL,
  `encryption_algorithm` varchar(255) DEFAULT NULL,
  `encryption_type` varchar(255) DEFAULT NULL,
894
895
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
896
897
898
899
900
901
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `device` (`device`),
  KEY `mountpoint` (`mountpoint`),
  KEY `totalsize` (`totalsize`),
  KEY `freesize` (`freesize`),
902
  KEY `item` (`itemtype`,`items_id`),
903
904
905
906
907
908
  KEY `filesystems_id` (`filesystems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `date_mod` (`date_mod`),
  KEY `date_creation` (`date_creation`)
909
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
910
911
912
913
914
915


### Dump table glpi_computermodels

DROP TABLE IF EXISTS `glpi_computermodels`;
CREATE TABLE `glpi_computermodels` (
916
  `id` int NOT NULL AUTO_INCREMENT,
917
918
919
  `name` varchar(255) DEFAULT NULL,
  `comment` text,
  `product_number` varchar(255) DEFAULT NULL,
920
921
  `weight` int NOT NULL DEFAULT '0',
  `required_units` int NOT NULL DEFAULT '1',
922
  `depth` float NOT NULL DEFAULT '1',
923
924
925
  `power_connections` int NOT NULL DEFAULT '0',
  `power_consumption` int NOT NULL DEFAULT '0',
  `is_half_rack` tinyint NOT NULL DEFAULT '0',
926
927
  `picture_front` text,
  `picture_rear` text,
928
929
  `date_mod` timestamp NULL DEFAULT NULL,
  `date_creation` timestamp NULL DEFAULT NULL,
930
931
932
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `date_mod` (`date_mod`),
933
934
  KEY `date_creation` (`date_creation`),
  KEY `product_number` (`product_number`)
935
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
936
937
938
939
940
941


### Dump table glpi_computers

DROP TABLE IF EXISTS `glpi_computers`;
CREATE TABLE `glpi_computers` (
942
943
  `id` int NOT NULL AUTO_INCREMENT,
  `entities_id` int NOT NULL DEFAULT '0',
944
945
946
947
948
  `name` varchar(255) DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `otherserial` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `contact_num` varchar(255) DEFAULT NULL,
949
950
  `users_id_tech` int NOT NULL DEFAULT '0',
  `groups_id_tech` int NOT NULL DEFAULT '0',
951
  `comment` text,
952
  `date_mod` timestamp NULL DEFAULT NULL,
953
954
955
956
957
958
  `autoupdatesystems_id` int NOT NULL DEFAULT '0',
  `locations_id` int NOT NULL DEFAULT '0',
  `networks_id` int NOT NULL DEFAULT '0',
  `computermodels_id` int NOT NULL DEFAULT '0',
  `computertypes_id` int NOT NULL DEFAULT '0',
  `is_template` tinyint NOT NULL DEFAULT '0',
959
  `template_name` varchar(255) DEFAULT NULL,
960
961
962
963
964
965
  `manufacturers_id` int NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_dynamic` tinyint NOT NULL DEFAULT '0',
  `users_id` int NOT NULL DEFAULT '0',
  `groups_id` int NOT NULL DEFAULT '0',
  `states_id` int NOT NULL DEFAULT '0',
966
  `ticket_tco` decimal(20,4) DEFAULT '0.0000',
967
  `uuid` varchar(255) DEFAULT NULL,
968
  `date_creation` timestamp NULL DEFAULT NULL,
969
  `is_recursive` tinyint NOT NULL DEFAULT '0',
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
  PRIMARY KEY (`id`),
  KEY `date_mod` (`date_mod`),
  KEY `name` (`name`),
  KEY `is_template` (`is_template`),
  KEY `autoupdatesystems_id` (`autoupdatesystems_id`),
  KEY `entities_id` (`entities_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `groups_id` (`groups_id`),
  KEY `users_id` (`users_id`),
  KEY `locations_id` (`locations_id`),
  KEY `computermodels_id` (`computermodels_id`),
  KEY `networks_id` (`networks_id`),
  KEY `states_id` (`states_id`),
  KEY `users_id_tech` (`users_id_tech`),
  KEY `computertypes_id` (`computertypes_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `groups_id_tech` (`groups_id_tech`),
  KEY `is_dynamic` (`is_dynamic`),
  KEY `serial` (`serial`),
  KEY `otherserial` (`otherserial`),
  KEY `uuid` (`uuid`),
  KEY `date_creation` (`date_creation`),
  KEY `is_recursive` (`is_recursive`)
993
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
994
995
996
997
998
999


### Dump table glpi_computers_items

DROP TABLE IF EXISTS `glpi_computers_items`;
CREATE TABLE `glpi_computers_items` (
1000
1001
1002
  `id` int NOT NULL AUTO_INCREMENT,
  `items_id` int NOT NULL DEFAULT '0' COMMENT 'RELATION to various table, according to itemtype (ID)',
  `computers_id` int NOT NULL DEFAULT '0',
1003
  `itemtype` varchar(100) NOT NULL,
1004
1005
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_dynamic` tinyint NOT NULL DEFAULT '0',
1006
1007
1008
1009
1010
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`),
  KEY `item` (`itemtype`,`items_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`)
1011
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
1012
1013


cconard96's avatar
cconard96 committed
1014
1015
### Previously glpi_computers_softwarelicenses < 9.5.0
### Dump table glpi_items_softwarelicenses
1016

cconard96's avatar
cconard96 committed
1017
1018
DROP TABLE IF EXISTS `glpi_items_softwarelicenses`;
CREATE TABLE `glpi_items_softwarelicenses` (
1019
1020
  `id` int NOT NULL AUTO_INCREMENT,
  `items_id` int NOT NULL DEFAULT '0',
cconard96's avatar
cconard96 committed
1021
  `itemtype` varchar(100) NOT NULL,
1022
1023
1024
  `softwarelicenses_id` int NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_dynamic` tinyint NOT NULL DEFAULT '0',
1025
  PRIMARY KEY (`id`),
1026
  KEY `item` (`itemtype`,`items_id`),
1027
1028
1029
  KEY `softwarelicenses_id` (`softwarelicenses_id`),
  KEY `is_deleted` (`is_deleted`),
  KEY `is_dynamic` (`is_dynamic`)
1030
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
1031

cconard96's avatar
cconard96 committed
1032
1033
### Previously glpi_computers_softwareversions < 9.5.0
### Dump table glpi_items_softwareversions
1034

cconard96's avatar
cconard96 committed
1035
1036
DROP TABLE IF EXISTS `glpi_items_softwareversions`;
CREATE TABLE `glpi_items_softwareversions` (
1037
1038
  `id` int NOT NULL AUTO_INCREMENT,
  `items_id` int NOT NULL DEFAULT '0',
cconard96's avatar
cconard96 committed
1039
  `itemtype` varchar(100) NOT NULL,
1040
1041
1042
1043
1044
1045
  `softwareversions_id` int NOT NULL DEFAULT '0',
  `is_deleted_item` tinyint NOT NULL DEFAULT '0',
  `is_template_item` tinyint NOT NULL DEFAULT '0',
  `entities_id` int NOT NULL DEFAULT '0',
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `is_dynamic` tinyint NOT NULL DEFAULT '0',
1046
1047
  `date_install` date DEFAULT NULL,
  PRIMARY KEY (`id`),
1048
  UNIQUE KEY `unicity` (`itemtype`,`items_id`,`softwareversions_id`),
1049
  KEY `softwareversions_id` (`softwareversions_id`),
cconard96's avatar
cconard96 committed
1050
  KEY `computers_info` (`entities_id`,`is_template_item`,`is_deleted_item`),
1051
  KEY `is_deleted` (`is_deleted`),
1052
  KEY `is_dynamic` (`is_dynamic`),
1053
1054
  KEY `is_deleted_item` (`is_deleted_item`),
  KEY `is_template_item` (`is_template_item`),
1055
  KEY `date_install` (`date_install`)
Cédric Anne's avatar