-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- 主機: localhost
-- 產生時間： 2017-12-09 02:36:18
-- 伺服器版本: 5.7.17-log
-- PHP 版本： 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 資料庫： `bank_db`
--

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

--
-- 資料表結構 `account`
--

CREATE TABLE `account` (
  `ID` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `name` char(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `balance` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 資料表的匯出資料 `account`
--

INSERT INTO `account` (`ID`, `name`, `balance`) VALUES
('1231567123903', '張大德', 50000),
('1234512345783', '林郁評', 220000),
('1234567891232', '郭大豪', 150000),
('2134567812343', '林惠容', 2300000),
('3412345671238', '劉姵君', 1100000),
('3412346789128', '劉美人', 802100),
('3412348719128', '柯大仙', 892102),
('4512341231235', '林秀氣', 3021000),
('6781231047822', '張美麗', 60000),
('9023176590127', '粘添壽', 500000),
('9872345123902', '陳立人', 4301234);

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

--
-- 資料表結構 `transaction`
--

CREATE TABLE `transaction` (
  `trans_no` int(11) NOT NULL,
  `ID` char(20) COLLATE utf8_unicode_ci NOT NULL,
  `trans_type` int(11) DEFAULT NULL,
  `trade` int(11) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 資料表的匯出資料 `transaction`
--

INSERT INTO `transaction` (`trans_no`, `ID`, `trans_type`, `trade`, `trans_date`) VALUES
(1, '1234567891232', 1, 2000, '2017-11-14 00:00:00'),
(2, '1234512345783', 1, 12000, '2017-11-15 00:00:00'),
(3, '3412345671238', 0, 20000, '2017-10-20 00:00:00'),
(4, '1234567891232', 0, 10200, '2017-10-21 00:00:00'),
(5, '1234512345783', 1, 2000, '2017-10-22 00:00:00'),
(6, '1234567891232', 1, 2000, '2017-10-23 00:00:00'),
(7, '2134567812343', 0, 2000, '2017-10-24 00:00:00'),
(8, '4512341231235', 1, 2000, '2017-10-25 00:00:00'),
(9, '1234567891232', 1, 2000, '2017-10-26 00:00:00'),
(10, '9872345123902', 1, 32000, '2017-10-27 00:00:00'),
(11, '3412345671238', 0, 2000, '2017-10-28 00:00:00'),
(12, '9872345123902', 1, 12000, '2017-10-29 00:00:00'),
(13, '1234567891232', 1, 2000, '2017-10-30 00:00:00'),
(14, '4512341231235', 0, 52000, '2017-10-31 00:00:00'),
(15, '9872345123902', 1, 2000, '2017-11-01 00:00:00'),
(16, '1234512345783', 1, 32000, '2017-11-02 00:00:00'),
(17, '3412345671238', 0, 2000, '2017-11-03 00:00:00'),
(18, '2134567812343', 0, 42000, '2017-11-04 00:00:00'),
(19, '3412345671238', 1, 12000, '2017-11-05 00:00:00'),
(20, '2134567812343', 1, 2000, '2017-11-06 00:00:00'),
(21, '4512341231235', 0, 22000, '2017-11-07 00:00:00'),
(22, '9023176590127', 1, 500000, '2017-12-08 15:50:28'),
(23, '1231567123903', 1, 50000, '2017-12-09 08:56:17'),
(24, '3412346789128', 1, 802100, '2017-12-09 09:06:35'),
(25, '6781231047822', 1, 60000, '2017-12-09 09:07:36'),
(26, '3412348719128', 1, 892102, '2017-12-09 09:16:50');

--
-- 已匯出資料表的索引
--

--
-- 資料表索引 `account`
--
ALTER TABLE `account`
  ADD PRIMARY KEY (`ID`);

--
-- 資料表索引 `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`trans_no`);

--
-- 在匯出的資料表使用 AUTO_INCREMENT
--

--
-- 使用資料表 AUTO_INCREMENT `transaction`
--
ALTER TABLE `transaction`
  MODIFY `trans_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
