CREATE TABLE `svctplantillas` (
  `codpla` varchar(10) NOT NULL,
  `nompla` varchar(40) NOT NULL,
  `htmpla` text NOT NULL,
  PRIMARY KEY  (`codpla`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctplantillas`
--

INSERT INTO `svctplantillas` (`codpla`,`nompla`,`htmpla`) VALUES 
 ('0000000002','juju','<table style=\"width: 439px; height: 54px;\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\"><tbody><tr><td>Insertar Texto aqui</td><td>dede</td></tr><tr><td>Insertar Texto aqui</td><td><img src=\"svcobtenerimagenfoto.php?id=0000000005&amp;tipo=normal&amp;nn=EDEBdaEeHeegeHCFBeEBdeffceagecgAdceHbbAbaHhDCE\"><br></td></tr></tbody></table>\n '),
 ('0000000004','cestlo','<table style=\"width: 369px; height: 32px;\" border=\"1\" bordercolor=\"#000000\" cellpadding=\"2\" cellspacing=\"2\"><tbody><tr><td>Insertar Texto aqui</td><td><img src=\"svcobtenerimagenfoto.php?id=0000000002&amp;tipo=normal&amp;nn=GccfbffEEcggHehbDaBbdaDgCbBHfgAgBGeddaCabeeDDD\"><br></td></tr></tbody></table> '),
 ('0000000005','borram1','<img src=\"svcobtenerimagenfoto.php?id=0000000005&amp;tipo=normal&amp;nn=bFHGdaeCHEDggAFbgGGDAcdhAdageDcdfffaEcbHDHHcdE\">\n\n '),
 ('0000000006','borrame2','<img src=\"svcobtenerimagenfoto.php?id=0000000003&amp;tipo=normal&amp;nn=ebCggffgGGHbehCgEDagcEfBBBCGDeBfcfHEeFDEEgaDFc\">\n\n '),
 ('0000000007','borrale','hgfhfhgfhfhfh '),
 ('0000000008','hhyy','<img src=\"svcobtenerimagenfoto.php?id=0000000005&amp;tipo=normal&amp;nn=HecDGgBHbaBBcEggGBchGfBhdFBaadAdhbefgGAAdffbgC\"> '),
 ('0000000009','boool','<img src=\"svcobtenerimagenfoto.php?id=0000000005&amp;tipo=normal&amp;nn=bFHGdaeCHEDggAFbgGGDAcdhAdageDcdfffaEcbHDHHcdE\"><br>asdasdasdassssss<br>\n\n\n '),
 ('0000000010','Plantilla actividad','Primera <br>actividad<br><img src=\"svcobtenerimagenfoto.php?id=0000000006&amp;tipo=normal&amp;nn=hgGhFhaHFAHhcDaBaCcCeECefdBBChacFbGHacCDDEggch\"><br>óñÑ<br> '),
 ('0000000011','plantilla comunidad','jhgjhghjg bbbv<br><table border=\"1\" bordercolor=\"#000000\" cellpadding=\"2\" cellspacing=\"2\"><tbody><tr><td>Insertar Texto aqui<img src=\"svcobtenerimagenfoto.php?id=0000000006&amp;tipo=normal&amp;nn=FgeEgaCHgbDdFDhBGgBaGBEDDFEedaHaFaEhBAfCHEFDgGddcCdgCaaAdHeAcHecfDbEHbHfGfbGeBbhchcbgggcHdheFEdaECGf\"></td></tr><tr><td>Insertar Texto \naqui</td></tr></tbody></table><br>  ');


--
-- Definition of table `svctportadaavancescardiologicos`
--

CREATE TABLE `svctportadaavancescardiologicos` (
  `codporava` varchar(10) NOT NULL default '',
  `nomporava` varchar(100) default NULL,
  `nomarc` varchar(50) default NULL,
  `tiparc` varchar(50) default NULL,
  `tamarc` int(11) default NULL,
  `datarc` longblob,
  `codava` varchar(10) NOT NULL,
  PRIMARY KEY  (`codporava`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctportadaavancescardiologicos`
--

INSERT INTO `svctportadaavancescardiologicos` (`codporava`,`nomporava`,`nomarc`,`tiparc`,`tamarc`,`datarc`,`codava`) VALUES 
 ('0000000001','Avances Cardiológicos 2007','Portada.jpg','image/jpeg',65803,0x[encoded data, 180100 characters],'0000000018');


--
-- Definition of table `svctpostgrados`
--

CREATE TABLE `svctpostgrados` (
  `codpos` varchar(10) NOT NULL,
  `nompos` varchar(100) NOT NULL,
  `codciu` varchar(3) NOT NULL,
  `coduni` varchar(3) NOT NULL,
  `corpos` varchar(30) NOT NULL,
  `dirpos` varchar(30) NOT NULL,
  `anofun` int(11) NOT NULL,
  `reqingpos` text NOT NULL,
  `reshis` text NOT NULL,
  `infcon` text NOT NULL,
  `nomfot` varchar(50) NOT NULL,
  `tipfot` varchar(20) NOT NULL,
  `tamfot` int(11) NOT NULL,
  `datfot` longblob NOT NULL,
  `estpriano` int(11) NOT NULL,
  `estsegano` int(11) NOT NULL,
  `estterano` int(11) NOT NULL,
  `codins` varchar(3) NOT NULL,
  PRIMARY KEY  (`codpos`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctpostgrados`
--

INSERT INTO `svctpostgrados` (`codpos`,`nompos`,`codciu`,`coduni`,`corpos`,`dirpos`,`anofun`,`reqingpos`,`reshis`,`infcon`,`nomfot`,`tipfot`,`tamfot`,`datfot`,`estpriano`,`estsegano`,`estterano`,`codins`) VALUES 
 ('0000000001','Cardiología','002','002','Dr. Finizola','La direccion',1979,'-','-','-','foxp.jpg','image/jpeg',130112,0x[encoded data, 339603 characters]