[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    [spacebar] mobile-logger: [mobile-logger] Make the messageToken db column UNIQUE
From:       Martin Klapetek <mklapetek () kde ! org>
Date:       2016-03-09 22:18:20
Message-ID: E1admQu-0002mh-V3 () scm ! kde ! org
[Download RAW message or body]

Git commit cda9086c9f1f0928b1af6af152112b4cbeb27add by Martin Klapetek.
Committed on 09/03/2016 at 22:18.
Pushed by mklapetek into branch 'master'.

[mobile-logger] Make the messageToken db column UNIQUE

This will prevent storing duplicate messages

M  +1    -1    mobile-logger/text-channel-observer.cpp

http://commits.kde.org/spacebar/cda9086c9f1f0928b1af6af152112b4cbeb27add

diff --git a/mobile-logger/text-channel-observer.cpp b/mobile-logger/text-c=
hannel-observer.cpp
index f30c19b..2dca163 100644
--- a/mobile-logger/text-channel-observer.cpp
+++ b/mobile-logger/text-channel-observer.cpp
@@ -67,7 +67,7 @@ KTp::TextChannelObserver::TextChannelObserver(QObject *pa=
rent)
                                                   "accountId INTEGER, "
                                                   "targetContactId INTEGER=
, "
                                                   "message TEXT, "
-                                                  "messageToken VARCHAR(19=
2), "
+                                                  "messageToken VARCHAR(19=
2) UNIQUE, "
                                                   "isIncoming BOOLEAN, "
                                                   "isDelivered BOOLEAN, "
                                                   "type SMALLINT "
[prev in list] [next in list] [prev in thread] [next in thread]