The SQL scripts contained in this directory have been created to completely rebuild the EOAS Database.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!! 					WARNING 						   !!!
!!! THE RUNALL.SQL SCRIPT WILL DELETE ALL EOA LEGACY DATA  !!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

The RUNALL.SQL script will drop all tables, sequences, views, triggers, functions, packages, and procedures.

It will then recreate the following:
* TYPES
* SEQUENCES
* TABLES
* VIEWS

It will then insert lookup data in the following tables:
* ATTACHMENT_TYPE_DATA_TABLE
* CASE_SOURCE_DATA_TABLE
* CASE_SOURCE_TYPE_MAP_DATA_TABLE
* CASE_TYPE_DATA_TABLE
* CONTACT_TYPE_DATA_TABLE
* DELIVERY_TYPE_DATA_TABLE
* DOCUMENT_TYPE_DATA_TABLE
* ELIGIBILITY_DENIED_REASON_DATA_TABLE
* INCOMPLETE_REASON_DATA_TABLE
* MARITAL_STATUS_DATA_TABLE
* MILITARY_STATUS_DATA_TABLE
* RACE_DATA_TABLE
* SCA_NATURE_OF_REQUEST_DATA_TABLE
* SHOWING_DATA_TABLE

It will then proceed to execute the following scripts:
* INDEXES
* CONSTRAINTS
* REF_CONSTRAINTS
* TRIGGERS
* FUNCTIONS
* PACKAGES
* PACKAGE_BODIES &boss_schema
* PROCEDURES


