Re: Datatype for timestamp for mysql dlr storage

[Nikos Balkanas]

Hi,

ts is not neccesarily a timestamp. EMI SMScs use it as a timestamp. SMPP as 
a unique id, sometimes in decimal other times in hex. Kannel needs this 
value to match DLRs. It should be varchar. If you need a timestamp column 
create one and let mysql initialize it automatically. Otherwise do not 
assume that ts is a timestamp.

BR,
Nikos
----- Original Message ----- 
From: brett skinner
To: users@kannel.org
Sent: Tuesday, June 29, 2010 12:57 PM
Subject: Re: Datatype for timestamp for mysql dlr storage


Hi

Thanks for your response Konstantin. So if I am understanding you correctly 
the problem is that every SMSC is responding according to their own specific 
implementation. So for timestamps I will need to implement something such as 
a column with a default value.

Thanks for your input.


On Tue, Jun 29, 2010 at 11:53 AM, Konstantin Vayner <pon...@appcell.net> 
wrote:

Problem is - Kannel stores the TS in different formats, depending on remote 
SMSC protocol and implementation.
Sometimes i see numeric values, sometimes hex


So i dont think really anything but varchar would work well


2010/6/29 Nikos Balkanas <nbalka...@gmail.com>

Hi,


Please consult the online Mysql reference. This is not a kannel question. If 
you use varchar or even datetime type column column, you better provide the 
value yourself. If you use timestamp type column, you can have mysql 
initialize it to current time.

BR,
Nikos
----- Original Message ----- From: brett skinner
To: users@kannel.org
Sent: Tuesday, June 29, 2010 12:12 PM
Subject: Datatype for timestamp for mysql dlr storage



Hi

I am using the mysql dlr storage type. I have everything working except for 
the timestamp. This is the output from debug mode

sql: INSERT INTO delivery_receipts (smsc, received, source, destination, 
service, url, mask, boxc, status) VALUES ('XXXYYYXXX', '50062911024679487', 
'+123123123', '+123123123', 'simple', '', '31', '', '0');

I set the delivery_receipts table received column to timestamp but when I 
query it I get this 0000-00-00 00:00:00

What should the datatype of the received column be? I see in some places 
people have left it as varchar. Is it up to me to do the translation.

Thanks and appreciate any assistance.

Regards,