CREATE TABLE `Hotel` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
`ville` INT( 11 ) NOT NULL ,
`adresse` VARCHAR( 200 ) NOT NULL ,
`etoiles` INT( 11 ) NOT NULL ,
`x` INT( 11 ) NOT NULL ,
`y` INT( 11 ) NOT NULL ,
`commentaire` TEXT NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Distance` (
`villedepart` INT( 11 ) NOT NULL ,
`villearrivee` INT( 11 ) NOT NULL ,
`distance` INT( 11 ) NOT NULL
);

CREATE TABLE `Liste_villes` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Ville` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
`pays` VARCHAR( 200 ) NOT NULL ,
`date_debut_festival` DATE NOT NULL ,
`date_fin_festival` DATE NOT NULL ,
`commentaire` TEXT NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Liste_services_hotel` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Spectacle` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
`theatre` INT( 11 ) NOT NULL ,
`date_debut` DATE NOT NULL ,
`date_fin` DATE NOT NULL ,
`commentaire` TEXT NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Theatre` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
`adresse` VARCHAR( 200 ) NOT NULL ,
`x` INT( 11 ) NOT NULL ,
`y` INT( 11 ) NOT NULL ,
`ville` INT( 11 ) NOT NULL ,
`commentaire` TEXT NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Chambre` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`hotel` INT( 11 ) NOT NULL ,
`type` INT( 11 ) NOT NULL ,
`nombre_lits` INT( 11 ) NOT NULL ,
`date_debut_reservation` DATE NOT NULL ,
`date_fin_reservation` DATE NOT NULL ,
`client` INT( 11 ) NOT NULL ,
`commentaire` TEXT NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Place` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`client` INT( 11 ) NOT NULL ,
`type` INT( 11 ) NOT NULL ,
`spectacle` INT( 11 ) NOT NULL ,
`date_reservation` DATE NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Liste_types_place` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Liste_types_chambre` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Prix_place` (
`type` INT( 11 ) NOT NULL ,
`theatre` INT( 11 ) NOT NULL ,
`spectacle` INT( 11 ) NOT NULL ,
`prix` INT( 11 ) NOT NULL
);

CREATE TABLE `Prix_chambre` (
`hotel` INT( 11 ) NOT NULL ,
`type` INT( 11 ) NOT NULL ,
`prix` INT( 11 ) NOT NULL
);

CREATE TABLE `Client` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
`prenom` VARCHAR( 200 ) NOT NULL ,
`mail` VARCHAR( 200 ) NOT NULL ,
`adresse` VARCHAR( 200 ) NOT NULL ,
`ville` INT( 11 ) NOT NULL ,
`budget` INT( 11 ) NOT NULL ,
`commentaire` TEXT NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Services_chambre_proposes` (
`hotel` INT( 11 ) NOT NULL ,
`service` INT( 11 ) NOT NULL ,
`prix_par_jour` INT( 11 ) NOT NULL
);

CREATE TABLE `Liste_services_chambre` (
`numero` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`nom` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `numero` )
);

CREATE TABLE `Services_chambre_choisis` (
`chambre` INT( 11 ) NOT NULL ,
`service_choisi` INT( 11 ) NOT NULL
);

CREATE TABLE `Services_hotel_compris` (
`hotel` INT( 11 ) NOT NULL ,
`service_propose` INT( 11 ) NOT NULL
);