/******************************************************************************/
/****              Generated by IBExpert 27/05/2024 08:46:47               ****/
/******************************************************************************/

/******************************************************************************/
/****     Following SET SQL DIALECT is just for the Database Comparer      ****/
/******************************************************************************/
SET SQL DIALECT 3;



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



CREATE TABLE PDA_CONFIGURATION (
    PDAC_ID              DOM_CLE_PRIMAIRE NOT NULL,
    PDAC_IDSTA           DOM_CLE_EXTERNE,
    PDAC_CONNEXION       DOM_ENTIER,
    PDAC_FONCTIONNEMENT  DOM_ENTIER,
    PDAC_DECONNEXION     DOM_ENTIER
);



/******************************************************************************/
/****                             Primary keys                             ****/
/******************************************************************************/

ALTER TABLE PDA_CONFIGURATION ADD CONSTRAINT PK_PDA_CONFIGURATION PRIMARY KEY (PDAC_ID);


/******************************************************************************/
/****                             Foreign keys                             ****/
/******************************************************************************/

ALTER TABLE PDA_CONFIGURATION ADD CONSTRAINT FK_PDAC_IDSTA FOREIGN KEY (PDAC_IDSTA) REFERENCES STATION (STA_ID) ON DELETE CASCADE ON UPDATE CASCADE;


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



SET TERM ^ ;



/******************************************************************************/
/****                         Triggers for tables                          ****/
/******************************************************************************/



/* Trigger: PDA_CONFIGURATION_BI */
CREATE OR ALTER TRIGGER PDA_CONFIGURATION_BI FOR PDA_CONFIGURATION
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  /* VERSION 0001 (29/01/2024) */

  IF ((NEW.PDAC_ID IS NULL) OR (NEW.PDAC_ID <= 0)) THEN
    NEW.PDAC_ID = NEXT VALUE FOR IDGENERIQUE;
END
^
SET TERM ; ^



/******************************************************************************/
/****                         Fields descriptions                          ****/
/******************************************************************************/

COMMENT ON COLUMN PDA_CONFIGURATION.PDAC_ID IS
'Clé primaire';

COMMENT ON COLUMN PDA_CONFIGURATION.PDAC_IDSTA IS
'ID de la station';

COMMENT ON COLUMN PDA_CONFIGURATION.PDAC_CONNEXION IS
'Type de connexion: 0=connexion locale/wifi, 1=connexion 4G';

COMMENT ON COLUMN PDA_CONFIGURATION.PDAC_FONCTIONNEMENT IS
'Type de fonctionnement: 0=Contrôle seulement, 1=Débit de séances/passages';

COMMENT ON COLUMN PDA_CONFIGURATION.PDAC_DECONNEXION IS
'Nombre de secondes pour la déconnexion 4G';



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


/******************************************************************************/
/****              Generated by IBExpert 27/05/2024 08:47:14               ****/
/******************************************************************************/

/******************************************************************************/
/****     Following SET SQL DIALECT is just for the Database Comparer      ****/
/******************************************************************************/
SET SQL DIALECT 3;



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


CREATE GENERATOR IDGENERIQUE;

CREATE TABLE PDA_CONFIGURATION_DETAIL (
    PCDE_ID      DOM_CLE_EXTERNE,
    PCDE_IDPDAC  DOM_CLE_EXTERNE,
    PCDE_TYPE    DOM_ENTIER,
    PCDE_IDDATA  DOM_CLE_EXTERNE
);



/******************************************************************************/
/****                             Primary keys                             ****/
/******************************************************************************/

ALTER TABLE PDA_CONFIGURATION_DETAIL ADD CONSTRAINT PK_PDA_CONFIGURATION_DETAIL PRIMARY KEY (PCDE_ID);


/******************************************************************************/
/****                             Foreign keys                             ****/
/******************************************************************************/

ALTER TABLE PDA_CONFIGURATION_DETAIL ADD CONSTRAINT FK_PCDE_IDPDAC FOREIGN KEY (PCDE_IDPDAC) REFERENCES PDA_CONFIGURATION (PDAC_ID) ON DELETE CASCADE ON UPDATE CASCADE;


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



SET TERM ^ ;



/******************************************************************************/
/****                         Triggers for tables                          ****/
/******************************************************************************/



/* Trigger: PDA_CONFIGURATION_DETAIL_BI */
CREATE OR ALTER TRIGGER PDA_CONFIGURATION_DETAIL_BI FOR PDA_CONFIGURATION_DETAIL
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  /* VERSION 0001 (27/05/2024) */

  IF ((NEW.PCDE_ID IS NULL) OR (NEW.PCDE_ID <= 0)) THEN
    NEW.PCDE_ID = NEXT VALUE FOR IDGENERIQUE;
END
^
SET TERM ; ^



/******************************************************************************/
/****                         Fields descriptions                          ****/
/******************************************************************************/

COMMENT ON COLUMN PDA_CONFIGURATION_DETAIL.PCDE_ID IS
'Clé primaire';

COMMENT ON COLUMN PDA_CONFIGURATION_DETAIL.PCDE_IDPDAC IS
'ID de la configuration';

COMMENT ON COLUMN PDA_CONFIGURATION_DETAIL.PCDE_TYPE IS
'Type de données : 0->Secteur, 1->Groupe, 2->Filtre';

COMMENT ON COLUMN PDA_CONFIGURATION_DETAIL.PCDE_IDDATA IS
'ID de la donnée (ASE_ID, GAR_ID, FIL_ID)';



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