create table room_type
  (type char,
   price mediumint,
   tv ENUM('true', 'false'),
   minibar ENUM('true','false'),
   primary key (type)
  ) engine = InnoDB;


create table room
  (number mediumint not null auto_increment,
   type   char,
   smoker ENUM('true','false'),
   status char,
   primary key (number),
   foreign key [rt] (type) references room_type(type)  
  ) engine = InnoDB;