1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
|
create table PROFIL
(
IDPROFIL INTEGER not null auto_increment,
PSEUDO CHAR(50) not null,
IDPERSO INTEGER ,
IDLOCA INTEGER not null,
IDPRESENTATION INTEGER ,
IDDITEPLUS INTEGER ,
SEXE CHAR(6) not null,
DATENAISSANCE DATE not null,
LANGUEPARLER CHAR(100) ,
TAILLE INTEGER ,
CHEVEUX CHAR(50) ,
NIVETUDE CHAR(50) ,
CATPROF CHAR(50) ,
STATMARITAL CHAR(50) ,
ETHNIC CHAR(50) ,
YEUX CHAR(50) ,
PROFESSION CHAR(50) ,
LONGUEURCHEVEUX CHAR(50) ,
SIGNEPART CHAR(50) ,
ATTRAY CHAR(50) ,
PILOSITE CHAR(50) ,
SILHOUETTE CHAR(50) ,
primary key (IDPROFIL)
)ENGINE= InnoDB;
create table RECHERCHER
(
IDPROFIL INTEGER not null,
PSEUDORECH CHAR(50) ,
SEXERECH CHAR(50) ,
AGEMINRECH INTEGER ,
AGEMAXRECH INTEGER ,
TAILLEMINRECH INTEGER ,
TAILLEMAXRECH INTEGER ,
SILHOURECH CHAR(50) ,
ETHNICRECH CHAR(50) ,
STATRECH CHAR(50) ,
FUMEURRECH CHAR(50) ,
DESIRERECH CHAR(150) ,
ENVICONCRETIRECH CHAR(150) ,
NATRECH CHAR(50) ,
primary key (IDPROFIL)
)ENGINE= InnoDB;
create table PERSONNALITE
(
IDPERSO INTEGER not null auto_increment,
STYLEVIE CHAR(150) ,
FUMEUR CHAR(50) ,
LOOK CHAR(50) ,
CARACTERE CHAR(250) ,
LIEUPREF CHAR(150) ,
VOYAGEREA CHAR(150) ,
CUISINE CHAR(150) ,
PLATFAV CHAR(100) ,
SEXUALITE CHAR(100) ,
PREFSEX CHAR(100) ,
SORTI CHAR(250) ,
ACTSPORTIVE CHAR(250) ,
primary key (IDPERSO)
)ENGINE= InnoDB; |