forked from InfotelGLPI/webapplications
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathempty-1.3.sql
More file actions
119 lines (111 loc) · 5.37 KB
/
Copy pathempty-1.3.sql
File metadata and controls
119 lines (111 loc) · 5.37 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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
DROP TABLE IF EXISTS `glpi_plugin_appweb`;
CREATE TABLE `glpi_plugin_appweb` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`FK_entities` INT(11) NOT NULL DEFAULT '0',
`name` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`address` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`type` INT(4) NOT NULL DEFAULT '0',
`server` INT(4) NOT NULL DEFAULT '0',
`technic` INT(4) NOT NULL DEFAULT '0',
`version` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`port` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`protocol` INT(4) NOT NULL DEFAULT '0',
`link_name` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`FK_enterprise` SMALLINT(6) NOT NULL DEFAULT '0',
`FK_glpi_enterprise` SMALLINT(6) NOT NULL DEFAULT '0',
`target` SMALLINT(6) NOT NULL DEFAULT '0',
`location` INT(4) NOT NULL DEFAULT '0',
`notes` LONGTEXT,
`comment` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`deleted` SMALLINT(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_dropdown_plugin_appweb_type`;
CREATE TABLE `glpi_dropdown_plugin_appweb_type` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`FK_entities` INT(11) NOT NULL DEFAULT '0',
`name` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`comments` TEXT,
PRIMARY KEY (`ID`),
KEY `name` (`name`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_dropdown_plugin_appweb_server_type`;
CREATE TABLE `glpi_dropdown_plugin_appweb_server_type` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`comments` TEXT,
PRIMARY KEY (`ID`),
KEY `name` (`name`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci;
INSERT INTO `glpi_dropdown_plugin_appweb_server_type` (`ID`, `name`, `comments`) VALUES ('1', 'Apache', '');
INSERT INTO `glpi_dropdown_plugin_appweb_server_type` (`ID`, `name`, `comments`) VALUES ('2', 'IIS', '');
INSERT INTO `glpi_dropdown_plugin_appweb_server_type` (`ID`, `name`, `comments`) VALUES ('3', 'Tomcat', '');
DROP TABLE IF EXISTS `glpi_dropdown_plugin_appweb_technic`;
CREATE TABLE `glpi_dropdown_plugin_appweb_technic` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`comments` TEXT,
PRIMARY KEY (`ID`),
KEY `name` (`name`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci;
INSERT INTO `glpi_dropdown_plugin_appweb_technic` (`ID`, `name`, `comments`) VALUES ('1', 'Asp', '');
INSERT INTO `glpi_dropdown_plugin_appweb_technic` (`ID`, `name`, `comments`) VALUES ('2', 'Cgi', '');
INSERT INTO `glpi_dropdown_plugin_appweb_technic` (`ID`, `name`, `comments`) VALUES ('3', 'Java', '');
INSERT INTO `glpi_dropdown_plugin_appweb_technic` (`ID`, `name`, `comments`) VALUES ('4', 'Perl', '');
INSERT INTO `glpi_dropdown_plugin_appweb_technic` (`ID`, `name`, `comments`) VALUES ('5', 'Php', '');
INSERT INTO `glpi_dropdown_plugin_appweb_technic` (`ID`, `name`, `comments`) VALUES ('6', '.Net', '');
DROP TABLE IF EXISTS `glpi_plugin_appweb_device`;
CREATE TABLE `glpi_plugin_appweb_device` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`FK_appweb` INT(11) NOT NULL DEFAULT '0',
`FK_device` INT(11) NOT NULL DEFAULT '0',
`device_type` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `FK_compte` (`FK_appweb`, `FK_device`, `device_type`),
KEY `FK_appweb_2` (`FK_appweb`),
KEY `FK_device` (`FK_device`, `device_type`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_appweb_profiles`;
CREATE TABLE `glpi_plugin_appweb_profiles` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255)
COLLATE utf8_unicode_ci DEFAULT NULL,
`interface` VARCHAR(50)
COLLATE utf8_unicode_ci NOT NULL DEFAULT 'appweb',
`is_default` SMALLINT(6) NOT NULL DEFAULT '0',
`appweb` CHAR(1) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `interface` (`interface`)
)
ENGINE = MyISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci;
INSERT INTO `glpi_display` (`ID`, `type`, `num`, `rank`, `FK_users`) VALUES (NULL, '1300', '2', '2', '0');
INSERT INTO `glpi_display` (`ID`, `type`, `num`, `rank`, `FK_users`) VALUES (NULL, '1300', '6', '3', '0');
INSERT INTO `glpi_display` (`ID`, `type`, `num`, `rank`, `FK_users`) VALUES (NULL, '1300', '7', '4', '0');
INSERT INTO `glpi_display` (`ID`, `type`, `num`, `rank`, `FK_users`) VALUES (NULL, '1300', '8', '5', '0');
INSERT INTO `glpi_display` (`ID`, `type`, `num`, `rank`, `FK_users`) VALUES (NULL, '1300', '12', '6', '0');