I think I might have gotten it, but I want to be sure this is the correct method of doing this :/
CREATE TABLE `blah` (
`ID_1` int(11) unsigned NOT NULL default '0',
`ID_2` int(11) unsigned NOT NULL default '0',
`data` varchar(50) NOT NULL default '',
PRIMARY KEY (`ID_1`,`ID_2`),
UNIQUE KEY `Unique` (`ID_1`,`ID_2`)
);
Again, if you can provide me insight on this, Thanks!
|