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

Andreas Hasenack andreas at ...836...
Wed Sep 26 06:20:01 EDT 2001


Em Tue, Sep 25, 2001 at 01:42:07PM -0400, Brian escreveu:
> > [CVS writters]: Please commit the patches to the four files below.
> 
> Can you please send the diff as an attachment?

here it is. But I think I saw something different on snort's CVS today.


-------------- next part --------------
--- snort-1.8.1-RELEASE/contrib/create_mssql~	Tue Aug  7 10:15:11 2001
+++ snort-1.8.1-RELEASE/contrib/create_mssql	Tue Sep 25 14:49:41 2001
@@ -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       VARCHAR(100)                 NOT NULL,
                           PRIMARY KEY (ref_id))
 
 CREATE TABLE reference_system ( ref_system_id   NUMERIC(10,0) IDENTITY(1,1) NOT NULL,
--- snort-1.8.1-RELEASE/contrib/create_mysql~	Fri Aug  3 15:51:38 2001
+++ snort-1.8.1-RELEASE/contrib/create_mysql	Tue Sep 25 14:48:13 2001
@@ -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       VARCHAR(100) NOT NULL,
                           PRIMARY KEY (ref_id));
 
 CREATE TABLE reference_system ( ref_system_id   INT         UNSIGNED NOT NULL AUTO_INCREMENT,
--- snort-1.8.1-RELEASE/contrib/create_postgresql~	Fri Jun 15 18:00:26 2001
+++ snort-1.8.1-RELEASE/contrib/create_postgresql	Tue Sep 25 14:48:30 2001
@@ -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,
--- snort-1.8.1-RELEASE/contrib/create_oracle.sql~	Sat Aug 11 04:49:13 2001
+++ snort-1.8.1-RELEASE/contrib/create_oracle.sql	Tue Sep 25 14:49:04 2001
@@ -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
-------------- 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/69d18352/attachment.sig>


More information about the Snort-devel mailing list