{"table_name":"zestatix_element","full_table_name":"wp_zestatix_element","description":"Stores zestatix element data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_zestatix_element ( id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, selector VARCHAR( 255 ) NOT NULL UNIQUE, browser_width VARCHAR( 100 ) NOT NULL, created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, tracked INT( 1 ) NOT NULL ) {$charset_collate}\"; $create_tables[] = \"CREATE TABLE IF NOT EXISTS wp_zestatix_event ( selector_id INT( 10 ) NOT NULL, user_id INT( 10 ) NOT NULL, url_id SMALLINT NOT NULL, device VARCHAR( 6 ) NOT NULL, width VARCHAR( 15 ) NOT NULL, event TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY ( selector_id ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}\"; $create_tables[] = \"CREATE TABLE IF NOT EXISTS wp_zestatix_url ( id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, url TEXT NOT NULL ) {$charset_collate}\"; $create_tables[] = \"CREATE TABLE IF NOT EXISTS wp_zestatix_loaded ( elem INT( 10 ) NOT NULL, user INT( 10 ) NOT NULL, url SMALLINT NOT NULL, FOREIGN KEY ( elem ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}\"; $create_tables[] = \"CREATE TABLE IF NOT EXISTS wp_zestatix_user ( id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY, ip VARCHAR( 40 ) NOT NULL, location VARCHAR( 50 ) NULL, login VARCHAR( 50 ) NULL, INDEX( ip ), INDEX( login ) ) {$charset_collate}\"; $create_tables[] = \"CREATE TABLE IF NOT EXISTS wp_zestatix_url_tracking ( id INT( 10 ) NOT NULL, url TEXT NOT NULL, subdir INT( 1 ) NOT NULL, FOREIGN KEY ( id ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}\"; foreach ( $create_tables as $table ) { $wpdb->query( $table );","columns":[{"name":"id","type":"INT( 10 )","nullable":false,"primary_key":true},{"name":"selector","type":"VARCHAR( 255 )","nullable":false,"primary_key":false},{"name":"browser_width","type":"VARCHAR( 100 )","nullable":false,"primary_key":false},{"name":"created","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"tracked","type":"INT( 1 )","nullable":false,"primary_key":false},{"name":"user_id","type":"INT( 10 )","nullable":false,"primary_key":false},{"name":"url_id","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR( 6 )","nullable":false,"primary_key":false},{"name":"width","type":"VARCHAR( 15 )","nullable":false,"primary_key":false},{"name":"event","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":false,"primary_key":true},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"user","type":"INT( 10 )","nullable":false,"primary_key":false},{"name":"url","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":false,"primary_key":true},{"name":"ip","type":"VARCHAR( 40 )","nullable":false,"primary_key":false},{"name":"location","type":"VARCHAR( 50 )","nullable":true,"primary_key":false},{"name":"login","type":"VARCHAR( 50 )","nullable":true,"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/"}}