ALTER TABLE `bbf_comments`
	ADD COLUMN `comment_parent` BIGINT NULL DEFAULT '0' AFTER `comment_status`;


ALTER TABLE `bbf_communities`
	ADD COLUMN `community_type` ENUM('PRIAVTE','PUBLIC') NULL AFTER `community_description`;


CREATE TABLE `bbf_friend_suggestion` (
	`suggestion_id` INT(10) NULL,
	`user_id` INT(10) NULL,
	`friend_suggestion_id` INT(10) NULL,
	PRIMARY KEY (`suggestion_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM;
ALTER TABLE `bbf_friend_suggestion`


ALTER TABLE `bbf_invitation`
	CHANGE COLUMN `invitation_status` `invitation_status` ENUM('P','A','R','DJ') NULL DEFAULT 'P' COMMENT 'P-pending,A-accepted,R-rejected' AFTER `invitation_created_on`;
	CHANGE COLUMN `suggestion_id` `suggestion_id` INT(10) NOT NULL AUTO_INCREMENT FIRST;


CREATE TABLE `bbf_tagged_business` (
	`tagg_id` INT(10) NULL AUTO_INCREMENT,
	`user_id` INT(10) NULL,
	`business_id` INT(10) NULL,
	`role` TEXT NULL,
	PRIMARY KEY (`tagg_id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM;

ALTER TABLE `bbf_tagged_business`
	ADD COLUMN `status` ENUM('A','I','D') NULL AFTER `role`;
	
ALTER TABLE `bbf_invitation`



       ADD COLUMN `invitation_action_deffered` ENUM('0','1') NULL DEFAULT NULL AFTER `invitation_status`;

ALTER TABLE iqms_lead_form
ADD COLUMN form_alias varchar(255) NOT NULL AFTER agent_id;