-- Table structure for table `videometadata`
--

DROP TABLE IF EXISTS `videometadata`;
CREATE TABLE `videometadata` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(128) NOT NULL default '',
  `director` varchar(128) NOT NULL default '',
  `plot` text,
  `rating` varchar(128) NOT NULL default '',
  `inetref` varchar(32) NOT NULL default '',
  `year` int(10) unsigned NOT NULL default '0',
  `userrating` float NOT NULL default '0',
  `length` int(10) unsigned NOT NULL default '0',
  `showlevel` int(10) unsigned NOT NULL default '0',
  `filename` text NOT NULL,
  `coverfile` text NOT NULL,
  `childid` int(11) NOT NULL default '-1',
  `browse` tinyint(1) NOT NULL default '1',
  `playcommand` varchar(255) default NULL,
  `category` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`intid`),
  KEY `director` (`director`),
  KEY `title` (`title`),
  KEY `title_2` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;