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

class Net360_360CH_Database {
    public static function table_name() {
        global $wpdb;
        return $wpdb->prefix . 'n360wp_leads';
    }
    public static function create_table() {
        global $wpdb;
        $table = self::table_name();
        $charset = $wpdb->get_charset_collate();
        $sql = "CREATE TABLE {$table} (
            id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
            name varchar(200) NOT NULL DEFAULT '',
            email varchar(200) NOT NULL DEFAULT '',
            agent varchar(100) NOT NULL DEFAULT '',
            message text NOT NULL,
            page text NOT NULL,
            country varchar(120) NOT NULL DEFAULT '',
            date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
            PRIMARY KEY  (id),
            KEY email (email(100)),
            KEY agent (agent),
            KEY date (date)
        ) {$charset};";
        require_once ABSPATH . 'wp-admin/includes/upgrade.php';
        dbDelta( $sql );
    }
}