Remove drop table if exists and auto increment values

1 files changed, 39 insertions, 137 deletions

diff --git a/mythfs/unittests/fixtures/schema.sql b/mythfs/unittests/fixtures/schema.sql
index fe6a17b..6034ecc 100644
--- a/mythfs/unittests/fixtures/schema.sql
+++ b/mythfs/unittests/fixtures/schema.sql
@@ -1,4 +1,4 @@
--- MySQL dump 10.13  Distrib 5.6.27, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.6.28, for Linux (x86_64)
 --
 -- Host: defiant    Database: mythconverg
 -- ------------------------------------------------------
@@ -19,7 +19,6 @@
 -- Table structure for table `archiveitems`
 --
 
-DROP TABLE IF EXISTS `archiveitems`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `archiveitems` (
@@ -43,14 +42,13 @@ CREATE TABLE `archiveitems` (
   `encoderprofile` varchar(50) NOT NULL DEFAULT 'NONE',
   PRIMARY KEY (`intid`),
   KEY `title` (`title`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `bar`
 --
 
-DROP TABLE IF EXISTS `bar`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `bar` (
@@ -63,7 +61,6 @@ CREATE TABLE `bar` (
 -- Table structure for table `callsignnetworkmap`
 --
 
-DROP TABLE IF EXISTS `callsignnetworkmap`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `callsignnetworkmap` (
@@ -79,7 +76,6 @@ CREATE TABLE `callsignnetworkmap` (
 -- Table structure for table `capturecard`
 --
 
-DROP TABLE IF EXISTS `capturecard`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `capturecard` (
@@ -110,14 +106,13 @@ CREATE TABLE `capturecard` (
   `diseqcid` int(10) unsigned DEFAULT NULL,
   `dvb_eitscan` tinyint(1) NOT NULL DEFAULT '1',
   PRIMARY KEY (`cardid`)
-) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `cardinput`
 --
 
-DROP TABLE IF EXISTS `cardinput`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `cardinput` (
@@ -137,14 +132,13 @@ CREATE TABLE `cardinput` (
   `schedorder` int(10) unsigned NOT NULL DEFAULT '0',
   `livetvorder` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`cardinputid`)
-) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `channel`
 --
 
-DROP TABLE IF EXISTS `channel`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `channel` (
@@ -187,7 +181,6 @@ CREATE TABLE `channel` (
 -- Table structure for table `channelgroup`
 --
 
-DROP TABLE IF EXISTS `channelgroup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `channelgroup` (
@@ -202,21 +195,19 @@ CREATE TABLE `channelgroup` (
 -- Table structure for table `channelgroupnames`
 --
 
-DROP TABLE IF EXISTS `channelgroupnames`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `channelgroupnames` (
   `grpid` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `name` varchar(64) NOT NULL DEFAULT '0',
   PRIMARY KEY (`grpid`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `channelscan`
 --
 
-DROP TABLE IF EXISTS `channelscan`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `channelscan` (
@@ -226,14 +217,13 @@ CREATE TABLE `channelscan` (
   `processed` tinyint(1) unsigned NOT NULL,
   `scandate` datetime NOT NULL,
   PRIMARY KEY (`scanid`)
-) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `channelscan_channel`
 --
 
-DROP TABLE IF EXISTS `channelscan_channel`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `channelscan_channel` (
@@ -282,7 +272,6 @@ CREATE TABLE `channelscan_channel` (
 -- Table structure for table `channelscan_dtv_multiplex`
 --
 
-DROP TABLE IF EXISTS `channelscan_dtv_multiplex`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `channelscan_dtv_multiplex` (
@@ -307,14 +296,13 @@ CREATE TABLE `channelscan_dtv_multiplex` (
   `tuner_type` smallint(2) unsigned NOT NULL,
   `default_authority` varchar(32) NOT NULL DEFAULT '',
   PRIMARY KEY (`transportid`)
-) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `codecparams`
 --
 
-DROP TABLE IF EXISTS `codecparams`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `codecparams` (
@@ -329,7 +317,6 @@ CREATE TABLE `codecparams` (
 -- Table structure for table `credits`
 --
 
-DROP TABLE IF EXISTS `credits`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `credits` (
@@ -346,7 +333,6 @@ CREATE TABLE `credits` (
 -- Table structure for table `customexample`
 --
 
-DROP TABLE IF EXISTS `customexample`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `customexample` (
@@ -362,7 +348,6 @@ CREATE TABLE `customexample` (
 -- Table structure for table `diseqc_config`
 --
 
-DROP TABLE IF EXISTS `diseqc_config`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `diseqc_config` (
@@ -377,7 +362,6 @@ CREATE TABLE `diseqc_config` (
 -- Table structure for table `diseqc_tree`
 --
 
-DROP TABLE IF EXISTS `diseqc_tree`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `diseqc_tree` (
@@ -406,7 +390,6 @@ CREATE TABLE `diseqc_tree` (
 -- Table structure for table `displayprofilegroups`
 --
 
-DROP TABLE IF EXISTS `displayprofilegroups`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `displayprofilegroups` (
@@ -415,14 +398,13 @@ CREATE TABLE `displayprofilegroups` (
   `profilegroupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`name`,`hostname`),
   UNIQUE KEY `profilegroupid` (`profilegroupid`)
-) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `displayprofiles`
 --
 
-DROP TABLE IF EXISTS `displayprofiles`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `displayprofiles` (
@@ -433,14 +415,13 @@ CREATE TABLE `displayprofiles` (
   KEY `profilegroupid` (`profilegroupid`),
   KEY `profileid` (`profileid`,`value`),
   KEY `profileid_2` (`profileid`)
-) ENGINE=MyISAM AUTO_INCREMENT=141 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `dtv_multiplex`
 --
 
-DROP TABLE IF EXISTS `dtv_multiplex`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `dtv_multiplex` (
@@ -469,14 +450,13 @@ CREATE TABLE `dtv_multiplex` (
   `updatetimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   `default_authority` varchar(32) NOT NULL DEFAULT '',
   PRIMARY KEY (`mplexid`)
-) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `dtv_privatetypes`
 --
 
-DROP TABLE IF EXISTS `dtv_privatetypes`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `dtv_privatetypes` (
@@ -491,7 +471,6 @@ CREATE TABLE `dtv_privatetypes` (
 -- Table structure for table `dvdbookmark`
 --
 
-DROP TABLE IF EXISTS `dvdbookmark`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `dvdbookmark` (
@@ -511,7 +490,6 @@ CREATE TABLE `dvdbookmark` (
 -- Table structure for table `dvdinput`
 --
 
-DROP TABLE IF EXISTS `dvdinput`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `dvdinput` (
@@ -531,7 +509,6 @@ CREATE TABLE `dvdinput` (
 -- Table structure for table `dvdtranscode`
 --
 
-DROP TABLE IF EXISTS `dvdtranscode`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `dvdtranscode` (
@@ -562,14 +539,13 @@ CREATE TABLE `dvdtranscode` (
   `two_pass` tinyint(1) DEFAULT NULL,
   `tc_param` varchar(128) DEFAULT NULL,
   PRIMARY KEY (`intid`)
-) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `eit_cache`
 --
 
-DROP TABLE IF EXISTS `eit_cache`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `eit_cache` (
@@ -587,7 +563,6 @@ CREATE TABLE `eit_cache` (
 -- Table structure for table `filemarkup`
 --
 
-DROP TABLE IF EXISTS `filemarkup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `filemarkup` (
@@ -603,7 +578,6 @@ CREATE TABLE `filemarkup` (
 -- Table structure for table `housekeeping`
 --
 
-DROP TABLE IF EXISTS `housekeeping`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `housekeeping` (
@@ -618,7 +592,6 @@ CREATE TABLE `housekeeping` (
 -- Table structure for table `inputgroup`
 --
 
-DROP TABLE IF EXISTS `inputgroup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `inputgroup` (
@@ -632,7 +605,6 @@ CREATE TABLE `inputgroup` (
 -- Table structure for table `internetcontent`
 --
 
-DROP TABLE IF EXISTS `internetcontent`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `internetcontent` (
@@ -656,7 +628,6 @@ CREATE TABLE `internetcontent` (
 -- Table structure for table `internetcontentarticles`
 --
 
-DROP TABLE IF EXISTS `internetcontentarticles`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `internetcontentarticles` (
@@ -695,7 +666,6 @@ CREATE TABLE `internetcontentarticles` (
 -- Table structure for table `inuseprograms`
 --
 
-DROP TABLE IF EXISTS `inuseprograms`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `inuseprograms` (
@@ -715,7 +685,6 @@ CREATE TABLE `inuseprograms` (
 -- Table structure for table `iptv_channel`
 --
 
-DROP TABLE IF EXISTS `iptv_channel`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `iptv_channel` (
@@ -732,7 +701,6 @@ CREATE TABLE `iptv_channel` (
 -- Table structure for table `jobqueue`
 --
 
-DROP TABLE IF EXISTS `jobqueue`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `jobqueue` (
@@ -751,14 +719,13 @@ CREATE TABLE `jobqueue` (
   `schedruntime` datetime NOT NULL DEFAULT '2007-01-01 00:00:00',
   PRIMARY KEY (`id`),
   UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`)
-) ENGINE=MyISAM AUTO_INCREMENT=3235 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `jumppoints`
 --
 
-DROP TABLE IF EXISTS `jumppoints`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `jumppoints` (
@@ -774,7 +741,6 @@ CREATE TABLE `jumppoints` (
 -- Table structure for table `keybindings`
 --
 
-DROP TABLE IF EXISTS `keybindings`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `keybindings` (
@@ -791,7 +757,6 @@ CREATE TABLE `keybindings` (
 -- Table structure for table `keyword`
 --
 
-DROP TABLE IF EXISTS `keyword`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `keyword` (
@@ -805,7 +770,6 @@ CREATE TABLE `keyword` (
 -- Table structure for table `livestream`
 --
 
-DROP TABLE IF EXISTS `livestream`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `livestream` (
@@ -842,7 +806,6 @@ CREATE TABLE `livestream` (
 -- Table structure for table `logging`
 --
 
-DROP TABLE IF EXISTS `logging`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `logging` (
@@ -862,14 +825,13 @@ CREATE TABLE `logging` (
   KEY `host` (`host`,`application`,`pid`,`msgtime`),
   KEY `msgtime` (`msgtime`),
   KEY `level` (`level`)
-) ENGINE=MyISAM AUTO_INCREMENT=1125417 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_albumart`
 --
 
-DROP TABLE IF EXISTS `music_albumart`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_albumart` (
@@ -880,14 +842,13 @@ CREATE TABLE `music_albumart` (
   `song_id` int(11) NOT NULL DEFAULT '0',
   `embedded` tinyint(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`albumart_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_albums`
 --
 
-DROP TABLE IF EXISTS `music_albums`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_albums` (
@@ -898,14 +859,13 @@ CREATE TABLE `music_albums` (
   `compilation` tinyint(1) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`album_id`),
   KEY `idx_album_name` (`album_name`)
-) ENGINE=MyISAM AUTO_INCREMENT=2720 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_artists`
 --
 
-DROP TABLE IF EXISTS `music_artists`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_artists` (
@@ -913,14 +873,13 @@ CREATE TABLE `music_artists` (
   `artist_name` varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`artist_id`),
   KEY `idx_artist_name` (`artist_name`)
-) ENGINE=MyISAM AUTO_INCREMENT=1221 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_dir_old`
 --
 
-DROP TABLE IF EXISTS `music_dir_old`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_dir_old` (
@@ -928,14 +887,13 @@ CREATE TABLE `music_dir_old` (
   `path` text CHARACTER SET latin1 NOT NULL,
   `parent_id` int(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`directory_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=502 DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_directories`
 --
 
-DROP TABLE IF EXISTS `music_directories`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_directories` (
@@ -943,14 +901,13 @@ CREATE TABLE `music_directories` (
   `path` text NOT NULL,
   `parent_id` int(20) NOT NULL DEFAULT '0',
   PRIMARY KEY (`directory_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=814 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_genres`
 --
 
-DROP TABLE IF EXISTS `music_genres`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_genres` (
@@ -958,14 +915,13 @@ CREATE TABLE `music_genres` (
   `genre` varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`genre_id`),
   KEY `idx_genre` (`genre`)
-) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_playlists`
 --
 
-DROP TABLE IF EXISTS `music_playlists`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_playlists` (
@@ -977,14 +933,13 @@ CREATE TABLE `music_playlists` (
   `songcount` smallint(8) unsigned NOT NULL DEFAULT '0',
   `hostname` varchar(64) NOT NULL DEFAULT '',
   PRIMARY KEY (`playlist_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_smartplaylist_categories`
 --
 
-DROP TABLE IF EXISTS `music_smartplaylist_categories`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_smartplaylist_categories` (
@@ -992,14 +947,13 @@ CREATE TABLE `music_smartplaylist_categories` (
   `name` varchar(128) NOT NULL,
   PRIMARY KEY (`categoryid`),
   KEY `name` (`name`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_smartplaylist_items`
 --
 
-DROP TABLE IF EXISTS `music_smartplaylist_items`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_smartplaylist_items` (
@@ -1011,14 +965,13 @@ CREATE TABLE `music_smartplaylist_items` (
   `value2` varchar(255) NOT NULL,
   PRIMARY KEY (`smartplaylistitemid`),
   KEY `smartplaylistid` (`smartplaylistid`)
-) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_smartplaylists`
 --
 
-DROP TABLE IF EXISTS `music_smartplaylists`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_smartplaylists` (
@@ -1031,14 +984,13 @@ CREATE TABLE `music_smartplaylists` (
   PRIMARY KEY (`smartplaylistid`),
   KEY `name` (`name`),
   KEY `categoryid` (`categoryid`)
-) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_songs`
 --
 
-DROP TABLE IF EXISTS `music_songs`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_songs` (
@@ -1079,14 +1031,13 @@ CREATE TABLE `music_songs` (
   KEY `album_id` (`album_id`),
   KEY `genre_id` (`genre_id`),
   KEY `artist_id` (`artist_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=14096 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `music_stats`
 --
 
-DROP TABLE IF EXISTS `music_stats`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `music_stats` (
@@ -1103,7 +1054,6 @@ CREATE TABLE `music_stats` (
 -- Table structure for table `mythlog`
 --
 
-DROP TABLE IF EXISTS `mythlog`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `mythlog` (
@@ -1117,14 +1067,13 @@ CREATE TABLE `mythlog` (
   `details` varchar(16000) NOT NULL DEFAULT '',
   PRIMARY KEY (`logid`),
   KEY `module` (`module`)
-) ENGINE=MyISAM AUTO_INCREMENT=564095 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `mythweb_sessions`
 --
 
-DROP TABLE IF EXISTS `mythweb_sessions`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `mythweb_sessions` (
@@ -1140,7 +1089,6 @@ CREATE TABLE `mythweb_sessions` (
 -- Table structure for table `networkiconmap`
 --
 
-DROP TABLE IF EXISTS `networkiconmap`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `networkiconmap` (
@@ -1156,7 +1104,6 @@ CREATE TABLE `networkiconmap` (
 -- Table structure for table `oldfind`
 --
 
-DROP TABLE IF EXISTS `oldfind`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `oldfind` (
@@ -1170,7 +1117,6 @@ CREATE TABLE `oldfind` (
 -- Table structure for table `oldprogram`
 --
 
-DROP TABLE IF EXISTS `oldprogram`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `oldprogram` (
@@ -1184,7 +1130,6 @@ CREATE TABLE `oldprogram` (
 -- Table structure for table `oldrecorded`
 --
 
-DROP TABLE IF EXISTS `oldrecorded`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `oldrecorded` (
@@ -1228,7 +1173,6 @@ CREATE TABLE `oldrecorded` (
 -- Table structure for table `people`
 --
 
-DROP TABLE IF EXISTS `people`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `people` (
@@ -1236,14 +1180,13 @@ CREATE TABLE `people` (
   `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
   PRIMARY KEY (`person`),
   UNIQUE KEY `name` (`name`(41))
-) ENGINE=MyISAM AUTO_INCREMENT=3781 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `pidcache`
 --
 
-DROP TABLE IF EXISTS `pidcache`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `pidcache` (
@@ -1258,7 +1201,6 @@ CREATE TABLE `pidcache` (
 -- Table structure for table `playgroup`
 --
 
-DROP TABLE IF EXISTS `playgroup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `playgroup` (
@@ -1276,7 +1218,6 @@ CREATE TABLE `playgroup` (
 -- Table structure for table `powerpriority`
 --
 
-DROP TABLE IF EXISTS `powerpriority`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `powerpriority` (
@@ -1291,7 +1232,6 @@ CREATE TABLE `powerpriority` (
 -- Table structure for table `profilegroups`
 --
 
-DROP TABLE IF EXISTS `profilegroups`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `profilegroups` (
@@ -1303,14 +1243,13 @@ CREATE TABLE `profilegroups` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`,`hostname`),
   KEY `cardtype` (`cardtype`)
-) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `program`
 --
 
-DROP TABLE IF EXISTS `program`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `program` (
@@ -1366,7 +1305,6 @@ CREATE TABLE `program` (
 -- Table structure for table `programgenres`
 --
 
-DROP TABLE IF EXISTS `programgenres`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `programgenres` (
@@ -1383,7 +1321,6 @@ CREATE TABLE `programgenres` (
 -- Table structure for table `programrating`
 --
 
-DROP TABLE IF EXISTS `programrating`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `programrating` (
@@ -1400,7 +1337,6 @@ CREATE TABLE `programrating` (
 -- Table structure for table `recgrouppassword`
 --
 
-DROP TABLE IF EXISTS `recgrouppassword`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recgrouppassword` (
@@ -1414,7 +1350,6 @@ CREATE TABLE `recgrouppassword` (
 -- Table structure for table `record`
 --
 
-DROP TABLE IF EXISTS `record`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `record` (
@@ -1475,14 +1410,13 @@ CREATE TABLE `record` (
   KEY `maxepisodes` (`maxepisodes`),
   KEY `search` (`search`),
   KEY `type` (`type`)
-) ENGINE=MyISAM AUTO_INCREMENT=3482 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `record_tmp`
 --
 
-DROP TABLE IF EXISTS `record_tmp`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `record_tmp` (
@@ -1532,14 +1466,13 @@ CREATE TABLE `record_tmp` (
   `storagegroup` varchar(32) NOT NULL DEFAULT 'Default',
   `avg_delay` int(11) NOT NULL DEFAULT '100',
   PRIMARY KEY (`recordid`)
-) ENGINE=MyISAM AUTO_INCREMENT=1897 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `recorded`
 --
 
-DROP TABLE IF EXISTS `recorded`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recorded` (
@@ -1600,7 +1533,6 @@ CREATE TABLE `recorded` (
 -- Table structure for table `recordedartwork`
 --
 
-DROP TABLE IF EXISTS `recordedartwork`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedartwork` (
@@ -1617,7 +1549,6 @@ CREATE TABLE `recordedartwork` (
 -- Table structure for table `recordedcredits`
 --
 
-DROP TABLE IF EXISTS `recordedcredits`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedcredits` (
@@ -1634,7 +1565,6 @@ CREATE TABLE `recordedcredits` (
 -- Table structure for table `recordedfile`
 --
 
-DROP TABLE IF EXISTS `recordedfile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedfile` (
@@ -1665,7 +1595,6 @@ CREATE TABLE `recordedfile` (
 -- Table structure for table `recordedmarkup`
 --
 
-DROP TABLE IF EXISTS `recordedmarkup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedmarkup` (
@@ -1682,7 +1611,6 @@ CREATE TABLE `recordedmarkup` (
 -- Table structure for table `recordedprogram`
 --
 
-DROP TABLE IF EXISTS `recordedprogram`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedprogram` (
@@ -1732,7 +1660,6 @@ CREATE TABLE `recordedprogram` (
 -- Table structure for table `recordedrating`
 --
 
-DROP TABLE IF EXISTS `recordedrating`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedrating` (
@@ -1749,7 +1676,6 @@ CREATE TABLE `recordedrating` (
 -- Table structure for table `recordedseek`
 --
 
-DROP TABLE IF EXISTS `recordedseek`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordedseek` (
@@ -1766,7 +1692,6 @@ CREATE TABLE `recordedseek` (
 -- Table structure for table `recordfilter`
 --
 
-DROP TABLE IF EXISTS `recordfilter`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordfilter` (
@@ -1782,7 +1707,6 @@ CREATE TABLE `recordfilter` (
 -- Table structure for table `recordingprofiles`
 --
 
-DROP TABLE IF EXISTS `recordingprofiles`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordingprofiles` (
@@ -1793,14 +1717,13 @@ CREATE TABLE `recordingprofiles` (
   `profilegroup` int(10) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `profilegroup` (`profilegroup`)
-) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `recordmatch`
 --
 
-DROP TABLE IF EXISTS `recordmatch`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `recordmatch` (
@@ -1823,7 +1746,6 @@ CREATE TABLE `recordmatch` (
 -- Table structure for table `scannerfile`
 --
 
-DROP TABLE IF EXISTS `scannerfile`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `scannerfile` (
@@ -1840,7 +1762,6 @@ CREATE TABLE `scannerfile` (
 -- Table structure for table `scannerpath`
 --
 
-DROP TABLE IF EXISTS `scannerpath`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `scannerpath` (
@@ -1856,7 +1777,6 @@ CREATE TABLE `scannerpath` (
 -- Table structure for table `schemalock`
 --
 
-DROP TABLE IF EXISTS `schemalock`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `schemalock` (
@@ -1868,7 +1788,6 @@ CREATE TABLE `schemalock` (
 -- Table structure for table `settings`
 --
 
-DROP TABLE IF EXISTS `settings`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `settings` (
@@ -1883,7 +1802,6 @@ CREATE TABLE `settings` (
 -- Table structure for table `storagegroup`
 --
 
-DROP TABLE IF EXISTS `storagegroup`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `storagegroup` (
@@ -1894,14 +1812,13 @@ CREATE TABLE `storagegroup` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `grouphostdir` (`groupname`,`hostname`,`dirname`),
   KEY `hostname` (`hostname`)
-) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `tvchain`
 --
 
-DROP TABLE IF EXISTS `tvchain`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `tvchain` (
@@ -1924,7 +1841,6 @@ CREATE TABLE `tvchain` (
 -- Table structure for table `tvosdmenu`
 --
 
-DROP TABLE IF EXISTS `tvosdmenu`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `tvosdmenu` (
@@ -1942,7 +1858,6 @@ CREATE TABLE `tvosdmenu` (
 -- Table structure for table `upnpmedia`
 --
 
-DROP TABLE IF EXISTS `upnpmedia`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `upnpmedia` (
@@ -1966,35 +1881,32 @@ CREATE TABLE `upnpmedia` (
 -- Table structure for table `videocast`
 --
 
-DROP TABLE IF EXISTS `videocast`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 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=574 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `videocategory`
 --
 
-DROP TABLE IF EXISTS `videocategory`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 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 AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `videocollection`
 --
 
-DROP TABLE IF EXISTS `videocollection`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videocollection` (
@@ -2024,35 +1936,32 @@ CREATE TABLE `videocollection` (
 -- Table structure for table `videocountry`
 --
 
-DROP TABLE IF EXISTS `videocountry`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 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 AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `videogenre`
 --
 
-DROP TABLE IF EXISTS `videogenre`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 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 AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `videometadata`
 --
 
-DROP TABLE IF EXISTS `videometadata`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videometadata` (
@@ -2094,14 +2003,13 @@ CREATE TABLE `videometadata` (
   PRIMARY KEY (`intid`),
   KEY `director` (`director`),
   KEY `title` (`title`)
-) ENGINE=MyISAM AUTO_INCREMENT=9077 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `videometadatacast`
 --
 
-DROP TABLE IF EXISTS `videometadatacast`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videometadatacast` (
@@ -2115,7 +2023,6 @@ CREATE TABLE `videometadatacast` (
 -- Table structure for table `videometadatacountry`
 --
 
-DROP TABLE IF EXISTS `videometadatacountry`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videometadatacountry` (
@@ -2131,7 +2038,6 @@ CREATE TABLE `videometadatacountry` (
 -- Table structure for table `videometadatagenre`
 --
 
-DROP TABLE IF EXISTS `videometadatagenre`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videometadatagenre` (
@@ -2147,7 +2053,6 @@ CREATE TABLE `videometadatagenre` (
 -- Table structure for table `videopart`
 --
 
-DROP TABLE IF EXISTS `videopart`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videopart` (
@@ -2162,7 +2067,6 @@ CREATE TABLE `videopart` (
 -- Table structure for table `videopathinfo`
 --
 
-DROP TABLE IF EXISTS `videopathinfo`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videopathinfo` (
@@ -2179,7 +2083,6 @@ CREATE TABLE `videopathinfo` (
 -- Table structure for table `videosource`
 --
 
-DROP TABLE IF EXISTS `videosource`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videosource` (
@@ -2195,14 +2098,13 @@ CREATE TABLE `videosource` (
   `dvb_nit_id` int(6) DEFAULT '-1',
   PRIMARY KEY (`sourceid`),
   UNIQUE KEY `name` (`name`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `videotypes`
 --
 
-DROP TABLE IF EXISTS `videotypes`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `videotypes` (
@@ -2212,7 +2114,7 @@ CREATE TABLE `videotypes` (
   `f_ignore` tinyint(1) DEFAULT NULL,
   `use_default` tinyint(1) DEFAULT NULL,
   PRIMARY KEY (`intid`)
-) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
@@ -2224,4 +2126,4 @@ CREATE TABLE `videotypes` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2015-12-21 16:03:27
+-- Dump completed on 2015-12-24  5:08:30