{"table_name":"clusterlane_snapshots","full_table_name":"wp_clusterlane_snapshots","description":"Stores clusterlane snapshots data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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; \" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"snap_date","type":"DATE","nullable":false,"primary_key":false},{"name":"taken_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"metrics_version","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"articles","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"scanned","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"clusters","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"health","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"orphans","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"avg_inbound","type":"DECIMAL(7,1)","nullable":false,"primary_key":false},{"name":"links","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"data","type":"LONGTEXT","nullable":false,"primary_key":false}],"plugin":{"slug":"clusterlane","name":"Clusterlane","active_installs":0,"version":"1.3.2","wp_org_url":"https://wordpress.org/plugins/clusterlane/"}}