--- BEG # 0001
ALTER TABLE contabilizacao ADD COLUMN fornecedor_conta CHAR(1) DEFAULT 'N'; 
--- END
--- BEG # 0002
ALTER TABLE contabilizacao ADD COLUMN id_custo INT(11); 
--- END
--- BEG # 0003
ALTER TABLE contabilizacao ADD COLUMN desc_custo VARCHAR(255); 
--- END
--- BEG # 0004
ALTER TABLE entrada_det_custo ADD COLUMN conta_debito VARCHAR(50); 
--- END
--- BEG # 0005
ALTER TABLE entrada_det_custo ADD COLUMN conta_credito VARCHAR(50); 
--- END
--- BEG # 0006
ALTER TABLE entrada  ADD COLUMN id_grupo_tensao INT (11); 
--- END
--- BEG # 0007
ALTER TABLE entrada  ADD COLUMN descr_grupo_tensao VARCHAR (100); 
--- END
--- BEG # 0008
ALTER TABLE entrada  ADD COLUMN id_classe_consumo INT (11); 
--- END
--- BEG # 0009
ALTER TABLE entrada  ADD COLUMN descr_classe_consumo VARCHAR(100); 
--- END
--- BEG # 0010
ALTER TABLE entrada  ADD COLUMN id_tipo_ligacao INT(11); 
--- END
--- BEG # 0011
ALTER TABLE entrada  ADD COLUMN descr_tipo_ligacao VARCHAR(100); 
--- END
--- BEG # 0012
ALTER TABLE entrada  ADD COLUMN id_classe_comunicacao INT(11); 
--- END
--- BEG # 0013
ALTER TABLE entrada  ADD COLUMN descr_classe_comunicacao VARCHAR (100); 
--- END
--- BEG # 0014
ALTER TABLE entrada  ADD COLUMN id_tipo_assinante INT(11); 
--- END
--- BEG # 0015
ALTER TABLE entrada  ADD COLUMN descr_tipo_assinante VARCHAR (100); 
--- END
--- BEG # 0016
ALTER TABLE entrada  ADD COLUMN qtde_forn_energia DOUBLE; 
--- END
--- BEG # 0017
ALTER TABLE entrada  ADD COLUMN vlr_forn_comunicacao DOUBLE; 
--- END
--- BEG # 0018
ALTER TABLE entrada  ADD COLUMN id_origem INT(11); 
--- END
--- BEG # 0019
ALTER TABLE entrada  ADD COLUMN descr_origem VARCHAR(100); 
--- END
--- BEG # 0020
ALTER TABLE entrada  ADD COLUMN id_destino INT(11); 
--- END
--- BEG # 0021
ALTER TABLE entrada ADD COLUMN descr_destino VARCHAR(100); 
--- END
--- BEG # 0022
ALTER TABLE entrada  ADD COLUMN vlr_cofins DOUBLE DEFAULT 0; 
--- END
--- BEG # 0023
ALTER TABLE entrada  ADD COLUMN vlr_PIS DOUBLE DEFAULT 0; 
--- END
--- BEG # 0024
CREATE TABLE `grupo_tensao` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`descricao` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
--- END
--- BEG # 0025
CREATE TABLE `classe_consumo` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`descricao` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
--- END
--- BEG # 0026
CREATE TABLE `classe_consumo_comunicacao` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`descricao` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
--- END
--- BEG # 0027
CREATE TABLE `tipo_assinante` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`descricao` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
--- END
--- BEG # 0028
CREATE TABLE `tipo_nota` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`descricao` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
--- END
--- BEG # 0029
ALTER TABLE entrada  ADD COLUMN id_tipo_nota INT(11); 
--- END
--- BEG # 0030
ALTER TABLE entrada  ADD COLUMN descr_nota VARCHAR (100); 
--- END
--- BEG # 0236
ALTER TABLE entrada ADD COLUMN simples_nacional int(1);
/
INSERT INTO configuracao SET parametro='valida.odc', valor='N',descricao='Valida o campo ODC da DRM na efetivação';
--- END
--- BEG # 0237
ALTER TABLE entrada_det_transp ADD COLUMN data_nf date;
/
ALTER TABLE entrada_det_transp ADD COLUMN desconto double(15,2);
--- END
--- BEG # 0238
DROP TABLE IF EXISTS `entrada_servicos_det`;
CREATE TABLE `entrada_servicos_det` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_entrada_servico` int(11),
  `id_material` int(11),
  `descricao` varchar(255),
  `unidade` varchar(5),
  `cst_icms` varchar(5), 
  `cfop` int(11),
  `ncm_material` varchar(30),
  `quantidade` double(12,5),
  `valor_unitario` double(12,5),
  `aliquota_icms` double(12,5),
  `icms` double(12,5),
  `valor_total` double(12,5),
  `valoricmssubst` double(15,2),
  `desconto_item` double(12,5),
  `parcela_icms` int(2),
  `aliquota_icms_sub` double(12,5),
  PRIMARY KEY (`id`),
  KEY `id_entrada` (`id_entrada_servico`),
  KEY `KEntradaMaterial` (`id_entrada_servico`,`id_material`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/
ALTER TABLE entrada_servicos ADD COLUMN ciap int(1);
/
ALTER TABLE entrada ADD COLUMN codigo_centro_custo int(11);
/
ALTER TABLE entrada_servicos ADD COLUMN codigo_centro_custo int(11);
/
ALTER TABLE entrada_servicos ADD COLUMN observacao VARCHAR (255); 
--- BEG # 0239
ALTER TABLE entrada ADD COLUMN id_odc_vida VARCHAR (50); 
--- END
--- BEG # 0240
ALTER TABLE entrada_servicos ADD COLUMN somente_darf INT(1) DEFAULT 0; 
--- END
--- BEG # 0241
ALTER TABLE fornecedor ADD COLUMN cod_almox VARCHAR(5); 
/
ALTER TABLE fornecedor ADD COLUMN conta_almox_debito VARCHAR(50); 
/
ALTER TABLE fornecedor ADD COLUMN id_natureza INT(11);
/
ALTER TABLE diario ADD COLUMN conta_cred_icms VARCHAR(50);
/
ALTER TABLE diario ADD COLUMN conta_deb_icms VARCHAR(50);
/
ALTER TABLE diario ADD COLUMN valor_icms double(12,5);
--- END
--- BEG # 0242
ALTER TABLE entrada_servicos ADD COLUMN descr_destino VARCHAR(100); 
/
ALTER TABLE entrada_servicos ADD COLUMN descr_origem VARCHAR(100); 
/
ALTER TABLE entrada_servicos ADD COLUMN id_origem INT(11);
/
ALTER TABLE entrada_servicos ADD COLUMN id_destino INT(11);
--- END
--- BEG # 0243
DROP TABLE IF EXISTS `material_fornecedor`;
CREATE TABLE `material_fornecedor` (
  `id_material` int(11),
  `id_fornecedor` int(11),
  `data_ultima_compra` date
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--- END
--- BEG # 0244
ALTER TABLE entrada ADD COLUMN exportar_contabilidade INT(1); 
--- END
--- BEG # 0245
ALTER TABLE entrada_det ADD COLUMN aliqICMS_ST double(15,2); 
/
ALTER TABLE entrada_det ADD COLUMN aliq_IPI double(15,2); 
--- END
--- BEG # 0246
ALTER TABLE entrada ADD COLUMN flag_anular_nf INT(1);
--- END
--- BEG # 0247
ALTER TABLE saida MODIFY COLUMN num_medidor VARCHAR(100);
--- END
--- BEG # 0248
ALTER TABLE entrada_det ADD COLUMN valor_base_difal double(15,2); 
/
ALTER TABLE entrada_det ADD COLUMN valor_base_fecp double(15,2); 
/
ALTER TABLE entrada_det ADD COLUMN valor_base_icms_subst double(15,2); 
--- END
--- BEG # 0249
ALTER TABLE entrada ADD COLUMN valor_total_financeiro double(15,2); 
--- END
--- BEG # 0250
ALTER TABLE entrada ADD COLUMN conta_cartao_credito INT(1); 
--- END
--- BEG # 0251
ALTER TABLE entrada_det ADD COLUMN valor_base_icms double(15,2); 
--- END
--- BEG # 0252
ALTER TABLE entrada_det_transp ADD COLUMN aliqfecp double(5,2); 
/
ALTER TABLE entrada_det_transp ADD COLUMN aliqicms double(5,2); 
/
ALTER TABLE entrada_det_transp ADD COLUMN valoricms double(15,2); 
--- END
--- BEG # 0253
DROP TABLE IF EXISTS `ocorrencias_efetivacao_xml`;
CREATE TABLE `ocorrencias_efetivacao_xml` (
  `arquivo` VARCHAR(255),
  `ocorrencia` VARCHAR(255),
  `numero_nf` VARCHAR(11),
  `id_fornecedor` int(11),
  `valor_nf` double(11,2),
  `nome_fornecedor` VARCHAR(250)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/
ALTER TABLE aux_entrada_xml ADD COLUMN arquivo VARCHAR(255); 
/
ALTER TABLE entrada_servicos ADD COLUMN espelhoODI INT(10); 
/
ALTER TABLE entrada_servicos ADD COLUMN item_imobilizado INT(1); 
/
ALTER TABLE entrada_servicos ADD COLUMN retorno_odi_vida  VARCHAR(10); 
--- END