Богдан Герасименко

/* Start: Register Post Type (Universities Pages) */
function custom_post_type_universities_pages() {
    $labels = array(
        'name'               => _x('Universities Pages', 'post type general name', 'your-text-domain'),
        'singular_name'      => _x('Universities Page', 'post type singular name', 'your-text-domain'),
        // Добавьте другие метки по вашему усмотрению
    );

    $args = array(
        'labels'              => $labels,
        'public'              => true,
        'supports'            => array('title','editor','author','comments'), // Включение поддержки комментариев
    );
    
    register_post_type('universities_page', $args);
}

add_action('init', 'custom_post_type_universities_pages');

/* Start: Rewrite URL's */
function custom_rewrite_rule() {
    add_rewrite_rule('^([^/]+)/([^/]+)/([^/]+)/?$', 'index.php?pagename=university&country=$matches[1]&city=$matches[2]&university_slug=$matches[3]', 'top');
}
add_action('init', 'custom_rewrite_rule');

function custom_rewrite_tag() {
    add_rewrite_tag('%country%', '([^&]+)');
    add_rewrite_tag('%city%', '([^&]+)');
    add_rewrite_tag('%university_slug%', '([^&]+)');
}
add_action('init', 'custom_rewrite_tag');

<a href="<?php echo home_url('/' . $university_data->country . '/' . $university_data->city . '/' . $university_data->slug); ?>" class="text-size-medium text-weight-bold"><?php echo esc_html($university_data->name); ?></a>

CREATE TABLE client ( clientid INT AUTO_INCREMENT PRIMARY KEY,
                      firstname VARCHAR(255),
                      lastname VARCHAR(255),
                      phone BIGINT,                           -- если исходный VARCHAR - поменять, 
                                                              -- либо соотв. преобразование в INSERT
                      UNIQUE (firstname, lastname, phone) );  -- можно потом удалить

INSERT INTO client (firstname, lastname, phone)
    SELECT DISTINCT firstname, lastname, phone
    FROM orders_old;

CREATE TABLE order ( orderid INT AUTO_INCREMENT PRIMARY KEY,
                     ordernumber INT,
                     clientid INT,
                     FOREIGN KEY (clientid) REFERENCES client (clientid) );

INSERT INTO order (ordernumber, clientid)
    SELECT orders_old.ordernumber, client.clientid
    FROM orders_old
    JOIN client USING (firstname, lastname, phone);