AnsweredAssumed Answered

Database failure. Please refer to sugarcrm.log for details.

Question asked by venkatesh A on Aug 22, 2017
Latest reply on Aug 22, 2017 by Francesca Shiekh

Hi, I am newly sugarcrm developer, I will download existing code install in my localhost. I have successfully install but existing module page display blank, error not display

 

Admin->repair->quick repair and rebuild click cache file rebuild some tables missing database

 

Going to click on the excute button error display "Database failure. Please refer to sugarcrm.log for details please help me how to resolve that issue.

 

 

Error:

Differences found between database and vardefs

The following script will sync the database structure with the structure defined in the vardefs. You have the option of exporting this script and then running it against your database using external database management tools, or to allow the administration module to run the script.

 

NOTE: any changes you make to the script in the textbox will be reflected in the exported or executed code.

 

/* Table : it_itinerary_routing */
/* MISSING TABLE: it_itinerary_routing */
CREATE TABLE it_itinerary_routing (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : lon_long_distance_coach_service */
/* MISSING TABLE: lon_long_distance_coach_service */
CREATE TABLE lon_long_distance_coach_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ginvo_client_invoice */
/* MISSING TABLE: ginvo_client_invoice */
CREATE TABLE ginvo_client_invoice (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,document_name varchar(255) NULL ,filename varchar(255) NULL ,file_ext varchar(100) NULL ,file_mime_type varchar(100) NULL ,active_date date NULL ,exp_date date NULL ,category_id varchar(100) NULL ,subcategory_id varchar(100) NULL ,status_id varchar(100) NULL ,client_address_city varchar(100) NULL ,client_address_state varchar(100) NULL ,client_address_postalcode varchar(20) NULL ,client_address_country varchar(100) NULL ,client_address varchar(255) NULL ,recipient_address_city varchar(100) NULL ,recipient_address_state varchar(100) NULL ,recipient_address_postalcode varchar(20) NULL ,recipient_address_country varchar(100) NULL ,recipient_address varchar(255) NULL ,client_vat_id varchar(255) NULL ,client_name varchar(255) NULL ,client_id varchar(255) NULL ,tour_duration varchar(255) NULL ,tax_no varchar(255) NULL ,service varchar(255) NULL ,recipient_vat_id varchar(255) NULL ,recipient_tax_no varchar(255) NULL ,recipient_name varchar(255) NULL ,pax_numbers varchar(255) NULL ,invoice_number varchar(255) NULL ,iban varchar(255) NULL ,email varchar(255) NULL ,bic varchar(255) NULL ,account_holder varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,phone_mobile varchar(255) NULL ,phone_fax varchar(255) NULL ,pax_tourleader int(255) NULL ,pax_children int(255) NULL ,pax_adults int(255) NULL ,vat float(18,2) NULL ,total float(18,2) NULL ,sub_total float(18,2) NULL ,city varchar(100) NULL ,tour_date_start datetime NULL ,tour_date_end datetime NULL ,expected_payment_date datetime NULL ,remarks text NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_thematic_tour_rates */
/* MISSING TABLE: ggs_thematic_tour_rates */
CREATE TABLE ggs_thematic_tour_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,service_details varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour */
/* MISSING TABLE: ggs_tour */
CREATE TABLE ggs_tour (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(255) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(100) NULL ,phone_mobile varchar(100) NULL ,phone_work varchar(100) NULL ,phone_other varchar(100) NULL ,phone_fax varchar(100) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(100) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_guided_tour */
/* MISSING TABLE: ggs_guided_tour */
CREATE TABLE ggs_guided_tour (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '0' NULL ,language text NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_cruise_vendor */
/* MISSING TABLE: ggs_cruise_vendor */
CREATE TABLE ggs_cruise_vendor (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,cru_description text NULL ,cru_booking_policies varchar(255) NULL ,cru_annual_op_ho_start_date datetime NULL ,cru_annual_op_ho_end_date datetime NULL ,cru_gen_rem_on_payment varchar(255) NULL ,cru_contract_start_date date NULL ,cru_contract_end_date date NULL ,cru_working_days text NULL ,cru_area_of_operation text NULL ,cru_lang_offered_general text NULL ,cru_tax_no varchar(255) NULL ,cru_vat_no varchar(255) NULL ,cru_bic varchar(255) NULL ,cru_iban varchar(255) NULL ,cru_account_holder varchar(255) NULL ,cru_free_place_provided varchar(100) DEFAULT 'no' NULL ,cru_fpp_service varchar(255) NULL ,cru_fpp_remarks varchar(255) NULL ,cru_vat_type varchar(100) DEFAULT '1' NULL ,cru_vat varchar(255) NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : loc_local_coach_service */
/* MISSING TABLE: loc_local_coach_service */
CREATE TABLE loc_local_coach_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : por_porter_service */
/* MISSING TABLE: por_porter_service */
CREATE TABLE por_porter_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_long_distance_coach_vendor */
/* MISSING TABLE: ggs_long_distance_coach_vendor */
CREATE TABLE ggs_long_distance_coach_vendor (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,nationality varchar(255) NULL ,special_remarks varchar(255) NULL ,contract_start_date date NULL ,contract_end_date varchar(255) NULL ,inside_guiding varchar(100) DEFAULT 'no' NULL ,inside_guiding_service varchar(255) NULL ,inside_guiding_remarks varchar(255) NULL ,working_days text NULL ,coach_classification varchar(100) DEFAULT 'star_1' NULL ,area_of_operation text NULL ,languages_known text NULL ,vehicle_type text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,supplement_night_service varchar(255) NULL ,supplement_night_rate varchar(255) NULL ,weekend_supplement_service varchar(255) NULL ,weekend_supplement_rate varchar(255) NULL ,os_city_supplement_service varchar(255) NULL ,os_city_supplement_rate varchar(255) NULL ,airport_supplement_service varchar(255) NULL ,airport_supplement_rate varchar(255) NULL ,travel_expenses_service varchar(255) NULL ,travel_expenses_rate varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,vat varchar(255) NULL ,other_vehicle_type varchar(255) NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : pax_c_pax_children */
/* MISSING TABLE: pax_c_pax_children */
CREATE TABLE pax_c_pax_children (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_local_coach_vendor */
/* MISSING TABLE: ggs_local_coach_vendor */
CREATE TABLE ggs_local_coach_vendor (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,nationality varchar(255) NULL ,special_remarks varchar(255) NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,coach_classification varchar(100) DEFAULT 'star_1' NULL ,vehicle_type text NULL ,other_vehicle_type varchar(255) NULL ,area_of_operation text NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,supplement_night_service varchar(255) NULL ,supplement_night_rate varchar(255) NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,weekend_supplement_service varchar(255) NULL ,weekend_supplement_rate varchar(255) NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,os_city_supplement_service varchar(255) NULL ,os_city_supplement_rate varchar(255) NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplemenet_service varchar(255) NULL ,airport_supplement_rate varchar(255) NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,travel_expenses_service varchar(255) NULL ,travel_expenses_rate varchar(255) NULL ,apt_only varchar(255) NULL ,apt_htl varchar(255) NULL ,apt_pier varchar(255) NULL ,station_only varchar(255) NULL ,stn_pier varchar(255) NULL ,pier_only varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,vat varchar(255) NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_contact_person_vendor */
/* MISSING TABLE: ggs_contact_person_vendor */
CREATE TABLE ggs_contact_person_vendor (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(255) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(100) NULL ,email varchar(255) NULL ,phone_mobile varchar(100) NULL ,phone_work varchar(100) NULL ,phone_other varchar(100) NULL ,phone_fax varchar(100) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(100) NULL ,service_type varchar(100) DEFAULT 'guide' NULL ,primary_contact int(255) NULL ,designation varchar(255) NULL ,contacts_id varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_porter_service_rates */
/* MISSING TABLE: ggs_porter_service_rates */
CREATE TABLE ggs_porter_service_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate_per_luggage varchar(255) NULL ,number_of_luggage varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_local_coach_rates */
/* MISSING TABLE: ggs_local_coach_rates */
CREATE TABLE ggs_local_coach_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_driver_guide_rates */
/* MISSING TABLE: ggs_driver_guide_rates */
CREATE TABLE ggs_driver_guide_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_local_coach_rates_client */
/* MISSING TABLE: ggs_local_coach_rates_client */
CREATE TABLE ggs_local_coach_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_restaurant_vendor */
/* MISSING TABLE: ggs_restaurant_vendor */
CREATE TABLE ggs_restaurant_vendor (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,occasion text NULL ,serve_type text NULL ,number_of_seats varchar(255) NULL ,eating_habits text NULL ,general_remarks_on_payments varchar(255) NULL ,booking_policies varchar(255) NULL ,an_op_ho_start_date date NULL ,an_op_ho_end_date date NULL ,video_upload varchar(100) DEFAULT 'no' NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,area_of_operation text NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,free_place_provided varchar(100) DEFAULT 'no' NULL ,free_place_provided_service varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,vat varchar(255) NULL ,eating_habits_others varchar(255) NULL ,occasion_others varchar(255) NULL ,serve_type_others varchar(255) NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_attraction_rates */
/* MISSING TABLE: ggs_attraction_rates */
CREATE TABLE ggs_attraction_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(255) NULL ,full_attraction_name varchar(255) NULL ,service_name varchar(255) NULL ,type varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate_regular varchar(255) NULL ,rate_reduced varchar(255) NULL ,min_age varchar(255) NULL ,max_age varchar(255) NULL ,pax_children varchar(255) NULL ,group_rate_from varchar(255) NULL ,rate_groups_from varchar(255) NULL ,rate_audio_guide varchar(255) NULL ,guided_tour_surc_per_pax varchar(255) NULL ,guided_tour_surc_per_group varchar(255) NULL ,ticket_fee varchar(255) NULL ,free_place_policy varchar(255) NULL ,cancellation_terms varchar(255) NULL ,remarks varchar(255) NULL ,language varchar(100) DEFAULT 'eng' NULL ,client varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_driver_guide_rates_client */
/* MISSING TABLE: ggs_driver_guide_rates_client */
CREATE TABLE ggs_driver_guide_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_inside_guiding */
/* MISSING TABLE: ggs_inside_guiding */
CREATE TABLE ggs_inside_guiding (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,contacts_id varchar(255) NULL ,remarks varchar(255) NULL ,service_type varchar(100) DEFAULT 'guide' NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : tou_tour_escort_service */
/* MISSING TABLE: tou_tour_escort_service */
CREATE TABLE tou_tour_escort_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_assistant_vendor */
/* MISSING TABLE: ggs_assistant_vendor */
CREATE TABLE ggs_assistant_vendor (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(255) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(100) NULL ,phone_mobile varchar(100) NULL ,phone_work varchar(100) NULL ,phone_other varchar(100) NULL ,phone_fax varchar(100) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(100) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,nationality varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,supplement_night_service varchar(255) NULL ,supplement_night_rate varchar(255) NULL ,weekend_supplement_service varchar(255) NULL ,weekend_supplement_rate varchar(255) NULL ,os_city_supplement_service varchar(255) NULL ,os_city_supplement_rate varchar(255) NULL ,airport_supplement_service varchar(255) NULL ,airport_supplement_rate varchar(255) NULL ,travel_expenses_service varchar(255) NULL ,travel_expenses_rate varchar(255) NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,rating varchar(100) DEFAULT 'star_1' NULL ,area_of_operation text NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,apt_only varchar(255) NULL ,apt_htl varchar(255) NULL ,apt_pier varchar(255) NULL ,station_only varchar(255) NULL ,stn_pier varchar(255) NULL ,pier_only varchar(255) NULL ,vat varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : res_restaurant_service */
/* MISSING TABLE: res_restaurant_service */
CREATE TABLE res_restaurant_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_escort_rates */
/* MISSING TABLE: ggs_tour_escort_rates */
CREATE TABLE ggs_tour_escort_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_conversation */
/* MISSING TABLE: ggs_conversation */
CREATE TABLE ggs_conversation (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,message text NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : attr_attraction_service */
/* MISSING TABLE: attr_attraction_service */
CREATE TABLE attr_attraction_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_porter_service_vendor */
/* MISSING TABLE: ggs_porter_service_vendor */
CREATE TABLE ggs_porter_service_vendor (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,location varchar(100) DEFAULT 'airport' NULL ,other_location varchar(255) NULL ,access_licenses varchar(255) NULL ,special_remarks varchar(255) NULL ,general_remarks_on_payments varchar(255) NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,rating varchar(100) DEFAULT 'star_1' NULL ,area_of_operation text NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,supplement_night_service varchar(255) NULL ,supplement_night_rate varchar(255) NULL ,weekend_supplement_service varchar(255) NULL ,weekend_supplement_rate varchar(255) NULL ,os_city_supplement_service varchar(255) NULL ,os_city_supplement_rate varchar(255) NULL ,airport_supplement_service varchar(255) NULL ,airport_supplement_rate varchar(255) NULL ,travel_expenses_service varchar(255) NULL ,travel_expenses_rate varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,vat varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_assistant_rates_client */
/* MISSING TABLE: ggs_assistant_rates_client */
CREATE TABLE ggs_assistant_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_vehicle_specification */
/* MISSING TABLE: ggs_vehicle_specification */
CREATE TABLE ggs_vehicle_specification (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,vehicle_type varchar(100) DEFAULT 'car' NULL ,other_vehicle_type varchar(255) NULL ,on_board_free_mineral_water varchar(100) DEFAULT 'no' NULL ,guests_seats varchar(255) NULL ,tourleader_seats varchar(255) NULL ,car_classification varchar(100) DEFAULT 'star_1' NULL ,jvw_single_seating_2_tables varchar(100) DEFAULT 'no' NULL ,equipment text NULL ,eo_sliding_doors varchar(100) DEFAULT 'no' NULL ,entertainment text NULL ,other_entertainment varchar(255) NULL ,tinted_windows_n_roller_blinds varchar(100) DEFAULT 'no' NULL ,el_wheelbase_fm_lr_lv varchar(100) DEFAULT 'no' NULL ,ncw_lan_umts_rb varchar(100) DEFAULT 'no' NULL ,leather_seats varchar(100) DEFAULT 'no' NULL ,other_equipment varchar(255) NULL ,other_no_cost_router varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : cru_cruise_service */
/* MISSING TABLE: cru_cruise_service */
CREATE TABLE cru_cruise_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_licences */
/* MISSING TABLE: ggs_licences */
CREATE TABLE ggs_licences (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,licence_name varchar(255) NULL ,remarks varchar(255) NULL ,service_type varchar(100) DEFAULT 'guide' NULL ,contacts_id varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_escort_vendor */
/* MISSING TABLE: ggs_tour_escort_vendor */
CREATE TABLE ggs_tour_escort_vendor (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(255) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(100) NULL ,phone_mobile varchar(100) NULL ,phone_work varchar(100) NULL ,phone_other varchar(100) NULL ,phone_fax varchar(100) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(100) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,nationality varchar(255) NULL ,special_remarks varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,supplement_night_service varchar(255) NULL ,supplement_night_rate varchar(255) NULL ,weekend_supplement_service varchar(255) NULL ,weekend_supplement_rate varchar(255) NULL ,os_city_supplement_service varchar(255) NULL ,os_city_supplement_rate varchar(255) NULL ,airport_supplement_service varchar(255) NULL ,airport_supplement_rate varchar(255) NULL ,travel_expenses_service varchar(255) NULL ,travel_expenses_rate varchar(255) NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,rating varchar(100) DEFAULT 'star_1' NULL ,area_of_operation text NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,apt_only varchar(255) NULL ,apt_htl varchar(255) NULL ,apt_pier varchar(255) NULL ,station_only varchar(255) NULL ,stn_pier varchar(255) NULL ,pier_only varchar(255) NULL ,vat varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_cancellation_term */
/* MISSING TABLE: ggs_tour_cancellation_term */
CREATE TABLE ggs_tour_cancellation_term (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,days varchar(255) NULL ,refund varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_restaurant_rates */
/* MISSING TABLE: ggs_restaurant_rates */
CREATE TABLE ggs_restaurant_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,number_regular varchar(255) NULL ,rate_dish varchar(255) NULL ,number_children varchar(255) NULL ,rate_children_dish varchar(255) NULL ,service_details varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_thematic_tour_rates_client */
/* MISSING TABLE: ggs_thematic_tour_rates_client */
CREATE TABLE ggs_thematic_tour_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,service_details varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_cruise_rates */
/* MISSING TABLE: ggs_cruise_rates */
CREATE TABLE ggs_cruise_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,type varchar(100) DEFAULT 'river_cruise' NULL ,full_cruise_company_name varchar(255) NULL ,service_name varchar(255) NULL ,ship_name varchar(255) NULL ,start_pier varchar(255) NULL ,end_pier varchar(255) NULL ,language varchar(100) DEFAULT 'eng' NULL ,duration varchar(100) DEFAULT '900' NULL ,rate_regular varchar(255) NULL ,minimum_age varchar(255) NULL ,maximum_age varchar(255) NULL ,pax_children varchar(255) NULL ,stud_sen_hand varchar(255) NULL ,group_rate_from varchar(255) NULL ,rate_group_from varchar(255) NULL ,private_boat varchar(255) NULL ,rate_audio_commentary varchar(255) NULL ,ticket_fee varchar(255) NULL ,free_place_policy varchar(255) NULL ,cancellation_terms varchar(255) NULL ,remarks varchar(255) NULL ,client varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_cruise_rates_client */
/* MISSING TABLE: ggs_cruise_rates_client */
CREATE TABLE ggs_cruise_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,type varchar(100) DEFAULT 'river_cruise' NULL ,full_cruise_company_name varchar(255) NULL ,service_name varchar(255) NULL ,ship_name varchar(255) NULL ,start_pier varchar(255) NULL ,end_pier varchar(255) NULL ,language varchar(100) DEFAULT 'eng' NULL ,duration varchar(100) DEFAULT '900' NULL ,rate_regular varchar(255) NULL ,minimum_age varchar(255) NULL ,maximum_age varchar(255) NULL ,pax_children varchar(255) NULL ,stud_sen_hand varchar(255) NULL ,group_rate_from varchar(255) NULL ,rate_group_from varchar(255) NULL ,private_boat varchar(255) NULL ,rate_audio_commentary varchar(255) NULL ,ticket_fee varchar(255) NULL ,free_place_policy varchar(255) NULL ,cancellation_terms varchar(255) NULL ,remarks varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_assistant_rates */
/* MISSING TABLE: ggs_assistant_rates */
CREATE TABLE ggs_assistant_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ser_service_name */
/* MISSING TABLE: ser_service_name */
CREATE TABLE ser_service_name (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_audio_guide_languages */
/* MISSING TABLE: ggs_audio_guide_languages */
CREATE TABLE ggs_audio_guide_languages (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,language text NULL ,contacts_id varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_thematic_tour_vendor */
/* MISSING TABLE: ggs_thematic_tour_vendor */
CREATE TABLE ggs_thematic_tour_vendor (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(255) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(100) NULL ,phone_mobile varchar(100) NULL ,phone_work varchar(100) NULL ,phone_other varchar(100) NULL ,phone_fax varchar(100) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(100) NULL ,option_type varchar(100) DEFAULT 'individual' NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,rating varchar(100) DEFAULT 'star_1' NULL ,area_of_operation text NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,free_place_provided varchar(100) DEFAULT 'no' NULL ,apt_only varchar(255) NULL ,apt_htl varchar(255) NULL ,apt_pier varchar(255) NULL ,station_only varchar(255) NULL ,stn_pier varchar(255) NULL ,pier_only varchar(255) NULL ,vat varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,inside_guiding varchar(100) DEFAULT 'no' NULL ,company_name varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_rates */
/* MISSING TABLE: ggs_rates */
CREATE TABLE ggs_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(255) NULL ,language varchar(255) NULL ,service varchar(255) NULL ,duration varchar(255) NULL ,rate varchar(255) NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_attraction_rates_client */
/* MISSING TABLE: ggs_attraction_rates_client */
CREATE TABLE ggs_attraction_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(255) NULL ,full_attraction_name varchar(255) NULL ,service_name varchar(255) NULL ,language text NULL ,type varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate_regular varchar(255) NULL ,rate_reduced varchar(255) NULL ,min_age varchar(255) NULL ,max_age varchar(255) NULL ,pax_children varchar(255) NULL ,group_rate_from varchar(255) NULL ,rate_groups_from varchar(255) NULL ,rate_audio_guide varchar(255) NULL ,guided_tour_surc_per_pax varchar(255) NULL ,guided_tour_surc_per_group varchar(255) NULL ,ticket_fee varchar(255) NULL ,free_place_policy varchar(255) NULL ,cancellation_terms varchar(255) NULL ,remarks varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : the_thematic_tour_service */
/* MISSING TABLE: the_thematic_tour_service */
CREATE TABLE the_thematic_tour_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_driver_guide_vendor */
/* MISSING TABLE: ggs_driver_guide_vendor */
CREATE TABLE ggs_driver_guide_vendor (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,salutation varchar(255) NULL ,first_name varchar(100) NULL ,last_name varchar(100) NULL ,title varchar(100) NULL ,department varchar(255) NULL ,do_not_call bool DEFAULT '0' NULL ,phone_home varchar(100) NULL ,phone_mobile varchar(100) NULL ,phone_work varchar(100) NULL ,phone_other varchar(100) NULL ,phone_fax varchar(100) NULL ,primary_address_street varchar(150) NULL ,primary_address_city varchar(100) NULL ,primary_address_state varchar(100) NULL ,primary_address_postalcode varchar(20) NULL ,primary_address_country varchar(255) NULL ,alt_address_street varchar(150) NULL ,alt_address_city varchar(100) NULL ,alt_address_state varchar(100) NULL ,alt_address_postalcode varchar(20) NULL ,alt_address_country varchar(255) NULL ,assistant varchar(75) NULL ,assistant_phone varchar(100) NULL ,nationality varchar(255) NULL ,dressing_of_driver varchar(255) NULL ,company_name varchar(255) NULL ,special_remarks varchar(255) NULL ,primary_address text NULL ,contract_start_date date NULL ,contract_end_date date NULL ,working_days text NULL ,inside_guiding varchar(100) DEFAULT 'yes' NULL ,inside_guiding_service varchar(255) NULL ,inside_guiding_remarks varchar(255) NULL ,car_classification varchar(100) DEFAULT 'star_1' NULL ,area_of_operation text NULL ,vehicle_type text NULL ,other_vehicle_type varchar(255) NULL ,languages_known text NULL ,tax_no varchar(255) NULL ,vat_no varchar(255) NULL ,bic varchar(255) NULL ,iban varchar(255) NULL ,account_holder varchar(255) NULL ,supplement_night varchar(100) DEFAULT 'no' NULL ,weekend_supplement varchar(100) DEFAULT 'no' NULL ,outside_city_supplement varchar(100) DEFAULT 'no' NULL ,airport_supplement varchar(100) DEFAULT 'no' NULL ,travel_expenses varchar(100) DEFAULT 'no' NULL ,supplement_night_service varchar(255) NULL ,supplement_night_rate varchar(255) NULL ,weekend_supplement_service varchar(255) NULL ,weekend_supplement_rate varchar(255) NULL ,outside_city_sup_service varchar(255) NULL ,outside_city_sup_rate varchar(255) NULL ,airport_supplement_service varchar(255) NULL ,airport_supplement_rate varchar(255) NULL ,travel_expenses_service varchar(255) NULL ,travel_expenses_rate varchar(255) NULL ,apt_only varchar(255) NULL ,apt_htl varchar(255) NULL ,apt_pier varchar(255) NULL ,station_only varchar(255) NULL ,stn_pier varchar(255) NULL ,pier_only varchar(255) NULL ,user_name varchar(255) NULL ,vat varchar(255) NULL ,vat_type varchar(100) DEFAULT '1' NULL ,option_type varchar(100) DEFAULT 'individual' NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : vou_voucher */
/* MISSING TABLE: vou_voucher */
CREATE TABLE vou_voucher (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : gui_guide_service */
/* MISSING TABLE: gui_guide_service */
CREATE TABLE gui_guide_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : dri_driver_guide_service */
/* MISSING TABLE: dri_driver_guide_service */
CREATE TABLE dri_driver_guide_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_porter_service_rates_client */
/* MISSING TABLE: ggs_porter_service_rates_client */
CREATE TABLE ggs_porter_service_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate_per_luggage varchar(255) NULL ,number_of_luggage varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_cruise_contact_person */
/* MISSING TABLE: ggs_cruise_contact_person */
CREATE TABLE ggs_cruise_contact_person (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,mobile_phone varchar(255) NULL ,office_phone varchar(255) NULL ,email varchar(255) NULL ,designation varchar(255) NULL ,department varchar(255) NULL ,primary_contact varchar(100) DEFAULT 'yes' NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_local_guide_in */
/* MISSING TABLE: ggs_local_guide_in */
CREATE TABLE ggs_local_guide_in (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,remarks varchar(255) NULL ,service_type varchar(100) DEFAULT 'guide' NULL ,contacts_id varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_escort_rates_client */
/* MISSING TABLE: ggs_tour_escort_rates_client */
CREATE TABLE ggs_tour_escort_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ginvo_invoice */
/* MISSING TABLE: ginvo_invoice */
CREATE TABLE ginvo_invoice (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,document_name varchar(255) NULL ,filename varchar(255) NULL ,file_ext varchar(100) NULL ,file_mime_type varchar(100) NULL ,active_date date NULL ,exp_date date NULL ,category_id varchar(100) NULL ,subcategory_id varchar(100) NULL ,status_id varchar(100) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_long_distance_coach_rates_client */
/* MISSING TABLE: ggs_long_distance_coach_rates_client */
CREATE TABLE ggs_long_distance_coach_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_guide_rates */
/* MISSING TABLE: ggs_guide_rates */
CREATE TABLE ggs_guide_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ass_assistant_service */
/* MISSING TABLE: ass_assistant_service */
CREATE TABLE ass_assistant_service (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_pickup_or_drop */
/* MISSING TABLE: ggs_pickup_or_drop */
CREATE TABLE ggs_pickup_or_drop (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,service varchar(255) NULL ,rate varchar(255) NULL ,contacts_id varchar(255) NULL ,service_type varchar(100) DEFAULT 'guide' NULL ,rate_type varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_restaurant_rates_client */
/* MISSING TABLE: ggs_restaurant_rates_client */
CREATE TABLE ggs_restaurant_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,number_regular varchar(255) NULL ,rate_dish varchar(255) NULL ,number_children varchar(255) NULL ,rate_children_dish varchar(255) NULL ,service_details varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_long_distance_coach_rates */
/* MISSING TABLE: ggs_long_distance_coach_rates */
CREATE TABLE ggs_long_distance_coach_rates (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,start_city varchar(100) DEFAULT 'amsterdam' NULL ,end_city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_annual_hours */
/* MISSING TABLE: ggs_annual_hours */
CREATE TABLE ggs_annual_hours (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,service_type varchar(100) DEFAULT 'guide' NULL ,hours_remarks varchar(255) NULL ,type varchar(255) NULL ,contacts_id varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_guide_rates_client */
/* MISSING TABLE: ggs_guide_rates_client */
CREATE TABLE ggs_guide_rates_client (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,client varchar(100) DEFAULT 'gta' NULL ,city varchar(100) DEFAULT 'amsterdam' NULL ,language varchar(100) DEFAULT 'eng' NULL ,service varchar(255) NULL ,duration varchar(100) DEFAULT '900' NULL ,rate varchar(255) NULL ,travel_expenses varchar(255) NULL ,cancellation_terms varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_contact_person */
/* MISSING TABLE: ggs_tour_contact_person */
CREATE TABLE ggs_tour_contact_person (id char(36) NOT NULL ,name varchar(255) NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,description text NULL ,deleted bool DEFAULT '0' NULL ,assigned_user_id char(36) NULL ,contact_person_name varchar(255) NULL ,moblie_phone varchar(255) NULL ,office_phone varchar(255) NULL ,email varchar(255) NULL ,designation varchar(255) NULL ,department varchar(255) NULL , PRIMARY KEY (id)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_local_guide_in_1_c */
/* MISSING TABLE: contacts_ggs_local_guide_in_1_c */
CREATE TABLE contacts_ggs_local_guide_in_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_local_guide_in_1contacts_ida varchar(36) NULL ,contacts_ggs_local_guide_in_1ggs_local_guide_in_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_local_guide_in_1_ida1 (contacts_ggs_local_guide_in_1contacts_ida), KEY contacts_ggs_local_guide_in_1_alt (contacts_ggs_local_guide_in_1ggs_local_guide_in_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_vou_voucher_1_c */
/* MISSING TABLE: ggs_tour_vou_voucher_1_c */
CREATE TABLE ggs_tour_vou_voucher_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_vou_voucher_1ggs_tour_ida varchar(36) NULL ,ggs_tour_vou_voucher_1vou_voucher_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_vou_voucher_1_ida1 (ggs_tour_vou_voucher_1ggs_tour_ida), KEY ggs_tour_vou_voucher_1_alt (ggs_tour_vou_voucher_1vou_voucher_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_assistant_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_assistant_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_assistant_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_assistant_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_gbab9_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_assistant_rates_client_1_ida1 (ggs_tour_ggs_assistant_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_assistant_rates_client_1_alt (ggs_tour_gbab9_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_tou_tour_escort_service_1_c */
/* MISSING TABLE: meetings_tou_tour_escort_service_1_c */
CREATE TABLE meetings_tou_tour_escort_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_tou_tour_escort_service_1meetings_ida varchar(36) NULL ,meetings_tou_tour_escort_service_1tou_tour_escort_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_tou_tour_escort_service_1_ida1 (meetings_tou_tour_escort_service_1meetings_ida), KEY meetings_tou_tour_escort_service_1_idb2 (meetings_tou_tour_escort_service_1tou_tour_escort_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_long_distance_coach_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_long_distance_coach_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_long_distance_coach_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_long_distance_coach_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_gf89d_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_long_distance_coach_rates_client_1_ida1 (ggs_tour_ggs_long_distance_coach_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_long_distance_coach_rates_client_1_alt (ggs_tour_gf89d_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_por_porter_service_1_c */
/* MISSING TABLE: meetings_por_porter_service_1_c */
CREATE TABLE meetings_por_porter_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_por_porter_service_1meetings_ida varchar(36) NULL ,meetings_por_porter_service_1por_porter_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_por_porter_service_1_ida1 (meetings_por_porter_service_1meetings_ida), KEY meetings_por_porter_service_1_idb2 (meetings_por_porter_service_1por_porter_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_guide_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_guide_rates_1_c */
CREATE TABLE ggs_tour_ggs_guide_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_guide_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_guide_rates_1ggs_guide_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_guide_rates_1_ida1 (ggs_tour_ggs_guide_rates_1ggs_tour_ida), KEY ggs_tour_ggs_guide_rates_1_alt (ggs_tour_ggs_guide_rates_1ggs_guide_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : vou_voucher_meetings_1_c */
/* MISSING TABLE: vou_voucher_meetings_1_c */
CREATE TABLE vou_voucher_meetings_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,vou_voucher_meetings_1vou_voucher_ida varchar(36) NULL ,vou_voucher_meetings_1meetings_idb varchar(36) NULL , PRIMARY KEY (id), KEY vou_voucher_meetings_1_ida1 (vou_voucher_meetings_1vou_voucher_ida), KEY vou_voucher_meetings_1_idb2 (vou_voucher_meetings_1meetings_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_porter_service_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_porter_service_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_porter_service_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_porter_service_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_g832e_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_porter_service_rates_client_1_ida1 (ggs_tour_ggs_porter_service_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_porter_service_rates_client_1_alt (ggs_tour_g832e_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_thematic_tour_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_thematic_tour_rates_1_c */
CREATE TABLE ggs_tour_ggs_thematic_tour_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_thematic_tour_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_thematic_tour_rates_1ggs_thematic_tour_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_thematic_tour_rates_1_ida1 (ggs_tour_ggs_thematic_tour_rates_1ggs_tour_ida), KEY ggs_tour_ggs_thematic_tour_rates_1_alt (ggs_tour_ggs_thematic_tour_rates_1ggs_thematic_tour_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_attr_attraction_service_1_c */
/* MISSING TABLE: meetings_attr_attraction_service_1_c */
CREATE TABLE meetings_attr_attraction_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_attr_attraction_service_1meetings_ida varchar(36) NULL ,meetings_attr_attraction_service_1attr_attraction_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_attr_attraction_service_1_ida1 (meetings_attr_attraction_service_1meetings_ida), KEY meetings_attr_attraction_service_1_idb2 (meetings_attr_attraction_service_1attr_attraction_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_gui_guide_service_1_c */
/* MISSING TABLE: meetings_gui_guide_service_1_c */
CREATE TABLE meetings_gui_guide_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_gui_guide_service_1meetings_ida varchar(36) NULL ,meetings_gui_guide_service_1gui_guide_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_gui_guide_service_1_ida1 (meetings_gui_guide_service_1meetings_ida), KEY meetings_gui_guide_service_1_idb2 (meetings_gui_guide_service_1gui_guide_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_restaurant_rates_1_c */
/* MISSING TABLE: contacts_ggs_restaurant_rates_1_c */
CREATE TABLE contacts_ggs_restaurant_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_restaurant_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_restaurant_rates_1ggs_restaurant_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_restaurant_rates_1_ida1 (contacts_ggs_restaurant_rates_1contacts_ida), KEY contacts_ggs_restaurant_rates_1_alt (contacts_ggs_restaurant_rates_1ggs_restaurant_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_local_coach_rates_1_c */
/* MISSING TABLE: contacts_ggs_local_coach_rates_1_c */
CREATE TABLE contacts_ggs_local_coach_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_local_coach_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_local_coach_rates_1ggs_local_coach_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_local_coach_rates_1_ida1 (contacts_ggs_local_coach_rates_1contacts_ida), KEY contacts_ggs_local_coach_rates_1_alt (contacts_ggs_local_coach_rates_1ggs_local_coach_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_loc_local_coach_service_1_c */
/* MISSING TABLE: meetings_loc_local_coach_service_1_c */
CREATE TABLE meetings_loc_local_coach_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_loc_local_coach_service_1meetings_ida varchar(36) NULL ,meetings_loc_local_coach_service_1loc_local_coach_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_loc_local_coach_service_1_ida1 (meetings_loc_local_coach_service_1meetings_ida), KEY meetings_loc_local_coach_service_1_idb2 (meetings_loc_local_coach_service_1loc_local_coach_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_guide_rates_1_c */
/* MISSING TABLE: contacts_ggs_guide_rates_1_c */
CREATE TABLE contacts_ggs_guide_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_guide_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_guide_rates_1ggs_guide_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_guide_rates_1_ida1 (contacts_ggs_guide_rates_1contacts_ida), KEY contacts_ggs_guide_rates_1_alt (contacts_ggs_guide_rates_1ggs_guide_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_local_coach_vendor_1_c */
/* MISSING TABLE: contacts_ggs_local_coach_vendor_1_c */
CREATE TABLE contacts_ggs_local_coach_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_local_coach_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_local_coach_vendor_1ggs_local_coach_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_local_coach_vendor_1_ida1 (contacts_ggs_local_coach_vendor_1contacts_ida), KEY contacts_ggs_local_coach_vendor_1_idb2 (contacts_ggs_local_coach_vendor_1ggs_local_coach_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ginvo_invoice_meetings_1_c */
/* MISSING TABLE: ginvo_invoice_meetings_1_c */
CREATE TABLE ginvo_invoice_meetings_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ginvo_invoice_meetings_1ginvo_invoice_ida varchar(36) NULL ,ginvo_invoice_meetings_1meetings_idb varchar(36) NULL , PRIMARY KEY (id), KEY ginvo_invoice_meetings_1_ida1 (ginvo_invoice_meetings_1ginvo_invoice_ida), KEY ginvo_invoice_meetings_1_idb2 (ginvo_invoice_meetings_1meetings_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_restaurant_vendor_1_c */
/* MISSING TABLE: contacts_ggs_restaurant_vendor_1_c */
CREATE TABLE contacts_ggs_restaurant_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_restaurant_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_restaurant_vendor_1ggs_restaurant_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_restaurant_vendor_1_ida1 (contacts_ggs_restaurant_vendor_1contacts_ida), KEY contacts_ggs_restaurant_vendor_1_idb2 (contacts_ggs_restaurant_vendor_1ggs_restaurant_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_cru_cruise_service_1_c */
/* MISSING TABLE: meetings_cru_cruise_service_1_c */
CREATE TABLE meetings_cru_cruise_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_cru_cruise_service_1meetings_ida varchar(36) NULL ,meetings_cru_cruise_service_1cru_cruise_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_cru_cruise_service_1_ida1 (meetings_cru_cruise_service_1meetings_ida), KEY meetings_cru_cruise_service_1_idb2 (meetings_cru_cruise_service_1cru_cruise_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_attraction_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_attraction_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_attraction_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_attraction_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_g73ec_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_attraction_rates_client_1_ida1 (ggs_tour_ggs_attraction_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_attraction_rates_client_1_alt (ggs_tour_g73ec_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_assistant_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_assistant_rates_1_c */
CREATE TABLE ggs_tour_ggs_assistant_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_assistant_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_assistant_rates_1ggs_assistant_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_assistant_rates_1_ida1 (ggs_tour_ggs_assistant_rates_1ggs_tour_ida), KEY ggs_tour_ggs_assistant_rates_1_alt (ggs_tour_ggs_assistant_rates_1ggs_assistant_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_porter_service_rates_1_c */
/* MISSING TABLE: contacts_ggs_porter_service_rates_1_c */
CREATE TABLE contacts_ggs_porter_service_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_porter_service_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_porter_service_rates_1ggs_porter_service_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_porter_service_rates_1_ida1 (contacts_ggs_porter_service_rates_1contacts_ida), KEY contacts_ggs_porter_service_rates_1_alt (contacts_ggs_porter_service_rates_1ggs_porter_service_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ginvo_client_invoice_meetings_c */
/* MISSING TABLE: ginvo_client_invoice_meetings_c */
CREATE TABLE ginvo_client_invoice_meetings_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ginvo_client_invoice_meetingsginvo_client_invoice_ida varchar(36) NULL ,ginvo_client_invoice_meetingsmeetings_idb varchar(36) NULL , PRIMARY KEY (id), KEY ginvo_client_invoice_meetings_ida1 (ginvo_client_invoice_meetingsginvo_client_invoice_ida), KEY ginvo_client_invoice_meetings_idb2 (ginvo_client_invoice_meetingsmeetings_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_local_coach_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_local_coach_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_local_coach_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_local_coach_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_g9743_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_local_coach_rates_client_1_ida1 (ggs_tour_ggs_local_coach_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_local_coach_rates_client_1_alt (ggs_tour_g9743_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_dri_driver_guide_service_1_c */
/* MISSING TABLE: meetings_dri_driver_guide_service_1_c */
CREATE TABLE meetings_dri_driver_guide_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_dri_driver_guide_service_1meetings_ida varchar(36) NULL ,meetings_dri_driver_guide_service_1dri_driver_guide_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_dri_driver_guide_service_1_ida1 (meetings_dri_driver_guide_service_1meetings_ida), KEY meetings_dri_driver_guide_service_1_idb2 (meetings_dri_driver_guide_service_1dri_driver_guide_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_cruise_rates_1_c */
/* MISSING TABLE: contacts_ggs_cruise_rates_1_c */
CREATE TABLE contacts_ggs_cruise_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_cruise_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_cruise_rates_1ggs_cruise_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_cruise_rates_1_ida1 (contacts_ggs_cruise_rates_1contacts_ida), KEY contacts_ggs_cruise_rates_1_alt (contacts_ggs_cruise_rates_1ggs_cruise_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_contact_person_vendor_1_c */
/* MISSING TABLE: contacts_ggs_contact_person_vendor_1_c */
CREATE TABLE contacts_ggs_contact_person_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_contact_person_vendor_1contacts_ida varchar(36) NULL ,contacts_g217f_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_contact_person_vendor_1_ida1 (contacts_ggs_contact_person_vendor_1contacts_ida), KEY contacts_ggs_contact_person_vendor_1_alt (contacts_g217f_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_the_thematic_tour_service_1_c */
/* MISSING TABLE: meetings_the_thematic_tour_service_1_c */
CREATE TABLE meetings_the_thematic_tour_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_the_thematic_tour_service_1meetings_ida varchar(36) NULL ,meetings_t020bservice_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_the_thematic_tour_service_1_ida1 (meetings_the_thematic_tour_service_1meetings_ida), KEY meetings_the_thematic_tour_service_1_idb2 (meetings_t020bservice_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_ass_assistant_service_1_c */
/* MISSING TABLE: meetings_ass_assistant_service_1_c */
CREATE TABLE meetings_ass_assistant_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_ass_assistant_service_1meetings_ida varchar(36) NULL ,meetings_ass_assistant_service_1ass_assistant_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_ass_assistant_service_1_ida1 (meetings_ass_assistant_service_1meetings_ida), KEY meetings_ass_assistant_service_1_idb2 (meetings_ass_assistant_service_1ass_assistant_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_cruise_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_cruise_rates_1_c */
CREATE TABLE ggs_tour_ggs_cruise_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_cruise_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_cruise_rates_1ggs_cruise_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_cruise_rates_1_ida1 (ggs_tour_ggs_cruise_rates_1ggs_tour_ida), KEY ggs_tour_ggs_cruise_rates_1_alt (ggs_tour_ggs_cruise_rates_1ggs_cruise_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_tour_escort_rates_1_c */
/* MISSING TABLE: contacts_ggs_tour_escort_rates_1_c */
CREATE TABLE contacts_ggs_tour_escort_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_tour_escort_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_tour_escort_rates_1ggs_tour_escort_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_tour_escort_rates_1_ida1 (contacts_ggs_tour_escort_rates_1contacts_ida), KEY contacts_ggs_tour_escort_rates_1_alt (contacts_ggs_tour_escort_rates_1ggs_tour_escort_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_porter_service_vendor_1_c */
/* MISSING TABLE: contacts_ggs_porter_service_vendor_1_c */
CREATE TABLE contacts_ggs_porter_service_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_porter_service_vendor_1contacts_ida varchar(36) NULL ,contacts_g4e6e_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_porter_service_vendor_1_ida1 (contacts_ggs_porter_service_vendor_1contacts_ida), KEY contacts_ggs_porter_service_vendor_1_idb2 (contacts_g4e6e_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_audio_guide_languages_1_c */
/* MISSING TABLE: contacts_ggs_audio_guide_languages_1_c */
CREATE TABLE contacts_ggs_audio_guide_languages_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_audio_guide_languages_1contacts_ida varchar(36) NULL ,contacts_g5f8enguages_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_audio_guide_languages_1_ida1 (contacts_ggs_audio_guide_languages_1contacts_ida), KEY contacts_ggs_audio_guide_languages_1_alt (contacts_g5f8enguages_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_assistant_rates_1_c */
/* MISSING TABLE: contacts_ggs_assistant_rates_1_c */
CREATE TABLE contacts_ggs_assistant_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_assistant_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_assistant_rates_1ggs_assistant_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_assistant_rates_1_ida1 (contacts_ggs_assistant_rates_1contacts_ida), KEY contacts_ggs_assistant_rates_1_alt (contacts_ggs_assistant_rates_1ggs_assistant_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_driver_guide_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_driver_guide_rates_1_c */
CREATE TABLE ggs_tour_ggs_driver_guide_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_driver_guide_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_driver_guide_rates_1ggs_driver_guide_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_driver_guide_rates_1_ida1 (ggs_tour_ggs_driver_guide_rates_1ggs_tour_ida), KEY ggs_tour_ggs_driver_guide_rates_1_alt (ggs_tour_ggs_driver_guide_rates_1ggs_driver_guide_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_res_restaurant_service_1_c */
/* MISSING TABLE: meetings_res_restaurant_service_1_c */
CREATE TABLE meetings_res_restaurant_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_res_restaurant_service_1meetings_ida varchar(36) NULL ,meetings_res_restaurant_service_1res_restaurant_service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_res_restaurant_service_1_ida1 (meetings_res_restaurant_service_1meetings_ida), KEY meetings_res_restaurant_service_1_idb2 (meetings_res_restaurant_service_1res_restaurant_service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_restaurant_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_restaurant_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_restaurant_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_restaurant_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_g4fb1_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_restaurant_rates_client_1_ida1 (ggs_tour_ggs_restaurant_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_restaurant_rates_client_1_alt (ggs_tour_g4fb1_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_tour_contact_person_1_c */
/* MISSING TABLE: ggs_tour_ggs_tour_contact_person_1_c */
CREATE TABLE ggs_tour_ggs_tour_contact_person_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_tour_contact_person_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_tour_contact_person_1ggs_tour_contact_person_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_tour_contact_person_1_ida1 (ggs_tour_ggs_tour_contact_person_1ggs_tour_ida), KEY ggs_tour_ggs_tour_contact_person_1_alt (ggs_tour_ggs_tour_contact_person_1ggs_tour_contact_person_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_driver_guide_vendor_1_c */
/* MISSING TABLE: contacts_ggs_driver_guide_vendor_1_c */
CREATE TABLE contacts_ggs_driver_guide_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_driver_guide_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_driver_guide_vendor_1ggs_driver_guide_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_driver_guide_vendor_1_ida1 (contacts_ggs_driver_guide_vendor_1contacts_ida), KEY contacts_ggs_driver_guide_vendor_1_idb2 (contacts_ggs_driver_guide_vendor_1ggs_driver_guide_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_driver_guide_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_driver_guide_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_driver_guide_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_driver_guide_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_gbd42_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_driver_guide_rates_client_1_ida1 (ggs_tour_ggs_driver_guide_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_driver_guide_rates_client_1_alt (ggs_tour_gbd42_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_thematic_tour_vendor_1_c */
/* MISSING TABLE: contacts_ggs_thematic_tour_vendor_1_c */
CREATE TABLE contacts_ggs_thematic_tour_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_thematic_tour_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_thematic_tour_vendor_1ggs_thematic_tour_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_thematic_tour_vendor_1_ida1 (contacts_ggs_thematic_tour_vendor_1contacts_ida), KEY contacts_ggs_thematic_tour_vendor_1_idb2 (contacts_ggs_thematic_tour_vendor_1ggs_thematic_tour_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_cruise_vendor_1_c */
/* MISSING TABLE: contacts_ggs_cruise_vendor_1_c */
CREATE TABLE contacts_ggs_cruise_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_cruise_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_cruise_vendor_1ggs_cruise_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_cruise_vendor_1_ida1 (contacts_ggs_cruise_vendor_1contacts_ida), KEY contacts_ggs_cruise_vendor_1_idb2 (contacts_ggs_cruise_vendor_1ggs_cruise_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_long_distance_coach_rates_1_c */
/* MISSING TABLE: contacts_ggs_long_distance_coach_rates_1_c */
CREATE TABLE contacts_ggs_long_distance_coach_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_long_distance_coach_rates_1contacts_ida varchar(36) NULL ,contacts_gcce6h_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_long_distance_coach_rates_1_ida1 (contacts_ggs_long_distance_coach_rates_1contacts_ida), KEY contacts_ggs_long_distance_coach_rates_1_alt (contacts_gcce6h_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_licences_1_c */
/* MISSING TABLE: contacts_ggs_licences_1_c */
CREATE TABLE contacts_ggs_licences_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_licences_1contacts_ida varchar(36) NULL ,contacts_ggs_licences_1ggs_licences_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_licences_1_ida1 (contacts_ggs_licences_1contacts_ida), KEY contacts_ggs_licences_1_alt (contacts_ggs_licences_1ggs_licences_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_guide_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_guide_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_guide_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_guide_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_guide_rates_client_1ggs_guide_rates_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_guide_rates_client_1_ida1 (ggs_tour_ggs_guide_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_guide_rates_client_1_alt (ggs_tour_ggs_guide_rates_client_1ggs_guide_rates_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_conversation_1_c */
/* MISSING TABLE: contacts_ggs_conversation_1_c */
CREATE TABLE contacts_ggs_conversation_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_conversation_1contacts_ida varchar(36) NULL ,contacts_ggs_conversation_1ggs_conversation_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_conversation_1_ida1 (contacts_ggs_conversation_1contacts_ida), KEY contacts_ggs_conversation_1_alt (contacts_ggs_conversation_1ggs_conversation_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_cruise_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_cruise_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_cruise_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_cruise_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_cruise_rates_client_1ggs_cruise_rates_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_cruise_rates_client_1_ida1 (ggs_tour_ggs_cruise_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_cruise_rates_client_1_alt (ggs_tour_ggs_cruise_rates_client_1ggs_cruise_rates_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_tour_escort_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_tour_escort_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_tour_escort_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_tour_escort_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_g0631_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_tour_escort_rates_client_1_ida1 (ggs_tour_ggs_tour_escort_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_tour_escort_rates_client_1_alt (ggs_tour_g0631_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_tour_escort_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_tour_escort_rates_1_c */
CREATE TABLE ggs_tour_ggs_tour_escort_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_tour_escort_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_tour_escort_rates_1ggs_tour_escort_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_tour_escort_rates_1_ida1 (ggs_tour_ggs_tour_escort_rates_1ggs_tour_ida), KEY ggs_tour_ggs_tour_escort_rates_1_alt (ggs_tour_ggs_tour_escort_rates_1ggs_tour_escort_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_tour_escort_vendor_1_c */
/* MISSING TABLE: contacts_ggs_tour_escort_vendor_1_c */
CREATE TABLE contacts_ggs_tour_escort_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_tour_escort_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_tour_escort_vendor_1ggs_tour_escort_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_tour_escort_vendor_1_ida1 (contacts_ggs_tour_escort_vendor_1contacts_ida), KEY contacts_ggs_tour_escort_vendor_1_idb2 (contacts_ggs_tour_escort_vendor_1ggs_tour_escort_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_driver_guide_rates_1_c */
/* MISSING TABLE: contacts_ggs_driver_guide_rates_1_c */
CREATE TABLE contacts_ggs_driver_guide_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_driver_guide_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_driver_guide_rates_1ggs_driver_guide_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_driver_guide_rates_1_ida1 (contacts_ggs_driver_guide_rates_1contacts_ida), KEY contacts_ggs_driver_guide_rates_1_alt (contacts_ggs_driver_guide_rates_1ggs_driver_guide_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_annual_hours_1_c */
/* MISSING TABLE: contacts_ggs_annual_hours_1_c */
CREATE TABLE contacts_ggs_annual_hours_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_annual_hours_1contacts_ida varchar(36) NULL ,contacts_ggs_annual_hours_1ggs_annual_hours_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_annual_hours_1_ida1 (contacts_ggs_annual_hours_1contacts_ida), KEY contacts_ggs_annual_hours_1_alt (contacts_ggs_annual_hours_1ggs_annual_hours_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_attraction_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_attraction_rates_1_c */
CREATE TABLE ggs_tour_ggs_attraction_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_attraction_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_attraction_rates_1ggs_attraction_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_attraction_rates_1_ida1 (ggs_tour_ggs_attraction_rates_1ggs_tour_ida), KEY ggs_tour_ggs_attraction_rates_1_alt (ggs_tour_ggs_attraction_rates_1ggs_attraction_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_lon_long_distance_coach_service_1_c */
/* MISSING TABLE: meetings_lon_long_distance_coach_service_1_c */
CREATE TABLE meetings_lon_long_distance_coach_service_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_lon_long_distance_coach_service_1meetings_ida varchar(36) NULL ,meetings_la7c3service_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_lon_long_distance_coach_service_1_ida1 (meetings_lon_long_distance_coach_service_1meetings_ida), KEY meetings_lon_long_distance_coach_service_1_idb2 (meetings_la7c3service_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_assistant_vendor_1_c */
/* MISSING TABLE: contacts_ggs_assistant_vendor_1_c */
CREATE TABLE contacts_ggs_assistant_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_assistant_vendor_1contacts_ida varchar(36) NULL ,contacts_ggs_assistant_vendor_1ggs_assistant_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_assistant_vendor_1_ida1 (contacts_ggs_assistant_vendor_1contacts_ida), KEY contacts_ggs_assistant_vendor_1_idb2 (contacts_ggs_assistant_vendor_1ggs_assistant_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_pickup_or_drop_1_c */
/* MISSING TABLE: contacts_ggs_pickup_or_drop_1_c */
CREATE TABLE contacts_ggs_pickup_or_drop_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_pickup_or_drop_1contacts_ida varchar(36) NULL ,contacts_ggs_pickup_or_drop_1ggs_pickup_or_drop_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_pickup_or_drop_1_ida1 (contacts_ggs_pickup_or_drop_1contacts_ida), KEY contacts_ggs_pickup_or_drop_1_alt (contacts_ggs_pickup_or_drop_1ggs_pickup_or_drop_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ginvo_client_invoice_1_c */
/* MISSING TABLE: ggs_tour_ginvo_client_invoice_1_c */
CREATE TABLE ggs_tour_ginvo_client_invoice_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ginvo_client_invoice_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ginvo_client_invoice_1ginvo_client_invoice_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ginvo_client_invoice_1_ida1 (ggs_tour_ginvo_client_invoice_1ggs_tour_ida), KEY ggs_tour_ginvo_client_invoice_1_alt (ggs_tour_ginvo_client_invoice_1ginvo_client_invoice_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_thematic_tour_rates_1_c */
/* MISSING TABLE: contacts_ggs_thematic_tour_rates_1_c */
CREATE TABLE contacts_ggs_thematic_tour_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_thematic_tour_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_thematic_tour_rates_1ggs_thematic_tour_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_thematic_tour_rates_1_ida1 (contacts_ggs_thematic_tour_rates_1contacts_ida), KEY contacts_ggs_thematic_tour_rates_1_alt (contacts_ggs_thematic_tour_rates_1ggs_thematic_tour_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_restaurant_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_restaurant_rates_1_c */
CREATE TABLE ggs_tour_ggs_restaurant_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_restaurant_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_restaurant_rates_1ggs_restaurant_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_restaurant_rates_1_ida1 (ggs_tour_ggs_restaurant_rates_1ggs_tour_ida), KEY ggs_tour_ggs_restaurant_rates_1_alt (ggs_tour_ggs_restaurant_rates_1ggs_restaurant_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_long_distance_coach_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_long_distance_coach_rates_1_c */
CREATE TABLE ggs_tour_ggs_long_distance_coach_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_long_distance_coach_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_gf5c2h_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_long_distance_coach_rates_1_ida1 (ggs_tour_ggs_long_distance_coach_rates_1ggs_tour_ida), KEY ggs_tour_ggs_long_distance_coach_rates_1_alt (ggs_tour_gf5c2h_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : meetings_ggs_conversation_1_c */
/* MISSING TABLE: meetings_ggs_conversation_1_c */
CREATE TABLE meetings_ggs_conversation_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,meetings_ggs_conversation_1meetings_ida varchar(36) NULL ,meetings_ggs_conversation_1ggs_conversation_idb varchar(36) NULL , PRIMARY KEY (id), KEY meetings_ggs_conversation_1_ida1 (meetings_ggs_conversation_1meetings_ida), KEY meetings_ggs_conversation_1_alt (meetings_ggs_conversation_1ggs_conversation_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_meetings_1_c */
/* MISSING TABLE: ggs_tour_meetings_1_c */
CREATE TABLE ggs_tour_meetings_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_meetings_1ggs_tour_ida varchar(36) NULL ,ggs_tour_meetings_1meetings_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_meetings_1_ida1 (ggs_tour_meetings_1ggs_tour_ida), KEY ggs_tour_meetings_1_alt (ggs_tour_meetings_1meetings_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_thematic_tour_rates_client_1_c */
/* MISSING TABLE: ggs_tour_ggs_thematic_tour_rates_client_1_c */
CREATE TABLE ggs_tour_ggs_thematic_tour_rates_client_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_thematic_tour_rates_client_1ggs_tour_ida varchar(36) NULL ,ggs_tour_g0cc4_client_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_thematic_tour_rates_client_1_ida1 (ggs_tour_ggs_thematic_tour_rates_client_1ggs_tour_ida), KEY ggs_tour_ggs_thematic_tour_rates_client_1_alt (ggs_tour_g0cc4_client_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_guided_tour_1_c */
/* MISSING TABLE: contacts_ggs_guided_tour_1_c */
CREATE TABLE contacts_ggs_guided_tour_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_guided_tour_1contacts_ida varchar(36) NULL ,contacts_ggs_guided_tour_1ggs_guided_tour_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_guided_tour_1_ida1 (contacts_ggs_guided_tour_1contacts_ida), KEY contacts_ggs_guided_tour_1_alt (contacts_ggs_guided_tour_1ggs_guided_tour_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_porter_service_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_porter_service_rates_1_c */
CREATE TABLE ggs_tour_ggs_porter_service_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_porter_service_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_porter_service_rates_1ggs_porter_service_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_porter_service_rates_1_ida1 (ggs_tour_ggs_porter_service_rates_1ggs_tour_ida), KEY ggs_tour_ggs_porter_service_rates_1_alt (ggs_tour_ggs_porter_service_rates_1ggs_porter_service_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_long_distance_coach_vendor_1_c */
/* MISSING TABLE: contacts_ggs_long_distance_coach_vendor_1_c */
CREATE TABLE contacts_ggs_long_distance_coach_vendor_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_long_distance_coach_vendor_1contacts_ida varchar(36) NULL ,contacts_g3d66_vendor_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_long_distance_coach_vendor_1_ida1 (contacts_ggs_long_distance_coach_vendor_1contacts_ida), KEY contacts_ggs_long_distance_coach_vendor_1_idb2 (contacts_g3d66_vendor_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_cruise_contact_person_1_c */
/* MISSING TABLE: contacts_ggs_cruise_contact_person_1_c */
CREATE TABLE contacts_ggs_cruise_contact_person_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_cruise_contact_person_1contacts_ida varchar(36) NULL ,contacts_ge3f5_person_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_cruise_contact_person_1_ida1 (contacts_ggs_cruise_contact_person_1contacts_ida), KEY contacts_ggs_cruise_contact_person_1_alt (contacts_ge3f5_person_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_inside_guiding_1_c */
/* MISSING TABLE: contacts_ggs_inside_guiding_1_c */
CREATE TABLE contacts_ggs_inside_guiding_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_inside_guiding_1contacts_ida varchar(36) NULL ,contacts_ggs_inside_guiding_1ggs_inside_guiding_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_inside_guiding_1_ida1 (contacts_ggs_inside_guiding_1contacts_ida), KEY contacts_ggs_inside_guiding_1_alt (contacts_ggs_inside_guiding_1ggs_inside_guiding_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_ggs_local_coach_rates_1_c */
/* MISSING TABLE: ggs_tour_ggs_local_coach_rates_1_c */
CREATE TABLE ggs_tour_ggs_local_coach_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_ggs_local_coach_rates_1ggs_tour_ida varchar(36) NULL ,ggs_tour_ggs_local_coach_rates_1ggs_local_coach_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_ggs_local_coach_rates_1_ida1 (ggs_tour_ggs_local_coach_rates_1ggs_tour_ida), KEY ggs_tour_ggs_local_coach_rates_1_alt (ggs_tour_ggs_local_coach_rates_1ggs_local_coach_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : ggs_tour_documents_1_c */
/* MISSING TABLE: ggs_tour_documents_1_c */
CREATE TABLE ggs_tour_documents_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,ggs_tour_documents_1ggs_tour_ida varchar(36) NULL ,ggs_tour_documents_1documents_idb varchar(36) NULL ,document_revision_id varchar(36) NULL , PRIMARY KEY (id), KEY ggs_tour_documents_1_ida1 (ggs_tour_documents_1ggs_tour_ida), KEY ggs_tour_documents_1_alt (ggs_tour_documents_1documents_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_vehicle_specification_1_c */
/* MISSING TABLE: contacts_ggs_vehicle_specification_1_c */
CREATE TABLE contacts_ggs_vehicle_specification_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_vehicle_specification_1contacts_ida varchar(36) NULL ,contacts_gccdeication_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_vehicle_specification_1_ida1 (contacts_ggs_vehicle_specification_1contacts_ida), KEY contacts_ggs_vehicle_specification_1_alt (contacts_gccdeication_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_ggs_attraction_rates_1_c */
/* MISSING TABLE: contacts_ggs_attraction_rates_1_c */
CREATE TABLE contacts_ggs_attraction_rates_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_ggs_attraction_rates_1contacts_ida varchar(36) NULL ,contacts_ggs_attraction_rates_1ggs_attraction_rates_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_ggs_attraction_rates_1_ida1 (contacts_ggs_attraction_rates_1contacts_ida), KEY contacts_ggs_attraction_rates_1_alt (contacts_ggs_attraction_rates_1ggs_attraction_rates_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;
/* Table : contacts_users_1_c */
/* MISSING TABLE: contacts_users_1_c */
CREATE TABLE contacts_users_1_c (id varchar(36) NOT NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,contacts_users_1contacts_ida varchar(36) NULL ,contacts_users_1users_idb varchar(36) NULL , PRIMARY KEY (id), KEY contacts_users_1_ida1 (contacts_users_1contacts_ida), KEY contacts_users_1_alt (contacts_users_1users_idb)) CHARACTER SET utf8 COLLATE utf8_general_ci;

Outcomes