X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fimages.sql;h=c0c24de07d72ab599e0067aa1800312f34f0203b;hb=ec67426680980f9c41cc9568f33cb9af217331de;hp=6c95d7abed24335708329ad1a10c3837d72bd5f9;hpb=6ac2236239966a401c45c89867b81f1e4f68d0f5;p=Pman.Core 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);