XEUnTLur

1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 25, 2016 at 06:39 AM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `db`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `account`
27--
28
29CREATE TABLE IF NOT EXISTS `account` (
30  `CustomerID` int(11) NOT NULL,
31  `AccountNumber` varchar(15) NOT NULL,
32  `AccountType` varchar(15) NOT NULL,
33  `DateOpened` varchar(20) NOT NULL,
34  `Balance` double NOT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `account`
39--
40
41INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(1, '9987', 'Checking', '10/12/1989', 4000);
42INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(1, '9980', 'Savings', '10/12/1989', 2000);
43INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(2, '8811', 'Savings', '1/5/92', 1000);
44INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(3, '4442', 'Checking', '12/1/1994', 6000);
45INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(3, '4433', 'Savings', '12/1/94', 9000);
46INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(4, '3322', 'Savings', '8/22/94', 500);
47INSERT INTO `account` (`CustomerID`, `AccountNumber`, `AccountType`, `DateOpened`, `Balance`) VALUES(4, '1122', 'Checking', '11/13/88', 800);
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `customer`
53--
54
55CREATE TABLE IF NOT EXISTS `customer` (
56  `CustomerID` int(11) NOT NULL COMMENT 'The Unique Identifier Of Customer',
57  `Name` varchar(50) NOT NULL COMMENT 'The Name of the Customer',
58  `Address` varchar(100) NOT NULL COMMENT 'The Address of the Customer',
59  `City` varchar(50) NOT NULL COMMENT 'The City of the Customer',
60  `State` varchar(2) NOT NULL COMMENT 'The Home State of the Customer',
61  `Zip` varchar(5) NOT NULL COMMENT 'The Zip Code of the Customer'
62) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
63
64--
65-- Dumping data for table `customer`
66--
67
68INSERT INTO `customer` (`CustomerID`, `Name`, `Address`, `City`, `State`, `Zip`) VALUES(1, 'Mr Smith', '123 Lexington', 'Smithville', 'KY', '91232');
69INSERT INTO `customer` (`CustomerID`, `Name`, `Address`, `City`, `State`, `Zip`) VALUES(2, 'Mrs. Jones', '2 Davis Ave', 'Smithville', 'KY', '91232');
70INSERT INTO `customer` (`CustomerID`, `Name`, `Address`, `City`, `State`, `Zip`) VALUES(3, 'Mr Axe', '443 Grinder LN', 'Broadville', 'GA', '81992');
71INSERT INTO `customer` (`CustomerID`, `Name`, `Address`, `City`, `State`, `Zip`) VALUES(4, 'Mr & Mrs Bull', '661 Parker Road', 'Streetville', 'GA', '81990');
72
73--
74-- Indexes for dumped tables
75--
76
77--
78-- Indexes for table `customer`
79--
80ALTER TABLE `customer`
81  ADD PRIMARY KEY (`CustomerID`);
82
83--
84-- AUTO_INCREMENT for dumped tables
85--
86
87--
88-- AUTO_INCREMENT for table `customer`
89--
90ALTER TABLE `customer`
91  MODIFY `CustomerID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'The Unique Identifier Of Customer',AUTO_INCREMENT=5;
92/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
93/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
94/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;