1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
CREATE TABLE Logiciel
(nLog varchar(5),
nomLog varchar(20) NOT NULL,
dateAch DATETIME,
version varchar(7),
typeLog varchar(9),
prix DECIMAL(6,2),
CONSTRAINT pk_Logiciel PRIMARY KEY (nLog),
CONSTRAINT ck_prix CHECK (prix >= 0));
CREATE TABLE Installer
(nPoste varchar(7),
nLog varchar(5),
numIns INTEGER(5) AUTO_INCREMENT,
dateIns TIMESTAMP DEFAULT NOW(),
delai DECIMAL(8,2),
CONSTRAINT pk_Installer PRIMARY KEY(numIns));
CREATE TABLE Types
(typeLP varchar(9), nomType varchar(20),
CONSTRAINT pk_types PRIMARY KEY(typeLP)); |
Partager