-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy pathempty-1.7.0.sql
73 lines (66 loc) · 3.39 KB
/
empty-1.7.0.sql
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
DROP TABLE IF EXISTS `glpi_plugin_badges_badges`;
CREATE TABLE `glpi_plugin_badges_badges` (
`id` int(11) NOT NULL auto_increment,
`entities_id` int(11) NOT NULL default '0',
`name` varchar(255) collate utf8_unicode_ci default NULL,
`serial` varchar(255) collate utf8_unicode_ci default NULL,
`plugin_badges_badgetypes_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_badges_badgetypes (id)',
`locations_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_locations (id)',
`date_affectation` date default NULL,
`date_expiration` date default NULL,
`states_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_states (id)',
`users_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_users (id)',
`is_helpdesk_visible` int(11) NOT NULL default '1',
`date_mod` datetime default NULL,
`comment` text collate utf8_unicode_ci,
`notepad` longtext collate utf8_unicode_ci,
`is_deleted` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`),
KEY `plugin_badges_badgetypes_id` (`plugin_badges_badgetypes_id`),
KEY `locations_id` (`locations_id`),
KEY `date_expiration` (`date_expiration`),
KEY `states_id` (`states_id`),
KEY `users_id` (`users_id`),
KEY `is_helpdesk_visible` (`is_helpdesk_visible`),
KEY `is_deleted` (`is_deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_badges_badgetypes`;
CREATE TABLE `glpi_plugin_badges_badgetypes` (
`id` int(11) NOT NULL auto_increment,
`entities_id` int(11) NOT NULL default '0',
`name` varchar(255) collate utf8_unicode_ci default NULL,
`comment` text collate utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `entities_id` (`entities_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_badges_profiles`;
CREATE TABLE `glpi_plugin_badges_profiles` (
`id` int(11) NOT NULL auto_increment,
`profiles_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_profiles (id)',
`badges` char(1) collate utf8_unicode_ci default NULL,
`open_ticket` char(1) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`),
KEY `profiles_id` (`profiles_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_badges_notificationstates`;
CREATE TABLE `glpi_plugin_badges_notificationstates` (
`id` int(11) NOT NULL auto_increment,
`states_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_states (id)',
PRIMARY KEY (`id`),
KEY `states_id` (`states_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_badges_configs`;
CREATE TABLE `glpi_plugin_badges_configs` (
`id` int(11) NOT NULL auto_increment,
`delay_expired` varchar(50) collate utf8_unicode_ci NOT NULL default '30',
`delay_whichexpire` varchar(50) collate utf8_unicode_ci NOT NULL default '30',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `glpi_plugin_badges_configs` VALUES (1, '30', '30');
INSERT INTO `glpi_notificationtemplates` VALUES(NULL, 'Alert Badges', 'PluginBadgesBadge', '2010-02-23 23:44:46','',NULL);
INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginBadgesBadge','3','2','0');
INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginBadgesBadge','4','3','0');
INSERT INTO `glpi_displaypreferences` VALUES (NULL,'PluginBadgesBadge','5','4','0');