{"table_name":"ec_offer_code","full_table_name":"wp_ec_offer_code","description":"Stores ec offer code data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_offer_code ( offer_code_id int(11) NOT NULL AUTO_INCREMENT, offer_id int(11) NOT NULL DEFAULT '0', code varchar($max_index_length) NOT NULL DEFAULT '', max_redemptions int(11) NOT NULL DEFAULT '0', times_redeemed int(11) NOT NULL DEFAULT '0', assigned_email varchar(255) NOT NULL DEFAULT '', is_active tinyint(1) NOT NULL DEFAULT '1', created_date timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (offer_code_id), UNIQUE KEY offer_code_code (code), KEY offer_code_offer_id (offer_id) ) $collate;\" );","columns":[{"name":"offer_code_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"offer_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"code","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"max_redemptions","type":"int(11)","nullable":false,"primary_key":false},{"name":"times_redeemed","type":"int(11)","nullable":false,"primary_key":false},{"name":"assigned_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_date","type":"timestamp","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}