-- ------------------------------------------
--- Friendica 3.6-dev (Asparagus)
+-- Friendica 2018-05-dev (The Tazmans Flax-lily)
-- DB_UPDATE_VERSION 1256
-- ------------------------------------------
`v` mediumtext COMMENT 'cached serialized value',
`expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache expiration',
`updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of cache insertion',
- PRIMARY KEY (`k`),
- KEY `k_expires` (`k`,`expires`) USING BTREE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Stores temporary data';
+ PRIMARY KEY(`k`),
+ INDEX `k_expires` (`k`,`expires`)
+) DEFAULT COLLATE utf8mb4_general_ci;
--
-- TABLE challenge
`author-link` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`author-avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `content-warning` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`body` mediumtext COMMENT '',
`app` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`verb` varchar(100) NOT NULL DEFAULT '' COMMENT '',