ALTER TABLE Person ADD COLUMN phone_mobile varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Person ADD COLUMN phone_direct varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN honor varchar(32) NOT NULL DEFAULT '';
# old mysql
alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;
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);