J. King
4b3cfba495
Abandon the new marking method
It was less accurate and turned out to be more complex rather than less.
1 year ago
J. King
2c9daedb14
Add provision for soft deletion of subscriptions
2 years ago
J. King
15a2e7fe0f
Actually-last tests for schema upgrade
2 years ago
J. King
95d20f33c7
Last tests for schema upgrade
2 years ago
J. King
63e780b06d
Tests for articles, with fixes
Related tables (categories, enclosures, label members) still need tests
2 years ago
J. King
48accdfad8
Fix subs in the new MySQL schema
2 years ago
J. King
fc2428713a
Fix remaining MySQL schema problems
2 years ago
J. King
e4a7e6622b
Fix most problems with the new schema
Some issues remain with MySQL
2 years ago
J. King
bd728e3e12
New schema for MySQL
2 years ago
J. King
86897af0b3
Add ability to enable scraper
Also transfer any existing scraper booleans on database upgrade. It was
previously possible to enable scraping manually by editing the database,
and these settings will be honoured.
3 years ago
J. King
4cb23dd198
Partial implementation of proper content scraping
3 years ago
J. King
d5cd5b6a17
Implement hidden marks
Tests are still needed
4 years ago
J. King
c43d0dcae3
Groundwork for filtering rules
4 years ago
J. King
5c83655541
Add modification timestamp to user metadata
4 years ago
J. King
a431243421
Fixes for MySQL and PostgreSQL
4 years ago
J. King
978929aabd
WIP redesign of user properties
4 years ago
J. King
e861cca53d
Integrate schema change necessary for microsub
4 years ago
J. King
8f739cec85
Excluse empty-string URLs from icons table
4 years ago
J. King
2438f35f3d
Add icon cache to database
Feed updating has not yet been adapted to store
icon data (nor their URLs anymore)
4 years ago
J. King
905f8938e2
Typo
4 years ago
J. King
16d2e01668
New schema for PostgreSQL and MySQL
4 years ago
J. King
b58a326461
Prepare for schema changes
4 years ago
J. King
794fb506a5
Widen URL field
5 years ago
J. King
484510cf8c
Expand text fields other than user id and feed URL
5 years ago
J. King
f4b08170bf
Fix MySQL schema
5 years ago
J. King
568e6e4660
Delete dangling MySQL records when updating
MySQL seems to reject queries involving arsse_folders.parent and
arsse_subscription.folder, though they appear to be valid. More testing
is required.
5 years ago
J. King
737dd9f6b8
Fix foreign keys in MySQL
5 years ago
J. King
38bdde1167
Add access tokens to the db, with relevant code
Tokens are similar to sessions in that they stand in for users, but the
protocol handlers will manage them; Fever login hashes are the
originating use case for them. These must never expire, for example,
and we need to specify their values.
This commit also performs a bit of database clean-up
5 years ago
J. King
fb1bdbfb37
Database schema for subscription tags
5 years ago
J. King
393b4e95ad
Adjustments for MySQL 8
The prototype had been tested against MariaDB
6 years ago
J. King
316ba941a2
Hopefully complete MySQL schema
6 years ago
J. King
0f7baf4b51
Base MySQL schema
Note the columns "key" and "read" must be quoted in addition to "user".
6 years ago
