ALTER TABLE TBGESTAO_NOTIF_CLIENTE
ADD ID_SERVIDOR INTEGER;

CREATE TABLE TBGESTAO_NOTIF_CLIENTE_USUARIOS (
    ID INTEGER NOT NULL,
    GESTAO_NOTIF_CLIENTE_ID INTEGER NOT NULL,
    USUARIO_ID INTEGER NOT NULL);

ALTER TABLE TBGESTAO_NOTIF_CLIENTE_USUARIOS
ADD CONSTRAINT PK_TBGESTAO_NOTIF_CLIENTE_USUAR
PRIMARY KEY (ID);

CREATE SEQUENCE GTBGESTAO_NOTIF_CLIENTE_U;

SET TERM ^ ;

CREATE OR ALTER trigger tbgestao_notif_cliente_u_b01i for tbgestao_notif_cliente_usuarios
active before insert position 0
AS
BEGIN
    IF (NEW.ID IS NULL) THEN
        NEW.ID = GEN_ID(GTBGESTAO_NOTIF_CLIENTE_U, 1);
END
^

SET TERM ; ^

SET TERM ^ ;

CREATE or ALTER trigger ttbgestao_notif_cliente_b02d for tbgestao_notif_cliente
active before delete position 1
AS
BEGIN
    IF (OLD.ID > 0) THEN
    BEGIN
        DELETE FROM TBGESTAO_NOTIF_CLIENTE_USUARIOS U WHERE U.GESTAO_NOTIF_CLIENTE_ID = OLD.ID;
    END
END
^

SET TERM ; ^