From 3d06f3964f7c5b36a151268c37fcac4d87b49e76 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 30 Jan 2013 18:20:14 -0800
Subject: add item revision column and index

---
 install/database.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index ba063bfa4..17d71e7af 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -451,6 +451,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `body` mediumtext NOT NULL,
   `app` char(255) NOT NULL DEFAULT '',
   `lang` char(64) NOT NULL DEFAULT '',
+  `revision` int(10) unsigned NOT NULL DEFAULT '0',
   `verb` char(255) NOT NULL DEFAULT '',
   `obj_type` char(255) NOT NULL DEFAULT '',
   `object` text NOT NULL,
@@ -495,6 +496,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `item_private` (`item_private`),
   KEY `llink` (`llink`),
   KEY `expires` (`expires`),
+  KEY `revision` (`revision`),
   FULLTEXT KEY `title` (`title`),
   FULLTEXT KEY `body` (`body`),
   FULLTEXT KEY `allow_cid` (`allow_cid`),
-- 
cgit v1.2.3