delete from acessos where codigo=8;
INSERT INTO acessos
    (codigo, descricao)
VALUES
    (8, 'PERMITE ALTERAR O VALOR DO PRODUTO 1');

update produtos set qtde=0 where qtde=null;
alter table pre add if not exists data_entrega date;
alter table pre add if not exists hora_entrega time;

CREATE TABLE IF NOT EXISTS "pre2"
(
   "numero" INTEGER,
   "data" date,
   "hora" time,
   "forma_pagamento" varchar(20),
   "valor_entrada" float,
   "movimento" float,
   "codigo_operador" INTEGER,
   "codigo_func" INTEGER,
   "estornado" BOOLEAN,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Adiantamentos de Pré Venda'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 2
);

alter table pre add if not exists data_entrega date;
alter table pre add if not exists hora_entrega time;
CREATE INDEX IF NOT EXISTS "numero" ON "pre2" ("numero");
CREATE INDEX IF NOT EXISTS "entrega" ON "pre" ("data_entrega","hora_entrega");

alter table pre add if not exists atendente integer;
alter table pre add if not exists nome_atendente varchar(40);
CREATE TABLE IF NOT EXISTS "pre10"
(
   "numero" INTEGER,
   "item" INTEGER,
   "impressora" INTEGER,
   "numero_ticket" INTEGER,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Impressão dos itens que tem guia de produção vinculado'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 1
);
CREATE INDEX IF NOT EXISTS "numero" ON "pre10" ("numero");
CREATE INDEX IF NOT EXISTS "item" ON "pre10" ("item");
CREATE INDEX IF NOT EXISTS "impressora" ON "pre10" ("impressora");

alter table sistema add if not exists contadorpedidos integer;

CREATE TABLE IF NOT EXISTS "cartao_prevenda"
(
   "numero" Autoinc,
   "codbarra" char(13),
   "status_impresso" Boolean,
   "aberto" Boolean,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Cartões para Pre venda'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 1
);
CREATE INDEX IF NOT EXISTS "numero" ON "cartao_prevenda" ("numero");

alter table confignf add if not exists PAYER_login varchar(60);
alter table confignf add if not exists PAYER_Senha varchar(30);
alter table formas add if not exists TEF_PAYER_paymentMethod integer;
alter table formas add if not exists TEF_PAYER_paymentType integer;
alter table formas add if not exists TEF_PAYER_paymentMethodSubType integer;

alter table formas add if not exists percentual_desconto_forma float;

