CREATE TABLE accomodation_details (id INT AUTO_INCREMENT, num_students INT, num_males INT, num_females INT, num_adults_paying INT, num_adults_free INT, num_single INT, num_dobule INT, num_twin INT, type TINYINT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE activities (id INT AUTO_INCREMENT, name VARCHAR(100) NOT NULL, description TEXT NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE airport (id INT AUTO_INCREMENT, arrival_airport VARCHAR(100), departure_airport VARCHAR(100), arrival_terminal VARCHAR(100), departure_terminal VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE campus_summer (id INT AUTO_INCREMENT, num_nights INT, prize INT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE cricket_stadium (id INT AUTO_INCREMENT, name VARCHAR(100) NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE days (id INT AUTO_INCREMENT, name VARCHAR(45), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE dinner_premier_inn (id INT AUTO_INCREMENT, dish VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE dinner_rouge (id INT AUTO_INCREMENT, starter VARCHAR(100), main_course VARCHAR(100), dessert VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE english_course (id INT AUTO_INCREMENT, session VARCHAR(40), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE evening_activities (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE family_summer (id INT AUTO_INCREMENT, num_nights INT, prize INT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE fillings (id INT AUTO_INCREMENT, filling_1 VARCHAR(45), fillling_2 VARCHAR(45), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE flight_details (id INT AUTO_INCREMENT, arrival_date DATE, departure_date DATE, arrival_time TIME, departure_time TIME, airport_id INT NOT NULL, INDEX airport_id_idx (airport_id), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE football_stadium (id INT AUTO_INCREMENT, name VARCHAR(200), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE galleries (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE hot_premier_inn (id INT AUTO_INCREMENT, dish VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE hot_revolutionary (id INT AUTO_INCREMENT, day VARCHAR(100), dish VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE hotel_summer (id INT AUTO_INCREMENT, num_nights INT, prize INT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE integration_workshop (id INT AUTO_INCREMENT, integration TINYINT NOT NULL, integration_name VARCHAR(200), workshop_name VARCHAR(200), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE land_details (id INT AUTO_INCREMENT, arrival_date DATE, arrival_time TIME, departure_date DATE, departure_time TIME, land_stations_id INT NOT NULL, INDEX land_stations_id_idx (land_stations_id), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE land_stations (id INT AUTO_INCREMENT, arrival_station VARCHAR(150), departure_station VARCHAR(150), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE legal_finance (id INT AUTO_INCREMENT, name VARCHAR(200), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE museums (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE other_activities (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE packed_lunches (id INT AUTO_INCREMENT, num_vegetarians INT NOT NULL, num_coeliacs INT NOT NULL, num_vegans INT NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE packed_lunches_has_fillings (packed_lunches_id INT NOT NULL, fillings_id INT NOT NULL, id INT AUTO_INCREMENT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE rugby_stadium (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE school_group_details (id INT AUTO_INCREMENT, country VARCHAR(100), sg_name VARCHAR(200), address TEXT, phone DECIMAL(20, 2), fax DECIMAL(20, 2), email VARCHAR(50), lt_name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE school_study_family (id INT AUTO_INCREMENT, num_nights INT, prize INT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE school_study_hotel (id INT AUTO_INCREMENT, num_nights INT, prize INT, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE settings (id VARCHAR(20), users_id INT, days_id INT, school_group_details_id INT, english_course_id INT, evening_activities_id INT, walking_tours_id INT, legal_finance_id INT, integration_workshop_id INT, land_details_id INT, accomodation_details_id INT, flight_details_id INT, theatre_tours_idtheatre_tours INT, football_stadium_id INT, cricket_stadium_id INT, tennis_stadium_idtable1 INT, rugby_stadium_id INT, sport_activities_id INT, museums_id INT, galleries_id INT, shopping_tours_id INT, other_activities_id INT, hot_revolutionary_id INT, hot_premier_inn_id INT, dinner_rouge_id INT, dinner_premier_inn_id INT, hotel_summer_id INT, family_summer_id INT, school_study_hotel_id INT, school_study_family_id INT, campus_summer_id INT, packed_lunches_has_fillings_id INT, INDEX school_group_details_id_idx (school_group_details_id), INDEX english_course_id_idx (english_course_id), INDEX evening_activities_id_idx (evening_activities_id), INDEX walking_tours_id_idx (walking_tours_id), INDEX legal_finance_id_idx (legal_finance_id), INDEX integration_workshop_id_idx (integration_workshop_id), INDEX land_details_id_idx (land_details_id), INDEX accomodation_details_id_idx (accomodation_details_id), INDEX flight_details_id_idx (flight_details_id), INDEX theatre_tours_idtheatre_tours_idx (theatre_tours_idtheatre_tours), INDEX football_stadium_id_idx (football_stadium_id), INDEX cricket_stadium_id_idx (cricket_stadium_id), INDEX tennis_stadium_idtable1_idx (tennis_stadium_idtable1), INDEX rugby_stadium_id_idx (rugby_stadium_id), INDEX sport_activities_id_idx (sport_activities_id), INDEX museums_id_idx (museums_id), INDEX galleries_id_idx (galleries_id), INDEX shopping_tours_id_idx (shopping_tours_id), INDEX other_activities_id_idx (other_activities_id), INDEX hot_revolutionary_id_idx (hot_revolutionary_id), INDEX hot_premier_inn_id_idx (hot_premier_inn_id), INDEX dinner_rouge_id_idx (dinner_rouge_id), INDEX dinner_premier_inn_id_idx (dinner_premier_inn_id), INDEX hotel_summer_id_idx (hotel_summer_id), INDEX family_summer_id_idx (family_summer_id), INDEX school_study_hotel_id_idx (school_study_hotel_id), INDEX school_study_family_id_idx (school_study_family_id), INDEX campus_summer_id_idx (campus_summer_id), INDEX packed_lunches_has_fillings_id_idx (packed_lunches_has_fillings_id), PRIMARY KEY(id, users_id, days_id)) ENGINE = INNODB;
CREATE TABLE shopping_tours (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sport_activities (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE tennis_stadium (id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE theatre_tours (id INT AUTO_INCREMENT, name VARCHAR(200), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE users (id INT AUTO_INCREMENT, username VARCHAR(10) NOT NULL, password VARCHAR(10) NOT NULL, firstname VARCHAR(100), lastname VARCHAR(150), country VARCHAR(100), email VARCHAR(100), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE walking_tours (id INT AUTO_INCREMENT, name VARCHAR(200) NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sf_guard_forgot_password (id BIGINT AUTO_INCREMENT, user_id BIGINT NOT NULL, unique_key VARCHAR(255), expires_at DATETIME NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX user_id_idx (user_id), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sf_guard_group (id BIGINT AUTO_INCREMENT, name VARCHAR(255) UNIQUE, description TEXT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sf_guard_group_permission (group_id BIGINT, permission_id BIGINT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(group_id, permission_id)) ENGINE = INNODB;
CREATE TABLE sf_guard_permission (id BIGINT AUTO_INCREMENT, name VARCHAR(255) UNIQUE, description TEXT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sf_guard_remember_key (id BIGINT AUTO_INCREMENT, user_id BIGINT, remember_key VARCHAR(32), ip_address VARCHAR(50), created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX user_id_idx (user_id), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sf_guard_user (id BIGINT AUTO_INCREMENT, first_name VARCHAR(255), last_name VARCHAR(255), email_address VARCHAR(255) NOT NULL UNIQUE, username VARCHAR(128) NOT NULL UNIQUE, algorithm VARCHAR(128) DEFAULT 'sha1' NOT NULL, salt VARCHAR(128), password VARCHAR(128), is_active TINYINT(1) DEFAULT '1', is_super_admin TINYINT(1) DEFAULT '0', last_login DATETIME, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX is_active_idx_idx (is_active), PRIMARY KEY(id)) ENGINE = INNODB;
CREATE TABLE sf_guard_user_group (user_id BIGINT, group_id BIGINT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(user_id, group_id)) ENGINE = INNODB;
CREATE TABLE sf_guard_user_permission (user_id BIGINT, permission_id BIGINT, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(user_id, permission_id)) ENGINE = INNODB;
ALTER TABLE flight_details ADD CONSTRAINT flight_details_airport_id_airport_id FOREIGN KEY (airport_id) REFERENCES airport(id);
ALTER TABLE land_details ADD CONSTRAINT land_details_land_stations_id_land_stations_id FOREIGN KEY (land_stations_id) REFERENCES land_stations(id);
ALTER TABLE settings ADD CONSTRAINT sppi FOREIGN KEY (packed_lunches_has_fillings_id) REFERENCES packed_lunches_has_fillings(id);
ALTER TABLE settings ADD CONSTRAINT settings_walking_tours_id_walking_tours_id FOREIGN KEY (walking_tours_id) REFERENCES walking_tours(id);
ALTER TABLE settings ADD CONSTRAINT settings_users_id_users_id FOREIGN KEY (users_id) REFERENCES users(id);
ALTER TABLE settings ADD CONSTRAINT settings_theatre_tours_idtheatre_tours_theatre_tours_id FOREIGN KEY (theatre_tours_idtheatre_tours) REFERENCES theatre_tours(id);
ALTER TABLE settings ADD CONSTRAINT settings_tennis_stadium_idtable1_tennis_stadium_id FOREIGN KEY (tennis_stadium_idtable1) REFERENCES tennis_stadium(id);
ALTER TABLE settings ADD CONSTRAINT settings_sport_activities_id_sport_activities_id FOREIGN KEY (sport_activities_id) REFERENCES sport_activities(id);
ALTER TABLE settings ADD CONSTRAINT settings_shopping_tours_id_shopping_tours_id FOREIGN KEY (shopping_tours_id) REFERENCES shopping_tours(id);
ALTER TABLE settings ADD CONSTRAINT settings_school_study_hotel_id_school_study_hotel_id FOREIGN KEY (school_study_hotel_id) REFERENCES school_study_hotel(id);
ALTER TABLE settings ADD CONSTRAINT settings_school_study_family_id_school_study_family_id FOREIGN KEY (school_study_family_id) REFERENCES school_study_family(id);
ALTER TABLE settings ADD CONSTRAINT settings_school_group_details_id_school_group_details_id FOREIGN KEY (school_group_details_id) REFERENCES school_group_details(id);
ALTER TABLE settings ADD CONSTRAINT settings_rugby_stadium_id_rugby_stadium_id FOREIGN KEY (rugby_stadium_id) REFERENCES rugby_stadium(id);
ALTER TABLE settings ADD CONSTRAINT settings_other_activities_id_other_activities_id FOREIGN KEY (other_activities_id) REFERENCES other_activities(id);
ALTER TABLE settings ADD CONSTRAINT settings_museums_id_museums_id FOREIGN KEY (museums_id) REFERENCES museums(id);
ALTER TABLE settings ADD CONSTRAINT settings_legal_finance_id_legal_finance_id FOREIGN KEY (legal_finance_id) REFERENCES legal_finance(id);
ALTER TABLE settings ADD CONSTRAINT settings_land_details_id_land_details_id FOREIGN KEY (land_details_id) REFERENCES land_details(id);
ALTER TABLE settings ADD CONSTRAINT settings_integration_workshop_id_integration_workshop_id FOREIGN KEY (integration_workshop_id) REFERENCES integration_workshop(id);
ALTER TABLE settings ADD CONSTRAINT settings_hotel_summer_id_hotel_summer_id FOREIGN KEY (hotel_summer_id) REFERENCES hotel_summer(id);
ALTER TABLE settings ADD CONSTRAINT settings_hot_revolutionary_id_hot_revolutionary_id FOREIGN KEY (hot_revolutionary_id) REFERENCES hot_revolutionary(id);
ALTER TABLE settings ADD CONSTRAINT settings_hot_premier_inn_id_hot_premier_inn_id FOREIGN KEY (hot_premier_inn_id) REFERENCES hot_premier_inn(id);
ALTER TABLE settings ADD CONSTRAINT settings_galleries_id_galleries_id FOREIGN KEY (galleries_id) REFERENCES galleries(id);
ALTER TABLE settings ADD CONSTRAINT settings_football_stadium_id_football_stadium_id FOREIGN KEY (football_stadium_id) REFERENCES football_stadium(id);
ALTER TABLE settings ADD CONSTRAINT settings_flight_details_id_flight_details_id FOREIGN KEY (flight_details_id) REFERENCES flight_details(id);
ALTER TABLE settings ADD CONSTRAINT settings_family_summer_id_family_summer_id FOREIGN KEY (family_summer_id) REFERENCES family_summer(id);
ALTER TABLE settings ADD CONSTRAINT settings_evening_activities_id_evening_activities_id FOREIGN KEY (evening_activities_id) REFERENCES evening_activities(id);
ALTER TABLE settings ADD CONSTRAINT settings_english_course_id_english_course_id FOREIGN KEY (english_course_id) REFERENCES english_course(id);
ALTER TABLE settings ADD CONSTRAINT settings_dinner_rouge_id_dinner_rouge_id FOREIGN KEY (dinner_rouge_id) REFERENCES dinner_rouge(id);
ALTER TABLE settings ADD CONSTRAINT settings_dinner_premier_inn_id_dinner_premier_inn_id FOREIGN KEY (dinner_premier_inn_id) REFERENCES dinner_premier_inn(id);
ALTER TABLE settings ADD CONSTRAINT settings_days_id_days_id FOREIGN KEY (days_id) REFERENCES days(id);
ALTER TABLE settings ADD CONSTRAINT settings_cricket_stadium_id_cricket_stadium_id FOREIGN KEY (cricket_stadium_id) REFERENCES cricket_stadium(id);
ALTER TABLE settings ADD CONSTRAINT settings_campus_summer_id_campus_summer_id FOREIGN KEY (campus_summer_id) REFERENCES campus_summer(id);
ALTER TABLE settings ADD CONSTRAINT settings_accomodation_details_id_accomodation_details_id FOREIGN KEY (accomodation_details_id) REFERENCES accomodation_details(id);
ALTER TABLE sf_guard_forgot_password ADD CONSTRAINT sf_guard_forgot_password_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_group_permission ADD CONSTRAINT sf_guard_group_permission_permission_id_sf_guard_permission_id FOREIGN KEY (permission_id) REFERENCES sf_guard_permission(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_group_permission ADD CONSTRAINT sf_guard_group_permission_group_id_sf_guard_group_id FOREIGN KEY (group_id) REFERENCES sf_guard_group(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_remember_key ADD CONSTRAINT sf_guard_remember_key_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_user_group ADD CONSTRAINT sf_guard_user_group_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_user_group ADD CONSTRAINT sf_guard_user_group_group_id_sf_guard_group_id FOREIGN KEY (group_id) REFERENCES sf_guard_group(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_user_permission ADD CONSTRAINT sf_guard_user_permission_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE;
ALTER TABLE sf_guard_user_permission ADD CONSTRAINT sf_guard_user_permission_permission_id_sf_guard_permission_id FOREIGN KEY (permission_id) REFERENCES sf_guard_permission(id) ON DELETE CASCADE;