SET SQL_SAFE_UPDATES=0;
SET FOREIGN_KEY_CHECKS=0;
UPDATE player SET name = CONCAT('"', name, '"') ;
UPDATE clan SET name = CONCAT('"', name, '"') ;
UPDATE account SET name = CONCAT('"', name, '"') ;
UPDATE clan_map_marker SET label = CONCAT('"', label, '"') ;
UPDATE territory SET name = CONCAT('"', name, '"') ;
ALTER TABLE account
CHANGE COLUMN score score INT(11) NOT NULL DEFAULT 0,
CHANGE COLUMN locker locker INT(11) NOT NULL DEFAULT 0;
ALTER TABLE construction
ADD INDEX territory_id (territory_id);

ALTER TABLE construction
ADD CONSTRAINT construction_ibfk_2 FOREIGN KEY (territory_id)
REFERENCES territory(id) ON DELETE CASCADE ON UPDATE RESTRICT;

ALTER TABLE container
ADD INDEX territory_id (territory_id);
ALTER TABLE container
ADD CONSTRAINT container_ibfk_2 FOREIGN KEY (territory_id)
REFERENCES territory(id) ON DELETE CASCADE ON UPDATE RESTRICT;
ALTER TABLE player
CHANGE COLUMN money money INT(11) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE player
DROP PRIMARY KEY,
ADD PRIMARY KEY (id);
ALTER TABLE territory
ADD INDEX flag_stolen_by_uid (flag_stolen_by_uid);
ALTER TABLE territory
ADD CONSTRAINT territory_ibfk_2 FOREIGN KEY (flag_stolen_by_uid)
REFERENCES account(uid) ON DELETE SET NULL ON UPDATE RESTRICT;
ALTER TABLE vehicle
CHANGE COLUMN hitpoints hitpoints TEXT NOT NULL,
CHANGE COLUMN cargo_items cargo_items TEXT NOT NULL,
CHANGE COLUMN cargo_magazines cargo_magazines TEXT NOT NULL,
CHANGE COLUMN cargo_weapons cargo_weapons TEXT NOT NULL,
CHANGE COLUMN cargo_container cargo_container TEXT NOT NULL,
CHANGE COLUMN vehicle_texture vehicle_texture TEXT NOT NULL;
ALTER TABLE vehicle
ADD INDEX vehicle_ibfk_2_idx (territory_id);
ALTER TABLE vehicle
ADD CONSTRAINT vehicle_ibfk_2 FOREIGN KEY (territory_id)
REFERENCES territory(id) ON DELETE CASCADE ON UPDATE RESTRICT;