# +=================================================================== # | # | Generado el 27-06-2015 a las 11:06:50 AM # | Servidor: localhost # | MySQL Version: 5.1.37 # | PHP Version: 5.3.0 # | Base de datos: 'regnom' # | Tablas: [0] => resultados1; [1] => resultados2; [2] => resultados3; [3] => resultados4; [4] => resultados5; [5] => resultados6; [6] => resultados7 # | # +------------------------------------------------------------------- # | Carga de datos de la tabla 'direccion' # +-------------------------------------> INSERT INTO direccion VALUES ('11', '28', '1985', '2479', 'GAZP7505058A7', 'alvaro obregon', 'conocido', 'sn', 'sn', 'sc', '8793489', '7598237', '57paty@patito', '2015-06-25 21:11:05', '2015-06-25 21:11:05', NULL) ON DUPLICATE KEY UPDATE codest='28',codmpio='1985',codcol='2479',delegacion='alvaro obregon',domicilio='conocido',numext='sn',numint='sn',codpos='sc',casatel='8793489',celtel='7598237',email='57paty@patito',log_add='2015-06-25 21:11:05',log_mod='2015-06-25 21:11:05',log_us=NULL; INSERT INTO direccion VALUES ('12', '28', '1995', '2643', 'PACM1405053H2', '', 'conocido', 'x', 'x', 'x', '', '', '', '2015-06-25 21:28:53', '2015-06-25 21:28:53', NULL) ON DUPLICATE KEY UPDATE codest='28',codmpio='1995',codcol='2643',delegacion='',domicilio='conocido',numext='x',numint='x',codpos='x',casatel='',celtel='',email='',log_add='2015-06-25 21:28:53',log_mod='2015-06-25 21:28:53',log_us=NULL; INSERT INTO direccion VALUES ('13', '28', '1981', '3179', 'MALM150601KE0', '', 'conocido', '34', '', '', '', '', '', '2015-06-25 21:32:46', '2015-06-25 21:32:46', NULL) ON DUPLICATE KEY UPDATE codest='28',codmpio='1981',codcol='3179',delegacion='',domicilio='conocido',numext='34',numint='',codpos='',casatel='',celtel='',email='',log_add='2015-06-25 21:32:46',log_mod='2015-06-25 21:32:46',log_us=NULL; INSERT INTO direccion VALUES ('14', '28', '2018', '856', 'OETP880406DK7', '', '39 y 40 Doblado', '0', '', '87078', '', '', '', '2015-06-26 08:37:54', '2015-06-26 08:37:54', NULL) ON DUPLICATE KEY UPDATE codest='28',codmpio='2018',codcol='856',delegacion='',domicilio='39 y 40 Doblado',numext='0',numint='',codpos='87078',casatel='',celtel='',email='',log_add='2015-06-26 08:37:54',log_mod='2015-06-26 08:37:54',log_us=NULL; INSERT INTO direccion VALUES ('15', '28', '2018', '937', 'OETJ7712059I9', '', 'LOMA DEL CASTILLO', '126', '', '87134', '', '', '', '2015-06-26 08:53:36', '2015-06-26 08:53:36', NULL) ON DUPLICATE KEY UPDATE codest='28',codmpio='2018',codcol='937',delegacion='',domicilio='LOMA DEL CASTILLO',numext='126',numint='',codpos='87134',casatel='',celtel='',email='',log_add='2015-06-26 08:53:36',log_mod='2015-06-26 08:53:36',log_us=NULL; # | Carga de datos de la tabla 'generales' # +-------------------------------------> INSERT INTO generales VALUES ('11', '1', '1', '3,', 'patricia', 'garcia', 'zalapa', '1975-05-05', 'F', 'GAZP7505058A7', 'x', NULL, '2015-06-26 08:52:36', '2015-06-25 21:11:05', '1') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codservmed='3,',nombre='patricia',apaterno='garcia',amaterno='zalapa',fecha_nac='1975-05-05',sexo='F',curp='x',log_us=NULL,log_mod='2015-06-26 08:52:36',log_add='2015-06-25 21:11:05',hab='1'; INSERT INTO generales VALUES ('12', '1', '1', '9,', 'miguel angel', 'padron', 'del carmen', '2014-05-05', 'M', 'PACM1405053H2', 'x', NULL, '2015-06-26 08:52:20', '2015-06-25 21:28:53', '1') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codservmed='9,',nombre='miguel angel',apaterno='padron',amaterno='del carmen',fecha_nac='2014-05-05',sexo='M',curp='x',log_us=NULL,log_mod='2015-06-26 08:52:20',log_add='2015-06-25 21:28:53',hab='1'; INSERT INTO generales VALUES ('13', '1', '1', '7,', 'marisol', 'martinez', 'lopez', '2015-06-01', 'F', 'MALM150601KE0', 'x', NULL, '2015-06-26 08:52:09', '2015-06-25 21:32:46', '1') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codservmed='7,',nombre='marisol',apaterno='martinez',amaterno='lopez',fecha_nac='2015-06-01',sexo='F',curp='x',log_us=NULL,log_mod='2015-06-26 08:52:09',log_add='2015-06-25 21:32:46',hab='1'; INSERT INTO generales VALUES ('14', '1', '1', '10,', 'PEDRO EDUARDO', 'OLVERA', 'TREJO', '1988-04-06', 'M', 'OETP880406DK7', 'x', NULL, '2015-06-26 08:39:58', '2015-06-26 08:37:53', '1') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codservmed='10,',nombre='PEDRO EDUARDO',apaterno='OLVERA',amaterno='TREJO',fecha_nac='1988-04-06',sexo='M',curp='x',log_us=NULL,log_mod='2015-06-26 08:39:58',log_add='2015-06-26 08:37:53',hab='1'; INSERT INTO generales VALUES ('15', '1', '1', '9,', 'JORGE ALBERTO', 'OLVERA', 'TREJO', '1977-12-05', 'M', 'OETJ7712059I9', 'x', NULL, '2015-06-26 08:53:36', '2015-06-26 08:53:36', '1') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codservmed='9,',nombre='JORGE ALBERTO',apaterno='OLVERA',amaterno='TREJO',fecha_nac='1977-12-05',sexo='M',curp='x',log_us=NULL,log_mod='2015-06-26 08:53:36',log_add='2015-06-26 08:53:36',hab='1'; # | Carga de datos de la tabla 'resultados1' # +-------------------------------------> INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '1', '1', '2', NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:00', '2015-06-25 21:30:00') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='1',codres='1',resnum='2',restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:00',log_add='2015-06-25 21:30:00'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '2', '2', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:00', '2015-06-25 21:30:00') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='2',codres='2',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:00',log_add='2015-06-25 21:30:00'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '3', '3', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='3',codres='3',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '4', '5', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='4',codres='5',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '5', '7', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='5',codres='7',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '6', '8', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='6',codres='8',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '7', '10', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='7',codres='10',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '8', '12', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='8',codres='12',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '9', '15', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='9',codres='15',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '10', '18', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='10',codres='18',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '12', 'PACM1405053H2', '1', '11', '22', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:30:01', '2015-06-25 21:30:01') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='12',rfc='PACM1405053H2',codregnom='1',codpre='11',codres='22',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:30:01',log_add='2015-06-25 21:30:01'; INSERT INTO `resultados1` VALUES ('1', '1', '13', 'MALM150601KE0', '1', '1', '1', '0', NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:33:21', '2015-06-25 21:33:21') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='13',rfc='MALM150601KE0',codregnom='1',codpre='1',codres='1',resnum='0',restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:33:21',log_add='2015-06-25 21:33:21'; INSERT INTO `resultados1` VALUES ('1', '1', '13', 'MALM150601KE0', '1', '2', '2', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:33:21', '2015-06-25 21:33:21') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='13',rfc='MALM150601KE0',codregnom='1',codpre='2',codres='2',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:33:21',log_add='2015-06-25 21:33:21'; INSERT INTO `resultados1` VALUES ('1', '1', '13', 'MALM150601KE0', '1', '4', '5', NULL, NULL, NULL, NULL, '2015-06-25', '::1,', NULL, '2015-06-25 21:33:21', '2015-06-25 21:33:21') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='13',rfc='MALM150601KE0',codregnom='1',codpre='4',codres='5',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-25',ip_cli='::1,',log_us=NULL,log_mod='2015-06-25 21:33:21',log_add='2015-06-25 21:33:21'; # | Carga de datos de la tabla 'resultados2' # +-------------------------------------> # | Carga de datos de la tabla 'resultados3' # +-------------------------------------> # | Carga de datos de la tabla 'resultados4' # +-------------------------------------> INSERT INTO `resultados4` VALUES ('1', '1', '14', 'OETP880406DK7', '4', '44', '85', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:38:22', '2015-06-26 08:38:22') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='14',rfc='OETP880406DK7',codregnom='4',codpre='44',codres='85',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:38:22',log_add='2015-06-26 08:38:22'; INSERT INTO `resultados4` VALUES ('1', '1', '14', 'OETP880406DK7', '4', '45', '86', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:38:22', '2015-06-26 08:38:22') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='14',rfc='OETP880406DK7',codregnom='4',codpre='45',codres='86',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:38:22',log_add='2015-06-26 08:38:22'; INSERT INTO `resultados4` VALUES ('1', '1', '14', 'OETP880406DK7', '4', '45', '87', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:38:22', '2015-06-26 08:38:22') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='14',rfc='OETP880406DK7',codregnom='4',codpre='45',codres='87',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:38:22',log_add='2015-06-26 08:38:22'; INSERT INTO `resultados4` VALUES ('1', '1', '14', 'OETP880406DK7', '4', '45', '88', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:38:22', '2015-06-26 08:38:22') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='14',rfc='OETP880406DK7',codregnom='4',codpre='45',codres='88',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:38:22',log_add='2015-06-26 08:38:22'; INSERT INTO `resultados4` VALUES ('1', '1', '14', 'OETP880406DK7', '4', '46', '91', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:38:22', '2015-06-26 08:38:22') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='14',rfc='OETP880406DK7',codregnom='4',codpre='46',codres='91',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:38:22',log_add='2015-06-26 08:38:22'; # | Carga de datos de la tabla 'resultados5' # +-------------------------------------> INSERT INTO `resultados5` VALUES ('1', '1', '15', 'OETJ7712059I9', '5', '61', '122', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:54:05', '2015-06-26 08:54:05') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='15',rfc='OETJ7712059I9',codregnom='5',codpre='61',codres='122',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:54:05',log_add='2015-06-26 08:54:05'; INSERT INTO `resultados5` VALUES ('1', '1', '15', 'OETJ7712059I9', '5', '62', '123', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:54:05', '2015-06-26 08:54:05') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='15',rfc='OETJ7712059I9',codregnom='5',codpre='62',codres='123',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:54:05',log_add='2015-06-26 08:54:05'; INSERT INTO `resultados5` VALUES ('1', '1', '15', 'OETJ7712059I9', '5', '62', '124', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:54:05', '2015-06-26 08:54:05') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='15',rfc='OETJ7712059I9',codregnom='5',codpre='62',codres='124',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:54:05',log_add='2015-06-26 08:54:05'; INSERT INTO `resultados5` VALUES ('1', '1', '15', 'OETJ7712059I9', '5', '63', '125', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:54:05', '2015-06-26 08:54:05') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='15',rfc='OETJ7712059I9',codregnom='5',codpre='63',codres='125',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:54:05',log_add='2015-06-26 08:54:05'; INSERT INTO `resultados5` VALUES ('1', '1', '15', 'OETJ7712059I9', '5', '63', '126', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:54:05', '2015-06-26 08:54:05') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='15',rfc='OETJ7712059I9',codregnom='5',codpre='63',codres='126',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:54:05',log_add='2015-06-26 08:54:05'; INSERT INTO `resultados5` VALUES ('1', '1', '15', 'OETJ7712059I9', '5', '64', '129', NULL, NULL, NULL, NULL, '2015-06-26', '::1,', NULL, '2015-06-26 08:54:05', '2015-06-26 08:54:05') ON DUPLICATE KEY UPDATE codjuris='1',codumed='1',codgen='15',rfc='OETJ7712059I9',codregnom='5',codpre='64',codres='129',resnum=NULL,restxt=NULL,restexto=NULL,resfch=NULL,fchres='2015-06-26',ip_cli='::1,',log_us=NULL,log_mod='2015-06-26 08:54:05',log_add='2015-06-26 08:54:05'; # | Carga de datos de la tabla 'resultados6' # +-------------------------------------> # | Carga de datos de la tabla 'resultados7' # +------------------------------------->