SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
--

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

--
-- Estructura de tabla para la tabla `phi_resources`
--

CREATE TABLE `phi_resources` (
  `id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `filename` varchar(255) NOT NULL default '',
  `mimetype` varchar(128) NOT NULL default '',
  `timestamp` int(11) NOT NULL default '0',
  `library` int(11) NOT NULL default '0',
  `owner` int(11) NOT NULL default '0',
  `comment_level` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `phi_resources_seq`
--

CREATE TABLE `phi_resources_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
