From 74129d1b9e97a5d59f72bd38b70a40a5d21a019f Mon Sep 17 00:00:00 2001 From: Alessandro Cosentino Date: Mon, 13 Aug 2012 17:06:12 -0400 Subject: database tables changed --- appinfo/database.xml | 411 +++++++++++++++++++++++++++------------------------ appinfo/version | 2 +- 2 files changed, 215 insertions(+), 198 deletions(-) (limited to 'appinfo') diff --git a/appinfo/database.xml b/appinfo/database.xml index 1fbfe29a4..1d5cef5b9 100644 --- a/appinfo/database.xml +++ b/appinfo/database.xml @@ -1,199 +1,216 @@ - - *dbname* - true - false - latin1 - - *dbprefix*news_folders - - - id - integer - 0 - true - 1 - 4 - - - parent_id - integer - false - 4 - - - name - text - true - 100 - - - user_id - text - - true - 64 - - - - folder_id - true - - id - descending - - - - user_id - - user_id - - - -
- - - *dbprefix*news_feeds - - - id - integer - 0 - true - 1 - 4 - - - user_id - text - - true - 64 - - - url - text - true - 100 - - - title - text - true - 100 - - - favicon_link - text - false - 100 - - - added - integer - - false - true - 4 - - - lastmodified - integer - - false - true - 4 - - - folder_id - integer - true - 4 - - - - feed_id - true - true - - id - descending - - - - - feed_url - true - false - - url - - - -
- - - *dbprefix*news_items - - - id - integer - 0 - true - 1 - 4 - - - guid - text - true - 300 - - - url - text - 300 - - - title - text - 300 - - - feed_id - integer - true - 4 - - - body - text - 4000 - - - status - integer - 1 - - - - item_id - true - - id - descending - - - - item_guid - true - - guid - - - feed_id - - - -
+ *dbname* + true + false + latin1 + + *dbprefix*news_folders + + + id + integer + true + 1 + + + parent_id + integer + false + + + name + text + 100 + true + + + user_id + text + + true + 64 + + + + PRIMARY + true + true + + id + descending + + + + + user_id + + user_id + + + +
+ + + *dbprefix*news_feeds + + + id + integer + true + 1 + + + user_id + text + + true + 64 + + + url_hash + text + 32 + true + + + url + clob + true + + + title + clob + true + + + favicon_link + clob + false + + + added + integer + + false + true + + + lastmodified + integer + + false + true + + + folder_id + integer + true + + + + PRIMARY + true + true + + id + descending + + + + + feed_url + true + false + + url_hash + + + +
+ + + *dbprefix*news_items + + + id + integer + true + 1 + + + guid_hash + text + true + 32 + + + guid + clob + true + + + url + clob + + + title + clob + + + author + clob + false + + + date + integer + + false + true + + + body + clob + false + + + feed_id + integer + true + + + status + integer + + + + + PRIMARY + true + true + + id + descending + + + + + feed_id + + feed_id + + + + + item_guid + true + + guid_hash + + + feed_id + + + +
diff --git a/appinfo/version b/appinfo/version index 1f2be2a26..295ec490e 100644 --- a/appinfo/version +++ b/appinfo/version @@ -1 +1 @@ -6.3 \ No newline at end of file +6.8.2 \ No newline at end of file -- cgit v1.2.3