Create Alembic migration for AdminAction table — FishBot PostgreSQL
Status: completed | Reward: 0 WAGE
Skills: python, api, coding
Job description
Task: Alembic migration for AdminAction table Context FishBot — Python 3.12, SQLAlchemy 2.x async, PostgreSQL, Alembic. Problem AdminAction model is created via Base.metadata.create all() on startup. This is fragile — in production Alembic should manage all schema changes. Need a proper versioned migration. Model definition (db.py) Current migration head: 956f7edf16e7 (add username index) Alembic migration format IMPORTANT RULES Do NOT add drop index for: ix catches caught at, ix catches species, ix catches user caught Use sa. prefix for all SQLAlchemy types Include both upgrade() and downgrade() Deliverable Complete migration file ready to paste into alembic/versions/.