if (Exists (Select Table_name from SysTable where Table_name='SpaOtcheti')) then
  Drop Table SpaOtcheti
end if

GO

CREATE TABLE "DBA"."SpaOtcheti"
(
	"OtchetNo"      		integer NOT NULL ,
	"OtchetDate"    		integer NOT NULL ,
	"FromInvoiceNo" 		integer NOT NULL ,
	"ToInvoiceNo"   		integer NOT NULL ,
	"FromDepositNo" 		integer NOT NULL ,
	"ToDepositNo"   		integer NOT NULL ,
	"KodAdmin"      		integer NOT NULL ,
	"OtchetDateDt"  		date NULL ,
	 PRIMARY KEY ("OtchetNo"),

)

GO

if (select count(*) from SYSINDEX where index_name='IND_Otchet_N')=1 then

      DROP INDEX "IND_Otchet_N"
end if

GO

CREATE UNIQUE INDEX "IND_Otchet_N" ON "DBA"."SpaOtcheti"
(
	"OtchetNo" ASC
)

GO

if exists (select * from SYSTRIGGERS where LCase(trigname)=lcase('TrigOtchetiUpd'))
  then
  drop trigger TrigOtchetiUpd
end if

GO


CREATE TRIGGER "TrigOtchetiUpd" after insert,update order 1
on "DBA".SpaOtcheti
referencing new as OtchetiNew
for each row
begin
  update SpaOtcheti set OtchetDateDt=FloatToDate(OtchetDate)
    where OtchetNo=OtchetiNew.OtchetNo
end