From 3586723af798396fd072c2e7ee4dd6390c2fea1b Mon Sep 17 00:00:00 2001 From: friendica 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') 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