--- BEG # 0001
ALTER TABLE `baixa`
  ADD COLUMN `forma_imobil` varchar(3) NULL DEFAULT NULL;
--- END 
--- BEG # 0002
ALTER TABLE `baixa`
  CHANGE COLUMN `forma_imobil` `forma_imobil` char(3) CHARACTER SET latin1 NULL DEFAULT NULL;
--- END 
--- BEG # 0003
CREATE TABLE `transferencia` (
  `registro` bigint(11) NOT NULL default '0',
  `id` bigint(20) NOT NULL default '0',
  `sequencia` bigint(20) default '0',
  `odi` char(10) NOT NULL,
  `conta` char(20) default NULL,
  `odi_anterior` char(10) default NULL,
  `conta_anterior` char(20) default NULL,
  PRIMARY KEY  (`registro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

--- END 
--- BEG # 0004
ALTER TABLE `transferencia`
  ADD COLUMN `depreciacao` double NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `valor_imob` double NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `data_transacao` date NULL DEFAULT NULL;

--- END 
--- BEG # 0005
ALTER TABLE `imob`
  ADD COLUMN `depreciacao_baixa` double NULL DEFAULT NULL;
--- END 
--- BEG # 0006
ALTER TABLE `transferencia`
  ADD COLUMN `depreciacao_baixa` double NULL DEFAULT NULL;
--- END 
--- BEG # 0007
ALTER TABLE `baixa`
  ADD COLUMN `depreciacao_baixa` double NULL DEFAULT NULL;
--- END 
--- BEG # 0008
ALTER TABLE `baixa`
  ADD COLUMN `cota_depreciacao` double NULL DEFAULT NULL;

--- END 
--- BEG # 0009
ALTER TABLE `imob`
  CHANGE COLUMN `tensao_trab` `tensao_trab` double(10,2) NULL DEFAULT NULL;

--- END 
--- BEG # 0010
ALTER TABLE `imob`
  ADD COLUMN `depre_cmc` double(15,2) unsigned NULL DEFAULT 000000000000.00 AFTER `depreciacao_baixa`,
  ADD COLUMN `cota_cmc` double(15,2) unsigned NULL DEFAULT 000000000000.00,
  ADD COLUMN `valor_cmc` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00',
  ADD COLUMN `valor_reav` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00',
  ADD COLUMN `depre_reav` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00',
  ADD COLUMN `cota_reav` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00',
  ADD COLUMN `valor_cme` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00',
  ADD COLUMN `depre_cme` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00',
  ADD COLUMN `cota_cme` double(15,2) unsigned NULL DEFAULT NULL COMMENT '000000000000.00';
--- END 
--- BEG # 0011
CREATE TABLE `custos_odd_vida` (
  `id_custos` int(11) NOT NULL AUTO_INCREMENT,
  `odd` varchar(10) DEFAULT NULL,
  `sub_odd` varchar(10) DEFAULT NULL,
  `valor` double DEFAULT NULL,
  `data_baixa` date DEFAULT NULL,
  `conta_imob` varchar(20) DEFAULT NULL,
  `conta_vida` varchar(20) DEFAULT NULL,
  `tipo` varchar(20) DEFAULT NULL,
  `registro_imob` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_custos`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--- END 
--- BEG # 0012
ALTER TABLE `baixa`
  ADD COLUMN `sub_odi` char(10) NULL DEFAULT NULL;
--- END 
--- BEG # 0013
UPDATE `configuracao` SET `valor`='###.##.#.#.##' WHERE `parametro`='empresa.mascara_conta' AND `valor`='###*##*#*#*##' AND `descricao` IS NULL;
--- END 
--- BEG # 0014
ALTER TABLE `baixa`
  ADD COLUMN `sub_odd` char(10) NULL DEFAULT NULL;
--- END 
--- BEG # 0015
ALTER TABLE `baixa`
  ADD COLUMN `odd` char(10) NULL DEFAULT NULL;
--- END 

--- BEG # 0016
ALTER TABLE `transferencia`
  ADD COLUMN `transf` char(1) NULL DEFAULT 'N';

--- END 
--- BEG # 0017
ALTER TABLE `custos_odd_vida`
  CHANGE COLUMN `conta_imob` `conta_debito` varchar(20) CHARACTER SET latin1 NULL DEFAULT NULL,
  CHANGE COLUMN `conta_vida` `conta_credito` varchar(20) CHARACTER SET latin1 NULL DEFAULT NULL AFTER `conta_debito`;
--- END 
--- BEG # 0018
ALTER TABLE `imob`
  CHANGE COLUMN `descricao_uar` `descricao_uar` varchar(600) CHARACTER SET latin1 NULL DEFAULT NULL;
--- END 
--- BEG # 0019
ALTER TABLE `razao`
  CHANGE COLUMN `saldbtn` `saldbtn` double(23,4) NULL DEFAULT NULL,
  CHANGE COLUMN `debbtn` `debbtn` double(23,4) NULL DEFAULT NULL,
  CHANGE COLUMN `crebtn` `crebtn` double(23,4) NULL DEFAULT NULL;

--- END 
--- BEG # 0021
DROP TABLE `imob_importado`;
/
DROP TABLE `config`;
/
DROP TABLE `tuc`;
/
DROP TABLE `planilha367_importacao`;
/
DROP TABLE `ti`;
/
DROP TABLE `imob1`;
/
DROP TABLE `mes_ativo`;
--- END 
--- BEG # 0023
ALTER TABLE `custos_odd_vida`
  ADD COLUMN `id_tipo_instalacao` int(3) NULL DEFAULT NULL;

--- END 
--- BEG # 0024
ALTER TABLE `imob`
  CHANGE COLUMN `tensao_trab` `tensao_trab` double(6,2) NULL DEFAULT NULL;
--- END 
--- BEG # 0025
ALTER TABLE `imob`
  CHANGE COLUMN `num_ser` `num_ser` char(60) CHARACTER SET latin1 NULL DEFAULT NULL;
--- END 
--- BEG # 0026
ALTER TABLE `imob`
  ADD COLUMN `flg_importado` char(1) NULL DEFAULT NULL;
--- END 
--- BEG # 0027
update imob set odi = lpad(odi, '6', '0');
/
update odi set id = lpad(id, '6', '0');
--- END 
--- BEG # 0028
CREATE TABLE `imob_historico` (
  `id` int(11) NOT NULL DEFAULT '0',
  `sequencia` int(11) NOT NULL DEFAULT '0',
  `conta` varchar(20) DEFAULT NULL,
  `valor_imob` double(12,2) DEFAULT NULL,
  `taxa_depreciacao` double(12,2) DEFAULT NULL,
  `cota_depreciacao` double(12,2) DEFAULT NULL,
  `depreciacao` double(12,2) DEFAULT NULL,
  `quantb` int(11) DEFAULT NULL,
  `transf` char(1) DEFAULT NULL,
  `registro` bigint(1) NOT NULL DEFAULT '0',
  `dia_depre` char(2) NOT NULL DEFAULT '',
  `mes_depre` char(2) NOT NULL DEFAULT '',
  `ano_depre` char(4) NOT NULL DEFAULT '',
  `quantidade` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`,`sequencia`,`registro`,`dia_depre`,`mes_depre`,`ano_depre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--- END 
--- BEG # 0029
alter table `imob` 
   add column `id_lotacao` double DEFAULT '0' NULL after `termo_responsabilidade`, 
   add column `lotacao` varchar(100) NULL after `id_lotacao`
--- END   

--- BEG # 0030
ALTER TABLE `imob`
  CHANGE COLUMN `id_lotacao` `id_lotacao` double NULL DEFAULT '0' AFTER `flg_importado`,
  CHANGE COLUMN `lotacao` `lotacao` varchar(100) NULL DEFAULT NULL AFTER `id_lotacao`;
--- END   
--- BEG # 0031
ALTER TABLE `imob`
  ADD COLUMN `id_material_almox` int(11) NULL DEFAULT NULL;
--- END 
--- BEG # 0033
ALTER TABLE `imob`
  ADD COLUMN `id_usuario` int(11) NULL DEFAULT NULL;
/
ALTER TABLE `imob`
  ADD COLUMN `data_hora_usuario` datetime NULL DEFAULT NULL;
--- END 
--- BEG # 0031
alter table `imob` 
   add column `internacional` tinyint DEFAULT '0' NULL after `modelo`
--- END 
--- BEG # 0032
ALTER TABLE `imob`
  CHANGE COLUMN `internacional` `internacional` tinyint(4) NULL DEFAULT '0' AFTER `data_hora_usuario`;
--- END 
--- BEG # 0034
ALTER TABLE `imob`
  CHANGE COLUMN `id_operacional` `id_operacional` char(40) CHARACTER SET latin1 NULL DEFAULT NULL;
--- END
--- BEG # 0035
UPDATE `cad_tipo_uc` SET `tx_depre`=4.3 WHERE `id_tipo_uc`=345
--- END
--- BEG # 0036
ALTER TABLE `imob`
  CHANGE COLUMN `descricao_uar` `descricao_uar` varchar(650) CHARACTER SET latin1 NULL DEFAULT NULL;
--- END
--- BEG # 0037
UPDATE `patrimonio_genesis`.`cad_tipo_uc` SET `tx_depre`=4.0 WHERE `id_tipo_uc`=345
--- END
--- BEG # 0038
ALTER TABLE `transferencia`
  ADD COLUMN `motivo` varchar(300) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `responsavel` varchar(300) NULL DEFAULT NULL;
--- END
--- BEG # 0039
ALTER TABLE `transferencia`
  ADD COLUMN `quantidade_anterior` int(11) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `quantidade` int(11) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `cota_depreciacao` double NULL DEFAULT NULL;
--- END

--- BEG # 0040
ALTER TABLE `transferencia`
  DROP PRIMARY KEY;
/
ALTER TABLE `transferencia`
ADD COLUMN `id_transf` int(11) NOT NULL AUTO_INCREMENT,
ADD PRIMARY KEY (`id_transf`);
--- END  
--- BEG # 0041
ALTER TABLE `transferencia`
  ADD COLUMN `mes_transf` char(2) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `ano_transf` char(4) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `descricao_uar` varchar(650) NULL DEFAULT NULL;
--- END  

--- BEG # 0042
ALTER TABLE `transferencia`
  ADD COLUMN `id_tipo_instalacao` int(3) NULL DEFAULT NULL AFTER `descricao_uar`,
  ADD COLUMN `id_tipo_uc` int(4) NULL DEFAULT NULL AFTER `id_tipo_instalacao`,
  ADD COLUMN `id_tipo_bem` int(4) NULL DEFAULT NULL AFTER `id_tipo_uc`,
  ADD COLUMN `id_a2` int(3) NULL DEFAULT NULL AFTER `id_tipo_bem`,
  ADD COLUMN `id_a3` int(3) NULL DEFAULT NULL AFTER `id_a2`,
  ADD COLUMN `id_a4` int(4) NULL DEFAULT NULL AFTER `id_a3`,
  ADD COLUMN `id_a5` int(3) NULL DEFAULT NULL AFTER `id_a4`,
  ADD COLUMN `id_a6` int(3) NULL DEFAULT NULL;
--- END

--- BEG # 0044
ALTER TABLE `imob`
  DROP COLUMN `valor_cme`,
  DROP COLUMN `depre_cme`,
  DROP COLUMN `cota_cme`;
--- END
--- BEG # 0045
ALTER TABLE `imob`
  CHANGE COLUMN `internacional` `internacional` int(3) NULL DEFAULT 0;
--- END
--- BEG # 0046
ALTER TABLE `imob`
  CHANGE COLUMN `internacional` `internacional` int(3) NULL DEFAULT '0' AFTER `registro`;
--- END
--- BEG # 0047
ALTER TABLE `transferencia`
  ADD COLUMN `sequencia_transf` int(1) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  ADD COLUMN `ordem_transf` int(11) NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  CHANGE COLUMN `quantidade_anterior` `quantidade_transf` int(11) NULL DEFAULT NULL;
--- END
--- BEG # 0048
ALTER TABLE `transferencia`
  ADD COLUMN `tipo` varchar(15) NULL DEFAULT NULL;
--- END

--- BEG # 0049
ALTER TABLE `transferencia`
  CHANGE COLUMN `quantidade_transf` `quantidade_transf` double NULL DEFAULT NULL;
/
ALTER TABLE `transferencia`
  CHANGE COLUMN `quantidade` `quantidade` double NULL DEFAULT NULL;
--- END

--- BEG # 0050
ALTER TABLE `transferencia`
  ADD COLUMN `mes_imob` char(2) NULL DEFAULT NULL AFTER `quantidade_anterior`,
  ADD COLUMN `ano_imob` char(4) NULL DEFAULT NULL;
--- END
--- BEG # 0051
ALTER TABLE `transferencia`
  ADD COLUMN `id_usuario` int(11) NULL DEFAULT NULL;
--- END
--- BEG # 0052
alter table `baixa` 
   add column `id_material_almox` double DEFAULT '0' NULL after `odd`
--- END   
--- BEG # 0053
CREATE TABLE `centro_custo` (
  `id_centro_custo` int(11) NOT NULL DEFAULT '0',
  `descricao` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id_centro_custo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/
ALTER TABLE `imob`
  ADD COLUMN `id_centro_custo` int(11) NULL DEFAULT NULL;
/
ALTER TABLE `imob`
  ADD COLUMN `descricao_centro_custo` varchar(150) NULL DEFAULT NULL;
/
ALTER TABLE `imob`
  ADD COLUMN `determinacao_conta` varchar(150) NULL DEFAULT NULL;
/
ALTER TABLE `imob`
  ADD COLUMN `chave_pais` varchar(15) NULL DEFAULT NULL;
--- END   
--- BEG # 0054
  ALTER TABLE `imob_historico`
  CHANGE COLUMN `quantidade` `quantidade` double NULL DEFAULT NULL;
--- END
--- BEG # 0056
ALTER TABLE `baixa`
  CHANGE COLUMN `sub_odd` `sub_odd` varchar(40) CHARACTER SET latin1 NULL DEFAULT NULL;
/
ALTER TABLE `baixa`
  CHANGE COLUMN `sub_odd` `sub_odd` varchar(60) CHARACTER SET latin1 NULL DEFAULT NULL;
/
ALTER TABLE `custos_odd_vida` CHANGE `sub_odd` `sub_odd` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ; 
--- END
--- BEG # 0057
ALTER TABLE `imob`
  CHANGE COLUMN `num_ser` `num_ser` varchar(255) CHARACTER SET latin1 NULL DEFAULT NULL;
--- END
--- BEG # 0058
ALTER TABLE `imob`
  ADD COLUMN `potencia_usina` varchar(20) NULL DEFAULT NULL AFTER `chave_pais`,
  ADD COLUMN `tipo_extensao` varchar(255) NULL DEFAULT NULL AFTER `potencia_usina`,
  ADD COLUMN `estrutura_controle` varchar(255) NULL DEFAULT NULL;
--- END
--- BEG # 0059
ALTER TABLE `imob`
  ADD COLUMN `unidade_med_basica` varchar(20) NULL DEFAULT NULL;
--- END
--- BEG # 0060
ALTER TABLE `cad_tabela`
  ADD COLUMN `flg_empresa` char(1) NULL DEFAULT 'N';
--- END
--- BEG # 0062
ALTER TABLE `cad_tipo_bem`
  ADD COLUMN `vida_util` double NULL DEFAULT NULL AFTER `descricao`,
  ADD COLUMN `tx_depre` double NULL DEFAULT NULL AFTER `vida_util`;
--- END

--- BEG # 0063
ALTER TABLE `cad_tipo_bem`
  ADD COLUMN `tx_depre69` double NULL DEFAULT NULL AFTER `tx_depre`;
--- END

--- BEG # 0064
ALTER TABLE `cad_tipo_bem`
  CHANGE COLUMN `tx_depre69` `tx_depre69` double(12,2) NULL DEFAULT NULL;
/
ALTER TABLE `cad_tipo_bem`
  CHANGE COLUMN `tx_depre` `tx_depre` double(12,2) NULL DEFAULT NULL;
/
ALTER TABLE `cad_tipo_bem`
  CHANGE COLUMN `vida_util` `vida_util` double(12,2) NULL DEFAULT NULL;
--- END

--- BEG # 0065
ALTER TABLE `imob`
  ADD INDEX `index_sequencia_imob` (`id`, `sequencia`);
--- END
  
--- BEG # 0066
alter table `centro_custo` 
   add column `centro_custo` varchar(50) NULL after `descricao`, 
   add column `odi` varchar(20) NULL after `centro_custo`, 
   add column `sigla` varchar(20) NULL after `odi`, 
   add column `id_tipo_instalacao` int DEFAULT '0' NULL after `sigla`
--- END   

--- BEG # 0067
ALTER TABLE `centro_custo` 
   CHANGE `id_centro_custo` `id_centro_custo` INT(11) NOT NULL AUTO_INCREMENT
--- END

--- BEG # 0068
ALTER TABLE `baixa`
  ADD COLUMN `depreciacao_soc` double(15,2) NULL DEFAULT NULL AFTER `registro`,
  ADD COLUMN `cota_depreciacao_soc` double(15,2) NULL DEFAULT NULL AFTER `depreciacao_soc`,
  ADD COLUMN `depreciacao_fisc` double(15,2) NULL DEFAULT NULL AFTER `cota_depreciacao_soc`,
  ADD COLUMN `cota_depreciacao_fisc` double(15,2) NULL DEFAULT NULL;
--- END