tracking_kits/Data/Migrations/Migration_18_Create_CustomOfficeCopyJob_Table.asp

<%
Class Migration_18_Create_CustomOfficeCopyJob_Table
    Public Migration

    Public Sub Up
        Migration.Do "CREATE TABLE [CustomOfficeCopyJob] (" &_
                    "[ID] COUNTER," &_
                    "[Jcode] VARCHAR(15)," &_
                    "[Precinct] VARCHAR(20)," &_ 
                    "[StartingBallotNumber] LONG," &_
                    "[Amount] LONG," &_
                    "[Status] VARCHAR(100)," &_
                    "[Donedate] DATETIME" &_
                    ");"
        Migration.Do "CREATE UNIQUE INDEX [ID] ON [CustomOfficeCopyJob]( [ID] ) WITH PRIMARY;"
End Sub
    
    Public Sub Down
        Migration.Do "DROP TABLE [CustomOfficeCopyJob]"
    End Sub
End Class
 Migrations.Add "Migration_18_Create_CustomOfficeCopyJob_Table"
 %>