+--
+-- TABLE item
+--
+CREATE TABLE IF NOT EXISTS `item` (
+ `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 '0000-00-00 00:00:00',
+ `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `owner-name` varchar(255) NOT NULL DEFAULT '',
+ `owner-link` varchar(255) NOT NULL DEFAULT '',
+ `owner-avatar` varchar(255) NOT NULL DEFAULT '',
+ `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 NOT NULL,
+ `app` varchar(255) NOT NULL DEFAULT '',
+ `verb` varchar(255) NOT NULL DEFAULT '',
+ `object-type` varchar(255) NOT NULL DEFAULT '',
+ `object` text NOT NULL,
+ `target-type` varchar(255) NOT NULL DEFAULT '',
+ `target` text NOT NULL,
+ `postopts` text NOT NULL,
+ `plink` varchar(255) NOT NULL DEFAULT '',
+ `resource-id` varchar(255) NOT NULL DEFAULT '',
+ `event-id` int(11) NOT NULL DEFAULT 0,
+ `tag` mediumtext NOT NULL,
+ `attach` mediumtext NOT NULL,
+ `inform` mediumtext NOT NULL,
+ `file` mediumtext NOT NULL,
+ `location` varchar(255) NOT NULL DEFAULT '',
+ `coord` varchar(255) NOT NULL DEFAULT '',
+ `allow_cid` mediumtext NOT NULL,
+ `allow_gid` mediumtext NOT NULL,
+ `deny_cid` mediumtext NOT NULL,
+ `deny_gid` mediumtext NOT NULL,
+ `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 NOT NULL,
+ `global` tinyint(1) NOT NULL DEFAULT 0,
+ PRIMARY KEY(`id`),
+ INDEX `guid` (`guid`),
+ INDEX `uri` (`uri`),
+ INDEX `parent` (`parent`),
+ INDEX `parent-uri` (`parent-uri`),
+ INDEX `extid` (`extid`),
+ INDEX `uid_id` (`uid`,`id`),
+ INDEX `uid_created` (`uid`,`created`),
+ INDEX `uid_unseen` (`uid`,`unseen`),
+ INDEX `uid_network_received` (`uid`,`network`,`received`),
+ INDEX `uid_received` (`uid`,`received`),
+ INDEX `uid_network_commented` (`uid`,`network`,`commented`),
+ INDEX `uid_commented` (`uid`,`commented`),
+ INDEX `uid_title` (`uid`,`title`),
+ INDEX `uid_thrparent` (`uid`,`thr-parent`),
+ INDEX `uid_parenturi` (`uid`,`parent-uri`),
+ INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
+ INDEX `gcontactid_uid_created` (`gcontact-id`,`uid`,`created`),
+ INDEX `wall_body` (`wall`,`body`(6)),
+ INDEX `uid_visible_moderated_created` (`uid`,`visible`,`moderated`,`created`),
+ INDEX `uid_uri` (`uid`,`uri`),
+ INDEX `uid_wall_created` (`uid`,`wall`,`created`),
+ INDEX `resource-id` (`resource-id`),
+ INDEX `uid_type` (`uid`,`type`),
+ INDEX `uid_starred` (`uid`,`starred`),
+ INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)),
+ INDEX `uid_wall_parent_created` (`uid`,`wall`,`parent`,`created`),
+ INDEX `uid_type_changed` (`uid`,`type`,`changed`),
+ INDEX `contactid_verb` (`contact-id`,`verb`),
+ INDEX `deleted_changed` (`deleted`,`changed`),
+ INDEX `uid_wall_changed` (`uid`,`wall`,`changed`),
+ INDEX `uid_eventid` (`uid`,`event-id`),
+ INDEX `uid_authorlink` (`uid`,`author-link`),
+ INDEX `uid_ownerlink` (`uid`,`owner-link`)
+) DEFAULT CHARSET=utf8;