y6R2PEkr

1CREATE TABLE IF NOT EXISTS `Relationship_User_Follows_Business` (
2  `user_id` int(10) unsigned NOT NULL,
3  `business_id` int(10) unsigned NOT NULL,
4  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '1=following, 0=not following'
5) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
6
7ALTER TABLE `Relationship_User_Follows_Business`
8  ADD UNIQUE KEY `unique_user_business_id` (`user_id`,`business_id`);
9	
10SELECT Business.*, Relationship_User_Follows_Business.status FROM Business, Relationship_User_Follows_Business WHERE 104=Relationship_User_Follows_Business.user_id AND Business.id=Relationship_User_Follows_Business.business_id