{"table_name":"classpilot_classes","full_table_name":"wp_classpilot_classes","description":"Stores classpilot classes data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_classes ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title varchar(200) NOT NULL DEFAULT '', description longtext NOT NULL, schedule_type varchar(20) NOT NULL DEFAULT 'recurring', booking_mode varchar(20) NOT NULL DEFAULT 'drop-in', drop_in_price_minor int unsigned NOT NULL DEFAULT 0, drop_in_currency varchar(3) NOT NULL DEFAULT 'USD', duration_minutes smallint unsigned NOT NULL DEFAULT 60, default_capacity smallint unsigned NOT NULL DEFAULT 10, location_id bigint(20) unsigned NOT NULL DEFAULT 0, instructor_id bigint(20) unsigned NOT NULL DEFAULT 0, policy_id bigint(20) unsigned NOT NULL DEFAULT 0, gallery_image_ids text, published tinyint(1) NOT NULL DEFAULT 0, archived tinyint(1) NOT NULL DEFAULT 0, booking_open_hours_before smallint unsigned NOT NULL DEFAULT 0, booking_close_hours_before smallint unsigned NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY published_archived (published, archived) ) {$charset};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":false,"primary_key":false},{"name":"schedule_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"booking_mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"drop_in_price_minor","type":"int unsigned","nullable":false,"primary_key":false},{"name":"drop_in_currency","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"duration_minutes","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"default_capacity","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"location_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"instructor_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"policy_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"gallery_image_ids","type":"text","nullable":true,"primary_key":false},{"name":"published","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"archived","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"booking_open_hours_before","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"booking_close_hours_before","type":"smallint unsigned","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/"}}