--- 20150705 Changes:
--- Add table mic_business_rules
--- Change mic_new_card_request table: remove customer_code
+-- 20150707 Changes:
+-- Add column mic_contract.need_renew_payment
+-- Add columns mic_new_card_request.is_delivery_requested and mic_new_card_request.is_paid
 -- MySQL Workbench Forward Engineering
 
 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

  `price_per_year` FLOAT UNSIGNED NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
AUTO_INCREMENT = 7
DEFAULT CHARACTER SET = utf8
COMMENT = 'Contract type information';


  `request_date` DATETIME NOT NULL,
  `resolve_date` DATETIME NULL DEFAULT NULL,
  `note` VARCHAR(2000) NULL DEFAULT NULL,
  `is_delivery_requested` INT(1) UNSIGNED NOT NULL DEFAULT '0',
  `is_paid` INT(1) UNSIGNED NOT NULL DEFAULT '0',
  `old_card_id` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_mic_new_card_request_mic_card1_idx` (`old_card_id` ASC),
