def execute(self):
        db.backup_database('sickbeard.db', self.checkDBVersion())

        logger.log(u'Converting TV Episodes table to Indexer Scheme...')

        if self.hasTable('tmp_tv_episodes'):
            logger.log(u'Removing temp tv episode tables left behind from previous updates...')
            self.connection.action('DROP TABLE tmp_tv_episodes')

        self.connection.action('ALTER TABLE tv_episodes RENAME TO tmp_tv_episodes')
        self.connection.action(
            'CREATE TABLE tv_episodes (episode_id INTEGER PRIMARY KEY, showid NUMERIC, indexerid NUMERIC, indexer NUMERIC, name TEXT, season NUMERIC, episode NUMERIC, description TEXT, airdate NUMERIC, hasnfo NUMERIC, hastbn NUMERIC, status NUMERIC, location TEXT, file_size NUMERIC, release_name TEXT, subtitles TEXT, subtitles_searchcount NUMERIC, subtitles_lastsearch TIMESTAMP, is_proper NUMERIC)')
        self.connection.action(
            'INSERT INTO tv_episodes(episode_id, showid, indexerid, name, season, episode, description, airdate, hasnfo, hastbn, status, location, file_size, release_name, subtitles, subtitles_searchcount, subtitles_lastsearch, is_proper) SELECT episode_id, showid, tvdbid, name, season, episode, description, airdate, hasnfo, hastbn, status, location, file_size, release_name, subtitles, subtitles_searchcount, subtitles_lastsearch, is_proper FROM tmp_tv_episodes')
        self.connection.action('DROP TABLE tmp_tv_episodes')

        self.connection.action('CREATE INDEX idx_tv_episodes_showid_airdate ON tv_episodes(showid,airdate);')
        self.connection.action('CREATE INDEX idx_showid ON tv_episodes (showid);')
        self.connection.action('CREATE INDEX idx_status ON tv_episodes (status,season,episode,airdate)')
        self.connection.action('CREATE INDEX idx_sta_epi_air ON tv_episodes (status,episode, airdate)')
        self.connection.action('CREATE INDEX idx_sta_epi_sta_air ON tv_episodes (season,episode, status, airdate)')

        self.connection.action('UPDATE tv_episodes SET indexer = 1')

        self.incDBVersion()
        return self.checkDBVersion()

    def execute(self):
        db.backup_database('sickbeard.db', self.checkDBVersion())

        logger.log(u'Dropping redundant column')
        self.dropColumn('db_version', 'db_minor_version')

        self.setDBVersion(10001)
        return self.checkDBVersion()

    def execute(self):
        db.backup_database('sickbeard.db', self.checkDBVersion())

        if self.hasColumn('tv_shows', 'sub_use_sr_metadata'):
            logger.log(u'Dropping redundant column metadata sub')
            self.dropColumn('tv_shows', 'sub_use_sr_metadata')

        self.setDBVersion(10002)
        return self.checkDBVersion()