|
use EnVisage
|
|
|
|
if not exists (select 1 from sys.all_columns where name like 'IsTemplate' and object_id = OBJECT_ID('Project'))
|
|
begin
|
|
alter table Project
|
|
add IsTemplate bit
|
|
CONSTRAINT templatedefault DEFAULT(0) NOT NULL
|
|
alter table Project
|
|
drop CONSTRAINT templatedefault
|
|
end
|