#
# Title: ODIN SQL
#
# File: odin.sql
# Version: 0.2a
# 
# Written by Impriser <ram@cryptojail.net>
#
# Contributors: NONE
#
# =======================================
#   Copyright (C) 2002 the Odin Project
#   (see 'LICENSE' for license details)
# =======================================
#
# USAGE: 
# 
# CREATE DATABASE odin;
# GRANT ALL ON odin TO odin@localhost;
# FLUSH PRIVILEGES;
# mysql -u odin -D odin < ./odin.sql

CREATE TABLE pflog (     id      	INT     UNSIGNED NOT NULL AUTO_INCREMENT,
                        sip     	VARCHAR(15) NOT NULL,
                        dip     	VARCHAR(15) NOT NULL,
                        sport   	INT     UNSIGNED NOT NULL,
                        dport   	INT     UNSIGNED NOT NULL,
			action		text	NOT NULL,	
			direction	text	NOT NULL,	
			interface	VARCHAR(3) NOT NULL,
			rule		INT	UNSIGNED NOT NULL,
			date		datetime NOT NULL,
			flags		VARCHAR(6),
			seq1		DOUBLE	UNSIGNED,
			seq2		DOUBLE	UNSIGNED,
			tcpdata		INT	UNSIGNED,
			ackseq		DOUBLE	UNSIGNED,	
			df		INT 	UNSIGNED,
			win		INT	UNSIGNED,
			icmp		text,
			servfail	text,
			udplen		INT	UNSIGNED,
			options		text,		
			sensor		text NOT NULL,
                        PRIMARY KEY (id),
                        INDEX   sign_idx (sip));