wp_at_activities_attendances

Static

Stores at activities attendances data created by this plugin.

Column Definitions

Column	Type	Nullable
activity_id	bigint(20)	NO
subscription_id	bigint(20)	NO
willAttend	bool	YES
verificationCode	varchar(255)	NO
timestampAnswer	datetime	YES

CREATE TABLE Statement

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

Safe to delete?

If you have uninstalled WP Attend, 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_at_activities_attendances`;

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

Other tables from WP Attend

wp_at_activities wp_at_subscriptions