modules/smsgateway/smsgateway.mysql

--
-- $Id: smsgateway.mysql,v 1.1 2005/10/22 22:24:14 therave Exp $
-- Table structure for table 'smslog'
--

CREATE TABLE smslog (
  sid int(10) NOT NULL auto_increment,
  direction varchar(3) NOT NULL,
  number varchar(20) NOT NULL,
  message text default NULL,
  response varchar(128) default NULL,
  timestamp int(11) unsigned NOT NULL default '0',
  KEY smslog_timestamp (timestamp),
  PRIMARY KEY (sid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;


1	--
2	-- $Id: smsgateway.mysql,v 1.1 2005/10/22 22:24:14 therave Exp $
3	-- Table structure for table 'smslog'
4	--
5
6	CREATE TABLE smslog (
7	sid int(10) NOT NULL auto_increment,
8	direction varchar(3) NOT NULL,
9	number varchar(20) NOT NULL,
10	message text default NULL,
11	response varchar(128) default NULL,
12	timestamp int(11) unsigned NOT NULL default '0',
13	KEY smslog_timestamp (timestamp),
14	PRIMARY KEY (sid)
15	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
16
17