- `id` int(10) unsigned NOT NULL auto_increment,
- `guid` varchar(255) NOT NULL DEFAULT '',
- `uri` varchar(255) NOT NULL DEFAULT '',
- `uid` int(10) unsigned NOT NULL DEFAULT 0,
- `contact-id` int(11) NOT NULL DEFAULT 0,
- `gcontact-id` int(11) unsigned NOT NULL DEFAULT 0,
- `type` varchar(255) NOT NULL DEFAULT '',
- `wall` tinyint(1) NOT NULL DEFAULT 0,
- `gravity` tinyint(1) NOT NULL DEFAULT 0,
- `parent` int(10) unsigned NOT NULL DEFAULT 0,
- `parent-uri` varchar(255) NOT NULL DEFAULT '',
- `extid` varchar(255) NOT NULL DEFAULT '',
- `thr-parent` varchar(255) NOT NULL DEFAULT '',
- `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
- `owner-id` int(11) NOT NULL DEFAULT 0,
- `owner-name` varchar(255) NOT NULL DEFAULT '',
- `owner-link` varchar(255) NOT NULL DEFAULT '',
- `owner-avatar` varchar(255) NOT NULL DEFAULT '',
- `author-id` int(11) NOT NULL DEFAULT 0,
- `author-name` varchar(255) NOT NULL DEFAULT '',
- `author-link` varchar(255) NOT NULL DEFAULT '',
- `author-avatar` varchar(255) NOT NULL DEFAULT '',
- `title` varchar(255) NOT NULL DEFAULT '',
- `body` mediumtext,
- `app` varchar(255) NOT NULL DEFAULT '',
- `verb` varchar(255) NOT NULL DEFAULT '',
- `object-type` varchar(255) NOT NULL DEFAULT '',
- `object` text,
- `target-type` varchar(255) NOT NULL DEFAULT '',
- `target` text,
- `postopts` text,
- `plink` varchar(255) NOT NULL DEFAULT '',
- `resource-id` varchar(255) NOT NULL DEFAULT '',
- `event-id` int(11) NOT NULL DEFAULT 0,
- `tag` mediumtext,
- `attach` mediumtext,
- `inform` mediumtext,
- `file` mediumtext,
- `location` varchar(255) NOT NULL DEFAULT '',
- `coord` varchar(255) NOT NULL DEFAULT '',
- `allow_cid` mediumtext,
- `allow_gid` mediumtext,
- `deny_cid` mediumtext,
- `deny_gid` mediumtext,
- `private` tinyint(1) NOT NULL DEFAULT 0,
- `pubmail` tinyint(1) NOT NULL DEFAULT 0,
- `moderated` tinyint(1) NOT NULL DEFAULT 0,
- `visible` tinyint(1) NOT NULL DEFAULT 0,
- `spam` tinyint(1) NOT NULL DEFAULT 0,
- `starred` tinyint(1) NOT NULL DEFAULT 0,
- `bookmark` tinyint(1) NOT NULL DEFAULT 0,
- `unseen` tinyint(1) NOT NULL DEFAULT 1,
- `deleted` tinyint(1) NOT NULL DEFAULT 0,
- `origin` tinyint(1) NOT NULL DEFAULT 0,
- `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
- `last-child` tinyint(1) unsigned NOT NULL DEFAULT 1,
- `mention` tinyint(1) NOT NULL DEFAULT 0,
- `network` varchar(32) NOT NULL DEFAULT '',
- `rendered-hash` varchar(32) NOT NULL DEFAULT '',
- `rendered-html` mediumtext,
- `global` tinyint(1) NOT NULL DEFAULT 0,
+ `id` int unsigned NOT NULL auto_increment,
+ `guid` varchar(255) NOT NULL DEFAULT '' COMMENT 'A unique identifier for this item',
+ `uri` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `uri-id` int unsigned COMMENT 'Id of the item-uri table entry that contains the item uri',
+ `uri-hash` varchar(80) NOT NULL DEFAULT '' COMMENT 'RIPEMD-128 hash from uri',
+ `parent` int unsigned NOT NULL DEFAULT 0 COMMENT 'item.id of the parent to this item if it is a reply of some form; otherwise this must be set to the id of this item',
+ `parent-uri` varchar(255) NOT NULL DEFAULT '' COMMENT 'uri of the parent to this item',
+ `parent-uri-id` int unsigned COMMENT 'Id of the item-uri table that contains the parent uri',
+ `thr-parent` varchar(255) NOT NULL DEFAULT '' COMMENT 'If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri',
+ `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 timestamp.',
+ `edited` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last edit (default is created)',
+ `commented` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date of last comment/reply to this item',
+ `received` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime',
+ `changed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'Date that something in the conversation changed, indicating clients should fetch the conversation again',
+ `gravity` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `network` char(4) NOT NULL DEFAULT '' COMMENT 'Network from where the item comes from',
+ `owner-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the owner of this item',
+ `author-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Link to the contact table with uid=0 of the author of this item',
+ `icid` int unsigned COMMENT 'Id of the item-content table entry that contains the whole item content',
+ `iaid` int unsigned COMMENT 'Id of the item-activity table entry that contains the activity data',
+ `extid` varchar(255) NOT NULL DEFAULT '' COMMENT '',
+ `post-type` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Post type (personal note, bookmark, ...)',
+ `global` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `private` boolean NOT NULL DEFAULT '0' COMMENT 'distribution is restricted',
+ `visible` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `moderated` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `deleted` boolean NOT NULL DEFAULT '0' COMMENT 'item has been deleted',
+ `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner id which owns this copy of the item',
+ `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id',
+ `wall` boolean NOT NULL DEFAULT '0' COMMENT 'This item was posted to the wall of uid',
+ `origin` boolean NOT NULL DEFAULT '0' COMMENT 'item originated at this site',
+ `pubmail` boolean NOT NULL DEFAULT '0' COMMENT '',
+ `starred` boolean NOT NULL DEFAULT '0' COMMENT 'item has been favourited',
+ `unseen` boolean NOT NULL DEFAULT '1' COMMENT 'item has not been seen',
+ `mention` boolean NOT NULL DEFAULT '0' COMMENT 'The owner of this item was mentioned in it',
+ `forum_mode` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
+ `psid` int unsigned COMMENT 'ID of the permission set of this post',
+ `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',
+ `event-id` int unsigned NOT NULL DEFAULT 0 COMMENT 'Used to link to the event.id',
+ `attach` mediumtext COMMENT 'JSON structure representing attachments to this item',
+ `allow_cid` mediumtext COMMENT 'Deprecated',
+ `allow_gid` mediumtext COMMENT 'Deprecated',
+ `deny_cid` mediumtext COMMENT 'Deprecated',
+ `deny_gid` mediumtext COMMENT 'Deprecated',
+ `postopts` text COMMENT 'Deprecated',
+ `inform` mediumtext COMMENT 'Deprecated',
+ `type` varchar(20) COMMENT 'Deprecated',
+ `bookmark` boolean COMMENT 'Deprecated',
+ `file` mediumtext COMMENT 'Deprecated',
+ `location` varchar(255) COMMENT 'Deprecated',
+ `coord` varchar(255) COMMENT 'Deprecated',
+ `tag` mediumtext COMMENT 'Deprecated',
+ `plink` varchar(255) COMMENT 'Deprecated',
+ `title` varchar(255) COMMENT 'Deprecated',
+ `content-warning` varchar(255) COMMENT 'Deprecated',
+ `body` mediumtext COMMENT 'Deprecated',
+ `app` varchar(255) COMMENT 'Deprecated',
+ `verb` varchar(100) COMMENT 'Deprecated',
+ `object-type` varchar(100) COMMENT 'Deprecated',
+ `object` text COMMENT 'Deprecated',
+ `target-type` varchar(100) COMMENT 'Deprecated',
+ `target` text COMMENT 'Deprecated',
+ `author-name` varchar(255) COMMENT 'Deprecated',
+ `author-link` varchar(255) COMMENT 'Deprecated',
+ `author-avatar` varchar(255) COMMENT 'Deprecated',
+ `owner-name` varchar(255) COMMENT 'Deprecated',
+ `owner-link` varchar(255) COMMENT 'Deprecated',
+ `owner-avatar` varchar(255) COMMENT 'Deprecated',
+ `rendered-hash` varchar(32) COMMENT 'Deprecated',
+ `rendered-html` mediumtext COMMENT 'Deprecated',