/******************************************************************************/
/***               Generated by IBExpert 13/02/2023 17:26:15                ***/
/******************************************************************************/

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



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



CREATE TABLE ACESSO (
    ID            BIGINT GENERATED BY DEFAULT AS IDENTITY,
    MATRICULA     INTEGER,
    NOME          NOME /* NOME = VARCHAR(80) */,
    CATEGORIA     NOME /* NOME = VARCHAR(80) */,
    MOTIVO        NOME /* NOME = VARCHAR(80) */,
    CODIGO_BARRA  COD_BARRA /* COD_BARRA = VARCHAR(120) */,
    FOTO          NOME /* NOME = VARCHAR(80) */,
    LIBERADO      VARCHAR(1) COLLATE WIN_PTBR,
    CONVITE       VARCHAR(1) COLLATE WIN_PTBR,
    DATA_ACESSO   TIMESTAMP
);




/******************************************************************************/
/***                        Autoincrement generators                        ***/
/******************************************************************************/


ALTER TABLE ACESSO ALTER ID RESTART WITH 2;




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

ALTER TABLE ACESSO ADD CONSTRAINT PK_ACESSO PRIMARY KEY (ID);


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


ALTER TABLE ITENS_SERVICO
    ADD LOCAL_PAGAMENTO NOME

UPDATE ITENS_SERVICO
SET LOCAL_PAGAMENTO = 'SEDE'

ALTER TABLE VALOR_ITENS_SERVICO
    ADD LOCAL_PAGAMENTO NOME

UPDATE VALOR_ITENS_SERVICO
SET LOCAL_PAGAMENTO = 'SEDE'


ALTER TABLE DEPENDENTE
    ADD CPF CPF

ALTER TABLE PARAMETRO
    ADD COD_IMPRESSORA_RECIBO_AV CODIGO,
    ADD IMPRESSAO_RECIBO_AV_VISUALIZAR BOOLEAN_STR,
    ADD IMPRESSAO_RECIBO_AV_OP_IMPRESSA BOOLEAN_STR,
    ADD IMPRESSAO_RECIBO_AV NOME

ALTER TABLE RECIBO_AVULSO ALTER COLUMN REFERENTE TYPE OBSERVACAO

ALTER TABLE PROCESSAMENTO
    ADD CEDENTE ABREVIATURA

ALTER TABLE CONVENIO_COBRANCA
    ADD CONTA_EXTRATO_BANCARIO NOME



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


CREATE TABLE ENTIDADE_SINDICAL_CEDENTES (
    COD_ENTIDADE_CEDENTES  CODIGO NOT NULL /* CODIGO = INTEGER */,
    COD_ENTIDADE_SINDICAL  CODIGO NOT NULL /* CODIGO = INTEGER */,
    CODIGO_DO_CEDENTE      DESCRICAO /* DESCRICAO = VARCHAR(200) */,
    CONTA                  NOME /* NOME = VARCHAR(80) */,
    CONTA_DV               ABREVIATURA /* ABREVIATURA = VARCHAR(10) */,
    AGENCIA                ABREVIATURA /* ABREVIATURA = VARCHAR(10) */,
    AGENCIA_DV             ABREVIATURA /* ABREVIATURA = VARCHAR(10) */,
    DESCRICAO              DESCRICAO /* DESCRICAO = VARCHAR(200) */
);




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

ALTER TABLE ENTIDADE_SINDICAL_CEDENTES ADD CONSTRAINT PK_ENTIDADE_SINDICAL_CEDENTES PRIMARY KEY (COD_ENTIDADE_CEDENTES);


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

ALTER TABLE ENTIDADE_SINDICAL_CEDENTES ADD CONSTRAINT FK_ENTIDADE_SINDICAL_CEDENTES_1 FOREIGN KEY (COD_ENTIDADE_SINDICAL) REFERENCES ENTIDADE_SINDICAL (COD_ENTIDADE_SINDICAL) ON DELETE CASCADE ON UPDATE CASCADE;



/******************************************************************************/
/***               Generated by IBExpert 25/12/2022 08:50:19                ***/
/******************************************************************************/

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



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


