Snort mailing list archives
AW: db schema upgrade
From: "Sean Wheeler" <s.wheeler () netprotect ch>
Date: Mon, 14 Oct 2002 20:08:43 +0200
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
Current thread:
- db schema upgrade Vladimir Orlando (Oct 10)
- AW: db schema upgrade Sean Wheeler (Oct 14)