Merge lp:~boiko/history-service/fix_1228446 into lp:history-service

[Gustavo Pichorim Boiko]

Clear the inconsistencies between thread_participants and threads on existing databases to make sure the service continues to work properly.

Clear the inconsistencies between thread_participants and threads on existing databases to make sure the service continues to work properly.

[Tiago Salem Herrmann (tiagosh)]

works fine.
+1

review: Approve

[PS Jenkins bot (ps-jenkins)]

PASSED: Continuous integration, rev:99
http://jenkins.qa.ubuntu.com/job/history-service-ci/67/
Executed test runs:
    SUCCESS: http://jenkins.qa.ubuntu.com/job/history-service-saucy-amd64-ci/67
    SUCCESS: http://jenkins.qa.ubuntu.com/job/history-service-saucy-armhf-ci/68
        deb: http://jenkins.qa.ubuntu.com/job/history-service-saucy-armhf-ci/68/artifact/work/output/*zip*/output.zip
    SUCCESS: http://jenkins.qa.ubuntu.com/job/history-service-saucy-i386-ci/67

Click here to trigger a rebuild:
http://s-jenkins:8080/job/history-service-ci/67/rebuild

review: Approve (continuous-integration)

=== added file 'plugins/sqlite/schema/v5.sql'
--- plugins/sqlite/schema/v5.sql	1970-01-01 00:00:00 +0000
+++ plugins/sqlite/schema/v5.sql	2013-09-23 21:04:37 +0000
@@ -0,0 +1,1 @@
+DELETE FROM thread_participants WHERE (SELECT count(threadId) FROM threads WHERE threads.threadId=thread_participants.threadId)=0;
 
=== modified file 'plugins/sqlite/schema/version.info'
--- plugins/sqlite/schema/version.info	2013-09-11 23:21:55 +0000
+++ plugins/sqlite/schema/version.info	2013-09-23 21:04:37 +0000
@@ -1,1 +1,1 @@
-4
+5
 
=== modified file 'plugins/sqlite/sqlitehistoryplugin.qrc'
--- plugins/sqlite/sqlitehistoryplugin.qrc	2013-09-11 23:21:55 +0000
+++ plugins/sqlite/sqlitehistoryplugin.qrc	2013-09-23 21:04:37 +0000
@@ -5,6 +5,7 @@
         <file>schema/v2.sql</file>
         <file>schema/v3.sql</file>
         <file>schema/v4.sql</file>
+        <file>schema/v5.sql</file>
         <file>schema/version.info</file>
     </qresource>
 </RCC>