EnVisageOnline/Beta/Database/Scripts/20140903/Status.sql

11 lines
412 B
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

use [EnVisage]
BEGIN TRANSACTION
ALTER TABLE dbo.Status ADD
IsSystem bit NOT NULL CONSTRAINT DF_Status_IsSystem DEFAULT 0
GO
update dbo.Status set IsSystem = 1 where name = 'system'
GO
COMMIT