[mythtv-users] How to reset in video manager the list of all genre/category etc...

[Jean-Yves Avenard]

Hi

2009/2/6 Ma Begaj <derliebegott at gmail.com>:
> I dont think that you can break it as you seem to know enough about
> programming and software. But making backup cannot harm

Yep... I ended up going into mysql and reset the whole thing by end..

Used the following commands:
All back to spanking new :)

---
DROP TABLE IF EXISTS `videocategory`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videocategory` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `category` varchar(128) NOT NULL,
  PRIMARY KEY  (`intid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `videocategory` (   `intid` int(10) unsigned NOT NULL
auto_increment,   `category` varchar(128) NOT NULL,   PRIMARY KEY
(`intid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `videocountry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videocountry` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `country` varchar(128) NOT NULL,
  PRIMARY KEY  (`intid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `videocountry` (   `intid` int(10) unsigned NOT NULL
auto_increment,   `country` varchar(128) NOT NULL,   PRIMARY KEY
(`intid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `videogenre`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videogenre` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `genre` varchar(128) NOT NULL,
  PRIMARY KEY  (`intid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `videogenre` (   `intid` int(10) unsigned NOT NULL
auto_increment,   `genre` varchar(128) NOT NULL,   PRIMARY KEY
(`intid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `videometadata`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videometadata` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(128) NOT NULL,
  `director` varchar(128) NOT NULL,
  `plot` text,
  `rating` varchar(128) NOT NULL,
  `inetref` varchar(32) NOT NULL,
  `year` int(10) unsigned NOT NULL,
  `userrating` float NOT NULL,
  `length` int(10) unsigned NOT NULL,
  `showlevel` int(10) unsigned NOT NULL,
  `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;
CREATE TABLE `videometadata` (   `intid` int(10) unsigned NOT NULL
auto_increment,   `title` varchar(128) NOT NULL,   `director`
varchar(128) NOT NULL,   `plot` text,   `rating` varchar(128) NOT
NULL,   `inetref` varchar(32) NOT NULL,   `year` int(10) unsigned NOT
NULL,   `userrating` float NOT NULL,   `length` int(10) unsigned NOT
NULL,   `showlevel` int(10) unsigned NOT NULL,   `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;
SET character_set_client = @saved_cs_client;
DROP TABLE IF EXISTS `videometadatacountry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videometadatacountry` (
  `idvideo` int(10) unsigned NOT NULL,
  `idcountry` int(10) unsigned NOT NULL,
  KEY `idvideo` (`idvideo`),
  KEY `idcountry` (`idcountry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `videometadatacountry` (   `idvideo` int(10) unsigned NOT
NULL,   `idcountry` int(10) unsigned NOT NULL,   KEY `idvideo`
(`idvideo`),   KEY `idcountry` (`idcountry`) ) ENGINE=MyISAM DEFAULT
CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `videometadatacountry`
--
LOCK TABLES `videometadatacountry` WRITE;
/*!40000 ALTER TABLE `videometadatacountry` DISABLE KEYS */;
/*!40000 ALTER TABLE `videometadatacountry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `videometadatagenre`
--
DROP TABLE IF EXISTS `videometadatagenre`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videometadatagenre` (
  `idvideo` int(10) unsigned NOT NULL,
  `idgenre` int(10) unsigned NOT NULL,
  KEY `idvideo` (`idvideo`),
  KEY `idgenre` (`idgenre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `videometadatagenre` (   `idvideo` int(10) unsigned NOT
NULL,   `idgenre` int(10) unsigned NOT NULL,   KEY `idvideo`
(`idvideo`),   KEY `idgenre` (`idgenre`) ) ENGINE=MyISAM DEFAULT
CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `videometadatagenre`
--
LOCK TABLES `videometadatagenre` WRITE;
/*!40000 ALTER TABLE `videometadatagenre` DISABLE KEYS */;
/*!40000 ALTER TABLE `videometadatagenre` ENABLE KEYS */;
UNLOCK TABLES;
DROP TABLE IF EXISTS `videocast`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `videocast` (
  `intid` int(10) unsigned NOT NULL auto_increment,
  `cast` varchar(128) NOT NULL,
  PRIMARY KEY  (`intid`)
) ENGINE=MyISAM AUTO_INCREMENT=494 DEFAULT CHARSET=latin1;
CREATE TABLE `videocast` (   `intid` int(10) unsigned NOT NULL
auto_increment,   `cast` varchar(128) NOT NULL,   PRIMARY KEY
(`intid`) ) ENGINE=MyISAM AUTO_INCREMENT=494 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;