CREATE TABLE IF NOT EXISTS "tef"
(
   "numero" AUTOINC,
   "dh" TIMESTAMP,
   "NSU" VARCHAR(40),
   "valor" FLOAT,
   "Rede_Adquirente" VARCHAR(30),
   "Pagamento_Tipo" VARCHAR(20),
   "Pagamento_Cartao" VARCHAR(30),
   "Codigo_de_Autorizacao" VARCHAR(30),
   "Documento_numero" VARCHAR(20),
   "operacao" INTEGER,
   "txID" VARCHAR(70),
   "E2E" VARCHAR(70),
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Registro de transação TEF'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "numero" ON "tef" ("numero");
CREATE INDEX IF NOT EXISTS "NSU" ON "tef" ("NSU");
CREATE INDEX IF NOT EXISTS "Codigo_de_Autorizacao" ON "tef" ("Codigo_de_Autorizacao");

alter table produtos add if not exists apagado boolean;

update etiq2 set dado='preco' where codigo=61;

alter table confignf add if not exists permite_prod_Sem_Pag boolean;
alter table nfe1 add if not exists naocobrar boolean;

alter table formas add if not exists TEF_PAYGO_Modalidade integer;
alter table formas add if not exists TEF_PAYGO_Tipocartao integer;
alter table formas add if not exists TEF_PAYGO_ModFinanciamento integer;
alter table formas add if not exists TEF_PAYGO_Autorizador varchar(20);

alter table nfe1 add if not exists pDif float;
alter table operacao add if not exists produtospdif float;
alter table operacao add if not exists produtospdifinterest float;
alter table operacao add if not exists produtosignorarprod6 Boolean;

alter table nfe add if not exists enviada_contingencia Boolean;

alter table pre2 add if not exists evento integer;
alter table pre2 add if not exists tpIntegra integer;
alter table pre2 add if not exists CNPJ varchar(20);
alter table pre2 add if not exists indPag integer;
alter table pre2 add if not exists tBand integer;
alter table pre2 add if not exists cAut varchar(10);
alter table pre2 add if not exists NSU varchar(40);

alter table cupom2 add if not exists e2e varchar(40);
alter table pre2 add if not exists e2e varchar(40);

CREATE TABLE IF NOT EXISTS "pix"
(
   "numero" AUTOINC,
   "dh" TIMESTAMP,
   "NSU" VARCHAR(40),
   "valor" FLOAT,
   "Rede_Adquirente" VARCHAR(30),
   "operacao" INTEGER,
   "E2E" VARCHAR(70),
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Registro de transação PIX'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "numero" ON "pix" ("numero");
CREATE INDEX IF NOT EXISTS "nsu" ON "pix" ("NSU");

alter table produtos add if not exists custo_add float;

alter table tef add if not exists cnpj_adquirente varchar(20);

alter table nfe1 add if not exists cstis varchar(3);
alter table nfe1 add if not exists cclasstribis varchar(6);
alter table nfe1 add if not exists aliqis Float;
alter table nfe1 add if not exists aliqisespec Float;
alter table nfe1 add if not exists cstcbs varchar(3);
alter table nfe1 add if not exists cclasstribcbs varchar(6);
alter table nfe1 add if not exists aliqibsuf Float;
alter table nfe1 add if not exists aliqdifibsuf Float;
alter table nfe1 add if not exists vldevtribibsuf Float;
alter table nfe1 add if not exists aliqredibsuf Float;
alter table nfe1 add if not exists aliqefetibsuf Float;
alter table nfe1 add if not exists aliqibsmun Float;
alter table nfe1 add if not exists aliqdifibsmun Float;
alter table nfe1 add if not exists vldevtribibsmun Float;
alter table nfe1 add if not exists aliqredibsmun Float;
alter table nfe1 add if not exists aliefetibsmun Float;
alter table nfe1 add if not exists aliqcbs Float;
alter table nfe1 add if not exists aliqdifcbs Float;
alter table nfe1 add if not exists aliqefetcbs Float;
alter table nfe1 add if not exists vldevtribcbs Float;
alter table nfe1 add if not exists aliqredcbs Float;
alter table nfe1 add if not exists transfcredvibs Float;
alter table nfe1 add if not exists transfcredvcbs Float;
alter table nfe1 add if not exists aliqefetibsmun Float;

alter table confignf add if not exists aliqfixasreformatrib2026 Boolean;
update confignf set aliqfixasreformatrib2026=true;

CREATE TABLE IF NOT EXISTS "prod9"
(
   "codigo" integer,
   "cstis" varchar(3),
   "cclasstribis" varchar(6),
   "aliqis" Float,
   "aliqisespec" Float,
   "cstcbs" varchar(3),
   "cclasstribcbs" varchar(6),
   "aliqibsuf" Float,
   "aliqdifibsuf" Float,
   "vldevtribibsuf" Float,
   "aliqredibsuf" Float,
   "aliqefetibsuf" Float,
   "aliqibsmun" Float,
   "aliqdifibsmun" Float,
   "vldevtribibsmun" Float,
   "aliqredibsmun" Float,
   "aliefetibsmun" Float,
   "aliqcbs" Float,
   "aliqdifcbs" Float,
   "aliqefetcbs" Float,
   "vldevtribcbs" Float,
   "aliqredcbs" Float,
   "aliqefetibsmun" Float,
   "qtde_trib" Float,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Infos Tributarias a partir da reforma tributaria'
LOCALE CODE 0
USER MAJOR VERSION 3
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "codigo" ON "prod9" ("codigo");

insert into acessos (codigo, descricao) values (2100,'EXPORTAR ARQUIVOS CSV PRODUTOS E CLIENTES');
insert into acessos (codigo, descricao) values (2200,'EXPORTAR LISTAGENS DE PRODUTOS E CLIENTES');

CREATE TABLE IF NOT EXISTS "pre8"
(
"numero" integer,
"entrega_endereco" varchar(50),
"entrega_nro" varchar(10),
"entrega_bairro" varchar(30),
"entrega_cidade" varchar(30),
"entrega_uf" varchar(2),
"entrega_cep" varchar(9),
"entrega_complemento" varchar(30),
"entrega_referencia" varchar(60),
"entrega_taxa_entrega" float,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Controle de entrega do pedido - Dados adicionais'
LOCALE CODE 0
USER MAJOR VERSION 3
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "numero" ON "pre8" ("numero");

alter table nfe add if not exists incluir_frete_na_bcicms boolean;
alter table nfe add if not exists incluir_frete_na_bcicmsst boolean;