

--
-- Definition of table `svctasociados`
--

CREATE TABLE `svctasociados` (
  `codaso` varchar(10) default NULL,
  `codfil` varchar(50) default NULL,
  `cedaso` varchar(10) NOT NULL default '''''',
  `apeaso` varchar(25) NOT NULL,
  `nomaso` varchar(25) default NULL,
  `claaso` varchar(50) default NULL,
  `codesp` varchar(50) default NULL,
  `sittra` varchar(50) default NULL,
  `emaaso` varchar(50) default NULL,
  `codcap` varchar(10) NOT NULL,
  `codciu` varchar(3) default NULL,
  `fecnac` date NOT NULL,
  `nomespaso` varchar(30) default NULL,
  `numhij` int(11) NOT NULL,
  `codunipre` varchar(3) default NULL,
  `fecpre` date NOT NULL,
  `telcel` varchar(25) NOT NULL,
  `telhab` varchar(25) NOT NULL,
  `teltra` varchar(25) NOT NULL,
  `faxaso` varchar(25) NOT NULL,
  `dirtra` varchar(100) NOT NULL,
  `nomfot` varchar(50) default NULL,
  `tipfot` varchar(20) default NULL,
  `tamfot` int(11) NOT NULL default '0',
  `datfot` longblob,
  `lugnac` varchar(30) NOT NULL,
  `codded` varchar(3) NOT NULL,
  `pasaso` varchar(100) default NULL,
  `numcar` varchar(10) NOT NULL,
  `stavin` varchar(2) NOT NULL,
  `codest` varchar(3) NOT NULL,
  `codmsms` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctasociados`
--

INSERT INTO `svctasociados` (`codaso`,`codfil`,`cedaso`,`apeaso`,`nomaso`,`claaso`,`codesp`,`sittra`,`emaaso`,`codcap`,`codciu`,`fecnac`,`nomespaso`,`numhij`,`codunipre`,`fecpre`,`telcel`,`telhab`,`teltra`,`faxaso`,`dirtra`,`nomfot`,`tipfot`,`tamfot`,`datfot`,`lugnac`,`codded`,`pasaso`,`numcar`,`stavin`,`codest`,`codmsms`) VALUES 
 ('0000000015','002','5950712','HERNANDEZ ROUTMAN','EDSON ARANTES ','ASOCIADO','001','Ascardio','','001','002','1962-12-05','',2,'006','0000-00-00','04145250905','','02512514390','','CARRERA 17 CON CALLE 12 BARRIO LA FERIA ','','',0,'','','004','202cb962ac59075b964b07152d234b70','H013','SI','011',''),
 ('0000000016','002','4875174','HERNANDEZ SOTO','SERGIO RAMON ','ASOCIADO','001','Ascardio','sergio730@hotmail.com','001','002','1957-09-09','',0,'006','0000-00-00','04145181670','','','','','','',0,'','','004','202cb962ac59075b964b07152d234b70','H014','SI','',''),
 ('0000000017','002','7755068','LEON PIRELA','CARLOS ENRIQUE','ASOCIADO','001','Ascardio','carloslp@icnet.com.ve','001','002','0000-00-00','',0,'006','0000-00-00','04145231912','','','','','','',0,'','','004','202cb962ac59075b964b07152d234b70','L016','SI','',''),
 ('0000000026','002','3317582','RAMIREZ ROJAS ','HERNAN RAFAEL ','TITULAR','002','Ascardio','herraro@hotmail.com','001','002','1947-04-07','GRACIELA DE RAMIREZ',2,'003','1971-11-12','04143503837','0251-2313614','0251-2521395, 2525821','0251-2518398','CARRERA 17 CON CALLE 12 BARRIO LA FERIA ','','',0,'','BARQUISIMETO','004','202cb962ac59075b964b07152d234b70','R006','SI','',''),
 ('0000000027','002','','RAMOS','PEDRO','ASOCIADO','001','Ascardio','sinemail@hotmail.com','001','002','0000-00-00','',0,'006','0000-00-00','','','','','','','',0,'','','004','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000030','002','','SANCHEZ','LUIS','ASOCIADO','001','Ascardio','sinemail@hotmail.com','001','002','0000-00-00','',0,'006','0000-00-00','','','','','','','',0,'','','001','202cb962ac59075b964b07152d234b70','-','NO','',''),
 ('0000000031','002','','TERAN PEREZ','JESUS ENRIQUE','ASOCIADO','001','Ascardio','jesterper@hotmail.com','001','002','0000-00-00','',0,'006','0000-00-00','04166510089','','','','','DR. TERAN JESUS.JPG','image/pjpeg',54609,0x[encoded data, 149460 characters],'','004','202cb962ac59075b964b07152d234b70','T004','SI','',''),
 ('0000000032','002','3317582','TORRES MOGOLLON ','WILLIAM RAMON','ASOCIADO','001','Ascardio','','001','002','1954-02-16','',0,'006','0000-00-00','04167503159','','','','','DR. TORRES WILLIAM.JPG','image/pjpeg',53418,0x[encoded data, 146200 characters],'','003','202cb962ac59075b964b07152d234b70','T010','SI','','');
INSERT INTO `svctasociados` (`codaso`,`codfil`,`cedaso`,`apeaso`,`nomaso`,`claaso`,`codesp`,`sittra`,`emaaso`,`codcap`,`codciu`,`fecnac`,`nomespaso`,`numhij`,`codunipre`,`fecpre`,`telcel`,`telhab`,`teltra`,`faxaso`,`dirtra`,`nomfot`,`tipfot`,`tamfot`,`datfot`,`lugnac`,`codded`,`pasaso`,`numcar`,`stavin`,`codest`,`codmsms`) VALUES 
 ('0000000042','002','3377346','GONZALEZ HERNANDEZ','RODOLFO ENRIQUE','ASOCIADO','001','Centro Clínico Quirúrgico de San Felipe','rodoenrique@gmail.com','001','002','1953-10-31','',0,'006','0000-00-00','04168546522','','','','','','',0,'','','004','202cb962ac59075b964b07152d234b70','G036','SI','',''),
 ('0000000047','002','6.316.388','SAAVEDRA MANZANO','LEONARDO ENRIQUE ','ASOCIADO','001','Ascardio','leonardosaavedra@interlink.net.ve','002','002','1966-08-25','',1,'002','1993-12-15','04145213599','','02512522592','02512518398','Prolongacion carrera 17 con calle 12','','',0,'','SAN CRISTOBAL','004','202cb962ac59075b964b07152d234b70','S001','SI','',''),
 ('0000000057','006','4.669.765','ASCANIO MORILLO','RAFAEL VICENTE','ASOCIADO','001','','rasfacan@cantv.net','002','','2007-03-30','',0,'006','2007-03-30','04144949555','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000058','003','2550548','DURAN DELGADO ','DUMAR ODEXER','TITULAR','002','','dodurand@gmail.com','002','006','1948-10-30','',0,'006','2007-04-02','','','02742639611','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000059','003','2755991','CARDENAS DAVILA','CARLOS GUILLERMO','TITULAR','001','','cgcardenas@email.com','001','006','1947-06-28','',0,'006','2007-04-02','04143740598','','02742638540','02742637015','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000060','003','2979204','CARRASCO GUERRA ','HUGO ANTONIO','TITULAR','001','','hacg7891@hotmail.com','002','006','1944-02-08','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','015','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000061','003','2139801','DONIS HERNANDEZ ','JOSE HIPOLITO','TITULAR','001','','donisj@cantv.net','002','006','1945-08-13','',0,'006','2007-04-02','04161754975','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000062','003','2455289','GARCIA MULLER ','MIGUEL ROBERTO ','TITULAR','001','','','002','006','1941-12-03','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','015','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000063','003','676226','INGLESSIS VARELA ','GEORGE','TITULAR','001','','georgeinglessis@mipunto.com','002','006','1934-03-04','',0,'006','2007-04-02','04147440903','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000065','009','3752540','PARADA FUENTES','HENRY','TITULAR','002','','henryparadafuentes1102@gmail.com','006','002','1955-02-11','',0,'004','2007-04-02','04145670049','0273-2220460','0273-4004529','','Clínica Nuestra Señora del Pilar, 1er piso, cons. 9. Mérida',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000066','003','5463460','NAVARRO PARADA','ALEXIS EDUARDO ','TITULAR','002','','anavarro@valmorca.com.ve','002','006','2007-04-02','',0,'006','2007-04-02','04143744198','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000067','003','3159680','PACHECO ALVAREZ','JOSE ANTONIO','TITULAR','002','','japacheco@intercable.net.ve','002','006','1948-04-16','',0,'006','2007-04-02','04143744199','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000068','003','3524461','PRATO ROJAS ','CARMEN MAGDALENA ','TITULAR','002','','carprak@intercable.net.ve','002','006','1950-09-14','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','016','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000070','003','2848382','SARDI SCHOONEWOLF','EDGARD GALENO','TITULAR','002','','galesardi@hotmail.com','002','006','1942-05-05','',0,'006','2007-04-02','04143748111','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000071','003','10718105','CARRASCO VERDU ','HUGO','TITULAR','001','','hrcv@msn.com','002','006','2007-04-02','',0,'006','2007-04-02','04162747084','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000072','009','1106460','CASAL PEREZ','SERVIO TULIO','ASOCIADO','001','','','002','023','1935-09-05','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','015','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000073','003','','DAVILA SPINETTI','DIEGO F.','TITULAR','001','','diegod@ula.ve','002','006','1944-06-13','',0,'006','2007-04-02','04143743948','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000074','009','4260919','DESPUJOS CARDILLO','JOSE ANTONIO','ASOCIADO','001','','despujos@cantv.net','002','','1954-01-21','',0,'006','2007-04-02','04145596591','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000075','003','5197314','DELGADO SANCHEZ ','MARY DEL SOCORRO ','TITULAR','001','','mary_ve@yahoo.es','002','006','1957-05-22','',0,'006','2007-04-02','04147469442','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000076','009','3321887','GIMENEZ DE FREITEZ','MIREYA','ASOCIADO','002','Acarigua-Araure, Estado Portuguesa','fregim@cantv.net','002','','1946-01-28','Francisco P. FrÃ©itez Ruiz',2,'002','1974-12-20','04143550954','0255-6643408','0255-8084726','0255-6640760','Centro Integrado de Salud Araure.  Av. 23 cruce calle 2, Araure 3301.',NULL,NULL,0,NULL,'Barquisimeto','','48b1a9461ffc1f44937526f76b13ef9a','-','SI','',''),
 ('0000000077','009','4241242','GOMEZ SCOTT DE PEREIRA','CARMEN COROMOTO','ASOCIADO','001','','ogomez_1@cantv.net','002','','1956-09-08','',0,'006','2007-04-02','04145697744','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000078','003','3767730','FUENMAYOR AROCHA','ABDEL JOSE','ASOCIADO','001','','ajf@cantv.net','007','006','1956-05-27','',0,'006','2007-04-02','04143742647','','','','',NULL,NULL,0,NULL,'','004','202cb962ac59075b964b07152d234b70','-','SI','012',''),
 ('0000000079','003','','GUILLEN DE MENDOZA ','SOAIRA','ASOCIADO','001','','','015','006','2007-04-02','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','015','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000080','009','3691281','GONZALEZ OCHOA','NESTOR JOSE','ASOCIADO','001','','ngo@cantv.net','002','','1953-05-16','',0,'006','2007-04-02','04145576453','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000081','003','3401056','MOLINA ALEMAN ','CESAR AUGUSTO ','ASOCIADO','002','','','002','006','1948-05-12','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','016','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000082','003','4352097','MORENO PINEDA ','ADOLFO S. ','ASOCIADO','002','','','002','006','1956-01-13','',0,'006','2007-04-02','','','','','',NULL,NULL,0,NULL,'','016','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000083','009','4929354','MENDEZ MENDOZA','OSWALD ALFONSO','ASOCIADO','001','','omendez@telcel.net.ve','002','','1960-07-12','',0,'006','2007-04-02','04143733483','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000084','003','8715423','NUÑEZ MEDINA ','TULIO JOSE ','ASOCIADO','002','','tuliojose_nm@hotmail.com','002','006','1968-03-11','',0,'006','2007-04-02','04161769757','','','','',NULL,NULL,0,NULL,'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000085','009','8068533','NORCINI CORONA DE PISELLI','DOMENICA','ASOCIADO','002','','','002','','1963-07-23','',0,'006','2007-04-02','04145756200','','','','','DRA. NORCINI DOMENICA.JPG','image/pjpeg',52709,0x[encoded data, 144260 characters],'','','202cb962ac59075b964b07152d234b70','-','SI','',''),
 ('0000000086','003','15367098','ODREMAN MACCHIOLI','RODOLFO OSCAR ','ASOCIADO','002','','odremanr@cantv.net','002','006','1966-08-09','',0,'006','2007-04-02','04149788731','','','','','DR. ODREMAN RODOLFO.JPG','image/pjpeg',58867,0x[encoded data, 72118 characters]