core: Add backlog trigger to update lastmsgid

[quassel.git] / src / core / sql.qrc

diff --git a/src/core/sql.qrc b/src/core/sql.qrc
index 1ce6c88..e39fc27 100644 (file)
--- a/src/core/sql.qrc
+++ b/src/core/sql.qrc
@@ -64,6 +64,8 @@
     <file>./SQL/PostgreSQL/setup_040_network.sql</file>
     <file>./SQL/PostgreSQL/setup_050_buffer.sql</file>
     <file>./SQL/PostgreSQL/setup_060_backlog.sql</file>
+    <file>./SQL/PostgreSQL/setup_061_add_function_backlog_lastmsgid_update.sql</file>
+    <file>./SQL/PostgreSQL/setup_062_add_trigger_backlog_lastmsgid_update.sql</file>
     <file>./SQL/PostgreSQL/setup_070_coreinfo.sql</file>
     <file>./SQL/PostgreSQL/setup_080_ircservers.sql</file>
     <file>./SQL/PostgreSQL/setup_090_backlog_idx.sql</file>
@@ -99,6 +101,8 @@
     <file>./SQL/PostgreSQL/version/20/upgrade_002_run_function_populate_lastmsgid.sql</file>
     <file>./SQL/PostgreSQL/version/20/upgrade_003_correct_bad_lastseenmsgid.sql</file>
     <file>./SQL/PostgreSQL/version/20/upgrade_004_add_lastseenmsgid_constraint.sql</file>
+    <file>./SQL/PostgreSQL/version/21/upgrade_000_add_function_backlog_lastmsgid_update.sql</file>
+    <file>./SQL/PostgreSQL/version/21/upgrade_001_add_trigger_backlog_lastmsgid_update.sql</file>
     <file>./SQL/SQLite/delete_backlog_by_uid.sql</file>
     <file>./SQL/SQLite/delete_backlog_for_buffer.sql</file>
     <file>./SQL/SQLite/delete_backlog_for_network.sql</file>
@@ -163,6 +167,8 @@
     <file>./SQL/SQLite/setup_040_buffer_idx.sql</file>
     <file>./SQL/SQLite/setup_050_buffer_cname_idx.sql</file>
     <file>./SQL/SQLite/setup_060_backlog.sql</file>
+    <file>./SQL/SQLite/setup_061_add_trigger_backlog_lastmsgid_update_direct_insert.sql</file>
+    <file>./SQL/SQLite/setup_062_add_trigger_backlog_lastmsgid_update_direct_update.sql</file>
     <file>./SQL/SQLite/setup_070_coreinfo.sql</file>
     <file>./SQL/SQLite/setup_080_ircservers.sql</file>
     <file>./SQL/SQLite/setup_090_backlog_idx.sql</file>
@@ -271,5 +277,7 @@
     <file>./SQL/SQLite/version/21/upgrade_004_insert_into_buffer_new_from_buffer.sql</file>
     <file>./SQL/SQLite/version/21/upgrade_005_drop_table_buffer.sql</file>
     <file>./SQL/SQLite/version/21/upgrade_006_alter_table_buffer_new_rename_to_buffer.sql</file>
+    <file>./SQL/SQLite/version/22/upgrade_000_add_trigger_backlog_lastmsgid_update_direct_insert.sql</file>
+    <file>./SQL/SQLite/version/22/upgrade_001_add_trigger_backlog_lastmsgid_update_direct_update.sql</file>
 </qresource>
 </RCC>