USE [master]
GO
/****** Object:  Database [dbRsysNFe]    Script Date: 28/03/2024 14:41:37 ******/
CREATE DATABASE [dbRsysNFe]

GO
ALTER DATABASE [dbRsysNFe] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [dbRsysNFe].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [dbRsysNFe] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [dbRsysNFe] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [dbRsysNFe] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [dbRsysNFe] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [dbRsysNFe] SET ARITHABORT OFF 
GO
ALTER DATABASE [dbRsysNFe] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [dbRsysNFe] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [dbRsysNFe] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [dbRsysNFe] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [dbRsysNFe] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [dbRsysNFe] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [dbRsysNFe] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [dbRsysNFe] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [dbRsysNFe] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [dbRsysNFe] SET  DISABLE_BROKER 
GO
ALTER DATABASE [dbRsysNFe] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [dbRsysNFe] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [dbRsysNFe] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [dbRsysNFe] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [dbRsysNFe] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [dbRsysNFe] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [dbRsysNFe] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [dbRsysNFe] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [dbRsysNFe] SET  MULTI_USER 
GO
ALTER DATABASE [dbRsysNFe] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [dbRsysNFe] SET DB_CHAINING OFF 
GO
ALTER DATABASE [dbRsysNFe] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [dbRsysNFe] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
ALTER DATABASE [dbRsysNFe] SET DELAYED_DURABILITY = DISABLED 
GO
EXEC sys.sp_db_vardecimal_storage_format N'dbRsysNFe', N'ON'
GO
USE [dbRsysNFe]
GO
/****** Object:  Table [dbo].[Certificado]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Certificado](
	[IdCertificado] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[Nome] [nvarchar](100) NOT NULL,
	[IdEmitente] [int] NULL,
	[TipoLocal] [smallint] NULL,
	[PrivateKey] [varchar](max) NULL,
	[PublicKey] [varchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[IdCertificado] 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].[ConfiguracaoDanfe]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConfiguracaoDanfe](
	[IdConfiguracao] [int] IDENTITY(1,1) NOT NULL,
	[NomeConfiguracao] [varchar](50) NOT NULL,
	[NomeLayoutDanfe] [varchar](255) NULL,
	[LayoutRpt] [varbinary](max) NULL,
	[XmlConfiguracoes] [varchar](max) NULL,
 CONSTRAINT [PK_ConfiguracaoDanfe] PRIMARY KEY CLUSTERED 
(
	[IdConfiguracao] 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].[ConfiguracaoDanfse]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ConfiguracaoDanfse](
	[IdConfiguracaoNFSe] [int] IDENTITY(1,1) NOT NULL,
	[NomeConfiguracao] [varchar](50) NOT NULL,
	[NomeLayoutNFSe] [varchar](255) NULL,
	[LayoutRptNFSe] [varbinary](max) NULL,
	[TipoLayoutNFSe] [int] NULL,
	[ModeloLogo] [int] NULL,
	[SepararDescricaoValor] [bit] NULL,
	[ImprimirCodigoTomador] [bit] NULL,
 CONSTRAINT [PK_ConfiguracaoDanfse] PRIMARY KEY CLUSTERED 
(
	[IdConfiguracaoNFSe] 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].[DownloadNota]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DownloadNota](
	[IdDownloadNota] [int] IDENTITY(1,1) NOT NULL,
	[DataHora] [datetime] NOT NULL,
	[Ip] [varchar](50) NOT NULL,
	[EnderecoWeb] [varchar](100) NOT NULL,
	[IdNotaFiscal] [int] NOT NULL,
	[Versao] [int] NOT NULL,
 CONSTRAINT [PK_DownloadNota] PRIMARY KEY CLUSTERED 
(
	[IdDownloadNota] 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].[Emitente]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Emitente](
	[IdEmitente] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[RazaoSocial] [nvarchar](100) NOT NULL,
	[CNPJ] [nvarchar](14) NOT NULL,
	[VersaoSchema] [int] NOT NULL,
	[Estado] [nvarchar](255) NOT NULL,
	[TipoSistema] [smallint] NULL,
	[InscricaoMunicipal] [nvarchar](25) NULL,
	[IdConfiguracaoDanfe] [int] NULL,
	[NomeLogotipo] [varchar](255) NULL,
	[Logotipo] [varbinary](max) NULL,
	[CodigoCSC] [varchar](36) NULL,
	[IdToken] [varchar](6) NULL,
	[IdConfiguracaoDanfse] [int] NULL,
	[VersaoNfse] [int] NULL,
 CONSTRAINT [PK__Emitente__FE3883037F60ED59] PRIMARY KEY CLUSTERED 
(
	[IdEmitente] 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].[Log]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Log](
	[IdLancto] [int] IDENTITY(1,1) NOT NULL,
	[Ano] [int] NOT NULL,
	[Semana] [int] NOT NULL,
	[CodEmitente] [int] NOT NULL,
	[TipoLog] [int] NOT NULL,
	[Mensagem] [varchar](255) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[IdLancto] 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].[Lote]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Lote](
	[IdLote] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[NumeroRecebido] [nvarchar](50) NOT NULL,
	[Sequencia] [int] NOT NULL,
	[StatusLote] [int] NOT NULL,
	[IdCertificado] [int] NOT NULL,
	[IdEmitente] [int] NOT NULL,
	[XmlLoteGerado] [ntext] NULL,
	[TipoAmbiente] [int] NOT NULL,
	[TipoServico] [int] NOT NULL,
	[TipoWebService] [int] 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].[LoteNFSe]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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] NULL,
	[XmlLoteGerado] [ntext] NULL,
	[XmlReciboProtocolo] [varchar](8000) NULL,
	[MensagemErroWS] [varchar](1000) NULL,
	[MensagemPreValidacao] [varchar](1000) NULL,
 CONSTRAINT [PK__LoteNFSe__38C4EE901CF15040] 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: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NotaFiscal](
	[IdNotaFiscal] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[ChaveAcesso] [nvarchar](50) NOT NULL,
	[CodigoNumerico] [int] NOT NULL,
	[NumeroDocumento] [int] NOT NULL,
	[Serie] [nvarchar](3) NOT NULL,
	[StatusNota] [int] NOT NULL,
	[IdLote] [int] NULL,
	[DocDistribuicaoNota] [ntext] NULL,
	[NotaXml] [ntext] NULL,
	[NumeroProtocolo] [bigint] NULL,
	[DocCancelamentoNota] [ntext] NULL,
 CONSTRAINT [PK__NotaFiscal__1387E197] PRIMARY KEY CLUSTERED 
(
	[IdNotaFiscal] 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].[NotaFiscalServico]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NotaFiscalServico](
	[IdNotaFiscalServico] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[Serie] [nvarchar](3) NOT NULL,
	[StatusNota] [int] NOT NULL,
	[IdLote] [int] NULL,
	[NotaXmlAutorizado] [ntext] NULL,
	[NotaXml] [ntext] NULL,
	[NumeroProtocolo] [nvarchar](50) NULL,
	[NumeroRps] [int] NULL,
	[NumeroNota] [int] 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
/****** Object:  Table [dbo].[Versao]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Versao](
	[Versao] [smallint] NOT NULL,
	[SubVersao] [smallint] NOT NULL,
 CONSTRAINT [PK_Versao] PRIMARY KEY CLUSTERED 
(
	[Versao] ASC,
	[SubVersao] 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].[WebService]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WebService](
	[IdWebService] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[Estado] [nvarchar](2) 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].[WebServiceNFSe]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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].[WSNFSeEmitenteCidade]    Script Date: 28/03/2024 14:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WSNFSeEmitenteCidade](
	[IdWSNFSe] [int] IDENTITY(1,1) NOT NULL,
	[Versao] [int] NOT NULL,
	[IdEmitente] [int] NOT NULL,
	[CodIbge] [int] NOT NULL,
	[TipoAmbiente] [int] NOT NULL,
	[TipoWebService] [int] NOT NULL,
	[URLWebService] [varchar](200) NULL,
 CONSTRAINT [PK__IdWSNFSe] PRIMARY KEY CLUSTERED 
(
	[IdWSNFSe] 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
ALTER TABLE [dbo].[Certificado] ADD  DEFAULT ((0)) FOR [TipoLocal]
GO
ALTER TABLE [dbo].[Certificado]  WITH CHECK ADD  CONSTRAINT [FK7C23369CFBAB0753] FOREIGN KEY([IdEmitente])
REFERENCES [dbo].[Emitente] ([IdEmitente])
GO
ALTER TABLE [dbo].[Certificado] CHECK CONSTRAINT [FK7C23369CFBAB0753]
GO
ALTER TABLE [dbo].[DownloadNota]  WITH CHECK ADD  CONSTRAINT [FK_DownloadNota_NotaFiscal] FOREIGN KEY([IdNotaFiscal])
REFERENCES [dbo].[NotaFiscal] ([IdNotaFiscal])
GO
ALTER TABLE [dbo].[DownloadNota] CHECK CONSTRAINT [FK_DownloadNota_NotaFiscal]
GO
ALTER TABLE [dbo].[Lote]  WITH CHECK ADD  CONSTRAINT [FK4BDC032A1860335] FOREIGN KEY([IdCertificado])
REFERENCES [dbo].[Certificado] ([IdCertificado])
GO
ALTER TABLE [dbo].[Lote] CHECK CONSTRAINT [FK4BDC032A1860335]
GO
ALTER TABLE [dbo].[Lote]  WITH CHECK ADD  CONSTRAINT [FK4BDC032AFBAB0753] FOREIGN KEY([IdEmitente])
REFERENCES [dbo].[Emitente] ([IdEmitente])
GO
ALTER TABLE [dbo].[Lote] CHECK CONSTRAINT [FK4BDC032AFBAB0753]
GO
ALTER TABLE [dbo].[NotaFiscal]  WITH CHECK ADD  CONSTRAINT [FK883BFB094CAF7531] FOREIGN KEY([IdLote])
REFERENCES [dbo].[Lote] ([IdLote])
GO
ALTER TABLE [dbo].[NotaFiscal] CHECK CONSTRAINT [FK883BFB094CAF7531]
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
ALTER TABLE [dbo].[WSNFSeEmitenteCidade]  WITH CHECK ADD  CONSTRAINT [FK_WSNFSe_Emitente] FOREIGN KEY([IdEmitente])
REFERENCES [dbo].[Emitente] ([IdEmitente])
GO
ALTER TABLE [dbo].[WSNFSeEmitenteCidade] CHECK CONSTRAINT [FK_WSNFSe_Emitente]
GO
USE [master]
GO
ALTER DATABASE [dbRsysNFe] SET  READ_WRITE 
GO
