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

wp_events_detail

Static

Stores events detail data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_events_detail` ( * `id` int(11) unsigned NOT NULL AUTO_INCREMENT, * `event_code` varchar(26) DEFAULT '0', * `event_name` varchar(100) DEFAULT NULL, * `event_desc` text, * `display_desc` varchar(1) DEFAULT 'Y', * `display_reg_form` varchar(1) DEFAULT 'Y', * `event_identifier` varchar(75) DEFAULT NULL, * `start_date` varchar(15) DEFAULT NULL, * `end_date` varchar(15) DEFAULT NULL, * `registration_start` varchar(15) DEFAULT NULL, * `registration_end` varchar(15) DEFAULT NULL, * `registration_startT` varchar(15) DEFAULT NULL, * `registration_endT` varchar(15) DEFAULT NULL, * `visible_on` varchar(15) DEFAULT NULL, * `address` text, * `address2` text, * `city` varchar(100) DEFAULT NULL, * `state` varchar(100) DEFAULT NULL, * `zip` varchar(11) DEFAULT NULL, * `phone` varchar(15) DEFAULT NULL, * `venue_title` varchar(250) DEFAULT NULL, * `venue_url` varchar(250) DEFAULT NULL, * `venue_image` text, * `venue_phone` varchar(15) DEFAULT NULL, * `virtual_url` varchar(250) DEFAULT NULL, * `virtual_phone` varchar(15) DEFAULT NULL, * `reg_limit` varchar(25) DEFAULT '999999', * `allow_multiple` varchar(15) DEFAULT 'N', * `additional_limit` int(10) DEFAULT '5', * `send_mail` varchar(2) DEFAULT 'Y', * `is_active` varchar(1) DEFAULT 'Y', * `event_status` varchar(2) DEFAULT 'A', * `conf_mail` text, * `use_coupon_code` varchar(1) DEFAULT 'N', * `use_groupon_code` varchar(1) DEFAULT 'N', * `category_id` text, * `coupon_id` text, * `tax_percentage` float DEFAULT NULL, * `tax_mode` int(11) DEFAULT NULL, * `member_only` varchar(1) DEFAULT NULL, * `post_id` int(11) DEFAULT NULL, * `post_type` varchar(50) DEFAULT NULL, * `country` varchar(200) DEFAULT NULL, * `externalURL` varchar(255) DEFAULT NULL, * `early_disc` varchar(10) DEFAULT NULL, * `early_disc_date` varchar(15) DEFAULT NULL, * `early_disc_percentage` varchar(1) DEFAULT 'N', * `question_groups` longtext, * `item_groups` longtext, * `event_type` varchar(250) DEFAULT NULL, * `allow_overflow` varchar(1) DEFAULT 'N', * `overflow_event_id` int(10) DEFAULT '0', * `recurrence_id` int(11) DEFAULT '0', * `email_id` int(11) DEFAULT '0', * `alt_email` text, * `event_meta` longtext, * `wp_user` int(22) DEFAULT '1', * `require_pre_approval` int(11) DEFAULT '0', * `timezone_string` varchar(250) DEFAULT NULL, * `likes` int(22) DEFAULT NULL, * `ticket_id` int(22) DEFAULT '0', * `submitted` datetime NOT NULL, * PRIMARY KEY (`id`), * KEY `event_code` (`event_code`), * KEY `wp_user` (`wp_user`), * KEY `event_name` (`event_name`), * KEY `city` (`city`), * KEY `state` (`state`), * KEY `start_date` (`start_date`), * KEY `end_date` (`end_date`), * KEY `registration_start` (`registration_start`), * KEY `registration_end` (`registration_end`), * KEY `reg_limit` (`reg_limit`), * KEY `event_status` (`event_status`), * KEY `recurrence_id` (`recurrence_id`), * KEY `submitted` (`submitted`), * KEY `likes` (`likes`) * ) ENGINE

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_detail`;

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

Other tables from Event Espresso – Event Registration & Ticketing Sales