ALTER TABLE `recibos` CHANGE `emi` `emi` BIGINT(20) NOT NULL;
ALTER TABLE `usuario` CHANGE `ser_exe` `ser_exe` BIGINT(20) NOT NULL, CHANGE `seg_vida` `seg_vida` BIGINT(20) NOT NULL, CHANGE `emi` `emi` BIGINT(20) NOT NULL;
ALTER TABLE `recibos_servicios` ADD `poliza` BIGINT(20) NOT NULL AFTER `revisado`, ADD `extra` BIGINT(20) NOT NULL AFTER `poliza`, ADD `exe` BIGINT(20) NOT NULL AFTER `extra`, ADD `seg_vida` BIGINT(20) NOT NULL AFTER `exe`;
ALTER TABLE `servicios` ADD `poliza` BIGINT(20) NOT NULL AFTER `obser`, ADD `extra` BIGINT(20) NOT NULL AFTER `poliza`, ADD `exe` BIGINT(20) NOT NULL AFTER `extra`, ADD `seg_vida` BIGINT(20) NOT NULL AFTER `exe`, ADD `tipo_pago` INT(1) NOT NULL AFTER `seg_vida`, ADD `ofi` VARCHAR(20) NOT NULL AFTER `tipo_pago`, ADD `dia_consig` INT(2) NOT NULL AFTER `ofi`, ADD `mes_consig` INT(2) NOT NULL AFTER `dia_consig`, ADD `ano_consig` INT(4) NOT NULL AFTER `mes_consig`;
ALTER TABLE `recibos_servicios` ADD `nrot` BIGINT(20) NOT NULL AFTER `seg_vida`, ADD `us` VARCHAR(20) NOT NULL AFTER `nrot`;
ALTER TABLE `cta` ADD `resolucion` VARCHAR(150) NOT NULL AFTER `diferencia`, ADD `prefijo` VARCHAR(10) NOT NULL AFTER `resolucion`;

UPDATE recibos_servicios SET exe = valor WHERE recibos_servicios.valor != 0


resolucion
prefijo


CREATE TABLE `recibos_servicios` (
  `id_recibo` bigint(20) NOT NULL DEFAULT '0',
  `cc` bigint(15) NOT NULL,
  `dia` int(2) NOT NULL DEFAULT '0',
  `mes` int(2) NOT NULL DEFAULT '0',
  `ano` int(4) NOT NULL DEFAULT '0',
  `mes_pago` int(2) NOT NULL DEFAULT '0',
  `ano_pago` int(4) NOT NULL DEFAULT '0',
  `tipo_pago` int(1) NOT NULL DEFAULT '0',
  `valor_mensaj` varchar(10) NOT NULL,
  `valor_total` bigint(10) NOT NULL,
  `banco` int(1) NOT NULL DEFAULT '0',
  `ofi` varchar(100) NOT NULL,
  `dia_consig` int(2) NOT NULL DEFAULT '0',
  `mes_consig` int(2) NOT NULL DEFAULT '0',
  `ano_consig` int(4) NOT NULL DEFAULT '0',
  `vr_descuen` bigint(20) NOT NULL DEFAULT '0',
  `descuen` varchar(150) NOT NULL,
  `revisado` int(1) NOT NULL,
  `poliza` bigint(20) NOT NULL,
  `extra` bigint(20) NOT NULL,
  `exe` bigint(20) NOT NULL,
  `seg_vida` bigint(20) NOT NULL,
  `nrot` bigint(20) NOT NULL,
  `us` varchar(20) NOT NULL,
  `act` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `recibos_servicios`
--
ALTER TABLE `recibos_servicios`
  ADD PRIMARY KEY (`id_recibo`,`cc`);
COMMIT;



CREATE TABLE `servicios` (
  `cc` bigint(25) NOT NULL,
  `tipo_serv` varchar(50) NOT NULL DEFAULT '0',
  `tipo_c` char(1) NOT NULL,
  `nom1` varchar(25) NOT NULL,
  `nom2` varchar(25) NOT NULL,
  `apell1` varchar(25) NOT NULL,
  `apell2` varchar(25) NOT NULL,
  `dia_nac` int(2) NOT NULL DEFAULT '0',
  `mes_nac` int(2) NOT NULL DEFAULT '0',
  `ano_nac` int(4) NOT NULL DEFAULT '0',
  `dir` varchar(50) NOT NULL,
  `tel` varchar(25) NOT NULL,
  `tel2` varchar(25) NOT NULL,
  `email` varchar(50) NOT NULL,
  `retiro_total` int(11) NOT NULL DEFAULT '0',
  `valor` bigint(10) NOT NULL,
  `ser_exe_admon` bigint(20) NOT NULL DEFAULT '0',
  `ser_exe_adicio` int(1) NOT NULL DEFAULT '0',
  `ser_exe_canti` int(2) NOT NULL DEFAULT '0',
  `dia_contrato` int(2) NOT NULL DEFAULT '0',
  `mes_contrato` int(2) NOT NULL DEFAULT '0',
  `ano_contrato` int(4) NOT NULL DEFAULT '0',
  `empresa` varchar(65) NOT NULL,
  `obser` varchar(200) NOT NULL,
  `poliza` bigint(20) NOT NULL,
  `extra` bigint(20) NOT NULL,
  `exe` bigint(20) NOT NULL,
  `seg_vida` bigint(20) NOT NULL,
  `tipo_pago` int(1) NOT NULL,
  `ofi` varchar(20) NOT NULL,
  `dia_consig` int(2) NOT NULL,
  `mes_consig` int(2) NOT NULL,
  `ano_consig` int(4) NOT NULL,
  `act` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `servicios`
--
ALTER TABLE `servicios`
  ADD PRIMARY KEY (`cc`);
COMMIT;