delimiter $$

CREATE TABLE `t_loan_received` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_received_voucher_number` int(11) NOT NULL,
  `loan_received_date` date NOT NULL,
  `loan_received_from_id` int(11) NOT NULL,
  `loan_amount` int(20) NOT NULL,
  `loan_received_by` int(11) DEFAULT '0',
  `loan_received_Mode` int(11) NOT NULL,
  `loan_received_mode_deposited_at` varchar(500) DEFAULT NULL,
  `loan_received_mode_cheque_number` varchar(45) DEFAULT NULL,
  `loan_voucher_details` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8$$