USE [TryNFeOnline]
GO

ALTER TABLE [dbo].[classificacaotributaria] ADD 
[ncm] [varchar] (500) COLLATE Latin1_General_CI_AS NULL,
[indConsumidorFinal] [int] NULL
GO
ALTER TABLE [dbo].[Fatura] ADD 
[idnLancamentoSemParar] [bit] NULL
GO
CREATE NONCLUSTERED INDEX [_dta_index_OrdemServicoEncerrada_5_1758629308__K2_K1_3_4_5_6_7_8_9_10_11_12] ON [dbo].[OrdemServicoEncerrada]
(
	[idOrdemServico] ASC,
	[id] ASC
) INCLUDE ([dataHora],[idOperador],[valorAcrescimo],[valorDesconto],[totalReceber],[idCondicaoPagamento],[idFormaPagamento],[valorEntrada],[idReceitaProduto],[idReceitaServico]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_estoqueAjustes_5_1829581556__K7_K9_K8_K3_1_2_4_5_6_10_11_12_13_14_15_16_17_18_19] ON [dbo].[estoqueAjustes]
(
	[idOperacao] ASC,
	[idEmitente] ASC,
	[idnES] ASC,
	[data] ASC
) INCLUDE ([id],[idnProdutoControlaLote],[idProduto],[qtd],[unitario],[valor],[idOperador],[dscHistorico],[idProdutoClassificacao],[idPedido],[idnAjusteAutomatico],[idMontagem],[idNotaFiscal],[idPedidoProdutoProducaoMaquina],[unidadeMedida]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fatura_5_46623209__K16_K1_K12_K4] ON [dbo].[Fatura]
(
	[idnReceitaDespesa] ASC,
	[id] ASC,
	[idEmitente] ASC,
	[dataFatura] ASC
) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_FaturaParcelaPagamento_5_270624007__K2_8] ON [dbo].[FaturaParcelaPagamento]
(
	[idFaturaParcela] ASC
) INCLUDE ([valorJuro]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_FaturaParcelaPagamento_5_270624007__K2_9] ON [dbo].[FaturaParcelaPagamento]
(
	[idFaturaParcela] ASC
) INCLUDE ([valorMulta]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Telas] ON 
GO
INSERT [dbo].[Telas] ([id], [descricao], [controle], [imagem], [teclaAtalho1], [teclaAtalho2], [idnPermiteAbrirVarias], [qtdVezesAberta], [dataUltimaAbertura], [idnRestricaoAcesso]) VALUES (313, N'Importar MDFe', N'Cadastros.ucImportarXMLMDFe, Cadastros, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', NULL, NULL, NULL, NULL, 1, CAST(N'2021-03-05T10:37:26.677' AS DateTime), NULL)
GO
INSERT [dbo].[Telas] ([id], [descricao], [controle], [imagem], [teclaAtalho1], [teclaAtalho2], [idnPermiteAbrirVarias], [qtdVezesAberta], [dataUltimaAbertura], [idnRestricaoAcesso]) VALUES (314, N'Importar Planilha sem parar', N'Cadastros.ucImportarPlanilhaSemParar, Cadastros, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', NULL, NULL, NULL, NULL, 1, CAST(N'2021-03-05T10:38:29.180' AS DateTime), NULL)
GO
SET IDENTITY_INSERT [dbo].[Telas] OFF
GO
SET IDENTITY_INSERT [dbo].[MenuItens] ON 
GO
INSERT [dbo].[MenuItens] ([id], [idMenu], [descricao], [idTela], [idMenuItemPai], [ordem], [idnVisivel], [md5], [imagem]) VALUES (423, 2, N'Sintegra', 45, 184, 4, 1, NULL, N'')
GO
INSERT [dbo].[MenuItens] ([id], [idMenu], [descricao], [idTela], [idMenuItemPai], [ordem], [idnVisivel], [md5], [imagem]) VALUES (424, 1, N'Importar XML do MDFe', 313, 22, 28, 1, NULL, N'')
GO
INSERT [dbo].[MenuItens] ([id], [idMenu], [descricao], [idTela], [idMenuItemPai], [ordem], [idnVisivel], [md5], [imagem]) VALUES (425, 1, N'-', NULL, 68, 4, 1, NULL, N'')
GO
INSERT [dbo].[MenuItens] ([id], [idMenu], [descricao], [idTela], [idMenuItemPai], [ordem], [idnVisivel], [md5], [imagem]) VALUES (426, 1, N'Importar planilha do Sem Parar', 314, 68, 5, 1, NULL, N'')
GO
SET IDENTITY_INSERT [dbo].[MenuItens] OFF
GO
INSERT INTO VERSAO(VERSAO, VERSAOATUALIZACAO, DATAATUALIZACAO) VALUES(436, 694, GETDATE());
