wp_fpm_todos

Static

Stores fpm todos data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑IDint(11) unsignedNO
todotextYES
is_completetinyint(1)NO
listIDint(11) unsignedYES
userIDint(11) unsignedYES
user_namevarchar(100)YES
assignee_namevarchar(100)YES
assigneeIDint(11) unsignedYES
projectIDint(11) unsignedYES
file_idslongtextYES
due_datedatetimeYES
createddatetimeYES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS `wp_fpm_todos` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `todo` text, `is_complete` tinyint(1) NOT NULL DEFAULT '0', `listID` int(11) unsigned, `userID` int(11) unsigned, `user_name` varchar(100), `assignee_name` varchar(100), `assigneeID` int(11) unsigned, `projectID` int(11) unsigned, `file_ids` longtext, `due_date` datetime, `created` datetime, PRIMARY KEY (`ID`) ) ENGINE

Safe to delete?

If you have uninstalled Awesome Project Manager, 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_fpm_todos`;

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

Other tables from Awesome Project Manager