-- ------------------------------------------
-- Friendica 2020.12-dev (Red Hot Poker)
--- DB_UPDATE_VERSION 1377
+-- DB_UPDATE_VERSION 1378
-- ------------------------------------------
PRIMARY KEY(`id`),
INDEX `uid_name` (`uid`,`name`(190)),
INDEX `self_uid` (`self`,`uid`),
- INDEX `alias_uid` (`alias`(96),`uid`),
+ INDEX `alias_uid` (`alias`(128),`uid`),
INDEX `pending_uid` (`pending`,`uid`),
INDEX `blocked_uid` (`blocked`,`uid`),
INDEX `uid_rel_network_poll` (`uid`,`rel`,`network`,`poll`(64),`archive`),
INDEX `uid_network_batch` (`uid`,`network`,`batch`(64)),
- INDEX `addr_uid` (`addr`(96),`uid`),
- INDEX `nurl_uid` (`nurl`(96),`uid`),
- INDEX `nick_uid` (`nick`(32),`uid`),
+ INDEX `addr_uid` (`addr`(128),`uid`),
+ INDEX `nurl_uid` (`nurl`(128),`uid`),
+ INDEX `nick_uid` (`nick`(128),`uid`),
INDEX `attag_uid` (`attag`(96),`uid`),
INDEX `dfrn-id` (`dfrn-id`(64)),
INDEX `issued-id` (`issued-id`(64)),
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
--
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
--