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

if not exists (Select * from dbo.SysColumns Where id = object_id(N'Emitente') and 
                                                 Name Like 'TipoSistema' And
                                                 OBJECTPROPERTY(id, N'IsUserTable') = 1 )
begin
	alter table Emitente
	add TipoSistema smallint
end

if not exists (Select * from dbo.SysColumns Where id = object_id(N'[dbo].[Emitente]') and 
                                                 Name Like 'InscricaoMunicipal' And
                                                 OBJECTPROPERTY(id, N'IsUserTable') = 1 )
begin
	alter table Emitente
	add InscricaoMunicipal nvarchar(25)
end


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

CREATE TABLE [dbo].[WebServiceNFSe](
	[IdWebService] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[TipoSistema] [smallint] NOT NULL,
	[URL] [nvarchar](200) NOT NULL,
	[TipoAmbiente] [int] NOT NULL,
	[TipoWebService] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[IdWebService] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

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

CREATE TABLE [dbo].[LoteNFSe](
	[IdLote] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[NumeroRecibo] [nvarchar](50) NOT NULL,
	[Sequencia] [int] NOT NULL,
	[StatusLote] [int] NOT NULL,
	[IdCertificado] [int] NOT NULL,
	[IdEmitente] [int] NOT NULL,
	[IdWebService] [int] NOT NULL,
	[XmlLoteGerado] [ntext] NULL,
PRIMARY KEY CLUSTERED 
(
	[IdLote] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[NotaFiscalServico](
	[IdNotaFiscalServico] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[NumeroRps] int NOT NULL,
	[NumeroNota] [int] NOT NULL,
	[Serie] [nvarchar](3) NOT NULL,
	[StatusNota] [int] NOT NULL,
	[IdLote] [int] NULL,
	[NotaXmlAutorizado] [ntext] NULL,
	[NotaXml] [ntext] NULL,
	[NumeroProtocolo] [bigint] NULL,
 CONSTRAINT [PK__NotaFiscalServico] PRIMARY KEY CLUSTERED 
(
	[IdNotaFiscalServico] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[NotaFiscalServico]  WITH CHECK ADD  CONSTRAINT [FK_LoteNFSe] FOREIGN KEY([IdLote])
REFERENCES [dbo].[LoteNFSe] ([IdLote])
GO

ALTER TABLE [dbo].[NotaFiscalServico] CHECK CONSTRAINT [FK_LoteNFSe]
GO

