ALTER DATABASE [ARTNFE] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [ARTNFE] SET ANSI_NULLS OFF
GO
ALTER DATABASE [ARTNFE] SET ANSI_PADDING OFF
GO
ALTER DATABASE [ARTNFE] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [ARTNFE] SET ARITHABORT OFF
GO
ALTER DATABASE [ARTNFE] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [ARTNFE] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [ARTNFE] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [ARTNFE] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [ARTNFE] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [ARTNFE] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [ARTNFE] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [ARTNFE] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [ARTNFE] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [ARTNFE] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [ARTNFE] SET  DISABLE_BROKER
GO
ALTER DATABASE [ARTNFE] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [ARTNFE] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [ARTNFE] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [ARTNFE] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [ARTNFE] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [ARTNFE] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [ARTNFE] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [ARTNFE] SET  READ_WRITE
GO
ALTER DATABASE [ARTNFE] SET RECOVERY FULL
GO
ALTER DATABASE [ARTNFE] SET  MULTI_USER
GO
ALTER DATABASE [ARTNFE] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [ARTNFE] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'ARTNFE', N'ON'
GO
USE [ARTNFE]
GO
/****** Object:  Table [dbo].[usuarios]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[usuarios](
	[usr] [varchar](100) NOT NULL,
	[pwd] [varchar](100) NOT NULL,
	[tipo] [varchar](10) NOT NULL,
	[cnpjs] [text] NULL,
	[nfeacess] [int] NULL,
	[nfeimp] [int] NULL,
	[nfecons] [int] NULL,
	[nfexml] [int] NULL,
	[nfesave] [int] NULL,
	[nfemail] [int] NULL,
	[cceacess] [int] NULL,
	[cceimp] [int] NULL,
	[ccexml] [int] NULL,
	[ccesave] [int] NULL,
	[ccemail] [int] NULL,
	[resnfensu] [int] NULL,
	[resnfeacess] [int] NULL,
	[resnfedetail] [int] NULL,
	[resnfemanifesta] [int] NULL,
	[resnfexml] [int] NULL,
	[resnfesave] [int] NULL,
	[emailacess] [int] NULL,
	[emailclear] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[usuarios] 
(
	[usr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[resnfe]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[resnfe](
	[cnpj] [varchar](20) NULL,
	[nsu] [varchar](15) NULL,
	[chnfe] [varchar](44) NOT NULL,
	[cpf_cnpj] [varchar](14) NULL,
	[xnome] [varchar](100) NULL,
	[ie] [varchar](14) NULL,
	[demi] [varchar](20) NULL,
	[tpnf] [varchar](1) NULL,
	[vnf] [float] NULL,
	[digval] [varchar](30) NULL,
	[dhrecbto] [varchar](20) NULL,
	[csitnfe] [int] NULL,
	[csitconf] [int] NULL,
	[dataconfirmacao] [datetime] NULL,
	[datadesconhecimento] [datetime] NULL,
	[datanaorealizada] [datetime] NULL,
	[dataciencia] [datetime] NULL,
	[cstatconfirmacao] [int] NULL,
	[cstatdesconhecimento] [int] NULL,
	[cstatnaorealizada] [int] NULL,
	[cstatciencia] [int] NULL,
	[xmotivoconfirmacao] [varchar](255) NULL,
	[xmotivodesconhecimento] [varchar](255) NULL,
	[xmotivonaorealizada] [varchar](255) NULL,
	[xmotivociencia] [varchar](255) NULL,
	[dataultimoevento] [datetime] NULL,
	[csitconfultimoevento] [int] NULL,
	[cstatultimoevento] [int] NULL,
	[xmotivoultimoevento] [varchar](255) NULL,
	[csitconfemcurso] [int] NULL,
	[xmlconfirmacao] [text] NULL,
	[xmldesconhecimento] [text] NULL,
	[xmlnaorealizada] [text] NULL,
	[xmlciencia] [text] NULL,
	[xjust] [varchar](255) NULL,
	[datadownload] [datetime] NULL,
	[cstatdownload] [int] NULL,
	[xmotivodownload] [varchar](255) NULL,
	[xmldownload] [text] NULL,
	[procnfedownload] [text] NULL,
	[xmlretdownload] [text] NULL,
	[dataerrodownload] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[resnfe] 
(
	[chnfe] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[rescce]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rescce](
	[cnpj] [varchar](20) NOT NULL,
	[nsu] [varchar](15) NULL,
	[chnfe] [varchar](44) NULL,
	[dhevento] [varchar](40) NULL,
	[tpevento] [varchar](6) NULL,
	[nseqevento] [varchar](2) NULL,
	[descevento] [varchar](60) NULL,
	[xcorrecao] [text] NULL,
	[tpnf] [varchar](1) NULL,
	[dhrecbto] [varchar](40) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Index_1] ON [dbo].[rescce] 
(
	[cnpj] ASC,
	[nsu] ASC,
	[chnfe] ASC,
	[dhevento] ASC,
	[tpevento] ASC,
	[nseqevento] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[rescanc]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rescanc](
	[cnpj] [varchar](20) NULL,
	[nsu] [varchar](15) NULL,
	[chnfe] [varchar](44) NOT NULL,
	[cpf_cnpj] [varchar](14) NULL,
	[xnome] [varchar](100) NULL,
	[ie] [varchar](14) NULL,
	[demi] [varchar](20) NULL,
	[tpnf] [varchar](1) NULL,
	[vnf] [float] NULL,
	[digval] [varchar](30) NULL,
	[dhrecbto] [varchar](20) NULL,
	[csitnfe] [int] NULL,
	[csitconf] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[rescanc] 
(
	[chnfe] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[reccnpj]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[reccnpj](
	[NREC] [varchar](15) NULL,
	[CNPJ] [varchar](20) NULL,
	[IDNOTA] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Index_1] ON [dbo].[reccnpj] 
(
	[NREC] ASC,
	[CNPJ] ASC,
	[IDNOTA] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[notas]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[notas](
	[IDNOTA] [varchar](50) NOT NULL,
	[XMLNOTA] [text] NULL,
	[NREC] [varchar](15) NULL,
	[DATA_ENVIO] [datetime] NULL,
	[XMOTIVO] [varchar](2000) NULL,
	[CSTAT] [int] NULL,
	[DATA_RETRECIBO] [datetime] NULL,
	[DATA_IMPRESSAO] [datetime] NULL,
	[XMLASSINADO] [text] NULL,
	[XMLPROCRET] [text] NULL,
	[DATA_EMAIL] [datetime] NULL,
	[PDF] [image] NULL,
	[XMLCANCELAMENTO] [text] NULL,
	[XMLINUTILIZACAO] [text] NULL,
	[DATA_EMAIL_CANCELAMENTO] [datetime] NULL,
	[XMLCANCELAMENTOSIGNED] [text] NULL,
	[XMLINUTILIZACAOSIGNED] [text] NULL,
	[dhregdpec] [varchar](30) NULL,
	[nregdpec] [varchar](30) NULL,
	[envdpec] [text] NULL,
	[retdpec] [text] NULL,
	[storage] [int] not null default -1
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[notas] 
(
	[IDNOTA] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[nfs_imp_dados]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[nfs_imp_dados](
	[CPFCNPJ_PRESTADOR] [varchar](20) NOT NULL,
	[LOGO] [image] NULL,
	[RAZO_SOCIAL] [varchar](100) NULL,
	[ENDERECO_1] [text] NULL,
	[ENDERECO_2] [text] NULL,
	[INSCRICAO] [varchar](20) NULL,
	[EMAIL] [varchar](100) NULL,
	[ATIVIDADE_MUNICIPIO] [varchar](100) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[nfs_imp_dados] 
(
	[CPFCNPJ_PRESTADOR] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[nfs_cab_imp]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[nfs_cab_imp](
	[CHAVE_ACESSO] [varchar](50) NULL,
	[NUMERO_RPS] [int] NOT NULL,
	[SERIE] [int] NOT NULL,
	[TIPO] [int] NOT NULL,
	[DATA_EMISSAO] [datetime] NULL,
	[NATUREZA_OPERACAO] [int] NULL,
	[OPTANTE_SIMPLES_NACIONAL] [int] NULL,
	[INCENTIVADOR_CULTURAL] [int] NULL,
	[STATUS] [int] NULL,
	[REGIME_ESPECIAL_TRIBUTACAO] [int] NULL,
	[TIPO_AMBIENTE_NFS] [int] NULL,
	[CPFCNPJ_PRESTADOR] [varchar](20) NOT NULL,
	[INSCRICAO_PRESTADOR] [varchar](20) NULL,
	[RAZAO_PRESTADOR] [varchar](100) NULL,
	[FANTASIA_PRESTADOR] [varchar](100) NULL,
	[ENDERECO_PRESTADOR] [varchar](100) NULL,
	[NUMERO_PRESTADOR] [varchar](10) NULL,
	[COMPLEMENTO_PRESTADOR] [varchar](100) NULL,
	[BAIRRO_PRESTADOR] [varchar](100) NULL,
	[CIDADE_PRESTADOR] [varchar](100) NULL,
	[UF_PRESTADOR] [varchar](3) NULL,
	[CEP_PRESTADOR] [varchar](20) NULL,
	[EMAIL_PRESTADOR] [varchar](100) NULL,
	[NOME_TOMADOR] [varchar](100) NULL,
	[INSCRICAOESTATUDAL_TOMADOR] [varchar](15) NULL,
	[CPFCNPJ_TOMADOR] [varchar](20) NULL,
	[INSCRICAOMUNICIPAL_TOMADOR] [varchar](15) NULL,
	[ENDERECO_TOMADOR] [varchar](100) NULL,
	[NUMERO_TOMADOR] [varchar](10) NULL,
	[COMPLEMENTO_TOMADOR] [varchar](100) NULL,
	[BAIRRO_TOMADOR] [varchar](100) NULL,
	[CIDADE_TOMADOR] [varchar](100) NULL,
	[UF_TOMADOR] [varchar](3) NULL,
	[CEP_TOMADOR] [varchar](20) NULL,
	[EMAIL_TOMADOR] [varchar](100) NULL,
	[RAZAOSOCIAL_INTERMEDIARIO] [varchar](100) NULL,
	[CPFCNPJ_INTERMEDIARIO] [varchar](20) NULL,
	[INSCRICAOMUNICIPAL_INTERMEDIARI] [varchar](20) NULL,
	[CODIGO_OBRA] [int] NULL,
	[ART] [int] NULL,
	[ITEM_LISTA_SERVICO] [varchar](10) NULL,
	[CODIGO_CNAE] [varchar](10) NULL,
	[CODIGO_TRIBUTACAO_MUNICIPIO] [varchar](20) NULL,
	[DISCRIMINACAO] [text] NULL,
	[MUNICIPIO_PRESTACAO_SERVICO] [int] NULL,
	[VALOR_SERVICOS] [float] NULL,
	[VALOR_DEDUCOES] [float] NULL,
	[VALOR_PIS] [float] NULL,
	[VALOR_COFINS] [float] NULL,
	[VALOR_INSS] [float] NULL,
	[VALOR_IR] [float] NULL,
	[VALOR_CSLL] [float] NULL,
	[ISS_RETIDO] [float] NULL,
	[VALOR_ISS] [float] NULL,
	[VALOR_ISS_RETIDO] [float] NULL,
	[OUTRAS_RETENCOES] [float] NULL,
	[BASE_CALCULO] [float] NULL,
	[ALIQUOTA] [float] NULL,
	[VALOR_LIQUIDO_NFS] [float] NULL,
	[DESCONTO_INCONDICIONADO] [float] NULL,
	[DESCONTO_CONDICIONADO] [float] NULL,
	[NATUREZA_OPERACAO_DESC] [text] NULL,
	[CODIGO_VERIFICACAO_AUTENTICIDAD] [text] NULL,
	[DATA_EMISSAO_RPS] [text] NULL,
	[NUMERO_NOTA] [int] NULL,
	[OUTRAS_INFORMACOES] [text] NULL,
	[ISS_RETIDO_DESC] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[nfs_cab_imp] 
(
	[NUMERO_RPS] ASC,
	[SERIE] ASC,
	[TIPO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[nfs]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[nfs](
	[IDNOTA] [varchar](50) NOT NULL,
	[DATA_ENVIO] [datetime] NULL,
	[XMLNOTA] [text] NULL,
	[CSTAT] [varchar](15) NULL,
	[XMOTIVO] [text] NULL,
	[NREC] [varchar](50) NULL,
	[XMLASSINADO] [text] NULL,
	[PROTOCOLO] [varchar](50) NULL,
	[CPF_CNPJ] [varchar](15) NULL,
	[INSCRICAOMUNICIPAL] [varchar](15) NULL,
	[DATA_RETRECIBO] [datetime] NULL,
	[DATA_IMPRESSAO] [datetime] NULL,
	[XMLRETORNO] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[nfs] 
(
	[IDNOTA] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[liberacao]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[liberacao](
	[c1] [varbinary](max) NULL,
	[c2] [varbinary](max) NULL,
	[c3] [varbinary](max) NULL,
	[ex] [varchar](2000) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[impressora_especifica]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[impressora_especifica](
	[IDNOTA] [varchar](50) NOT NULL,
	[IMPRESSORA] [text] NOT NULL,
	[COPIAS] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[email_notas]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[email_notas](
	[IDNOTA] [varchar](50) NOT NULL,
	[EMAIL] [text] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[email_notas] 
(
	[IDNOTA] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[confs]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[confs](
	[dirinput] [text] NULL,
	[versao] [varchar](10) NULL,
	[portabanco] [varchar](10) NULL,
	[servidor] [varchar](100) NULL,
	[banco] [varchar](100) NULL,
	[usuario] [varchar](100) NULL,
	[senha] [varchar](100) NULL,
	[removearqtemps] [varchar](10) NULL,
	[dirapp] [text] NULL,
	[dioutputsoluma] [text] NULL,
	[usaproxy] [varchar](10) NULL,
	[endproxy] [text] NULL,
	[userproxy] [varchar](100) NULL,
	[senhaproxy] [varchar](100) NULL,
	[portaproxy] [varchar](10) NULL,
	[diroutputnfeentrada] [text] NULL,
	[popentrada] [text] NULL,
	[smtpentrada] [text] NULL,
	[userentrada] [varchar](100) NULL,
	[passentrada] [varchar](100) NULL,
	[tempochecamail] [varchar](10) NULL,
	[addrentrada] [varchar](100) NULL,
	[checaentrada] [varchar](10) NULL,
	[enviaxmlmail] [varchar](10) NULL,
	[popmonitoramento] [text] NULL,
	[smtpmonitoramento] [text] NULL,
	[usermonitoramento] [varchar](100) NULL,
	[passmonitoramento] [varchar](100) NULL,
	[addrmonitoramento] [varchar](100) NULL,
	[processanotasabrasf] [varchar](10) NULL,
	[portapopentrada] [varchar](10) NULL,
	[portasmtpentrada] [varchar](10) NULL,
	[portapopmonitoramento] [varchar](10) NULL,
	[portasmtpmonitoramento] [varchar](10) NULL,
	[sslentrada] [varchar](10) NULL,
	[sslmonitoramento] [varchar](10) NULL,
	[emailredir] [text] NULL,
	[versaolayoutnota] [varchar](10) NULL,
	[somentecompdf] [varchar](10) NULL,
	[addrerrosmail] [varchar](100) NULL,
	[usacontigencia] [varchar](10) NULL,
	[seriecontigencia] [varchar](10) NULL,
	[envianotacontigencia] [varchar](10) NULL,
	[emailerrosnotaentrada] [text] NULL,
	[protocolobanco] [varchar](100) NULL,
	[usarepositorionotas] [varchar](10) NULL,
	[dirrepositorionotas] [text] NULL,
	[bancointegracao] [varchar](500) NULL,
	[utilizabancointegracao] [varchar](10) NULL,
	[manifestacienciaautomatico] [varchar](10) NULL,
	[salvatxtnotamanifestada] [varchar](10) NULL,
	[permitirmaisdeumainstanciadaaplicacao] [varchar](10) NULL,
	[md5] [varchar](50) NULL,
	[addrstorage] [varchar] (200) NULL,
	[usaloginunicoenvioemails] [varchar] (10) NULL,
	[minutosenvioemails] [int] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[cnpjnsu]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cnpjnsu](
	[cnpj] [varchar](20) NOT NULL,
	[tpamb] [int] NULL,
	[veraplic] [varchar](5) NULL,
	[cstat] [int] NULL,
	[xmotivo] [text] NULL,
	[dhresp] [varchar](50) NULL,
	[indcont] [int] NULL,
	[ultnsu] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[cnpjnsu] 
(
	[cnpj] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[cnpj]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cnpj](
	[cnpj] [varchar](20) NOT NULL,
	[razao] [varchar](200) NULL,
	[codigocertificado] [varchar](100) NULL,
	[senhacertificado] [varchar](100) NULL,
	[ambiente] [varchar](2) NULL,
	[uf] [varchar](2) NULL,
	[usaimpressao] [varchar](10) NULL,
	[impressora] [text] NULL,
	[numcopia] [varchar](2) NULL,
	[codigocertificadonfs] [varchar](100) NULL,
	[senhacertificadonfs] [varchar](100) NULL,
	[ambientenfs] [varchar](2) NULL,
	[ufnfs] [varchar](10) NULL,
	[pathlogo] [text] NULL,
	[enviapdf] [varchar](10) NULL,
	[envianotas] [varchar](10) NULL,
	[informacoesadicionaisobsrodape] [text] NULL,
	[emailavisomanifestacaonota] [text] NULL,
	[imprimedadoscupomrodape] [varchar](10) NULL,
	[idcsc] [VARCHAR](10) NULL,
  	[csc] [VARCHAR](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[cnpj] 
(
	[cnpj] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[carta_correcao]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[carta_correcao](
	[IDNOTA] [varchar](50) NOT NULL,
	[DATA_ENVIO] [datetime] NULL,
	[XMLASSINADO] [text] NULL,
	[CSTAT] [int] NULL,
	[XMOTIVO] [text] NULL,
	[IDEVENTO] [varchar](60) NOT NULL,
	[CSTAT_CC] [int] NULL,
	[XMOTIVO_CC] [text] NULL,
	[XMLRETORNO] [text] NULL,
	[SEQ] [bigint] IDENTITY (1, 1) NOT NULL,
	[DATA_EMAIL] [datetime] NULL,
	[DATA_IMPRESSAO] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[carta_correcao] 
(
	[SEQ] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[atualizanotas]    Script Date: 11/18/2014 09:49:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[atualizanotas](
	[IDNOTA] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE UNIQUE NONCLUSTERED INDEX [PRIMAR_] ON [dbo].[atualizanotas] 
(
	[IDNOTA] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  View [dbo].[VIEW_STATUSNOTA]    Script Date: 11/18/2014 09:49:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[VIEW_STATUSNOTA]
AS 
SELECT DISTINCT XMOTIVO FROM NOTAS
GO
/****** Object:  Default [DF__liberacao__ex__182C9B23]    Script Date: 11/18/2014 09:49:18 ******/
ALTER TABLE [dbo].[liberacao] ADD  DEFAULT (NULL) FOR [ex]
GO