AW: db schema upgrade

["Sean Wheeler" <s.wheeler () netprotect ch>]

hi,

from my comparison, I applied the following changes, excuse the scribbling
format

#######################################
** Core Snort required Schema Changes**
#######################################
***schema***
DELETE from schema;
INSERT INTO schema  (vseq, ctime) VALUES ('106', now());
***event***
no change required
***signature***
no change required
***sig_reference***
no change required
***reference***
no change required
***reference_system***
no change required
***sig_class***
no change required
***sensor***
ALTER TABLE `snort`.`sensor` ADD `last_cid` INT UNSIGNED NOT NULL;
***iphdr***
ALTER TABLE `iphdr` DROP INDEX `cid`
***tcphdr***
no change required
***udphdr***
no change required
***icmphdr***
no change required
***opt***
no change required
***data***
no change required
***encoding***
no change required
***detail***
no change required

regards

Sean

-----Ursprungliche Nachricht-----
Von: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net]Im Auftrag von Vladimir
Orlando
Gesendet: Montag, 7. Oktober 2002 14:03
An: snort-users () lists sourceforge net
Betreff: [Snort-users] db schema upgrade


Hi everyone,

i've just upgraded my old version of Snort (1.8.3) with new 1.9.0. Only a
problem. My old version used Mysql schema 1.04, my new version new schema
1.06.
How can I upgrade my Mysql schema in an easy way?

Thanks a lot.


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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