function pv_create_competition_tables() {

    global $wpdb;

    require_once ABSPATH . 'wp-admin/includes/upgrade.php';

    // CREATE TABLE ...
    // dbDelta(...)
}

pv_create_competition_tables();