Prospecting/db/migrations/20261023160001_create_industries_table.asp

<%
'=======================================================================================================================
' MIGRATION: create_industries_table
'=======================================================================================================================

Sub Migration_Up(migration)
    migration.CreateTable "industries", "id AUTOINCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL"
    migration.ExecuteSQL "CREATE UNIQUE INDEX uq_industries_name ON industries (name)"
End Sub

Sub Migration_Down(migration)
    migration.DropTable "industries"
End Sub
%>