{"table_name":"contenttrace_duplicates","full_table_name":"wp_contenttrace_duplicates","description":"Stores contenttrace duplicates data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_contenttrace_duplicates ( id bigint(20) NOT NULL AUTO_INCREMENT, post_id bigint(20) NOT NULL, source_url varchar(500) NOT NULL, score decimal(5,2) NOT NULL, found_at datetime DEFAULT CURRENT_TIMESTAMP, notified tinyint(1) DEFAULT 0, notified_email varchar(255) DEFAULT NULL, notified_at datetime DEFAULT NULL, status varchar(50) DEFAULT 'new', created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id), KEY score (score), KEY status (status) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"post_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"source_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"score","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"found_at","type":"datetime","nullable":true,"primary_key":false},{"name":"notified","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"notified_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"notified_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"contenttrace","name":"ContentTrace","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/contenttrace/"}}