{"table_name":"classpilot_locations","full_table_name":"wp_classpilot_locations","description":"Stores classpilot locations data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_locations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', address text NOT NULL, description longtext NOT NULL, arrival_instructions text NOT NULL, gallery_image_ids text, active tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (id) ) {$charset};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"address","type":"text","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":false,"primary_key":false},{"name":"arrival_instructions","type":"text","nullable":false,"primary_key":false},{"name":"gallery_image_ids","type":"text","nullable":true,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false}],"plugin":{"slug":"classpilot-booking","name":"ClassPilot Booking","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/classpilot-booking/"}}