Commit Graph

388 Commits

Author SHA1 Message Date
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
Andrew Dolgov c339343b40 add compact theme 2006-10-01 11:57:50 +01:00
Andrew Dolgov c91c224952 drop option ENABLE_SEARCH_TOOLBAR, use some more callbacks in filterCR 2006-10-01 08:00:04 +01:00
Andrew Dolgov 800a71e0f1 add graycube theme 2006-09-30 17:33:56 +01:00
Andrew Dolgov 96527ac659 remove DISPLAY_HEADER/FOOTER options (update schema) 2006-09-29 08:53:47 +01:00
Andrew Dolgov f698dd2796 schema: move out old upgrade files 2006-09-29 08:50:02 +01:00
Andrew Dolgov f6d6e22ff4 new option: CONFIRM_FEED_CATCHUP (closes #106) 2006-08-28 05:03:26 +01:00
Andrew Dolgov 3dd9183cd6 schema: ttrss_feeds, new field - include_in_digest 2006-08-22 08:29:18 +01:00
Andrew Dolgov e2a8a097bd bump schema version 2006-08-21 16:09:05 +01:00
Andrew Dolgov 481c9804aa change email to e-mail in description of DIGEST_ENABLE pref option 2006-08-21 07:47:20 +01:00
Andrew Dolgov 9a61ce6d20 add upgrade schema files for 1.2.3, new option: DIGEST_ENABLE 2006-08-21 07:12:09 +01:00
Andrew Dolgov 8fb018809f move out old schema upgrade files 2006-08-21 07:11:36 +01:00
Andrew Dolgov 4fd52ba4b0 schema: add enabled field to ttrss_filters 2006-08-20 15:02:48 +01:00
Andrew Dolgov 32be4b10c3 add fields for daily email digest to ttrss_users 2006-08-20 11:54:53 +01:00
Andrew Dolgov 60a2080f9a fix mysql update script bug 2006-08-17 04:05:49 +01:00
Andrew Dolgov 7da377ca8b add hidden field to ttrss_feeds 2006-08-13 12:43:48 +01:00
Andrew Dolgov d6e5706d7e new option: REVERSE_HEADLINES (closes #97) 2006-08-01 05:52:32 +01:00
Andrew Dolgov 53c98a9af8 move 3 options to advanced section 2006-07-31 09:02:16 +01:00
Andrew Dolgov 52c61bf866 add schema update scripts for 1.2.2 2006-07-25 09:12:17 +01:00
Andrew Dolgov 4919fb42c9 new option: MARK_UNREAD_ON_UPDATE (closes #76) 2006-07-25 09:11:13 +01:00
Andrew Dolgov 5cfc8713d2 move old schema upgrade files 2006-07-25 08:36:34 +01:00
Andrew Dolgov 78d5212c0a optionally show last update time in feedlist (EXTENDED_FEEDLIST) (closes #55) 2006-06-06 07:51:00 +01:00
Andrew Dolgov c9268ed599 sort feedlist by unread articles (closes #66) 2006-06-05 09:33:19 +01:00
Andrew Dolgov dd7d31871e new filter action: set starred, rename add filter button 2006-05-18 02:20:43 +01:00
Andrew Dolgov e52d6bc4be new option: ON_CATCHUP_SHOW_NEXT_FEED, fix several schema issues 2006-05-17 14:12:11 +01:00
Andrew Dolgov 9483421615 introduce old-skool theme 2006-05-17 08:45:17 +01:00
Andrew Dolgov 01b3e1919a split backend rpc, various interface improvements 2006-03-29 04:11:48 +01:00
Andrew Dolgov 3b0f23de40 schema: drop ip_address from ttrss_sessions 2006-03-28 04:45:30 +01:00
Andrew Dolgov a2e9b45759 obsolete ip_address field in ttrss_sessions 2006-03-27 17:23:50 +01:00
Andrew Dolgov 894ebcf5e9 update_daemon work, remove unneeded indexes, query optimizations 2006-03-21 08:09:18 +01:00
Andrew Dolgov 44e241cb44 query optimizations; split big feed update transaction 2006-03-21 05:52:56 +01:00
Andrew Dolgov 70f6dbb10b experimental RTL support features (schema, version bump) 2006-03-20 11:28:14 +01:00
Andrew Dolgov 2e73dece90 fix schema version 2006-03-20 06:36:33 +01:00
Andrew Dolgov 7f16656eb7 remove support for plain-text passwords 2006-03-07 12:25:44 +01:00
Andrew Dolgov 68511f86ac new option: OPEN_LINKS_IN_NEW_WINDOW (closes #47) 2006-03-06 05:45:54 +01:00
Andrew Dolgov 9e2cdd5135 remove ENABLE_SPLASH user param, just in case 2006-03-04 07:32:40 +01:00
Andrew Dolgov 04febb0429 shrink session id length in db 2006-03-02 13:15:28 +01:00
Andrew Dolgov 09018e9526 new option: SESSION_CHECK_ADDRESS 2006-03-02 09:32:44 +01:00
Andrew Dolgov 8fd92701e9 update schema, new option: DATABASE_BACKED_SESSIONS 2006-03-02 09:20:02 +01:00
Andrew Dolgov 36bfab86c2 database backed sessions 2006-03-02 09:10:43 +01:00
Andrew Dolgov 59b8192f94 workaround for Opera cache of feeds/headlines panel; remove addheader param handling 2006-02-26 15:07:22 +01:00
Andrew Dolgov 4bc760da51 add author column to ttrss_entries, add upgrade script for 1.1.4, bump schema version 2006-02-26 07:39:09 +01:00
Andrew Dolgov ab5eb26fba fix scheduled_updates drop position in schema 2006-02-17 07:59:25 +01:00
Andrew Dolgov 7afb0f019d move 1.1.1-1.1.2 upgrade scripts to obsolete 2006-02-12 10:59:29 +01:00
Andrew Dolgov baf79bb1b7 fix pgsql upgrade script 2006-02-12 06:26:20 +01:00
Andrew Dolgov b4548c3237 add upgrade scripts to 1.1.3 2006-02-12 06:24:36 +01:00
Andrew Dolgov de696427ad initial work on update daemon 2006-02-11 14:52:17 +01:00
Andrew Dolgov dbf4a4cf05 UNDO: schema: support for audio enclosure in ttrss_entries 2006-01-12 14:19:13 +01:00
Andrew Dolgov ab1c2c9de5 schema: support for audio enclosure in ttrss_entries 2006-01-12 14:19:13 +01:00
Andrew Dolgov 7f123cdab4 new option: HIDE_READ_FEEDS (+ pref setting RPC calls) (closes #23) 2006-01-05 16:12:40 +01:00
Andrew Dolgov 13b9833355 mysql 5.0 fix (closes #24) 2006-01-05 15:35:40 +01:00
Andrew Dolgov 5b35b4de9b ttrss_feeds: add private column to hide from browser 2005-12-30 04:05:01 +01:00
Andrew Dolgov 41765fef9b bump schema version 2005-12-29 19:03:24 +01:00
Andrew Dolgov de99f5005d add parent_feed column to ttrss_feeds, create upgrade script for 1.1.1, move out old scripts to schema/obsolete 2005-12-28 19:59:47 +01:00
Andrew Dolgov 49756fc36c bump schema version 2005-12-21 19:08:59 +01:00
Andrew Dolgov 5238347d43 new option: ENABLE_SEARCH_TOOLBAR 2005-12-20 16:58:39 +01:00
Andrew Dolgov 8629e09d9b schema: add email column to ttrss_users 2005-12-20 07:23:33 +01:00
Andrew Dolgov 855d0ecfda schema: wrap table creation in transaction block 2005-12-16 06:48:45 +01:00
Andrew Dolgov e93a3c96bb add login/pass fields for feeds 2005-12-16 06:45:04 +01:00
Andrew Dolgov fb891340e6 fix upgrade script for mysql 2005-12-13 15:32:36 +01:00
Andrew Dolgov 28bcadff2b schema: add collapsed field for ttrss_user_categories 2005-12-13 09:30:52 +01:00
Andrew Dolgov 30ccc2f1cf change COMBINED_DISPLAY_MODE help text 2005-12-13 06:58:22 +01:00
Andrew Dolgov 386cbf27aa combined article display mode (option COMBINED_DISPLAY_MODE), remove xml feed output 2005-12-13 06:52:32 +01:00
Andrew Dolgov eb40e11b14 add column for slash:comments and alike in ttrss_entries (+ add upgrade scripts for 1.1.1) 2005-12-10 08:14:29 +01:00
Andrew Dolgov 559ccbf305 add missing column to 1.0.6-1.0.7 upgrade script 2005-12-04 12:51:53 +01:00
Andrew Dolgov 8fe19cd81e forgot about SHORT/LONG date formats for mysql schema 2005-12-03 10:39:32 +01:00
Andrew Dolgov 53d6935b34 schema: add filter actions, fix typo in PG schema 2005-11-29 19:30:08 +01:00
Andrew Dolgov be773442d2 option HEADLINES_SMART_DATE 2005-11-28 08:43:03 +01:00
Andrew Dolgov 9167e250e8 new options: SHORT_DATE_FORMAT, LONG_DATE_FORMAT 2005-11-27 20:57:59 +01:00
Andrew Dolgov 591c396df4 content preview in headlines list, option SHOW_CONTENT_PREVIEW 2005-11-27 16:17:49 +01:00
Andrew Dolgov 00a0bcc82f fix cascade delete for user_prefs foreign keys and PG 2005-11-26 13:36:22 +01:00
Andrew Dolgov ef775b46d8 remove splashscreen 2005-11-26 13:34:08 +01:00
Andrew Dolgov e552e5a200 themes schema 2005-11-25 13:37:42 +01:00
Andrew Dolgov 17095c5a0e fix ttrss_feed_categories auto increment on mysql 2005-11-23 15:21:59 +01:00
Andrew Dolgov 81dde650b6 fix table drop order in schema 2005-11-23 13:51:50 +01:00
Andrew Dolgov 30a49c9227 DAEMON_REFRESH_ONLY makes a lot more sense as a global option 2005-11-23 13:26:29 +01:00
Andrew Dolgov e0b77afceb misc schema updates (for mysql) 2005-11-23 10:38:19 +01:00
Andrew Dolgov a04a687d90 misc schema updates 2005-11-23 10:35:08 +01:00
Andrew Dolgov 91ff844a86 feed categories 2005-11-23 08:07:04 +01:00
Andrew Dolgov 10dc37acce option to enable feed categories 2005-11-23 06:57:08 +01:00
Andrew Dolgov 5a214f9d68 ttrss_feed_categories are now uid-aware 2005-11-23 06:36:28 +01:00
Andrew Dolgov 4a9a8bd884 add schema for feed categories 2005-11-23 06:15:53 +01:00
Andrew Dolgov 386d7b5bda new option - USER_STYLESHEET_URL 2005-11-22 07:44:19 +01:00
Andrew Dolgov 8caa7999c0 entry comments schema 2005-11-20 19:06:06 +01:00
Andrew Dolgov e55a298d5c fix wrong foreign key reference in ttrss_filters for PGSQL 2005-11-21 15:04:46 +01:00
Andrew Dolgov 2bbd16b947 per-feed filters in schema 2005-11-21 14:11:16 +01:00
Andrew Dolgov 3a933f22b1 filters are now actually applied separately for each user 2005-11-21 08:38:28 +01:00
Andrew Dolgov 14c8eca714 fix ALLOW_DUPLICATE_POSTS description 2005-11-20 08:45:44 +01:00
Andrew Dolgov 45a2e09256 tweak ALLOW_DUPLICATE_POSTS help text 2005-11-19 11:37:41 +01:00
Andrew Dolgov 71604ca4e9 new option - ALLOW_DUPLICATE_POSTS 2005-11-19 11:32:59 +01:00
Andrew Dolgov c62d62f65e new schema adapted for mysql, PG schema fixes 2005-11-19 11:03:47 +01:00
Andrew Dolgov 05732aa0b6 misc new schema support related work 2005-11-19 09:18:34 +01:00
Andrew Dolgov daa25e8a50 add schema indexes 2005-11-19 09:03:54 +01:00
Andrew Dolgov 4c193675d0 initial split ttrss_entries work 2005-11-19 06:48:02 +01:00
Andrew Dolgov 8bbb8466df update schema to split ttrss_entries 2005-11-19 06:10:00 +01:00
Andrew Dolgov 870ef47907 remove test users from schema 2005-11-18 10:53:21 +01:00
Andrew Dolgov f16ef23677 change last_login type for mysql 2005-11-18 10:14:24 +01:00
Andrew Dolgov 4f628ae588 add last_login field to ttrss_users 2005-11-18 10:11:56 +01:00
Andrew Dolgov cd42edf18d removed some default feeds from schema 2005-11-18 09:58:17 +01:00
Andrew Dolgov d5ebcff9a2 remove upgrade scripts for 1.0.7-1.0.8 2005-11-18 08:15:02 +01:00
Andrew Dolgov 273a2f6b43 schema updates, ICONS_DIR/ICONS_URL moved to config.php 2005-11-18 08:04:41 +01:00
Andrew Dolgov 2aaacbc03e minor fixes in PG schema 2005-11-18 07:49:00 +01:00
Andrew Dolgov a6ccf566b7 multi-user schema for mysql 2005-11-18 07:48:45 +01:00
Andrew Dolgov ff485f1d50 per-user preferences 2005-11-18 06:17:17 +01:00
Andrew Dolgov 6318df0e5c more multiuser schema fixes 2005-11-17 19:04:18 +01:00
Andrew Dolgov b58cf26600 update schema again 2005-11-17 18:37:15 +01:00
Andrew Dolgov ee9008f922 update schema 2005-11-17 18:34:58 +01:00
Andrew Dolgov 4e9dd2cddf initial multiuser schema work 2005-11-17 14:06:03 +01:00
Andrew Dolgov 9f8c0ce504 update 1.0.7-1.0.8 upgrade scripts 2005-11-17 11:47:06 +01:00
Andrew Dolgov 44e7753a11 fix 1.0.6-1.0.7 upgrade script for PG 2005-11-17 11:42:52 +01:00
Andrew Dolgov 650bc4350f Advanced section in preferences, tweak pref editor look 2005-11-17 11:24:34 +01:00
Andrew Dolgov 36990e3304 add help_text for some options in schema 2005-11-17 08:10:03 +01:00
Andrew Dolgov 4338e23d07 fix schema typo 2005-11-17 06:39:27 +01:00
Andrew Dolgov 2fb72ab9b4 update mysql schema 2005-11-17 06:38:24 +01:00
Andrew Dolgov 0298fb3f3d update prefs sections 2005-11-17 06:37:27 +01:00
Andrew Dolgov 541492a9ce update schema 2005-11-17 05:57:03 +01:00
Andrew Dolgov 603e9ebed8 update prefs schema 2005-11-17 05:41:26 +01:00
Andrew Dolgov 4769ddaf72 sql-ize backend.php 2005-11-16 18:37:45 +01:00
Andrew Dolgov e0257be14a create sql preferences schema 2005-11-16 17:48:29 +01:00
Andrew Dolgov b17ede720c add 1->2 upgrade script for mysql 2005-11-16 13:18:52 +01:00
Andrew Dolgov 1089b16bc2 add purge_interval in ttrss_feeds (schema updated) 2005-11-16 08:24:43 +01:00
Andrew Dolgov 5f171894d1 ttrss_version table (schema updated) 2005-11-10 05:34:36 +01:00
Andrew Dolgov 37d379de29 reserve column in ttrss_feeds for site url (schema+upgrade script updated) 2005-11-02 12:53:06 +01:00
Andrew Dolgov 32bd6e262f rename schema upgrade file 2005-11-01 14:30:36 +01:00
Andrew Dolgov 833188150f schema/upgrade-1.0.6-1.0.7.sql: fix 2005-11-01 10:01:03 +01:00
Andrew Dolgov 4e31590e41 add schema/upgrade-1.0.6-1.0.7.sql 2005-11-01 10:00:18 +01:00
Andrew Dolgov ab3d0b9926 store last feed update error in the database (SCHEMA UPDATED), display warning box in preferences on feed update error 2005-11-01 08:47:03 +01:00
Andrew Dolgov 7cc6112aaa add another example label in default schema 2005-10-20 17:18:15 +01:00
Andrew Dolgov d148926e2b per-feed update intervals 2005-10-13 04:15:09 +01:00
Andrew Dolgov 1696229f9d fixed serious bug in MySQL schema (cascade deletes were unfunctional), add yet another content: subtype workaround 2005-10-12 11:54:09 +01:00
Andrew Dolgov a0d5a39abb fix mysql (guid) schema bug 2005-09-24 13:34:45 +01:00
Andrew Dolgov 49a0dd3d3f while we are at it, change ttrss_entries.{guid,link} to text too 2005-09-14 14:52:21 +01:00
Andrew Dolgov 9ad5b0de31 change ttrss_entries.title type to text 2005-09-14 14:43:26 +01:00
Andrew Dolgov 8143ae1f2b more work on tag support 2005-09-09 08:45:54 +01:00
Andrew Dolgov eb36b4eb55 start work on support for technorati tags, schema uses cascade deletes for pgsql 2005-09-09 05:52:36 +01:00
Andrew Dolgov d6f55ce800 rename All Posts, change default labels in schema 2005-09-08 14:05:48 +01:00
Andrew Dolgov a82065a18b no entries found -> no articles found 2005-09-08 10:35:05 +01:00
Andrew Dolgov 48f0adb02e virtual feeds (labels) support 2005-09-08 08:43:44 +01:00
Andrew Dolgov 3eb570288d move schema examples to subdirectory 2005-09-08 04:25:33 +01:00