Solaris

REM
REM List of audit trail file types.  This is for human consumption only and
REM is never referenced or modified by the servers.
REM
CREATE TABLE gam_file_types (
	type		NUMBER(2,0)
			PRIMARY KEY
			USING INDEX
				TABLESPACE gam_ind
				STORAGE (INITIAL 256K NEXT 256K PCTINCREASE 0
					MAXEXTENTS UNLIMITED),
	description	VARCHAR2(100)
) TABLESPACE gam_tab STORAGE (INITIAL 256K NEXT 256K PCTINCREASE 0
				MAXEXTENTS UNLIMITED);

INSERT INTO gam_file_types VALUES (1, 'Activity records');
INSERT INTO gam_file_types VALUES (2, 'User information modification records');
INSERT INTO gam_file_types VALUES (3, 'Host ID tracking records');

REM
REM List of currently existing audit trail files.  This table is populated
REM by the MCP and updated by the gobbler.
REM
CREATE TABLE gam_files (
	filename	VARCHAR2(60)
			NOT NULL,
	type		NUMBER(2,0)
			NOT NULL,
	state		NUMBER(1)
			NOT NULL,
	created_time	NUMBER(20)
			NOT NULL,
	proc_start_time	NUMBER(20)
			NOT NULL,
	record_count	NUMBER(10)
			NULL
) TABLESPACE gam_tab STORAGE (INITIAL 256K NEXT 256K PCTINCREASE 0
				MAXEXTENTS unlimited);

ALTER TABLE gam_files ADD (CONSTRAINT gam_files_pk
	PRIMARY KEY (filename, type)
	USING INDEX TABLESPACE gam_ind STORAGE (INITIAL 256K NEXT 256K PCTINCREASE 0
			MAXEXTENTS unlimited)
);