<%
'=======================================================================================================================
' MIGRATION: create_cards
'=======================================================================================================================

Sub Migration_Up(migration)
    migration.ExecuteSQL _
        "CREATE TABLE [cards] (" & _
        "[id] AUTOINCREMENT PRIMARY KEY, " & _
        "[board_id] INTEGER NOT NULL, " & _
        "[column_id] INTEGER NOT NULL, " & _
        "[swim_lane_id] INTEGER NOT NULL, " & _
        "[job_number] VARCHAR(255), " & _
        "[job_name] VARCHAR(255), " & _
        "[position] INTEGER NOT NULL, " & _
        "[created_at] DATETIME, " & _
        "[created_by] VARCHAR(255), " & _
        "[updated_at] DATETIME, " & _
        "[updated_by] VARCHAR(255)" & _
        ")"

    migration.ExecuteSQL "CREATE INDEX [idx_cards_board_id]     ON [cards] ([board_id])"
    migration.ExecuteSQL "CREATE INDEX [idx_cards_column_id]    ON [cards] ([column_id])"
    migration.ExecuteSQL "CREATE INDEX [idx_cards_swim_lane_id] ON [cards] ([swim_lane_id])"
End Sub

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