{"table_name":"classpilot_customers","full_table_name":"wp_classpilot_customers","description":"Stores classpilot customers data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_customers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, wp_user_id bigint(20) unsigned DEFAULT NULL, display_name varchar(200) NOT NULL DEFAULT '', email varchar(200) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY wp_user_id (wp_user_id), KEY email (email) ) {$charset_collate};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"wp_user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"display_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","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/"}}