INSERT INTO `svctpostgrados` (`codpos`,`nompos`,`codciu`,`coduni`,`corpos`,`dirpos`,`anofun`,`reqingpos`,`reshis`,`infcon`,`nomfot`,`tipfot`,`tamfot`,`datfot`,`estpriano`,`estsegano`,`estterano`,`codins`) VALUES 
 ('0000000003','hggjhgh','002','006','gjhg','ghjghj',1930,'gjhghj','jgjhgj','hgjh','','',0,'',0,0,0,'013'),
 ('0000000004','asdasd','002','006','ghjgjhg','jhgjhgjhgj',1930,'hjgjhg','jhghjg','hjghj','abbyroad.jpg','image/jpeg',2244,0x[encoded data, 6144 characters],0,0,0,'013');


--
-- Definition of table `svctpublicaci`
--

CREATE TABLE `svctpublicaci` (
  `codpub` varchar(10) NOT NULL default '',
  `nompub` varchar(50) default NULL,
  `tippub` varchar(20) default NULL,
  `urlpub` varchar(120) default NULL,
  `nomfot` varchar(50) default NULL,
  `tipfot` varchar(20) NOT NULL,
  `tamfot` int(11) NOT NULL,
  `datfot` longblob NOT NULL,
  `stagra` varchar(2) default NULL,
  `staven` varchar(2) NOT NULL,
  `codreg` varchar(3) NOT NULL,
  PRIMARY KEY  (`codpub`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctpublicaci`
--

INSERT INTO `svctpublicaci` (`codpub`,`nompub`,`tippub`,`urlpub`,`nomfot`,`tipfot`,`tamfot`,`datfot`,`stagra`,`staven`,`codreg`) VALUES 
 ('0000000001','Revista Argentina','Revista','http://www.fac.org.ar/1/revista/index.php','revimic.gif','image/gif',7986,0x[encoded data, 21860 characters],'SI','NO','001'),
 ('0000000002','Cardiology','Revista','http://speedracer.acc.org/absolutebm/abmc.aspx?b=10','002.gif','image/gif',10785,0x[encoded data, 29520 characters],'NO','SI','001'),
 ('0000000003','REVISTA VENEZOLANA DE ONCOLOGIA','Revista','http://www.ateproca.com/dyncat.cfm?catid=232','003.jpg','image/jpeg',6184,0x[encoded data, 16932 characters],'SI','SI','001'),
 ('0000000004','Revista HEMOS','Revista','http://www.ateproca.com/dyncat.cfm?catid=101','004.jpg','image/jpeg',31119,0x[encoded data, 85168 characters],'SI','SI','001');
INSERT INTO `svctpublicaci` (`codpub`,`nompub`,`tippub`,`urlpub`,`nomfot`,`tipfot`,`tamfot`,`datfot`,`stagra`,`staven`,`codreg`) VALUES 
 ('0000000005','Avances Cardiologicos','Revista','http://www.ateproca.com/dyncat.cfm?catid=231','005.jpg','image/jpeg',24756,0x[encoded data, 67756 characters],'SI','SI','001'),
 ('0000000006','Boletin venezolano de infectologia','Revista','http://www.ateproca.com/dyncat.cfm?catid=99','006.jpg','image/jpeg',28057,0x[encoded data, 76796 characters],'SI','SI','001');


--
-- Definition of table `svctregiones`
--

CREATE TABLE `svctregiones` (
  `codreg` varchar(3) NOT NULL,
  `nomreg` varchar(25) NOT NULL,
  PRIMARY KEY  (`codreg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctregiones`
--

INSERT INTO `svctregiones` (`codreg`,`nomreg`) VALUES 
 ('001','Latinoamerica'),
 ('002','EEUU y Canada'),
 ('003','Europa'),
 ('004','Otras Regiones');


--
-- Definition of table `svctregionesvinculos`
--

CREATE TABLE `svctregionesvinculos` (
  `codreg` varchar(2) NOT NULL,
  `nomreg` varchar(20) NOT NULL,
  PRIMARY KEY  (`codreg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctregionesvinculos`
--

INSERT INTO `svctregionesvinculos` (`codreg`,`nomreg`) VALUES 
 ('01','América'),
 ('02','Europa'),
 ('03','Otras Regiones');


--
-- Definition of table `svcttemasinteres`
--

CREATE TABLE `svcttemasinteres` (
  `codtemint` varchar(10) NOT NULL default '',
  `nomtemint` varchar(60) default NULL,
  `destemint` text,
  `fectemint` date default NULL,
  PRIMARY KEY  (`codtemint`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcttemasinteres`
--

INSERT INTO `svcttemasinteres` (`codtemint`,`nomtemint`,`destemint`,`fectemint`) VALUES 
 ('0000000001','xdcg','<img src=\"svcobtenerimagenfoto.php?id=0000000005&amp;tipo=normal&amp;nn=BbehbFcEcDAGcDadBehdHFffbHFBCDbggcDEcaDEdaDbEdDGDDgAFGHBEHeCeccbbcEDHacFdHFHCAGEgeBegGhDFCbdfEhDCaaG\"><br>sdfsdf\n  ','2008-12-10'),
 ('0000000002','Prueba de Tema','Este es una prueba para Carlos<br><img src=\"svcobtenerimagenfoto.php?id=0000000002&amp;tipo=normal&amp;nn=dBEGgAdFEHhcgeGgFfeehGcbDEdDBBBgGCEGCAEcDcbHag\"><br> ','2008-12-18');


--
-- Definition of table `svcttesis`
--

CREATE TABLE `svcttesis` (
  `codtes` varchar(10) NOT NULL default '',
  `nomtes` varchar(50) default NULL,
  `tiptes` varchar(20) default NULL,
  `urltes` varchar(120) default NULL,
  `nompdf` varchar(50) NOT NULL,
  `tippdf` varchar(20) NOT NULL,
  `tampdf` int(11) NOT NULL,
  `datpdf` longblob NOT NULL,
  `palcla` text NOT NULL,
  `restes` text NOT NULL,
  `lugfis` varchar(50) NOT NULL,
  PRIMARY KEY  (`codtes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcttesis`
--

INSERT INTO `svcttesis` (`codtes`,`nomtes`,`tiptes`,`urltes`,`nompdf`,`tippdf`,`tampdf`,`datpdf`,`palcla`,`restes`,`lugfis`) VALUES 
 ('0000000001','Tesis 1','Revista','001.pdf','001.pdf','application/pdf',27395,0x[encoded data, 74980 characters],'arterias venas','Las arterias como canal sanguineo','Biblioteca Pio Tamayo'),
 ('0000000002','Tesis 2','Revista','002.pdf','','',0,'','hemodinamia, tension arterial','La tension es el enemigo oculto','biblioteca de la ucla');
INSERT INTO `svcttesis` (`codtes`,`nomtes`,`tiptes`,`urltes`,`nompdf`,`tippdf`,`tampdf`,`datpdf`,`palcla`,`restes`,`lugfis`) VALUES 
 ('0000000003','Tesis 3','Revista','003.pdf','','',0,'','Corazon','Es una tesis de corazon abierto','ascardio');


--
-- Definition of table `svcttestdia`
--

CREATE TABLE `svcttestdia` (
  `codtes` varchar(10) NOT NULL default '',
  `tittes` varchar(100) default NULL,
  `enutes` text,
  `detcas` text,
  `titopc` varchar(100) default NULL,
  `opca` varchar(100) NOT NULL,
  `opcb` varchar(100) NOT NULL,
  `opcc` varchar(100) NOT NULL,
  `opcd` varchar(100) NOT NULL,
  `opce` varchar(100) NOT NULL,
  `opccor` varchar(1) NOT NULL,
  `stapub` varchar(1) NOT NULL,
  PRIMARY KEY  (`codtes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcttestdia`
--

INSERT INTO `svcttestdia` (`codtes`,`tittes`,`enutes`,`detcas`,`titopc`,`opca`,`opcb`,`opcc`,`opcd`,`opce`,`opccor`,`stapub`) VALUES 
 ('0000000001','ELECTROCARDIOGRAMA','<table style=\"width: 443px; height: 112px;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\">  \n<tbody>\n<tr>\n<td>\n<div style=\"text-align: center;\"><p:colorscheme colors=\"#FFFFFF,#000000,#808080,#000000,#BBE0E3,#333399,#009999,#99CC00\"></p:colorscheme></div>  \n<div class=\"O\" style=\"text-align: center;\" v:shape=\"_x0000_s2050\"><span style=\"font-size: 117%; color: black; font-family: Arial;\" lang=\"ES-MX\"><b>ELECTROCARDIOGRAMA DEL MES</b></span><span style=\"display: none;\"> </span></div></td></tr>  \n<tr>\n<td><p:colorscheme colors=\"#FFFFFF,#000000,#808080,#000000,#BBE0E3,#333399,#009999,#99CC00\"></p:colorscheme>  \n<div class=\"O\" v:shape=\"_x0000_s2050\">\n<div><font size=\"4\"><span style=\"font-size: 67%; font-family: Arial;\" lang=\"ES-MX\">Paciente \nmasculino d  \n56 años, quien consulta por síncopes desde la adolescencia. La </span><span style=\"font-size: 67%; font-family: Arial;\" lang=\"ES-MX\">evaluación neurológica fué negativa. Antecedentes  \nfamiliares de muerte súbita. El examen físico </span><span style=\"font-size: 67%; font-family: Arial;\" lang=\"ES-MX\">y ecocardiograma normales. </span></font></div>  \n<div><span style=\"display: none; font-size: 67%; font-family: Arial;\" lang=\"ES-MX\"></span></div>\n<div><font size=\"4\"><span style=\"font-size: 67%; color: rgb(51, 51, 153); font-family: Arial;\" lang=\"ES-MX\"><b>Se le realiza el siguiente electrocardiograma</b></span><span style=\"font-size: 67%; font-family: Arial;\" lang=\"ES-MX\"><b>: </b></span></font></div>  \n<div><font size=\"4\"><span style=\"font-size: 67%; visibility: hidden; font-family: Arial;\"><span style=\"left: -0.76%; position: absolute;\">?</span></span></font><span style=\"display: none; font-size: 67%; font-family: Arial;\"><b> </b></span></div>  \n<div><span style=\"display: none;\"></span></div></div></td></tr>\n<tr>\n<td>Insertar Texto aqui</td></tr>\n<tr>\n<td>Insertar Texto aqui</td></tr>\n<tr>\n<td><a href=\"http://localhost/svc/svca/svcimostrarimagen.php?id=0000000006\" target=\"_blank\"><img src=\"http://localhost/svc/svca/svcobtenerimagenfoto.php?id=0000000006&amp;tipo=normal&amp;nn=BBHgHabcCeEaHdbGdhcDfabbFHBeDbgBEGcHdHfECFcfAGGEGeGHdAFfhbfHbaHEDHCacHfeAdEhgGdAaAFBGhfAfdCCBbABBbFF\" border=\"0\"></a></td></tr></tbody></table>  \n<br>\n','<a href=\"http://localhost/svc/svca/svcimostrarimagen.php?id=0000000005\" target=\"_blank\"><img src=\"http://localhost/svc/svca/svcobtenerimagenfoto.php?id=0000000005&amp;tipo=normal&amp;nn=cEeCEeDbdCCGcGHcAAFCfGchebFfBFhdDGbfAEfBEcBFEGgcCFHDcEGAEFegfeDDAFgGfhfGgDFgHhEHbebhdHEFFaAHFegDecFf\" border=\"0\"></a>  ','Seleccione el Diagnóstico Probable','Síncope Vasovagal','Síndrome de QT prolongado familiar','Displasia arritmogenica  del Ventrículo derecho','Síndrome de Brugada','Bloqueo AV paroxístico','d','S');


--
-- Definition of table `svcttipovinculos`
--

CREATE TABLE `svcttipovinculos` (
  `codtipvin` varchar(2) NOT NULL,
  `nomtipvin` varchar(50) NOT NULL,
  PRIMARY KEY  (`codtipvin`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcttipovinculos`
--

INSERT INTO `svcttipovinculos` (`codtipvin`,`nomtipvin`) VALUES 
 ('01','Revistas'),
 ('02','Sociedades de Cardiología'),
 ('03','Fundaciones del Corazón'),
 ('04','Hospitales, Clinicas o Centros'),
 ('05','Materia'),
 ('06','Otros');


--
-- Definition of table `svctuniversidad`
--

CREATE TABLE `svctuniversidad` (
  `coduni` varchar(3) NOT NULL,
  `nomuni` varchar(100) NOT NULL,
  PRIMARY KEY  (`coduni`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctuniversidad`
--

INSERT INTO `svctuniversidad` (`coduni`,`nomuni`) VALUES 
 ('001','UCV'),
 ('002','UCLA'),
 ('003','UC'),
 ('004','ULA'),
 ('005','USB'),
 ('006','LUZ'),
 ('007','UDO'),
 ('008','UNELLEZ');


--
-- Definition of table `svctusuarios`
--

CREATE TABLE `svctusuarios` (
  `logusu` varchar(20) NOT NULL default '',
  `pasusu` varchar(100) default NULL,
  `nomusu` varchar(30) NOT NULL,
  `nivusu` varchar(20) NOT NULL,
  PRIMARY KEY  (`logusu`(10))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctusuarios`
--

INSERT INTO `svctusuarios` (`logusu`,`pasusu`,`nomusu`,`nivusu`) VALUES 
 ('123','caf1a3dfb505ffed0d024130f58c5cfa','Prueba','Administrador');


--
-- Definition of table `svctvinculos`
--

CREATE TABLE `svctvinculos` (
  `codvin` varchar(10) NOT NULL,
  `nomvin` varchar(50) NOT NULL,
  `codtipvin` varchar(2) default NULL,
  `urlvin` varchar(120) default NULL,
  `staven` varchar(2) default NULL,
  `desvin` text NOT NULL,
  `codreg` varchar(2) NOT NULL,
  PRIMARY KEY  (`codvin`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctvinculos`
--

INSERT INTO `svctvinculos` (`codvin`,`nomvin`,`codtipvin`,`urlvin`,`staven`,`desvin`,`codreg`) VALUES 
 ('0000000001','Sociedad colombiana de Cardiologia','01','http://www.scc.org.co/eventos.cfm','NO','-','01'),
 ('0000000002','American College','01','http://www.acc.org/advocacy/advoc_issues/rc_cpar.htm','SI','-','01'),
 ('0000000003','Ateproca','05','http://www.ateproca.com/JOBS.CFM','SI','','02'),
 ('0000000004','Revista Latina de Cardiologia','01','http://db.doyma.es/cgi-bin/wdbcgi.exe/doyma/mrevista_info.sobre?pident_revista=68','SI','-','01'),
 ('0000000005','Revista Electronica de Portales Medicos','01','http://www.portalesmedicos.com/publicaciones/categories/Imagenes/Imagenes-de-Cardiologia/','SI','-','01'),
 ('0000000006','Medline','01','http://db2.doyma.es/main_medline.htm','SI','-','01'),
 ('0000000007','Revista Española de Cardiologia','01','http://www.revespcardiol.org/cgi-bin/wdbcgi.exe/cardio/mrevista_cardio.fulltext?pident=13096589','SI','-','01'),
 ('0000000008','Revista Uruguaya de Cardiologia','01','http://www.scielo.edu.uy/scielo.php?pid=S0797-00482005000300002&script=sci_arttext&tlng=es','SI','-','01'),
 ('0000000009','El medico.net','01','http://elmedico.metropoliglobal.com/','SI','-','01'),
 ('0000000010','Estudiantes Medicina TV','01','http://estudiantes.medicinatv.com/links/salud/sub_salud/Default.asp?idmail=8','SI','-','01'),
 ('0000000011','Congreso Virtual de Cardiologia','01','http://pcvc.sminter.com.ar/cvirtual/publica/acpubtep.htm','SI','-','01');


--
-- Definition of table `svctvisitas`
--

CREATE TABLE `svctvisitas` (
  `convis` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctvisitas`
--

INSERT INTO `svctvisitas` (`convis`) VALUES 
 (82);


--
-- Definition of table `svctvisitasmesactual`
--

CREATE TABLE `svctvisitasmesactual` (
  `mesres` varchar(2) NOT NULL,
  `anores` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctvisitasmesactual`
--

INSERT INTO `svctvisitasmesactual` (`mesres`,`anores`) VALUES 
 ('06','2009');


--
-- Definition of table `svctvisitasnacext`
--

CREATE TABLE `svctvisitasnacext` (
  `convisnac` bigint(20) default NULL,
  `convisext` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctvisitasnacext`
--

INSERT INTO `svctvisitasnacext` (`convisnac`,`convisext`) VALUES 
 (11,0);


--
-- Definition of table `svctvisitaspaises`
--

CREATE TABLE `svctvisitaspaises` (
  `convis` bigint(20) NOT NULL,
  `nompai` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctvisitaspaises`
--

INSERT INTO `svctvisitaspaises` (`convis`,`nompai`) VALUES 
 (0,'Venezuela');


--
-- Definition of table `svctvisitaspaisesresumen`
--

CREATE TABLE `svctvisitaspaisesresumen` (
  `convis` bigint(20) NOT NULL,
  `nompai` varchar(30) NOT NULL,
  `mesres` varchar(2) NOT NULL,
  `anores` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctvisitaspaisesresumen`
--

INSERT INTO `svctvisitaspaisesresumen` (`convis`,`nompai`,`mesres`,`anores`) VALUES 
 (1,'Venezuela','05','2009');




