35 lines
866 B
SQL
35 lines
866 B
SQL
drop database if exists PPE2;
|
|
create database PPE2;
|
|
use PPE2;
|
|
|
|
create table Profil (
|
|
idprofil int (3) not null auto_increment,
|
|
nom varchar (50),
|
|
prenom varchar (50),
|
|
adresse varchar (100),
|
|
mail varchar (100),
|
|
mdp varchar (50),
|
|
droits varchar (50),
|
|
primary key (idprofil)
|
|
);
|
|
|
|
insert into Profil values
|
|
(null, "admin Nom", "admin Prenom", "rue de Paris", "admin@gmail.com", "123", "tout"),
|
|
(null, "user Nom", "user Prenom", "rue de Lyon", "user@gmail.com", "123", "0-0-1");
|
|
|
|
create table client (
|
|
|
|
idclient int(5) not null auto_increment,
|
|
nom varchar(50),
|
|
prenom varchar(50),
|
|
email varchar(50),
|
|
adresse varchar(50),
|
|
primary key (idclient)
|
|
);
|
|
|
|
insert into client values ("","ben", "oka","oka@gmail.com","rue de paris, limoges"),
|
|
("","Edwina", "serine","ed@gmail.com","rue de lyon, paris"),
|
|
("","kamar", "elie","kamar@gmail.com","rue de lille, Lyon");
|
|
|
|
|