From e74f6db36d411248f23c455095ed9f4f21ad2823 Mon Sep 17 00:00:00 2001
From: Bernhard Posselt <dev@bernhard-posselt.com>
Date: Wed, 3 Aug 2016 14:00:56 +0200
Subject: add indices for last_modified columns

---
 appinfo/database.xml | 29 +++++++++++++++++++++++++----
 1 file changed, 25 insertions(+), 4 deletions(-)

(limited to 'appinfo')

diff --git a/appinfo/database.xml b/appinfo/database.xml
index 8756a8ff5..8c1b4ae95 100644
--- a/appinfo/database.xml
+++ b/appinfo/database.xml
@@ -51,12 +51,19 @@
             <field>
                 <name>last_modified</name>
                 <type>integer</type>
-                <default></default>
+                <default>0</default>
                 <length>8</length>
                 <notnull>false</notnull>
                 <unsigned>true</unsigned>
             </field>
 
+            <index>
+                <name>news_folders_last_modified_index</name>
+                <field>
+                    <name>last_modified</name>
+                </field>
+            </index>
+
             <index>
                 <name>news_folders_parent_id_index</name>
                 <field>
@@ -95,7 +102,7 @@
             <field>
                 <name>last_modified</name>
                 <type>integer</type>
-                <default></default>
+                <default>0</default>
                 <length>8</length>
                 <notnull>false</notnull>
                 <unsigned>true</unsigned>
@@ -144,7 +151,7 @@
             <field>
                 <name>added</name>
                 <type>integer</type>
-                <default></default>
+                <default>0</default>
                 <length>8</length>
                 <notnull>false</notnull>
                 <unsigned>true</unsigned>
@@ -226,6 +233,13 @@
                 <notnull>true</notnull>
             </field>
 
+            <index>
+                <name>news_feeds_last_modified_index</name>
+                <field>
+                    <name>last_modified</name>
+                </field>
+            </index>
+
             <index>
                 <name>news_feeds_user_id_index</name>
                 <field>
@@ -345,12 +359,19 @@
             <field>
                 <name>last_modified</name>
                 <type>integer</type>
-                <default></default>
+                <default>0</default>
                 <length>8</length>
                 <notnull>false</notnull>
                 <unsigned>true</unsigned>
             </field>
 
+            <index>
+                <name>news_items_last_modified_index</name>
+                <field>
+                    <name>last_modified</name>
+                </field>
+            </index>
+
             <index>
                 <name>news_items_feed_id_index</name>
                 <field>
-- 
cgit v1.2.3