{"slug":"zestatix","name":"zeStatix","description":"zeStatix ​​is counter clicks for the specified HTML elements.","author":"module4u","active_installs":0,"version":"1.2","wp_org_url":"https://wordpress.org/plugins/zestatix/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"zestatix_element","full_table_name":"wp_zestatix_element","description":"Stores zestatix element data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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 );"},{"table_name":"zestatix_event","full_table_name":"wp_zestatix_event","description":"Stores zestatix event data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"zestatix_loaded","full_table_name":"wp_zestatix_loaded","description":"Stores zestatix loaded data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"elem","type":"BIGINT( 20 )","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":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_zestatix_loaded ( elem BIGINT( 20 ) NOT NULL, user INT( 10 ) NOT NULL, url SMALLINT NOT NULL, FOREIGN KEY ( elem ) REFERENCES wp_zestatix_element ( id ) ON DELETE CASCADE ) {$charset_collate}\" );"},{"table_name":"zestatix_location","full_table_name":"wp_zestatix_location","description":"Stores zestatix location data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT( 20 )","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR( 25 )","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_zestatix_location ( id BIGINT( 20 ) NOT NULL, country VARCHAR( 25 ) NOT NULL ) {$charset_collate}\" );"},{"table_name":"zestatix_url","full_table_name":"wp_zestatix_url","description":"Stores zestatix url data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"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","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}],"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}\" );"},{"table_name":"zestatix_user","full_table_name":"wp_zestatix_user","description":"Stores zestatix user data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":7}