diff options
author | Alessandro Cosentino <cosenal@gmail.com> | 2012-05-12 21:50:53 -0400 |
---|---|---|
committer | Alessandro Cosentino <cosenal@gmail.com> | 2012-05-12 21:50:53 -0400 |
commit | 72770c15d3e5b18b620720a259b7c6ecd6274157 (patch) | |
tree | 3cbde1a3d22957aeee4156617aef2223a490c00e | |
parent | f8222c89afc5884ef191255267751e9b273ddf61 (diff) |
Added folders and items table to database
-rw-r--r-- | appinfo/database.xml | 94 | ||||
-rw-r--r-- | appinfo/info.xml | 2 |
2 files changed, 89 insertions, 7 deletions
diff --git a/appinfo/database.xml b/appinfo/database.xml index e2aeb7ee2..30f337e5b 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -5,7 +5,7 @@ <overwrite>false</overwrite> <charset>latin1</charset> <table> - <name>*dbprefix*news_feeds</name> + <name>*dbprefix*news_folders</name> <declaration> <field> <name>id</name> @@ -16,23 +16,58 @@ <length>4</length> </field> <field> - <name>url</name> + <name>parentid</name> + <type>integer</type> + <notnull>false</notnull> + <length>4</length> + </field> + <field> + <name>name</name> <type>text</type> <notnull>true</notnull> <length>100</length> </field> <field> - <name>title</name> + <name>userid</name> + <type>text</type> + <default></default> + <notnull>true</notnull> + <length>64</length> + </field> + + <index> + <name>id</name> + <unique>true</unique> + <field> + <name>id</name> + <sorting>descending</sorting> + </field> + </index> + </declaration> + </table> + + <table> + <name>*dbprefix*news_feeds</name> + <declaration> + <field> + <name>id</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <autoincrement>1</autoincrement> + <length>4</length> + </field> + <field> + <name>url</name> <type>text</type> <notnull>true</notnull> <length>100</length> </field> <field> - <name>user_id</name> + <name>title</name> <type>text</type> - <default></default> <notnull>true</notnull> - <length>64</length> + <length>100</length> </field> <field> <name>added</name> @@ -50,6 +85,53 @@ <unsigned>true</unsigned> <length>4</length> </field> + <field> + <name>folderid</name> + <type>integer</type> + <notnull>true</notnull> + <length>4</length> + </field> + + <index> + <name>id</name> + <unique>true</unique> + <field> + <name>id</name> + <sorting>descending</sorting> + </field> + </index> + </declaration> + </table> + + <table> + <name>*dbprefix*news_items</name> + <declaration> + <field> + <name>id</name> + <type>integer</type> + <default>0</default> + <notnull>true</notnull> + <autoincrement>1</autoincrement> + <length>4</length> + </field> + <field> + <name>url</name> + <type>text</type> + <notnull>true</notnull> + <length>100</length> + </field> + <field> + <name>title</name> + <type>text</type> + <notnull>true</notnull> + <length>100</length> + </field> + <field> + <name>feedid</name> + <type>integer</type> + <notnull>true</notnull> + <length>4</length> + </field> <index> <name>id</name> diff --git a/appinfo/info.xml b/appinfo/info.xml index f8e6f9ba4..2d372a7a2 100644 --- a/appinfo/info.xml +++ b/appinfo/info.xml @@ -3,7 +3,7 @@ <id>news</id> <name>News</name> <description>An RSS/Atom feed reader</description> - <version>0.2</version> + <version>0.2.1</version> <licence>AGPL</licence> <author>Alessandro Cosentino</author> <require>3</require> |