z2tkgr2k

1CREATE TABLE `t_cif` (
2  `idCif` int(11) NOT NULL,
3  `cifTitle` varchar(25) NOT NULL,
4  `cifDescription` varchar(255) NOT NULL,
5  `cifEval` float DEFAULT NULL,
6  `cifNbrEval` int(11) DEFAULT NULL,
7  `fkIdUser` int(11) NOT NULL,
8  `fkIdCategory` int(11) NOT NULL,
9	
10-- phpMyAdmin SQL Dump
11-- version 4.5.4.1
12-- http://www.phpmyadmin.net
13--
14-- Client :  localhost
15-- Généré le :  Ven 09 Mars 2018 à 09:25
16-- Version du serveur :  5.7.11
17-- Version de PHP :  7.0.3
18DROP DATABASE IF EXISTS `mycifdb`;
19CREATE DATABASE `mycifdb`;
20USE `mycifdb`;
21SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
22SET time_zone = "+00:00";
23
24
25/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
26/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
27/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
28/*!40101 SET NAMES utf8mb4 */;
29
30--
31-- Base de données :  `mycifdb`
32--
33
34-- --------------------------------------------------------
35
36--
37-- Structure de la table `t_cif`
38--
39
40CREATE TABLE `t_cif` (
41  `idCif` int(11) NOT NULL,
42  `cifTitle` varchar(25) NOT NULL,
43  `cifDescription` varchar(255) NOT NULL,
44  `cifEval` float DEFAULT NULL,
45  `cifNbrEval` int(11) DEFAULT NULL,
46  `fkIdUser` int(11) NOT NULL,
47  `fkIdCategory` int(11) NOT NULL,
48
49    PRIMARY KEY (idCif),
50    FOREIGN KEY (`fkIdUser`) REFERENCES t_user(`idUser`),
51    FOREIGN KEY (`fkIdCategory`) REFERENCES t_category(`idCategory`)
52) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
54-- --------------------------------------------------------
55
56--
57-- Structure de la table `t_category`
58--
59
60CREATE TABLE `t_category` (
61  `idCategory` int(11) NOT NULL,
62  `catName` varchar(25) NOT NULL,
63
64    PRIMARY KEY (`idCategory`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67-- --------------------------------------------------------
68
69--
70-- Structure de la table `t_user`
71--
72
73CREATE TABLE `t_user` (
74  `idUser` int(11) NOT NULL,
75  `usePseudo` varchar(25) NOT NULL,
76  `useDateEntry` date NOT NULL,
77  `useNbrCif` int(11) DEFAULT NULL,
78  `useNbrEval` int(11) DEFAULT NULL,
79  `usePassword` varchar(200) NOT NULL,
80  `useEmail` varchar(50) NOT NULL,
81
82    PRIMARY KEY (`idUser`)
83) ENGINE=InnoDB DEFAULT CHARSET=latin1;
84
85/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
86/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
87/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;