-- ------------------------------------------
--- Friendica 2018-05-dev (The Tazmans Flax-lily)
--- DB_UPDATE_VERSION 1258
+-- Friendica 2018.05-rc (The Tazmans Flax-lily)
+-- DB_UPDATE_VERSION 1265
-- ------------------------------------------
`noscrape` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`network` char(4) NOT NULL DEFAULT '' COMMENT '',
`platform` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `relay-subscribe` boolean NOT NULL DEFAULT '0' COMMENT 'Has the server subscribed to the relay system',
+ `relay-scope` varchar(10) NOT NULL DEFAULT '' COMMENT 'The scope of messages that the server wants to get',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`last_poco_query` datetime DEFAULT '0001-01-01 00:00:00' COMMENT '',
`last_contact` datetime DEFAULT '0001-01-01 00:00:00' COMMENT '',
UNIQUE INDEX `nurl` (`nurl`(190))
) DEFAULT COLLATE utf8mb4_general_ci;
+--
+-- TABLE gserver-tag
+--
+CREATE TABLE IF NOT EXISTS `gserver-tag` (
+ `gserver-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'The id of the gserver',
+ `tag` varchar(100) NOT NULL DEFAULT '' COMMENT 'Tag that the server has subscribed',
+ PRIMARY KEY(`gserver-id`,`tag`),
+ INDEX `tag` (`tag`)
+) DEFAULT COLLATE utf8mb4_general_ci;
+
--
-- TABLE hook
--
`callback_url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`topic` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`nickname` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `push` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
- `last_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `push` tinyint NOT NULL DEFAULT 0 COMMENT 'Retrial counter',
+ `last_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last successful trial',
+ `next_try` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Next retrial date',
+ `renewed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last subscription renewal',
`secret` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- PRIMARY KEY(`id`)
+ PRIMARY KEY(`id`),
+ INDEX `next_try` (`next_try`)
) DEFAULT COLLATE utf8mb4_general_ci;
--
INDEX `pid` (`pid`),
INDEX `parameter` (`parameter`(64)),
INDEX `priority_created` (`priority`,`created`),
- INDEX `executed` (`executed`)
+ INDEX `done_executed` (`done`,`executed`)
) DEFAULT COLLATE utf8mb4_general_ci;