#!/bin/sh
#*******************************************************************************
#             PACOR II SOFTWARE
#       Property of the U.S. Government
#            NASA/GSFC/Code 560
#*******************************************************************************
#PURPOSE: Creates the sequence generators. 
#
#INVOCATION METHOD: SeqBuilder_DPS user/pw
#
#
#DEVELOPMENT HISTORY:
#
#       Author          Change-ID    Release    Date    Description of Change
#       ------          ---------    -------    ----    ---------------------
#    L. Lease                        Build 1   7/93      Initial release
#    S. Azama                        Build 2   10/3/93   Changes for build 2. 
# M.Rauschenberger                   Build 3   03/16/94  Changes for build 3. 
# P. Matthews                        B3R2      05/05/94  Added sequence number for
#                                                        PMSchedule
# P. Matthews                        B3R2      05/16/94  Added appdestdefseq 
#                                                        sequence number
# P. Matthews                        B3R2      06/28/94  Added sequence number for
#                                                        specname
# P. Matthews                        B3R2      06/29/94  Deleted sequences
#                                                        AppDestSchedSeq and
#                                                        RescConstSchSeq
# M.Rauschenberger                   B4R2.1    09/23/94  Added DataMainId
# P. Matthews                        B4R2.1    10/25/94  Deleted sequences 
#                                                        appdestdefseq and 
#                                                        rescconstdefseq 
# P. Matthews                         B4R2.1   11/09/94  Incremented MsgNum to 1 million
# P. Matthews                         B4R2.1   11/16/94  Removed AcqSessCharSeq
#                                                        sequence number
# J. Whelan             PAC2950977     R3.0    10/01/95  Change maxvalue of
#                                                         DAN_sequence
# I. Horowitz           ACE0615      ACE R2.0  06/30/96  Minor edits, added connect stmt.
# R. Wiechert           ISTP         R1.2      04/20/98  Cache option causes sequences
#                                                         to skip in really busy systems,
#                                                         like ISTP, so use no cache.
#
#*********************************************************************************
if test $# -ne 1
then
   echo '***********************************************'
   echo 'Error, you must enter an Oracle UserID/Password'
   echo '***********************************************'
   exit
fi

sqlplus /nolog << ENDORACLE 
connect $1

DROP SEQUENCE DAN_sequence;
CREATE SEQUENCE DAN_sequence 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 999999999
   CYCLE
   CACHE 2;

DROP SEQUENCE MsgNum;
CREATE SEQUENCE MsgNum
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 1000000
   CYCLE
   CACHE 2;

DROP SEQUENCE Product_sequence;
CREATE SEQUENCE Product_sequence 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 100000
   CYCLE
   CACHE 2;

DROP SEQUENCE ScheduleMsgNum;
CREATE SEQUENCE ScheduleMsgNum 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 10000
   CYCLE
   CACHE 2;

DROP SEQUENCE ScheduleNum;
CREATE SEQUENCE ScheduleNum 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 1000000
   CYCLE
   CACHE 2;

DROP SEQUENCE SessionNum;
CREATE SEQUENCE SessionNum 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 1000000
   CYCLE
   CACHE 2;

DROP SEQUENCE PMSchedulenum;
CREATE SEQUENCE PMSchedulenum 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 10000
   CYCLE
   CACHE 2;

DROP SEQUENCE DataMaintId;
CREATE SEQUENCE DataMaintId 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 32000
   CYCLE
   CACHE 2;

DROP SEQUENCE SpecNameSeq;
CREATE SEQUENCE SpecNameSeq 
   START WITH 1
   INCREMENT BY 1
   MAXVALUE 1000000
   CYCLE
   CACHE 2;

ENDORACLE

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