{"table_name":"classpilot_packs","full_table_name":"wp_classpilot_packs","description":"Stores classpilot packs data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_packs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', description longtext NOT NULL, credits smallint unsigned NOT NULL DEFAULT 1, price_minor int unsigned NOT NULL DEFAULT 0, currency varchar(3) NOT NULL DEFAULT 'USD', validity_days smallint unsigned NOT NULL DEFAULT 0, status varchar(20) NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status) ) {$charset_collate};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"description","type":"longtext","nullable":false,"primary_key":false},{"name":"credits","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"price_minor","type":"int unsigned","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"validity_days","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_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/"}}