X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=a8c12f272b41805c1cae49008618ac1538fc4f1a;hb=b935a2b6d95dbdfcaa30e18dde9151b65bc65550;hp=4a5946ef38dc747b8c210e7f4f5b84ea60e046a4;hpb=2d229ad8561c0e65f3f9ef7928f4faeb04051240;p=friendica.git diff --git a/database.sql b/database.sql index 4a5946ef38..a8c12f272b 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -- ------------------------------------------ --- Friendica 3.5.2-rc (Asparagus) --- DB_UPDATE_VERSION 1227 +-- Friendica 3.6-dev (Asparagus) +-- DB_UPDATE_VERSION 1238 -- ------------------------------------------ @@ -184,8 +184,8 @@ CREATE TABLE IF NOT EXISTS `contact` ( INDEX `addr_uid` (`addr`(32),`uid`), INDEX `nurl_uid` (`nurl`(32),`uid`), INDEX `nick_uid` (`nick`(32),`uid`), - INDEX `dfrn-id` (`dfrn-id`), - INDEX `issued-id` (`issued-id`) + INDEX `dfrn-id` (`dfrn-id`(64)), + INDEX `issued-id` (`issued-id`(64)) ) DEFAULT COLLATE utf8mb4_general_ci; -- @@ -216,7 +216,8 @@ CREATE TABLE IF NOT EXISTS `conversation` ( `source` mediumtext, `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY(`item-uri`), - INDEX `conversation-uri` (`conversation-uri`) + INDEX `conversation-uri` (`conversation-uri`), + INDEX `received` (`received`) ) DEFAULT COLLATE utf8mb4_general_ci; -- @@ -273,29 +274,6 @@ CREATE TABLE IF NOT EXISTS `fcontact` ( UNIQUE INDEX `url` (`url`(190)) ) DEFAULT COLLATE utf8mb4_general_ci; --- --- TABLE ffinder --- -CREATE TABLE IF NOT EXISTS `ffinder` ( - `id` int(10) unsigned NOT NULL auto_increment, - `uid` int(10) unsigned NOT NULL DEFAULT 0, - `cid` int(10) unsigned NOT NULL DEFAULT 0, - `fid` int(10) unsigned NOT NULL DEFAULT 0, - PRIMARY KEY(`id`) -) DEFAULT COLLATE utf8mb4_general_ci; - --- --- TABLE fserver --- -CREATE TABLE IF NOT EXISTS `fserver` ( - `id` int(11) NOT NULL auto_increment, - `server` varchar(255) NOT NULL DEFAULT '', - `posturl` varchar(255) NOT NULL DEFAULT '', - `key` text, - PRIMARY KEY(`id`), - INDEX `server` (`server`(32)) -) DEFAULT COLLATE utf8mb4_general_ci; - -- -- TABLE fsuggest -- @@ -396,13 +374,11 @@ CREATE TABLE IF NOT EXISTS `group` ( -- CREATE TABLE IF NOT EXISTS `group_member` ( `id` int(10) unsigned NOT NULL auto_increment, - `uid` int(10) unsigned NOT NULL DEFAULT 0, `gid` int(10) unsigned NOT NULL DEFAULT 0, `contact-id` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY(`id`), INDEX `contactid` (`contact-id`), - INDEX `gid_contactid` (`gid`,`contact-id`), - UNIQUE INDEX `uid_gid_contactid` (`uid`,`gid`,`contact-id`) + UNIQUE INDEX `gid_contactid` (`gid`,`contact-id`) ) DEFAULT COLLATE utf8mb4_general_ci; -- @@ -416,6 +392,7 @@ CREATE TABLE IF NOT EXISTS `gserver` ( `site_name` varchar(255) NOT NULL DEFAULT '', `info` text, `register_policy` tinyint(1) NOT NULL DEFAULT 0, + `registered-users` int(10) NOT NULL DEFAULT 0, `poco` varchar(255) NOT NULL DEFAULT '', `noscrape` varchar(255) NOT NULL DEFAULT '', `network` varchar(32) NOT NULL DEFAULT '', @@ -529,11 +506,11 @@ CREATE TABLE IF NOT EXISTS `item` ( `rendered-html` mediumtext, `global` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY(`id`), - INDEX `guid` (`guid`), - INDEX `uri` (`uri`), + INDEX `guid` (`guid`(191)), + INDEX `uri` (`uri`(191)), INDEX `parent` (`parent`), - INDEX `parent-uri` (`parent-uri`), - INDEX `extid` (`extid`), + INDEX `parent-uri` (`parent-uri`(191)), + INDEX `extid` (`extid`(191)), INDEX `uid_id` (`uid`,`id`), INDEX `uid_contactid_id` (`uid`,`contact-id`,`id`), INDEX `uid_created` (`uid`,`created`), @@ -546,7 +523,7 @@ CREATE TABLE IF NOT EXISTS `item` ( INDEX `authorid_created` (`author-id`,`created`), INDEX `ownerid` (`owner-id`), INDEX `uid_uri` (`uid`,`uri`(190)), - INDEX `resource-id` (`resource-id`), + INDEX `resource-id` (`resource-id`(191)), INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)), INDEX `uid_type_changed` (`uid`,`type`(190),`changed`), INDEX `contactid_verb` (`contact-id`,`verb`(190)), @@ -557,22 +534,6 @@ CREATE TABLE IF NOT EXISTS `item` ( INDEX `uid_ownerlink` (`uid`,`owner-link`(190)) ) DEFAULT COLLATE utf8mb4_general_ci; --- --- TABLE item_id --- -CREATE TABLE IF NOT EXISTS `item_id` ( - `id` int(11) NOT NULL auto_increment, - `iid` int(11) NOT NULL DEFAULT 0, - `uid` int(11) NOT NULL DEFAULT 0, - `sid` varchar(255) NOT NULL DEFAULT '', - `service` varchar(255) NOT NULL DEFAULT '', - PRIMARY KEY(`id`), - INDEX `uid` (`uid`), - INDEX `sid` (`sid`), - INDEX `service` (`service`(32)), - INDEX `iid` (`iid`) -) DEFAULT COLLATE utf8mb4_general_ci; - -- -- TABLE locks -- @@ -580,7 +541,7 @@ CREATE TABLE IF NOT EXISTS `locks` ( `id` int(11) NOT NULL auto_increment, `name` varchar(128) NOT NULL DEFAULT '', `locked` tinyint(1) NOT NULL DEFAULT 0, - `created` datetime DEFAULT '0001-01-01 00:00:00', + `pid` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY(`id`) ) DEFAULT COLLATE utf8mb4_general_ci; @@ -610,7 +571,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( INDEX `convid` (`convid`), INDEX `uri` (`uri`(64)), INDEX `parent-uri` (`parent-uri`(64)), - INDEX `contactid` (`contact-id`) + INDEX `contactid` (`contact-id`(32)) ) DEFAULT COLLATE utf8mb4_general_ci; -- @@ -944,24 +905,7 @@ CREATE TABLE IF NOT EXISTS `sign` ( `signature` text, `signer` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY(`id`), - INDEX `iid` (`iid`) -) DEFAULT COLLATE utf8mb4_general_ci; - --- --- TABLE spam --- -CREATE TABLE IF NOT EXISTS `spam` ( - `id` int(11) NOT NULL auto_increment, - `uid` int(11) NOT NULL DEFAULT 0, - `spam` int(11) NOT NULL DEFAULT 0, - `ham` int(11) NOT NULL DEFAULT 0, - `term` varchar(255) NOT NULL DEFAULT '', - `date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - PRIMARY KEY(`id`), - INDEX `uid` (`uid`), - INDEX `spam` (`spam`), - INDEX `ham` (`ham`), - INDEX `term` (`term`) + UNIQUE INDEX `iid` (`iid`) ) DEFAULT COLLATE utf8mb4_general_ci; -- @@ -1027,7 +971,8 @@ CREATE TABLE IF NOT EXISTS `thread` ( INDEX `authorid` (`author-id`), INDEX `uid_created` (`uid`,`created`), INDEX `uid_commented` (`uid`,`commented`), - INDEX `uid_wall_created` (`uid`,`wall`,`created`) + INDEX `uid_wall_created` (`uid`,`wall`,`created`), + INDEX `private_wall_received` (`private`,`wall`,`received`) ) DEFAULT COLLATE utf8mb4_general_ci; -- @@ -1083,7 +1028,6 @@ CREATE TABLE IF NOT EXISTS `user` ( `account_expired` tinyint(1) NOT NULL DEFAULT 0, `account_expires_on` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `expire_notification_sent` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', - `service_class` varchar(32) NOT NULL DEFAULT '', `def_gid` int(11) NOT NULL DEFAULT 0, `allow_cid` mediumtext, `allow_gid` mediumtext, @@ -1114,8 +1058,11 @@ CREATE TABLE IF NOT EXISTS `workerqueue` ( `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', `pid` int(11) NOT NULL DEFAULT 0, `executed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', + `done` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY(`id`), INDEX `pid` (`pid`), - INDEX `priority_created` (`priority`,`created`) + INDEX `parameter` (`parameter`(64)), + INDEX `priority_created` (`priority`,`created`), + INDEX `executed` (`executed`) ) DEFAULT COLLATE utf8mb4_general_ci;