diff options
author | Alessandro Cosentino <cosenal@gmail.com> | 2012-05-29 16:07:12 -0400 |
---|---|---|
committer | Alessandro Cosentino <cosenal@gmail.com> | 2012-05-29 16:07:12 -0400 |
commit | a6e57a9a1f4427de872c4bf0050cc0ee38d2adfe (patch) | |
tree | 82f1a064079526950bcb7a9bbf9cd1262df93564 /appinfo | |
parent | 07fdf6ad3c3cc659a06099cd2011aab1ce2c8c5e (diff) |
adds indices to database schema
Diffstat (limited to 'appinfo')
-rw-r--r-- | appinfo/database.xml | 35 |
1 files changed, 31 insertions, 4 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml index 30f337e5b..7ef656da3 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -93,13 +93,23 @@ </field> <index> - <name>id</name> + <name>feed_id</name> <unique>true</unique> + <primary>true</primary> <field> <name>id</name> <sorting>descending</sorting> </field> </index> + + <index> + <name>feed_url</name> + <unique>true</unique> + <primary>false</primary> + <field> + <name>url</name> + </field> + </index> </declaration> </table> @@ -115,15 +125,19 @@ <length>4</length> </field> <field> - <name>url</name> + <name>guid</name> <type>text</type> <notnull>true</notnull> <length>100</length> </field> <field> + <name>url</name> + <type>text</type> + <length>100</length> + </field> + <field> <name>title</name> <type>text</type> - <notnull>true</notnull> <length>100</length> </field> <field> @@ -132,15 +146,28 @@ <notnull>true</notnull> <length>4</length> </field> + <field> + <name>body</name> + <type>text</type> + <length>4000</length> + </field> <index> - <name>id</name> + <name>item_id</name> <unique>true</unique> <field> <name>id</name> <sorting>descending</sorting> </field> </index> + <index> + <name>item_guid</name> + <unique>true</unique> + <field> + <name>guid</name> + <sorting>descending</sorting> + </field> + </index> </declaration> </table> </database> |