· 8 years ago · Aug 28, 2018, 05:54 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Erstellungszeit: 28. Aug 2018 um 19:49
7-- Server-Version: 10.1.34-MariaDB
8-- PHP-Version: 7.2.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Datenbank: `test`
23--
24CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `test`;
26
27-- --------------------------------------------------------
28
29--
30-- Tabellenstruktur für Tabelle `testtable`
31--
32
33CREATE TABLE `testtable` (
34 `id` int(11) NOT NULL,
35 `flip` varchar(16) CHARACTER SET utf8 NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38--
39-- Daten für Tabelle `testtable`
40--
41
42INSERT INTO `testtable` (`id`, `flip`) VALUES
43(2, '(╯°□°)╯︵ â”»â”â”»');
44
45--
46-- Indizes der exportierten Tabellen
47--
48
49--
50-- Indizes für die Tabelle `testtable`
51--
52ALTER TABLE `testtable`
53 ADD PRIMARY KEY (`id`);
54
55--
56-- AUTO_INCREMENT für exportierte Tabellen
57--
58
59--
60-- AUTO_INCREMENT für Tabelle `testtable`
61--
62ALTER TABLE `testtable`
63 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
64COMMIT;
65
66/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
67/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
68/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;