- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `guid` char(64) NOT NULL,
- `uri` char(255) CHARACTER SET ascii NOT NULL,
- `uid` int(10) unsigned NOT NULL DEFAULT '0',
- `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
- `type` char(255) NOT NULL,
- `wall` tinyint(1) NOT NULL DEFAULT '0',
- `gravity` tinyint(1) NOT NULL DEFAULT '0',
- `parent` int(10) unsigned NOT NULL DEFAULT '0',
- `parent-uri` char(255) CHARACTER SET ascii NOT NULL,
- `extid` char(255) NOT NULL,
- `thr-parent` char(255) NOT NULL,
- `created` datetime NOT NULL,
- `edited` datetime NOT NULL,
- `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` char(255) NOT NULL,
- `owner-link` char(255) NOT NULL,
- `owner-avatar` char(255) NOT NULL,
- `author-name` char(255) NOT NULL,
- `author-link` char(255) NOT NULL,
- `author-avatar` char(255) NOT NULL,
- `title` char(255) NOT NULL,
- `body` mediumtext NOT NULL,
- `app` char(255) NOT NULL,
- `verb` char(255) NOT NULL,
- `object-type` char(255) NOT NULL,
- `object` text NOT NULL,
- `target-type` char(255) NOT NULL,
- `target` text NOT NULL,
- `postopts` text NOT NULL,
- `plink` char(255) NOT NULL,
- `resource-id` char(255) NOT NULL,
- `event-id` int(11) NOT NULL,
- `tag` mediumtext NOT NULL,
- `attach` mediumtext NOT NULL,
- `inform` mediumtext NOT NULL,
- `file` mediumtext NOT NULL,
- `location` char(255) NOT NULL,
- `coord` char(255) NOT NULL,
- `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',
- `mention` tinyint(1) NOT NULL DEFAULT '0',
- `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
- PRIMARY KEY (`id`),
- KEY `uri` (`uri`),
- KEY `uid` (`uid`),
- KEY `contact-id` (`contact-id`),
- KEY `type` (`type`),
- KEY `parent` (`parent`),
- KEY `parent-uri` (`parent-uri`),
- KEY `created` (`created`),
- KEY `edited` (`edited`),
- KEY `visible` (`visible`),
- KEY `deleted` (`deleted`),
- KEY `last-child` (`last-child`),
- KEY `unseen` (`unseen`),
- KEY `extid` (`extid`),
- KEY `received` (`received`),
- KEY `starred` (`starred`),
- KEY `guid` (`guid`),
- KEY `origin` (`origin`),
- KEY `wall` (`wall`),
- KEY `forum_mode` (`forum_mode`),
- KEY `author-link` (`author-link`),
- KEY `bookmark` (`bookmark`),
- KEY `moderated` (`moderated`),
- KEY `spam` (`spam`),
- KEY `author-name` (`author-name`),
- KEY `uid_commented` (`uid`, `commented`),
- KEY `uid_created` (`uid`, `created`),
- KEY `uid_unseen` (`uid`, `unseen`),
- KEY `mention` (`mention`),
- KEY `resource-id` (`resource-id`),
- FULLTEXT KEY `title` (`title`),
- FULLTEXT KEY `body` (`body`),
- FULLTEXT KEY `allow_cid` (`allow_cid`),
- FULLTEXT KEY `allow_gid` (`allow_gid`),
- FULLTEXT KEY `deny_cid` (`deny_cid`),
- FULLTEXT KEY `deny_gid` (`deny_gid`),
- FULLTEXT KEY `tag` (`tag`),
- FULLTEXT KEY `file` (`file`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
+ `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
+ `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,
+ `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,
+ 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 `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;
+
+--
+-- TABLE item_id