wp_ddwppwa_subscribers
StaticStores ddwppwa subscribers data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| client_id | varchar(64) | NO |
| token | text | YES |
| token_hash | char(32) | NO |
| user_id | bigint(20) | NO |
| status | varchar(20) | NO |
| platform | varchar(60) | NO |
| browser | varchar(40) | NO |
| device_type | varchar(20) | NO |
| installed | tinyint(1) | NO |
| welcomed | tinyint(1) | NO |
| subscribed_at | datetime | YES |
| installed_at | datetime | YES |
| last_seen | datetime | YES |
| cart_updated_at | datetime | YES |
| cart_notified_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_ddwppwa_subscribers ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `client_id` varchar(64) NOT NULL DEFAULT '', `token` text NULL, `token_hash` char(32) NOT NULL DEFAULT '', `user_id` bigint(20) NOT NULL DEFAULT 0, `status` varchar(20) NOT NULL DEFAULT 'subscribed', `platform` varchar(60) NOT NULL DEFAULT '', `browser` varchar(40) NOT NULL DEFAULT '', `device_type` varchar(20) NOT NULL DEFAULT '', `installed` tinyint(1) NOT NULL DEFAULT 0, `welcomed` tinyint(1) NOT NULL DEFAULT 0, `subscribed_at` datetime DEFAULT NULL, `installed_at` datetime DEFAULT NULL, `last_seen` datetime DEFAULT NULL, `cart_updated_at` datetime DEFAULT NULL, `cart_notified_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY client_id (client_id), KEY token_hash (token_hash), KEY user_id (user_id), KEY status (status), KEY last_seen (last_seen) ) $charset_collate;"; dbDelta( $subscribers_table );
Safe to delete?
If you have uninstalled Progressive Web App – PWA, Web Push Notifications and Offline Mode, 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_ddwppwa_subscribers`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Progressive Web App – PWA, Web Push Notifications and Offline Mode