{"slug":"wp-attend","name":"WP Attend","description":"This plugin allows easy creation of events and registration of attendances via email.","author":"bitsandarts","active_installs":10,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/wp-attend/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"at_activities","full_table_name":"wp_at_activities","description":"Stores at activities data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"description","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"location","type":"text","nullable":false,"primary_key":false},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"withAttendance","type":"bool","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_at_activities( id bigint(20) NOT NULL AUTO_INCREMENT, description varchar(255) NOT NULL, location text NOT NULL, timestamp datetime NOT NULL, withAttendance bool NOT NULL, UNIQUE KEY id (id))ENGINE"},{"table_name":"at_activities_attendances","full_table_name":"wp_at_activities_attendances","description":"Stores at activities attendances data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"activity_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"subscription_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"willAttend","type":"bool","nullable":true,"primary_key":false},{"name":"verificationCode","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"timestampAnswer","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_at_activities_attendances( activity_id bigint(20) NOT NULL, subscription_id bigint(20) NOT NULL, willAttend bool, verificationCode varchar(255) NOT NULL, timestampAnswer datetime, UNIQUE KEY (activity_id, subscription_id), CONSTRAINT activity_fk FOREIGN KEY (activity_id) REFERENCES wp_at_activities(id) ON DELETE CASCADE, CONSTRAINT subscription_fk FOREIGN KEY (subscription_id) REFERENCES wp_at_subscriptions(id) ON DELETE CASCADE)ENGINE"},{"table_name":"at_subscriptions","full_table_name":"wp_at_subscriptions","description":"Stores at subscriptions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"validatedTimestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"isValid","type":"bool","nullable":true,"primary_key":false},{"name":"verificationCode","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_at_subscriptions( id bigint(20) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, email varchar(255) NOT NULL, timestamp datetime NOT NULL, validatedTimestamp datetime NOT NULL, isValid bool, verificationCode varchar(255) NOT NULL, UNIQUE KEY id (id))ENGINE"}],"table_count":3}