sms_marry5.sql

SMS gateway. SMS protocol for CHINA mobile, unicom, lingtong. Using mysql to exchange message.

drop table MO_Deliver;
CREATE TABLE MO_Deliver (
  Id int(10) NOT NULL auto_increment,
  sMsgID varchar(10) NOT NULL default '',
  nIsReport int(1),
  nMsgFormat int(1),
  sRecvTime varchar(14) NOT NULL default '',
  sSrcTermID varchar(21) NOT NULL default '',
  sDestTermID varchar(21) NOT NULL default '',
  nMsgLength int(3),
  sMsgContent varchar(252) NOT NULL default '',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

drop table MO_Report;
CREATE TABLE MO_Report (
  Id int(10) NOT NULL auto_increment,
  sMsgID varchar(10) NOT NULL default '',
  nIsReport int(1),
  nMsgFormat int(1),
  sRecvTime varchar(14) NOT NULL default '',
  sSrcTermID varchar(21) NOT NULL default '',
  sDestTermID varchar(21) NOT NULL default '',
  nMsgLength int(3),
  sSubmitDate varchar(14) NOT NULL default '',
  sDoneDate varchar(14) NOT NULL default '',
  sStatus varchar(7) NOT NULL default '',
  sErr varchar(3) NOT NULL default '',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

drop table MT_Submit;
CREATE TABLE MT_Submit (
  Id int(10) NOT NULL auto_increment,  
  nMsgType int(1),		
  nNeedReport int(1),		
  nPriority int(1),
  sServerID varchar(10) NOT NULL default '',
  sFeeType varchar(2) NOT NULL default '',	
  sFeeCode varchar(6) NOT NULL default '',	
  sFixedFee varchar(6) NOT NULL default '',
  nMsgFormat int(1),
  sValidTime varchar(17),
  sAtTime varchar(17),
  sReplyPath varchar(21) NOT NULL default '',
  sChargeTermId varchar(21) NOT NULL default '',
  sDestTermId varchar(21) NOT NULL default '',
  nMsgLength int(1),
  sMsgContent varchar(252) NOT NULL default '',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;


--Part of CMPP_Submit

CREATE TABLE Mtime_Submit (
  Id int(5) NOT NULL auto_increment,
  Registered_Delivery int(1) NOT NULL default '1',
  Msg_level int(1) NOT NULL default '0',
  Service_Id varchar(10) NOT NULL default '',
  Fee_UserType int(1) NOT NULL default '',
  Fee_terminal_Id varchar(21) NOT NULL default '',
  Msg_Fmt int(1) NOT NULL default '',
  FeeType varchar(2) NOT NULL default '',
  FeeCode varchar(6) NOT NULL default '',
  Src_Id varchar(21) NOT NULL default '',
  Dest_terminal_Id varchar(21) NOT NULL default '',
  Msg_Length int(3) NOT NULL default '',
  Msg_Content varchar(255) NOT NULL default '',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

--Part of CMPP_Deliver

CREATE TABLE Mtime_Deliver (
  Id int(5) NOT NULL auto_increment,
  Msg_Id varchar(8) NOT NULL default '',
  Dest_Id varchar(21) NOT NULL default '',
  Service_Id varchar(10) NOT NULL default '',
  TP_pid int(3) default '',
  TP_udhi int(3) default '',
  Msg_Fmt int(1) NOT NULL default '',
  Src_terminal_Id varchar(21) NOT NULL default '',
  Registered_Delivery int(1) NOT NULL default '',
  Msg_Length int(3) NOT NULL default '',
  Msg_Content varchar(255) NOT NULL default '',
  Reserved varchar(8) default '',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;




-------------------------------------Not use-----------------------------------------------------
-- Table structure for table 'SMSqueue'
--
--drop table SMSqueue;
--CREATE TABLE SMSqueue (
--  smsId int(9) NOT NULL auto_increment,
--  smsTime datetime NOT NULL default '0000-00-00 00:00:00',
--  priority tinyint(4) NOT NULL default '0',
--  descId varchar(20) NOT NULL default '',
--  srcId varchar(20) NOT NULL default '',
--  data varchar(255) NOT NULL default '',
--  serviceId varchar(20) default 'LOGO',
--  type varchar(20) NOT NULL default 'txt',
--  PRIMARY KEY  (smsId)
--) TYPE=MyISAM;

--
-- Dumping data for table 'SMSqueue'
--

--
-- Table structure for table 'SMSref'
--
--drop table SMSref;
--CREATE TABLE SMSref (
--  smsId int(9) NOT NULL auto_increment,
--  smsTime datetime NOT NULL default '0000-00-00 00:00:00',
--  descId varchar(20) NOT NULL default '',
--  srcId varchar(20) NOT NULL default '',
--  data varchar(255) NOT NULL default '',
--  PRIMARY KEY  (smsId)
--) TYPE=MyISAM;

--
-- Dumping data for table 'SMSref'
----------------------------------------------------------------------------------------------