IF (EXISTS (select Table_name from SysTable where LCase(Table_name)=LCase('ServicesPeriod'))) THEN
   Drop Table ServicesPeriod
END IF
GO

CREATE TABLE ServicesPeriod
(
	"id"    			integer NOT NULL DEFAULT autoincrement ,
	"name"  			varchar(100) NOT NULL ,
	"stoinost"      		integer NOT NULL DEFAULT 0 , 
	 PRIMARY KEY ("id"),
	
)
go

ALTER TABLE "DBA"."ServicesPeriod" ADD  UNIQUE 
(
	"id"
)
Go

if (select count(*) from Registers where lcase(RegisterName)=lcase('ShowAutoServices'))=0 then
    insert into Registers(RegisterName,IntStojnost,Komentar) 
	values('ShowAutoServices',0,'Показва меню автоматични услуги');
end if;
GO

if (select count(*) from HotelOptions where lcase(OptionName)=lcase('FirmBankCode'))=0 then
    insert into HotelOptions(OptionName,Stoinost,BulgName)
	values('FirmBankCode','','Банков код на фирмата');
end if;