{"table_name":"zestatix_url_tracking","full_table_name":"wp_zestatix_url_tracking","description":"Stores zestatix url tracking data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_zestatix_url_tracking ( id BIGINT( 20 ) NOT NULL, url TEXT NOT NULL, subdir INT( 1 ) NOT NULL, FOREIGN KEY ( id ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}\" );","columns":[{"name":"id","type":"BIGINT( 20 )","nullable":false,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"subdir","type":"INT( 1 )","nullable":false,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":true,"primary_key":false}],"plugin":{"slug":"zestatix","name":"zeStatix","active_installs":0,"version":"1.2","wp_org_url":"https://wordpress.org/plugins/zestatix/"}}