View Single Post
  #2  
Old 09-04-2003, 06:14 PM
Kolo
Hill Giant
 
Join Date: Jul 2002
Location: Chicago Suburb
Posts: 103
Default

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!
Reply With Quote