-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 14, 2013 at 04:06 AM
-- Server version: 5.5.32
-- PHP Version: 5.4.16

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

--
-- Database: `test`
--
CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `test`;

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

--
-- Table structure for table `adminlogs`
--

DROP TABLE IF EXISTS `adminlogs`;
CREATE TABLE IF NOT EXISTS `adminlogs` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Date` date DEFAULT NULL,
  `Time` time DEFAULT NULL,
  `IP` varchar(30) DEFAULT NULL,
  `Username` varchar(30) DEFAULT NULL,
  `Password` varchar(30) DEFAULT NULL,
  `Try` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `bank`
--

DROP TABLE IF EXISTS `bank`;
CREATE TABLE IF NOT EXISTS `bank` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Bank_Code` int(4) DEFAULT NULL,
  `Bank_Name` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

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

--
-- Table structure for table `bank_details`
--

DROP TABLE IF EXISTS `bank_details`;
CREATE TABLE IF NOT EXISTS `bank_details` (
  `ID` int(5) NOT NULL AUTO_INCREMENT,
  `Branch_Count` int(3) DEFAULT NULL,
  `Bank_Code` int(4) DEFAULT NULL,
  `Bank_Name` varchar(40) DEFAULT NULL,
  `Branch_Code` int(3) DEFAULT NULL,
  `Branch_Name` varchar(38) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2409 ;

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

--
-- Table structure for table `ben`
--

DROP TABLE IF EXISTS `ben`;
CREATE TABLE IF NOT EXISTS `ben` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `CustomerNO` int(10) NOT NULL,
  `Benificiary_Last_Name` varchar(50) NOT NULL,
  `Benificiary_Other_Names` varchar(50) NOT NULL,
  `Benificiary_Mobile_No` varchar(50) NOT NULL,
  `Benificiary_Home_Ph` varchar(50) NOT NULL,
  `Bank` varchar(60) NOT NULL,
  `Bank_Code` int(5) NOT NULL,
  `Branch` varchar(50) NOT NULL,
  `Branch_Code` int(5) NOT NULL,
  `Account_NO` varchar(50) NOT NULL,
  `Benificiary_ID_Type` varchar(30) NOT NULL,
  `Benificiary_IDN` varchar(50) NOT NULL,
  `Benificiary_Address` varchar(50) NOT NULL,
  `Benificiary_Town` varchar(40) NOT NULL,
  `Benificiary_Country` varchar(30) NOT NULL DEFAULT 'Sri Lanka',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4204 ;

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

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
CREATE TABLE IF NOT EXISTS `customer` (
  `CustomerNO` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `First_Name` varchar(50) DEFAULT NULL,
  `Last_Name` varchar(50) DEFAULT NULL,
  `Date_Of_Birth` varchar(50) DEFAULT NULL,
  `Gender` varchar(20) NOT NULL,
  `Occupation` varchar(40) NOT NULL,
  `Mobile_Ph` int(15) DEFAULT '0',
  `Home_Ph` int(15) DEFAULT '0',
  `Work_Ph` int(15) DEFAULT '0',
  `Fax_No` int(15) NOT NULL,
  `Residential_Street_No` varchar(50) DEFAULT NULL,
  `Residential_Street_Name` varchar(50) DEFAULT NULL,
  `Residential_Suburb` varchar(50) DEFAULT NULL,
  `Residential_Post_Code` varchar(50) DEFAULT NULL,
  `Residential_State` varchar(50) DEFAULT NULL,
  `Residential_Country` varchar(50) DEFAULT NULL,
  `ID_Type` varchar(50) DEFAULT NULL,
  `ID_No` varchar(50) DEFAULT NULL,
  `ID_Expiry` varchar(20) NOT NULL,
  `Issuer` varchar(50) NOT NULL,
  `Place_of_Issue` varchar(50) NOT NULL,
  `idcopy` varchar(20) NOT NULL,
  `idcopyimage` varchar(20) NOT NULL,
  `acstatus` varchar(20) NOT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `IP` varchar(20) NOT NULL,
  PRIMARY KEY (`CustomerNO`),
  KEY `ID_No` (`ID_No`),
  KEY `Residential_Post_Code` (`Residential_Post_Code`),
  KEY `CustomerNO` (`CustomerNO`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1731 ;

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

--
-- Table structure for table `customercopy`
--

DROP TABLE IF EXISTS `customercopy`;
CREATE TABLE IF NOT EXISTS `customercopy` (
  `CustomerNO` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `Title` varchar(50) DEFAULT NULL,
  `First_Name` varchar(50) DEFAULT NULL,
  `Last_Name` varchar(50) DEFAULT NULL,
  `Date_Of_Birth` varchar(50) DEFAULT NULL,
  `Gender` varchar(20) NOT NULL,
  `Occupation` varchar(40) NOT NULL,
  `Mobile_Ph` int(15) DEFAULT '0',
  `Home_Ph` int(15) DEFAULT '0',
  `Work_Ph` int(15) DEFAULT '0',
  `Fax_No` int(15) NOT NULL,
  `Residential_Street_No` varchar(50) DEFAULT NULL,
  `Residential_Street_Name` varchar(50) DEFAULT NULL,
  `Residential_Suburb` varchar(50) DEFAULT NULL,
  `Residential_Post_Code` varchar(50) DEFAULT NULL,
  `Residential_State` varchar(50) DEFAULT NULL,
  `Residential_Country` varchar(50) DEFAULT NULL,
  `ID_Type` varchar(50) DEFAULT NULL,
  `ID_No` varchar(50) DEFAULT NULL,
  `ID_Expiry` varchar(20) NOT NULL,
  `Issuer` varchar(50) NOT NULL,
  `Place_of_Issue` varchar(50) NOT NULL,
  `idcopy` varchar(20) NOT NULL,
  `idcopyimage` varchar(20) NOT NULL,
  `acstatus` varchar(20) NOT NULL,
  `Email` varchar(50) DEFAULT NULL,
  `IP` varchar(20) NOT NULL,
  PRIMARY KEY (`CustomerNO`),
  KEY `ID_No` (`ID_No`),
  KEY `Residential_Post_Code` (`Residential_Post_Code`),
  KEY `CustomerNO` (`CustomerNO`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1629 ;

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

--
-- Table structure for table `customerorders`
--

DROP TABLE IF EXISTS `customerorders`;
CREATE TABLE IF NOT EXISTS `customerorders` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `CustomerNO` int(10) NOT NULL,
  `BeneficiaryID` varchar(15) NOT NULL,
  `name` varchar(100) NOT NULL,
  `bank` varchar(30) NOT NULL,
  `Bank_Code` int(5) NOT NULL,
  `branch` varchar(30) NOT NULL,
  `Branch_Code` int(5) NOT NULL,
  `ac` varchar(30) NOT NULL,
  `AmountAUD` varchar(15) NOT NULL,
  `deposit` varchar(20) NOT NULL,
  `Location` varchar(20) NOT NULL,
  `msg` varchar(300) NOT NULL,
  `amount` int(10) NOT NULL,
  `status` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `customfields`
--

DROP TABLE IF EXISTS `customfields`;
CREATE TABLE IF NOT EXISTS `customfields` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ColName` varchar(30) DEFAULT NULL,
  `TableName` varchar(30) DEFAULT NULL,
  `TitleName` varchar(40) DEFAULT NULL,
  `TypeName` varchar(40) DEFAULT NULL,
  `DefaultValue` varchar(100) DEFAULT NULL,
  `Selected` varchar(5) DEFAULT NULL,
  `Validate` varchar(5) DEFAULT NULL,
  `Required` varchar(5) DEFAULT NULL,
  `Message` varchar(100) DEFAULT NULL,
  `Searchable` varchar(5) DEFAULT NULL,
  `OrderPos` int(11) NOT NULL DEFAULT '3',
  `OptionTitle` varchar(50) DEFAULT NULL,
  `Locked` varchar(5) DEFAULT NULL,
  `BrowsePage` varchar(5) DEFAULT NULL,
  `AllowHTML` varchar(5) DEFAULT NULL,
  `MaxChars` int(11) DEFAULT NULL,
  `IsLink` varchar(5) DEFAULT NULL,
  `Target` varchar(10) DEFAULT NULL,
  `LinkText` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `dollar_rate`
--

DROP TABLE IF EXISTS `dollar_rate`;
CREATE TABLE IF NOT EXISTS `dollar_rate` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Date` date NOT NULL,
  `Rate` decimal(10,2) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Date` (`Date`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

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

--
-- Table structure for table `firstdelete`
--

DROP TABLE IF EXISTS `firstdelete`;
CREATE TABLE IF NOT EXISTS `firstdelete` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Date` date NOT NULL,
  `Time` time NOT NULL,
  `User` varchar(30) NOT NULL,
  `IP` varchar(20) NOT NULL,
  `Table` varchar(20) NOT NULL,
  `Data` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hold`
--

DROP TABLE IF EXISTS `hold`;
CREATE TABLE IF NOT EXISTS `hold` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `CustomerNO` int(10) NOT NULL,
  `BeneficiaryID` int(10) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `name` varchar(100) NOT NULL,
  `bank` varchar(50) NOT NULL,
  `Bank_Code` int(5) NOT NULL,
  `branch` varchar(50) NOT NULL,
  `Branch_Code` int(5) NOT NULL,
  `ac` varchar(50) NOT NULL,
  `amount` varchar(15) NOT NULL,
  `location` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `msg` varchar(300) NOT NULL,
  `pdf` varchar(10) NOT NULL,
  `AmountAUD` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13497 ;

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

--
-- Table structure for table `jobend`
--

DROP TABLE IF EXISTS `jobend`;
CREATE TABLE IF NOT EXISTS `jobend` (
  `iddate` varchar(50) NOT NULL,
  `date` varchar(30) NOT NULL,
  `deposited` int(20) NOT NULL DEFAULT '0',
  `received` int(20) NOT NULL DEFAULT '0',
  `balance` int(20) NOT NULL DEFAULT '0',
  `location` varchar(50) NOT NULL,
  `quantity` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`iddate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `recievedmoney`
--

DROP TABLE IF EXISTS `recievedmoney`;
CREATE TABLE IF NOT EXISTS `recievedmoney` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `method` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `location` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=672 ;

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

--
-- Table structure for table `system_staff`
--

DROP TABLE IF EXISTS `system_staff`;
CREATE TABLE IF NOT EXISTS `system_staff` (
  `A_ID` int(10) NOT NULL AUTO_INCREMENT,
  `Username` varchar(30) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Role` varchar(20) NOT NULL,
  `Branch` varchar(20) NOT NULL,
  `Designaion` varchar(40) NOT NULL,
  PRIMARY KEY (`A_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `system_staff`
--

INSERT INTO `system_staff` (`A_ID`, `Username`, `Password`, `Role`, `Branch`, `Designaion`) VALUES
(9, 'admin', '21232f297a57a5a743894a0e4a801fc3', '1', '0', '');

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

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
CREATE TABLE IF NOT EXISTS `transactions` (
  `T_ID` int(10) NOT NULL AUTO_INCREMENT,
  `CustomerNO` int(10) NOT NULL,
  `BeneficiaryID` int(10) NOT NULL,
  `Date` date NOT NULL,
  `Time` time NOT NULL,
  `Acc_Name` varchar(100) NOT NULL,
  `Bank_Name` varchar(60) NOT NULL,
  `Bank_Code` int(5) NOT NULL,
  `Bank_Branch` varchar(50) NOT NULL,
  `Branch_Code` int(5) NOT NULL,
  `Acc_No` varchar(50) NOT NULL,
  `AmountLKR` decimal(15,2) NOT NULL,
  `Agent` varchar(30) NOT NULL,
  `Status` varchar(50) NOT NULL,
  `Msg` varchar(300) NOT NULL,
  `Pdf` varchar(20) NOT NULL,
  `AmountAUD` decimal(10,2) NOT NULL,
  `Dollar_Rate` decimal(10,2) NOT NULL,
  `Services_Fee` decimal(10,2) NOT NULL,
  `Payment_Mode` varchar(10) NOT NULL,
  PRIMARY KEY (`T_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15789 ;

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

--
-- Table structure for table `userlogs`
--

DROP TABLE IF EXISTS `userlogs`;
CREATE TABLE IF NOT EXISTS `userlogs` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Date` date DEFAULT NULL,
  `Time` time DEFAULT NULL,
  `IP` varchar(30) DEFAULT NULL,
  `Username` varchar(30) DEFAULT NULL,
  `Password` varchar(30) DEFAULT NULL,
  `Try` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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