--
-- count
--

DROP TABLE IF EXISTS `count`;
CREATE TABLE `count` (
  `max_no` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`max_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `count` WRITE;
INSERT INTO `count` VALUES (1000000000);
UNLOCK TABLES;

--
-- order_item
--

DROP TABLE IF EXISTS `order_item`;
CREATE TABLE `order_item` (
  `order_no` int(10) unsigned NOT NULL,
  `order_date` datetime NOT NULL,
  `item` varchar(20) NOT NULL,
  `qty` int(2) unsigned NOT NULL,
  UNIQUE KEY `uk1` (`order_no`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- order_main
--

DROP TABLE IF EXISTS `order_main`;
CREATE TABLE `order_main` (
  `order_no` int(10) unsigned NOT NULL,
  `order_date` datetime NOT NULL,
  `name` varchar(20) NOT NULL,
  `address` varchar(100) NOT NULL,
  PRIMARY KEY  (`order_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

