X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=7b3156f6f7c8d4cab53fa3898ca4759836b7eb5b;hb=6753eeab8b2f28c0736d0ba446e3b6f854aa1ec2;hp=bbe1e655729e0dc6f431689d97871cd4fb16da0c;hpb=04450bbbd4a490e29c2295ab0c11e3dcb6e9bc95;p=friendica.git

diff --git a/database.sql b/database.sql
index bbe1e65572..7b3156f6f7 100644
--- a/database.sql
+++ b/database.sql
@@ -1088,6 +1088,7 @@ CREATE TABLE IF NOT EXISTS `photo` (
 	`height` smallint unsigned NOT NULL DEFAULT 0 COMMENT '',
 	`width` smallint unsigned NOT NULL DEFAULT 0 COMMENT '',
 	`datasize` int unsigned NOT NULL DEFAULT 0 COMMENT '',
+	`blurhash` varbinary(255) COMMENT 'BlurHash representation of the photo',
 	`data` mediumblob NOT NULL COMMENT '',
 	`scale` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '',
 	`profile` boolean NOT NULL DEFAULT '0' COMMENT '',
@@ -1313,6 +1314,7 @@ CREATE TABLE IF NOT EXISTS `post-media` (
 	`height` smallint unsigned COMMENT 'Height of the media',
 	`width` smallint unsigned COMMENT 'Width of the media',
 	`size` bigint unsigned COMMENT 'Media size',
+	`blurhash` varbinary(255) COMMENT 'BlurHash representation of the image',
 	`preview` varbinary(512) COMMENT 'Preview URL',
 	`preview-height` smallint unsigned COMMENT 'Height of the preview picture',
 	`preview-width` smallint unsigned COMMENT 'Width of the preview picture',