namespace BirdDogSoftware.Core.Persistance

module MigrationList =
    open BirdDogSoftware.Core.Persistance.Migration

    let list = [
        {
            Name = "ProjectManagement"
            Up = fun(m) ->
                m.Create.Table("BDProjects2")
                    .WithColumn("ID").AsGuid()
                    .WithColumn("ID").AsGuid()
                    .WithColumn("ShortID").AsInt64()
                    .WithColumn("Name").AsString()
                    .WithColumn("Status").AsInt32()
                    .WithColumn("ContactID").AsGuid()
                    .WithColumn("DateCreated").AsDate()
                    .WithColumn("DueDate").AsDate()
                    .WithColumn("Priority").AsString()
                    .WithColumn("CompletionDate").AsDate()
                    .WithColumn("Notes").AsString()
                    .WithColumn("ParentProjectID").AsGuid()
                |> ignore
            Down = fun(m) ->
                m.Delete.Table("BDProjects2")
                |> ignore
        }
    ]