protected function databaseFinalPgsql()
{
/**
* 'table' +> 'primary_key_column'
*/
$map = ['airship_auth_tokens' => 'tokenid', 'airship_custom_dir' => 'directoryid', 'airship_custom_page' => 'pageid', 'airship_custom_page_version' => 'versionid', 'airship_custom_redirect' => 'redirectid', 'airship_dirs' => 'directoryid', 'airship_files' => 'fileid', 'airship_groups' => 'groupid', 'airship_perm_actions' => 'actionid', 'airship_perm_contexts' => 'contextid', 'airship_perm_rules' => 'ruleid', 'airship_users' => 'userid', 'airship_user_preferences' => 'preferenceid', 'hull_blog_authors' => 'authorid', 'hull_blog_author_photos' => 'photoid', 'hull_blog_categories' => 'categoryid', 'hull_blog_comments' => 'commentid', 'hull_blog_comment_versions' => 'versionid', 'hull_blog_tags' => 'tagid', 'hull_blog_posts' => 'postid', 'hull_blog_post_versions' => 'versionid', 'hull_blog_series' => 'seriesid', 'hull_blog_series_items' => 'itemid'];
foreach ($map as $table => $primary_key_name) {
$this->db->run("SELECT setval(\n '" . $table . "_" . $primary_key_name . "_seq',\n COALESCE(\n (\n SELECT MAX(" . $primary_key_name . ") + 1 FROM " . $table . "\n ),\n 1\n ),\n FALSE\n );");
}
}