gistfile1.sql

mysql> show create table smpp_in_pdu \G
*************************** 1. row ***************************
       Table: smpp_in_pdu
Create Table: CREATE TABLE `smpp_in_pdu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `seq_number` int(11) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `partner_id` int(11) unsigned NOT NULL,
  `channel_id` int(11) unsigned NOT NULL,
  `country_id` int(11) unsigned NOT NULL,
  `destination_addr` bigint(21) unsigned NOT NULL,
  `source_addr` varchar(21) NOT NULL DEFAULT 'source_addr',
  `short_message` varchar(255) DEFAULT NULL,
  `partner_price_pdu` double(15,4) unsigned NOT NULL DEFAULT '0.0000',
  `partner_price_pdu_orig` double(15,4) unsigned NOT NULL,
  `system_price_pdu` double(15,4) unsigned NOT NULL,
  `system_price_pdu_orig` double(15,4) unsigned NOT NULL,
  `manager_price_pdu` double(15,4) unsigned NOT NULL,
  `manager_price_pdu_orig` double(15,4) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=213087 DEFAULT CHARSET=utf8