CREATE GENERATOR GEN_ENT_SINDICAL_ARQUIVOS_DET;

CREATE TABLE ENTIDADE_SINDICAL_ARQUIVOS_DET (
    COD_ENTIDADE_ARQUIVO_DET  CODIGO_EXTENSO NOT NULL /* CODIGO_EXTENSO = NUMERIC(15,0) */,
    COD_ENTIDADE_ARQUIVO      CODIGO_EXTENSO /* CODIGO_EXTENSO = NUMERIC(15,0) */,
    DATA_CREDITO              DATE,
    VALOR_RATEIO              VALOR /* VALOR = NUMERIC(15,2) */
);




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

ALTER TABLE ENTIDADE_SINDICAL_ARQUIVOS_DET ADD CONSTRAINT PK_ENTIDADE_SINDICAL_ARQUIVOS_D PRIMARY KEY (COD_ENTIDADE_ARQUIVO_DET);


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

ALTER TABLE ENTIDADE_SINDICAL_ARQUIVOS_DET ADD CONSTRAINT FK_ENTIDADE_SINDICAL_ARQUIVOS_D FOREIGN KEY (COD_ENTIDADE_ARQUIVO) REFERENCES ENTIDADE_SINDICAL_ARQUIVOS (COD_ENTIDADE_ARQUIVO) ON DELETE CASCADE ON UPDATE CASCADE;


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



SET TERM ^ ;



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



/* Trigger: ENT_SINDICAL_ARQUIVOS_DET */
CREATE OR ALTER TRIGGER ENT_SINDICAL_ARQUIVOS_DET FOR ENTIDADE_SINDICAL_ARQUIVOS_DET
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.cod_entidade_arquivo_det is null) then
    new.cod_entidade_arquivo_det = gen_id(gen_ent_sindical_arquivos_det,1);
end
^

SET TERM ; ^



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


/******************************************************************************/
/***               Generated by IBExpert 25/12/2022 08:50:07                ***/
/******************************************************************************/

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



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


CREATE GENERATOR GEN_ENT_SINDICAL_ARQUIVOS;

CREATE TABLE ENTIDADE_SINDICAL_ARQUIVOS (
    COD_ENTIDADE_ARQUIVO   CODIGO_EXTENSO NOT NULL /* CODIGO_EXTENSO = NUMERIC(15,0) */,
    COD_ENTIDADE_CEDENTES  CODIGO /* CODIGO = INTEGER */,
    NSA                    CODIGO /* CODIGO = INTEGER */,
    NOME                   OBSERVACAO /* OBSERVACAO = VARCHAR(10000) */,
    DATA                   DATE,
    HASH_CODE              NOME /* NOME = VARCHAR(80) */
);




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

ALTER TABLE ENTIDADE_SINDICAL_ARQUIVOS ADD CONSTRAINT PK_ENTIDADE_SINDICAL_ARQUIVOS PRIMARY KEY (COD_ENTIDADE_ARQUIVO);


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

ALTER TABLE ENTIDADE_SINDICAL_ARQUIVOS ADD CONSTRAINT FK_ENTIDADE_SINDICAL_ARQUIVOS_1 FOREIGN KEY (COD_ENTIDADE_CEDENTES) REFERENCES ENTIDADE_SINDICAL_CEDENTES (COD_ENTIDADE_CEDENTES) ON DELETE CASCADE ON UPDATE CASCADE;


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



SET TERM ^ ;



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



/* Trigger: ENTIDADE_SINDICAL_ARQUIVOS_BI */
CREATE OR ALTER TRIGGER ENTIDADE_SINDICAL_ARQUIVOS_BI FOR ENTIDADE_SINDICAL_ARQUIVOS
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.cod_entidade_arquivo is null) then
    new.cod_entidade_arquivo = gen_id(gen_ent_sindical_arquivos,1);
end
^

SET TERM ; ^




ALTER TABLE CONVENIO_COBRANCA
    ADD CONTA_EXTRATO_BANCARIO NOME

ALTER TABLE CONVENIO_COBRANCA
    ADD PERCENTUAL_RATEIO PERCENTUAL;

ALTER TABLE REGISTRO
    ADD COD_FILIAL INTEGER;