Andrew Dolgov
5eb0f3d640
bring back web dbupdate using new migrations system
3 years ago
Andrew Dolgov
c0fb0a5ec0
wip for db_migrations for core schema
3 years ago
Andrew Dolgov
c1cd3324e3
bump schema for ttrss_user_labels2 indexes
3 years ago
Andrew Dolgov
00d0cb8c81
remove unused data from schema files
3 years ago
Andrew Dolgov
1112922029
bump schema for upcoming prefs overhaul
3 years ago
Andrew Dolgov
de22464ea8
schema: add ttrss_feeds.last_successful_update
4 years ago
Andrew Dolgov
60609637bc
schema: when inserting initial forum feed, don't hardcode admin UID as 1
5 years ago
Andrew Dolgov
17e145f481
revise schema 139 to use engine=innodb
5 years ago
Andrew Dolgov
b158103f2f
schema: add missing stuff
5 years ago
Andrew Dolgov
84e9f1d5cc
update schema for app-specific passwords
5 years ago
Andrew Dolgov
9e200f2cf0
schema: update version to 138
5 years ago
Andrew Dolgov
6768b3a4a3
schema: add DEFAULT_SEARCH_LANGUAGE
5 years ago
Andrew Dolgov
08183fcd27
set key length to 255 on mysql
5 years ago
Andrew Dolgov
32f9fda33d
add composite key on ttrss_feeds (feed_url & owner_uid)
5 years ago
Andrew Dolgov
c8fc9eee0c
update mysql 136 script
5 years ago
Andrew Dolgov
0881d0a00d
some dbupdater improvements; fix schema 136 syntax for mysql
5 years ago
Andrew Dolgov
38e01270d8
archived feeds: expire old entries (schema bump)
5 years ago
Andrew Dolgov
3e4326e34d
add ttrss_filters2.last_triggered (bump schema version)
5 years ago
foobar
2008ec4ed7
change filter rule regexp type to text
6 years ago
Andrew Dolgov
ecd2e414bd
add ttrss_feeds.last_unconditional (schema bump)
7 years ago
Andrew Dolgov
153cb6d305
add support for http 304 not modified (no timestamp calculation bullshit like last time)
7 years ago
Andrew Dolgov
10a1f28f7c
schema: updates for new filter format (bump version to 131)
7 years ago
Andrew Dolgov
539f6ee6cd
update schema 128 to properly set ttrss_feeds.last_updated default value to NULL
8 years ago
Andrew Dolgov
aa4ab8e0bc
remove .htaccess files
8 years ago
Andrew Dolgov
6497fb65b4
fix ttrss_feeds.last_update defaulting to 0 on mysql, set to null instead
...
bump schema
9 years ago
Andrew Dolgov
b87744534a
add plugin-based filter actions (see example plugin in attic)
...
bump schema
9 years ago
Andrew Dolgov
df659891ac
implement per-feed stemming language setting
9 years ago
Andrew Dolgov
e854442e1f
more fts stuff for simple index
9 years ago
Andrew Dolgov
6d204cd131
schema: remove obsolete releases.rss feed
9 years ago
Andrew Dolgov
1103172909
Revert "pgsql schema: remove unnecessary named indexes"
...
This reverts commit c9bcda5469
.
9 years ago
Andrew Dolgov
c9bcda5469
pgsql schema: remove unnecessary named indexes
9 years ago
Andrew Dolgov
5cbc1c7469
mysql: remove some more unneeded manual index()es from table create scripts
9 years ago
Andrew Dolgov
89e31b9d4e
migration: remove mandatory index drops from 127 because of potential fatal 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)
9 years ago
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>
10 years ago
Felix Eckhofer
06c4c9ebae
Update schema for size support of enclosures
10 years ago
Andrew Dolgov
532e1afeea
mysql schema: remove theme_id index pointing nowhere
10 years ago
Andrew Dolgov
8067dc8ca5
bump schema version to fix resetpass_token created as a wrong type in 124
10 years ago
Anders Larsson
44a45a6351
Fix mysql update 124 data type for resetpass_token
...
Currently mysql schema update 124 sets resetpass_token type to boolean
instead of VARCHAR(250). This prevents reset password functionality from
working correctly.
10 years ago
Luca Santarelli
15a365a882
Fix: remove obsolete theme_id column
...
The theme_id column was removed in schema version 83 update script, but not in the initialization one.
10 years ago
Andrew Dolgov
3b19a53acf
schema: add resetpass_token (bump schema)
10 years ago
Andrew Dolgov
e596b5a9dd
add update script to convert myisam tables to innodb (bump version)
11 years ago
Andrew Dolgov
4df07d50b1
specify engine=innodb for all tt-rss tables
11 years ago
Andrew Dolgov
6b4617970f
add text_languagedetect to guess article language for better hyphenation
...
(bump schema)
11 years ago
Andrew Dolgov
2457679aed
switch AUTO_ASSIGN_LABELS to off by default (bump schema)
11 years ago
Andrew Dolgov
5ddc750427
schema: fix reinitialization not working for older databases
11 years ago
Andrew Dolgov
7b149552cb
remove language selector from the login form, store language in the database per-user
11 years ago
Andrew Dolgov
3fbb4d183d
set default timezone to automatic (bump schema)
11 years ago
Andrew Dolgov
889a5f9f19
experimental SQL-based error logger
11 years ago
Andrew Dolgov
646aeb7001
add schema version 177 upgrade scripts
11 years ago
Andrew Dolgov
14118af36f
fix schema for favicon_avg_color
11 years ago