/*================*/
/* Versão: 3.51   */
/*==============================================================*/
/* Tables: PARCELAS_NF, DESCCORPO_NF, ALIQ_ICMSNF,              */
/*         DESCAUX_NF, ITENS_NF                                 */
/*==============================================================*/
ALTER TABLE PARCELAS_NF DROP CONSTRAINT FK_PARCELAS_NF_NOTA_FISCAL;

ALTER TABLE DESCCORPO_NF DROP CONSTRAINT FK_DESCCORPO_NF_NOTA_FISCAL;

ALTER TABLE ALIQ_ICMSNF DROP CONSTRAINT FK_ALIQ_ICMSNF_NOTA_FISCAL;

ALTER TABLE DESCAUX_NF DROP CONSTRAINT FK_DESCAUX_NF_NOTA_FISCAL;

ALTER TABLE ITENS_NF DROP CONSTRAINT FK_ITENS_NF_NOTA_FISCAL;

COMMIT WORK;

/*==============================================================*/
/* Table: PARCELAS_NF                                           */
/*==============================================================*/
ALTER TABLE PARCELAS_NF ADD MODELO_NF CHAR(2);

COMMIT WORK;

UPDATE PARCELAS_NF SET MODELO_NF = '01' WHERE MODELO_NF IS NULL;

COMMIT WORK;

update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MODELO_NF') and (RDB$RELATION_NAME = 'PARCELAS_NF');

COMMIT WORK;

/*==============================================================*/
/* Table: DESCCORPO_NF                                          */
/*==============================================================*/
ALTER TABLE DESCCORPO_NF ADD MODELO_NF CHAR(2);

COMMIT WORK;

UPDATE DESCCORPO_NF SET MODELO_NF = '01' WHERE MODELO_NF IS NULL;

COMMIT WORK;

update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MODELO_NF') and (RDB$RELATION_NAME = 'DESCCORPO_NF');

COMMIT WORK;

/*==============================================================*/
/* Table: ITENS_NF                                              */
/*==============================================================*/
ALTER TABLE ITENS_NF ADD MODELO_NF CHAR(2);

COMMIT WORK;

UPDATE ITENS_NF SET MODELO_NF = '01' WHERE MODELO_NF IS NULL;

COMMIT WORK;

update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MODELO_NF') and (RDB$RELATION_NAME = 'ITENS_NF');

COMMIT WORK;

/*==============================================================*/
/* Table: ALIQ_ICMSNF                                           */
/*==============================================================*/
ALTER TABLE ALIQ_ICMSNF ADD MODELO_NF CHAR(2);

COMMIT WORK;

UPDATE ALIQ_ICMSNF SET MODELO_NF = '01' WHERE MODELO_NF IS NULL;

COMMIT WORK;

update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MODELO_NF') and (RDB$RELATION_NAME = 'ALIQ_ICMSNF');

COMMIT WORK;

/*==============================================================*/
/* Table: DESCAUX_NF                                            */
/*==============================================================*/
ALTER TABLE DESCAUX_NF ADD MODELO_NF CHAR(2);

COMMIT WORK;

UPDATE DESCAUX_NF SET MODELO_NF = '01' WHERE MODELO_NF IS NULL;

COMMIT WORK;

update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MODELO_NF') and (RDB$RELATION_NAME = 'DESCAUX_NF');

COMMIT WORK;

/*==============================================================*/
/* Table: NOTA_FISCAL                                           */
/*==============================================================*/
ALTER TABLE NOTA_FISCAL ADD MODELO_NF CHAR(2);

COMMIT WORK;

ALTER TRIGGER TG_UPDATE_NOTAFISCAL INACTIVE;

COMMIT WORK;

UPDATE NOTA_FISCAL SET MODELO_NF = '01' WHERE MODELO_NF IS NULL;

COMMIT WORK;

update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'MODELO_NF') and (RDB$RELATION_NAME = 'NOTA_FISCAL');

COMMIT WORK;

ALTER TABLE NOTA_FISCAL DROP CONSTRAINT PK_NOTA_FISCAL;

COMMIT WORK;

alter table NOTA_FISCAL
   add constraint PK_NOTA_FISCAL primary key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF);

COMMIT WORK;

ALTER TRIGGER TG_UPDATE_NOTAFISCAL ACTIVE;

COMMIT WORK;

/*==============================================================*/
/* Table: ITENS_NF                                              */
/*==============================================================*/
ALTER TABLE ITENS_NF DROP CONSTRAINT PK_ITENS_NF;

COMMIT WORK;

alter table ITENS_NF
   add constraint PK_ITENS_NF primary key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF,SEQ_ITEM);

COMMIT WORK;

alter table ITENS_NF
   add constraint FK_ITENS_NF_NOTA_FISCAL foreign key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF)
      references NOTA_FISCAL(COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF);

COMMIT WORK;

/*==============================================================*/
/* Table: ALIQ_ICMSNF                                           */
/*==============================================================*/
ALTER TABLE ALIQ_ICMSNF DROP CONSTRAINT PK_ALIQ_ICMSNF;

COMMIT WORK;

alter table ALIQ_ICMSNF
   add constraint PK_ALIQ_ICMSNF primary key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF,TIPO_VLR);

COMMIT WORK;

alter table ALIQ_ICMSNF
   add constraint FK_ALIQ_ICMSNF_NOTA_FISCAL foreign key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF)
      references NOTA_FISCAL(COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF);

COMMIT WORK;

/*==============================================================*/
/* Table: DESCAUX_NF                                            */
/*==============================================================*/
ALTER TABLE DESCAUX_NF DROP CONSTRAINT PK_DESCAUX_NF;

COMMIT WORK;

alter table DESCAUX_NF
   add constraint PK_DESCAUX_NF primary key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF,SEQUENCIA);

COMMIT WORK;

alter table DESCAUX_NF
   add constraint FK_DESCAUX_NF_NOTA_FISCAL foreign key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF)
      references NOTA_FISCAL(COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF);

COMMIT WORK;

/*==============================================================*/
/* Table: DESCCORPO_NF                                          */
/*==============================================================*/
ALTER TABLE DESCCORPO_NF DROP CONSTRAINT PK_DESCCORPO_NF;

COMMIT WORK;

alter table DESCCORPO_NF
   add constraint PK_DESCCORPO_NF primary key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF,SEQUENCIA);

COMMIT WORK;

alter table DESCCORPO_NF
   add constraint FK_DESCCORPO_NF_NOTA_FISCAL foreign key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF)
      references NOTA_FISCAL(COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF);

COMMIT WORK;

/*==============================================================*/
/* Table: PARCELAS_NF                                           */
/*==============================================================*/
ALTER TABLE PARCELAS_NF DROP CONSTRAINT PK_PARCELAS_NF;

COMMIT WORK;

alter table PARCELAS_NF
   add constraint PK_PARCELAS_NF primary key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF,SEQ_PARCELAS);

COMMIT WORK;

alter table PARCELAS_NF
   add constraint FK_PARCELAS_NF_NOTA_FISCAL foreign key (COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF)
      references NOTA_FISCAL(COD_EMPRESA,TIPO_CONTROL,NRO_NF,SERIE_NF,MODELO_NF);

COMMIT WORK;