+ `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)',
+ `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 '',
+ `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',
+ `bdyear` varchar(4) NOT NULL DEFAULT '' COMMENT '',
+ `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',
+ `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',
+ `closeness` tinyint unsigned NOT NULL DEFAULT 99 COMMENT 'Deprecated',
+ `profile-id` int unsigned COMMENT 'Deprecated',