From 8445737a73b7ebd3a3e917cbd098eba6146f58a7 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 28 Feb 2013 14:25:14 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 33856cb0..222a757f 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -294,7 +294,8 @@ ALTER TABLE Images ADD COLUMN descript TEXT DEFAULT '' NOT NULL; ALTER TABLE Images ADD COLUMN title VARCHAR(128) DEFAULT '' NOT NULL; ALTER TABLE Images CHANGE COLUMN mimetype mimetype varchar(128) NOT NULL default ''; -ALTER TABLE Images ALTER COLUMN mimetype varchar(128) NOT NULL default ''; +-- postgres +ALTER TABLE Images ALTER COLUMN mimetype TYPE varchar(128) ; ALTER TABLE Images ADD INDEX lookup(ontable, onid); -- 2.39.2