wXtVijiU

1-- phpMyAdmin SQL Dump
2-- version 4.8.4
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  mer. 20 mars 2019 à 17:03
7-- Version du serveur :  5.7.24
8-- Version de PHP :  7.2.14
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 :  `restowa`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `address`
29--
30
31DROP TABLE IF EXISTS `address`;
32CREATE TABLE IF NOT EXISTS `address` (
33  `IDAddress` int(11) NOT NULL,
34  `Street` varchar(30) DEFAULT NULL,
35  `City` varchar(30) DEFAULT NULL,
36  `State` varchar(30) DEFAULT NULL,
37  `ZipCode` int(11) DEFAULT NULL,
38  `Country` varchar(30) DEFAULT NULL,
39  PRIMARY KEY (`IDAddress`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41
42-- --------------------------------------------------------
43
44--
45-- Structure de la table `type`
46--
47
48DROP TABLE IF EXISTS `type`;
49CREATE TABLE IF NOT EXISTS `type` (
50  `IDType` int(11) NOT NULL,
51  `NomType` varchar(30) DEFAULT NULL,
52  PRIMARY KEY (`IDType`)
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54
55-- --------------------------------------------------------
56
57--
58-- Structure de la table `useraccounts`
59--
60
61DROP TABLE IF EXISTS `useraccounts`;
62CREATE TABLE IF NOT EXISTS `useraccounts` (
63  `ID` int(11) NOT NULL,
64  `FirstName` varchar(30) DEFAULT NULL,
65  `LastName` varchar(30) DEFAULT NULL,
66  `Email` varchar(30) DEFAULT NULL,
67  `Password` varchar(30) DEFAULT NULL,
68  `PhoneNumber` varchar(30) DEFAULT NULL,
69  `Active` int(11) DEFAULT NULL,
70  `CreationDate` date DEFAULT NULL,
71  `LastModificationDate` date DEFAULT NULL,
72  `ResetPasswordLink` varchar(30) DEFAULT NULL,
73  `ResetLinkValidateDate` date DEFAULT NULL,
74  `IDType` int(11) NOT NULL,
75  `IDAddress` int(11) NOT NULL,
76  PRIMARY KEY (`ID`),
77  UNIQUE KEY `IDType` (`IDType`),
78  UNIQUE KEY `IDAddress` (`IDAddress`)
79) ENGINE=InnoDB DEFAULT CHARSET=latin1;
80
81--
82-- Contraintes pour les tables déchargées
83--
84
85--
86-- Contraintes pour la table `useraccounts`
87--
88ALTER TABLE `useraccounts`
89  ADD CONSTRAINT `useraccounts_ibfk_1` FOREIGN KEY (`IDType`) REFERENCES `type` (`IDType`),
90  ADD CONSTRAINT `useraccounts_ibfk_2` FOREIGN KEY (`IDAddress`) REFERENCES `address` (`IDAddress`);
91COMMIT;
92
93/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
94/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
95/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;