UPDATE `AccountStatusMaster` SET `id`=10 WHERE `id`='9';
UPDATE `AccountStatusMaster` SET `id`=9 WHERE `id`='8';
UPDATE `AccountStatusMaster` SET `id`=8 WHERE `id`='7';
UPDATE `AccountStatusMaster` SET `id`=7 WHERE `id`='6';
INSERT INTO `AccountStatusMaster` (`id`, `name`) VALUES (6, 'Approval expired');

set foreign_key_checks=0;
ALTER TABLE `AddressProofMaster` ADD COLUMN `country_id` TINYINT UNSIGNED NOT NULL  AFTER `id` , 
  ADD CONSTRAINT `AddressProofMaster_ibfk_1`
  FOREIGN KEY (`country_id` )
  REFERENCES `CountryMaster` (`id` )
  ON DELETE NO ACTION
  ON UPDATE CASCADE
, ADD INDEX `country_id` (`country_id` ASC) ;

UPDATE AddressProofMaster SET country_id = 1;

ALTER TABLE `IdentityProofMaster` ADD COLUMN `country_id` TINYINT UNSIGNED NOT NULL  AFTER `id` , 
  ADD CONSTRAINT `IdentityProofMaster_ibfk_1`
  FOREIGN KEY (`country_id` )
  REFERENCES `CountryMaster` (`id` )
  ON DELETE NO ACTION
  ON UPDATE CASCADE
, ADD INDEX `country_id` (`country_id` ASC) ;

UPDATE IdentityProofMaster SET country_id = 1;
set foreign_key_checks=1;

INSERT INTO IdentityProofMaster(id, country_id, name, ui_name, system_defined) VALUES
(7, 1, "Aadhaar Card", "Aadhaar Card", 1),
(8, 1, "MNREGA Job Card", "MNREGA Job Card", 1);

INSERT INTO AddressProofMaster(id, country_id, name, ui_name, system_defined) VALUES
(7, 1, "Aadhaar Card", "Aadhaar Card", 1),
(8, 1, "MNREGA Job Card", "MNREGA Job Card", 1);
