[Glpi-dev] Correction du plugin install

David DURIEUX Mon, 28 Jul 2008 05:59:41 -0700

Bonjour,

Correction des index mysql du plugin install


Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : [EMAIL PROTECTED]
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Créacité)
69400 Villefranche sur Saône

DROP TABLE IF EXISTS `glpi_plugin_install`;
CREATE TABLE `glpi_plugin_install` (
  `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 '',
  `type` tinyint(4) NOT NULL default '0',
  `state` tinyint(4) NOT NULL default '0',
  `user` int(4) NOT NULL default '0',
  `manager` int(4) NOT NULL default '0',
  `FK_group` int(4) NOT NULL default '0',
  `FK_enterprise` int(4) NOT NULL default '0',
  `recipient` int(4) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `begin_date` date NOT NULL default '0000-00-00',
  `delivery_date` date NOT NULL default '0000-00-00',
  `num_immo` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `is_template` smallint(6) NOT NULL default '0',
  `tplname` varchar(200) collate utf8_unicode_ci NOT NULL default '',
  `deleted` smallint(6) NOT NULL default '0',
  `comments` text,
  `notes` longtext,
  PRIMARY KEY  (`ID`),
  KEY `deleted` (`deleted`),
  KEY `is_template` (`is_template`,`FK_entities`,`name`),
  KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_plugin_install_needs`;
CREATE TABLE `glpi_plugin_install_needs` (
  `ID` int(11) NOT NULL auto_increment,
  `FK_install` int(11) NOT NULL default '0',
  `device_type` int(11) NOT NULL default '0',
  `comments` text,
  `is_template` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `FK_install` (`FK_install`,`device_type`),
  KEY `FK_install_2` (`FK_install`),
  KEY `FK_device` (`device_type`),
  KEY `device_type` (`device_type`,`FK_install`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_plugin_install_device`;
CREATE TABLE `glpi_plugin_install_device` (
  `ID` int(11) NOT NULL auto_increment,
  `FK_install` int(11) NOT NULL default '0',
  `FK_device` int(11) NOT NULL default '0',
  `device_type` int(11) NOT NULL default '0',
  `is_template` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `FK_install` (`FK_install`,`FK_device`,`device_type`),
  KEY `FK_device` (`FK_device`,`device_type`),
  KEY `device_type` (`device_type`,`FK_device`),
  KEY `FK_install_2` (`FK_install`,`device_type`,`FK_device`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_dropdown_plugin_install_type`;
CREATE TABLE `glpi_dropdown_plugin_install_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`),
  KEY `FK_entities` (`FK_entities`,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_dropdown_plugin_install_state`;
CREATE TABLE `glpi_dropdown_plugin_install_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,
  PRIMARY KEY  (`ID`),
  KEY `name` (`name`),
  KEY `FK_entities` (`FK_entities`,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_plugin_install_tasks`;
CREATE TABLE `glpi_plugin_install_tasks` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `FK_install` int(11) NOT NULL default '0',
  `type_task` int(4) NOT NULL default '0',
  `assign` int(11) NOT NULL default '0',
  `assign_group` int(11) NOT NULL default '0',
  `FK_enterprise` int(11) NOT NULL default '0',
  `begin_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `end_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `use_planning` smallint(6) NOT NULL default '1',
  `realtime` float DEFAULT '0' NOT NULL,
  `installed` int(11) NOT NULL default '0',
  `comments` text,
  `deleted` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `FK_install` (`FK_install`),
  KEY `end_date` (`end_date`),
  KEY `deleted` (`deleted`),
  KEY `installed` (`installed`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_dropdown_plugin_install_tasks_type`;
CREATE TABLE `glpi_dropdown_plugin_install_tasks_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`),
  KEY `FK_entities` (`FK_entities`,`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_plugin_install_tasks_items`;
CREATE TABLE `glpi_plugin_install_tasks_items` (
	`ID` int(11) NOT NULL auto_increment,
	`FK_task` int(11) NOT NULL default '0',
	`FK_device` int(11) NOT NULL default '0',
	`device_type` int(11) NOT NULL default '0',
	`is_template` smallint(6) NOT NULL default '0',
	PRIMARY KEY  (`ID`),
	KEY `FK_device` (`FK_device`,`FK_task`),
	KEY `FK_device_2` (`FK_device`),
	KEY `device_type` (`device_type`,`FK_device`,`FK_task`),
	KEY `FK_task` (`FK_task`,`device_type`,`FK_device`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_plugin_install_profiles`;
CREATE TABLE `glpi_plugin_install_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 'install',
  `is_default` smallint(6) NOT NULL default '0',
  `install` char(1) default NULL,
  `task` char(1) default NULL,
  `all` char(1) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `interface` (`interface`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `glpi_plugin_install_mailing`;
CREATE TABLE `glpi_plugin_install_mailing` (
  `ID` int(11) NOT NULL auto_increment,
  `type` varchar(255) collate utf8_unicode_ci default NULL,
  `FK_item` int(11) NOT NULL default '0',
  `item_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `mailings` (`type`,`FK_item`,`item_type`),
  KEY `type` (`type`),
  KEY `FK_item` (`FK_item`),
  KEY `item_type` (`item_type`),
  KEY `items` (`item_type`,`FK_item`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO glpi_plugin_install_mailing ( `ID` , `type` , `FK_item` , `item_type`) VALUES ('1','install','1','1');
INSERT INTO glpi_plugin_install_mailing ( `ID` , `type` , `FK_item` , `item_type`) VALUES ('2','task','1','1');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2100', '2', '1', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2100', '3', '2', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2100', '4', '3', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2100', '5', '4', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2100', '6', '5', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2100', '8', '6', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2101', '2', '1', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2101', '3', '2', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2101', '4', '3', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2101', '6', '4', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2101', '7', '5', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2102', '2', '1', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2102', '3', '2', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2102', '6', '3', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2102', '4', '4', '0');
INSERT INTO `glpi_display` ( `ID` , `type` , `num` , `rank` , `FK_users` ) VALUES (NULL , '2102', '5', '5', '0');

_______________________________________________
Glpi-dev mailing list
Glpi-dev@gna.org
https://mail.gna.org/listinfo/glpi-dev

[Glpi-dev] Correction du plugin install

Reply via email to