Commit Graph

388 Commits

Author SHA1 Message Date
Andrew Dolgov 368eb3f861 schema: fix psql upgrade script of version 84 2011-04-20 15:56:07 +04:00
Andrew Dolgov cfc0647184 schema: add status codes 2011-04-20 14:46:53 +04:00
Andrew Dolgov afb875ccd7 add rpc method to export feedbrowser data; update schema 2011-04-20 12:07:07 +04:00
Andrew Dolgov 58fa1bbc00 initial schema work on linked instances and shared feedbrowser 2011-04-20 11:42:16 +04:00
igorette dfa7bb2f63 fixed typo, missing semicolon 2011-04-05 16:42:08 +04:00
Andrew Dolgov dd0345769a schema: mysql: remove foreign key to ttrss_themes before dropping theme_id from ttrss_users 2011-04-01 15:32:27 +04:00
Andrew Dolgov 9507ab7f92 schema: remove ttrss_themes 2011-04-01 15:26:02 +04:00
Andrew Dolgov 5ab9791f34 implement pubsubhubbub subscriber (update schema) 2011-04-01 13:55:39 +04:00
Andrew Dolgov 74b046a1c9 add ttrss_feeds.update_on_checksum_change 2011-03-29 12:16:09 +04:00
Andrew Dolgov 9382ca847f add ttrss_feeds.mark_unread_on_update, bump schema, cleanup ttrss_prefs 2011-03-29 12:05:39 +04:00
Andrew Dolgov 8de8bfb871 authenticate against a hash of identifyable information from certificate instead of only serial (refs #324) 2011-03-28 09:45:23 +04:00
Andrew Dolgov 3d72afa19a use SSL serial to bind certificate to user; implement autologin using SSL certificate; set a separate session cookie for SSL connections (refs #324) 2011-03-28 08:30:15 +04:00
Andrew Dolgov b9ad7cface change description of filter 'filter' action (bump schema) 2011-03-10 11:54:10 +03:00
Andrew Dolgov 2f42315a13 change description of CDM_AUTO_CATCHUP (bump schema) 2011-03-06 09:55:40 +03:00
Andrew Dolgov cfad9259a6 mobile: allow showing category content inline (closes #315) 2011-03-04 17:53:02 +03:00
Andrew Dolgov 30b6ee8c08 clean obsolete options from schema (bump schema version) 2010-11-29 13:02:44 +03:00
Andrew Dolgov 88e4e5979c rework user CSS support (bump schema) 2010-11-24 19:23:24 +03:00
Andrew Dolgov 57e24c8267 add experimental support for Twitter OAuth and Twitter feeds (bump schema) 2010-11-22 16:26:00 +03:00
Andrew Dolgov ed7f0ecd37 schema: add some mysql indexes 2010-11-20 00:47:22 +03:00
Andrew Dolgov f0259baf13 schema: add some indexes 2010-11-18 16:56:34 +03:00
Andrew Dolgov 567810362c schema: add ttrss_feeds.order_id 2010-11-18 12:56:21 +03:00
Andrew Dolgov bf9fb81f75 schema: add ttrss_entries(updated) idx 2010-11-14 17:29:07 +03:00
Andrew Dolgov e2f08094cf schema: add ttrss_user_entries(unread) index 2010-11-14 17:26:26 +03:00
Andrew Dolgov 90c9c16f0e schema: add index on ttrss_tags 2010-11-13 19:26:29 +03:00
Andrew Dolgov c011b36b85 add upgrade files for schema #74 2010-11-10 19:12:49 +03:00
Andrew Dolgov 905ff52a36 implement label cache; misc fixes (bump schema) 2010-11-10 19:01:14 +03:00
Andrew Dolgov b3990c92e7 add option to sort headlines by feed-specified date (bump schema) 2010-11-10 13:56:42 +03:00
Andrew Dolgov 90ef9c7da3 schema: wrap upgrade scripts in transaction blocks 2010-11-10 11:45:28 +03:00
Andrew Dolgov 490c366d39 add tag cache for user_entries (bump schema) 2010-11-09 22:41:13 +03:00
Andrew Dolgov c3fc5e470e allow filtering by article tags (bump schema) 2010-11-09 14:49:41 +03:00
Andrew Dolgov 73fe13afd4 add ttrss_users.full_name; bump schema 2010-11-08 16:34:49 +03:00
Andrew Dolgov 8801fb017c replace old-style published feed with universal secretkey-based approach used for all feeds; do not allow user/pass handling in generated feed urls; bump schema 2010-11-08 13:15:00 +03:00
Andrew Dolgov 8b640f50e0 schema: fix mysql feedbrowser cache table encoding 2010-11-07 20:15:43 +03:00
Andrew Dolgov 8e54a21e77 update ttrss_entries.content to longtext type; config: set default mysql charset to UTF8 2010-11-07 19:48:24 +03:00
Andrew Dolgov 505b4b034d mysql schema: properly set UTF8 charset 2010-11-07 19:41:14 +03:00
Andrew Dolgov 324944f332 implement per-user timezone support; store dates in UTC internally (closes #254) 2010-11-07 18:14:48 +03:00
Andrew Dolgov 1f8c187de3 replace tt-rss.spb.ru references with tt-rss.org; update translations 2010-11-03 13:39:09 +03:00
Andrew Dolgov 25ea280502 add ttrss_entries.date_updated; use date_updated instead of date_enered for expiry checking (bump schema) 2010-10-27 12:05:20 +04:00
Andrew Dolgov fa3317be48 allow filtering by article author (bump schema) 2010-03-23 14:38:58 +03:00
Andrew Dolgov fbe2ea1c6d change description of DEFAULT_UPDATE_INTERVAL (bump schema) 2010-01-20 14:21:25 +03:00
Andrew Dolgov b97e6e0267 reorganize theme support; add some themeable icons; add neon theme 2010-01-14 16:11:54 +03:00
Andrew Dolgov dce46cade3 query themes from filesystem; obsolete ttrss_themes 2010-01-14 13:39:05 +03:00
Andrew Dolgov d9084cf220 implement settings profiles (bump schema) 2010-01-13 18:31:51 +03:00
Andrew Dolgov 661aabe741 add missing schema files 2010-01-11 14:51:57 +03:00
Andrew Dolgov e9105eb50d mobile: properly save preferences 2010-01-11 14:06:19 +03:00
Andrew Dolgov 6f068202d7 rework the way DEFAULT_ARTICLE_LIMIT works, remove limit toolbar dropdown (bump schema) 2010-01-04 12:12:31 +03:00
Andrew Dolgov 451b19c058 fix mysql schema upgrade #60 2010-01-02 14:19:41 +03:00
Andrew Dolgov 24902606eb add ttrss_archived_feeds (MODIFY SCHEMA v60) 2009-12-28 19:15:15 +03:00
Andrew Dolgov e04c18a2c2 implement archived articles feed; bump schema 2009-12-28 17:23:01 +03:00
Andrew Dolgov 57937c42b9 obsolete cookie storage for collapsed status of feedlist and special categories (bump schema) 2009-12-24 15:25:06 +03:00
Andrew Dolgov 3a216db45c add per-user option to enable access to API 2009-12-16 14:36:59 +03:00
Andrew Dolgov e0382fd6df schema: add ttrss_feeds.always_display_enclosures 2009-10-06 14:14:55 +04:00
Andrew Dolgov f574fec6a6 workaround against ttrss_enclosures mysql data being wrong (nukes the enclosures table) 2009-05-11 23:32:16 +04:00
Andrew Dolgov 42a5226a74 mysql: ttrss_enclosures should be an InnoDB table 2009-05-11 23:25:56 +04:00
Andrew Dolgov c7e51de137 Revert "update translations"
This reverts commit 2b38f79c86.

Wrong commit from wrong branch.
2009-03-21 23:11:58 +03:00
Andrew Dolgov 2b38f79c86 update translations 2009-03-21 22:58:32 +03:00
Andrew Dolgov 5161564f3d add support for adding syndicated notes to published articles 2009-03-06 13:40:59 +03:00
Andrew Dolgov 0351576bd8 schema: update help text for ENABLE_OFFLINE_READING 2009-02-10 12:00:51 +03:00
Andrew Dolgov a206a56c6d add missing schema files 2009-02-10 11:51:31 +03:00
Andrew Dolgov 5de926d8cc new option: ENABLE_OFFLINE_READING (bump schema) 2009-02-10 11:50:39 +03:00
Andrew Dolgov 41cb233a11 mysql schema: remove commented stuff (closes #229) 2009-02-06 17:14:41 +03:00
Andrew Dolgov c218ceb82c fix mysql schema (2) 2009-01-26 10:44:27 +01:00
Andrew Dolgov 6fd39d8f98 fix mysql schema 2009-01-26 10:42:44 +01:00
Andrew Dolgov aec57d7ad4 schema: add ttrss_labels2 color fields (bump schema) 2009-01-26 10:41:16 +01:00
Andrew Dolgov 84004f8c5f mysql schema: enable utf8 2009-01-20 15:54:45 +01:00
Andrew Dolgov 931dcbc137 feedbrowser_cache: store title; implement by-title search in feed browser 2009-01-20 11:01:22 +01:00
Andrew Dolgov f054b5475b schema: remove ttrss_labels 2009-01-18 16:42:07 +01:00
Andrew Dolgov e2549229e1 display article labels in headlines buffer 2009-01-18 14:54:40 +01:00
Andrew Dolgov f8bfb81fd1 schema fixes 2009-01-18 11:46:28 +01:00
Andrew Dolgov ceb30ba49d new style labels (bump schema) 2009-01-18 09:28:42 +01:00
Andrew Dolgov 8a4c759ea3 a variety of ccache work 2009-01-16 14:11:19 +01:00
Andrew Dolgov 044d39acb2 add missing schema files 2009-01-16 12:48:39 +01:00
Andrew Dolgov a1eba24b24 alter ttrss_counters_cache; bump schema 2009-01-16 12:48:16 +01:00
Andrew Dolgov 0c630ef326 schema: add ttrss_feedbrowser_cache (bump schema) 2009-01-16 10:33:25 +01:00
Andrew Dolgov 2362de6d9b schema: add field for filter type-specific params; bump schema 2008-12-13 13:19:06 +01:00
Andrew Dolgov 75fa1e3126 schema: add new filter type (refs #225) 2008-12-13 12:57:01 +01:00
Andrew Dolgov 889ec95a96 add missing schema files for v. 45 2008-11-13 06:59:59 +01:00
Andrew Dolgov a969b30bb1 block cdmWatchdog() in Fresh feed 2008-11-13 06:53:41 +01:00
Andrew Dolgov 4d73637869 schema: add ttrss_counters_cache 2008-10-13 14:10:31 +01:00
Andrew Dolgov f7f939b29c alter ttrss_labels.sql_exp to text, bump schema (closes #221) 2008-09-18 06:02:43 +01:00
Andrew Dolgov 7b4d02a834 main toolbar: add dropbox to select headlines sort mode 2008-09-09 04:30:12 +01:00
Andrew Dolgov 782ddd7014 implement (incomplete) sortable feedlist 2008-08-29 08:34:35 +01:00
Andrew Dolgov 2dcb7e80e5 rename description of option ENABLE_FEED_ICONS, bump schema 2008-08-08 06:22:38 +01:00
Andrew Dolgov e7490ab155 set the default for ENABLE_FLASH_PLAYER to true 2008-08-01 06:15:17 +01:00
Andrew Dolgov 94145fdf96 add missing upgrade files for schema ver. 39 2008-08-01 06:12:14 +01:00
Andrew Dolgov 8dccabedae merge two patches: STRIP_IMAGES and ENABLE_FLASH_PLAYER from Sten (bump schema) 2008-08-01 04:38:17 +01:00
Andrew Dolgov d234a2e39d new option: SYNC_COUNTERS (bump schema) 2008-07-23 04:55:35 +01:00
Andrew Dolgov 1ba2b87873 add missing schema updates for v. 37 2008-05-17 05:52:19 +01:00
Andrew Dolgov d00f22ac59 new option: VFEED_GROUP_BY_FEED (bump schema version) 2008-05-17 05:50:58 +01:00
Andrew Dolgov fdb7b03fc0 add new filter action: modify score 2008-04-30 07:35:30 +01:00
Andrew Dolgov afb6038e47 add ttrss_user_entries.score; bump schema 2008-04-30 07:34:08 +01:00
Andrew Dolgov fc2b26a6a2 add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201) 2008-04-21 05:53:19 +01:00
Andrew Dolgov 43398b8e43 remove limit on ttrss_feeds.feed_url length (closes #199) 2008-03-13 09:18:21 +01:00
Andrew Dolgov fca933507d new option: HIDE_FEEDLIST (bump schema) 2008-02-20 04:37:24 +01:00
Andrew Dolgov 2b6ed06b23 schema: add ttrss_prefs.access_level, bump version 2008-01-30 11:54:16 +01:00
Andrew Dolgov 5b8534ef6c schema: add ttrss_feeds.update_method, bump version 2008-01-25 17:40:33 +01:00
Andrew Dolgov 3c50da8334 schema: add ttrss_feeds.last_update_started, bump version 2008-01-23 09:44:50 +01:00
Andrew Dolgov 22f3e356c8 new option: HIDE_READ_SHOWS_SPECIAL (bump schema) 2008-01-21 09:30:54 +01:00
Andrew Dolgov f0907182c6 schema: set cat_id in ttrss_feeds to null when category is deleted 2008-01-21 04:27:42 +01:00
Andrew Dolgov 79095d68ff update BLACKLISTED_TAGS, bump schema (closes #186) 2008-01-14 06:59:43 +01:00
Andrew Dolgov f65b8485c6 fix schema version 2008-01-14 06:49:00 +01:00
Andrew Dolgov 092b9ee929 add schema ver 27 2007-11-21 13:33:06 +01:00
Andrew Dolgov 14fb4e91fc headlines cache: force refresh when subop is present 2007-11-21 13:29:41 +01:00
Andrew Dolgov ce53e200b4 add support for enclosures (closes #165) 2007-11-17 13:13:08 +01:00
Andrew Dolgov aa6d1e9766 schema: enclosure fixes 2007-11-17 11:33:13 +01:00
Andrew Dolgov 963d33141c schema: add support for enclosures 2007-11-17 11:16:24 +01:00
Andrew Dolgov 54a3d3cf51 schema: add created field to ttrss_users 2007-11-16 06:11:59 +01:00
Andrew Dolgov 07d0efe959 new preference: PURGE_UNREAD_ARTICLES (closes #161), fix bug in user purge 2007-11-15 06:41:53 +01:00
Andrew Dolgov d89a272ab8 unpimp the blog 2007-10-30 10:33:08 +01:00
Andrew Dolgov e603a0fa8f shamelessly pimp tt-rss devblog in default install 2007-10-30 09:36:14 +01:00
Andrew Dolgov 203610630a add 3pane theme 2007-10-30 09:22:01 +01:00
Andrew Dolgov 2918ff5eaa change ttrss_prefs.help_text type to varchar(250) 2007-10-29 08:46:08 +01:00
Andrew Dolgov 5062b8400d change ttrss_prefs.help_text type to text 2007-10-29 08:45:08 +01:00
Andrew Dolgov bef4c2451e add option to auto-expand CDM list (bump schema) 2007-10-18 03:24:22 +01:00
Andrew Dolgov dc85be2b35 digest: add option to mark sent articles as read 2007-10-01 04:13:09 +01:00
Andrew Dolgov fb67e2ba58 schema: add cache_images feed option 2007-08-26 04:34:52 +01:00
Andrew Dolgov 3c62b74874 add schema version 22 scripts 2007-08-25 05:49:41 +01:00
Andrew Dolgov b60e1d862c add index on ttrss_entries(date_entered), bump schema 2007-08-25 05:48:27 +01:00
Andrew Dolgov c1d7e6c344 new option: FRESH_ARTICLE_MAX_AGE (bump schema) 2007-08-23 09:05:40 +01:00
Andrew Dolgov 8c0edbc36c localization fixes and updates (bumps schema) 2007-08-21 11:34:43 +01:00
Andrew Dolgov c1879099e1 mysql: disable utf8 2007-08-21 06:35:24 +01:00
Andrew Dolgov 150b4a2ca5 set utf-8 as default charset just in case 2007-08-21 05:51:18 +01:00
Andrew Dolgov 91d64fb808 enlarge filters action_param field 2007-08-20 03:47:04 +01:00
Andrew Dolgov 0d276d67b0 workaround against mysql refusing to have defaults for text values (closes #137) 2007-08-16 13:19:00 +01:00
Andrew Dolgov 0c4811be71 schema: new filter, publish 2007-08-09 14:38:59 +01:00
Andrew Dolgov ffba8297ea schema: add published column 2007-08-09 11:09:22 +01:00
Andrew Dolgov c59d33a3a8 fix schema 2007-08-09 09:56:26 +01:00
Andrew Dolgov 237ec2ad9c disable headlines pagination (add hidden pref _PREFS_ENABLE_PAGINATION) 2007-07-17 04:29:53 +01:00
Andrew Dolgov feead173b0 reintroduce option ENABLE_SEARCH_TOOLBAR 2007-05-19 12:57:23 +01:00
Andrew Dolgov 1eb19b6adc new option: BLACKLISTED_TAGS 2007-05-17 08:42:28 +01:00
Andrew Dolgov f335e9659d change description of STRIP_UNSAFE_TAGS 2007-05-16 09:35:56 +01:00
Andrew Dolgov f826eee150 new option: STRIP_UNSAFE_TAGS 2007-05-16 07:50:00 +01:00
Andrew Dolgov 465ff90b4a new hidden param, _INFOBOX_DISABLE_OVERLAY 2007-05-14 09:31:54 +01:00
Andrew Dolgov e98bb24308 add missing update scripts for schema v.17 2007-05-05 12:00:55 +01:00
Andrew Dolgov fe8d205964 save active tab in prefs, fix schema 2007-05-04 04:26:20 +01:00
Andrew Dolgov 87b9fb6532 add _PREFS_ACTIVE_TAB hidden option, tweak update.php, move SCHEMA_VERSION definition to sanity_check.php 2007-05-04 04:15:58 +01:00
Andrew Dolgov e85610c710 schema: fix version 2007-04-20 03:59:27 +01:00
Andrew Dolgov 155a2a53ff schema: add (unused) ttrss_feeds.auth_pass_encrypted, bump schema 2007-04-18 07:25:51 +01:00
Andrew Dolgov 4049672041 add persistent storage for toolbar view options, bump schema 2007-03-26 06:23:15 +01:00
Andrew Dolgov 3fb00ee0a2 schema: fix typo 2007-03-06 08:20:43 +01:00
Andrew Dolgov 724d744498 update schema 2007-03-06 07:24:25 +01:00
Andrew Dolgov 72ae6d7a84 new pref: CDM_AUTO_CATCHUP, bump schema 2007-03-06 07:22:31 +01:00
Andrew Dolgov 078b5702be schema: change default feeds 2007-03-02 15:45:55 +01:00
Andrew Dolgov fecd57c886 add new-style schema versions and updater 2007-02-24 17:46:39 +01:00
Andrew Dolgov 1212419849 remove old-style schema upgrade files 2007-02-24 17:45:27 +01:00
Andrew Dolgov 3f2ff803b3 add interface/schema for inverse matching filters 2007-01-30 17:23:35 +01:00
Andrew Dolgov de07b5eee9 ttrss_filters: add tag action (2) 2006-12-08 07:36:59 +01:00
Andrew Dolgov 7cb9311ba1 ttrss_filters: add tag action 2006-12-08 07:34:59 +01:00
Andrew Dolgov 9ebaec057c ttrss_filters: add action_param field, bump schema version 2006-12-08 07:31:49 +01:00
Andrew Dolgov 85f57c80bd move out obsolete upgrade scripts 2006-12-07 11:03:31 +01:00