[Snort-devel] DB changes

roman at ...49... roman at ...49...
Tue Jun 18 13:14:03 EDT 2002


Patch committed.

thanks,
Roman

> 
> Oracle 9i, though it still supports LONG datatypes, does not provide the
> same support as seen in the past.   This patch is for anyone using Oracle.
> I recommend it be applied to create_oracle.sql.  Oracle will completely
> phase out LONG in the next version... All of this in favor of LOBs.
> 
> We've had our DBs set up like this from the beginning, requires no
> modification to spo_database.
> 
> diff -urN old-create_oracle.sql new-create_oracle.sql
> --- old-create_oracle.sql  Tue Jun 18 13:04:27 2002
> +++ new-create_oracle.sql   Tue Jun 18 13:04:27 2002
> @@ -249,7 +249,7 @@
>          opt_proto       INT NOT NULL,
>          opt_code        INT NOT NULL,
>          opt_len         INT,
> -        opt_data        LONG,
> +        opt_data        BLOB,
>          PRIMARY KEY (sid,cid,optid));
>  
>  
> @@ -259,7 +259,7 @@
>  CREATE TABLE data (
>          sid             INT NOT NULL,
>          cid             INT NOT NULL,
> -        data_payload  LONG,
> +        data_payload  BLOB,
>          PRIMARY KEY (sid,cid));
> 
> ----------------------------------------------------------------------------
>                    Bringing you mounds of caffeinated joy
>                    >>>     http://thinkgeek.com/sf    <<<
> 
> _______________________________________________
> Snort-devel mailing list
> Snort-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/snort-devel
> 
> 



---------------------------------------------
This message was sent using Voicenet WebMail.
      http://www.voicenet.com/webmail/






More information about the Snort-devel mailing list