X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=222a757ff0126d2517f8f61efed5d2ac6972f17c;hp=33856cb0bdfb34a215ab5c6613813a8c048cc0ac;hb=8445737a73b7ebd3a3e917cbd098eba6146f58a7;hpb=7384463f70820261ab36aa806ad8a98eba39bdbf

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);