Okay figured it out. For anyone else who wants to create a subpage by default when the blog gets created.
1. Duplicate the first line of code under //First Page that starts with $wpdb->query("INSERT INTO $wpdb->
posts to create a new page by default
2. On the new entry add post_parent to the end of this section
(post_author, post_date, post_date_gmt, post_content, post_excerpt, post_title, post_category, post_name, post_modified, post_modified_gmt, post_status, post_type, to_ping, pinged, post_content_filtered)
3. At the end of VALUES line of code
('$user_id', '$now', '$now_gmt', '".$wpdb->escape(__('content'))."', '', '".$wpdb->escape(__('About'))."', '0', '".$wpdb->escape(__('about'))."', '$now', '$now_gmt', 'publish', 'page', '', '', '')")
enter the page ID that you want to be the parent of the subpage.
Since the First Post takes up ID 1, The First Page stats at ID 2 and goes up from there. ie. The first
$wpdb->query("INSERT INTO $wpdb->posts
is ID 2, the second
$wpdb->query("INSERT INTO $wpdb->posts
is ID 3.
The finished code with one main page with a subpage would look like this
// First page
$wpdb->query("INSERT INTO $wpdb->posts (post_author, post_date, post_date_gmt, post_content, post_excerpt, post_title, post_category, post_name, post_modified, post_modified_gmt, post_status, post_type, to_ping, pinged, post_content_filtered) VALUES ('$user_id', '$now', '$now_gmt', '".$wpdb->escape(__('Enter content here'))."', '', '".$wpdb->escape(__('About Us'))."', '0', '".$wpdb->escape(__('about'))."', '$now', '$now_gmt', 'publish', 'page', '', '', '')");
$wpdb->query("INSERT INTO $wpdb->posts (post_author, post_date, post_date_gmt, post_content, post_excerpt, post_title, post_category, post_name, post_modified, post_modified_gmt, post_status, post_type, to_ping, pinged, post_content_filtered, post_parent) VALUES ('$user_id', '$now', '$now_gmt', '".$wpdb->escape(__('Enter subpage content here'))."', '', '".$wpdb->escape(__('Resources'))."', '0', '".$wpdb->escape(__('resources'))."', '$now', '$now_gmt', 'publish', 'page','', '', '','2')");
$wpdb->query( "INSERT INTO $wpdb->post2cat (<code>rel_id</code>, <code>post_id</code>, <code>category_id</code>) VALUES (2, 2, 1)" );