gistfile1.txt

alter table  cashier_collection add column remittance_type_id int(11) not null after agent_id;

CREATE TABLE `remittance_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `status` int(1) DEFAULT '1',
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

insert into remittance_type(name) values ('DSP Remittance'), ('AR Remittance');