X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=e890d7421a232e9ab313b1e272f3d50208d5943d;hb=f40cd60e3936c9220dbc6d5c1ef4cc5e294b99b1;hp=0b91aedc06112d42ffc37024826bde562998d182;hpb=73e163100c108caee1e295d00ac8433ea62405be;p=friendica.git diff --git a/database.sql b/database.sql index 0b91aedc06..e890d7421a 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2023.03-dev (Giant Rhubarb) --- DB_UPDATE_VERSION 1512 +-- DB_UPDATE_VERSION 1514 -- ------------------------------------------ @@ -495,6 +495,18 @@ CREATE TABLE IF NOT EXISTS `cache` ( INDEX `k_expires` (`k`,`expires`) ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Stores temporary data'; +-- +-- 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(`id`), + UNIQUE INDEX `cat_k` (`cat`,`k`) +) DEFAULT COLLATE utf8mb4_general_ci COMMENT='main configuration storage'; + -- -- TABLE contact-relation --