summaryrefslogtreecommitdiff
path: root/schema
AgeCommit message (Collapse)Author
2021-03-04bring back web dbupdate using new migrations systemAndrew Dolgov
2021-03-04wip for db_migrations for core schemaAndrew Dolgov
2021-02-27bump schema for ttrss_user_labels2 indexesAndrew Dolgov
2021-02-25remove unused data from schema filesAndrew Dolgov
2021-02-25bump schema for upcoming prefs overhaulAndrew Dolgov
2020-09-28schema: add ttrss_feeds.last_successful_updateAndrew Dolgov
2019-11-07schema: when inserting initial forum feed, don't hardcode admin UID as 1Andrew Dolgov
2019-11-03revise schema 139 to use engine=innodbAndrew Dolgov
2019-11-01schema: add missing stuffAndrew Dolgov
2019-11-01update schema for app-specific passwordsAndrew Dolgov
2019-04-10schema: update version to 138Andrew Dolgov
2019-04-10schema: add DEFAULT_SEARCH_LANGUAGEAndrew Dolgov
2019-03-10set key length to 255 on mysqlAndrew Dolgov
2019-03-10add composite key on ttrss_feeds (feed_url & owner_uid)Andrew Dolgov
2019-03-06update mysql 136 scriptAndrew Dolgov
2019-03-06some dbupdater improvements; fix schema 136 syntax for mysqlAndrew Dolgov
2019-03-06archived feeds: expire old entries (schema bump)Andrew Dolgov
2018-12-06add ttrss_filters2.last_triggered (bump schema version)Andrew Dolgov
2018-04-14change filter rule regexp type to textfoobar
2017-11-30add ttrss_feeds.last_unconditional (schema bump)Andrew Dolgov
2017-08-17add support for http 304 not modified (no timestamp calculation bullshit ↵Andrew Dolgov
like last time)
2017-07-02schema: updates for new filter format (bump version to 131)Andrew Dolgov
2016-08-17update schema 128 to properly set ttrss_feeds.last_updated default value to NULLAndrew Dolgov
2016-05-13remove .htaccess filesAndrew Dolgov
2015-11-18fix ttrss_feeds.last_update defaulting to 0 on mysql, set to null insteadAndrew Dolgov
bump schema
2015-08-11add plugin-based filter actions (see example plugin in attic)Andrew Dolgov
bump schema
2015-08-04implement per-feed stemming language settingAndrew Dolgov
2015-08-04more fts stuff for simple indexAndrew Dolgov
2015-04-18schema: remove obsolete releases.rss feedAndrew Dolgov
2015-02-20Revert "pgsql schema: remove unnecessary named indexes"Andrew Dolgov
This reverts commit c9bcda546999947145cfff6e4e88ba9f4f348f88.
2015-02-20pgsql schema: remove unnecessary named indexesAndrew Dolgov
2015-02-20mysql: remove some more unneeded manual index()es from table create scriptsAndrew Dolgov
2015-02-20migration: remove mandatory index drops from 127 because of potential fatal ↵Andrew Dolgov
errors; remove unnecessary named indexes from mysql schema for fields with foreign key constraints (mysql should create indexes automatically on table creation for those fields)
2014-12-18Drop duplicate database indexesAnders Kaseorg
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 <[email protected]>
2014-07-15Update schema for size support of enclosuresFelix Eckhofer
2014-04-16mysql schema: remove theme_id index pointing nowhereAndrew Dolgov
2014-04-06bump schema version to fix resetpass_token created as a wrong type in 124Andrew Dolgov
2014-04-06Fix mysql update 124 data type for resetpass_tokenAnders Larsson
Currently mysql schema update 124 sets resetpass_token type to boolean instead of VARCHAR(250). This prevents reset password functionality from working correctly.
2014-04-03Fix: remove obsolete theme_id columnLuca Santarelli
The theme_id column was removed in schema version 83 update script, but not in the initialization one.
2014-03-09schema: add resetpass_token (bump schema)Andrew Dolgov
2013-09-17add update script to convert myisam tables to innodb (bump version)Andrew Dolgov
2013-09-10specify engine=innodb for all tt-rss tablesAndrew Dolgov
2013-07-31add text_languagedetect to guess article language for better hyphenationAndrew Dolgov
(bump schema)
2013-05-30switch AUTO_ASSIGN_LABELS to off by default (bump schema)Andrew Dolgov
2013-05-28schema: fix reinitialization not working for older databasesAndrew Dolgov
2013-04-29remove language selector from the login form, store language in the database ↵Andrew Dolgov
per-user
2013-04-26set default timezone to automatic (bump schema)Andrew Dolgov
2013-04-16experimental SQL-based error loggerAndrew Dolgov
2013-04-15add schema version 177 upgrade scriptsAndrew Dolgov
2013-04-15fix schema for favicon_avg_colorAndrew Dolgov