CREATE TABLE `orders` (
  `order_id` varchar(10) NOT NULL primary key,
  `customer_id` varchar(10) NOT NULL,
  `order_date` date NOT NULL,
  `order_time` time NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=tis620

CREATE TABLE `orderdetails` (
  `orderdetails_id` int(5) NOT NULL auto_increment primary key,
  `order_id` varchar(10) NOT NULL,
  `product_id` int(5) NOT NULL,
  `qty` int(5) NOT NULL,
  `price` double NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=tis620
