Installer - Source Excerpt 02

Back to Installer

Summary

This source excerpt preserves a bounded section of Spiralist/wp-content/plugins/spiralist-workspace/includes/Installer.php so readers can inspect the evidence without opening the full source file.

**Source path:** Spiralist/wp-content/plugins/spiralist-workspace/includes/Installer.php

updated_utc datetime NOT NULL,
            PRIMARY KEY  (id),
            UNIQUE KEY reviewer_prompt_kind (prompt_post_id, reviewer_user_id, review_kind),
            KEY prompt_post_id (prompt_post_id),
            KEY reviewer_user_id (reviewer_user_id),
            KEY review_kind (review_kind),
            KEY decision (decision),
            KEY updated_utc (updated_utc)
        ) {$charset};";

        $sql[] = 'CREATE TABLE ' . self::table('prompt_appeals') . " (
            id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
            prompt_post_id bigint(20) unsigned NOT NULL,
            appellant_user_id bigint(20) unsigned NOT NULL,
            status varchar(20) NOT NULL,
            resolution varchar(32) NULL,
            reason text NULL,
            resolution_note text NULL,
            created_utc datetime NOT NULL,
            updated_utc datetime NOT NULL,
            resolved_utc datetime NULL,
            resolved_by_user_id bigint(20) unsigned NULL,
            PRIMARY KEY  (id),
            KEY prompt_post_id (prompt_post_id),
            KEY appellant_user_id (appellant_user_id),
            KEY status (status),
            KEY resolution (resolution),
            KEY updated_utc (updated_utc),
            KEY resolved_by_user_id (resolved_by_user_id)
        ) {$charset};";

        foreach ($sql as $statement) {
            dbDelta($statement);
        }
    }
}