diff options
| author | Bernhard Posselt <dev@bernhard-posselt.com> | 2016-08-03 14:00:56 +0200 |
|---|---|---|
| committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2016-08-03 14:00:56 +0200 |
| commit | e74f6db36d411248f23c455095ed9f4f21ad2823 (patch) | |
| tree | 2b69a84227c8cf1f105b04c791e3826c0adc60c9 | |
| parent | 17d44d0eb02c5570d3e519953fd3d5c308e8ad6b (diff) | |
add indices for last_modified columns
| -rw-r--r-- | appinfo/database.xml | 29 |
1 files changed, 25 insertions, 4 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml index 8756a8ff5..8c1b4ae95 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -51,13 +51,20 @@ <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> <name>parent_id</name> @@ -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> @@ -227,6 +234,13 @@ </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> <name>user_id</name> @@ -345,13 +359,20 @@ <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> <name>feed_id</name> |