blallo/tt-rss
1
0
Fork 0
Code Issues Pull requests Releases Wiki Activity
tt-rss/schema/versions/pgsql
History
Anders Kaseorg bd40827b73 Drop duplicate database indexes 
These duplicate indexes were found by the pt-duplicate-key-checker
tool in percona-toolkit.  Duplicate indexes waste space and slow down
the query planner.  Closes #835.

Signed-off-by: Anders Kaseorg <andersk@mit.edu>
2014-12-18 02:50:03 -05:00
..
3.sql
4.sql
5.sql
6.sql
7.sql
8.sql
9.sql
10.sql
11.sql
12.sql
13.sql
14.sql
15.sql
16.sql
17.sql
18.sql
19.sql
20.sql
21.sql
22.sql
23.sql
24.sql
25.sql
26.sql
27.sql
28.sql
29.sql
30.sql
31.sql
32.sql
33.sql
34.sql
35.sql
36.sql
37.sql
38.sql
39.sql set the default for ENABLE_FLASH_PLAYER to true 2008-08-01 06:15:17 +01:00
40.sql rename description of option ENABLE_FEED_ICONS, bump schema 2008-08-08 06:22:38 +01:00
41.sql implement (incomplete) sortable feedlist 2008-08-29 08:34:35 +01:00
42.sql main toolbar: add dropbox to select headlines sort mode 2008-09-09 04:30:12 +01:00
43.sql alter ttrss_labels.sql_exp to text, bump schema (closes #221) 2008-09-18 06:02:43 +01:00
44.sql schema: add ttrss_counters_cache 2008-10-13 14:10:31 +01:00
45.sql add missing schema files for v. 45 2008-11-13 06:59:59 +01:00
46.sql schema: add new filter type (refs #225) 2008-12-13 12:57:01 +01:00
47.sql schema: add field for filter type-specific params; bump schema 2008-12-13 13:19:06 +01:00
48.sql schema: add ttrss_feedbrowser_cache (bump schema) 2009-01-16 10:33:25 +01:00
49.sql add missing schema files 2009-01-16 12:48:39 +01:00
50.sql a variety of ccache work 2009-01-16 14:11:19 +01:00
51.sql new style labels (bump schema) 2009-01-18 09:28:42 +01:00
52.sql feedbrowser_cache: store title; implement by-title search in feed browser 2009-01-20 11:01:22 +01:00
53.sql schema: add ttrss_labels2 color fields (bump schema) 2009-01-26 10:41:16 +01:00
54.sql schema: update help text for ENABLE_OFFLINE_READING 2009-02-10 12:00:51 +03:00
55.sql Revert "update translations" 2009-03-21 23:11:58 +03:00
56.sql workaround against ttrss_enclosures mysql data being wrong (nukes the enclosures table) 2009-05-11 23:32:16 +04:00
57.sql schema: add ttrss_feeds.always_display_enclosures 2009-10-06 14:14:55 +04:00
58.sql add per-user option to enable access to API 2009-12-16 14:36:59 +03:00
59.sql obsolete cookie storage for collapsed status of feedlist and special categories (bump schema) 2009-12-24 15:25:06 +03:00
60.sql add ttrss_archived_feeds (MODIFY SCHEMA v60) 2009-12-28 19:15:15 +03:00
61.sql rework the way DEFAULT_ARTICLE_LIMIT works, remove limit toolbar dropdown (bump schema) 2010-01-04 12:12:31 +03:00
62.sql add missing schema files 2010-01-11 14:51:57 +03:00
63.sql implement settings profiles (bump schema) 2010-01-13 18:31:51 +03:00
64.sql reorganize theme support; add some themeable icons; add neon theme 2010-01-14 16:11:54 +03:00
65.sql change description of DEFAULT_UPDATE_INTERVAL (bump schema) 2010-01-20 14:21:25 +03:00
66.sql allow filtering by article author (bump schema) 2010-03-23 14:38:58 +03:00
67.sql 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
68.sql implement per-user timezone support; store dates in UTC internally (closes #254) 2010-11-07 18:14:48 +03:00
69.sql 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
70.sql add ttrss_users.full_name; bump schema 2010-11-08 16:34:49 +03:00
71.sql schema: wrap upgrade scripts in transaction blocks 2010-11-10 11:45:28 +03:00
72.sql schema: wrap upgrade scripts in transaction blocks 2010-11-10 11:45:28 +03:00
73.sql add option to sort headlines by feed-specified date (bump schema) 2010-11-10 13:56:42 +03:00
74.sql add upgrade files for schema #74 2010-11-10 19:12:49 +03:00
75.sql schema: add ttrss_feeds.order_id 2010-11-18 12:56:21 +03:00
76.sql add experimental support for Twitter OAuth and Twitter feeds (bump schema) 2010-11-22 16:26:00 +03:00
77.sql rework user CSS support (bump schema) 2010-11-24 19:23:24 +03:00
78.sql clean obsolete options from schema (bump schema version) 2010-11-29 13:02:44 +03:00
79.sql mobile: allow showing category content inline (closes #315) 2011-03-04 17:53:02 +03:00
80.sql change description of CDM_AUTO_CATCHUP (bump schema) 2011-03-06 09:55:40 +03:00
81.sql change description of filter 'filter' action (bump schema) 2011-03-10 11:54:10 +03:00
82.sql authenticate against a hash of identifyable information from certificate instead of only serial (refs #324) 2011-03-28 09:45:23 +04:00
83.sql schema: remove ttrss_themes 2011-04-01 15:26:02 +04:00
84.sql schema: add unique constraint on access_key 2011-04-20 16:17:57 +04:00
85.sql feedbrowser_cache & linked feeds: add site url (bump schema) 2011-04-20 20:05:10 +04:00
86.sql add missing schema files for version 86 2011-10-04 13:57:35 +04:00
87.sql implement filtering by category (closes #386) 2011-12-27 12:57:38 +04:00
88.sql improve password storage (use sha256 and long random salt) 2012-01-22 11:48:14 +04:00
89.sql update preferred time description to mention UTC 2012-02-01 15:52:09 +04:00
90.sql pref-feeds: apply patch by gmargo@forum to show/hide empty categories 2012-03-05 12:08:39 +04:00
91.sql change ON_CATCHUP_SHOW_NEXT_FEED helptext, bump schema 2012-03-29 15:08:12 +04:00
92.sql rate-limit requests for favicons when not present to conserve traffic (refs #457) 2012-05-24 16:20:03 +04:00
93.sql add ttrss_feed_categories.parent_cat, bump schema 2012-08-13 14:47:54 +04:00
94.sql properly persist include_children 2012-08-15 09:11:43 +04:00
95.sql hide more obscure preferences under "show more" checkbox in pref-prefs, 2012-08-30 13:10:28 +04:00
96.sql fix wrong version in psql update script 2012-08-31 12:15:59 +04:00
97.sql implement one time passwords using TOTP 2012-09-03 18:33:46 +04:00
98.sql add ability to auto-assign articles to labels (bump schema) 2012-10-30 12:58:35 +04:00
99.sql implement ttrss_feeds.cache_content 2012-11-23 13:22:34 +04:00
100.sql experimental support for per-user plugins (bump schema) 2012-12-25 00:45:10 +04:00
101.sql add plugin storage table to schema; add ability to clear plugin data 2012-12-27 19:20:36 +04:00
102.sql add _MOBILE_REVERSE_HEADLINES (closes #524) 2012-12-28 00:49:54 +04:00
103.sql add ttrss_user_entries.plugin_data (bump schema) 2013-02-21 22:08:38 +04:00
104.sql add schema 104 upgrade files 2013-03-14 18:53:49 +04:00
105.sql implement proper last_marked/last_published feeds for proper sorting of 2013-03-17 15:38:21 +04:00
106.sql rework STRIP_IMAGES to remove embedding; add per-feed control over embedded images (bump schema) 2013-03-19 22:41:10 +04:00
107.sql let us rejoice on being able to create double negative filters (refs #631) 2013-03-25 19:46:43 +04:00
108.sql schema: disable sort headlines by feed date by default 2013-03-26 09:08:42 +04:00
109.sql change description of HIDE_READ_FEEDS 2013-03-27 12:41:31 +04:00
110.sql add ability to select CSS files in themes/ 2013-03-28 21:04:29 +04:00
111.sql set combined display mode as default 2013-03-29 19:37:42 +04:00
112.sql add necessary schema plumbing to implement filter ordering 2013-03-31 16:25:27 +04:00
113.sql implement stop action 2013-03-31 19:28:36 +04:00
114.sql schema: add feed/cat view_settings 2013-04-01 09:09:20 +04:00
115.sql schema: remove unused prefs help_text/short_desc/section_name 2013-04-02 16:34:08 +04:00
116.sql update default of allow_duplicate_posts to false, bump schema 2013-04-09 22:26:38 +04:00
117.sql add schema version 177 upgrade scripts 2013-04-15 15:38:20 +04:00
118.sql experimental SQL-based error logger 2013-04-16 19:41:31 +04:00
119.sql set default timezone to automatic (bump schema) 2013-04-26 14:16:03 +04:00
120.sql remove language selector from the login form, store language in the database per-user 2013-04-29 15:54:23 +04:00
121.sql switch AUTO_ASSIGN_LABELS to off by default (bump schema) 2013-05-30 18:26:56 +04:00
122.sql add text_languagedetect to guess article language for better hyphenation 2013-07-31 10:30:17 +04:00
123.sql add update script to convert myisam tables to innodb (bump version) 2013-09-17 14:34:39 +04:00
124.sql schema: add resetpass_token (bump schema) 2014-03-09 10:50:32 +04:00
125.sql bump schema version to fix resetpass_token created as a wrong type in 124 2014-04-06 13:40:16 +00:00
126.sql Update schema for size support of enclosures 2014-07-15 15:05:08 +02:00
127.sql Drop duplicate database indexes 2014-12-18 02:50:03 -05:00