X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=e890d7421a232e9ab313b1e272f3d50208d5943d;hb=f40cd60e3936c9220dbc6d5c1ef4cc5e294b99b1;hp=b6ee05e84e6c54bf9f3ef6bdd86bb79b6e633418;hpb=6db89adc04dce3390d3e5086eea385daea1b8e22;p=friendica.git

diff --git a/database.sql b/database.sql
index b6ee05e84e..e890d7421a 100644
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2023.03-dev (Giant Rhubarb)
--- DB_UPDATE_VERSION 1513
+-- DB_UPDATE_VERSION 1514
 -- ------------------------------------------
 
 
@@ -499,10 +499,12 @@ CREATE TABLE IF NOT EXISTS `cache` (
 -- TABLE config
 --
 CREATE TABLE IF NOT EXISTS `config` (
+	`id` int unsigned NOT NULL auto_increment COMMENT '',
 	`cat` varbinary(50) NOT NULL DEFAULT '' COMMENT 'The category of the entry',
 	`k` varbinary(50) NOT NULL DEFAULT '' COMMENT 'The key of the entry',
 	`v` mediumtext COMMENT '',
-	 PRIMARY KEY(`cat`,`k`)
+	 PRIMARY KEY(`id`),
+	 UNIQUE INDEX `cat_k` (`cat`,`k`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='main configuration storage';
 
 --