GO
CREATE TABLE [dbo].[tbl_ConfiguracoesValor] (
    [Id]           INT             NOT NULL IDENTITY,
    [IndTipoOpcao] VARCHAR (50)    NOT NULL,
    [DiasSemana]   VARCHAR (50)    NULL,
    [Valor]        DECIMAL (18, 4) NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

GO
ALTER TABLE [dbo].[tbl_Comandas]
    ADD [DescricaoExtra] VARCHAR (30) NULL,
        [OpcaoExtra]     VARCHAR (15) NULL;

GO
ALTER TABLE [dbo].[tbl_Configuracoes]
    ADD [DescricaoLivre]  VARCHAR (30)    NULL,
        [DescricaoExtra1] VARCHAR (30)    NULL,
        [ValorExtra1]     DECIMAL (18, 4) NULL,
        [IdnExibirExtra1] BIT             NULL,
        [IdnPesarExtra1]  BIT             NULL,
        [DescricaoExtra2] VARCHAR (30)    NULL,
        [ValorExtra2]     DECIMAL (18, 4) NULL,
        [IdnExibirExtra2] BIT             NULL,
        [IdnPesarExtra2]  BIT             NULL,
        [DescricaoExtra3] VARCHAR (30)    NULL,
        [ValorExtra3]     DECIMAL (18, 4) NULL,
        [IdnExibirExtra3] BIT             NULL,
        [IdnPesarExtra3]  BIT             NULL,
        [DescricaoExtra4] VARCHAR (30)    NULL,
        [ValorExtra4]     DECIMAL (18, 4) NULL,
        [IdnExibirExtra4] BIT             NULL,
        [IdnPesarExtra4]  BIT             NULL;

GO
UPDATE [dbo].[tbl_Configuracoes]
    SET [DescricaoLivre] = 'BUFFET LIVRE',
        [IdnExibirExtra1] = 0,
        [IdnPesarExtra1] = 0,
        [IdnExibirExtra2] = 0,
        [IdnPesarExtra2] = 0,
        [IdnExibirExtra3] = 0,
        [IdnPesarExtra3] = 0,
        [IdnExibirExtra4] = 0,
        [IdnPesarExtra4] = 0;

GO
INSERT INTO [dbo].[tbl_Versao] (Versao, VersaoMinimaTryerp, DataAtualizacao) VALUES (5, 490, getdate());