-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Jan 17, 2017, 03:53 PM
-- 伺服器版本: 5.0.45
-- PHP 版本: 4.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- 資料庫: `orderdrink`
-- 

-- --------------------------------------------------------

-- 
-- 資料表格式： `productdetail`
-- 

CREATE TABLE `productdetail` (
  `productdetailid` int(10) unsigned NOT NULL auto_increment,
  `orderid` int(6) unsigned zerofill default NULL,
  `productnumber` varchar(10) collate utf8_unicode_ci default NULL,
  `productname` varchar(30) collate utf8_unicode_ci default NULL,
  `productprice` int(10) unsigned default NULL,
  `productquantity` int(10) unsigned default NULL,
  PRIMARY KEY  (`productdetailid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=29 ;

-- 
-- 列出以下資料庫的數據： `productdetail`
-- 

INSERT INTO `productdetail` VALUES (1, 000001, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (2, 000002, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (3, 000003, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (4, 000004, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (5, 000005, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (6, 000006, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (7, 000007, 'C02', '胚芽奶茶', 30, 1);
INSERT INTO `productdetail` VALUES (8, 000008, 'C02', '胚芽奶茶', 30, 1);
INSERT INTO `productdetail` VALUES (9, 000009, 'C02', '胚芽奶茶', 30, 1);
INSERT INTO `productdetail` VALUES (10, 000010, 'A01', '茉香紅茶', 20, 2);
INSERT INTO `productdetail` VALUES (11, 000011, 'A01', '茉香紅茶', 20, 3);
INSERT INTO `productdetail` VALUES (12, 000011, 'A03', '百香果紅茶', 25, 1);
INSERT INTO `productdetail` VALUES (13, 000011, 'B03', '百香果綠茶', 25, 1);
INSERT INTO `productdetail` VALUES (14, 000011, 'C02', '胚芽奶茶', 30, 1);
INSERT INTO `productdetail` VALUES (15, 000012, 'C01', '珍珠奶茶', 30, 4);
INSERT INTO `productdetail` VALUES (16, 000012, 'B03', '百香果綠茶', 25, 2);
INSERT INTO `productdetail` VALUES (17, 000013, 'C03', '新鮮柳橙汁', 40, 3);
INSERT INTO `productdetail` VALUES (18, 000013, 'B01', '茉香綠茶', 20, 2);
INSERT INTO `productdetail` VALUES (19, 000014, 'B01', '茉香綠茶', 20, 2);
INSERT INTO `productdetail` VALUES (20, 000014, 'C01', '珍珠奶茶', 30, 2);
INSERT INTO `productdetail` VALUES (21, 000015, 'A04', '仙草紅茶', 25, 3);
INSERT INTO `productdetail` VALUES (22, 000015, 'C03', '新鮮柳橙汁', 40, 2);
INSERT INTO `productdetail` VALUES (23, 000016, 'B02', '檸檬綠茶', 25, 2);
INSERT INTO `productdetail` VALUES (24, 000016, 'C03', '新鮮柳橙汁', 40, 2);
INSERT INTO `productdetail` VALUES (25, 000017, 'A02', '檸檬紅茶', 25, 2);
INSERT INTO `productdetail` VALUES (26, 000017, 'C04', '仙草凍', 40, 1);
INSERT INTO `productdetail` VALUES (27, 000018, 'A04', '仙草紅茶', 25, 2);
INSERT INTO `productdetail` VALUES (28, 000019, 'C02', '胚芽奶茶', 30, 3);