-- phpMyAdmin SQL Dump -- version 4.3.0 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 12. Aug 2015 um 14:08 -- Server Version: 5.5.43-MariaDB-log -- PHP-Version: 5.5.26 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Datenbank: `MyMusic53` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `art` -- CREATE TABLE IF NOT EXISTS `art` ( `art_id` int(11) NOT NULL, `media_id` int(11) DEFAULT NULL, `media_type` text, `type` text, `url` text ) ENGINE=InnoDB AUTO_INCREMENT=14350 DEFAULT CHARSET=utf8; -- -- Daten für Tabelle `art` -- INSERT INTO `art` (`type`, `url`) VALUES ('fanart', 'http://assets.fanart.tv/fanart/music/a9b88ebb-83aa-4ef7-b674-fabeb572c14e/artistbackground/beatsteaks-4e95dc8689bb7.jpg'), ('thumb', 'http://assets.fanart.tv/fanart/music/a9b88ebb-83aa-4ef7-b674-fabeb572c14e/artistthumb/beatsteaks-5066b77c07f2d.jpg'); -- -- Indizes der exportierten Tabellen -- -- -- Indizes für die Tabelle `art` -- ALTER TABLE `art` ADD PRIMARY KEY (`art_id`), ADD KEY `ix_art` (`media_id`,`media_type`(20),`type`(20)); -- -- AUTO_INCREMENT für exportierte Tabellen -- -- -- AUTO_INCREMENT für Tabelle `art` -- ALTER TABLE `art` MODIFY `art_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14350; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;