get_charset_collate(); // Main activity log table $table_name = $wpdb->prefix . 'actlogpro_activity_log_pro_all_logs'; $sql = "CREATE TABLE $table_name ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, user_role varchar(100) NOT NULL, user_login varchar(60) NOT NULL, user_display_name varchar(250) NOT NULL, ip_address varchar(45) NOT NULL, event_type varchar(100) NOT NULL, object_type varchar(100) NOT NULL, object_id bigint(20) NOT NULL, object_name varchar(250) NOT NULL, action varchar(100) NOT NULL, description text NOT NULL, created_at datetime NOT NULL, metadata longtext, PRIMARY KEY (id) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); // Set version in options add_option('actlogpro_db_version', ACTLOGPRO_VERSION); // Set activation notice flag - this will show on every activation update_option('actlogpro_show_activation_notice', true); } }