N7NgV4cs

1CREATE TABLE IF NOT EXISTS `friends` (
2      `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3      `providerId` int(10) unsigned NOT NULL DEFAULT '0',
4      `requestId` int(10) unsigned NOT NULL DEFAULT '0',
5      `status` binary(1) NOT NULL DEFAULT '0', PRIMARY KEY (`Id`),
6
7       UNIQUE KEY `Index_3` (`providerId`,`requestId`),
8       KEY `Index_2` (`providerId`,`requestId`,`status`))
9       ENGINE=InnoDB  DEFAULT CHARSET=latin1 
10       COMMENT='providerId is the Id of the users who wish to be friend with' AUTO_INCREMENT=7 ; 
11     
12`status` binary(1) NOT NULL DEFAULT '0', PRIMARY KEY (`Id`), 
13     
14CREATE TABLE IF NOT EXISTS `friends` (
15       `Id` int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
16      `providerId` int(10) unsigned NOT NULL DEFAULT '0',
17      `requestId` int(10) unsigned NOT NULL DEFAULT '0',
18      `status` binary(1) NOT NULL DEFAULT '0',
19
20       UNIQUE KEY `Index_3` (`providerId`,`requestId`),
21       KEY `Index_2` (`providerId`,`requestId`,`status`))
22       ENGINE=InnoDB  DEFAULT CHARSET=latin1 
23       COMMENT='providerId is the Id of the users who wish to be friend with' AUTO_INCREMENT=7 ;