XF 2.2 I mistakenly deleted the xf_admin_log table

[Firarist]

I accidentally deleted the xf_admin_log table. How can I create it again?

 

[Firarist]

I created it with the following query and it worked...

    CREATE TABLE xf_admin_log (
        admin_log_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
        user_id INT UNSIGNED NOT NULL,
        ip_address VARBINARY(16) NOT NULL DEFAULT '',
        request_date INT UNSIGNED NOT NULL,
        request_url TEXT NOT NULL,
        request_data MEDIUMBLOB NOT NULL,
        PRIMARY KEY (admin_log_id),
        KEY request_date (request_date),
        KEY user_id_request_date (user_id, request_date)
    ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci