X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=e3768c1efb67432fed9159ef1bfaee5a3b5176dc;hb=e5a6d91cc4dc8f8546580c656ed6acc7016d4a28;hp=76df6aec1990d576abdb7bf0b0b9796732296742;hpb=4b6afbf6814acde5151edc74f0b6cf1fd7685432;p=friendica.git diff --git a/database.sql b/database.sql index 76df6aec19..e3768c1efb 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ --- Friendica 3.4.1 (Lily of the valley) --- DB_UPDATE_VERSION 1188 +-- Friendica 3.4.2 (Lily of the valley) +-- DB_UPDATE_VERSION 1190 -- ------------------------------------------ @@ -317,6 +317,7 @@ CREATE TABLE IF NOT EXISTS `gcontact` ( `gender` varchar(32) NOT NULL DEFAULT '', `community` tinyint(1) NOT NULL DEFAULT 0, `network` varchar(255) NOT NULL DEFAULT '', + `addr` varchar(255) NOT NULL DEFAULT '', `generation` tinyint(3) NOT NULL DEFAULT 0, `server_url` varchar(255) NOT NULL DEFAULT '', INDEX `nurl` (`nurl`), @@ -1020,3 +1021,16 @@ CREATE TABLE IF NOT EXISTS `userd` ( INDEX `username` (`username`) ) DEFAULT CHARSET=utf8; +-- +-- TABLE workerqueue +-- +CREATE TABLE IF NOT EXISTS `workerqueue` ( + `id` int(11) NOT NULL auto_increment PRIMARY KEY, + `parameter` text NOT NULL, + `priority` tinyint(3) unsigned NOT NULL DEFAULT 0, + `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `pid` int(11) NOT NULL DEFAULT 0, + `executed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + INDEX `created` (`created`) +) DEFAULT CHARSET=utf8; +