Airship\Installer\Install::databaseFinalPgsql PHP Method

databaseFinalPgsql() protected method

Reset the sequence values.
protected databaseFinalPgsql ( )
    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                );");
        }
    }