Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement