X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=369637fe60c4a938d1bb458ab66d263ab739e719;hb=a6b1275f16ab67a26ac1a4cc18cffd3d454b0940;hp=da3462a752e82d0c5237a80f2969c4549885724a;hpb=1957aa8f0d5d3fddfb29f9d853bc3935a4169ff9;p=friendica.git

diff --git a/database.sql b/database.sql
index da3462a752..369637fe60 100644
--- a/database.sql
+++ b/database.sql
@@ -273,7 +273,7 @@ CREATE TABLE IF NOT EXISTS `event` (
   KEY `start` ( `start` ),
   KEY `finish` ( `finish` ),
   KEY `adjust` ( `adjust` ),
-  KEY `ignore` ( `ignore` ),
+  KEY `ignore` ( `ignore` )
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
@@ -592,11 +592,13 @@ CREATE TABLE IF NOT EXISTS `item` (
 --
 
 CREATE TABLE IF NOT EXISTS `item_id` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `iid` int(11) NOT NULL,
   `uid` int(11) NOT NULL,
   `sid` char(255) NOT NULL,
   `service` char(255) NOT NULL,
-  PRIMARY KEY (`iid`),
+  PRIMARY KEY (`id`),
+  KEY `iid` (`iid`),
   KEY `uid` (`uid`),
   KEY `sid` (`sid`),
   KEY `service` (`service`)
@@ -775,6 +777,7 @@ CREATE TABLE IF NOT EXISTS `photo` (
   `type` CHAR(128) NOT NULL DEFAULT 'image/jpeg',
   `height` smallint(6) NOT NULL,
   `width` smallint(6) NOT NULL,
+  `datasize` int(10) unsigned NOT NULL DEFAULT '0',
   `data` mediumblob NOT NULL,
   `scale` tinyint(3) NOT NULL,
   `profile` tinyint(1) NOT NULL DEFAULT '0',
@@ -787,6 +790,7 @@ CREATE TABLE IF NOT EXISTS `photo` (
   KEY `resource-id` (`resource-id`),
   KEY `album` (`album`),
   KEY `scale` (`scale`),
+  KEY `datasize` (`datasize`),
   KEY `profile` (`profile`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;