{"slug":"event-espresso-decaf","name":"Event Espresso – Event Registration & Ticketing Sales","description":"The best events plugin with event registration, free and paid ticket sales, event registration forms, PayPal payments, automatic emails, and more!","author":"Event Espresso","active_installs":600,"version":"5.0.58.decaf","wp_org_url":"https://wordpress.org/plugins/event-espresso-decaf/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"esp_answer","full_table_name":"wp_esp_answer","description":"Stores esp answer data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_attendee_meta","full_table_name":"wp_esp_attendee_meta","description":"Stores additional metadata (key-value pairs) for esp attendee records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_datetime","full_table_name":"wp_esp_datetime","description":"Stores esp datetime data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_datetime_ticket","full_table_name":"wp_esp_datetime_ticket","description":"Stores esp datetime ticket data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_event_meta","full_table_name":"wp_esp_event_meta","description":"Stores additional metadata (key-value pairs) for esp event records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_event_venue","full_table_name":"wp_esp_event_venue","description":"Stores esp event venue data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_payment","full_table_name":"wp_esp_payment","description":"Stores esp payment data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_price","full_table_name":"wp_esp_price","description":"Stores esp price data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_question","full_table_name":"wp_esp_question","description":"Stores esp question data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_question_group","full_table_name":"wp_esp_question_group","description":"Stores esp question group data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_question_group_question","full_table_name":"wp_esp_question_group_question","description":"Stores esp question group question data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_question_option","full_table_name":"wp_esp_question_option","description":"Stores esp question option data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_registration","full_table_name":"wp_esp_registration","description":"Stores esp registration data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_ticket","full_table_name":"wp_esp_ticket","description":"Stores esp ticket data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_ticket_price","full_table_name":"wp_esp_ticket_price","description":"Stores esp ticket price data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_transaction","full_table_name":"wp_esp_transaction","description":"Stores esp transaction data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"esp_venue_meta","full_table_name":"wp_esp_venue_meta","description":"Stores additional metadata (key-value pairs) for esp venue records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"events_answer","full_table_name":"wp_events_answer","description":"Stores events answer data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_answer` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `registration_id` varchar(23) NOT NULL, * `attendee_id` int(11) NOT NULL DEFAULT '0', * `question_id` int(11) NOT NULL DEFAULT '0', * `answer` text NOT NULL, * PRIMARY KEY (`id`), * KEY `registration_id` (`registration_id`), * KEY `attendee_id` (`attendee_id`) * ) ENGINE"},{"table_name":"events_attendee","full_table_name":"wp_events_attendee","description":"Stores events attendee data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"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') * );"},{"table_name":"events_category_detail","full_table_name":"wp_events_category_detail","description":"Stores events category detail data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"events_category_rel","full_table_name":"wp_events_category_rel","description":"Stores events category rel data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_category_rel` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `event_id` int(11) DEFAULT NULL, * `cat_id` int(11) DEFAULT NULL, * PRIMARY KEY (`id`), * KEY `event_id` (`event_id`) * ) ENGINE"},{"table_name":"events_detail","full_table_name":"wp_events_detail","description":"Stores events detail data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"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"},{"table_name":"events_multi_event_registration_id_group","full_table_name":"wp_events_multi_event_registration_id_group","description":"Stores events multi event registration id group data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"events_prices","full_table_name":"wp_events_prices","description":"Stores events prices data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_prices` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `event_id` int(11) DEFAULT NULL, * `price_type` varchar(50) DEFAULT NULL, * `event_cost` decimal(20,2) NOT NULL DEFAULT '0.00', * `surcharge` decimal(10,2) NOT NULL DEFAULT '0.00', * `surcharge_type` varchar(10) DEFAULT NULL, * `member_price_type` varchar(50) DEFAULT NULL, * `member_price` decimal(20,2) NOT NULL DEFAULT '0.00', * `max_qty` int(7) DEFAULT '0', * `max_qty_members` int(7) DEFAULT '0', * PRIMARY KEY (`id`), * KEY `event_id` (`event_id`) * ) ENGINE"},{"table_name":"events_qst_group","full_table_name":"wp_events_qst_group","description":"Stores events qst group data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_qst_group` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `group_name` varchar(100) NOT NULL DEFAULT 'NULL', * `group_identifier` varchar(45) NOT NULL DEFAULT 'NULL', * `group_description` text, * `group_order` int(11) DEFAULT '0', * `show_group_name` tinyint(1) NOT NULL DEFAULT '1', * `show_group_description` tinyint(1) NOT NULL DEFAULT '1', * `system_group` tinyint(1) NOT NULL DEFAULT '0', * `wp_user` int(22) DEFAULT '1', * PRIMARY KEY (`id`), * KEY `system_group` (`system_group`), * KEY `wp_user` (`wp_user`) * ) ENGINE"},{"table_name":"events_qst_group_rel","full_table_name":"wp_events_qst_group_rel","description":"Stores events qst group rel data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_qst_group_rel` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `group_id` int(11) NOT NULL, * `question_id` int(11) NOT NULL, * PRIMARY KEY (`id`), * KEY `group_id` (`group_id`), * KEY `question_id` (`question_id`) * ) ENGINE"},{"table_name":"events_question","full_table_name":"wp_events_question","description":"Stores events question data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_question` ( * `id` int(11) unsigned NOT NULL AUTO_INCREMENT, * `sequence` int(11) NOT NULL DEFAULT '0', * `question_type` enum('TEXT','TEXTAREA','MULTIPLE','SINGLE','DROPDOWN') NOT NULL DEFAULT 'TEXT', * `question` text NOT NULL, * `system_name` varchar(15) DEFAULT NULL, * `response` text, * `required` enum('Y','N') NOT NULL DEFAULT 'N', * `price_mod` enum('Y','N') NOT NULL DEFAULT 'N', * `required_text` text, * `admin_only` enum('Y','N') NOT NULL DEFAULT 'N', * `wp_user` int(22) DEFAULT '1', * PRIMARY KEY (`id`), * KEY `wp_user` (`wp_user`), * KEY `system_name` (`system_name`), * KEY `admin_only` (`admin_only`) * ) ENGINE"},{"table_name":"events_start_end","full_table_name":"wp_events_start_end","description":"Stores events start end data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_start_end` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `event_id` int(11) DEFAULT NULL, * `start_time` varchar(10) DEFAULT NULL, * `end_time` varchar(10) DEFAULT NULL, * `reg_limit` int(15) DEFAULT '0', * PRIMARY KEY (`id`), * KEY `event_id` (`event_id`) * ) ENGINE"},{"table_name":"events_venue","full_table_name":"wp_events_venue","description":"Stores events venue data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_venue` ( * // `id` int(11) unsigned NOT NULL AUTO_INCREMENT, * // `name` varchar(250) DEFAULT NULL, * // `identifier` varchar(26) DEFAULT '0', * // `address` varchar(250) DEFAULT NULL, * // `address2` varchar(250) DEFAULT NULL, * // `city` varchar(250) DEFAULT NULL, * // `state` varchar(250) DEFAULT NULL, * // `zip` varchar(250) DEFAULT NULL, * // `country` varchar(250) DEFAULT NULL, * // `meta` text, * // `wp_user` int(22) DEFAULT '1', * // PRIMARY KEY (`id`), * // KEY `identifier` (`identifier`), * // KEY `wp_user` (`wp_user`) * //) ENGINE"},{"table_name":"events_venue_rel","full_table_name":"wp_events_venue_rel","description":"Stores events venue rel data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_events_venue_rel` ( * `id` int(11) NOT NULL AUTO_INCREMENT, * `event_id` int(11) DEFAULT NULL, * `venue_id` int(11) DEFAULT NULL, * PRIMARY KEY (`id`), * KEY `event_id` (`event_id`) * ) ENGINE"}],"table_count":30}