<?php
if ( ! defined( 'ABSPATH' ) ) exit;

class PXSYNC_Installer {

    /**
     * Database Table Setup
     * Never forget comments: Using dbDelta ensures we don't drop data if the 
     * table exists, but adds any missing columns.
     */
    public static function activate() {
        global $wpdb;
        $table_name = $wpdb->prefix . 'pxsync_logs';
        $charset_collate = $wpdb->get_charset_collate();

        $sql = "CREATE TABLE $table_name (
            id bigint(20) NOT NULL AUTO_INCREMENT,
            event_id varchar(100) NOT NULL,
            event_name varchar(50) NOT NULL,
            source varchar(50) NOT NULL,
            source_platform varchar(50) DEFAULT '' NOT NULL,
            status varchar(100) NOT NULL,
            details text NOT NULL,
            created_at datetime DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY  (id),
            KEY event_id (event_id)
        ) $charset_collate;";
        
        require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
        dbDelta( $sql );
        
        // Add a version flag to options so we know it's installed
        update_option( 'pxsync_db_version', '1.0.1' );
    }
}