ALTER TABLE Office ADD COLUMN role varchar(32) NOT NULL DEFAULT '';
ALTER TABLE Office ADD COLUMN country VARCHAR(4) NULL;
+ALTER TABLE Office ADD COLUMN display_name VARCHAR(4) NULL;
CREATE TABLE Person (
id int(11) NOT NULL auto_increment,
ALTER TABLE Images ADD COLUMN descript TEXT DEFAULT '' NOT NULL;
ALTER TABLE Images ADD COLUMN title VARCHAR(128) DEFAULT '' NOT NULL;
-ALTER TABLE Images ALTER COLUMN mimetype mimetype varchar(128) NOT NULL default '';
+ALTER TABLE Images CHANGE COLUMN mimetype mimetype varchar(128) NOT NULL default '';
ALTER TABLE Images ADD INDEX lookup(ontable, onid);