CREATE TABLE clients(
Id INT AUTO_INCREMENT,
Client VARCHAR(300) NOT NULL,
Categorie VARCHAR(300) NULL,
Credit VARCHAR(300) NULL,
PRIMARY KEY(Id)
);
INSERT INTO clients (
Client,Categorie,Credit
) VALUES ('Ray Mathieu','Pratiquant',100);
INSERT INTO clients (
Client,Categorie,Credit
) VALUES ('Collette Antoine','Staff',0);
CREATE TABLE rotations (
Id INT AUTO_INCREMENT,
Client VARCHAR(300) NOT NULL,
Saut VARCHAR(300) NULL,
Cout VARCHAR(300) NULL,
PRIMARY KEY(Id)
);
INSERT INTO rotations (
Client,Saut,Cout
) VALUES ('Ray Mathieu','Standard 4000m',1);
INSERT INTO rotations (
Client,Saut,Cout
) VALUES ('Collette Antoine','Init B4',2);
INSERT INTO rotations (
Client,Saut,Cout
) VALUES ('Ray Mathieu','Standard 1500m',11);
INSERT INTO rotations (
Client,Saut,Cout
) VALUES ('Collette Antoine','Standard 4000m',22);