#!/bin/sh
#*******************************************************************************
#             PACOR II SOFTWARE
#       Property of the U.S. Government
#            NASA/GSFC/Code 560
#*******************************************************************************
#PURPOSE: Creates the TRACE DPS database tables.
#
#INVOCATION METHOD: TableBuilder_DPS user/pw
#
# EXTERNAL VARIABLES:
# Source               	Name               Type   Use  Description
# ----------------------------------------------------------------------------
# dps_db.create     	DPS_DB_BUILD_HOME  char    I   location of db build scripts
#
#
#DEVELOPMENT HISTORY:
#
#       Author          Change-ID   Release   Date    Description of Change
#       ------          ---------   ------- --------  ---------------------
#    S. Azama           Build 2             10/03/93  Initial release
#    P. Matthews        B3R2                03/22/94  Enhanced and simplified 
#    P. Matthews        PAC2951011          03/24/95  Sized tables for 
#                                                       operations and distributed
#                                                       them across multiple disks
#    M. Rauschenberger  PAC2951002          04/05/95  Removed table
#                                                       db_GroundTerminalInterfaceChnl
#    P. Matthews        N/A                 04/24/95  Remove parameter to gen 
#                                                       tables
#    I. Horowitz        N/A        ACE R1.0 10/09/95  Added ACE Tables, merged
#                                                       PDPS tables into this script
#    I. Horowitz        N/A        ACE R1.0 10/09/95  Added db_CHIMissionInfo
#    I. Horowitz        N/A        ACE R1.0 02/23/96  Replaced db_ProdFileDeliveryAcct
#							with db_ProductXfer
#    I. Horowitz        ACE0615    ACE R2.0 06/27/96  Updated table sizes, added use of
#							DPS_DB_BUILD_HOME
#    I. Horowitz        n/a      TRACE R1.0 07/08/96  Modified for TRACE mission
#    J. Raymond		PAC2961650  R3.2    08/07/96  Added pdp_TapeSessionIDs
#    J. Raymond		PAC2951415  R3.2    08/09/96  Added db_FilterRates
#    J. Whelan		PAC2961590  R3.2    09/24/96  Added db_PMSSInputLine and
#							  db_ScheduledisplayDefaults;
#							  Removed db_DataLine and
#							  db_MissionDataLine.
#    I. Horowitz        TRACE0105 TRACE R2.0 01/24/97 Merged Pacor II R3.2 changes
#    I. Horowitz        TRACE0116 TRACE R2.0 02/21/97 Added db_FrameSorterConfiguration
#    R. Wiechert        WIND970001      R1.0 07/17/97 Added db_SessionHeader and db_DUS
#    R. Wiechert        WIND910001      R1.0 09/14/97 Increased INITIAL, NEXT for
#                                                      pdp_hash_index by factor of 10.
#    R. Wiechert        WIND910001 R1.0b     11/21/97 Resized everything
#    R. Wiechert        ISTP            R1.2 04/21/98 Integrate with dps_db.create
#
#*********************************************************************************
if test $# -ne 1
then
   echo ""
   echo "***********************************************"
   echo "Error, you must enter an Oracle UserID/Password"
   echo "***********************************************"
   exit
fi

echo ""
echo "************************************"
echo "  Creating DPS Database Tables  "
echo "************************************"

if [ "$DPS_DB_RESIZE" = small ]
then
################################################################################################
#
#           S M A L L     C O N F I G U R A T I O N
#
################################################################################################
$DPS_DB_BUILD_HOME/db_AppDestDefaults.tab               $1 static_data      8     8    0 1 20
$DPS_DB_BUILD_HOME/db_CaptureScheduleSetup.tab          $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_CHIMissionInfo.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ChnlInformation.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ConfigurableItems.tab             $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DataRate.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DataSource.tab                    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DDFTransmissionConfig.tab         $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DestinationCatalog.tab            $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DestinationFacility.tab           $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FddiFELookup.tab                  $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FESConfiguration.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FilterRates.tab                   $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_FrameSorterConfiguration.tab      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FrameSyncSetup.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FSFilterSetup.tab                 $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FSFilterValue.tab                 $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_GroundTerminal.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_GroupDestination.tab              $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_HST_PKSetup.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_IDFSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_Message.tab                       $1 static_data    186   186    0 1 20
$DPS_DB_BUILD_HOME/db_MissionCatalog.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDataRate.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDataStreamIDCatalog.tab    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDestination.tab            $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionStation.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionSupportID.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionThresholds.tab             $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_NetworkID.tab                     $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_OracleLogin.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PacketizationPath.tab             $1 static_data     12    12    0 1 20
$DPS_DB_BUILD_HOME/db_PDPConfiguration.tab              $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PEConfiguration.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PFCSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PKSetup.tab                       $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PMSSInputLine.tab                 $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_POCCWindow.tab                    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ProductHost.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PTTConfiguration.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceCatalog.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceConstituentDefaults.tab   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceDevices.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RSBSSetup.tab                     $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RSDSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTMissionSetup.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSConfig.tab                    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSPortNum.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleDisplayDefaults.tab       $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleOption.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleSource.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_SIDSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_SQAFIPSetup.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_Station.tab                       $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_TerminalLocation.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_TimeCoefficient.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_UserAccessLevel.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_UserCategory.tab                  $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_UserLevel.tab                     $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/pdp_GroupIds.tab                     $1 static_data      2     2    0 1 20

