🗄️What WP Table Is This?
Home / Event Espresso – Event Registration & Ticketing Sales / wp_events_attendee

wp_events_attendee

Static

Stores events attendee data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_events_attendee` ( * `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, * `registration_id` VARCHAR(23) NULL DEFAULT '0', * `is_primary` TINYINT(1) NULL DEFAULT '0', * `lname` VARCHAR(45) NULL DEFAULT NULL, * `fname` VARCHAR(45) NULL DEFAULT NULL, * `address` VARCHAR(255) NULL DEFAULT NULL, * `address2` VARCHAR(255) NULL DEFAULT NULL, * `city` VARCHAR(45) NULL DEFAULT NULL, * `state` VARCHAR(45) NULL DEFAULT NULL, * `zip` VARCHAR(45) NULL DEFAULT NULL, * `country_id` VARCHAR(128) NULL DEFAULT NULL, * `organization_name` VARCHAR(50) NULL DEFAULT NULL, * `vat_number` VARCHAR(20) NULL DEFAULT NULL, * `email` VARCHAR(255) NULL DEFAULT NULL, * `phone` VARCHAR(45) NULL DEFAULT NULL, * `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, * `price_option` VARCHAR(150) NULL DEFAULT NULL, * `orig_price` DECIMAL(20,2) NULL DEFAULT '0.00', * `final_price` DECIMAL(20,2) NULL DEFAULT '0.00', * `quantity` INT(11) NULL DEFAULT '0', * `total_cost` DECIMAL(20,2) NULL DEFAULT '0.00', * `amount_pd` DECIMAL(20,2) NULL DEFAULT '0.00', * `coupon_code` VARCHAR(45) NULL DEFAULT NULL, * `payment` VARCHAR(45) NULL DEFAULT NULL, * `payment_status` VARCHAR(45) NULL DEFAULT 'Incomplete', * `txn_type` VARCHAR(45) NULL DEFAULT NULL, * `txn_id` VARCHAR(250) NULL DEFAULT NULL, * `payment_date` VARCHAR(45) NULL DEFAULT NULL, * `event_id` VARCHAR(45) NULL DEFAULT NULL, * `event_time` VARCHAR(15) NULL DEFAULT NULL, * `end_time` VARCHAR(15) NULL DEFAULT NULL, * `start_date` VARCHAR(45) NULL DEFAULT NULL, * `end_date` VARCHAR(45) NULL DEFAULT NULL, * `attendee_session` VARCHAR(250) NULL DEFAULT NULL, * `transaction_details` TEXT NULL, * `pre_approve` INT(11) NULL DEFAULT '1', * `checked_in` INT(1) NULL DEFAULT '0', * `checked_in_quantity` INT(11) NULL DEFAULT '0', * `hashSalt` VARCHAR(250) NULL DEFAULT NULL, * PRIMARY KEY (`id`), * INDEX `registration_id` (`registration_id`), * INDEX `event_id` (`event_id`) * ) * COLLATE='utf8_general_ci' * ENGINE=InnoDB * AUTO_INCREMENT=3 * ; * 4.1 Attendee tables and fields: * $this->_tables = array( * 'Attendee_CPT'=> new EE_Primary_Table('posts', 'ID'), * 'Attendee_Meta'=>new EE_Secondary_Table('esp_attendee_meta', 'ATTM_ID', 'ATT_ID') * );

Safe to delete?

If you have uninstalled Event Espresso – Event Registration & Ticketing Sales, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_events_attendee`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Event Espresso – Event Registration & Ticketing Sales