zkgk8pgR

1-- phpMyAdmin SQL Dump
2-- version 4.7.4
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mer. 27 déc. 2017 à 15:08
7-- Version du serveur :  5.7.19
8-- Version de PHP :  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-- Base de données :  `twinkle`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `personnage`
29--
30
31DROP TABLE IF EXISTS `personnage`;
32CREATE TABLE IF NOT EXISTS `personnage` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `accountID` int(11) DEFAULT NULL,
35  `nom` text COLLATE latin1_general_ci NOT NULL,
36  `bank` int(11) NOT NULL DEFAULT '0',
37  PRIMARY KEY (`id`),
38  KEY `accountID` (`accountID`)
39) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
40
41--
42-- Déchargement des données de la table `personnage`
43--
44
45INSERT INTO `personnage` (`id`, `accountID`, `nom`, `bank`) VALUES
46(2, 2, 'perso11111', 0),
47(3, 2, 'perso22222', 0),
48(4, 2, 'perso13333', 0);
49
50-- --------------------------------------------------------
51
52--
53-- Structure de la table `users`
54--
55
56DROP TABLE IF EXISTS `users`;
57CREATE TABLE IF NOT EXISTS `users` (
58  `id` int(11) NOT NULL AUTO_INCREMENT,
59  `login` text NOT NULL,
60  `pass` text NOT NULL,
61  PRIMARY KEY (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
63
64--
65-- Déchargement des données de la table `users`
66--
67
68INSERT INTO `users` (`id`, `login`, `pass`) VALUES
69(2, 'ikuyjhgb', '654'),
70(3, 'gfhdgfdh', 'fgbgfnh');
71
72--
73-- Contraintes pour les tables déchargées
74--
75
76--
77-- Contraintes pour la table `personnage`
78--
79ALTER TABLE `personnage`
80  ADD CONSTRAINT `personnage_ibfk_1` FOREIGN KEY (`accountID`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
81COMMIT;
82
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
85/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;