Commit Graph

19 Commits (main)

Author SHA1 Message Date
Johnny 0f3c9a467d refactor: migrate HOST roles to ADMIN
- Updated the isSuperUser function to only check for ADMIN role.
- Added SQL migration scripts for MySQL, PostgreSQL, and SQLite to change user roles from HOST to ADMIN.
- Created a new SQLite migration to alter the user table structure and ensure data integrity during the migration process.
14 hours ago
Johnny 1985205dc2 chore: remove memo_organizer table 2 weeks ago
Johnny 14fb38f375 fix: attachment table name 2 weeks ago
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
2 weeks ago
Johnny d326c71078 refactor(db): rename tables for clarity - resource→attachment, system_setting→instance_setting 2 weeks ago
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>
2 months ago
Steven 6e1b01cb68 chore: bump version 7 months ago
johnnyjoy 0af08d9c06 chore: add if exists to postgres 12 months ago
johnnyjoy b0119f320a chore: tweak migration scripts 12 months ago
johnnyjoy 9bd6d17864 chore: add migration script 12 months ago
johnnyjoy 39d4d4f4f3 chore: update migrate scripts 12 months ago
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>
1 year ago
johnnyjoy 80785de900 chore: remove unused script 1 year ago
Steven d066d46f6e chore: tweak schema version 1 year ago
Steven e527b6a878 feat: move reaction type to setting 1 year ago
Leo 95939ebcf1
fix: v0.22.5: start fail caused by incorrect migration file naming (#3873)
fix incorrect naming of migration file
1 year ago
Steven fa2b01cfb1 chore: tweak latest schema file name 1 year ago
Steven ccd3fdcd38 chore: fix tests 1 year ago
Steven 6e901fc940 refactor: store migrator 1 year ago