use [EnVisage] BEGIN TRANSACTION GO ALTER TABLE dbo.AspNetUsers ADD Phone nvarchar(20) NULL GO ALTER TABLE dbo.AspNetUsers ADD Type smallint NOT NULL DEFAULT(0) GO update dbo.AspNetUsers set type = 1 where UserName = 'admin' COMMIT