- `id` int(11) NOT NULL auto_increment,
- `uid` int(11) NOT NULL DEFAULT 0,
- `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `self` tinyint(1) NOT NULL DEFAULT 0,
- `remote_self` tinyint(1) NOT NULL DEFAULT 0,
- `rel` tinyint(1) NOT NULL DEFAULT 0,
- `duplex` tinyint(1) NOT NULL DEFAULT 0,
- `network` varchar(255) NOT NULL DEFAULT '',
- `name` varchar(255) NOT NULL DEFAULT '',
- `nick` varchar(255) NOT NULL DEFAULT '',
- `location` varchar(255) NOT NULL DEFAULT '',
- `about` text,
- `keywords` text,
- `gender` varchar(32) NOT NULL DEFAULT '',
- `xmpp` varchar(255) NOT NULL DEFAULT '',
- `attag` varchar(255) NOT NULL DEFAULT '',
- `avatar` varchar(255) NOT NULL DEFAULT '',
- `photo` text,
- `thumb` text,
- `micro` text,
- `site-pubkey` text,
- `issued-id` varchar(255) NOT NULL DEFAULT '',
- `dfrn-id` varchar(255) NOT NULL DEFAULT '',
- `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,
- `prvkey` text,
- `batch` varchar(255) NOT NULL DEFAULT '',
- `request` text,
- `notify` text,
- `poll` text,
- `confirm` text,
- `poco` text,
- `aes_allow` tinyint(1) NOT NULL DEFAULT 0,
- `ret-aes` tinyint(1) NOT NULL DEFAULT 0,
- `usehub` tinyint(1) NOT NULL DEFAULT 0,
- `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',
- `success_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `failure_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `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',
- `priority` tinyint(3) NOT NULL DEFAULT 0,
- `blocked` tinyint(1) NOT NULL DEFAULT 1,
- `readonly` tinyint(1) NOT NULL DEFAULT 0,
- `writable` tinyint(1) NOT NULL DEFAULT 0,
- `forum` tinyint(1) NOT NULL DEFAULT 0,
- `prv` tinyint(1) NOT NULL DEFAULT 0,
- `contact-type` int(11) NOT NULL DEFAULT 0,
- `hidden` tinyint(1) NOT NULL DEFAULT 0,
- `archive` tinyint(1) NOT NULL DEFAULT 0,
- `pending` tinyint(1) NOT NULL DEFAULT 1,
- `rating` tinyint(1) NOT NULL DEFAULT 0,
- `reason` text,
- `closeness` tinyint(2) NOT NULL DEFAULT 99,
- `info` mediumtext,
- `profile-id` int(11) NOT NULL DEFAULT 0,
- `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(1) NOT NULL DEFAULT 0,
- `ffi_keyword_blacklist` text,
+ `id` int unsigned NOT NULL auto_increment COMMENT '',
+ `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
+ `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `self` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `remote_self` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `rel` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `duplex` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `network` char(4) NOT NULL DEFAULT '' COMMENT '',
+ `name` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `nick` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `location` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `about` text COMMENT '',
+ `keywords` text COMMENT '',
+ `gender` varchar(32) NOT NULL DEFAULT '' COMMENT '',
+ `xmpp` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `attag` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `photo` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `micro` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `site-pubkey` text COMMENT '',
+ `issued-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `dfrn-id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `url` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `nurl` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `addr` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `pubkey` text COMMENT '',
+ `prvkey` text COMMENT '',
+ `batch` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `request` varchar(255) COMMENT '',
+ `notify` varchar(255) COMMENT '',
+ `poll` varchar(255) COMMENT '',
+ `confirm` varchar(255) COMMENT '',
+ `poco` varchar(255) COMMENT '',
+ `aes_allow` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `ret-aes` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `usehub` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `subhub` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `hub-verify` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `last-update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `success_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `failure_update` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `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 '',
+ `term-date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `last-item` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
+ `priority` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `blocked` boolean NOT NULL DEFAULT '1' COMMENT '',
+ `readonly` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `writable` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `forum` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `prv` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `contact-type` tinyint NOT NULL DEFAULT 0 COMMENT '',
+ `hidden` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `archive` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `pending` boolean NOT NULL DEFAULT '1' COMMENT '',
+ `rating` tinyint NOT NULL DEFAULT 0 COMMENT '',
+ `reason` text COMMENT '',
+ `closeness` tinyint unsigned NOT NULL DEFAULT 99 COMMENT '',
+ `info` mediumtext COMMENT '',
+ `profile-id` int unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `bdyear` varchar(4) NOT NULL DEFAULT '' COMMENT '',
+ `bd` date NOT NULL DEFAULT '0001-01-01' COMMENT '',
+ `notify_new_posts` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `fetch_further_information` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `ffi_keyword_blacklist` text COMMENT '',