!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	OPUS_RELEASE.SDDL
!
! Purpose:      This SDDL file defines the sogs_release relation.
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---    -------------------------------------------------
! 11/ 2/94    27329     EGB    Original implementation
! 01/15/96    30650     EGB    Rework for OPUS / SPSS decoupling
! 12/21/99    40131.1   MARose Stolen from SPSS to create the opus version
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!

LANGUAGE	SQL

RECORD  SOGSREL_TYPE

!------------------------------------------------------------------------------
!
!   RECORD INFORMATION
!
!------------------------------------------------------------------------------

    DESCRIPTION       "This relation contains a history of OPUS database 
		       installations.  It is useful for determining the
                       build configuration of a SOGS compatible database.

		       This was needed to help maintain the proliferation 
		       of test databases - it was often difficult to determine 
		       what configuration they were in (i.e. what build they 
                       map to). 

		       The table is designed to have only a single record
		       in it at any one time so a simple select will be
		       able to tell you the database configuration level.

                       See original OPR 26929 for more details, and OPR
		       30650 for additional details."

!------------------------------------------------------------------------------
!
!   FIELD INFORMATION
!
!------------------------------------------------------------------------------

    FIELD  opus_release_id
        TYPE            C*10
        DESCRIPTION     "This field identifies tha latest OPUS release 
			 to update the SOGS database.

                         Sample values include:  10.3f, 5.0"
    END_FIELD

    FIELD  opus_install_date
        TYPE            SYBASE_DATETIME  
        DESCRIPTION     "This field is set to the time the current SOGS PMDB 
			 database was installed with OPUS-specific updates."
    END_FIELD

END_RECORD

!------------------------------------------------------------------------------
!
!   RELATION DECLARATION
!
!------------------------------------------------------------------------------

RELATION  opus_release

    TYPE             SOGSREL_TYPE

    DESCRIPTION      "OPUS Project Management Database Identifier Relation"

    SUBSYSTEM_USING  "OPUS", "DBMS"

    INDEX opus_release_1       
        TYPE    unique, clustered 
        FIELDS  opus_release_id, opus_install_date
    END_INDEX

END_RELATION