From 3586723af798396fd072c2e7ee4dd6390c2fea1b Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 6 Dec 2012 20:26:43 -0800
Subject: DB: alter table group add hash char(255) not null default '' after
 id, add index (hash); alter table photo add size int(10) unsigned not null
 default '0' after width, add index (size);

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

(limited to 'install/database.sql')

diff --git a/install/database.sql b/install/database.sql
index 24c9b9922..36b1003ae 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -425,6 +425,7 @@ CREATE TABLE IF NOT EXISTS `glink` (
 
 CREATE TABLE IF NOT EXISTS `group` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `hash` char(255) NOT NULL DEFAULT '',
   `uid` int(10) unsigned NOT NULL,
   `visible` tinyint(1) NOT NULL DEFAULT '0',
   `deleted` tinyint(1) NOT NULL DEFAULT '0',
@@ -432,7 +433,8 @@ CREATE TABLE IF NOT EXISTS `group` (
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
   KEY `visible` (`visible`),
-  KEY `deleted` (`deleted`)
+  KEY `deleted` (`deleted`),
+  KEY `hash` (`hash`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `group_member` (
@@ -708,6 +710,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,
+  `size` int(10) unsigned NOT NULL DEFAULT '0',
   `data` mediumblob NOT NULL,
   `scale` tinyint(3) NOT NULL,
   `profile` tinyint(1) NOT NULL DEFAULT '0',
@@ -724,7 +727,8 @@ CREATE TABLE IF NOT EXISTS `photo` (
   KEY `type` (`type`),
   KEY `contact-id` (`contact-id`),
   KEY `aid` (`aid`),
-  KEY `xchan` (`xchan`)
+  KEY `xchan` (`xchan`),
+  KEY `size` (`size`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `profile` (
-- 
cgit v1.2.3

