-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 16, 2011 at 10:32 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

--
-- Database: `cibmt`
--

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

--
-- Table structure for table `alerts`
--

CREATE TABLE IF NOT EXISTS `alerts` (
  `id` bigint(20) NOT NULL auto_increment,
  `number` text NOT NULL,
  `date` datetime NOT NULL,
  `subject` text NOT NULL,
  `message` longtext NOT NULL,
  `status` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `alerts`
--


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

--
-- Table structure for table `history`
--

CREATE TABLE IF NOT EXISTS `history` (
  `id` int(20) NOT NULL auto_increment,
  `tid` text NOT NULL,
  `number` text NOT NULL,
  `date` datetime NOT NULL,
  `bname` text NOT NULL,
  `bcountry` text NOT NULL,
  `accnum` text NOT NULL,
  `sort` text NOT NULL,
  `amount` text NOT NULL,
  `cot` text NOT NULL,
  `type` text NOT NULL,
  `details` text NOT NULL,
  `status` text NOT NULL,
  `stat` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `history`
--


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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL auto_increment,
  `number` text NOT NULL,
  `date` datetime NOT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `status` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `messages`
--


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(20) NOT NULL auto_increment,
  `accid` text NOT NULL,
  `number` text NOT NULL,
  `password` text NOT NULL,
  `pin` text NOT NULL,
  `currency` text NOT NULL,
  `firstname` text NOT NULL,
  `lastname` text NOT NULL,
  `dob` date NOT NULL,
  `gender` text NOT NULL,
  `address` text NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `zip` text NOT NULL,
  `country` text NOT NULL,
  `phone` text NOT NULL,
  `email` text NOT NULL,
  `occupation` text NOT NULL,
  `income` text NOT NULL,
  `type` text NOT NULL,
  `lastlogin` datetime NOT NULL,
  `status` text NOT NULL,
  `balance` text NOT NULL,
  `balance2` text NOT NULL,
  `picture` longblob NOT NULL,
  `tax_status` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--

