diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-18 18:46:58 +0100 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-18 18:46:58 +0100 |
commit | 9e0316964d95151dc4d67abf37ee9b29b9e42cf1 (patch) | |
tree | 401a2a151dccb5917ce993f625e92d5958d5ede3 | |
parent | 206510d126a6c82c8fdbb2c704f57b8c00be0ae8 (diff) |
added indices and primary keys
-rw-r--r-- | appinfo/database.xml | 449 | ||||
-rw-r--r-- | appinfo/info.xml | 2 | ||||
-rw-r--r-- | appinfo/version | 2 |
3 files changed, 223 insertions, 230 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml index fbc5a4d6f..1b8bb93dd 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -1,231 +1,224 @@ <database> - <name>*dbname*</name> - <create>true</create> - <overwrite>false</overwrite> - <charset>utf8</charset> - <table> - <name>*dbprefix*news_folders</name> - <declaration> - <field> - <name>id</name> - <type>integer</type> - <notnull>true</notnull> - <autoincrement>1</autoincrement> - </field> - <field> - <name>parent_id</name> - <type>integer</type> - <notnull>false</notnull> - </field> - <field> - <name>name</name> - <type>text</type> - <length>100</length> - <notnull>true</notnull> - </field> - <field> - <name>user_id</name> - <type>text</type> - <default></default> - <notnull>true</notnull> - <length>64</length> - </field> - <field> - <name>opened</name> - <type>boolean</type> - <default>true</default> - <notnull>true</notnull> - </field> + <name>*dbname*</name> + <create>true</create> + <overwrite>false</overwrite> + <charset>utf8</charset> + <table> + <name>*dbprefix*news_folders</name> + <declaration> + <field> + <name>id</name> + <type>integer</type> + <notnull>true</notnull> + <autoincrement>true</autoincrement> + <unsigned>true</unsigned> + <primary>true</primary> + </field> + <field> + <name>parent_id</name> + <type>integer</type> + <notnull>false</notnull> + </field> + <field> + <name>name</name> + <type>text</type> + <length>100</length> + <notnull>true</notnull> + </field> + <field> + <name>user_id</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + <field> + <name>opened</name> + <type>boolean</type> + <default>true</default> + <notnull>true</notnull> + </field> - <index> - <name>PRIMARY</name> - <unique>true</unique> - <primary>true</primary> - <field> - <name>id</name> - <sorting>descending</sorting> - </field> - </index> - - <index> - <name>user_id</name> - <field> - <name>user_id</name> - </field> - </index> - </declaration> - </table> - - <table> - <name>*dbprefix*news_feeds</name> - <declaration> - <field> - <name>id</name> - <type>integer</type> - <notnull>true</notnull> - <autoincrement>1</autoincrement> - </field> - <field> - <name>user_id</name> - <type>text</type> - <default></default> - <notnull>true</notnull> - <length>64</length> - </field> - <field> - <name>url_hash</name> - <type>text</type> - <length>32</length> - <notnull>true</notnull> - </field> - <field> - <name>url</name> - <type>clob</type> - <notnull>true</notnull> - </field> - <field> - <name>title</name> - <type>clob</type> - <notnull>true</notnull> - </field> - <field> - <name>favicon_link</name> - <type>clob</type> - <notnull>false</notnull> - </field> - <field> - <name>added</name> - <type>integer</type> - <default></default> - <notnull>false</notnull> - <unsigned>true</unsigned> - </field> - <field> - <name>lastmodified</name> - <type>integer</type> - <default></default> - <notnull>false</notnull> - <unsigned>true</unsigned> - </field> - <field> - <name>folder_id</name> - <type>integer</type> - <notnull>true</notnull> - </field> - - <index> - <name>PRIMARY</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_hash</name> - </field> - </index> - </declaration> - </table> - - <table> - <name>*dbprefix*news_items</name> - <declaration> - <field> - <name>id</name> - <type>integer</type> - <notnull>true</notnull> - <autoincrement>1</autoincrement> - </field> - <field> - <name>guid_hash</name> - <type>text</type> - <notnull>true</notnull> - <length>32</length> - </field> - <field> - <name>guid</name> - <type>clob</type> - <notnull>true</notnull> - </field> - <field> - <name>url</name> - <type>clob</type> - </field> - <field> - <name>title</name> - <type>clob</type> - </field> - <field> - <name>author</name> - <type>clob</type> - <notnull>false</notnull> - </field> - <field> - <name>pub_date</name> - <type>timestamp</type> - <default>0000-00-00 00:00:00</default> - <notnull>false</notnull> - </field> - <field> - <name>body</name> - <type>clob</type> - <notnull>false</notnull> - </field> - <field> - <name>enclosure_mime</name> - <type>clob</type> - <notnull>false</notnull> - </field> - <field> - <name>enclosure_link</name> - <type>clob</type> - <notnull>false</notnull> - </field> - <field> - <name>feed_id</name> - <type>integer</type> - <notnull>true</notnull> - </field> - <field> - <name>status</name> - <type>integer</type> - </field> - - - <index> - <name>PRIMARY</name> - <unique>true</unique> - <primary>true</primary> - <field> - <name>id</name> - <sorting>descending</sorting> - </field> - </index> - - <index> - <name>feed_id</name> - <field> - <name>feed_id</name> - </field> - </index> - - <index> - <name>item_guid</name> - <unique>true</unique> - <field> - <name>guid_hash</name> - </field> - <field> - <name>feed_id</name> - </field> - </index> - </declaration> - </table> + <index> + <name>parent_id_index</name> + <field> + <name>parent_id</name> + </field> + </index> + + <index> + <name>user_id_index</name> + <field> + <name>user_id</name> + </field> + </index> + </declaration> + </table> + + <table> + <name>*dbprefix*news_feeds</name> + <declaration> + <field> + <name>id</name> + <type>integer</type> + <notnull>true</notnull> + <autoincrement>true</autoincrement> + <primary>true</primary> + <unsigned>true</unsigned> + </field> + <field> + <name>user_id</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + <field> + <name>url_hash</name> + <type>text</type> + <length>32</length> + <notnull>true</notnull> + </field> + <field> + <name>url</name> + <type>clob</type> + <notnull>true</notnull> + </field> + <field> + <name>title</name> + <type>clob</type> + <notnull>true</notnull> + </field> + <field> + <name>favicon_link</name> + <type>clob</type> + <notnull>false</notnull> + </field> + <field> + <name>added</name> + <type>integer</type> + <default></default> + <notnull>false</notnull> + <unsigned>true</unsigned> + </field> + <field> + <name>lastmodified</name> + <type>integer</type> + <default></default> + <notnull>false</notnull> + <unsigned>true</unsigned> + </field> + <field> + <name>folder_id</name> + <type>integer</type> + <notnull>true</notnull> + </field> + + <index> + <name>user_id_index</name> + <field> + <name>user_id</name> + </field> + </index> + + <index> + <name>folder_id_index</name> + <field> + <name>folder_id</name> + </field> + </index> + + <index> + <name>url_hash_index</name> + <field> + <name>url_hash</name> + </field> + </index> + </declaration> + </table> + + <table> + <name>*dbprefix*news_items</name> + <declaration> + <field> + <name>id</name> + <type>integer</type> + <notnull>true</notnull> + <autoincrement>true</autoincrement> + <primary>true</primary> + <unsigned>true</unsigned> + </field> + <field> + <name>guid_hash</name> + <type>text</type> + <notnull>true</notnull> + <length>32</length> + </field> + <field> + <name>guid</name> + <type>clob</type> + <notnull>true</notnull> + </field> + <field> + <name>url</name> + <type>clob</type> + </field> + <field> + <name>title</name> + <type>clob</type> + </field> + <field> + <name>author</name> + <type>clob</type> + <notnull>false</notnull> + </field> + <field> + <name>pub_date</name> + <type>timestamp</type> + <default>0000-00-00 00:00:00</default> + <notnull>false</notnull> + </field> + <field> + <name>body</name> + <type>clob</type> + <notnull>false</notnull> + </field> + <field> + <name>enclosure_mime</name> + <type>clob</type> + <notnull>false</notnull> + </field> + <field> + <name>enclosure_link</name> + <type>clob</type> + <notnull>false</notnull> + </field> + <field> + <name>feed_id</name> + <type>integer</type> + <notnull>true</notnull> + </field> + <field> + <name>status</name> + <type>integer</type> + </field> + + <index> + <name>feed_id_index</name> + <field> + <name>feed_id</name> + </field> + </index> + + <index> + <name>item_guid</name> + <field> + <name>guid_hash</name> + </field> + <field> + <name>feed_id</name> + </field> + </index> + </declaration> + </table> </database> diff --git a/appinfo/info.xml b/appinfo/info.xml index ae76ac0eb..c78370d86 100644 --- a/appinfo/info.xml +++ b/appinfo/info.xml @@ -6,6 +6,6 @@ <licence>AGPL</licence> <shipped>true</shipped> <author>Alessandro Cosentino, Bernhard Posselt. Powered by SimplePie (Ryan Parman, Geoffrey Sneddon, Ryan McCue and contributors).</author> - <require>4.93</require> + <require>5</require> <default_enable/> </info> diff --git a/appinfo/version b/appinfo/version index f5cce03c3..120096f1f 100644 --- a/appinfo/version +++ b/appinfo/version @@ -1 +1 @@ -7.6
\ No newline at end of file +7.7
\ No newline at end of file |