Bonjour,
Modif des index des tables du plugin ACL
Cordialement,
David DURIEUX
Tel : 04.74.04.81.34
Port : 06.18.42.55.27
Mail : [EMAIL PROTECTED]
Site Web : http://www.siprossii.com/
SIPROSSII
509 rue d'Anse
69400 Villefranche sur Saône
DROP TABLE IF EXISTS `glpi_plugin_acl`;
CREATE TABLE `glpi_plugin_acl` (
`ID` int(10) NOT NULL auto_increment,
`FK_entities` int(11) NOT NULL default '0',
`name` varchar(255) default NULL,
`type_regle` int(8) default NULL,
`state` int(8) NOT NULL,
`ip_src` varchar(255) default NULL,
`prt_src` varchar(255) default NULL,
`ip_dst` varchar(255) default NULL,
`prt_dst` varchar(255) default NULL,
`protocol` int(8) NOT NULL,
`comments` text,
`deleted` smallint(6) NOT NULL default '0',
`notes` longtext collate utf8_unicode_ci,
PRIMARY KEY (`ID`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_acl_device`;
CREATE TABLE `glpi_plugin_acl_device` (
`ID` int(11) NOT NULL auto_increment,
`FK_acl` int(11) NOT NULL default '0',
`FK_device` int(11) NOT NULL default '0',
`device_type` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `FK_acl` (`FK_acl`,`FK_device`,`device_type`),
KEY `FK_acl_2` (`FK_acl`),
KEY `FK_device` (`FK_device`,`device_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_dropdown_plugin_acl_state`;
CREATE TABLE `glpi_dropdown_plugin_acl_state` (
`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 collate utf8_unicode_ci,
PRIMARY KEY (`ID`),
KEY `name` (`name`),
KEY `FK_entities` (`FK_entities`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_dropdown_plugin_acl_type`;
CREATE TABLE `glpi_dropdown_plugin_acl_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 collate utf8_unicode_ci,
PRIMARY KEY (`ID`),
KEY `name` (`name`),
KEY `FK_entities` (`FK_entities`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_dropdown_plugin_acl_protocol_type`;
CREATE TABLE `glpi_dropdown_plugin_acl_protocol_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 collate utf8_unicode_ci,
PRIMARY KEY (`ID`),
KEY `name` (`name`),
KEY `FK_entities` (`FK_entities`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
DROP TABLE IF EXISTS `glpi_plugin_acl_profiles`;
CREATE TABLE `glpi_plugin_acl_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 'acl',
`is_default` smallint(6) NOT NULL default '0',
`acl` 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,'2900','3','2','0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL,'2900','4','3','0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL,'2900','5','4','0');___
Glpi-dev mailing list
Glpi-dev@gna.org
https://mail.gna.org/listinfo/glpi-dev