ALTER TABLE `teeth_live`.`tickets`   
	ADD COLUMN `issue` VARCHAR(255) NULL AFTER `updated_at`,
	ADD COLUMN `message` VARCHAR(255) NULL AFTER `issue`,
	ADD COLUMN `subject` VARCHAR(255) NULL AFTER `message`;


ALTER TABLE `teeth_live`.`tickets`   
	CHANGE `service` `service_id` BIGINT(255) UNSIGNED NOT NULL;
ALTER TABLE `teeth_live`.`tickets`  
  ADD FOREIGN KEY (`service_id`) REFERENCES `teeth_live`.`services`(`id`);
ALTER TABLE `teeth_live`.`tickets`   
	CHANGE `booking_id` `booking_id` BIGINT(255) UNSIGNED NOT NULL,
  ADD FOREIGN KEY (`booking_id`) REFERENCES `teeth_live`.`bookings`(`id`);





ALTER TABLE `teeth_live`.`wallet_transactions`   
	ADD COLUMN `reference_id` BIGINT(11) NULL AFTER `updated_at`;


ALTER TABLE `teeth_live`.`bookings`   
	ADD COLUMN `referal_amount` INT(11) NULL AFTER `provider_service_id`;
ALTER TABLE `teeth_live`.`bookings`   
	ADD COLUMN `total_amount` INT NULL AFTER `provider_service_id`;