$DPS_DB_BUILD_HOME/db_AcqSessionCharacteristics.tab     $1 dynamic_data   176   176    0 1 5
$DPS_DB_BUILD_HOME/db_AppDestSchedule.tab               $1 dynamic_data     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_CTMStatus.tab                     $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DANIndx.tab                       $1 dynamic_data   752   752    0 1 10
$DPS_DB_BUILD_HOME/db_DCR.tab                           $1 dynamic_data    16    16    0 1 4
$DPS_DB_BUILD_HOME/db_EventLog.tab                      $1 dynamic_data  8468  8468    0 1 2
$DPS_DB_BUILD_HOME/db_FESessionAcct.tab                 $1 dynamic_data   302   302    0 1 5
$DPS_DB_BUILD_HOME/db_FEUnselVCAcct.tab                 $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_FEVcAppAcct.tab                   $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_FEVirtualChannelAcct.tab          $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_GPGroupIndx.tab                   $1 dynamic_data 57902 57902    0 1 5
$DPS_DB_BUILD_HOME/db_GPProductIndx.tab                 $1 dynamic_data  1002  1002    0 1 10
$DPS_DB_BUILD_HOME/db_GroupSequenceNumbers.tab          $1 dynamic_data   144   144    0 1 8
$DPS_DB_BUILD_HOME/db_HST_SessionAcct.tab               $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_HST_SIDAcct.tab                   $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_LogCatalog.tab                    $1 dynamic_data   210   210    0 1 5
$DPS_DB_BUILD_HOME/db_PDPDataMaintActivity.tab          $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PDPSessionDataDiscont.tab         $1 dynamic_data  1464  1464    0 1 10
$DPS_DB_BUILD_HOME/db_PDPSessionsAcct.tab               $1 dynamic_data    74    74    0 1 10
$DPS_DB_BUILD_HOME/db_PDPSessVCAppIDAcct.tab            $1 dynamic_data 15902 15902    0 1 5
$DPS_DB_BUILD_HOME/db_PDPTapeDirectoryContents.tab      $1 dynamic_data   962   962    0 1 10
$DPS_DB_BUILD_HOME/db_PDPTelemetryOnDisk.tab            $1 dynamic_data    38    38    0 1 10
$DPS_DB_BUILD_HOME/db_PMSchedule.tab                    $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ProdMessageQualityAndAcct.tab     $1 dynamic_data  4030  4030    0 1 5
$DPS_DB_BUILD_HOME/db_ProductGaps.tab                   $1 dynamic_data   118   118    0 1 5
$DPS_DB_BUILD_HOME/db_ProductSessionQA.tab              $1 dynamic_data  2764  2764    0 1 5
$DPS_DB_BUILD_HOME/db_ProductSessQuality.tab            $1 dynamic_data    54    54    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSpec.tab                   $1 dynamic_data   122   122    0 1 20
$DPS_DB_BUILD_HOME/db_ProductThreshold.tab              $1 dynamic_data  3344  3344    0 1 5
$DPS_DB_BUILD_HOME/db_ProductXfer.tab                   $1 dynamic_data 40602 40602    0 1 5
$DPS_DB_BUILD_HOME/db_RawScheduleLog.tab                $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_ResourceConstituentSchedule.tab   $1 dynamic_data    30    30    0 1 5
$DPS_DB_BUILD_HOME/db_ResourceSchedule.tab              $1 dynamic_data    22    22    0 1 5
$DPS_DB_BUILD_HOME/db_RTOSDataReceiptAcct.tab           $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_RTOSDataTransmissionAcct.tab      $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_RTOSSelectedData.tab              $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSUserSelectionSpec.tab         $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSVCAppIDTransAcct.tab          $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_SchedMsgAcct.tab                  $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleMessageID.tab             $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_SelectedIDs.tab                   $1 dynamic_data   344   344    0 1 5
$DPS_DB_BUILD_HOME/db_SessionHeader.tab                 $1 dynamic_data   176   176    0 1 5
$DPS_DB_BUILD_HOME/pdp_hash_index.tab                   $1 dynamic_data 15818 15818    0 3 10
$DPS_DB_BUILD_HOME/pdp_hash_parameters.tab              $1 dynamic_data     2     2    0 1 4
$DPS_DB_BUILD_HOME/pdp_ProductCatalog.tab               $1 dynamic_data    90    90    0 1 4
$DPS_DB_BUILD_HOME/pdp_ProductFileFormat.tab            $1 dynamic_data   186   186    0 2 10
$DPS_DB_BUILD_HOME/pdp_ProductSelectedId.tab            $1 dynamic_data   180   180    0 1 4
$DPS_DB_BUILD_HOME/pdp_TapeSessionIDs.tab               $1 dynamic_data     8     8    0 1 2
$DPS_DB_BUILD_HOME/psc_IPCDescp.tab                     $1 dynamic_data     2     2    0 1 2
fi
 
