{"table_name":"rsvpmaker","full_table_name":"wp_rsvpmaker","description":"Stores rsvpmaker data created by this plugin.","detection_method":"static","confidence":"high","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","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}],"plugin":{"slug":"rsvpmaker","name":"RSVPMaker","active_installs":300,"version":"12.1","wp_org_url":"https://wordpress.org/plugins/rsvpmaker/"}}