KCI-KANBAN/db/migrations/20260424100000_add_printstream_fields_to_cards.asp

<%
'=======================================================================================================================
' MIGRATION: add_printstream_fields_to_cards
'=======================================================================================================================

Sub Migration_Up(migration)
    migration.ExecuteSQL "ALTER TABLE [cards] ADD COLUMN [customer_name] VARCHAR(255)"
    migration.ExecuteSQL "ALTER TABLE [cards] ADD COLUMN [delivery_date] DATETIME"
    migration.ExecuteSQL "ALTER TABLE [cards] ADD COLUMN [quantity] VARCHAR(50)"
    migration.ExecuteSQL "ALTER TABLE [cards] ADD COLUMN [notes] MEMO"
End Sub

Sub Migration_Down(migration)
    migration.ExecuteSQL "ALTER TABLE [cards] DROP COLUMN [notes]"
    migration.ExecuteSQL "ALTER TABLE [cards] DROP COLUMN [quantity]"
    migration.ExecuteSQL "ALTER TABLE [cards] DROP COLUMN [delivery_date]"
    migration.ExecuteSQL "ALTER TABLE [cards] DROP COLUMN [customer_name]"
End Sub
%>