yLUuR9DK

1
2CREATE TABLE IF NOT EXISTS 'USER' (
3  id INT( 255 ) NOT NULL AUTO_INCREMENT,
4  email VARCHAR(20) NOT NULL,
5  nom CHAR(20) NOT NULL,
6  prenom CHAR(20) NOT NULL,
7  mdp VARCHAR(20) NOT NULL,
8  typeUtilisateur CHAR(10) NOT NULL,
9  PRIMARY KEY ( id )
10)ENGINE = InnoDB DEFAULT CHARSET = latin1;
11
12
13
14CREATE TABLE IF NOT EXISTS 'CLIENT' (
15  idClient INT( 255 ) NOT NULL AUTO_INCREMENT,
16  nom CHAR(20) NOT NULL,
17  prenom CHAR(20) NOT NULL,
18  adresse VARCHAR(20) NOT NULL,
19  informationBancaire CHAR(50) NOT NULL,
20  facturePayee VARCHAR(20) NOT NULL,
21  typeUtilisateur CHAR(15) NOT NULL,
22  numeroVelo INT ( 255 ) NOT NULL,
23  PRIMARY KEY ( id )
24)ENGINE = InnoDB DEFAULT CHARSET = latin1;
25
26CREATE TABLE IF NOT EXISTS 'VELO' (
27  numeroVelo INT (255) AUTO_INCREMENT NOT NULL,
28  coordonnees VARCHAR(50) NOT NULL,
29  etatVelo ENUM('crevaison', 'chaine', 'freins', 'selle', 'lumiere', 'guidon', 'autre'),
30  disponibilite VARCHAR(20) NOT NULL,
31  dateMiseService DATE NOT NULL,
32  dateRevision DATE NOT NULL,
33  etatBatterie DATE NOT NULL,
34  coutMaintenance FLOAT NOT NULL,
35  dateDebutLocation DATE NOT NULL,
36  dateFinLocation DATE NOT NULL,
37  revenu INT(100) NOT NULL,
38  idClient INT(255) NOT NULL,
39  PRIMARY KEY ( numeroVelo )
40)ENGINE = InnoDB DEFAULT CHARSET = latin1;