-- ------------------------------------------
-- Friendica 2022.09-rc (Giant Rhubarb)
--- DB_UPDATE_VERSION 1481
+-- DB_UPDATE_VERSION 1484
-- ------------------------------------------
--
CREATE TABLE IF NOT EXISTS `gserver` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `nurl` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `nurl` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`version` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`site_name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`info` text COMMENT '',
`local-posts` int unsigned COMMENT 'Number of local posts',
`local-comments` int unsigned COMMENT 'Number of local comments',
`directory-type` tinyint DEFAULT 0 COMMENT 'Type of directory service (Poco, Mastodon)',
- `poco` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `noscrape` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `poco` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `noscrape` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`network` char(4) NOT NULL DEFAULT '' COMMENT '',
`protocol` tinyint unsigned COMMENT 'The protocol of the server',
`platform` varchar(255) NOT NULL DEFAULT '' COMMENT '',
--
CREATE TABLE IF NOT EXISTS `item-uri` (
`id` int unsigned NOT NULL auto_increment,
- `uri` varbinary(255) NOT NULL COMMENT 'URI of an item',
+ `uri` varbinary(383) NOT NULL COMMENT 'URI of an item',
`guid` varbinary(255) COMMENT 'A unique identifier for an item',
PRIMARY KEY(`id`),
UNIQUE INDEX `uri` (`uri`),
`keywords` text COMMENT 'public keywords (interests) of the contact',
`xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT 'XMPP address',
`matrix` varchar(255) NOT NULL DEFAULT '' COMMENT 'Matrix address',
- `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `header` varchar(255) COMMENT 'Header picture',
- `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `nurl` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `avatar` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `header` varbinary(383) COMMENT 'Header picture',
+ `url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `nurl` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the contact url',
`addr` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `alias` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`pubkey` text COMMENT 'RSA public key 4096 bit',
`prvkey` text COMMENT 'RSA private key 4096 bit',
- `batch` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `notify` varchar(255) COMMENT '',
- `poll` varchar(255) COMMENT '',
- `subscribe` varchar(255) COMMENT '',
+ `batch` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `notify` varbinary(383) COMMENT '',
+ `poll` varbinary(383) COMMENT '',
+ `subscribe` varbinary(383) COMMENT '',
`last-update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last try to update the contact info',
`next-update` datetime COMMENT 'Next connection request',
`success_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last successful contact update',
`archive` boolean NOT NULL DEFAULT '0' COMMENT '',
`unsearchable` boolean NOT NULL DEFAULT '0' COMMENT 'Contact prefers to not be searchable',
`sensitive` boolean NOT NULL DEFAULT '0' COMMENT 'Contact posts sensitive content',
- `baseurl` varchar(255) DEFAULT '' COMMENT 'baseurl of the contact',
+ `baseurl` varbinary(383) DEFAULT '' COMMENT 'baseurl of the contact',
`gsid` int unsigned COMMENT 'Global Server ID',
`bd` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
`reason` text COMMENT '',
`rel` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'The kind of the relation between the user and the contact',
`protocol` char(4) NOT NULL DEFAULT '' COMMENT 'Protocol of the contact',
`subhub` boolean NOT NULL DEFAULT '0' COMMENT '',
- `hub-verify` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `hub-verify` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`rating` tinyint NOT NULL DEFAULT 0 COMMENT 'Automatically detected feed poll frequency',
`priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Feed poll priority',
`attag` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`notify_new_posts` boolean NOT NULL DEFAULT '0' COMMENT '',
`fetch_further_information` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
`ffi_keyword_denylist` text COMMENT '',
- `photo` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo of the contact',
- `thumb` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (thumb size)',
- `micro` varchar(255) DEFAULT '' COMMENT 'Link to the profile photo (micro size)',
+ `photo` varbinary(383) DEFAULT '' COMMENT 'Link to the profile photo of the contact',
+ `thumb` varbinary(383) DEFAULT '' COMMENT 'Link to the profile photo (thumb size)',
+ `micro` varbinary(383) DEFAULT '' COMMENT 'Link to the profile photo (micro size)',
`name-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`uri-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`avatar-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
- `request` varchar(255) COMMENT '',
- `confirm` varchar(255) COMMENT '',
- `poco` varchar(255) COMMENT '',
+ `request` varbinary(383) COMMENT '',
+ `confirm` varbinary(383) COMMENT '',
+ `poco` varbinary(383) COMMENT '',
`writable` boolean NOT NULL DEFAULT '0' COMMENT '',
`forum` boolean NOT NULL DEFAULT '0' COMMENT 'contact is a forum. Deprecated, use \'contact-type\' = \'community\' and \'manually-approve\' = false instead',
`prv` boolean NOT NULL DEFAULT '0' COMMENT 'contact is a private group. Deprecated, use \'contact-type\' = \'community\' and \'manually-approve\' = true instead',
`site-pubkey` text COMMENT 'Deprecated',
`gender` varchar(32) NOT NULL DEFAULT '' COMMENT 'Deprecated',
`duplex` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
- `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Deprecated',
- `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Deprecated',
+ `issued-id` varbinary(383) NOT NULL DEFAULT '' COMMENT 'Deprecated',
+ `dfrn-id` varbinary(383) NOT NULL DEFAULT '' COMMENT 'Deprecated',
`aes_allow` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
`ret-aes` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
`usehub` boolean NOT NULL DEFAULT '0' COMMENT 'Deprecated',
CREATE TABLE IF NOT EXISTS `tag` (
`id` int unsigned NOT NULL auto_increment COMMENT '',
`name` varchar(96) NOT NULL DEFAULT '' COMMENT '',
- `url` varbinary(255) NOT NULL DEFAULT '' COMMENT '',
+ `url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`type` tinyint unsigned COMMENT 'Type of the tag (Unknown, General Collection, Follower Collection or Account)',
PRIMARY KEY(`id`),
UNIQUE INDEX `type_name_url` (`name`,`url`),
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Two-factor authentication trusted browsers';
+--
+-- TABLE account-user
+--
+CREATE TABLE IF NOT EXISTS `account-user` (
+ `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
+ `uri-id` int unsigned NOT NULL COMMENT 'Id of the item-uri table entry that contains the account url',
+ `uid` mediumint unsigned NOT NULL COMMENT 'User ID',
+ PRIMARY KEY(`id`),
+ UNIQUE INDEX `uri-id_uid` (`uri-id`,`uid`),
+ INDEX `uid_uri-id` (`uid`,`uri-id`),
+ FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
+ FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Remote and local accounts';
+
--
-- TABLE addon
--
-- TABLE apcontact
--
CREATE TABLE IF NOT EXISTS `apcontact` (
- `url` varbinary(255) NOT NULL COMMENT 'URL of the contact',
+ `url` varbinary(383) NOT NULL COMMENT 'URL of the contact',
`uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the apcontact url',
- `uuid` varchar(255) COMMENT '',
+ `uuid` varbinary(255) COMMENT '',
`type` varchar(20) NOT NULL COMMENT '',
- `following` varchar(255) COMMENT '',
- `followers` varchar(255) COMMENT '',
- `inbox` varchar(255) NOT NULL COMMENT '',
- `outbox` varchar(255) COMMENT '',
- `sharedinbox` varchar(255) COMMENT '',
- `featured` varchar(255) COMMENT 'Address for the collection of featured posts',
- `featured-tags` varchar(255) COMMENT 'Address for the collection of featured tags',
+ `following` varbinary(383) COMMENT '',
+ `followers` varbinary(383) COMMENT '',
+ `inbox` varbinary(383) NOT NULL COMMENT '',
+ `outbox` varbinary(383) COMMENT '',
+ `sharedinbox` varbinary(383) COMMENT '',
+ `featured` varbinary(383) COMMENT 'Address for the collection of featured posts',
+ `featured-tags` varbinary(383) COMMENT 'Address for the collection of featured tags',
`manually-approve` boolean COMMENT '',
`discoverable` boolean COMMENT 'Mastodon extension: true if profile is published in their directory',
`suspended` boolean COMMENT 'Mastodon extension: true if profile is suspended',
`about` text COMMENT '',
`xmpp` varchar(255) COMMENT 'XMPP address',
`matrix` varchar(255) COMMENT 'Matrix address',
- `photo` varchar(255) COMMENT '',
- `header` varchar(255) COMMENT 'Header picture',
+ `photo` varbinary(383) COMMENT '',
+ `header` varbinary(383) COMMENT 'Header picture',
`addr` varchar(255) COMMENT '',
- `alias` varchar(255) COMMENT '',
+ `alias` varbinary(383) COMMENT '',
`pubkey` text COMMENT '',
- `subscribe` varchar(255) COMMENT '',
- `baseurl` varchar(255) COMMENT 'baseurl of the ap contact',
+ `subscribe` varbinary(383) COMMENT '',
+ `baseurl` varbinary(383) COMMENT 'baseurl of the ap contact',
`gsid` int unsigned COMMENT 'Global Server ID',
`generator` varchar(255) COMMENT 'Name of the contact\'s system',
`following_count` int unsigned DEFAULT 0 COMMENT 'Number of following contacts',
`client_id` varchar(64) NOT NULL COMMENT '',
`client_secret` varchar(64) NOT NULL COMMENT '',
`name` varchar(255) NOT NULL COMMENT '',
- `redirect_uri` varchar(255) NOT NULL COMMENT '',
- `website` varchar(255) COMMENT '',
+ `redirect_uri` varbinary(383) NOT NULL COMMENT '',
+ `website` varbinary(383) COMMENT '',
`scopes` varchar(255) COMMENT '',
`read` boolean COMMENT 'Read scope',
`write` boolean COMMENT 'Write scope',
`application-id` int unsigned NOT NULL COMMENT '',
`uid` mediumint unsigned NOT NULL COMMENT 'Owner User id',
`timeline` varchar(64) NOT NULL COMMENT 'Marker (home, notifications)',
- `last_read_id` varchar(255) COMMENT 'Marker id for the timeline',
+ `last_read_id` varbinary(383) COMMENT 'Marker id for the timeline',
`version` smallint unsigned COMMENT 'Version number',
`updated_at` datetime COMMENT 'creation time',
PRIMARY KEY(`application-id`,`uid`,`timeline`),
--
CREATE TABLE IF NOT EXISTS `conv` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this conversation',
+ `guid` varbinary(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this conversation',
`recips` text COMMENT 'sender_handle;recipient_handle',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
`creator` varchar(255) NOT NULL DEFAULT '' COMMENT 'handle of creator',
--
CREATE TABLE IF NOT EXISTS `delayed-post` (
`id` int unsigned NOT NULL auto_increment,
- `uri` varchar(255) COMMENT 'URI of the post that will be distributed later',
+ `uri` varbinary(383) COMMENT 'URI of the post that will be distributed later',
`uid` mediumint unsigned COMMENT 'Owner User id',
`delayed` datetime COMMENT 'delay time',
`wid` int unsigned COMMENT 'Workerqueue id',
-- TABLE endpoint
--
CREATE TABLE IF NOT EXISTS `endpoint` (
- `url` varbinary(255) NOT NULL COMMENT 'URL of the contact',
+ `url` varbinary(383) NOT NULL COMMENT 'URL of the contact',
`type` varchar(20) NOT NULL COMMENT '',
`owner-uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the apcontact url',
PRIMARY KEY(`url`),
--
CREATE TABLE IF NOT EXISTS `event` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `guid` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `guid` varbinary(255) NOT NULL DEFAULT '' COMMENT '',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
`cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact_id (ID of the contact in contact table)',
- `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `uri` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the event uri',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'creation time',
`edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'last edit time',
--
CREATE TABLE IF NOT EXISTS `fcontact` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'unique id',
- `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `guid` varbinary(255) NOT NULL DEFAULT '' COMMENT 'unique id',
+ `url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the fcontact url',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `request` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `photo` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `request` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`nick` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`addr` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `batch` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `notify` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `poll` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `confirm` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `batch` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `notify` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `poll` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `confirm` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
`network` char(4) NOT NULL DEFAULT '' COMMENT '',
- `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `alias` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`pubkey` text COMMENT '',
+ `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`interacting_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts this contact interactes with',
`interacted_count` int unsigned DEFAULT 0 COMMENT 'Number of contacts that interacted with this contact',
--
CREATE TABLE IF NOT EXISTS `fetch-entry` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `url` varbinary(255) COMMENT 'url that awaiting to be fetched',
+ `url` varbinary(383) COMMENT 'url that awaiting to be fetched',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation date of the fetch request',
`wid` int unsigned COMMENT 'Workerqueue id',
PRIMARY KEY(`id`),
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
`cid` int unsigned NOT NULL DEFAULT 0 COMMENT '',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `request` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `request` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `photo` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`note` text COMMENT '',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
PRIMARY KEY(`id`),
--
CREATE TABLE IF NOT EXISTS `inbox-entry` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `activity-id` varbinary(255) COMMENT 'id of the incoming activity',
- `object-id` varbinary(255) COMMENT '',
- `in-reply-to-id` varbinary(255) COMMENT '',
- `conversation` varbinary(255) COMMENT '',
+ `activity-id` varbinary(383) COMMENT 'id of the incoming activity',
+ `object-id` varbinary(383) COMMENT '',
+ `in-reply-to-id` varbinary(383) COMMENT '',
+ `conversation` varbinary(383) COMMENT '',
`type` varchar(64) COMMENT 'Type of the activity',
`object-type` varchar(64) COMMENT 'Type of the object activity',
`object-object-type` varchar(64) COMMENT 'Type of the object\'s object activity',
-- TABLE inbox-status
--
CREATE TABLE IF NOT EXISTS `inbox-status` (
- `url` varbinary(255) NOT NULL COMMENT 'URL of the inbox',
+ `url` varbinary(383) NOT NULL COMMENT 'URL of the inbox',
`uri-id` int unsigned COMMENT 'Item-uri id of inbox url',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Creation date of this entry',
`success` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last successful delivery',
`knowyou` boolean NOT NULL DEFAULT '0' COMMENT '',
`duplex` boolean NOT NULL DEFAULT '0' COMMENT 'deprecated',
`note` text COMMENT '',
- `hash` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `hash` varbinary(255) NOT NULL DEFAULT '' COMMENT '',
`datetime` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`blocked` boolean NOT NULL DEFAULT '0' COMMENT 'deprecated',
`ignore` boolean NOT NULL DEFAULT '0' COMMENT '',
CREATE TABLE IF NOT EXISTS `mail` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
- `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this private message',
+ `guid` varbinary(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this private message',
`from-name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the sender',
- `from-photo` varchar(255) NOT NULL DEFAULT '' COMMENT 'contact photo link of the sender',
- `from-url` varchar(255) NOT NULL DEFAULT '' COMMENT 'profile linke of the sender',
- `contact-id` varchar(255) COMMENT 'contact.id',
+ `from-photo` varbinary(383) NOT NULL DEFAULT '' COMMENT 'contact photo link of the sender',
+ `from-url` varbinary(383) NOT NULL DEFAULT '' COMMENT 'profile linke of the sender',
+ `contact-id` varbinary(255) COMMENT 'contact.id',
`author-id` int unsigned COMMENT 'Link to the contact table with uid=0 of the author of the mail',
`convid` int unsigned COMMENT 'conv.id',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`reply` boolean NOT NULL DEFAULT '0' COMMENT '',
`replied` boolean NOT NULL DEFAULT '0' COMMENT '',
`unknown` boolean NOT NULL DEFAULT '0' COMMENT 'if sender not in the contact table this is 1',
- `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `uri` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`uri-id` int unsigned COMMENT 'Item-uri id of the related mail',
- `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `parent-uri` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`parent-uri-id` int unsigned COMMENT 'Item-uri id of the parent of the related mail',
- `thr-parent` varchar(255) COMMENT '',
+ `thr-parent` varbinary(383) COMMENT '',
`thr-parent-id` int unsigned COMMENT 'Id of the item-uri table that contains the thread parent uri',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'creation time of the private message',
PRIMARY KEY(`id`),
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
`type` smallint unsigned NOT NULL DEFAULT 0 COMMENT '',
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `photo` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`msg` mediumtext COMMENT '',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
- `link` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `link` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`iid` int unsigned COMMENT '',
`parent` int unsigned COMMENT '',
`uri-id` int unsigned COMMENT 'Item-uri id of the related post',
-- TABLE oembed
--
CREATE TABLE IF NOT EXISTS `oembed` (
- `url` varbinary(255) NOT NULL COMMENT 'page url',
+ `url` varbinary(383) NOT NULL COMMENT 'page url',
`maxwidth` mediumint unsigned NOT NULL COMMENT 'Maximum width passed to Oembed',
`content` mediumtext COMMENT 'OEmbed data of the page',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of creation',
`target-type` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams target type if applicable (URI)',
`target` text COMMENT 'JSON encoded target structure if used',
`resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type',
- `plink` varchar(255) NOT NULL DEFAULT '' COMMENT 'permalink or URL to a displayable copy of the message at its source',
+ `plink` varbinary(383) NOT NULL DEFAULT '' COMMENT 'permalink or URL to a displayable copy of the message at its source',
PRIMARY KEY(`uri-id`),
INDEX `plink` (`plink`(191)),
INDEX `resource-id` (`resource-id`),
`target-type` varchar(100) NOT NULL DEFAULT '' COMMENT 'ActivityStreams target type if applicable (URI)',
`target` text COMMENT 'JSON encoded target structure if used',
`resource-id` varchar(32) NOT NULL DEFAULT '' COMMENT 'Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type',
- `plink` varchar(255) NOT NULL DEFAULT '' COMMENT 'permalink or URL to a displayable copy of the message at its source',
+ `plink` varbinary(383) NOT NULL DEFAULT '' COMMENT 'permalink or URL to a displayable copy of the message at its source',
PRIMARY KEY(`uri-id`,`edited`),
FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Post history';
`preview-width` smallint unsigned COMMENT 'Width of the preview picture',
`description` text COMMENT '',
`name` varchar(255) COMMENT 'Name of the media',
- `author-url` varbinary(255) COMMENT 'URL of the author of the media',
+ `author-url` varbinary(383) COMMENT 'URL of the author of the media',
`author-name` varchar(255) COMMENT 'Name of the author of the media',
- `author-image` varbinary(255) COMMENT 'Image of the author of the media',
- `publisher-url` varbinary(255) COMMENT 'URL of the publisher of the media',
+ `author-image` varbinary(383) COMMENT 'Image of the author of the media',
+ `publisher-url` varbinary(383) COMMENT 'URL of the publisher of the media',
`publisher-name` varchar(255) COMMENT 'Name of the publisher of the media',
- `publisher-image` varbinary(255) COMMENT 'Image of the publisher of the media',
+ `publisher-image` varbinary(383) COMMENT 'Image of the publisher of the media',
PRIMARY KEY(`id`),
UNIQUE INDEX `uri-id-url` (`uri-id`,`url`(512)),
INDEX `uri-id-id` (`uri-id`,`id`),
`homepage` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT 'XMPP address',
`matrix` varchar(255) NOT NULL DEFAULT '' COMMENT 'Matrix address',
- `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `photo` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
+ `thumb` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`publish` boolean NOT NULL DEFAULT '0' COMMENT 'publish default profile in local directory',
`net-publish` boolean NOT NULL DEFAULT '0' COMMENT 'publish profile in global directory',
PRIMARY KEY(`id`),
CREATE TABLE IF NOT EXISTS `push_subscriber` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
- `callback_url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `callback_url` varbinary(383) NOT NULL DEFAULT '' COMMENT '',
`topic` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`nickname` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`push` tinyint NOT NULL DEFAULT 0 COMMENT 'Retrial counter',
--
CREATE TABLE IF NOT EXISTS `register` (
`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `hash` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `hash` varbinary(255) NOT NULL DEFAULT '' COMMENT '',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
`password` varchar(255) NOT NULL DEFAULT '' COMMENT '',
`fetch_further_information` tinyint unsigned COMMENT '',
`ffi_keyword_denylist` text COMMENT '',
`subhub` boolean COMMENT '',
- `hub-verify` varchar(255) COMMENT '',
+ `hub-verify` varbinary(383) COMMENT '',
`protocol` char(4) COMMENT 'Protocol of the contact',
`rating` tinyint COMMENT 'Automatically detected feed poll frequency',
`priority` tinyint unsigned COMMENT 'Feed poll priority',
-- TABLE arrived-activity
--
CREATE TABLE IF NOT EXISTS `arrived-activity` (
- `object-id` varbinary(255) NOT NULL COMMENT 'object id of the incoming activity',
+ `object-id` varbinary(383) NOT NULL COMMENT 'object id of the incoming activity',
`received` datetime COMMENT 'Receiving date',
PRIMARY KEY(`object-id`)
) ENGINE=MEMORY DEFAULT COLLATE utf8mb4_general_ci COMMENT='Id of arrived activities';
-- TABLE fetched-activity
--
CREATE TABLE IF NOT EXISTS `fetched-activity` (
- `object-id` varbinary(255) NOT NULL COMMENT 'object id of fetched activity',
+ `object-id` varbinary(383) NOT NULL COMMENT 'object id of fetched activity',
`received` datetime COMMENT 'Receiving date',
PRIMARY KEY(`object-id`)
) ENGINE=MEMORY DEFAULT COLLATE utf8mb4_general_ci COMMENT='Id of fetched activities';
projects / friendica.git / blobdiff