[Snort-users] create table schema

Onie Camara neil at ...4898...
Mon Feb 11 23:15:02 EST 2002


Please disregard my question. I've fixed it.

Now I know the use of the brackets in schema, [schema]. :-)

----- Original Message -----
From: "Onie Camara" <neil at ...4898...>
To: <snort-users at lists.sourceforge.net>
Sent: Tuesday, February 12, 2002 12:22 AM
Subject: [Snort-users] create table schema


> In the snort source under contrib, there is a file there named
create_mssql.
> My question is, what should I put in place of [schema] in this line?
> Actually, it's the first line.
>
> CREATE TABLE [schema] ( vseq NUMERIC(10,0) NOT NULL,
>                         ctime       DATETIME      NOT NULL,
>                         PRIMARY KEY (vseq))
> INSERT INTO [schema]  (vseq, ctime) VALUES ('104', GETDATE())
>
> In contrib/create_mysql, the word "schema" was used. But in MS Sql 7.0,
> schema is a reserved word. I tried to remove the brackets but it wouldn't
> create it.
>
> Assuming you replied to me with snort_schema as a replacement, what
> files should I modify on the snort source before I compile it?
>
> Thanks.
>
> Neil
>
> neil camara (neil at ...4898...) - cc{na|sa}, mcse - pgp
0x777777B2
> network/security engineer - dl := +1(847)2.21.0.224 cn :=
+1(847)9.80.17.53
> echo "I love windows" | sed -e 's/wi/u/g' | cut -f1 -dd | \
> awk '/u/ {printf("%s %s %six\n",$1,$2,$3)}'
>
>
>
> _______________________________________________
> Snort-users mailing list
> Snort-users at lists.sourceforge.net
> Go to this URL to change user options or unsubscribe:
> https://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users





More information about the Snort-users mailing list