DROP TABLE IF EXISTS `contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'sequential ID',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
  `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `updated` datetime DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last contact update',
  `self` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 if the contact is the user him/her self',
  `remote_self` tinyint(1) NOT NULL DEFAULT 0,
  `rel` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'The kind of the relation between the user and the contact',
  `duplex` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Deprecated',
  `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network of the contact',
  `protocol` char(4) NOT NULL DEFAULT '' COMMENT 'Protocol of the contact',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name that this contact is known by',
  `nick` varchar(255) NOT NULL DEFAULT '' COMMENT 'Nick- and user name of the contact',
  `location` varchar(255) DEFAULT '',
  `about` text DEFAULT NULL,
  `keywords` text DEFAULT NULL COMMENT 'public keywords (interests) of the contact',
  `gender` varchar(32) NOT NULL DEFAULT '' COMMENT 'Deprecated',
  `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT 'XMPP address',
  `attag` varchar(255) NOT NULL DEFAULT '',
  `avatar` varchar(255) NOT NULL DEFAULT '',
  `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)',
  `site-pubkey` text DEFAULT NULL COMMENT 'Deprecated',
  `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Deprecated',
  `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Deprecated',
  `url` varchar(255) NOT NULL DEFAULT '',
  `nurl` varchar(255) NOT NULL DEFAULT '',
  `addr` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `pubkey` text DEFAULT NULL COMMENT 'RSA public key 4096 bit',
  `prvkey` text DEFAULT NULL COMMENT 'RSA private key 4096 bit',
  `batch` varchar(255) NOT NULL DEFAULT '',
  `request` varchar(255) DEFAULT NULL,
  `notify` varchar(255) DEFAULT NULL,
  `poll` varchar(255) DEFAULT NULL,
  `confirm` varchar(255) DEFAULT NULL,
  `poco` varchar(255) DEFAULT NULL,
  `aes_allow` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Deprecated',
  `ret-aes` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Deprecated',
  `usehub` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Deprecated',
  `subhub` tinyint(1) NOT NULL DEFAULT 0,
  `hub-verify` varchar(255) NOT NULL DEFAULT '',
  `last-update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last try to update the contact info',
  `success_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last successful contact update',
  `failure_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of the last failed update',
  `name-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `uri-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `avatar-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `term-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
  `last-item` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'date of the last post',
  `priority` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Feed poll priority',
  `blocked` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Node-wide block status',
  `block_reason` text DEFAULT NULL COMMENT 'Node-wide block reason',
  `readonly` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'posts of the contact are readonly',
  `writable` tinyint(1) NOT NULL DEFAULT 0,
  `forum` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'contact is a forum. Deprecated, use ''contact-type'' = ''community'' and ''manually-approve'' = false in>
  `prv` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'contact is a private group. Deprecated, use ''contact-type'' = ''community'' and ''manually-approve'' = tr>
  `contact-type` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Person, organisation, news, community, relay',
  `hidden` tinyint(1) NOT NULL DEFAULT 0,
  `archive` tinyint(1) NOT NULL DEFAULT 0,
  `pending` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Contact request is pending',
  `deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Contact has been deleted',
  `rating` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Automatically detected feed poll frequency',
  `unsearchable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Contact prefers to not be searchable',
  `sensitive` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Contact posts sensitive content',
  `baseurl` varchar(255) DEFAULT '' COMMENT 'baseurl of the contact',
  `reason` text DEFAULT NULL,
  `closeness` tinyint(3) unsigned NOT NULL DEFAULT 99 COMMENT 'Deprecated',
  `info` mediumtext DEFAULT NULL,
  `profile-id` int(10) unsigned DEFAULT NULL COMMENT 'Deprecated',
  `bdyear` varchar(4) NOT NULL DEFAULT '',
  `bd` date NOT NULL DEFAULT '0001-01-01',
  `notify_new_posts` tinyint(1) NOT NULL DEFAULT 0,
  `fetch_further_information` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `subscribe` varchar(255) DEFAULT NULL,
  `gsid` int(10) unsigned DEFAULT NULL COMMENT 'Global Server ID',
  `ffi_keyword_denylist` text DEFAULT NULL,
  `failed` tinyint(1) DEFAULT NULL COMMENT 'Connection failed',
  `last-discovery` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'date of the last follower discovery',
  `manually-approve` tinyint(1) DEFAULT NULL COMMENT 'Contact requests have to be approved manually',
  `header` varchar(255) DEFAULT NULL COMMENT 'Header picture',
  `matrix` varchar(255) NOT NULL DEFAULT '' COMMENT 'Matrix address',
  `uri-id` int(10) unsigned DEFAULT NULL COMMENT 'Id of the item-uri table entry that contains the contact url',
  PRIMARY KEY (`id`),
  KEY `uid_name` (`uid`,`name`(190)),
  KEY `self_uid` (`self`,`uid`),
  KEY `pending_uid` (`pending`,`uid`),
  KEY `blocked_uid` (`blocked`,`uid`),
  KEY `uid_rel_network_poll` (`uid`,`rel`,`network`,`poll`(64),`archive`),
  KEY `uid_network_batch` (`uid`,`network`,`batch`(64)),
  KEY `gsid` (`gsid`),
  KEY `attag_uid` (`attag`(96),`uid`),
  KEY `network_uid_lastupdate` (`network`,`uid`,`last-update`),
  KEY `uid_network_self_lastupdate` (`uid`,`network`,`self`,`last-update`),
  KEY `uid_lastitem` (`uid`,`last-item`),
  KEY `alias_uid` (`alias`(128),`uid`),
  KEY `addr_uid` (`addr`(128),`uid`),
  KEY `nurl_uid` (`nurl`(128),`uid`),
  KEY `nick_uid` (`nick`(128),`uid`),
  KEY `batch_contact-type` (`batch`(64),`contact-type`),
  KEY `baseurl` (`baseurl`(64)),
  KEY `uid_contact-type` (`uid`,`contact-type`),
  KEY `uid_self_contact-type` (`uid`,`self`,`contact-type`),
  KEY `self_network_uid` (`self`,`network`,`uid`),
  KEY `uri-id` (`uri-id`),
  CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`),
  CONSTRAINT `contact_ibfk_2` FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON DELETE CASCADE,
  CONSTRAINT `contact_ibfk_3` FOREIGN KEY (`uri-id`) REFERENCES `item-uri` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1002645 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='contact table';
/*!40101 SET character_set_client = @saved_cs_client */;