Y7ZLS1E4

1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Client: 127.0.0.1
6-- Généré le : Ven 30 Novembre 2018 à 13:33
7-- Version du serveur: 5.5.16
8-- Version de PHP: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données: `tholdippe3`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `container`
27--
28
29CREATE TABLE IF NOT EXISTS `container` (
30  `numContainer` int(11) NOT NULL AUTO_INCREMENT,
31  `dateAchat` date NOT NULL,
32  `typeContainer` varchar(20) DEFAULT NULL,
33  `dateDerniereInspection` date DEFAULT NULL,
34  PRIMARY KEY (`numContainer`)
35) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
36
37--
38-- Contenu de la table `container`
39--
40
41INSERT INTO `container` (`numContainer`, `dateAchat`, `typeContainer`, `dateDerniereInspection`) VALUES
42(1, '2017-01-17', 'Flatracks 40', '2017-02-17'),
43(2, '2017-08-01', 'Open Top 20', '2017-03-17'),
44(3, '2018-06-07', 'Reefer 20', '2017-04-17'),
45(4, '2015-07-27', 'Reefer 40', '2017-05-17'),
46(5, '2017-01-17', 'Flatracks 40', '2015-12-19'),
47(6, '2017-08-01', 'Open Top 20', '2018-01-08'),
48(7, '2018-06-07', 'Reefer 20', '2016-12-07'),
49(8, '2015-07-27', 'Reefer 40', '2015-09-03'),
50(9, '2017-01-17', 'Flatracks 40', '2017-07-14'),
51(10, '2017-08-01', 'Open Top 20', '2017-06-22'),
52(11, '2018-06-07', 'Reefer 20', '2017-04-01'),
53(12, '2015-07-27', 'Reefer 40', '2017-05-24'),
54(13, '2017-01-17', 'Flatracks 40', '2015-05-19'),
55(14, '2017-08-01', 'Open Top 20', '2018-06-08'),
56(15, '2018-06-07', 'Reefer 20', '2016-12-22'),
57(16, '2015-07-27', 'Reefer 40', '2015-07-11');
58
59-- --------------------------------------------------------
60
61--
62-- Structure de la table `declaration`
63--
64
65CREATE TABLE IF NOT EXISTS `declaration` (
66  `codeDeclaration` int(11) NOT NULL AUTO_INCREMENT,
67  `commentaireDeclaration` varchar(255) DEFAULT NULL,
68  `dateDeclaration` date DEFAULT NULL,
69  `urgence` tinyint(1) DEFAULT NULL,
70  `traitee` tinyint(1) DEFAULT NULL,
71  `codeDocker` char(5) DEFAULT NULL,
72  `numContainer` int(11) DEFAULT NULL,
73  `codeProbleme` char(4) DEFAULT NULL,
74  PRIMARY KEY (`codeDeclaration`),
75  KEY `numContainer` (`numContainer`),
76  KEY `codeProbleme` (`codeProbleme`)
77) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
78
79--
80-- Contenu de la table `declaration`
81--
82
83INSERT INTO `declaration` (`codeDeclaration`, `commentaireDeclaration`, `dateDeclaration`, `urgence`, `traitee`, `codeDocker`, `numContainer`, `codeProbleme`) VALUES
84(1, 'eazazaaza', '2018-11-16', 1, 0, 'root0', 6, '4'),
85(4, 'saqsqsqsq', '2018-11-23', 0, 0, 'root0', 3, '5'),
86(5, 'J''ai chié dedans désolé boss', '2018-11-30', 1, 0, 'root0', 16, '5');
87
88-- --------------------------------------------------------
89
90--
91-- Structure de la table `probleme`
92--
93
94CREATE TABLE IF NOT EXISTS `probleme` (
95  `codeProbleme` char(4) NOT NULL,
96  `libelleProbleme` varchar(50) DEFAULT NULL,
97  PRIMARY KEY (`codeProbleme`)
98) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99
100--
101-- Contenu de la table `probleme`
102--
103
104INSERT INTO `probleme` (`codeProbleme`, `libelleProbleme`) VALUES
105('1', 'Tag'),
106('2', 'Corrosion'),
107('3', 'Coque persée'),
108('4', 'Systeme de fermeture defectueux'),
109('5', 'Autre');
110
111--
112-- Contraintes pour les tables exportées
113--
114
115--
116-- Contraintes pour la table `declaration`
117--
118ALTER TABLE `declaration`
119  ADD CONSTRAINT `declaration_ibfk_1` FOREIGN KEY (`numContainer`) REFERENCES `container` (`numContainer`),
120  ADD CONSTRAINT `declaration_ibfk_2` FOREIGN KEY (`codeProbleme`) REFERENCES `probleme` (`codeProbleme`);
121
122/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
123/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
124/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;