Commit Graph

35 Commits

Author SHA1 Message Date
Steven 0610257562 refactor(store): remove deprecated migration_history table and backward compatibility code
Complete removal of migration_history system in favor of instance_setting based schema versioning.

Changes:
- Remove migration_history table creation from all LATEST.sql files
- Delete all migration_history model and implementation files (~300 lines)
- Remove FindMigrationHistoryList and UpsertMigrationHistory from Driver interface
- Replace complex backward compatibility functions with simple version check
- Update health check to use instance_setting instead of migration_history
- Simplify checkMinimumUpgradeVersion to detect pre-v0.22 installations

Breaking change:
Users on versions < v0.22.0 (May 2024) must upgrade to v0.25.x first before upgrading to this version.
Clear error message with upgrade instructions will be shown for old installations.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-12-01 22:54:30 +08:00
Steven 0398df1d21 chore: update migrator comments 2025-07-16 21:59:37 +08:00
Steven 6e1b01cb68 chore: bump version 2025-06-24 23:06:57 +08:00
Johnny 9299c216e2 chore: move migration to 0.24.0 2025-02-16 21:02:18 +08:00
Chris Dzombak d25f355392
chore: allow storing resource references >256 chars long in mysql (#4408)
fix: allow storing resource references >256 chars long in mysql
2025-02-16 18:20:51 +08:00
wzc90 3f33ccd906
fix: update 01__memo_pinned.sql (#4370) 2025-02-06 09:08:31 +08:00
Steven 7996586488 chore: fix migration script for sqlite 2025-02-05 20:56:46 +08:00
johnnyjoy bf5a29524a chore: remove drop index 2025-02-03 11:45:15 +08:00
johnnyjoy 0af08d9c06 chore: add if exists to postgres 2025-02-02 13:19:56 +08:00
Xiao Wei 37a81f9d28
fix: migrate sql error (#4338)
* fix: migrate sql error

sqlite not support postgres sql

* Apply suggestions from code review

---------

Co-authored-by: Johnny <yourselfhosted@gmail.com>
2025-02-01 22:11:17 +08:00
johnnyjoy b0119f320a chore: tweak migration scripts 2025-02-01 11:19:36 +08:00
johnnyjoy 9bd6d17864 chore: add migration script 2025-01-31 22:00:05 +08:00
johnnyjoy 39d4d4f4f3 chore: update migrate scripts 2025-01-31 21:05:20 +08:00
johnnyjoy d605faeffa refactor: move pinned to memo 2025-01-31 20:58:18 +08:00
Zero King 5ec3150e0e
fix: use correct separator in migration file name (#4327)
Fixes: e913271f15 ("refactor: move tags from property to payload (#4229)")
2025-01-30 12:26:14 +08:00
Johnny e913271f15
refactor: move tags from property to payload (#4229)
* refactor: move tags from property to payload

* chore: fix tests

* chore: drop memo tags

* chore: update

---------

Co-authored-by: Steven <stevenlgtm@gmail.com>
2024-12-24 15:23:15 +00:00
Steven 51c80c37d1 revert: tweak reaction_type column type for mysql 2024-11-20 20:37:35 +08:00
Steven 9f2c1b2556 chore: tweak reaction_type column type for mysql 2024-11-20 20:35:03 +08:00
johnnyjoy 80785de900 chore: remove unused script 2024-11-14 22:12:00 +08:00
Steven d066d46f6e chore: tweak schema version 2024-10-10 22:30:46 +08:00
Steven e527b6a878 feat: move reaction type to setting 2024-10-10 21:06:32 +08:00
Leo 95939ebcf1
fix: v0.22.5: start fail caused by incorrect migration file naming (#3873)
fix incorrect naming of migration file
2024-09-04 06:28:55 +08:00
Steven fa2b01cfb1 chore: tweak latest schema file name 2024-09-01 22:11:15 +08:00
Steven ccd3fdcd38 chore: fix tests 2024-08-26 08:59:35 +08:00
Steven 6e901fc940 refactor: store migrator 2024-08-16 08:07:30 +08:00
boojack 8e01eb8702 feat: `store/db` module with sqlite 2022-05-22 00:59:22 +08:00
boojack bc22f69ac5 refactor: raw struct for store 2022-05-19 18:32:04 +08:00
boojack 74ab42069f chore: add service version 2022-05-17 21:21:13 +08:00
boojack c492317ffe feat: member manage section in setting dialog 2022-05-16 22:19:39 +08:00
STEVEN f1cca0f298
feat: add user role field (#49)
* feat: add user role field

* chore: fix typo

* feat: update signup api
2022-05-15 10:57:54 +08:00
boojack b1adaf9c4e update: seed data 2022-05-03 11:49:10 +08:00
boojack 995ec34bf8 feat: pin/unpin memo 2022-05-02 10:57:20 +08:00
boojack 406109b091 update: db initialization 2022-05-01 11:06:29 +08:00
email b3a431570c feat: system api with profiles 2022-03-29 20:53:43 +08:00
email 3c06c68691 chore: update db initial 2022-03-28 23:38:12 +08:00