<?php
namespace ABILITY;

if (!defined('ABSPATH')) exit;

/**
 * Database operations for ABILITY plugin.
 */
class DB {
    /**
     * Create database tables.
     */
    public static function create_tables() {
        global $wpdb;
        
        $charset_collate = $wpdb->get_charset_collate();
        $table_name = $wpdb->prefix . 'ability_scans';
        
        $sql = "CREATE TABLE IF NOT EXISTS $table_name (
            id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
            scan_type varchar(50) NOT NULL,
            file_path varchar(500) NOT NULL,
            issue_type varchar(100) NOT NULL,
            severity varchar(20) NOT NULL,
            message text NOT NULL,
            line_number int(11) DEFAULT NULL,
            status varchar(20) DEFAULT 'pending',
            wcag_sc varchar(20) DEFAULT NULL,
            technique varchar(50) DEFAULT NULL,
            standard varchar(50) DEFAULT NULL,
            section508 varchar(50) DEFAULT NULL,
            tool_version varchar(50) DEFAULT NULL,
            ruleset_version varchar(50) DEFAULT NULL,
            created_at datetime DEFAULT CURRENT_TIMESTAMP,
            fixed_at datetime DEFAULT NULL,
            PRIMARY KEY (id),
            KEY scan_type (scan_type),
            KEY status (status),
            KEY created_at (created_at)
        ) $charset_collate;";
        
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($sql);
    }
}