X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=7c0a593795e342c48be493469d6b3730e11ad15c;hb=c598bf7d8f5075526fadcfd329f6dd448533dfad;hp=aa87247db35c57dc2f68a079a1abe70995d28e6c;hpb=27155fead777741f35a8f89c176b8892508ada05;p=friendica.git diff --git a/database.sql b/database.sql index aa87247db3..7c0a593795 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ --- Friendica 2018-05-dev (The Tazmans Flax-lily) --- DB_UPDATE_VERSION 1259 +-- Friendica 2018.05-rc (The Tazmans Flax-lily) +-- DB_UPDATE_VERSION 1266 -- ------------------------------------------ @@ -855,10 +855,13 @@ CREATE TABLE IF NOT EXISTS `push_subscriber` ( `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; -- @@ -1073,6 +1076,16 @@ CREATE TABLE IF NOT EXISTS `userd` ( INDEX `username` (`username`(32)) ) DEFAULT COLLATE utf8mb4_general_ci; +-- +-- TABLE user-item +-- +CREATE TABLE IF NOT EXISTS `user-item` ( + `iid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Item id', + `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id', + `hidden` boolean NOT NULL DEFAULT '0' COMMENT 'Hidden marker', + PRIMARY KEY(`uid`,`iid`) +) DEFAULT COLLATE utf8mb4_general_ci; + -- -- TABLE workerqueue -- @@ -1088,7 +1101,7 @@ CREATE TABLE IF NOT EXISTS `workerqueue` ( 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;