From 4e6758e31de60263e3a630c562efb93a11c57edf Mon Sep 17 00:00:00 2001
From: zotlabs <mike@macgirvin.com>
Date: Thu, 8 Nov 2018 15:51:52 -0800
Subject: item db updates

---
 install/schema_mysql.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 088c0414d..8ece64ae2 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -579,6 +579,7 @@ CREATE TABLE IF NOT EXISTS `issue` (
 
 CREATE TABLE IF NOT EXISTS `item` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `uuid` char(191) NOT NULL DEFAULT '',
   `mid` char(191) NOT NULL DEFAULT '',
   `aid` int(10) unsigned NOT NULL DEFAULT 0 ,
   `uid` int(10) unsigned NOT NULL DEFAULT 0 ,
@@ -597,6 +598,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `source_xchan` char(191) NOT NULL DEFAULT '',
   `mimetype` char(191) NOT NULL DEFAULT '',
   `title` text NOT NULL,
+  `summary` mediumtext NOT NULL,
   `body` mediumtext NOT NULL,
   `html` mediumtext NOT NULL,
   `app` char(191) NOT NULL DEFAULT '',
@@ -651,6 +653,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `item_pending_remove` tinyint(1) NOT NULL DEFAULT 0 ,
   `item_blocked` tinyint(1) NOT NULL DEFAULT 0 ,
   PRIMARY KEY (`id`),
+  KEY `uuid` (`uuid`),
   KEY `parent` (`parent`),
   KEY `created` (`created`),
   KEY `edited` (`edited`),
-- 
cgit v1.2.3

