text: # HeidiSQL Dump 
  #
  # --------------------------------------------------------
  # Host:                 127.0.0.1
  # Database:             smslib
  # Server version:       5.1.32-community
  # Server OS:            Win32
  # Target-Compatibility: MySQL 5.0
  # max_allowed_packet:   1048576
  # HeidiSQL version:     3.2 Revision: 1129
  # --------------------------------------------------------
  
  /*!40100 SET CHARACTER SET latin1*/;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;
  
  
  #
  # Table structure for table 'smsserver_calls'
  #
  
  CREATE TABLE `smsserver_calls` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `call_date` datetime NOT NULL,
    `gateway_id` varchar(64) NOT NULL,
    `caller_id` varchar(16) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 /*!40100 DEFAULT CHARSET=utf8*/;
  
  
  
  #
  # Table structure for table 'smsserver_in'
  #
  
  CREATE TABLE `smsserver_in` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `process` int(11) NOT NULL,
    `originator` varchar(16) NOT NULL,
    `type` varchar(1) NOT NULL,
    `encoding` char(1) NOT NULL,
    `message_date` datetime NOT NULL,
    `receive_date` datetime NOT NULL,
    `text` varchar(1000) NOT NULL,
    `original_ref_no` varchar(64) DEFAULT NULL,
    `original_receive_date` datetime DEFAULT NULL,
    `gateway_id` varchar(64) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=9 /*!40100 DEFAULT CHARSET=utf8*/;
  
  
  
  #
  # Table structure for table 'smsserver_out'
  #
  
  CREATE TABLE `smsserver_out` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `type` varchar(1) NOT NULL DEFAULT 'O',
    `recipient` varchar(16) NOT NULL,
    `text` varchar(1000) NOT NULL,
    `wap_url` varchar(100) DEFAULT NULL,
    `wap_expiry_date` datetime DEFAULT NULL,
    `wap_signal` varchar(1) DEFAULT NULL,
    `create_date` datetime NOT NULL,
    `originator` varchar(16) NOT NULL DEFAULT ' ',
    `encoding` varchar(1) NOT NULL DEFAULT '7',
    `status_report` int(1) NOT NULL DEFAULT '0',
    `flash_sms` int(1) NOT NULL DEFAULT '0',
    `src_port` int(6) NOT NULL DEFAULT '-1',
    `dst_port` int(6) NOT NULL DEFAULT '-1',
    `sent_date` datetime DEFAULT NULL,
    `ref_no` varchar(64) DEFAULT NULL,
    `priority` int(5) NOT NULL DEFAULT '0',
    `status` varchar(1) NOT NULL DEFAULT 'U',
    `errors` int(2) NOT NULL DEFAULT '0',
    `gateway_id` varchar(64) NOT NULL DEFAULT '*',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 /*!40100 DEFAULT CHARSET=utf8*/;
  
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;
  