{sequence}_{domain}_{action}.{ext}

01_schema.my.hcl                          # Base schema definition
02_lookup.my.hcl                          # Lookup/enum tables
03_registration_preseed_master.my.hcl     # Merchant & branch setup
04_master_data_import.my.hcl              # Master data tables
05_transactional.my.hcl                   # Transaction tables
06_approval_flow.my.hcl                   # Approval workflow
07_inventory_flow.my.hcl                  # Inventory management
08_promotions.my.hcl                      # Promotions & discounts
09_offline_first.my.hcl                   # Offline sync tables
97_accounting_flow.my.hcl                 # Accounting & GL
98_ai_integration.my.hcl                  # AI features
99_archive_data.my.hcl                    # Archive & history

// 10_new_feature.my.hcl
table "feature_configs" {
  schema = schema."mstore-monolith"
  
  column "id" {
    null           = false
    type           = bigint
    unsigned       = true
    auto_increment = true
  }
  
  column "merchant_id" {
    null     = false
    type     = bigint
    unsigned = true
  }
  
  column "config_key" {
    null = false
    type = varchar(128)
  }
  
  column "config_value" {
    null = false
    type = text
  }
  
  column "created_at" {
    null    = true
    type    = timestamp
    default = sql("CURRENT_TIMESTAMP")
  }
  
  primary_key {
    columns = [column.id]
  }
  
  index "merchant_config_key" {
    unique  = true
    columns = [column.merchant_id, column.config_key]
  }
  
  foreign_key "merchant_fk" {
    columns     = [column.merchant_id]
    ref_columns = [table.merchants.column.id]
    on_delete   = CASCADE
  }
}

# Dry run (preview changes)
atlas migrate diff --env local

# Apply migration
atlas migrate apply --env local

# Apply to specific environment
atlas migrate apply --env staging

flyway migrate

-- Check table structure
DESCRIBE feature_configs;

-- Check indexes
SHOW INDEXES FROM feature_configs;

-- Check constraints
SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE 
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS 
WHERE TABLE_NAME = 'feature_configs';

# Revert last migration
atlas migrate down --env local

# Revert to specific version
atlas migrate down --env local --target-version {version}

-- Restore to specific timestamp
RESTORE DATABASE mstore-monolith 
  FROM BACKUP 'backup_2025_12_17' 
  TO POINT IN TIME '2025-12-17 14:30:00';