From: Alan Knowles Date: Thu, 14 Jul 2016 05:33:55 +0000 (+0800) Subject: sql/images.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=ec67426680980f9c41cc9568f33cb9af217331de sql/images.sql --- diff --git a/sql/images.sql b/sql/images.sql index 6c95d7ab..c0c24de0 100644 --- a/sql/images.sql +++ b/sql/images.sql @@ -23,7 +23,7 @@ ALTER TABLE Images ADD COLUMN title VARCHAR(128) DEFAULT '' NOT NULL; ALTER TABLE Images CHANGE COLUMN mimetype mimetype varchar(128) NOT NULL default ''; --- postgres +-- postgres (need better way to support this..) -- ALTER TABLE Images ALTER COLUMN mimetype TYPE varchar(128) ; ALTER TABLE Images ADD INDEX lookup(ontable, onid);