{"table_name":"ec_location","full_table_name":"wp_ec_location","description":"Stores ec location data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE ec_location ( location_id int(11) NOT NULL AUTO_INCREMENT, location_label varchar(255) DEFAULT '', address_line_1 varchar(255) NOT NULL DEFAULT '', address_line_2 varchar(255) NOT NULL DEFAULT '', city varchar(255) NOT NULL DEFAULT '', state varchar(255) NOT NULL DEFAULT '', country varchar(255) NOT NULL DEFAULT '', zip varchar(255) NOT NULL DEFAULT '', phone varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', latitude decimal(9,6) DEFAULT NULL, longitude decimal(9,6) DEFAULT NULL, PRIMARY KEY (location_id), UNIQUE KEY location_id (location_id) ) $collate;\" );","columns":[{"name":"location_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"location_label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"latitude","type":"decimal(9,6)","nullable":true,"primary_key":false},{"name":"longitude","type":"decimal(9,6)","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"Shopping Cart & eCommerce Store","active_installs":4000,"version":"5.9.1","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}