KCI-KANBAN/db/migrations/20260422100000_create_boards.asp

<%
'=======================================================================================================================
' MIGRATION: create_boards
'=======================================================================================================================

Sub Migration_Up(migration)
    migration.ExecuteSQL _
        "CREATE TABLE [boards] (" & _
        "[id] AUTOINCREMENT PRIMARY KEY, " & _
        "[name] VARCHAR(255) NOT NULL, " & _
        "[slug] VARCHAR(255) NOT NULL, " & _
        "[created_at] DATETIME, " & _
        "[created_by] VARCHAR(255), " & _
        "[updated_at] DATETIME, " & _
        "[updated_by] VARCHAR(255)" & _
        ")"

    migration.ExecuteSQL "CREATE INDEX [idx_boards_slug] ON [boards] ([slug])"
End Sub

Sub Migration_Down(migration)
    migration.ExecuteSQL "DROP TABLE [boards]"
End Sub
%>