RE.N.A.P.A. – Modulo 1 (Tabella Candidati)

<?php

// RE.N.A.P.A. – Modulo 1: Creazione tabella candidati

function renapa_create_table_candidati() {

    global $wpdb;

    $table_name = $wpdb->prefix . "renapa_candidati";

    // Verifica se la tabella esiste

    if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name) {

        return;

    }

    $charset_collate = $wpdb->get_charset_collate();

    $sql = "CREATE TABLE $table_name (

        id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,

        first_name VARCHAR(100) NOT NULL,

        last_name VARCHAR(100) NOT NULL,

        email VARCHAR(191) NOT NULL,

        phone VARCHAR(50) NOT NULL,

        privacy VARCHAR(10) DEFAULT '',

        created_at DATETIME DEFAULT CURRENT_TIMESTAMP,

        PRIMARY KEY (id),

        KEY email (email)

    ) $charset_collate;";

    require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

    dbDelta($sql);

}

add_action('init', 'renapa_create_table_candidati');