'aieo_dmm_offer_findings', ); } function aieo_dmm_create_offer_findings_table() { global $wpdb; $table = $wpdb->prefix . 'aieo_dmm_offer_findings'; $sql = "CREATE TABLE IF NOT EXISTS {$table} ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `offer_id` bigint(20) unsigned NOT NULL DEFAULT 0, `signal_name` varchar(32) NOT NULL, `day` date NOT NULL, `severity` varchar(12) NOT NULL DEFAULT 'warning', `figures` longtext DEFAULT NULL, `state` varchar(12) NOT NULL DEFAULT 'open', `told` varchar(64) NOT NULL DEFAULT '', `created_gmt` datetime NOT NULL, `updated_gmt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `aieo_dmm_uq_finding` (`offer_id`, `signal_name`, `day`), KEY `aieo_dmm_idx_finding_state` (`state`, `day`), KEY `aieo_dmm_idx_finding_day` (`day`) ) " . aieo_get_charset_collate() . ';'; return false !== $wpdb->query( $sql ); } }