-- Copyright © Oracle Corporation 1995.  All Rights Reserved.

CREATE STORAGE AREA RDB$SYSTEM
  FILENAME mf_pers_default 
  ALLOCATION IS 100 PAGES
  PAGE FORMAT IS UNIFORM 
  SNAPSHOT FILENAME  mf_pers_default.snp 
  SNAPSHOT ALLOCATION IS 50 PAGES
--
CREATE STORAGE AREA EMPIDS_LOW
       FILENAME empids_low 
       ALLOCATION IS 50 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  empids_low.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
--
CREATE STORAGE AREA EMPIDS_MID
       FILENAME  empids_mid 
       ALLOCATION IS 50 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  empids_mid.snp 
       SNAPSHOT ALLOCATION IS 10 pages
--
CREATE STORAGE AREA EMPIDS_OVER
       FILENAME  empids_over 
       ALLOCATION IS 50 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  empids_over.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
--
CREATE STORAGE AREA DEPARTMENTS
       FILENAME  departments 
       ALLOCATION IS 25 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  departments.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
--
CREATE STORAGE AREA SALARY_HISTORY
       FILENAME  salary_history 
       ALLOCATION IS 25 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  salary_history.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
--
CREATE STORAGE AREA JOBS
       FILENAME  jobs 
       ALLOCATION IS 25 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  jobs.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
--
CREATE STORAGE AREA EMP_INFO
       FILENAME  emp_info 
       ALLOCATION IS 30 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  emp_info.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
      
--
CREATE STORAGE AREA RESUME_LISTS
       FILENAME  resume_lists 
       ALLOCATION IS 30 PAGES
       PAGE SIZE IS 6 BLOCKS
       PAGE FORMAT IS MIXED
       THRESHOLDS ARE (30,60,80)
       SNAPSHOT FILENAME  resume_lists.snp 
       SNAPSHOT ALLOCATION IS 10 PAGES
--
CREATE STORAGE AREA RESUMES
       FILENAME  resumes 
       ALLOCATION IS 30 PAGES
       PAGE FORMAT IS MIXED
       SNAPSHOT FILENAME  resumes.snp    
       SNAPSHOT ALLOCATION IS 10 PAGES;

-- Note that semicolon on preceding line terminates the CREATE DATABASE statement.
-- Finished with database and storage area definitions. Next, define domains,
-- tables, and multifile structures.
DISCONNECT ALL;