wp_address
StaticStores address data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑address_id | smallint(5) unsigned | NO |
| address | varchar(50) | NO |
| address2 | varchar(50) | YES |
| district | varchar(20) | NO |
| city_id | smallint(5) unsigned | NO |
| postal_code | varchar(10) | YES |
| phone | varchar(20) | NO |
| last_update | timestamp | NO |
CREATE TABLE Statement
CREATE TABLE `address` ( `address_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `address` varchar(50) NOT NULL, `address2` varchar(50) DEFAULT NULL, `district` varchar(20) NOT NULL, `city_id` smallint(5) unsigned NOT NULL, `postal_code` varchar(10) DEFAULT NULL, `phone` varchar(20) NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`address_id`), KEY `idx_fk_city_id` (`city_id`), CONSTRAINT `fk_address_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`) ON UPDATE CASCADE ) ENGINE
Safe to delete?
If you have uninstalled Rest Routes – Custom Endpoints for WordPress REST API, 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_address`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Rest Routes – Custom Endpoints for WordPress REST API