X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=static%2Fdbstructure.config.php;h=87cfdd11c6330d5a222ba0dce9790b9afad9952e;hb=4a3544582c570d43f7d274ddbae7ea835176cbd9;hp=49934c63cf2324ea86d6e5d40b175e4f45e59cba;hpb=33664ebb48f415dd74a32da13edb25f54e494134;p=friendica.git

diff --git a/static/dbstructure.config.php b/static/dbstructure.config.php
index 49934c63cf..87cfdd11c6 100755
--- a/static/dbstructure.config.php
+++ b/static/dbstructure.config.php
@@ -34,7 +34,7 @@
 use Friendica\Database\DBA;
 
 if (!defined('DB_UPDATE_VERSION')) {
-	define('DB_UPDATE_VERSION', 1330);
+	define('DB_UPDATE_VERSION', 1332);
 }
 
 return [
@@ -277,7 +277,7 @@ return [
 			"reason" => ["type" => "text", "comment" => ""],
 			"closeness" => ["type" => "tinyint unsigned", "not null" => "1", "default" => "99", "comment" => ""],
 			"info" => ["type" => "mediumtext", "comment" => ""],
-			"profile-id" => ["type" => "int unsigned", "not null" => "1", "default" => "0", "comment" => ""],
+			"profile-id" => ["type" => "int unsigned", "comment" => "Deprecated"],
 			"bdyear" => ["type" => "varchar(4)", "not null" => "1", "default" => "", "comment" => ""],
 			"bd" => ["type" => "date", "not null" => "1", "default" => DBA::NULL_DATE, "comment" => ""],
 			"notify_new_posts" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => ""],
@@ -1084,8 +1084,8 @@ return [
 		"fields" => [
 			"id" => ["type" => "int unsigned", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => "sequential ID"],
 			"uid" => ["type" => "mediumint unsigned", "not null" => "1", "default" => "0", "relation" => ["user" => "uid"], "comment" => "Owner User id"],
-			"profile-name" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => "Name of the profile"],
-			"is-default" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => "Mark this profile as default profile"],
+			"profile-name" => ["type" => "varchar(255)", "comment" => "Deprecated"],
+			"is-default" => ["type" => "boolean", "comment" => "Deprecated"],
 			"hide-friends" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => "Hide friend list from viewers of this profile"],
 			"name" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
 			"pdesc" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => "Title or description"],
@@ -1095,29 +1095,29 @@ return [
 			"region" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
 			"postal-code" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
 			"country-name" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-			"hometown" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-			"gender" => ["type" => "varchar(32)", "not null" => "1", "default" => "", "comment" => ""],
-			"marital" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-			"with" => ["type" => "text", "comment" => ""],
-			"howlong" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => ""],
-			"sexual" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-			"politic" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-			"religion" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
+			"hometown" => ["type" => "varchar(255)", "comment" => "Deprecated"],
+			"gender" => ["type" => "varchar(32)", "comment" => "Deprecated"],
+			"marital" => ["type" => "varchar(255)", "comment" => "Deprecated"],
+			"with" => ["type" => "text", "comment" => "Deprecated"],
+			"howlong" => ["type" => "datetime", "comment" => "Deprecated"],
+			"sexual" => ["type" => "varchar(255)", "comment" => "Deprecated"],
+			"politic" => ["type" => "varchar(255)", "comment" => "Deprecated"],
+			"religion" => ["type" => "varchar(255)", "comment" => "Deprecated"],
 			"pub_keywords" => ["type" => "text", "comment" => ""],
 			"prv_keywords" => ["type" => "text", "comment" => ""],
-			"likes" => ["type" => "text", "comment" => ""],
-			"dislikes" => ["type" => "text", "comment" => ""],
-			"about" => ["type" => "text", "comment" => ""],
-			"summary" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
-			"music" => ["type" => "text", "comment" => ""],
-			"book" => ["type" => "text", "comment" => ""],
-			"tv" => ["type" => "text", "comment" => ""],
-			"film" => ["type" => "text", "comment" => ""],
-			"interest" => ["type" => "text", "comment" => ""],
-			"romance" => ["type" => "text", "comment" => ""],
-			"work" => ["type" => "text", "comment" => ""],
-			"education" => ["type" => "text", "comment" => ""],
-			"contact" => ["type" => "text", "comment" => ""],
+			"likes" => ["type" => "text", "comment" => "Deprecated"],
+			"dislikes" => ["type" => "text", "comment" => "Deprecated"],
+			"about" => ["type" => "text", "comment" => "Deprecated"],
+			"summary" => ["type" => "varchar(255)", "comment" => "Deprecated"],
+			"music" => ["type" => "text", "comment" => "Deprecated"],
+			"book" => ["type" => "text", "comment" => "Deprecated"],
+			"tv" => ["type" => "text", "comment" => "Deprecated"],
+			"film" => ["type" => "text", "comment" => "Deprecated"],
+			"interest" => ["type" => "text", "comment" => "Deprecated"],
+			"romance" => ["type" => "text", "comment" => "Deprecated"],
+			"work" => ["type" => "text", "comment" => "Deprecated"],
+			"education" => ["type" => "text", "comment" => "Deprecated"],
+			"contact" => ["type" => "text", "comment" => "Deprecated"],
 			"homepage" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
 			"xmpp" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
 			"photo" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => ""],
@@ -1145,6 +1145,25 @@ return [
 			"PRIMARY" => ["id"],
 		]
 	],
+	"profile_field" => [
+		"comment" => "Custom profile fields",
+		"fields" => [
+			"id" => ["type" => "int unsigned", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => "sequential ID"],
+			"uid" => ["type" => "mediumint unsigned", "not null" => "1", "default" => "0", "relation" => ["user" => "uid"], "comment" => "Owner user id"],
+			"order" => ["type" => "mediumint unsigned", "not null" => "1", "default" => "1", "comment" => "Field ordering per user"],
+			"psid" => ["type" => "int unsigned", "relation" => ["permissionset" => "id"], "comment" => "ID of the permission set of this profile field - 0 = public"],
+			"label" => ["type" => "varchar(255)", "not null" => "1", "default" => "", "comment" => "Label of the field"],
+			"value" => ["type" => "text", "comment" => "Value of the field"],
+			"created" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "creation time"],
+			"edited" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "last edit time"],
+		],
+		"indexes" => [
+			"PRIMARY" => ["id"],
+			"uid" => ["uid"],
+			"order" => ["order"],
+			"psid" => ["psid"],
+		]
+	],
 	"push_subscriber" => [
 		"comment" => "Used for OStatus: Contains feed subscribers",
 		"fields" => [