-- phpMyAdmin SQL Dump
-- version 4.3.13.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- 생성 시간: 16-08-31 08:46
-- 서버 버전: 5.6.25
-- PHP 버전: 5.5.27

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 utf8 */;

--
-- 데이터베이스: `citi_banking`
--

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

--
-- 테이블 구조 `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `custid` varchar(200) NOT NULL,
  `first_name` varchar(200) NOT NULL,
  `last_name` varchar(200) NOT NULL,
  `age` varchar(3) NOT NULL,
  `address` varchar(200) NOT NULL,
  `country` varchar(15) NOT NULL,
  `email` varchar(200) NOT NULL,
  `sex` varchar(15) NOT NULL,
  `contact_number` varchar(200) NOT NULL,
  `acc_number` varchar(200) NOT NULL,
  `balance` float NOT NULL,
  `acc_type` varchar(200) NOT NULL,
  `opendate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 테이블의 덤프 데이터 `customer`
--

INSERT INTO `customer` (`custid`, `first_name`, `last_name`, `age`, `address`, `country`, `email`, `sex`, `contact_number`, `acc_number`, `balance`, `acc_type`, `opendate`) VALUES
('10001', 'Nischitha', 'Udupa', '20', 'Mangalore', 'Dfgd', 'nischitha@yahoo.co.in', 'Female', '234234', '600001', 3743.25, 'Citi Nomal Banking', '2009-04-04'),
('10002', 'Elam', 'P', '21', 'Mangalore', 'Dfgd', 'elam_jp@yahoo.com', 'Male', '4537565', '600002', 5975.7, 'Citi Nomal Banking', '2013-06-10'),
('Test', 'Na', 'Tester', '99', 'Ff', 'USA', 'ff@ff.com', 'Male', '010000000', '600003', 1801000, 'Citi Beta Tester Only', '2016-08-26'),
('1234cha', 'Daisy', 'Guzman', '30', '22', 'USA', 'ff@ff.com', 'Male', '1111111111', '600004', 1000, 'Citi Nomal Banking', '2016-08-28'),
('limebh', 'Ryan', 'Fitzgerald', '30', '22', 'USA', 'ff@ff.com', 'Male', '1111111111', '600004', 150000, 'Citi Nomal Banking', '2016-08-28');

--
-- 덤프된 테이블의 인덱스
--

--
-- 테이블의 인덱스 `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`custid`,`acc_number`);

/*!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 */;