Prospecting/db/migrations/20261025120001_create_areas_tables.asp

<%
'=======================================================================================================================
' MIGRATION: create_areas_tables
' Areas (cities, regions...) a business covers. A business can cover several areas, so the link is its own table.
'=======================================================================================================================

Sub Migration_Up(migration)
    migration.CreateTable "areas", "id AUTOINCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL"
    migration.ExecuteSQL "CREATE UNIQUE INDEX uq_areas_name ON areas (name)"
    migration.CreateTable "business_areas", "business_id LONG NOT NULL, area_id LONG NOT NULL"
    migration.ExecuteSQL "CREATE UNIQUE INDEX uq_business_areas ON business_areas (business_id, area_id)"
    migration.CreateIndex "ix_business_areas_area_id", "business_areas", "area_id"
End Sub

Sub Migration_Down(migration)
    migration.DropTable "business_areas"
    migration.DropTable "areas"
End Sub
%>