{"slug":"rsvpmaker","name":"RSVPMaker","description":"Event and email marketing. Register guests and collect payment by PayPal or Stripe. Send invitations and newsletters.","author":"davidfcarr","active_installs":300,"version":"12.1","wp_org_url":"https://wordpress.org/plugins/rsvpmaker/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"mailpoet_subscribers","full_table_name":"wp_mailpoet_subscribers","description":"Stores mailpoet subscribers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"rsvp_volunteer_time","full_table_name":"wp_rsvp_volunteer_time","description":"Stores rsvp volunteer time data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"event","type":"int","nullable":false,"primary_key":false},{"name":"rsvp","type":"int","nullable":false,"primary_key":false},{"name":"time","type":"int","nullable":true,"primary_key":false},{"name":"user_id","type":"int","nullable":true,"primary_key":false},{"name":"participants","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_rsvp_volunteer_time` ( `id` int NOT NULL auto_increment, `event` int NOT NULL default '0', `rsvp` int NOT NULL default '0', `time` int default '0', `user_id` int default '0', `participants` int NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"rsvpmailer_blocked","full_table_name":"wp_rsvpmailer_blocked","description":"Stores rsvpmailer blocked data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"timestamp","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_rsvpmailer_blocked` ( `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(100) NOT NULL DEFAULT '', `code` varchar(50) NOT NULL DEFAULT '', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`), KEY `email` (`email`) ) ENGINE"},{"table_name":"rsvpmaker","full_table_name":"wp_rsvpmaker","description":"Stores rsvpmaker data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int","nullable":false,"primary_key":true},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"yesno","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"first","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"details","type":"text","nullable":false,"primary_key":false},{"name":"event","type":"int","nullable":false,"primary_key":false},{"name":"owed","type":"float(6,2)","nullable":false,"primary_key":false},{"name":"amountpaid","type":"float(6,2)","nullable":false,"primary_key":false},{"name":"fee_total","type":"float(6,2)","nullable":false,"primary_key":false},{"name":"master_rsvp","type":"int","nullable":false,"primary_key":false},{"name":"guestof","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"note","type":"text","nullable":false,"primary_key":false},{"name":"participants","type":"INT","nullable":false,"primary_key":false},{"name":"user_id","type":"INT","nullable":false,"primary_key":false},{"name":"form_id","type":"INT","nullable":false,"primary_key":false},{"name":"timestamp","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_rsvpmaker` ( `id` int NOT NULL auto_increment, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL, `yesno` tinyint(4) NOT NULL default '0', `first` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '', `last` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '', `details` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `event` int NOT NULL default '0', `owed` float(6,2) NOT NULL default '0.00', `amountpaid` float(6,2) NOT NULL default '0.00', `fee_total` float(6,2) NOT NULL default '0.00', `master_rsvp` int NOT NULL default '0', `guestof` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL, `note` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `participants` INT NOT NULL DEFAULT '0', `user_id` INT NOT NULL DEFAULT '0', `form_id` INT NOT NULL DEFAULT '0', `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"rsvpmaker_event","full_table_name":"wp_rsvpmaker_event","description":"Stores rsvpmaker event data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"event","type":"int","nullable":false,"primary_key":false},{"name":"post_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"display_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"date","type":"datetime","nullable":true,"primary_key":false},{"name":"enddate","type":"datetime","nullable":true,"primary_key":false},{"name":"ts_start","type":"int","nullable":false,"primary_key":false},{"name":"ts_end","type":"int","nullable":false,"primary_key":false},{"name":"timezone","type":"varchar(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_rsvpmaker_event` ( `event` int NOT NULL default '0', `post_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL, `display_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL, `date` datetime, `enddate` datetime, `ts_start` int NOT NULL default '0', `ts_end` int NOT NULL default '0', `timezone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci default NULL, PRIMARY KEY (`event`) ) ENGINE"},{"table_name":"rsvpmaker_guest_email","full_table_name":"wp_rsvpmaker_guest_email","description":"Stores rsvpmaker guest email data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"rsvpmaker_money","full_table_name":"wp_rsvpmaker_money","description":"Stores rsvpmaker money data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":7}