CREATE TABLE NodeHistory
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    node BIGINT NOT NULL,
    Language BIGINT UNSIGNED NOT NULL,
    Zone BIGINT UNSIGNED DEFAULT NULL,
    Website BIGINT UNSIGNED DEFAULT NULL,
    User BIGINT UNSIGNED NOT NULL,
    action ENUM("create", "remove", "update", "view", "execute", "clone") NOT NULL DEFAULT "create",
    Communication VARCHAR(50) NOT NULL,
    ts BIGINT UNSIGNED NOT NULL,
    data MEDIUMBLOB DEFAULT NULL,
    PRIMARY KEY ( id, ts ),
    KEY node ( node )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Track all changes to nodes in the system";
