/*****************************************************************************
*
* Filename         - $Workfile:   disable_triggers.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         - disable_triggers constraints etc prior to importing config data
*
* Language         - Oracle SQL*Plus script
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 1997
*
*****************************************************************************/
/****************************************************************************
* @(#)$Workfile:   disable_triggers.sql  $  $Revision:   1.3  $
*
* Revision History
*
* Note that user tagtrak is many users. For these users the user
* name is entered as the last line in the change description.
*
* $Log:   /pvcsarch/db_ora/db/source/live/data/disable_triggers.svl  $
* 
*    Rev 1.3   21 Jun 2001 14:08:26   tagtrak
* OR:
* CR:
* Re-baseline version 4.0.0 to include patches.
* 
*    Rev 1.2   20 Sep 1999 14:32:04   tagtrak
*  
* 
*    Rev 1.1   26 Feb 1999 09:22:18   tagtrak
*  
* 
*
****************************************************************************/
alter table tagtrak_users disable all triggers;
alter table user_group disable all triggers;
alter table privilege disable all triggers;
alter table  AGENTS                         disable all triggers;
alter table  BAG                            disable all triggers;
alter table  BAG_ALERT                      disable all triggers;
alter table  BAG_TRACE                      disable all triggers;
alter table  CARRIER_LOOKUP                 disable all triggers;
alter table  CARRIER_MAP                    disable all triggers;
alter table  CODE_SHARE                     disable all triggers;
alter table  CONTRACTED_AGENTS              disable all triggers;
alter table  DB_VERSION                     disable all triggers;
alter table  ERROR                          disable all triggers;
alter table  FASL_FLIGHT_INFO               disable all triggers;
alter table  FLIGHT                         disable all triggers;
alter table  FLIGHT_ACCESS                  disable all triggers;
alter table  FLIGHT_PRIVILEGES              disable all triggers;
alter table  FS_EVENTS                      disable all triggers;
alter table  KIT                            disable all triggers;
alter table  LOCATION                       disable all triggers;
alter table  LOG_TABLE                      disable all triggers;
alter table  MACH_FLIGHT_INFO               disable all triggers;
alter table  MAIL_GLOBAL                    disable all triggers;
alter table  MAIL_INDIV                     disable all triggers;
alter table  MBA_FLIGHTS                    disable all triggers;
alter table  MWS_SEARCH_PLANS               disable all triggers;
alter table  PAX                            disable all triggers;
alter table  SYSTEM_CFG                     disable all triggers;
alter table  ULD_TRACE                      disable all triggers;
alter table  ULD_TYPES                      disable all triggers;
alter table  USER_TRACE                     disable all triggers;
alter table  WEIGHTS                        disable all triggers;
alter table  BATCH_LOG            disable all triggers;
alter table  CARRIER_SUBGROUP     disable all triggers;
alter table  FLIGHT_INFO          disable all triggers;
alter table  HEL_FIDS_FLIGHT_INFO disable all triggers;
alter table  LBA_INFO             disable all triggers;
alter table  LOAD_ATTEMPT         disable all triggers;
alter table  PRG_FIDS_INFO        disable all triggers;
alter table  USER_ROLE            disable all triggers;
alter table  YVR_FIDS_INFO        disable all triggers;