if [ "$DPS_DB_RESIZE" = big ]
then
################################################################################################
#
#           L A R G E     C O N F I G U R A T I O N
#
################################################################################################
$DPS_DB_BUILD_HOME/db_AppDestDefaults.tab               $1 static_data     16    16    0 1 20
$DPS_DB_BUILD_HOME/db_CaptureScheduleSetup.tab          $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_CHIMissionInfo.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ChnlInformation.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ConfigurableItems.tab             $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DataRate.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DataSource.tab                    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DDFTransmissionConfig.tab         $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DestinationCatalog.tab            $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DestinationFacility.tab           $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FddiFELookup.tab                  $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FESConfiguration.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FilterRates.tab                   $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_FrameSorterConfiguration.tab      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FrameSyncSetup.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FSFilterSetup.tab                 $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_FSFilterValue.tab                 $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_GroundTerminal.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_GroupDestination.tab              $1 static_data      8     8    0 1 20
$DPS_DB_BUILD_HOME/db_HST_PKSetup.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_IDFSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_Message.tab                       $1 static_data    186   186    0 1 20
$DPS_DB_BUILD_HOME/db_MissionCatalog.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDataRate.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDataStreamIDCatalog.tab    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionDestination.tab            $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionStation.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionSupportID.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_MissionThresholds.tab             $1 static_data      6     6    0 1 20
$DPS_DB_BUILD_HOME/db_NetworkID.tab                     $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_OracleLogin.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PacketizationPath.tab             $1 static_data     16    16    0 1 20
$DPS_DB_BUILD_HOME/db_PDPConfiguration.tab              $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PEConfiguration.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PFCSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PKSetup.tab                       $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PMSSInputLine.tab                 $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_POCCWindow.tab                    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ProductHost.tab                   $1 static_data      4     4    0 1 20
$DPS_DB_BUILD_HOME/db_PTTConfiguration.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceCatalog.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceConstituentDefaults.tab   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ResourceDevices.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RSBSSetup.tab                     $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RSDSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTMissionSetup.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSConfig.tab                    $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSPortNum.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleDisplayDefaults.tab       $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleOption.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleSource.tab                $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_SIDSetup.tab                      $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_SQAFIPSetup.tab                   $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_Station.tab                       $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_TerminalLocation.tab              $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_TimeCoefficient.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_UserAccessLevel.tab               $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_UserCategory.tab                  $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/db_UserLevel.tab                     $1 static_data      2     2    0 1 20
$DPS_DB_BUILD_HOME/pdp_GroupIds.tab                     $1 static_data      2     2    0 1 20
 
