CREATE TABLE `ai_cycles` (
 `ai_cycle_id` varchar(15) NOT NULL,
 `preg_cycle_id` varchar(15) NOT NULL,
 `ai_cycle` int(1) NOT NULL,
 `cycle_start_date` date NOT NULL,
 `is_current_AIcycle` varchar(1) NOT NULL COMMENT 'Y/N',
 PRIMARY KEY (`ai_cycle_id`),
 KEY `preg_cycle_id` (`preg_cycle_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `pregnancy_cycles` (
 `preg_cycle_id` varchar(15) NOT NULL,
 `cattle_id` varchar(15) NOT NULL,
 `preg_cycle` int(1) NOT NULL,
 `is_current_prgncy_cycle` varchar(1) NOT NULL,
 `prgncy_cycle_start_date` date NOT NULL,
 PRIMARY KEY (`preg_cycle_id`),
 KEY `cattle_id` (`cattle_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `m02_vet_register_temp` (
 `vet_id` varchar(10) NOT NULL,
 `vet_name` varchar(200) NOT NULL,
 `contact_no` varchar(15) NOT NULL,
 PRIMARY KEY (`vet_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

CREATE TABLE `m01_06preferred_vet` (
 `prefvet_rowno` int(11) NOT NULL AUTO_INCREMENT,
 `vet_id` varchar(15) NOT NULL,
 `reg_no` int(15) NOT NULL,
 PRIMARY KEY (`prefvet_rowno`),
 KEY `vet_id` (`vet_id`),
 KEY `reg_no` (`reg_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1