From 58b84ca01dc03a95377e0f8b495b31f313702675 Mon Sep 17 00:00:00 2001
From: Michael <heluecht@pirati.ca>
Date: Sun, 11 Jul 2021 03:06:46 +0000
Subject: [PATCH] Public id added

---
 database.sql             | 1 +
 static/dbview.config.php | 1 +
 2 files changed, 2 insertions(+)

diff --git a/database.sql b/database.sql
index b9c3b32578..0b1a34f213 100644
--- a/database.sql
+++ b/database.sql
@@ -2482,6 +2482,7 @@ CREATE VIEW `account-view` AS SELECT
 DROP VIEW IF EXISTS `account-user-view`;
 CREATE VIEW `account-user-view` AS SELECT 
 	`ucontact`.`id` AS `id`,
+	`contact`.`id` AS `pid`,
 	`ucontact`.`uid` AS `uid`,
 	`contact`.`url` AS `url`,
 	`contact`.`nurl` AS `nurl`,
diff --git a/static/dbview.config.php b/static/dbview.config.php
index 18cdc16e87..bb2cd0f17a 100644
--- a/static/dbview.config.php
+++ b/static/dbview.config.php
@@ -916,6 +916,7 @@
 	"account-user-view" => [
 		"fields" => [
 			"id" => ["ucontact", "id"],
+			"pid" => ["contact", "id"],
 			"uid" => ["ucontact", "uid"],
 			"url" => ["contact", "url"],
 			"nurl" => ["contact", "nurl"],
-- 
2.39.5