X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=addd396ffd2d10b3924229eadbfae16f9a030069;hb=730a5c5725cd82e51ede61d5d5df316b1221aa3b;hp=46a2981e77244e5fc1129cd321ec39d2eba82e62;hpb=247d87c4e5e1474b25d6b2acb64bf1edfc4a43e3;p=friendica.git diff --git a/database.sql b/database.sql index 46a2981e77..addd396ffd 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2020.09-dev (Red Hot Poker) --- DB_UPDATE_VERSION 1366 +-- DB_UPDATE_VERSION 1367 -- ------------------------------------------ @@ -585,6 +585,16 @@ CREATE TABLE IF NOT EXISTS `hook` ( UNIQUE INDEX `hook_file_function` (`hook`,`file`,`function`) ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='addon hook registry'; +-- +-- TABLE host +-- +CREATE TABLE IF NOT EXISTS `host` ( + `id` tinyint unsigned NOT NULL auto_increment COMMENT 'sequential ID', + `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The hostname', + PRIMARY KEY(`id`), + UNIQUE INDEX `name` (`name`) +) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Hostname'; + -- -- TABLE inbox-status --