X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=b37036762e4be0d553d5bac573326c921bea75bd;hb=cc4bae6382f95b95ed0643adacbd0fcfcf16034a;hp=da3c458ef96d1908cdc51983eec67a2aebbfb8de;hpb=cbfea67ba639b4e789b798cc9c7b6cbe3d865775;p=friendica.git diff --git a/database.sql b/database.sql index da3c458ef9..b37036762e 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ -- Friendica 2020.12-dev (Red Hot Poker) --- DB_UPDATE_VERSION 1377 +-- DB_UPDATE_VERSION 1378 -- ------------------------------------------ @@ -248,6 +248,15 @@ CREATE TABLE IF NOT EXISTS `permissionset` ( FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE ) DEFAULT COLLATE utf8mb4_general_ci COMMENT=''; +-- +-- TABLE verb +-- +CREATE TABLE IF NOT EXISTS `verb` ( + `id` smallint unsigned NOT NULL auto_increment, + `name` varchar(100) NOT NULL DEFAULT '' COMMENT '', + PRIMARY KEY(`id`) +) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Activity Verbs'; + -- -- TABLE 2fa_app_specific_password -- @@ -1426,15 +1435,6 @@ CREATE TABLE IF NOT EXISTS `user-item` ( FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='User specific item data'; --- --- TABLE verb --- -CREATE TABLE IF NOT EXISTS `verb` ( - `id` smallint unsigned NOT NULL auto_increment, - `name` varchar(100) NOT NULL DEFAULT '' COMMENT '', - PRIMARY KEY(`id`) -) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Activity Verbs'; - -- -- TABLE worker-ipc --