smse.sql

来自「sms engine with gammu.dll」· SQL 代码 · 共 48 行

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