database-migrations
SKILL.md
Database Migrations
This skill guides you through creating and managing database migrations using golang-migrate following this project's specific patterns.
⚠️ IMPORTANT PROJECT PATTERNS
Table Structure Pattern
-- Standard column order for ALL tables:
CREATE TABLE IF NOT EXISTS table_name (
id VARCHAR(36) PRIMARY KEY, -- ID first, VARCHAR(36) not UUID!
created_at TIMESTAMP NULL, -- Timestamp fields
updated_at TIMESTAMP NULL,
deleted_at TIMESTAMP NULL,