20181218-081540-create-demo-person.sql

-- Migration Script

BEGIN TRANSACTION

CREATE TABLE [Demo].[Person](
   [PersonId] UNIQUEIDENTIFIER NOT NULL DEFAULT (NEWSEQUENTIALID()) PRIMARY KEY,
   [FirstName] NVARCHAR(50) NULL,
   [LastName] NVARCHAR(50) NULL,
   [Birthday] DATE NULL,
   [GenderId] UNIQUEIDENTIFIER NULL,
   [Street] NVARCHAR(100) NULL,
   [City] NVARCHAR(100) NULL,
   [RowVersion] TIMESTAMP NOT NULL,
   [CreatedBy] NVARCHAR(250) NULL,
   [CreatedDate] DATETIME2 NULL,
   [UpdatedBy] NVARCHAR(250) NULL,
   [UpdatedDate] DATETIME2 NULL,
)
	
COMMIT TRANSACTION