customer.sql

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_code` varchar(6) NOT NULL,
  `cust_name` varchar(40) NOT NULL,
  `cust_city` varchar(35) DEFAULT NULL,
  `working_area` varchar(35) NOT NULL,
  `cust_country` varchar(20) NOT NULL,
  `phone_no` varchar(17) NOT NULL,
  `agent_code` varchar(6) DEFAULT NULL
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;