wzjUdxYQ

1CREATE DATABASE IF NOT EXISTS Parc CHARACTER SET 'utf8' COLLATE utf8_unicode_ci;
2USE Parc
3
4CREATE TABLE IF NOT EXISTS Segment (
5  indIP VARCHAR(11),
6  nomSegment VARCHAR(20) NOT NULL,
7  etage TINYINT(1),
8  CONSTRAINT pk_indIP PRIMARY KEY(indIP)
9)
10ENGINE = INNODB;
11
12CREATE TABLE IF NOT EXISTS Salle (
13  nSalle VARCHAR(7),
14  nomSalle VARCHAR(20) NOT NULL,
15  nbPoste TINYINT(2),
16  indIP VARCHAR(11),
17  CONSTRAINT pk_nSalle PRIMARY KEY(nSalle)
18)
19ENGINE = INNODB;
20
21CREATE TABLE IF NOT EXISTS Poste (
22  nPoste VARCHAR(7),
23  nomPoste VARCHAR(20) NOT NULL,
24  indIP VARCHAR(11),
25  ad VARCHAR(3),
26  typePoste VARCHAR(9),
27  nSalle VARCHAR(7),
28  CONSTRAINT pk_nPoste PRIMARY KEY(nPoste),
29  CONSTRAINT ck_ad CHECK(ad >= 0 && ad <= 255)
30)
31ENGINE = INNODB;
32
33CREATE TABLE IF NOT EXISTS Logiciel (
34  nLog VARCHAR(5),
35  nomLog VARCHAR(20),
36  dateAch dateTime,
37  version VARCHAR(7),
38  typeLog VARCHAR(9),
39  prix DECIMAL(6, 2),
40  CONSTRAINT pk_nLog PRIMARY KEY(nLog),
41  CONSTRAINT ck_prix CHECK(prix >= 0)
42)
43ENGINE = INNODB;
44
45CREATE TABLE IF NOT EXISTS Installer (
46  nPoste VARCHAR(7),
47  nLog VARCHAR(5),
48  numIns INTEGER(5) NOT NULL AUTO_INCREMENT,
49  dateIns TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
50  delai SMALLINT,
51  CONSTRAINT pk_numIns PRIMARY KEY(numIns)
52)
53ENGINE = INNODB;
54
55CREATE TABLE IF NOT EXISTS Types (
56  typeLP VARCHAR(9),
57  nomType VARCHAR(20),
58  CONSTRAINT pk_typeLP PRIMARY KEY(typeLP)
59)
60ENGINE = INNODB;