create a column called sql_id and make it primary key and auto_increment.
CREATE TABLE IF NOT EXISTS `send_sms` (
`sql_id` bigint(20) NOT NULL auto_increment,
`momt` enum('MO','MT') default NULL,
`sender` varchar(20) default NULL,
`receiver` varchar(20) default NULL,
`udhdata` blob,
`msgdata` text character set utf8 collate utf8_swedish_ci,
`time` bigint(20) default NULL,
`smsc_id` varchar(255) default NULL,
`service` varchar(255) default NULL,
`account` varchar(255) default NULL,
`id` bigint(20) default NULL,
`sms_type` bigint(20) default NULL,
`mclass` bigint(20) default NULL,
`mwi` bigint(20) default NULL,
`coding` bigint(20) default NULL,
`compress` bigint(20) default NULL,
`validity` bigint(20) default NULL,
`deferred` bigint(20) default NULL,
`dlr_mask` bigint(20) default NULL,
`dlr_url` varchar(255) default NULL,
`pid` bigint(20) default NULL,
`alt_dcs` bigint(20) default NULL,
`rpi` bigint(20) default NULL,
`charset` varchar(255) default NULL,
`boxc_id` varchar(255) default NULL,
`binfo` varchar(255) default NULL,
`meta_data` text,
PRIMARY KEY (`sql_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=359 ;
That is my send_sms table
/Andreas
18 aug 2011 kl. 15:38 skrev Diverse:
> This is an example, it would be convenient to give sms_id through a
> separate field.
> Is it possible?
>
> Willy Mularto пишет:
>> You missed dlr_mask field brother. Set it with Kannel's standard value.
>> Please check the user-guide. It is your best friend actually :)
>>
>>
>> On Aug 18, 2011, at 7:20 PM, Diverse wrote:
>>
>>> I did this. Kannel 1.5 + sqlbox.
>>>
>>> MT
>>>
>>> INSERT INTO send_sms (
>>> momt, sender, receiver, msgdata, sms_type
>>> ) VALUES (
>>> ’MT’, ’1234’, ’1234567890’, ’Hello world’, 2
>>> );
>>>
>>> In which field should I specify my sms_id, what I would then been able
>>> to find it on the table DLR sent_sms.
>>>
>>> And how can I use sending messages through the base sqlbox, and link
>>> data from tables send_sms, sent_sms? Tell me please, through which field
>>> I can set my message number (sms_id), so after a write to send_sms I
>>> could find for this sms_id status (dlr) in sent_sms?
>>>
>>> Wendy William пишет:
>>>> You need Kannel 1.5 which supports sqlbox. Then setup the dlr in
>>>> kannel.conf,
>>>> Kannel will automatically store to your created table.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ----- Original Message ----
>>>>> From: Diverse <[email protected]>
>>>>> To: [email protected]
>>>>> Sent: Thu, August 18, 2011 5:39:29 PM
>>>>> Subject: DLR and sqlbox
>>>>>
>>>>> And how can I use sending messages through the base sqlbox, and link
>>>>> data from tables send_sms, sent_sms? Tell me please, through which field
>>>>> I can set my message number (sms_id), so after a write to send_sms I
>>>>> could find for this sms_id status (dlr) in sent_sms?
>>>>>
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>> --
>>> С уважением,
>>> Александр Сухарев
>>> Системный администратор "Цифроград" Ставрополь
>>> тел: (9624) 40-06-66
>>> e-mail: [email protected]
>>> icq: 272375131
>>> skype: [email protected]
>>> jabber: [email protected]
>>>
>> Willy Mularto
>> F300HD+MR18DE (NLC1725)
>> http://www.binbit.co.id/
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> --
> С уважением,
> Александр Сухарев
> Системный администратор "Цифроград" Ставрополь
> тел: (9624) 40-06-66
> e-mail: [email protected]
> icq: 272375131
> skype: [email protected]
> jabber: [email protected]
>
