 
CREATE GENERATOR GEN_WEBSERVICENFSE_ID;
CREATE GENERATOR GEN_LOTENFSE_ID;
CREATE GENERATOR GEN_NOTAFISCALSERVICO_ID;

/****** Object:  Table [dbo].[WebService]    Script Date: 02/11/2014 11:24:19 ******/

CREATE TABLE WebServiceNFSe(
    IdWebService int NOT NULL,
    Versao int NOT NULL,
    TipoSistema smallint NOT NULL,
    URL varchar (200) NOT NULL,
    TipoAmbiente int NOT NULL,
    TipoWebService int NOT NULL);

ALTER TABLE WebServiceNFSe ADD CONSTRAINT PK_WebServiceNFSe PRIMARY KEY
(    IdWebService);


/****** Object:  Table [dbo].[LoteNFSe]    Script Date: 02/11/2014 11:21:55 ******/

CREATE TABLE LoteNFSe(
    IdLote int NOT NULL,
    Versao int NOT NULL,
    NumeroRecibo varchar (50) NOT NULL,
    Sequencia int NOT NULL,
    StatusLote int NOT NULL,
    IdCertificado int NOT NULL,
    IdEmitente int NOT NULL,
    IdWebService int NOT NULL,
    XmlLoteGerado BLOB SUB_TYPE 1 SEGMENT SIZE 80);

    
ALTER TABLE LoteNFSe ADD CONSTRAINT PK_LoteNFSe PRIMARY KEY
(    IdLote);


/****** Object:  Table [dbo].[NotaFiscal]    Script Date: 02/11/2014 11:28:11 ******/

CREATE TABLE NotaFiscalServico(
    IdNotaFiscalServico int NOT NULL,
    Versao int NOT NULL,
    NumeroRps int NOT NULL,
    NumeroNota int NOT NULL,
    Serie varchar(3) NOT NULL,
    StatusNota int NOT NULL,
    IdLote int,
    NotaXmlAutorizado BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    NotaXml BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    NumeroProtocolo bigint);


ALTER TABLE NotaFiscalServico ADD CONSTRAINT PK_NotaFiscalServico PRIMARY KEY
(    IdNotaFiscalServico);


SET TERM ^ ;

CREATE TRIGGER LOTENFSE_BI FOR LOTENFSE
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.IDLOTE IS NULL) THEN
    NEW.IDLOTE = GEN_ID(GEN_LOTENFSE_ID,1);
END^


CREATE TRIGGER WEBSERVICENFSE_BI FOR WEBSERVICENFSE
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.IDWEBSERVICE IS NULL) THEN
    NEW.IDWEBSERVICE = GEN_ID(GEN_WEBSERVICENFSE_ID,1);
END^

CREATE TRIGGER NOTAFISCALSERVICO_BI FOR NOTAFISCALSERVICO
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.IDNOTAFISCALSERVICO IS NULL) THEN
    NEW.IDNOTAFISCALSERVICO = GEN_ID(GEN_NOTAFISCALSERVICO_ID,1);
END^

 /*
    CRIAÇÃO DE CAMPOS DO EMITENTE
*/

SET TERM ; ^
alter table Emitente
add TipoSistema smallint;

alter table Emitente
add InscricaoMunicipal varchar(25);


