[Sguil-cvs] sguil/server/sql_scripts create_sguildb.sql,1.17,1.18

[Bamm V. <ba...@us...>]

Update of /cvsroot/sguil/sguil/server/sql_scripts
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv11510/server/sql_scripts

Modified Files:
	create_sguildb.sql 
Log Message:
"Sessions" have been depreciated.


Index: create_sguildb.sql
===================================================================
RCS file: /cvsroot/sguil/sguil/server/sql_scripts/create_sguildb.sql,v
retrieving revision 1.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** create_sguildb.sql	1 Mar 2007 05:06:45 -0000	1.17
--- create_sguildb.sql	17 Mar 2007 02:43:37 -0000	1.18
***************
*** 122,146 ****
    INDEX ps_timestamp (timestamp));
  
! CREATE TABLE sessions ( 
!   sid		INT UNSIGNED NOT NULL, 
!   xid		BIGINT UNSIGNED NOT NULL, 
!   start_time	datetime NOT NULL, 
!   end_time	datetime NOT NULL, 
!   src_ip	INT UNSIGNED NOT NULL, 
!   dst_ip	INT UNSIGNED NOT NULL, 
!   src_port	INT UNSIGNED NOT NULL, 
!   dst_port	INT UNSIGNED NOT NULL, 
!   ip_proto	TINYINT UNSIGNED NOT NULL,
!   src_pckts	BIGINT UNSIGNED NOT NULL, 
!   dst_pckts	BIGINT UNSIGNED NOT NULL, 
!   src_bytes	BIGINT UNSIGNED NOT NULL, 
!   dst_bytes	BIGINT UNSIGNED NOT NULL, 
!   PRIMARY KEY (sid,xid), 
!   INDEX begin (start_time), 
!   INDEX end (end_time), 
!   INDEX server (src_ip), 
!   INDEX client (dst_ip), 
!   INDEX sport (src_port), 
!   INDEX cport (dst_port)); 
  
  CREATE TABLE status
--- 122,147 ----
    INDEX ps_timestamp (timestamp));
  
! -- Depreciated
! -- CREATE TABLE sessions ( 
! --  sid		INT UNSIGNED NOT NULL, 
! --  xid		BIGINT UNSIGNED NOT NULL, 
! --  start_time	datetime NOT NULL, 
! --  end_time	datetime NOT NULL, 
! --  src_ip	INT UNSIGNED NOT NULL, 
! --  dst_ip	INT UNSIGNED NOT NULL, 
! --  src_port	INT UNSIGNED NOT NULL, 
! --  dst_port	INT UNSIGNED NOT NULL, 
! --  ip_proto	TINYINT UNSIGNED NOT NULL,
! --  src_pckts	BIGINT UNSIGNED NOT NULL, 
! --  dst_pckts	BIGINT UNSIGNED NOT NULL, 
! --  src_bytes	BIGINT UNSIGNED NOT NULL, 
! --  dst_bytes	BIGINT UNSIGNED NOT NULL, 
! --  PRIMARY KEY (sid,xid), 
! --  INDEX begin (start_time), 
! --  INDEX end (end_time), 
! --  INDEX server (src_ip), 
! --  INDEX client (dst_ip), 
! --  INDEX sport (src_port), 
! --  INDEX cport (dst_port)); 
  
  CREATE TABLE status