/*
MySQL Data Transfer
Source Host: localhost
Source Database: smse
Target Host: localhost
Target Database: smse
Date: 22/09/2008 22:28:45
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for inbox_
-- ----------------------------
CREATE TABLE `inbox_` (  `inbox_id` bigint(20) NOT NULL auto_increment,  `telp_number` varchar(15) collate latin1_general_ci NOT NULL,  `message` varchar(140) collate latin1_general_ci NOT NULL,  `date_time` datetime NOT NULL,  PRIMARY KEY  (`inbox_id`)) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for outbox
-- ----------------------------
CREATE TABLE `outbox` (  `outbox_id` bigint(20) NOT NULL auto_increment,  `telp_number` varchar(15) collate latin1_general_ci NOT NULL,  `message` varchar(140) collate latin1_general_ci NOT NULL,  `date_time` datetime NOT NULL,  PRIMARY KEY  (`outbox_id`)) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Table structure for sent_items
-- ----------------------------
CREATE TABLE `sent_items` (  `sent_id` bigint(20) NOT NULL auto_increment,  `telp_dest` varchar(15) collate latin1_general_ci NOT NULL,  `message` varchar(140) collate latin1_general_ci NOT NULL,  `date_time` datetime NOT NULL,  `status` set('Sent OK','Sent Failed') collate latin1_general_ci NOT NULL,  PRIMARY KEY  (`sent_id`)) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records 
-- ----------------------------