zuG0qHgi

1--
2-- Structure de la table 'User'
3--
4
5DROP TABLE IF EXISTS User;
6CREATE TABLE IF NOT EXISTS User (
7	login int(11) NOT NULL,
8	password varchar(20) NOT NULL,
9	dateDernierMAJ Date NULL,
10	PRIMARY KEY (login)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13
14-- --------------------------------------------------------
15
16--
17-- Structure de la table 'Acces'
18--
19
20DROP TABLE IF EXISTS Acces;
21CREATE TABLE IF NOT EXISTS Acces (
22	idAcces int(11) NOT NULL,
23	nomAcces varchar(50) NOT NULL,
24	iconeAcces Blob NULL,
25	PRIMARY KEY (idAcces)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28-- --------------------------------------------------------
29
30--
31-- Structure de la table 'Tag'
32--
33
34DROP TABLE IF EXISTS Tag;
35CREATE TABLE IF NOT EXISTS Tag (
36	idTag int(11) NOT NULL,
37	nomTag varchar(50) NOT NULL,
38	descTag varchar(150) NULL,
39	PRIMARY KEY (idTag)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41
42
43-- --------------------------------------------------------
44
45--
46-- Structure de la table 'Branche'
47--
48
49DROP TABLE IF EXISTS Branche;
50CREATE TABLE IF NOT EXISTS Branche (
51	idBranche int(11) NOT NULL,
52	nomBranche varchar(50) NOT NULL,
53	urlBranche varchar(150) NOT NULL,
54	idDepot int(11) NOT NULL,
55	idBranche_fusion int(11) DEFAULT NULL,
56	PRIMARY KEY (idBranche),
57	KEY FK_idDepot (idDepot),
58	KEY FK_idBranche_fusion (idBranche_fusion)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
61--
62-- Contraintes pour la table Employé
63--
64ALTER TABLE Branche
65  ADD CONSTRAINT FK_idDepot FOREIGN KEY (idDepot) REFERENCES Depot (idDepot),
66  ADD CONSTRAINT FK_idBranche_fusion FOREIGN KEY (idBranche_fusion) REFERENCES Branche (idBranche_fusion);
67  
68
69-- --------------------------------------------------------
70
71--
72-- Structure de la table 'Contenir'
73--
74
75DROP TABLE IF EXISTS Contenir;
76CREATE TABLE IF NOT EXISTS Contenir (
77	idAcces int(11) NOT NULL,
78	idDepot int(11) NOT NULL,
79	PRIMARY KEY (idAcces, idDepot),
80	KEY FK_idAcces(idAcces),
81	KEY FK_idDepot(idDepot)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;
83
84--
85-- Contraintes pour la table Modèle
86--
87ALTER TABLE Modele
88  ADD CONSTRAINT FK_idAcces FOREIGN KEY (idAcces) REFERENCES Acces (idAcces),
89  ADD CONSTRAINT FK_idDepot FOREIGN KEY (idDepot) REFERENCES Depot (idDepot);