+--
+-- TABLE item-activity
+--
+CREATE TABLE IF NOT EXISTS `item-activity` (
+ `id` int unsigned NOT NULL auto_increment,
+ `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `uri-hash` char(80) NOT NULL DEFAULT '' COMMENT 'SHA-1 and RIPEMD-160 hash from uri',
+ `activity` smallint unsigned NOT NULL DEFAULT 0 COMMENT '',
+ PRIMARY KEY(`id`),
+ UNIQUE INDEX `uri-hash` (`uri-hash`),
+ INDEX `uri` (`uri`(191))
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Activities for items';
+