1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
| Imports System
Imports System.Data.Entity.Migrations
Namespace Migrations
Public Partial Class DataAnnotations
Inherits DbMigration
Public Overrides Sub Up()
AddColumn("dbo.Articles", "ArticleID", Function(c) c.Int(nullable := False, identity := True))
AddColumn("dbo.Articles", "ArticleName", Function(c) c.String())
AddColumn("dbo.Articles", "ArticlePrice", Function(c) c.Int(nullable := False))
DropPrimaryKey("dbo.Articles", New String() { "ItemId" })
AddPrimaryKey("dbo.Articles", "ArticleID")
DropColumn("dbo.Articles", "ItemId")
DropColumn("dbo.Articles", "ItemName")
DropColumn("dbo.Articles", "THBPriceStore")
DropColumn("dbo.Articles", "THBPriceStaff")
DropColumn("dbo.Articles", "USDPriceOnline")
DropColumn("dbo.Articles", "Stock")
DropColumn("dbo.Articles", "ItemVisble")
DropColumn("dbo.Articles", "EmailSent")
End Sub
Public Overrides Sub Down()
AddColumn("dbo.Articles", "EmailSent", Function(c) c.Boolean(nullable := False))
AddColumn("dbo.Articles", "ItemVisble", Function(c) c.Boolean(nullable := False))
AddColumn("dbo.Articles", "Stock", Function(c) c.Int(nullable := False))
AddColumn("dbo.Articles", "USDPriceOnline", Function(c) c.Int(nullable := False))
AddColumn("dbo.Articles", "THBPriceStaff", Function(c) c.Int(nullable := False))
AddColumn("dbo.Articles", "THBPriceStore", Function(c) c.Int(nullable := False))
AddColumn("dbo.Articles", "ItemName", Function(c) c.String(nullable := False))
AddColumn("dbo.Articles", "ItemId", Function(c) c.Int(nullable := False, identity := True))
DropPrimaryKey("dbo.Articles", New String() { "ArticleID" })
AddPrimaryKey("dbo.Articles", "ItemId")
DropColumn("dbo.Articles", "ArticlePrice")
DropColumn("dbo.Articles", "ArticleName")
DropColumn("dbo.Articles", "ArticleID")
End Sub
End Class
End Namespace |
Partager