USE [TryNFeOnline]
GO

ALTER TABLE [dbo].[configuracoes] ADD 
[idnNaoRemoverFormatacaoNFSe] [bit] NULL,
[idnIncluirFormaPagamentoInfAdicionaisNota] [bit] NULL,
[idnExigirMudarParceiroPreVenda] [bit] NULL
GO
ALTER TABLE [dbo].[estado] ADD 
[consultaQRCodeCTeHomologacao] [varchar] (200) COLLATE Latin1_General_CI_AS NULL,
[consultaQRCodeCTeProducao] [varchar] (200) COLLATE Latin1_General_CI_AS NULL
GO
UPDATE estado SET consultaQRCodeCTeHomologacao = 'https://hcte.fazenda.mg.gov.br/portalcte/sistema/qrcode.xhtml', consultaQRCodeCTeProducao = 'https://cte.fazenda.mg.gov.br/portalcte/sistema/qrcode.xhtml' 
WHERE UF = 'MG'
GO
UPDATE estado SET consultaQRCodeCTeHomologacao = 'http://www.dfe.ms.gov.br/cte/qrcode', consultaQRCodeCTeProducao = 'http://www.dfe.ms.gov.br/cte/qrcode' 
WHERE UF = 'MS'
GO
UPDATE estado SET consultaQRCodeCTeHomologacao = 'https://homologacao.sefaz.mt.gov.br/cte/qrcode', consultaQRCodeCTeProducao = 'https://www.sefaz.mt.gov.br/cte/qrcode' 
WHERE UF = 'MT'
GO
UPDATE estado SET consultaQRCodeCTeHomologacao = 'http://www.fazenda.pr.gov.br/cte/qrcode', consultaQRCodeCTeProducao = 'http://www.fazenda.pr.gov.br/cte/qrcode' 
WHERE UF = 'PR'
GO
UPDATE estado SET consultaQRCodeCTeHomologacao = 'https://homologacao.nfe.fazenda.sp.gov.br/CTeConsulta/qrCode', consultaQRCodeCTeProducao = 'https://nfe.fazenda.sp.gov.br/CTeConsulta/qrCode' 
WHERE UF = 'AP' OR UF = 'PE' OR UF = 'RR' OR UF = 'SP'
GO
UPDATE estado SET consultaQRCodeCTeHomologacao = 'https://dfe-portal.svrs.rs.gov.br/cte/qrCode', consultaQRCodeCTeProducao = 'https://dfe-portal.svrs.rs.gov.br/cte/qrCode' 
WHERE UF = 'AC' OR UF = 'AL' OR UF = 'AM' OR UF = 'BA' OR UF = 'CE' OR UF = 'DF' OR UF = 'ES' OR UF = 'GO' OR UF = 'MA' OR UF = 'PA' OR UF = 'PB' OR UF = 'PI' OR UF = 'RJ' OR UF = 'RN' OR UF = 'RO' OR UF = 'RS' OR UF = 'SC' OR UF = 'SE' OR UF = 'TO'
GO
SET IDENTITY_INSERT [dbo].[Telas] ON 
GO
INSERT [dbo].[Telas] ([id], [descricao], [controle], [imagem], [teclaAtalho1], [teclaAtalho2], [idnPermiteAbrirVarias], [qtdVezesAberta], [dataUltimaAbertura], [idnRestricaoAcesso]) VALUES (295, N'Consultar CIOT', N'Cadastros.ucConsCIOT, Cadastros, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', NULL, NULL, NULL, NULL, 1, CAST(N'2019-09-21T10:46:53.253' 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 (396, 1, N'Consultar CIOT', 295, 22, 13, 1, NULL, N'')
GO
INSERT [dbo].[MenuItens] ([id], [idMenu], [descricao], [idTela], [idMenuItemPai], [ordem], [idnVisivel], [md5], [imagem]) VALUES (397, 2, N'Consultar CIOT', 295, 164, 9, 1, NULL, N'')
GO
SET IDENTITY_INSERT [dbo].[MenuItens] OFF
GO
INSERT INTO VERSAO(VERSAO, VERSAOATUALIZACAO, DATAATUALIZACAO) VALUES(390, 648, GETDATE());