X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=8f349ab214820bbf5860daa4292d52ec1b36f766;hb=b91494d22ec1bcf7724f36c1df90d83178f6e47f;hp=2541de76a3ed6f02e6ab6a1e1d7f9ed1a3bbe03b;hpb=b02e30f1cfb3e92c65a5b8783256260a2e72ecc2;p=friendica.git diff --git a/database.sql b/database.sql index 2541de76a3..8f349ab214 100644 --- a/database.sql +++ b/database.sql @@ -145,6 +145,8 @@ CREATE TABLE IF NOT EXISTS `item` ( `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, `created` datetime NOT NULL, @@ -177,6 +179,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `uid` (`uid`), KEY `contact-id` (`contact-id`), KEY `type` (`type`), + KEY `wall` (`wall`), KEY `parent` (`parent`), KEY `parent-uri` (`parent-uri`), KEY `created` (`created`),