sol

CREATE TABLE host (
        host_id INT             UNSIGNED NOT NULL AUTO_INCREMENT,
        ipaddress       INT(10) UNSIGNED NOT NULL DEFAULT '0',
        host_name       VARCHAR(64)     NOT NULL DEFAULT '',
        mac             VARCHAR(17)     NOT NULL DEFAULT '',
        location        VARCHAR(255)    NOT NULL DEFAULT '',
        os              VARCHAR(64)     NOT NULL DEFAULT '',
        os_version      VARCHAR(64)     NOT NULL DEFAULT '',
        local           ENUM('remote','local','unknown') DEFAULT 'unknown',
        cc              CHAR(2)         NOT NULL DEFAULT '',
        need_notify     BOOL            NOT NULL DEFAULT 'false',
        state           ENUM('active','down','unknown') DEFAULT 'unknown',
        timestamp       DATETIME        NOT NULL DEFAULT '0000-00-00 00:00:00',
        PRIMARY KEY(host_id),
        KEY host_ipaddress_idx(ipaddress)
);

ERROR 1067 (42000) at line 39 in file: 'neteye.sql': Invalid default value for 'need_notify'