Re: Update schema

[roman () danyliw com]

If you have a v103 database, the only steps you need to take to upgrade to
v104 are as follows:

mysql> DELETE FROM schema WHERE vseq = 103;
mysql> INSERT INTO schema (vseq, ctime) VALUES (104, now());
mysql> ALTER TABLE reference MODIFY ref_tag VARCHAR(100) NOT NULL;

Roman

On Thu, 18 Oct 2001, East, Bill wrote:

> I simply must be dim.
>
> Running snort 1.8.1, ACID v0.9.6b16. ACID shows schema version 1.03. I
> downloaded the latest and extracted the create_mysql script. Entered mysql,
> USEd the proper database, and SOURCEd the script. It ran, and I can do a
> SELECT * from schema to get
>
> +------+---------------------+
> | vseq | ctime               |
> +------+---------------------+
> |  103 | 2001-09-20 14:18:21 |
> |  104 | 2001-10-18 16:13:44 |
>
> But ACID stays with schema 103, even after killing and restarting mysql and
> snort. Was there magic that I needed to do prior to the update? Do I need a
> later version of snort? Am I missing something painfully obvious? Are all
> Vulcans as snippy as T'Pol? I give up.



---------------------------------------------
This message was sent using Voicenet WebMail.
      http://www.voicenet.com/webmail/



_______________________________________________
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