if (select count(*) from sys.syscolumns where tname='Registers' and cname='SpaFromHour')=0 then

alter table Registers
Add SpaFromHour integer default 8

end if

GO

if (select count(*) from Registers where RegisterName='SpaFromHour')=0 then

insert into Registers(RegisterName,IntStojnost,Komentar) values('SpaFromHour',8,'');

end if

GO

if (select count(*) from sys.syscolumns where tname='Registers' and cname='SpaFromMin')=0 then

alter table Registers
Add SpaFromMin integer default 0

end if

GO

if (select count(*) from Registers where RegisterName='SpaFromMin')=0 then

insert into Registers(RegisterName,IntStojnost,Komentar) values('SpaFromMin',0,'');

end if

GO

if (select count(*) from sys.syscolumns where tname='Registers' and cname='SpaToHour')=0 then

alter table Registers
Add SpaToHour integer default 20

end if

GO

if (select count(*) from Registers where RegisterName='SpaToHour')=0 then

insert into Registers(RegisterName,IntStojnost,Komentar) values('SpaToHour',20,'');

end if

GO

if (select count(*) from sys.syscolumns where tname='Registers' and cname='SpaToMin')=0 then

alter table Registers
Add SpaToMin integer default 0

end if

GO

if (select count(*) from Registers where RegisterName='SpaToMin')=0 then

insert into Registers(RegisterName,IntStojnost,Komentar) values('SpaToMin',0,'');

end if