jaMDsYc4

1-- --------------------------------------------------------
2-- Hôte :                        127.0.0.1
3-- Version du serveur:           10.1.18-MariaDB - mariadb.org binary distribution
4-- SE du serveur:                Win64
5-- HeidiSQL Version:             9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Export de la structure de la base pour projectyle
14CREATE DATABASE IF NOT EXISTS `projectyle` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `projectyle`;
16
17-- Export de données de la table projectyle.bateau : ~6 rows (environ)
18/*!40000 ALTER TABLE `bateau` DISABLE KEYS */;
19INSERT INTO `bateau` (`idbateau`, `name`, `largeur`, `longueur`, `hauteur`, `imatriculation`, `type`, `constructeur`, `model`, `moteur`, `bip`, `nomproprietaire`, `prenomproprietaire`) VALUES
20	(27, 'Médor', 7.65, 2.48, 4.56, '45Y0TL', 'Voilier', 'Acno', 'cm356', 50, '2017-01-17 00:00:00', 'Jean', 'Robert'),
21	(28, 'Mondial', 2.05, 4.7, 1, 'TY66TL', 'Semi-rigide', 'Zodiac', 'Pro9man', 50, '2017-01-25 00:00:00', 'Dupont', 'Aurélien'),
22	(29, 'Paragus', 2.2, 6.5, 2.9, '65FDTL', 'Rigide', 'Benetau', '650LD', 300, '2017-01-23 00:00:00', 'Durando', 'Anais'),
23	(30, 'Luxura', 6.6, 54.7, 15, 'YHTJTL', 'Yacht', 'YachtEnterprise', 'ParadisioVr', 4000, '2017-01-13 00:00:00', 'Jayson', 'Derulo'),
24	(31, 'Gertrude', 1.5, 3.5, 0.5, '90YHTL', 'Souple', 'Yamaha', 'Ventura', 15, '2017-03-08 00:00:00', 'Tartanpion', 'Gilbert'),
25	(32, 'Zamass', 15.6, 113, 6.76, 'GY65TL', 'Yacht', 'MS Yacht', 'Van der valk', 10000, '2017-03-16 00:00:00', 'Buitoni', 'Tony');
26/*!40000 ALTER TABLE `bateau` ENABLE KEYS */;
27
28-- Export de données de la table projectyle.maitre__port : ~1 rows (environ)
29/*!40000 ALTER TABLE `maitre__port` DISABLE KEYS */;
30INSERT INTO `maitre__port` (`iduser`, `username`, `password`, `roles`) VALUES
31	(1, 'test', '$2y$13$O/LF6gSJm5ph7mpPzD//Ruj5x8DcOIpsG900sxO9RDSH8EQlSqy1W', '["ROLE_USER"]');
32/*!40000 ALTER TABLE `maitre__port` ENABLE KEYS */;
33/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
34/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
35/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;