diff options
| author | Michal Čihař <michal@cihar.com> | 2011-02-10 15:32:59 +0100 |
|---|---|---|
| committer | Michal Čihař <michal@cihar.com> | 2011-02-10 15:32:59 +0100 |
| commit | 66ce5a2dc79d6132a0db61f880782e56d4f8bfcf (patch) | |
| tree | 60a4edadc2ad333cc9984f71f0a364bb7eab7c93 /docs/man/gammu-smsd-sql.7 | |
| parent | a92feb0ede986fd672d2fc6d642ac93084c4da62 (diff) | |
Imported Upstream version 1.29.90
Diffstat (limited to 'docs/man/gammu-smsd-sql.7')
| -rw-r--r-- | docs/man/gammu-smsd-sql.7 | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/docs/man/gammu-smsd-sql.7 b/docs/man/gammu-smsd-sql.7 index 033a04c..fa39d4f 100644 --- a/docs/man/gammu-smsd-sql.7 +++ b/docs/man/gammu-smsd-sql.7 @@ -1,4 +1,4 @@ -.TH "GAMMU-SMSD-SQL" "7" "January 19, 2011" "1.29.0" "Gammu" +.TH "GAMMU-SMSD-SQL" "7" "February 10, 2011" "1.29.90" "Gammu" .SH NAME gammu-smsd-sql \- gammu-smsd(1) backend using SQL abstraction layer to use any supported database as a message storage . @@ -213,7 +213,7 @@ Default value: .sp .nf .ft C -INSERT INTO phones (IMEI, ID, Send, Receive, InsertIntoDB, TimeOut, Client, Battery, Signal) +INSERT INTO phones (IMEI, ID, Send, Receive, InsertIntoDB, TimeOut, Client, Battery, SignalStrength) VALUES (%I, %P, %1, %2, NOW(), (NOW() + INTERVAL 10 SECOND) + 0, %N, \-1, \-1) .ft P .fi @@ -361,6 +361,7 @@ Default value: .ft C SELECT ID, InsertIntoDB, SendingDateTime, SenderID FROM outbox WHERE SendingDateTime < NOW() AND SendingTimeOut < NOW() AND +SendBefore >= CURTIME() AND SendAfter <= CURTIME() AND ( SenderID is NULL OR SenderID = \(aq\(aq OR SenderID = %P ) ORDER BY InsertIntoDB ASC LIMIT %1 .ft P .fi @@ -612,7 +613,7 @@ Default value: .nf .ft C UPDATE phones SET TimeOut= (NOW() + INTERVAL 10 SECOND) + 0, -Battery = %1, Signal = %2 WHERE IMEI = %I +Battery = %1, SignalStrength = %2 WHERE IMEI = %I .ft P .fi .sp |