IF NOT EXISTS ;) 

Just drop the table and run it again or better yet, this:

mysql> ALTER TABLE autocat ADD comment VARCHAR(255) AFTER uid;



On Tue, Jun 10, 2014 at 7:56 PM, James Lay <jlay@slave-tothe-box.net> wrote:
On 2014-06-10 16:45, Paul Halliday wrote:
> Should be 14 entries there; comment is missing. See:
>
>
> https://github.com/bammv/sguil/blob/master/server/sql_scripts/update_sguildb_v13-v14.sql
> [5]
>

Thanks Paul.  Well shoot..here's what I got:

mysql -u root -p -D sguildb <
sguil9/sguil-0.9.0/server/sql_scripts/update_sguildb_v13-v14.sql


cat sguil9/sguil-0.9.0/server/sql_scripts/update_sguildb_v13-v14.sql
CREATE TABLE IF NOT EXISTS `autocat`
(
   autoid        INT UNSIGNED            NOT NULL AUTO_INCREMENT,
   erase         DATETIME,
   sensorname    VARCHAR(255),
   src_ip        VARCHAR(18),
   src_port      INT UNSIGNED,
   dst_ip        VARCHAR(18),
   dst_port      INT UNSIGNED,
   ip_proto      TINYINT UNSIGNED,
   signature     VARCHAR(255),
   status        SMALLINT UNSIGNED       NOT NULL,
   active        ENUM('Y','N') DEFAULT 'Y',
   timestamp     DATETIME NOT NULL,
   uid           INT UNSIGNED    NOT NULL,
   comment       VARCHAR(255),
   PRIMARY KEY (autoid)
) ENGINE = MYISAM;

UPDATE version SET version="0.14", installed = now();

Still seem to be missing the comment field.  Is there a way I can just
manually add that in?

mysql> DESC autocat;
+------------+----------------------+------+-----+---------+----------------+
| Field      | Type                 | Null | Key | Default | Extra
    |
+------------+----------------------+------+-----+---------+----------------+
| autoid     | int(10) unsigned     | NO   | PRI | NULL    |
auto_increment |
| erase      | datetime             | YES  |     | NULL    |
    |
| sensorname | varchar(255)         | YES  |     | NULL    |
    |
| src_ip     | varchar(18)          | YES  |     | NULL    |
    |
| src_port   | int(10) unsigned     | YES  |     | NULL    |
    |
| dst_ip     | varchar(18)          | YES  |     | NULL    |
    |
| dst_port   | int(10) unsigned     | YES  |     | NULL    |
    |
| ip_proto   | tinyint(3) unsigned  | YES  |     | NULL    |
    |
| signature  | varchar(255)         | YES  |     | NULL    |
    |
| status     | smallint(5) unsigned | NO   |     | NULL    |
    |
| active     | enum('Y','N')        | YES  |     | Y       |
    |
| timestamp  | datetime             | NO   |     | NULL    |
    |
| uid        | int(10) unsigned     | NO   |     | NULL    |
    |
+------------+----------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)


Am I missing something with executing the script?  Thanks again.

James


------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
Sguil-users mailing list
Sguil-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sguil-users



--
Paul Halliday
http://www.pintumbler.org/