-- Add log table.
CREATE TABLE IF NOT EXISTS `#__kunena_logs` (
  `id`          int(11)     NOT NULL AUTO_INCREMENT,
  `type`        tinyint(4)  NOT NULL DEFAULT '0',
  `user_id`     int(11)     NOT NULL DEFAULT '0',
  `category_id` int(11)     NOT NULL DEFAULT '0',
  `topic_id`    int(11)     NOT NULL DEFAULT '0',
  `target_user` int(11)     NOT NULL DEFAULT '0',
  `ip`          varchar(40) NOT NULL DEFAULT '',
  `time`        int(11)     NOT NULL DEFAULT '0',
  `operation`   varchar(40) NOT NULL,
  `data`        mediumtext  NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `category_id` (`category_id`),
  KEY `topic_id` (`topic_id`),
  KEY `target_user` (`target_user`),
  KEY `user_id` (`user_id`)
)
  DEFAULT CHARACTER SET utf8;