{"table_name":"bcog_promotions","full_table_name":"wp_bcog_promotions","description":"Stores bcog promotions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bcog_promotions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'draft', type VARCHAR(50) NOT NULL, priority INT NOT NULL DEFAULT 10, conditions LONGTEXT NOT NULL, rewards LONGTEXT NOT NULL, settings LONGTEXT NOT NULL, starts_at DATETIME NULL DEFAULT NULL, ends_at DATETIME NULL DEFAULT NULL, usage_count BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY status_priority (status, priority), KEY starts_ends (starts_at, ends_at) ) ENGINE","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"priority","type":"INT","nullable":false,"primary_key":false},{"name":"conditions","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"rewards","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"settings","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"starts_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ends_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"usage_count","type":"BIGINT 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},{"name":"created_by","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"byticslab-conditional-offers-for-woocommerce","name":"ByticsLab Conditional Offers for WooCommerce","active_installs":0,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/byticslab-conditional-offers-for-woocommerce/"}}