phorge-phorge/resources/sql/patches/20130103.filemetadata.sql at master - revi-archive/phorge-phorge - SiliconForest Atelier

revi-archive/phorge-phorge

mirror of https://we.phorge.it/source/phorge.git synced 2024-09-19 16:58:48 +02:00

Mailson Menezes 712e22208c Store width and height metadata of image files

Summary: Also provide a way to update old files metadata.

Test Plan: Create a revision which includes a image file. Check whether the widht, height metadata exists. Run `scripts/files/manage_files.php metadata --all` to update previously uploaded files.

Reviewers: epriestley

Reviewed By: epriestley

CC: aran, Korvin

Maniphest Tasks: T2101

Differential Revision: https://secure.phabricator.com/D4347

2013-01-07 09:46:43 -08:00

5 lines

160 B

SQL

Raw Permalink Blame History

 ALTER TABLE {$NAMESPACE}_file.file
   ADD metadata LONGTEXT COLLATE utf8_bin NOT NULL;
 UPDATE {$NAMESPACE}_file.file
   SET metadata = '{}' WHERE metadata = '';