! Copyright © Oracle Corporation 1995.  All Rights Reserved.
DEFINE DATABASE "DEMO$DB_NAME" DICTIONARY IS NOT USED
!
! Define default storage area for system relations and any other
! relations for which no STORAGE AREA is explicitly defined.
!
DEFINE STORAGE AREA RDB$SYSTEM FILENAME "DEMO$DIR:MF_PERS_DEFAULT"
  ALLOCATION IS 100 PAGES
  PAGE FORMAT IS UNIFORM
  SNAPSHOT_FILENAME IS "DEMO$DIR:MF_PERS_DEFAULT.SNP"
  SNAPSHOT ALLOCATION IS 50 PAGES
END RDB$SYSTEM STORAGE AREA
!
! Define special storage area for all segmented string fields
! in the MF_PERSONNEL database.
!
DEFINE STORAGE AREA MF_PERS_SEGSTR FILENAME "DEMO$DIR:MF_PERS_SEGSTR"
  ALLOCATION IS 50 PAGES
  PAGE FORMAT IS UNIFORM
  SNAPSHOT_FILENAME IS "DEMO$DIR:MF_PERS_SEGSTR.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END MF_PERS_SEGSTR STORAGE AREA
!
! Use the SEGMENTED STRING clause, required when a separate storage
! area is defined for segmented string fields
!
SEGMENTED STRING STORAGE AREA IS MF_PERS_SEGSTR

DEFINE STORAGE AREA EMPIDS_LOW FILENAME "DEMO$DIR:EMPIDS_LOW"
  ALLOCATION IS 50 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:EMPIDS_LOW.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END EMPIDS_LOW STORAGE AREA
!
DEFINE STORAGE AREA EMPIDS_MID FILENAME "DEMO$DIR:EMPIDS_MID"
  ALLOCATION IS 50 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:EMPIDS_MID.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END EMPIDS_MID STORAGE AREA
!
DEFINE STORAGE AREA EMPIDS_OVER FILENAME "DEMO$DIR:EMPIDS_OVER"
  ALLOCATION IS 50 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:EMPIDS_OVER.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END EMPIDS_OVER STORAGE AREA
!
DEFINE STORAGE AREA DEPARTMENTS FILENAME "DEMO$DIR:DEPARTMENTS"
  ALLOCATION IS 25 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:DEPARTMENTS.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END DEPARTMENTS STORAGE AREA
!
DEFINE STORAGE AREA SALARY_HISTORY FILENAME "DEMO$DIR:SALARY_HISTORY"
  ALLOCATION IS 25 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:SALARY_HISTORY.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END SALARY_HISTORY STORAGE AREA
!
DEFINE STORAGE AREA JOBS FILENAME "DEMO$DIR:JOBS"
  ALLOCATION IS 25 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:JOBS.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END JOBS STORAGE AREA
!
DEFINE STORAGE AREA EMP_INFO FILENAME "DEMO$DIR:EMP_INFO"
  ALLOCATION IS 30 PAGES
  PAGE FORMAT IS MIXED
  SNAPSHOT_FILENAME IS "DEMO$DIR:EMP_INFO.SNP"
  SNAPSHOT ALLOCATION IS 10 PAGES
END EMP_INFO STORAGE AREA.
!
PRINT "Completed DEFINE DATABASE (including storage areas) statement"