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

Proposed by Gustavo Pichorim Boiko
Status: Merged
Approved by: Tiago Salem Herrmann
Approved revision: 99
Merged at revision: 100
Proposed branch: lp:~boiko/history-service/fix_1228446
Merge into: lp:history-service
Diff against target: 24 lines (+3/-1)
3 files modified
plugins/sqlite/schema/v5.sql (+1/-0)
plugins/sqlite/schema/version.info (+1/-1)
plugins/sqlite/sqlitehistoryplugin.qrc (+1/-0)
To merge this branch: bzr merge lp:~boiko/history-service/fix_1228446
Reviewer Review Type Date Requested Status
PS Jenkins bot continuous-integration Approve
Tiago Salem Herrmann (community) Approve
Review via email: mp+187108@code.launchpad.net

Commit message

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

Description of the change

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

To post a comment you must log in.
Revision history for this message
Tiago Salem Herrmann (tiagosh) wrote :

works fine.
+1

review: Approve
Revision history for this message
PS Jenkins bot (ps-jenkins) wrote :
review: Approve (continuous-integration)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'plugins/sqlite/schema/v5.sql'
2--- plugins/sqlite/schema/v5.sql 1970-01-01 00:00:00 +0000
3+++ plugins/sqlite/schema/v5.sql 2013-09-23 21:04:37 +0000
4@@ -0,0 +1,1 @@
5+DELETE FROM thread_participants WHERE (SELECT count(threadId) FROM threads WHERE threads.threadId=thread_participants.threadId)=0;
6
7=== modified file 'plugins/sqlite/schema/version.info'
8--- plugins/sqlite/schema/version.info 2013-09-11 23:21:55 +0000
9+++ plugins/sqlite/schema/version.info 2013-09-23 21:04:37 +0000
10@@ -1,1 +1,1 @@
11-4
12+5
13
14=== modified file 'plugins/sqlite/sqlitehistoryplugin.qrc'
15--- plugins/sqlite/sqlitehistoryplugin.qrc 2013-09-11 23:21:55 +0000
16+++ plugins/sqlite/sqlitehistoryplugin.qrc 2013-09-23 21:04:37 +0000
17@@ -5,6 +5,7 @@
18 <file>schema/v2.sql</file>
19 <file>schema/v3.sql</file>
20 <file>schema/v4.sql</file>
21+ <file>schema/v5.sql</file>
22 <file>schema/version.info</file>
23 </qresource>
24 </RCC>

Subscribers

People subscribed via source and target branches