Re: create table schema

["Onie Camara" <neil () restricted dyndns org>]

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 () restricted dyndns org>
To: <snort-users () 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 () restricted dyndns org) - 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 () 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


_______________________________________________
Snort-users mailing list
Snort-users () 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