get_charset_collate(); $table_name = $wpdb->prefix . 'actionwear_sync_state'; $sql = "CREATE TABLE IF NOT EXISTS $table_name ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, process_key VARCHAR(64) NOT NULL, state_key VARCHAR(64) NOT NULL, state_value LONGTEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY idx_process_state (process_key, state_key) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } } }