r1806 + fix missing unique in RackObjectTags
[racktables] / upgrade.php
index 8abf28c10a605aa8271d99cb34b1d49953b17060..6df5eec1da9ac63cde4fe2809caa5aadd6733f26 100644 (file)
@@ -1060,7 +1060,7 @@ CREATE TABLE `IPVirtualService` (
 CREATE TABLE `RackObjectTags` (
   `object_id` int(10) unsigned default NULL,
   `tag_id` int(10) unsigned default NULL,
 CREATE TABLE `RackObjectTags` (
   `object_id` int(10) unsigned default NULL,
   `tag_id` int(10) unsigned default NULL,
-  KEY `object_id` (`object_id`)
+  UNIQUE KEY `object_tag` (`object_id`,`tag_id`)
 ) TYPE=MyISAM;
 ";
                        $query[] =
 ) TYPE=MyISAM;
 ";
                        $query[] =