Deseo hacer que el campo "stock_securefield" se convierta en campo unico, pero nome deja... que debo hacer ?
Código HTML:
CREATE TABLE `Stock` (
`Size_idSize` int(11) NOT NULL,
`Color_idColor` int(11) NOT NULL,
`Products_product_id` int(10) unsigned NOT NULL,
`stock_qty` int(10) unsigned default NULL,
`stock_retailprice` decimal(8,2) default NULL,
`stock_wholesaleprice` decimal(8,2) NOT NULL,
`stock_securefield` varchar(21) NOT NULL,
KEY `Stock_FKIndex2` (`Color_idColor`),
KEY `Stock_FKIndex1` (`Products_product_id`),
KEY `Stock_FKIndex3` (`Size_idSize`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;