CREATE DATABASE ocwtest;

--
-- Estructura de tabla para la tabla `aux1`
--

CREATE TABLE `aux1` (
  `id` int(11) NOT NULL,
  `code` varchar(25) NOT NULL,
  `loans` varchar(25) NOT NULL,
  `exemp` varchar(25) NOT NULL,
  `ratio` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bibliocat`
--

CREATE TABLE `bibliocat` (
  `id` int(11) NOT NULL,
  `originFILE` varchar(250) NOT NULL,
  `code` varchar(25) NOT NULL,
  `newcode` text NOT NULL,
  `url` varchar(500) NOT NULL,
  `author` varchar(250) NOT NULL,
  `authorsec` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `edition` varchar(250) NOT NULL,
  `trad` varchar(5) NOT NULL,
  `publication` varchar(250) NOT NULL,
  `physical` varchar(250) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `collection` varchar(250) NOT NULL,
  `permalink` text NOT NULL,
  `isbn` varchar(25) NOT NULL,
  `presenceAmazon` varchar(25) NOT NULL,
  `linkAmazon` text NOT NULL,
  `reliAmazon` varchar(25) NOT NULL,
  `presenceDilve` varchar(25) NOT NULL,
  `linkDilve` text NOT NULL,
  `reliDilve` varchar(25) NOT NULL,
  `presenceTuslibros` varchar(25) NOT NULL,
  `linkTuslibros` text NOT NULL,
  `reliTuslibros` varchar(25) NOT NULL,
  `presenceIberlibro` varchar(25) NOT NULL,
  `linkIberlibro` text NOT NULL,
  `reliIberlibro` varchar(25) NOT NULL,
  `presenceRebiun` varchar(25) NOT NULL,
  `linkRebiun` text NOT NULL,
  `reliRebiun` varchar(25) NOT NULL,
  `presenceBne` varchar(25) NOT NULL,
  `linkBne` text NOT NULL,
  `reliBne` varchar(25) NOT NULL,
  `presenceBnedatos` varchar(25) NOT NULL,
  `linkBnedatos` text NOT NULL,
  `reliBnedatos` varchar(25) NOT NULL,
  `presenceIsbn` varchar(25) NOT NULL,
  `linkIsbn` text NOT NULL,
  `reliIsbn` varchar(25) NOT NULL,
  `descatIsbn` varchar(25) NOT NULL,
  `presenceGooglebooks` varchar(25) NOT NULL,
  `linkGooglebooks` text NOT NULL,
  `reliGooglebooks` varchar(25) NOT NULL,
  `indexer` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `aux1`
--
ALTER TABLE `aux1`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `bibliocat`
--
ALTER TABLE `bibliocat`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `bibliocat` ADD FULLTEXT KEY `indexer` (`indexer`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `aux1`
--
ALTER TABLE `aux1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `bibliocat`
--
ALTER TABLE `bibliocat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;