/******************************************************************************/ 
 /****              Generated by IBExpert 15.12.2003 14:26:10               ****/ 
 /******************************************************************************/ 

SET NAMES WIN1251;



 /******************************************************************************/ 
 /****                                Tables                                ****/ 
 /******************************************************************************/ 

CREATE TABLE REPORTS (
    IND        SMALLINT NOT NULL,
    TYPEIND    SMALLINT,
    NAME       VARCHAR( 250 ),
    SHABLON    VARCHAR( 250 ),
    DIALOGWIN  CHAR( 8 ),
    DIALOGSQL  VARCHAR( 250 )
);





 /******************************************************************************/ 
 /****                             Primary Keys                             ****/ 
 /******************************************************************************/ 

ALTER TABLE REPORTS ADD CONSTRAINT PK_REPORTS PRIMARY KEY (IND);


 /******************************************************************************/ 
 /****                             Foreign Keys                             ****/ 
 /******************************************************************************/ 

ALTER TABLE REPORTS ADD CONSTRAINT FK_REPORTS_TYPEREP_TYPES FOREIGN KEY (TYPEIND) REFERENCES TYPES (IND);


 /******************************************************************************/ 
 /****                               Triggers                               ****/ 
 /******************************************************************************/ 


SET TERM ^ ;




 /* Trigger: DEL_REPORT */ 
CREATE TRIGGER DEL_REPORT FOR REPORTS
ACTIVE BEFORE DELETE POSITION  0 
as
begin
  delete from gr_report where (RepInd=old.Ind);
  delete from querys  where (Ind=old.Ind);
end
^

 /* Trigger: Z_REPORTS_1 */ 
CREATE TRIGGER Z_REPORTS_1 FOR REPORTS
ACTIVE AFTER INSERT POSITION  0 
as
declare variable a1 smallint;
declare variable a2 varchar( 250 );
declare variable a3 varchar( 250 );
declare variable a4 char( 8 );
declare variable a5 varchar( 250 );
begin
  a1=new.TypeInd;
  a2=new.Name;
  a3=new.Shablon;
  a4=new.DialogWin;
  a5=new.DialogSQL;
  insert into z_reports values ( 1 ,New.Ind,:a1,:a2,:a3,:a4,:a5);
end
^

 /* Trigger: Z_REPORTS_2 */ 
CREATE TRIGGER Z_REPORTS_2 FOR REPORTS
ACTIVE AFTER UPDATE POSITION  0 
as
declare variable a1 smallint;
declare variable a2 varchar( 250 );
declare variable a3 varchar( 250 );
declare variable a4 char( 8 );
declare variable a5 varchar( 250 );
begin
  a1=new.TypeInd;
  a2=new.Name;
  a3=new.Shablon;
  a4=new.DialogWin;
  a5=new.DialogSQL;
  delete from z_reports where  (A= 2 ) and (Ind=old.Ind);
  insert into z_reports values ( 2 ,old.Ind,:a1,:a2,:a3,:a4,:a5);
end
^

 /* Trigger: Z_REPORTS_3 */ 
CREATE TRIGGER Z_REPORTS_3 FOR REPORTS
ACTIVE AFTER DELETE POSITION  0 
as
begin
  delete from z_reports where  (Ind=old.Ind); 
  insert into z_reports values ( 3 ,old.Ind, 0 , " " , " " , " " , " " );
end
^


SET TERM ; ^


 /******************************************************************************/ 
 /****                              Privileges                              ****/ 
 /******************************************************************************/