USE [TryNFeOnline]
GO

ALTER TABLE [dbo].[configuracaoNovo] ADD 
[tamanhoValorMaximo] [varchar] (20) COLLATE Latin1_General_CI_AS NULL,
[idnParametroMultilinhas] [bit] NULL,
[idnParametroRadio] [bit] NULL,
[idnParametroSelecaoPasta] [bit] NULL,
[idnPermiteAlteracaoApenasPorAdmins] [bit] NULL,
[idnCampoSenha] [bit] NULL,
[tabelaSelecao] [varchar] (50) COLLATE Latin1_General_CI_AS NULL,
[filtroSelecao] [varchar] (500) COLLATE Latin1_General_CI_AS NULL,
[validacaoRegularExpression] [varchar] (100) COLLATE Latin1_General_CI_AS NULL
GO
ALTER TABLE [dbo].[configuracoes] ADD 
[metodoBuscaCEP] [varchar] (20) COLLATE Latin1_General_CI_AS NULL
GO
ALTER TABLE [dbo].[FaturaParcela] ADD 
[percentualDescontoComissao] [decimal] (18,4) NULL,
[idnRenegociada] [bit] NULL,
[parcelaOrigemRenegociacao] [int] NULL
GO
CREATE TABLE [dbo].[ConfiguracaoNovoOpcoes]
(
	[id] [int] IDENTITY (1,1) NOT NULL,
	[nomeParametro] [varchar] (80) COLLATE Latin1_General_CI_AS NOT NULL,
	[descricao] [varchar] (100) COLLATE Latin1_General_CI_AS NULL,
	[valor] [varchar] (100) COLLATE Latin1_General_CI_AS NULL,
	CONSTRAINT [PK_ConfiguracaoNovoOpcoes] PRIMARY KEY CLUSTERED
	(
		[id] 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].[ConfiguracaoNovoOpcoes] ADD CONSTRAINT [FK_ConfiguracaoNovoOpcoes_configuracaoNovo] FOREIGN KEY
	(
		[nomeParametro]
	)
	REFERENCES [dbo].[configuracaoNovo]
	(
		[nomeParametro]
	)
GO
update selecao set filtro = '(dataBaixa is null)' where tabela = 'Servico'
GO
SET IDENTITY_INSERT [dbo].[MenuLateralItens] ON 
GO
INSERT [dbo].[MenuLateralItens] ([id], [idMenu], [descricao], [idTela], [idMenuLateralGrupo], [imagem], [ordem]) VALUES (296, 2, N'Consultar Marketplaces', 317, 22, N'search-2_32.png', 0)
GO
INSERT [dbo].[MenuLateralItens] ([id], [idMenu], [descricao], [idTela], [idMenuLateralGrupo], [imagem], [ordem]) VALUES (297, 2, N'Cadastrar Marketplaces', 316, 22, N'market_32.png', 1)
GO
SET IDENTITY_INSERT [dbo].[MenuLateralItens] OFF
GO
INSERT INTO VERSAO(VERSAO, VERSAOATUALIZACAO, DATAATUALIZACAO) VALUES(440, 698, GETDATE());
