-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 08, 2008 at 06:52 AM
-- Server version: 5.0.27
-- PHP Version: 5.2.0
-- 
-- Database: `ozeki`
-- 

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

-- 
-- Table structure for table `ozekimessagein`
-- 

CREATE TABLE `ozekimessagein` (
  `id` int(11) NOT NULL auto_increment,
  `sender` varchar(30) default NULL,
  `receiver` varchar(30) default NULL,
  `msg` varchar(160) default NULL,
  `senttime` varchar(100) default NULL,
  `receivedtime` varchar(100) default NULL,
  `operator` varchar(100) default NULL,
  `msgtype` varchar(160) default NULL,
  `reference` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `ozekimessagein`
-- 


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

-- 
-- Table structure for table `ozekimessageout`
-- 

CREATE TABLE `ozekimessageout` (
  `id` int(11) NOT NULL auto_increment,
  `sender` varchar(30) default NULL,
  `receiver` varchar(30) default NULL,
  `msg` varchar(160) default NULL,
  `senttime` varchar(100) default NULL,
  `receivedtime` varchar(100) default NULL,
  `reference` varchar(100) default NULL,
  `status` varchar(20) default NULL,
  `msgtype` varchar(160) default NULL,
  `operator` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

-- 
-- Dumping data for table `ozekimessageout`
-- 

INSERT INTO `ozekimessageout` VALUES (1, '01911420420', '01911489911', 'test', '2007-11-29 13:00:24', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (2, '01711673093', '01911489911', 'Bal chira ati bandho.... re!!!!!', '2007-11-29 14:35:37', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (3, '01715269038', '01715995576', 'Hello world', '2007-11-29 14:39:06', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (4, '420', '01815001524', '420 charaa ar ki????', '2007-11-29 14:41:39', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (5, '01819296250', '01819296250', 'eita ki ami????', '2007-11-29 17:39:27', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (6, '420', '01819296250', 'test', '2007-11-29 17:40:57', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (7, '420', '01552482839', 'bhalo hoia ja', '2007-11-29 22:52:09', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (8, '01911489911', '01711545095', 'Plz chk email. The Fax copy is sent already. Mail si\\ubj- Fax- Rumi from DHaka shilpo', '2007-11-29 23:22:48', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (9, '01918871158', '01918871158', 'test', '2007-11-30 12:10:42', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (10, '01918871158', '01911489911', 'hello world', '2007-11-30 12:11:57', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (11, '01819296250', '01711560935', 'bhalo hoia jan', '2007-12-03 17:29:11', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (12, '01911489911', '01711560935', 'hello world', '2007-12-03 17:49:02', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (13, '+441234567890', '01711560935', 'hello', '2007-12-03 17:49:41', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (14, '+4471238594125', '01713067810', 'you bitch, tor aibar kharap  time aithase', '2007-12-03 17:53:26', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (15, '+17382822724', '01917298366', 'Tor make chudi.. Khankir poot.. tor mayer bhodar bhitore tore abar dhukamu', '2007-12-03 18:04:26', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (16, '01711624973', '01711624973', 'bal chira ati bandho', '2007-12-10 21:01:19', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (17, '01711077487', '01711624973', 'Ami takla', '2007-12-10 21:03:10', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (18, '8801911489911', '00919833113720', 'Test from Rumi BD', '2007-12-17 11:55:03', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (19, '1911489911', '00919833113720', 'another test- RUMi', '2007-12-17 11:57:59', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (20, '00RUMI', '01911489911', 'test', '2007-12-17 12:24:35', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (21, '+RUMI', '01911489911', 'Test from Rumi BD', '2007-12-17 12:25:17', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (22, '+880RUMI', '01911489911', 'Test from Rumi BD', '2007-12-17 12:25:48', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (23, '011100100111010101101101011010', '01911489911', 'test', '2007-12-17 12:34:20', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (24, '01010010', '01911489911', 'test', '2007-12-17 12:35:38', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (25, '0152113660', '01911489911', 'masking sms', '2007-12-24 21:04:30', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (26, '01911489911', '01711673093', 'rumi checking router.ensii.net', '2007-12-24 21:15:45', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (27, '01911489911', '01717459745', 'http://acer.com.sg/products/extensa4620Z/psp_extensa4620Z.asp', '2007-12-24 23:37:15', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (28, '01911489911', '01911310377', 'SDOI STAT ON 31-12-07 CALL #2480 AVG MOU- 14302 AVG CALL LENGTH- 5M 46S THKS- RUMI', '2008-01-01 21:56:33', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (29, '01911489911', '01911310305', 'SDOI STAT ON 31-12-07 CALL #2480 AVG MOU- 14302 AVG CALL LENGTH- 5M 46S THKS- RUMI', '2008-01-01 21:56:53', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (30, '01911489911', '01911310377', 'SDOI Stat for 31.12.07 Billed Mins- 8655 Unq Usr- 2126 No of Calls- 2480 Avg. Call duration- 3.63 min', '2008-01-02 19:01:14', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (31, '01911489911', '01911310377', 'SDOI Stat for 01.01.08 Billed Mins- 7925 Unq Usr- 2750 No of Calls- 3270 Avg. Call duration- ~2.5 min', '2008-01-02 19:05:23', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (32, '01911489911', '01911310305', 'SDOI Stat for 01.01.08 Billed Mins- 7925 Unq Usr- 2750 No of Calls- 3270 Avg. Call duration- ~2.5 min', '2008-01-02 19:21:30', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (33, '01911489911', '01911310305', 'SDOI Stat for 31.12.07 Billed Mins- 8655 Unq Usr- 2126 No of Calls- 2480 Avg. Call duration- 3.63 min', '2008-01-02 19:22:05', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (34, '01911489911', '01911489911', 'test', '2008-01-03 15:01:29', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (35, '01911489911', '01199277035', 'Zulfiquar 01552113660', '2008-01-07 00:06:36', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (36, '01911489911', '01552113660', 'cpt. bahalul might call u. tell him we need to contact again on monday, though we tried to reach them earlier by phn i sent mail to val already ccd u 2', '2008-01-07 00:11:51', NULL, NULL, 'transmitted', NULL, NULL);
INSERT INTO `ozekimessageout` VALUES (37, '01911489911', '01715995576', 'can u lend me ur gsm modem for a day? if possible- bring it 2morrow with the driver', '2008-01-07 00:18:54', NULL, NULL, 'transmitted', NULL, NULL);
