-- Database Definition File
--
set verify
--
-- Physical Database Definition
--
-- You may want to add a directory to the file spec.
__
create SCHEMA filename filename 'QNA.RDB'
    dictionary is NOT REQUIRED
    snapshot is ENABLED IMMEDIATE
    allocation is 3000 pages
;
commit work;
--
-- Domain Definitions
--
create domain AA_DATE	DATE VMS;
 
create domain AA_NUMBER	INTEGER edit string is 'ZZZ,ZZ9';
 
commit work;
--
-- Table Definitions
--
create table QNA_COUNTS (
    DATE_TIME			AA_DATE,
    SECONDS_SINCE_LAST_ZEROED	AA_NUMBER,
    DATA_BLOCKS_RECEIVED	AA_NUMBER,
    MULTICAST_BLOCKS_RECEIVED	AA_NUMBER,
    RECEIVE_FAILURE		AA_NUMBER,
    BYTES_RECEIVED		AA_NUMBER
				edit string is 'Z,ZZZ,ZZ9',
    MULTICAST_BYTES_RECEIVED	AA_NUMBER
				edit string is 'z,zzz,zz9',
    DATA_OVERRUN		AA_NUMBER,
    DATA_BLOCKS_SENT		AA_NUMBER,
    MULTICAST_BLOCKS_SENT	AA_NUMBER,
    BLOCKS_SENT_MULTIPLE_COLLISIONS	AA_NUMBER,
    BLOCKS_SENT_SINGLE_COLLISION	AA_NUMBER,
    BLOCKS_SENT_INITIALLY_DEFERRED	AA_NUMBER,
    BYTES_SENT			AA_NUMBER
				edit string is 'Z,ZZZ,ZZ9',
    MULTICAST_BYTES_SENT	AA_NUMBER
				edit string is 'Z,ZZZ,ZZ9',
    SEND_FAILURE		AA_NUMBER,
    COLLISION_DETECT_CHECK_FAILURE	AA_NUMBER,
    UNRECOGNIZED_FRAME_DESTINATION	AA_NUMBER,
    SYSTEM_BUFFER_UNAVAILABLE	AA_NUMBER,
    USER_BUFFER_UNAVAILABLE	AA_NUMBER);
 
create table DPV_COUNTS (
    DATE_TIME			AA_DATE,
    SECONDS_SINCE_LAST_ZEROED	AA_NUMBER,
    BYTES_RECEIVED		AA_NUMBER
				edit string is 'Z,ZZZ,ZZ9',
    BYTES_SENT			AA_NUMBER
				edit string is 'Z,ZZZ,ZZ9',
    DATA_BLOCKS_RECEIVED	AA_NUMBER,
    DATA_BLOCKS_SENT		AA_NUMBER,
    DATA_ERRORS_INBOUND		AA_NUMBER,
    DATA_ERRORS_OUTBOUND	AA_NUMBER,
    REMOTE_REPLY_TIMEOUTS	AA_NUMBER,
    LOCAL_REPLY_TIMEOUTS	AA_NUMBER,
    REMOTE_BUFFER_ERRORS	AA_NUMBER,
    LOCAL_BUFFER_ERRORS		AA_NUMBER,
    REMOTE_PROCESS_ERRORS	AA_NUMBER,
    LOCAL_PROCESS_ERRORS	AA_NUMBER);
 
commit work;

GRANT ALL PRIVILEGES ON SCHEMA RDB$DBHANDLE TO PUBLIC;

commit work;
