Reply to thread

Message: <blockquote data-quote="Sledmore" data-source="post: 447220" data-attributes="member: 591">Spooky timing, was literally planning to do this today, what a time saver - thanks for the release.I'd probably just consider adding a foreign key to the table in relation to the items table, and probably adding two indexes, for example:[CODE]CREATE TABLE `catalog_items_limited`  (  `id` int(11) NOT NULL AUTO_INCREMENT,  `number` int(11) NOT NULL DEFAULT 0,  `item_id` int(11) NOT NULL DEFAULT 0,  PRIMARY KEY (`id`) USING BTREE,  UNIQUE INDEX `number, item_id`(`number`, `item_id`) USING BTREE,  INDEX `item_id`(`item_id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;[/CODE]</blockquote>