<p>-- phpMyAdmin SQL Dump<br>
  -- version 2.11.7<br>
  -- http://www.phpmyadmin.net<br>
  --<br>
  -- Host: localhost<br>
  -- Generation Time: Aug 16, 2011 at 10:32 PM<br>
  -- Server version: 5.0.51<br>
  -- PHP Version: 5.2.6</p>
<p>--<br>
  -- Database: `cibmt`<br>
  --</p>
<p>-- --------------------------------------------------------</p>
<p>--<br>
  -- Table structure for table `alerts`<br>
  --</p>
<p>CREATE TABLE IF NOT EXISTS `alerts` (<br>
  `id` bigint(20) NOT NULL auto_increment,<br>
  `number` text NOT NULL,<br>
  `date` datetime NOT NULL,<br>
  `subject` text NOT NULL,<br>
  `message` longtext NOT NULL,<br>
  `status` int(2) NOT NULL,<br>
  PRIMARY KEY  (`id`)<br>
  ) ENGINE=MyISAM AUTO_INCREMENT=1 ;</p>
<p>--<br>
  -- Dumping data for table `alerts`<br>
  --<br>
</p>
<p>-- --------------------------------------------------------</p>
<p>--<br>
  -- Table structure for table `history`<br>
  --</p>
<p>CREATE TABLE IF NOT EXISTS `history` (<br>
  `id` int(20) NOT NULL auto_increment,<br>
  `tid` text NOT NULL,<br>
  `number` text NOT NULL,<br>
  `date` datetime NOT NULL,<br>
  `bname` text NOT NULL,<br>
  `bcountry` text NOT NULL,<br>
  `accnum` text NOT NULL,<br>
  `sort` text NOT NULL,<br>
  `amount` text NOT NULL,<br>
  `cot` text NOT NULL,<br>
  `type` text NOT NULL,<br>
  `details` text NOT NULL,<br>
  `status` text NOT NULL,<br>
  `stat` text NOT NULL,<br>
  PRIMARY KEY  (`id`)<br>
  ) ENGINE=MyISAM AUTO_INCREMENT=1 ;</p>
<p>--<br>
  -- Dumping data for table `history`<br>
  --<br>
</p>
<p>-- --------------------------------------------------------</p>
<p>--<br>
  -- Table structure for table `messages`<br>
  --</p>
<p>CREATE TABLE IF NOT EXISTS `messages` (<br>
  `id` int(11) NOT NULL auto_increment,<br>
  `number` text NOT NULL,<br>
  `date` datetime NOT NULL,<br>
  `subject` text NOT NULL,<br>
  `message` text NOT NULL,<br>
  `status` int(2) NOT NULL,<br>
  PRIMARY KEY  (`id`)<br>
  ) ENGINE=MyISAM AUTO_INCREMENT=1 ;</p>
<p>--<br>
  -- Dumping data for table `messages`<br>
  --<br>
</p>
<p>-- --------------------------------------------------------</p>
<p>--<br>
  -- Table structure for table `users`<br>
  --</p>
<p>CREATE TABLE IF NOT EXISTS `users` (<br>
  `id` int(20) NOT NULL auto_increment,<br>
  `accid` text NOT NULL,<br>
  `number` text NOT NULL,<br>
  `password` text NOT NULL,<br>
  `pin` text NOT NULL,<br>
  `currency` text NOT NULL,<br>
  `firstname` text NOT NULL,<br>
  `lastname` text NOT NULL,<br>
  `dob` date NOT NULL,<br>
  `gender` text NOT NULL,<br>
  `address` text NOT NULL,<br>
  `city` text NOT NULL,<br>
  `state` text NOT NULL,<br>
  `zip` text NOT NULL,<br>
  `country` text NOT NULL,<br>
  `phone` text NOT NULL,<br>
  `email` text NOT NULL,<br>
  `occupation` text NOT NULL,<br>
  `income` text NOT NULL,<br>
  `type` text NOT NULL,<br>
  `lastlogin` datetime NOT NULL,<br>
  `status` text NOT NULL,<br>
  `balance` text NOT NULL,<br>
  `balance2` text NOT NULL,<br>
  `picture` longblob NOT NULL,<br>
  `tax_status` int(2) NOT NULL,<br>
  PRIMARY KEY  (`id`)<br>
  ) ENGINE=MyISAM AUTO_INCREMENT=1 ;</p>
<p>--<br>
  -- Dumping data for table `users`<br>
  --</p>
-- 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`
--