From ddf0002cf3cd6cd03a8fc7b310c8c685a8cfbfa0 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Thu, 24 Dec 2015 05:12:05 +0000 Subject: Remove drop table if exists and auto increment values --- mythfs/unittests/fixtures/schema.sql | 176 ++++++++--------------------------- 1 file 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 -- cgit v1.2.3