Hi,
ts is the smsc-id, referred to as "foreign-msgid". You use that ID to match
DLRs. Its format is SMSc specific. For SMPP it is a unique ID. For EMI or
CIMD it is the time of the day. It was named ts, since the first SMScs
developed where with time of the day.
If you want to delete old DLRs from your DB, you should create another
timestamp column, that your DB can fill in automatically during inserts.
BR,
Nikos
----- Original Message -----
From: Ahmed Shabana
To: Sayed Hadi Rastgou Haghi
Cc: [email protected]
Sent: Sunday, April 10, 2011 8:28 PM
Subject: RE: Rotate DLR table
Yes I tried it and it gives me the format that you mentioned below
But really most of its values are some thing like this '0000-00-00 00:00:00'
?
From: Sayed Hadi Rastgou Haghi [mailto:[email protected]]
Sent: Sunday, April 10, 2011 7:28 PM
To: Ahmed Shabana
Subject: Re: Rotate DLR table
yes
a timestamp = date in seconds and you can use queries like ts >= "2011-01-01
00:00:00" and mysql handles it.
On Sun, Apr 10, 2011 at 9:38 PM, Ahmed Shabana <[email protected]>
wrote:
Did you tried that before
--------------------------------------------------------------------------
_ _ _ __ _ _
/_\ | |__ _ __ ___ ___ __| | / _\ |__ __ _| |__ __ _ _ __ __ _
//_\\| '_ \| '_ ` _ \ / _ \/ _` | \ \| '_ \ / _` | '_ \ / _` | '_ \ / _` |
/ _ \ | | | | | | | | __/ (_| | _\ \ | | | (_| | |_) | (_| | | | | (_| |
\_/ \_/_| |_|_| |_| |_|\___|\__,_| \__/_| |_|\__,_|_.__/ \__,_|_| |_|\__,_|
From: Sayed Hadi Rastgou Haghi [mailto:[email protected]]
Sent: Sunday, April 10, 2011 6:42 PM
To: Ahmed Shabana
Subject: Re: Rotate DLR table
please change it to timestamp.
Some other fields need a review too.
On Sun, Apr 10, 2011 at 8:00 PM, Ahmed Shabana <[email protected]>
wrote:
Hi all
As day after day the DLR table size grow ,I want to make simple script that
rotate the dlr table based on ts field
But I really have not idea about its format , It just a varchar(100) field
,and I have no idea about its format
Do u have any idea about this field format
Best Regards,
Ahmed Shabana | System Engineer | Creative Communication Solutions
Egypt M +20 (10) 3325373 | Tel +20 (50) 2528897
Saudi M + 966 (54) 8065712 | Tel +966 (1) 4040638
MSN [email protected]
Meet us at:
--
Sincerely,
Sayed Hadi Rastgou Haghi
--
Sincerely,
Sayed Hadi Rastgou Haghi