$DPS_DB_BUILD_HOME/db_AcqSessionCharacteristics.tab     $1 dynamic_data   552   552    0 1 5
$DPS_DB_BUILD_HOME/db_AppDestSchedule.tab               $1 dynamic_data     2     2    0 1 2
$DPS_DB_BUILD_HOME/db_CTMStatus.tab                     $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_DANIndx.tab                       $1 dynamic_data  2302  2302    0 1 10
$DPS_DB_BUILD_HOME/db_DCR.tab                           $1 dynamic_data    16    16    0 1 4
$DPS_DB_BUILD_HOME/db_EventLog.tab                      $1 dynamic_data 27134  2714    0 1 20
$DPS_DB_BUILD_HOME/db_FESessionAcct.tab                 $1 dynamic_data   802   802    0 1 5
$DPS_DB_BUILD_HOME/db_FEUnselVCAcct.tab                 $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_FEVcAppAcct.tab                   $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_FEVirtualChannelAcct.tab          $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_GPGroupIndx.tab                   $1 dynamic_data 257202 25722   0 1 50
$DPS_DB_BUILD_HOME/db_GPProductIndx.tab                 $1 dynamic_data  3068  3068    0 1 10
$DPS_DB_BUILD_HOME/db_GroupSequenceNumbers.tab          $1 dynamic_data   202   202    0 1 8
$DPS_DB_BUILD_HOME/db_HST_SessionAcct.tab               $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_HST_SIDAcct.tab                   $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_LogCatalog.tab                    $1 dynamic_data   648   648    0 1 5
$DPS_DB_BUILD_HOME/db_PDPDataMaintActivity.tab          $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_PDPSessionDataDiscont.tab         $1 dynamic_data 337982 33798   0 1 100
$DPS_DB_BUILD_HOME/db_PDPSessionsAcct.tab               $1 dynamic_data   210   210    0 1 10
$DPS_DB_BUILD_HOME/db_PDPSessVCAppIDAcct.tab            $1 dynamic_data 69952  6995    0 1 50
$DPS_DB_BUILD_HOME/db_PDPTapeDirectoryContents.tab      $1 dynamic_data   962   962    0 1 10
$DPS_DB_BUILD_HOME/db_PDPTelemetryOnDisk.tab            $1 dynamic_data   110   110    0 1 10
$DPS_DB_BUILD_HOME/db_PMSchedule.tab                    $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ProdMessageQualityAndAcct.tab     $1 dynamic_data 18058  1806    0 1 50
$DPS_DB_BUILD_HOME/db_ProductGaps.tab                   $1 dynamic_data 25642  2564    0 1 50
$DPS_DB_BUILD_HOME/db_ProductSessionQA.tab              $1 dynamic_data 11746  1176    0 1 50
$DPS_DB_BUILD_HOME/db_ProductSessQuality.tab            $1 dynamic_data   156   156    0 1 10
$DPS_DB_BUILD_HOME/db_ProductSpec.tab                   $1 dynamic_data   386   386    0 1 20
$DPS_DB_BUILD_HOME/db_ProductThreshold.tab              $1 dynamic_data 14728  1474    0 1 50
$DPS_DB_BUILD_HOME/db_ProductXfer.tab                   $1 dynamic_data 180602 18062   0 1 50
$DPS_DB_BUILD_HOME/db_RawScheduleLog.tab                $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_ResourceConstituentSchedule.tab   $1 dynamic_data    82    82    0 1 5
$DPS_DB_BUILD_HOME/db_ResourceSchedule.tab              $1 dynamic_data    58    58    0 1 5
$DPS_DB_BUILD_HOME/db_RTOSDataReceiptAcct.tab           $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_RTOSDataTransmissionAcct.tab      $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_RTOSSelectedData.tab              $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSUserSelectionSpec.tab         $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_RTOSVCAppIDTransAcct.tab          $1 dynamic_data     2     2    0 1 5
$DPS_DB_BUILD_HOME/db_SchedMsgAcct.tab                  $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_ScheduleMessageID.tab             $1 dynamic_data     2     2    0 1 20
$DPS_DB_BUILD_HOME/db_SelectedIDs.tab                   $1 dynamic_data  1544  1544    0 1 5
$DPS_DB_BUILD_HOME/db_SessionHeader.tab                 $1 dynamic_data   552   552    0 1 5
$DPS_DB_BUILD_HOME/pdp_hash_index.tab                   $1 dynamic_data 2000000 50000  0 1 400
$DPS_DB_BUILD_HOME/pdp_hash_parameters.tab              $1 dynamic_data     4     4    0 1 4
$DPS_DB_BUILD_HOME/pdp_ProductCatalog.tab               $1 dynamic_data   282   282    0 1 4
$DPS_DB_BUILD_HOME/pdp_ProductFileFormat.tab            $1 dynamic_data   832   832    0 2 10
$DPS_DB_BUILD_HOME/pdp_ProductSelectedId.tab            $1 dynamic_data   808   808    0 1 4
$DPS_DB_BUILD_HOME/pdp_TapeSessionIDs.tab               $1 dynamic_data    24    24    0 1 2
$DPS_DB_BUILD_HOME/psc_IPCDescp.tab                     $1 dynamic_data     2     2    0 1 2
fi

echo "*****************************************************************"
echo " DONE building DPS tables - see log file for results"
echo "*****************************************************************"
echo ""
exit
