   `cancel_reason` VARCHAR(250) NULL DEFAULT NULL,
   `cancel_note` VARCHAR(2000) NULL DEFAULT NULL,
   `last_modified` DATETIME NOT NULL,
+  `need_renew_payment` INT(11) UNSIGNED NULL DEFAULT NULL,
   `staff_code` VARCHAR(10) NULL DEFAULT NULL,
   `contract_type_id` INT(11) UNSIGNED NOT NULL,
   `customer_code` VARCHAR(10) NOT NULL,
-  `need_renew_payment` INT(11) UNSIGNED NULL DEFAULT NULL,
   PRIMARY KEY (`contract_code`),
   INDEX `fk_mic_contract_mic_staff_idx` (`staff_code` ASC),
   INDEX `fk_mic_contract_mic_contract_type1_idx` (`contract_type_id` ASC),

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


    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 88
DEFAULT CHARACTER SET = utf8
COMMENT = 'Payment information';

