Commit graph

23 commits

Author SHA1 Message Date
Johnny
af6a0726d8 chore: drop redundant indexes in sqlite migration 2026-01-08 22:53:46 +08:00
Johnny
1985205dc2 chore: remove memo_organizer table 2026-01-08 22:28:13 +08:00
Johnny
14fb38f375 fix: attachment table name 2026-01-07 20:44:21 +08:00
Johnny
cc9a214be8 revert: revert system_setting to instance_setting rename changes
Reverts only the system_setting → instance_setting rename related changes from commit d326c71.
Keeps the resource → attachment rename changes intact.

- Reverts table name back to system_setting in all database drivers (MySQL, PostgreSQL, SQLite)
- Removes migration files for the system_setting rename
- Reverts LATEST.sql files to use system_setting table
2026-01-07 20:38:02 +08:00
Johnny
d326c71078 refactor(db): rename tables for clarity - resource→attachment, system_setting→instance_setting 2026-01-06 23:36:42 +08:00
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
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
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
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
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