/*****************************************************************************
*
* Filename         - $Workfile:   tables.sql  $
*
*                     Name              Date      Version     CR Number
* Author           - See revision history below.
* Last Update      - See revision history below.
*
* Project Name     - TAGTRAK(Oracle Database)
*
* Source Code
* Identifier       - 0/3/300/8010/112
*
* Design Spec
* Section          - 
*
* Contents         - Live Schema: Create all tables
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/

set doc off;
@@sys_interface.sql
@@flight_info_inbound.sql;
@@flight_info_extras.sql;
@@tz_data.sql
@@site_info.sql
@@email_accounts.sql
@@agents.sql
@@timezone.sql
@@user_group.sql
@@tagtrak_users.sql
@@system_cfg.sql
@@db_config.sql
@@credentials_lookup.sql
@@carrier_lookup.sql
@@carrier_subgroup.sql
@@gateway_redo.sql
@@cust_loyalty_program.sql
@@error.sql
@@bag_exception_types.sql
@@flight.sql
@@flight_dests.sql
@@flight_status.sql
@@flight_trace.sql
@@fs_events.sql
@@pax.sql
@@ldg_strat.sql
@@location_group.sql
@@location.sql
@@log_table.sql
@@mail_global.sql
@@mail_indiv.sql
@@msg_log.sql
@@mws_search_plans.sql
@@privilege.sql
@@ulds.sql
@@uld_dests.sql
@@uld_trace.sql
@@uld_types.sql
@@mba_flights.sql
@@bpm_data.sql
@@bpm_status_trace.sql
@@db_version.sql
@@holds.sql
@@interim.sql
@@bag.sql
@@bag_alert.sql
@@bag_trace.sql
@@flight_restrict.sql
@@contracted_agents.sql
@@flight_privileges.sql
@@flight_access.sql
@@kit_status.sql
@@kit_type.sql
@@kit.sql
@@user_trace.sql
@@stats.sql
@@stats_access.sql
@@code_share.sql
@@carrier_map.sql
@@flight_info.sql
@@weights.sql
@@uld_weights.sql
@@flight_events.sql
@@mach_flight_info.sql
@@fasl_flight_info.sql
@@onward_flight.sql
@@temp_delete_ids.sql
@@hel_fids_flight_info.sql
@@lba_info.sql
@@group_iata_dests.sql
@@loading_totals.sql
@@app_priv.sql
@@user_role.sql
@@tagtrak_users_role.sql
@@user_role_priv.sql
@@batch_log.sql
@@batch_actions.sql
@@batch_scanner.sql
@@error_msg.sql
@@load_attempt.sql
@@prg_fids_info.sql
@@airport_configuration.sql
@@flight_configuration.sql
@@connection_configuration.sql
@@super_agents.sql
@@yvr_fids_info.sql
@@site_config.sql
@@codeshare_config.sql
@@uld_card_templates.sql
@@uld_card_details.sql
@@uld_recorded_id_codes.sql
@@flight_status_type.sql
@@timed_report_config.sql
@@oracle_error.sql
@@hbmd.sql
@@mct.sql
@@stand_setup.sql
@@terminals.sql
@@function_id.sql
@@super_groups.sql
@@pm_results.sql
@@eq_log.sql
@@three_letter_carrier_codes.sql
@@hbmd_interim.sql
@@translator.sql
@@unauthorised_bag.sql
@@unknown_bag.sql
@@bag_group.sql
@@bag_status.sql
@@tracking_events.sql
@@tracking_log.sql
@@handler_trace.sql
@@wan_config.sql
@@rfs_log.sql
@@carrier_site_config.sql
@@aircraft_type.sql
@@aircraft_carrier.sql
@@hold_config.sql
@@reflight_setup
@@reflight_accept_from
@@reflight_avoid_dest
@@reflight_dest_tx
@@reflight_flight
@@reflight_pax
@@reflight_ulds
@@reflight_bag
@@reflight_bag_hist_temp
@@reason_for_loss_code
@@interim_flight
@@interim_ulds
@@work_flight_select
@@reflight_flight_list_temp
@@flight_event_types.sql
@@email_addresses.sql
@@reports.sql
@@email_trace.sql
@@inbound_pax.sql
@@inbound_pax_onward_dests.sql
@@inbound_uld.sql
@@inbound_uld_dests.sql
@@inbound_bag.sql
@@bmm_routes.sql
@@messages.sql
@@message_parts.sql
@@messages_trace.sql
@@pax_match_rules.sql
@@pax_match_algorithms.sql
@@cabin_classes.sql
@@class_list.sql
@@misc_bag_exceptions.sql
@@bpm_types.sql
@@bpm_groups.sql
@@lost_baggage.sql
@@bsm_log.sql
@@bsm_data.sql
@@wt_transactions.sql
@@wt_config.sql
@@flight_mapping.sql
@@fgos_security_messages.sql
@@inbound_term_bag_trace.sql
@@bag_colour_codes.sql
@@bag_type_codes.sql
@@bag_descriptive_elements.sql
@@missing_bag_rule.sql
@@missing_bag_alert.sql
@@bag_alert_priority.sql
@@flight_loop_data.sql