From 6ac2236239966a401c45c89867b81f1e4f68d0f5 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 14 Jul 2016 13:33:41 +0800 Subject: [PATCH] sql/images.sql --- sql/images.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/sql/images.sql b/sql/images.sql index 8130f884..6c95d7ab 100644 --- a/sql/images.sql +++ b/sql/images.sql @@ -7,7 +7,7 @@ CREATE TABLE Images ( ALTER TABLE Images ADD COLUMN filename varchar(255) NOT NULL default ''; ALTER TABLE Images ADD COLUMN ontable varchar(32) NOT NULL default ''; ALTER TABLE Images ADD COLUMN onid int(11) NOT NULL default '0'; -ALTER TABLE Images ADD COLUMN mimetype varchar(64) NOT NULL default ''; +ALTER TABLE Images ADD COLUMN mimetype varchar(128) NOT NULL default ''; ALTER TABLE Images ADD COLUMN width int(11) NOT NULL default '0'; ALTER TABLE Images ADD COLUMN height int(11) NOT NULL default '0'; ALTER TABLE Images ADD COLUMN filesize int(11) NOT NULL default '0'; @@ -22,8 +22,9 @@ 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 ''; + -- postgres -ALTER TABLE Images ALTER COLUMN mimetype TYPE varchar(128) ; +-- ALTER TABLE Images ALTER COLUMN mimetype TYPE varchar(128) ; ALTER TABLE Images ADD INDEX lookup(ontable, onid); -- 2.39.2