wp_clusterlane_snapshots
StaticStores clusterlane snapshots data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| snap_date | DATE | NO |
| taken_at | DATETIME | NO |
| source | VARCHAR(10) | NO |
| metrics_version | SMALLINT UNSIGNED | NO |
| articles | INT UNSIGNED | NO |
| scanned | INT UNSIGNED | NO |
| clusters | INT UNSIGNED | NO |
| health | TINYINT UNSIGNED | NO |
| orphans | INT UNSIGNED | NO |
| avg_inbound | DECIMAL(7,1) | NO |
| links | INT UNSIGNED | NO |
| data | LONGTEXT | NO |
CREATE TABLE Statement
CREATE TABLE wp_clusterlane_snapshots ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, snap_date DATE NOT NULL, taken_at DATETIME NOT NULL, source VARCHAR(10) NOT NULL DEFAULT 'cron', metrics_version SMALLINT UNSIGNED NOT NULL DEFAULT 1, articles INT UNSIGNED NOT NULL DEFAULT 0, scanned INT UNSIGNED NOT NULL DEFAULT 0, clusters INT UNSIGNED NOT NULL DEFAULT 0, health TINYINT UNSIGNED NOT NULL DEFAULT 0, orphans INT UNSIGNED NOT NULL DEFAULT 0, avg_inbound DECIMAL(7,1) NOT NULL DEFAULT 0, links INT UNSIGNED NOT NULL DEFAULT 0, data LONGTEXT NOT NULL, PRIMARY KEY (id) ) $charset; " );
Safe to delete?
If you have uninstalled Clusterlane, 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_clusterlane_snapshots`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Clusterlane