-- 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`
-- 

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

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

CREATE TABLE `orders` (
  `orderid` int(6) unsigned zerofill NOT NULL auto_increment,
  `totalmoney` int(10) unsigned default NULL,
  `name` varchar(30) collate utf8_unicode_ci default NULL,
  `phone` varchar(20) collate utf8_unicode_ci default NULL,
  `address` varchar(50) collate utf8_unicode_ci default NULL,
  `ordertime` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `finish` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`orderid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=20 ;

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

INSERT INTO `orders` VALUES (000001, 25, '黃小溢', '0955648889', '', '2015-05-18 14:14:44', 1);
INSERT INTO `orders` VALUES (000002, 25, '黃小溢', '0955648889', '', '2015-05-18 14:18:43', 1);
INSERT INTO `orders` VALUES (000003, 25, '黃小溢', '0955648889', '', '2015-05-18 14:23:22', 1);
INSERT INTO `orders` VALUES (000004, 25, '黃小溢', '0955648889', '', '2015-05-18 14:23:43', 0);
INSERT INTO `orders` VALUES (000005, 25, '黃小溢', '0955648889', '', '2015-05-18 14:25:12', 1);
INSERT INTO `orders` VALUES (000006, 25, '黃小溢', '0955648889', '', '2015-05-18 14:26:00', 0);
INSERT INTO `orders` VALUES (000007, 30, '黃小溢', '0955648889', '', '2015-05-18 14:31:55', 1);
INSERT INTO `orders` VALUES (000008, 30, '黃小溢', '0955648889', '', '2015-05-18 14:36:31', 1);
INSERT INTO `orders` VALUES (000009, 30, '黃小溢', '0933000000', '', '2015-05-18 17:10:03', 1);
INSERT INTO `orders` VALUES (000010, 40, '黃小溢', '0955648889', '明德路20號', '2015-05-18 17:43:08', 0);
INSERT INTO `orders` VALUES (000011, 140, '黃小溢', '0955648889', '明德路20號', '2015-05-19 08:52:44', 0);
INSERT INTO `orders` VALUES (000012, 170, '林子炎', '0987654321', '', '2015-05-19 10:29:44', 0);
INSERT INTO `orders` VALUES (000013, 160, '林子炎', '0912345678', '', '2015-05-19 14:44:35', 0);
INSERT INTO `orders` VALUES (000014, 100, '黃小溢', '0955648889', '明德路20號', '2015-05-22 11:35:43', 0);
INSERT INTO `orders` VALUES (000015, 155, 'david', '0921574694', '', '2015-05-29 11:03:33', 0);
INSERT INTO `orders` VALUES (000016, 130, 'David', '0955648889', '', '2015-05-29 15:52:52', 0);
INSERT INTO `orders` VALUES (000017, 90, '黃信溢', '0955648889', '', '2015-06-06 15:43:12', 1);
INSERT INTO `orders` VALUES (000018, 50, '林子炎', '0912345678', '', '2015-06-11 11:26:30', 0);
INSERT INTO `orders` VALUES (000019, 90, '林子炎', '0912345678', '', '2015-06-11 11:54:36', 0);
