Untitled

CREATE TABLE `order_lines` (
  `row_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `item_num` text,
  PRIMARY KEY  (`row_id`)
);
LOCK TABLES `order_lines` WRITE;
INSERT INTO `order_lines` VALUES (1,1,1,'Order 1, Item 1'),(2,1,2,'Order 1, Item 2'),(3,1,3,'Order 1, Item 3'),(4,1,17,'Order 1, Item 17');
UNLOCK TABLES;

CREATE TABLE `orders` (
  `row_id` int(11) NOT NULL auto_increment,
  `name` text,
  PRIMARY KEY  (`row_id`)
);
LOCK TABLES `orders` WRITE;
INSERT INTO `orders` VALUES (1,'Order #1'),(2,'Order #2'),(3,'Order #3');
UNLOCK TABLES;