{"table_name":"foxlms_coupons","full_table_name":"wp_foxlms_coupons","description":"Stores foxlms coupons data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE `wp_foxlms_coupons` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `code` varchar(50) NOT NULL, `discount_type` varchar(20) NOT NULL DEFAULT 'percentage', `discount_amount` decimal(11,2) NOT NULL DEFAULT '0', `usage_limit_total` int(11) NOT NULL DEFAULT '0', `usage_limit_per_user` int(11) DEFAULT NULL, `usage_count` int(11) NOT NULL DEFAULT '0', `applies_to` varchar(1000) DEFAULT NULL, `start_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `discount_type` (`discount_type`), KEY `start_date` (`start_date`), KEY `end_date` (`end_date`), KEY `active_coupons` (`start_date`, `end_date`) ) $charset_collate;\"; $results = $wpdb->get_results( $wpdb->prepare( \"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = %s AND table_name = 'wp_foxlms_coupons' \", DB_NAME ) );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"discount_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"discount_amount","type":"decimal(11,2)","nullable":false,"primary_key":false},{"name":"usage_limit_total","type":"int(11)","nullable":false,"primary_key":false},{"name":"usage_limit_per_user","type":"int(11)","nullable":true,"primary_key":false},{"name":"usage_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"applies_to","type":"varchar(1000)","nullable":true,"primary_key":false},{"name":"start_date","type":"datetime","nullable":true,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"fox-lms","name":"Fox LMS – eLearning & Course Builder","active_installs":80,"version":"1.0.8.7","wp_org_url":"https://wordpress.org/plugins/fox-lms/"}}