axH2vAtB

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Erstellungszeit: 15. Dez 2017 um 20:31
7-- Server-Version: 10.2.8-MariaDB
8-- PHP-Version: 5.6.31
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: `fivecloud`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Tabellenstruktur für Tabelle `accounts`
29--
30
31DROP TABLE IF EXISTS `accounts`;
32CREATE TABLE IF NOT EXISTS `accounts` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `sc_name` char(255) NOT NULL,
35  `password` char(72) NOT NULL,
36  `role` tinyint(3) UNSIGNED NOT NULL,
37  `last_ip` char(50) NOT NULL,
38  `last_seen` datetime NOT NULL,
39  `banned` tinyint(1) NOT NULL,
40  `banned_type` tinyint(3) UNSIGNED NOT NULL,
41  PRIMARY KEY (`id`),
42  UNIQUE KEY `IX_sc_name` (`sc_name`) USING HASH
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45-- --------------------------------------------------------
46
47--
48-- Tabellenstruktur für Tabelle `characters`
49--
50
51DROP TABLE IF EXISTS `characters`;
52CREATE TABLE IF NOT EXISTS `characters` (
53  `id` int(11) NOT NULL AUTO_INCREMENT,
54  `idAccount` int(11) NOT NULL,
55  `firstname` char(255) NOT NULL,
56  `lastname` char(255) NOT NULL,
57  `skinid` int(11) NOT NULL,
58  PRIMARY KEY (`id`)
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61-- --------------------------------------------------------
62
63--
64-- Tabellenstruktur für Tabelle `characters_skin`
65--
66
67DROP TABLE IF EXISTS `characters_skin`;
68CREATE TABLE IF NOT EXISTS `characters_skin` (
69  `id` int(11) NOT NULL AUTO_INCREMENT,
70  `firstname` char(255) NOT NULL,
71  `lastname` char(255) NOT NULL,
72  `bday` int(11) NOT NULL,
73  `bmonth` int(11) NOT NULL,
74  `byear` int(11) NOT NULL,
75  `gender` char(72) DEFAULT NULL,
76  `mother` int(11) NOT NULL,
77  `father` int(11) NOT NULL,
78  PRIMARY KEY (`id`)
79) ENGINE=InnoDB DEFAULT CHARSET=latin1;
80
81-- --------------------------------------------------------
82
83--
84-- Tabellenstruktur für Tabelle `__migrationhistory`
85--
86
87DROP TABLE IF EXISTS `__migrationhistory`;
88CREATE TABLE IF NOT EXISTS `__migrationhistory` (
89  `MigrationId` varchar(150) CHARACTER SET utf8 NOT NULL,
90  `ContextKey` varchar(300) CHARACTER SET utf8 NOT NULL,
91  `Model` longblob NOT NULL,
92  `ProductVersion` varchar(32) CHARACTER SET utf8 NOT NULL,
93  PRIMARY KEY (`MigrationId`)
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96--
97-- Daten für Tabelle `__migrationhistory`
98--
99
100INSERT INTO `__migrationhistory` (`MigrationId`, `ContextKey`, `Model`, `ProductVersion`) VALUES
101('201712142245411_initialize_database', 'FiveCloud.Data.Migrations.Configuration', 0x1f8b0800000000000400ed5acd6edb4610be17e83b103c27a2edc0686b48096c392e84dab111dab91a2b72242db2dc65b84bd742d127eba18fd457e82c7f97a44491945da741904b34dcfd76f6e3cc707efccf5f7f8fdf3d06cc7a804852c127f6e1e8c0b6807bc2a77c39b163b578fdb3fdeeed8f3f8cdffbc1a3f5295ff746afc39d5c4eec9552e189e3486f050191a3807a919062a1469e081ce20be7e8e0e017e7f0d00184b011cbb2c61f63ae6800c90ffc3915dc8350c5845d091f98cce4f8c44d50ad0f240019120f26f6057d802913b13f3a278a8cd20db675ca2841655c600bdb229c0b4514aa7a7227c15591e04b37440161b7eb1070dd823009d9154ecae55d6f7370a46fe3941b73282f964a043d010fdf64f438f5ed8348b60bfa90c0f748b45aeb5b27244eec53cf13c87ec29b6dd50f3c99b2482fdec2f3c8dcfdcaaaae7955d8079a91fef7ca9ac64cc5114c38c42a22b8e3269e33eafd06eb5bf119f884c78c99eaa2c2f8ac2240d14d244288d4fa232caa9798f9b6e554b73bf5fdc5eee6d6f4a233aede1cd9d6075485cc1914b66190e22a11c1afc021220afc1ba21444f86a673e24ec3694a81de90a0f2dcf63f15cffcecf45b34427b3ad2bf278097ca95613fbe8f8d846521fc1cf25992e779ca24fe22615c5b041d7f6f36f8894bf8bc86f39f9a7a3e738f8a360e575d133475a207bc35c12a966618bf6c707cfa1bd3ed605e0f9c168e3704b83fe40337986c60405ff67026920bc370ea268800aa329722a6e851b3b6528680d10d315898887163e304454f7bf609018121dfecbb0d03912b5c35cd048aa97092cda435ee664f733e5fd88eb6cff1a7aa0e9175bbf5bfd7773ad446e1aa9954fd6fb797a821208ae564f80b30612ed078336e043b47f52d17eca95502bd853d30bd217637bb48803235664f9cc4c5e30b22ccb8abe71238179aa9881f4e26b616b7c1b59bab156508b245710cc21cad34346d69a9d4f84c5f8f3a0c16665b51b87a18894b1e1b07dc3a91f505e2c3e6af29c32dac2b299e3ec4b7589f5627c7f101cbab27d0b01b24da27557b62fe9025492a4f6235c1b3b96e18a505e6015fc9c9f6d201a2beb8c6b99797255ad14d305554d77d05d4ad7ca92d86a4deab4e3e8fc7213483d6fdd01a3bfd59b608ccfffa680507054f6289cb4499137339c2ddd8cf11509433412a3bb91492c376d6d4c5fbbfd0bfe20c5703cb9a1ee2fb42d4ec28f375942ed291e8d9a265f66ed0973a23d6bea078d65a6456ca1373fa9f6d2eb894bc97bbe41ffbf66775b5b0f75b892cb0bbc5e809948725328b4aaf53d1adb9356136124da9ea34f058b039e8a6923c96a03a9d7ff2692f4ee7922ec0e5796f326505848bb23a5f5b989122592ee0879696e623094ddd3b02f4c5a6a37806422ee0e5516db26d43c9375c7298aed26ccbd4a1e34b1c64ecd0aeb56ef34ccbe96a9d7dda89393a511717f0fab45d0fe3eb60b60eb3bdbcbbdb6fa68f6a00f96519d98580b2deeeba765b95137eabe4879b55b091c28dbccd30b5961fa41dddf0acb0f707f036cd9fb3cb6f775da4b596e56825722e98992959b159c4cd613292d382b40a9a83b4e5e719a20cb4cd61d25af284d942093f578f3a489b220db509ed5271bb9697d49717a91a3d672d1719617ee1ebf3512c574896d213d0fd4d749e2d5dafdc23297d6ff9d320a3a0ae72bae08c72245aab486b28f47c7b5f1ddd7334a73a4f4598f79da807e5d33deeceed7d1a25f4735b13b3b723ddb25454e9a9ee1adb49736eabf19fadde3c4fe034bf23b4ebfc47062dd621568fdd96ca8f53c3faccdab52056a8da59e9891318a8a15e5eb84b99e204566bb452f3d871a02298d29938fef302de06f22f0683a6fef8f3baf4c9ce642b0811059b2db8bb9a1b3a66fc37d8cc4d338a5278891416c31b6219e5526134f089a67a25d2f3b6012f36d18c6ffe89dce8d61c510f39d57c6148310cc01c5108065653cb1e31bd2651211542611839c9af44368f7947abbb6d9c3ebd490cd9a9d3b9ab2699a879fa7b940fd538d49d1d1edd0b2355bb33b7bb79b4ef3f235bbcf337ab86dfdddf653ee755c1bdc046e26d463c7fcabb7f13948ba2c21f4dfc071f074665582e66b667c217253c25b9a1ae54bea350e28829904398d145de07df0b107522613ba6c30f03e98833fe3d7b10a63752a25047356a90fc74efbf949a7bbaaf3f83ad4bfe4535c01d5a43a19bae66731657ea1f7c5063fd902a13d228bdfa895ab741c5f96a3947410d30528a3ef1c421d54b8d263198660f29abbe40186e87627e11296c45be765d17690dd2fa24afbf89c92654402996194fbf127dab01f3cbefd1734ed9bc3fc290000, '6.2.0-61023');
102COMMIT;
103
104/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
105/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
106/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;