The following queries were executed
location module
Update #6301
	•	DROP TABLE {cache_location}
	•	CREATE TABLE {cache_location} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
	•	UPDATE {location} SET latitude = 0.0 WHERE latitude IS NULL
	•	UPDATE {location} SET longitude = 0.0 WHERE longitude IS NULL
	•	Failed: ALTER TABLE {location} DROP PRIMARY KEY
	•	Failed: ALTER TABLE {location} CHANGE lid `lid` INT unsigned NOT NULL auto_increment, ADD PRIMARY KEY (lid)
	•	ALTER TABLE {location} CHANGE name `name` VARCHAR(255) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE street `street` VARCHAR(255) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE additional `additional` VARCHAR(255) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE city `city` VARCHAR(255) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE province `province` VARCHAR(16) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE postal_code `postal_code` VARCHAR(16) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE country `country` CHAR(2) NOT NULL DEFAULT ''
	•	ALTER TABLE {location} CHANGE latitude `latitude` DECIMAL(10, 6) NOT NULL DEFAULT 0
	•	ALTER TABLE {location} CHANGE longitude `longitude` DECIMAL(10, 6) NOT NULL DEFAULT 0
	•	ALTER TABLE {location} CHANGE source `source` TINYINT NOT NULL DEFAULT 0
	•	Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_nid_idx
	•	Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_vid_idx
	•	Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_uid_idx
	•	Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_genid_idx
	•	Failed: ALTER TABLE {location_instance} DROP INDEX {location_instance}_lid_idx
	•	UPDATE {location_instance} SET nid = 0 WHERE nid IS NULL
	•	UPDATE {location_instance} SET vid = 0 WHERE vid IS NULL
	•	UPDATE {location_instance} SET uid = 0 WHERE uid IS NULL
	•	UPDATE {location_instance} SET genid = '' WHERE genid IS NULL
	•	ALTER TABLE {location_instance} CHANGE nid `nid` INT unsigned NOT NULL DEFAULT 0
	•	ALTER TABLE {location_instance} CHANGE vid `vid` INT unsigned NOT NULL DEFAULT 0
	•	ALTER TABLE {location_instance} CHANGE uid `uid` INT unsigned NOT NULL DEFAULT 0
	•	ALTER TABLE {location_instance} CHANGE genid `genid` VARCHAR(255) NOT NULL DEFAULT ''
	•	ALTER TABLE {location_instance} CHANGE lid `lid` INT unsigned NOT NULL DEFAULT 0
	•	Failed: ALTER TABLE {location_instance} ADD INDEX nid (nid)
	•	Failed: ALTER TABLE {location_instance} ADD INDEX vid (vid)
	•	Failed: ALTER TABLE {location_instance} ADD INDEX uid (uid)
	•	Failed: ALTER TABLE {location_instance} ADD INDEX genid (genid)
	•	Failed: ALTER TABLE {location_instance} ADD INDEX lid (lid)
	•	Failed: ALTER TABLE {zipcodes} DROP PRIMARY KEY