forked from InfotelGLPI/webapplications
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathempty-4.0.0.sql
More file actions
63 lines (56 loc) · 3.45 KB
/
Copy pathempty-4.0.0.sql
File metadata and controls
63 lines (56 loc) · 3.45 KB
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
DROP TABLE IF EXISTS `glpi_plugin_webapplications_webapplicationservertypes`;
CREATE TABLE `glpi_plugin_webapplications_webapplicationservertypes` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255)
COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` TEXT COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
INSERT INTO `glpi_plugin_webapplications_webapplicationservertypes` VALUES ('1', 'Apache', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationservertypes` VALUES ('2', 'IIS', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationservertypes` VALUES ('3', 'Nginx', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationservertypes` VALUES ('4', 'PRTG', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationservertypes` VALUES ('5', 'Tomcat', '');
DROP TABLE IF EXISTS `glpi_plugin_webapplications_webapplicationtypes`;
CREATE TABLE `glpi_plugin_webapplications_webapplicationtypes` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`entities_id` int unsigned NOT NULL DEFAULT '0',
`name` VARCHAR(255)
COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` TEXT COLLATE utf8mb4_unicode_ci,
`is_recursive` tinyint NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `glpi_plugin_webapplications_webapplicationtechnics`;
CREATE TABLE `glpi_plugin_webapplications_webapplicationtechnics` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255)
COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`comment` TEXT COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES ('1', 'Asp', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES ('2', 'Cgi', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES ('3', 'Java', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES ('4', 'Perl', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES ('5', 'Php', '');
INSERT INTO `glpi_plugin_webapplications_webapplicationtechnics` VALUES ('6', '.Net', '');
DROP TABLE IF EXISTS `glpi_plugin_webapplications_appliances`;
CREATE TABLE `glpi_plugin_webapplications_appliances` (
`id` int unsigned NOT NULL auto_increment,
`appliances_id` int unsigned NOT NULL,
`webapplicationtypes_id` int unsigned NOT NULL DEFAULT '0'
COMMENT 'RELATION to glpi_plugin_webapplications_webapplicationtypes (id)',
`webapplicationservertypes_id` int unsigned NOT NULL DEFAULT '0'
COMMENT 'RELATION to glpi_plugin_webapplications_webapplicationservertypes (id)',
`webapplicationtechnics_id` int unsigned NOT NULL DEFAULT '0'
COMMENT 'RELATION to glpi_plugin_webapplications_webapplicationtechnics (id)',
`address` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`backoffice` VARCHAR(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `appliances_id` (`appliances_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;