SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';



ALTER TABLE `usroofs_office`.`module_files_ownershipdetails` CHANGE COLUMN `amount_payable` `amount_payable` DECIMAL(12,2) NOT NULL DEFAULT 0

, DROP INDEX `fk_module_files_ownershipdetails_module_files`

, ADD INDEX `fk_module_files_ownershipdetails_module_files` (`module_files_id` ASC) ;



ALTER TABLE `usroofs_office`.`module_files_financialdata` CHANGE COLUMN `purchase_price` `purchase_price` DECIMAL(12,2) NOT NULL DEFAULT 0  , CHANGE COLUMN `sale_price` `sale_price` DECIMAL(12,2) NOT NULL DEFAULT 0

, DROP INDEX `fk_module_files_financialdata_module_files`

, ADD INDEX `fk_module_files_financialdata_module_files` (`module_files_id` ASC) ;



ALTER TABLE `usroofs_office`.`user_permissions`

DROP PRIMARY KEY

, ADD PRIMARY KEY (`users_id`, `permission`) ;



ALTER TABLE `usroofs_office`.`module_files_agents` CHANGE COLUMN `amount_payable` `amount_payable` DECIMAL(12,2) NOT NULL DEFAULT 0  ;



ALTER TABLE `usroofs_office`.`module_files_permissions`

DROP PRIMARY KEY

, ADD PRIMARY KEY (`users_id`, `module_files_groups_id`) ;



ALTER TABLE `usroofs_office`.`module_contacts_tags`

DROP INDEX `fk_module_contacts_tags_module_contacts1`

, ADD INDEX `fk_module_contacts_tags_module_contacts1` (`module_contacts_id` ASC) ;





SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;