Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.3.0
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Erstellungszeit: 12. Aug 2015 um 14:00
- -- 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: `kodi-music52`
- --
- -- --------------------------------------------------------
- --
- -- 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=14305 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'),
- ('fanart', 'http://assets.fanart.tv/fanart/music/9beb62b2-88db-4cea-801e-162cd344ee53/artistbackground/beastie-boys-4ddbae15831a2.jpg'),
- ('thumb', 'http://assets.fanart.tv/fanart/music/9beb62b2-88db-4cea-801e-162cd344ee53/artistthumb/beastie-boys-4faa62508485e.jpg'),
- ('fanart', 'http://assets.fanart.tv/fanart/music/0103c1cc-4a09-4a5d-a344-56ad99a77193/artistbackground/avril-lavigne-4dd00da9d12d9.jpg'),
- ('thumb', 'http://assets.fanart.tv/fanart/music/0103c1cc-4a09-4a5d-a344-56ad99a77193/artistthumb/lavigne-avril-4fc746d2be45e.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=14305;
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement