[Snort-devel] Re: [Snort-users] DB schema v104

Andreas Hasenack andreas at ...836...
Wed Sep 26 06:39:13 EDT 2001


Em Wed, Sep 26, 2001 at 10:19:04AM -0300, Andreas Hasenack escreveu:
> here it is. But I think I saw something different on snort's CVS today.

Yes, here is the CVS patch.

-------------- next part --------------
===================================================================
RCS file: /cvsroot/snort/snort/contrib/create_mssql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- snort/snort/contrib/create_mssql	2001/08/07 13:15:11	1.1
+++ snort/snort/contrib/create_mssql	2001/09/26 03:42:39	1.2
@@ -24,7 +24,7 @@
 CREATE TABLE [schema] ( vseq        NUMERIC(10,0) NOT NULL,
                         ctime       DATETIME      NOT NULL,
                         PRIMARY KEY (vseq))
-INSERT INTO [schema]  (vseq, ctime) VALUES ('103', GETDATE())
+INSERT INTO [schema]  (vseq, ctime) VALUES ('104', GETDATE())

 CREATE TABLE event  ( sid         NUMERIC(10,0)   NOT NULL ,
                       cid         NUMERIC(10,0)   NOT NULL ,
@@ -51,7 +51,7 @@

 CREATE TABLE reference (  ref_id        NUMERIC(10,0) IDENTITY(1,1) NOT NULL,
                           ref_system_id NUMERIC(10,0)               NOT NULL,
-                          ref_tag       VARCHAR(20)                 NOT NULL,
+                          ref_tag       TEXT                        NOT NULL,
                           PRIMARY KEY (ref_id))

 CREATE TABLE reference_system ( ref_system_id   NUMERIC(10,0) IDENTITY(1,1) NOT NULL,
===================================================================
RCS file: /cvsroot/snort/snort/contrib/create_mysql,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- snort/snort/contrib/create_mysql	2001/08/03 18:51:38	1.14
+++ snort/snort/contrib/create_mysql	2001/09/26 03:42:39	1.15
@@ -21,7 +21,7 @@
 CREATE TABLE schema ( vseq        INT      UNSIGNED NOT NULL,
                       ctime       DATETIME NOT NULL,
                       PRIMARY KEY (vseq));
-INSERT INTO schema  (vseq, ctime) VALUES ('103', now());       
+INSERT INTO schema  (vseq, ctime) VALUES ('104', now());       

 CREATE TABLE event  ( sid 	  INT 	   UNSIGNED NOT NULL,
                       cid 	  INT 	   UNSIGNED NOT NULL,
@@ -48,7 +48,7 @@

 CREATE TABLE reference (  ref_id        INT         UNSIGNED NOT NULL AUTO_INCREMENT,
                           ref_system_id INT         UNSIGNED NOT NULL,
-                          ref_tag       VARCHAR(20) NOT NULL,
+                          ref_tag       TEXT NOT NULL,
                           PRIMARY KEY (ref_id));

 CREATE TABLE reference_system ( ref_system_id   INT         UNSIGNED NOT NULL AUTO_INCREMENT,
===================================================================
RCS file: /cvsroot/snort/snort/contrib/create_oracle.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- snort/snort/contrib/create_oracle.sql	2001/08/11 07:49:13	1.1
+++ snort/snort/contrib/create_oracle.sql	2001/09/26 03:42:39	1.2
@@ -49,7 +49,7 @@
                       ctime       VARCHAR2(24) NOT NULL,
                       PRIMARY KEY (vseq));
 
-INSERT INTO schema  (vseq, ctime) VALUES ('103', sysdate);
+INSERT INTO schema  (vseq, ctime) VALUES ('104', sysdate);

 prompt event;
 drop table event;
@@ -94,7 +94,7 @@
 drop table reference;
 CREATE TABLE reference (  ref_id        INT          NOT NULL,
                           ref_system_id INT          NOT NULL,
-                          ref_tag       VARCHAR2(20) NOT NULL,
+                          ref_tag       VARCHAR2(100) NOT NULL,
                           PRIMARY KEY (ref_id));
 --
 --  auto-increment the reference.ref_id
===================================================================
RCS file: /cvsroot/snort/snort/contrib/create_postgresql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- snort/snort/contrib/create_postgresql	2001/06/15 21:00:26	1.10
+++ snort/snort/contrib/create_postgresql	2001/09/26 03:42:39	1.11
@@ -21,7 +21,7 @@
 CREATE TABLE schema ( vseq        INT4     NOT NULL,
                       ctime       DATETIME NOT NULL,
                       PRIMARY KEY (vseq));
-INSERT INTO schema  (vseq, ctime) VALUES ('103', now());
+INSERT INTO schema  (vseq, ctime) VALUES ('104', now());

 CREATE TABLE signature ( sig_id       SERIAL NOT NULL,
                          sig_name     TEXT NOT NULL,
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
URL: <https://lists.snort.org/pipermail/snort-devel/attachments/20010926/6dbec686/attachment.sig>


More information about the Snort-devel mailing list