aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-12-06 20:26:43 -0800
committerfriendica <info@friendica.com>2012-12-06 20:26:43 -0800
commit3586723af798396fd072c2e7ee4dd6390c2fea1b (patch)
tree140d7c47a9858a759cd8685c0c01477627da20e4 /install/database.sql
parenta0a8cde2012d77c8579f476f114b3b280c1d8638 (diff)
downloadvolse-hubzilla-3586723af798396fd072c2e7ee4dd6390c2fea1b.tar.gz
volse-hubzilla-3586723af798396fd072c2e7ee4dd6390c2fea1b.tar.bz2
volse-hubzilla-3586723af798396fd072c2e7ee4dd6390c2fea1b.zip
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);
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql8
1 files changed, 6 insertions, 2 deletions
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` (