Changeset 27330 for extensions/physical2virtual/maintain.inc.php

Timestamp:

Feb 11, 2014, 1:25:40 PM (10 years ago)

Author:

JanisV

Message:

Updated storing association physical 2 virtual

File:

• extensions/physical2virtual/maintain.inc.php (modified) (3 diffs)

extensions/physical2virtual/maintain.inc.php

@@ -27 +27 @@
   function __construct($plugin_id)
   {
+    global $prefixeTable;
+
     parent::__construct($plugin_id);
+
+    $this->table = $prefixeTable . 'phy2virt_categories';
   }
 
   function install($plugin_version, &$errors=array())
   {
-    global $conf;
+    global $conf, $prefixeTable;
 
     if (empty($conf['physical2virtual']))
@@ -47 +51 @@
     }
     
+    // new table
+    pwg_query(
+'CREATE TABLE IF NOT EXISTS `' . $this->table . '` (
+  `phy_category_id` smallint(5) unsigned NOT NULL,
+  `virt_category_id` smallint(5) unsigned NOT NULL,
+  `updated` DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00",
+  KEY `phy_category_id` (`phy_category_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8
+;');
+
     $this->installed = true;
   }
@@ -65 +79 @@
   {
     conf_delete_param('physical2virtual');
+
+    pwg_query('DROP TABLE `' . $this->table . '`;');
   }
 }