set	verify	

-- --
--  Facility:
--    NetFlow Host Collector
--
--  Environment:
--    VMS/VAX/Alpha/IA64,
--    DEC/ORACLE RDB 7.x,
--    WASD HTTP Server.
--
--  Author:   Ruslan R. Laishev
--
--  Creation Date: 10-AUG-2009
--
--  Abstract:   This script is supposed to be used as first time to performs
--      creation of tables, stored routines and so on...
--
--  Usage:
--    SQL$ @NETFLOW_RDB_INIT.SQL
--
--  Modifications:
--	 5-NOV-2009	RRL	Added srcas (Source AS number)
-- ++

CREATE	DATABASE	FILENAME	'NETFLOW'
CREATE  STORAGE AREA	NETFLOW_IDX	FILENAME 'NETFLOW_IDX'PAGE FORMAT IS MIXED;
ATTACH	'FILENAME	NETFLOW';

-- --
--  Create internal data types/domains :
-- ++

CREATE	DOMAIN	dom_date	DATE VMS DEFAULT SYSDATE;
CREATE  DOMAIN  dom_ipaddr	CHAR(15)	DEFAULT '0.0.0.0';
CREATE	DOMAIN	dom_long	INTEGER DEFAULT 0;
CREATE	DOMAIN	dom_word	SMALLINT DEFAULT 0;
CREATE	DOMAIN	dom_byte	TINYINT DEFAULT 0;

CREATE  TABLE netflow
	(
	tstamp		dom_date,
	sysip		dom_ipaddr,
	srcaddr		dom_ipaddr,
	dstaddr		dom_ipaddr,
	inp		dom_word,
	out		dom_word,
	dpkts		dom_long,
	doctets		dom_long,
	srcport		dom_word,
	dstport		dom_word,
	flags		dom_byte,
	prot		dom_byte,
	tos		dom_byte,
	dst_as		dom_word,
	src_as		dom_word
	) COMMENT IS 'Table to storing Netflow Data Record';

CREATE	INDEX	tstamp_idx ON netflow (tstamp) TYPE is HASHED STORE IN NETFLOW_IDX;
CREATE	INDEX	srcaddr_idx ON netflow (srcaddr) TYPE is HASHED STORE IN NETFLOW_IDX;
CREATE	INDEX	dstaddr_idx ON netflow (dstaddr) TYPE is HASHED STORE IN NETFLOW_IDX;