{"table_name":"classpilot_pack_credits","full_table_name":"wp_classpilot_pack_credits","description":"Stores classpilot pack credits data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_pack_credits ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, customer_id bigint(20) unsigned NOT NULL, pack_id bigint(20) unsigned NOT NULL, credits_total smallint unsigned NOT NULL DEFAULT 0, credits_remaining smallint unsigned NOT NULL DEFAULT 0, stripe_session_id varchar(200) NOT NULL DEFAULT '', purchased_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, expires_at datetime NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY customer_pack (customer_id, pack_id), KEY stripe_session_id (stripe_session_id), KEY expires_at (expires_at) ) {$charset};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"customer_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"pack_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"credits_total","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"credits_remaining","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"stripe_session_id","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"purchased_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","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/"}}