CREATE TABLE `svcpformatos` (
  `nomarc` varchar(50) default NULL,
  `tiparc` varchar(20) default NULL,
  `tamarc` int(11) default NULL,
  `datarc` longblob,
  `codfor` varchar(100) default NULL,
  `fecfor` datetime default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcpformatos`
--

INSERT INTO `svcpformatos` (`nomarc`,`tiparc`,`tamarc`,`datarc`,`codfor`,`fecfor`) VALUES 
 ('borrame.doc','application/msword',19456,0x[encoded data, 53256 characters],'dcBedacebDBcaBbABdgaGDgGFfgBeDagEehDGBDAHGBBHGfDfcgCAGgbFbcaGfcHhDeHACcfdGbEHBbbHBdbfDChgFFfHFECeHeD','2007-06-05 11:44:14'),
 ('borrame.doc','application/msword',19456,0x[encoded data, 53256 characters],'GFhGcdGbBGEhBHgEbcdEbdfabFeFaHBCecEecFgcFEFaAggDgbgEADDgcFgbCDCBBDcDDgBddGgffeGCaGgCBcahFChGhBEFdHac','2007-06-05 11:45:08');


--
-- Definition of table `svcpfotos`
--

CREATE TABLE `svcpfotos` (
  `codfot` varchar(100) NOT NULL default '',
  `nomfot` varchar(50) NOT NULL,
  `tipfot` varchar(20) NOT NULL,
  `tamfot` int(11) NOT NULL,
  `datfot` longblob NOT NULL,
  `fecfot` datetime NOT NULL,
  PRIMARY KEY  (`codfot`(10))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcpfotos`
--



--
-- Definition of table `svcpportadaavancescardiologicos`
--

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

--
-- Dumping data for table `svcpportadaavancescardiologicos`
--



--
-- Definition of table `svcppostgrados`
--

CREATE TABLE `svcppostgrados` (
  `nomfot` varchar(50) default NULL,
  `tipfot` varchar(20) default NULL,
  `tamfot` int(11) default NULL,
  `datfot` longblob,
  `codpos` varchar(100) default NULL,
  `fecfot` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcppostgrados`
--



--
-- Definition of table `svcppublicaci`
--

CREATE TABLE `svcppublicaci` (
  `nomfot` varchar(50) default NULL,
  `tipfot` varchar(20) default NULL,
  `tamfot` int(11) default NULL,
  `datfot` longblob,
  `codpub` varchar(100) default NULL,
  `fecfot` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcppublicaci`
--



--
-- Definition of table `svcptesis`
--

CREATE TABLE `svcptesis` (
  `nompdf` varchar(50) default NULL,
  `tippdf` varchar(20) default NULL,
  `tampdf` int(11) default NULL,
  `datpdf` longblob,
  `codtes` varchar(100) default NULL,
  `fecpdf` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svcptesis`
--



--
-- Definition of table `svctanunciantes`
--

CREATE TABLE `svctanunciantes` (
  `codanu` varchar(10) NOT NULL default '',
  `nomanu` varchar(100) default NULL,
  `nomarc` varchar(50) default NULL,
  `tiparc` varchar(50) default NULL,
  `tamarc` int(11) default NULL,
  `datarc` longblob,
  `tiedurswf` int(11) default NULL,
  PRIMARY KEY  (`codanu`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `svctanunciantes`
--

INSERT INTO `svctanunciantes` (`codanu`,`nomanu`,`nomarc`,`tiparc`,`tamarc`,`datarc`,`tiedurswf`) VALUES 
 ('0000000002','Farma','importado.swf','application/x-shockwave-flash',167020,0x[encoded data, 413456 characters]