USE [TryNFeOnline]
GO

ALTER TABLE [dbo].[configuracoes] ADD 
[idnSolicitarConfirmacaoFinalizarVenda] [bit] NULL,
[qtdVolumesPadraoVenda] [int] NULL,
[infAdicionaisContribuinteNFCe] [varchar] (500) COLLATE Latin1_General_CI_AS NULL
GO
ALTER TABLE [dbo].[MDeNotas] ADD 
[modFrete] [varchar] (200) COLLATE Latin1_General_CI_AS NULL
GO
ALTER TABLE [dbo].[OrdemServico] ADD 
[codigoApp] [int] NULL
GO
ALTER TABLE [dbo].[OrdemServicoProduto] ADD 
[codigoApp] [int] NULL
GO
ALTER TABLE [dbo].[OrdemServicoServico] ADD 
[codigoApp] [int] NULL
GO
ALTER TABLE [dbo].[parceiro] ADD 
[codigoApp] [int] NULL
GO
CREATE TABLE [dbo].[configuracaoNovo]
(
	[nomeParametro] [varchar] (80) COLLATE Latin1_General_CI_AS NOT NULL,
	[descricaoSimplificada] [varchar] (150) COLLATE Latin1_General_CI_AS NOT NULL,
	[descricaoDetalhada] [varchar] (500) COLLATE Latin1_General_CI_AS NOT NULL,
	[tipoValor] [varchar] (30) COLLATE Latin1_General_CI_AS NULL,
	[valor] [varchar] (max) COLLATE Latin1_General_CI_AS NULL,
	[grupo] [varchar] (50) COLLATE Latin1_General_CI_AS NULL,
	[subgrupo] [varchar] (50) COLLATE Latin1_General_CI_AS NULL,
	CONSTRAINT [PK_configuracaoNovo] PRIMARY KEY CLUSTERED
	(
		[nomeParametro] 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
delete from telas where id = 22
GO
INSERT INTO VERSAO(VERSAO, VERSAOATUALIZACAO, DATAATUALIZACAO) VALUES(424, 682, GETDATE());