   PRIMARY KEY ( id ),
   UNIQUE KEY  uniq_id  ( google_id )
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
+
+
 
 
 DROP TRIGGER IF EXISTS trg_google_user_cp;

) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


DROP PROCEDURE IF EXISTS  UPDATE_SITE_TRACKER ;

DELIMITER //

alter table sc_post_site add index idx_post_id(post_id) ;
alter table sc_post_site add index idx_site_id (site_id) ;




--
-- missing foreign keys
-- need to take a call on foreign keys
-- foreign keys may have performance implications!
--


-- alter table sc_comment add constraint foreign key(post_id)  references sc_post(id);
--
-- alter table sc_facebook add constraint foreign key(login_id)  references sc_login(id);
-- alter table sc_twitter add constraint foreign key(login_id)  references sc_login(id);
-- alter table sc_google_user add constraint foreign key(login_id)  references sc_login(id);
-- alter table sc_user add constraint foreign key(login_id)  references sc_login(id);
-- alter table sc_denorm_user add constraint foreign key(login_id)  references sc_login(id);
--
-- alter table sc_follow add constraint foreign key(follower_id)  references sc_login(id);
-- alter table sc_follow add constraint foreign key(following_id)  references sc_login(id);
--
--
-- alter table sc_post_site add constraint foreign key(post_id)  references sc_post(id);
-- alter table sc_post_site add constraint foreign key(site_id)  references sc_site_master(id);
-- alter table sc_tmp_ps add constraint foreign key(post_id)  references sc_post(id);
-- alter table sc_tmp_ps add constraint foreign key(site_id)  references sc_site_master(id);
--
-- alter table sc_site_tracker add constraint foreign key(post_id)  references sc_post(id);
-- alter table sc_user_group add constraint foreign key(login_id)  references sc_login(id);

-- alter table sc_list_item add constraint foreign key(list_id)  references sc_list(id);
-- alter table sc_list_item add constraint foreign key(item_id)  references sc_post(id);
