-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 21, 2014 at 05:26 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Database: `banking`
--

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

--
-- Table structure for table `account_holder`
--

CREATE TABLE IF NOT EXISTS `account_holder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `dte_of_birth` date NOT NULL,
  `dte_open` date NOT NULL,
  `fname` varchar(100) NOT NULL,
  `mname` varchar(100) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `padres` text NOT NULL,
  `cadres` text NOT NULL,
  `email` varchar(200) NOT NULL,
  `mob` varchar(200) NOT NULL,
  `pan` int(100) NOT NULL,
  `idname` varchar(200) NOT NULL,
  `idno` int(100) NOT NULL,
  `balance` int(20) NOT NULL,
  `credit_amnt` int(11) NOT NULL,
  `cnar` varchar(200) NOT NULL,
  `debit_amnt` int(11) NOT NULL,
  `dnar` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `account_holder`
--


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

--
-- Table structure for table `acnt_no`
--

CREATE TABLE IF NOT EXISTS `acnt_no` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `acnt_no`
--


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

--
-- Table structure for table `credit`
--

CREATE TABLE IF NOT EXISTS `credit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `anumber` int(11) NOT NULL,
  `aname` varchar(200) NOT NULL,
  `credit_dt` date NOT NULL,
  `credit_amount` int(11) NOT NULL,
  `book_balance` int(11) NOT NULL,
  `narration` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `credit`
--


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

--
-- Table structure for table `debit`
--

CREATE TABLE IF NOT EXISTS `debit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `anumber` int(11) NOT NULL,
  `aname` varchar(100) NOT NULL,
  `debit_dt` date NOT NULL,
  `debit_amount` int(20) NOT NULL,
  `book_balance` int(11) NOT NULL,
  `narration` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `debit`
--


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

--
-- Table structure for table `exa_userdetails`
--

CREATE TABLE IF NOT EXISTS `exa_userdetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `usrnme` varchar(100) NOT NULL,
  `paswd` varchar(100) NOT NULL,
  `last_login` datetime NOT NULL,
  `satatus` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `exa_userdetails`
--

INSERT INTO `exa_userdetails` (`id`, `name`, `email`, `usrnme`, `paswd`, `last_login`, `satatus`) VALUES
(1, 'BANKER', 'aneeshcea@gmail.com', 'admin', 'admin', '2014-03-21 22:44:43', 1),
(2, 'Aneesh ', 'aneeshcea@gmail.com', 'nila', '1234', '2014-02-11 13:17:30', 0);

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

--
-- Table structure for table `transfer`
--

CREATE TABLE IF NOT EXISTS `transfer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transfer_dt` date NOT NULL,
  `transfer_amount` int(11) NOT NULL,
  `from_acc` int(11) NOT NULL,
  `to_acc` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `transfer`
--

