<?php
/**
 * Database handler for 404 Scout module.
 */

class AILM_Scout_DB {

    public static function get_table_name() {
        global $wpdb;
        return $wpdb->prefix . 'ailm_link_monitor';
    }

    public static function create_table() {
        global $wpdb;
        $table_name = self::get_table_name();
        $charset_collate = $wpdb->get_charset_collate();

        $sql = "CREATE TABLE $table_name (
            id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
            post_id bigint(20) unsigned NOT NULL,
            url varchar(2048) NOT NULL,
            anchor text,
            link_origin varchar(20) DEFAULT 'manual' NOT NULL,
            link_type varchar(20) DEFAULT 'internal' NOT NULL,
            status_code int(5) NOT NULL DEFAULT 0,
            last_checked datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
            PRIMARY KEY  (id),
            KEY post_id (post_id),
            KEY status_code (status_code),
            KEY analytics_idx (post_id, link_type, status_code)
        ) $charset_collate;";

        require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
        dbDelta( $sql );
    }

    public static function truncate_table() {
        global $wpdb;
        $table_name = self::get_table_name();
        $wpdb->query( "TRUNCATE TABLE " . esc_sql( $table_name ) );
    }
}