Drop index for migration
public dropKey ( $table, $indexname ) | ||
$table | string | |
$indexname | string |
function plugin_archires_updateTo180() { $migration = new Migration(180); $migration->renameTable("glpi_plugin_archires_query_location", "glpi_plugin_archires_locationqueries"); $migration->renameTable("glpi_plugin_archires_query_switch", "glpi_plugin_archires_networkequipmentqueries"); $migration->renameTable("glpi_plugin_archires_query_applicatifs", "glpi_plugin_archires_appliancequeries"); $migration->renameTable("glpi_plugin_archires_image_device", "glpi_plugin_archires_imageitems"); $migration->renameTable("glpi_plugin_archires_query_type", "glpi_plugin_archires_querytypes"); $migration->renameTable("glpi_plugin_archires_color_iface", "glpi_plugin_archires_networkinterfacecolors"); $migration->renameTable("glpi_plugin_archires_color_state", "glpi_plugin_archires_statecolors"); $migration->renameTable("glpi_plugin_archires_color_vlan", "glpi_plugin_archires_vlancolors"); $migration->renameTable("glpi_plugin_archires_config", "glpi_plugin_archires_views"); $migration->dropKey("glpi_plugin_archires_locationqueries", "deleted"); $migration->changeField("glpi_plugin_archires_locationqueries", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_locationqueries", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_locationqueries", "location", "locations_id", 'integer', array('comment' => 'RELATION to glpi_locations (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "network", "networks_id", 'integer', array('comment' => 'RELATION to glpi_networks (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_group", "groups_id", 'integer', array('comment' => 'RELATION to glpi_groups (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_config", "plugin_archires_views_id", 'integer', array('comment' => 'RELATION to glpi_plugin_archires_views (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "FK_vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->changeField("glpi_plugin_archires_locationqueries", "deleted", "is_deleted", 'bool'); $migration->changeField("glpi_plugin_archires_locationqueries", "notes", "notepad", 'longtext'); $migration->dropField("glpi_plugin_archires_locationqueries", "link"); $migration->addKey("glpi_plugin_archires_locationqueries", "name"); $migration->addKey("glpi_plugin_archires_locationqueries", "entities_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "locations_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "networks_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "groups_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "plugin_archires_views_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "states_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "vlans_id"); $migration->addKey("glpi_plugin_archires_locationqueries", "is_deleted"); $migration->dropKey("glpi_plugin_archires_networkequipmentqueries", "deleted"); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "switch", "networkequipments_id", 'integer', array('comment' => 'RELATION to glpi_networkequipments (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "network", "networks_id", 'integer', array('comment' => 'RELATION to glpi_networks (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_group", "groups_id", 'integer', array('comment' => 'RELATION to glpi_groups (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_config", "plugin_archires_views_id", 'integer', array('comment' => 'RELATION to glpi_plugin_archires_views (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "FK_vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "deleted", "is_deleted", 'bool'); $migration->changeField("glpi_plugin_archires_networkequipmentqueries", "notes", "notepad", 'longtext'); $migration->dropField("glpi_plugin_archires_networkequipmentqueries", "link"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "name"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "entities_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "networkequipments_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "networks_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "groups_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "plugin_archires_views_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "states_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "vlans_id"); $migration->addKey("glpi_plugin_archires_networkequipmentqueries", "is_deleted"); $migration->dropKey("glpi_plugin_archires_appliancequeries", "deleted"); $migration->changeField("glpi_plugin_archires_appliancequeries", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_appliancequeries", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_appliancequeries", "applicatifs", "appliances_id", 'integer', array('comment' => 'RELATION to glpi_plugin_appliances (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "network", "networks_id", 'integer', array('comment' => 'RELATION to glpi_networks (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_group", "groups_id", 'integer', array('comment' => 'RELATION to glpi_groups (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_config", "plugin_archires_views_id", 'integer', array('comment' => 'RELATION to glpi_plugin_archires_views (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "FK_vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->changeField("glpi_plugin_archires_appliancequeries", "deleted", "is_deleted", 'bool'); $migration->changeField("glpi_plugin_archires_appliancequeries", "notes", "notepad", 'longtext'); $migration->dropField("glpi_plugin_archires_appliancequeries", "link"); $migration->addKey("glpi_plugin_archires_appliancequeries", "name"); $migration->addKey("glpi_plugin_archires_appliancequeries", "entities_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "appliances_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "networks_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "groups_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "plugin_archires_views_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "states_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "vlans_id"); $migration->addKey("glpi_plugin_archires_appliancequeries", "is_deleted"); $migration->dropKey("glpi_plugin_archires_imageitems", "device_type"); $migration->changeField("glpi_plugin_archires_imageitems", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_imageitems", "type", "type", 'integer'); $migration->changeField("glpi_plugin_archires_imageitems", "device_type", "itemtype", "varchar(100) collate utf8_unicode_ci NOT NULL", array('comment' => 'see .class.php file')); $migration->dropKey("glpi_plugin_archires_querytypes", "FK_query"); $migration->dropKey("glpi_plugin_archires_querytypes", "type"); $migration->dropKey("glpi_plugin_archires_querytypes", "type_query"); $migration->dropKey("glpi_plugin_archires_querytypes", "device_type"); $migration->changeField("glpi_plugin_archires_querytypes", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_querytypes", "type_query", "querytype", "varchar(100) collate utf8_unicode_ci NOT NULL", array('comment' => 'RELATION to the 3 type of archires (type)')); $migration->changeField("glpi_plugin_archires_querytypes", "type", "type", 'integer'); $migration->changeField("glpi_plugin_archires_querytypes", "device_type", "itemtype", "varchar(100) collate utf8_unicode_ci NOT NULL", array('comment' => 'see .class.php file')); $migration->changeField("glpi_plugin_archires_querytypes", "FK_query", "plugin_archires_queries_id", 'integer', array('comment' => 'RELATION to the 3 queries tables (id)')); $migration->addKey("glpi_plugin_archires_querytypes", "querytype"); $migration->addKey("glpi_plugin_archires_querytypes", "type"); $migration->addKey("glpi_plugin_archires_querytypes", "itemtype"); $migration->addKey("glpi_plugin_archires_querytypes", "plugin_archires_queries_id"); $migration->migrationOneTable("glpi_plugin_archires_querytypes"); $query = "UPDATE `glpi_plugin_archires_querytypes`\n SET `querytype` = 'PluginArchiresLocationQuery'\n WHERE `querytype` = 0"; $DB->queryOrDie($query, __('1.8.0 update glpi_plugin_archires_querytypes (querytype) ', 'archires') . $DB->error()); $query = "UPDATE `glpi_plugin_archires_querytypes`\n SET `querytype` = 'PluginArchiresNetworkEquipmentQuery'\n WHERE `querytype` = 1"; $DB->queryOrDie($query, __('1.8.0 update glpi_plugin_archires_querytypes (querytype) ', 'archires') . $DB->error()); $query = "UPDATE `glpi_plugin_archires_querytypes`\n SET `querytype` = 'PluginArchiresApplianceQuery'\n WHERE `querytype` = 2"; $DB->queryOrDie($query, __('1.8.0 update glpi_plugin_archires_querytypes (querytype) ', 'archires') . $DB->error()); $migration->dropKey("glpi_plugin_archires_networkinterfacecolors", "iface"); $migration->changeField("glpi_plugin_archires_networkinterfacecolors", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_networkinterfacecolors", "iface", "networkinterfaces_id", 'integer', array('comment' => 'RELATION to glpi_networkinterfaces (id)')); $migration->addKey("glpi_plugin_archires_networkinterfacecolors", "networkinterfaces_id"); $migration->changeField("glpi_plugin_archires_statecolors", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_statecolors", "state", "states_id", 'integer', array('comment' => 'RELATION to glpi_states (id)')); $migration->addKey("glpi_plugin_archires_statecolors", "states_id"); $migration->changeField("glpi_plugin_archires_vlancolors", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_vlancolors", "vlan", "vlans_id", 'integer', array('comment' => 'RELATION to glpi_vlans (id)')); $migration->addKey("glpi_plugin_archires_vlancolors", "vlans_id"); $migration->dropKey("glpi_plugin_archires_views", "deleted"); $migration->dropKey("glpi_plugin_archires_views", "FK_entities"); $migration->changeField("glpi_plugin_archires_views", "ID", "id", 'autoincrement'); $migration->changeField("glpi_plugin_archires_views", "name", "name", 'string'); $migration->changeField("glpi_plugin_archires_views", "FK_entities", "entities_id", 'integer'); $migration->changeField("glpi_plugin_archires_views", "deleted", "is_deleted", 'bool'); $migration->addKey("glpi_plugin_archires_views", "entities_id"); $migration->addKey("glpi_plugin_archires_views", "is_deleted"); $migration->changeField("glpi_plugin_archires_profiles", "ID", "id", 'autoincrement'); $migration->addField("glpi_plugin_archires_profiles", "profiles_id", 'integer', array('comment' => 'RELATION to glpi_profiles (id)')); $migration->changeField("glpi_plugin_archires_profiles", "archires", "archires", 'char'); $migration->addKey("glpi_plugin_archires_profiles", "profiles_id"); $query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `itemtype` = 3000 AND `num` = 9"; $DB->queryOrDie($query, __('1.8.0 delete glpi_displaypreferences (itemtype) ', 'archires') . $DB->error()); $query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `itemtype` = 3001 AND `num` = 8"; $DB->queryOrDie($query, __('1.8.0 delete glpi_displaypreferences (itemtype) ', 'archires') . $DB->error()); $query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `itemtype` = 3002 AND `num` = 8"; $DB->queryOrDie($query, __('1.8.0 delete glpi_displaypreferences (itemtype) ', 'archires') . $DB->error()); $migration->executeMigration(); }