SHARE
TWEET

Untitled

a guest May 10th, 2018 110 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SET SQL_SAFE_UPDATES=0;
  2. SET FOREIGN_KEY_CHECKS=0;
  3. UPDATE player SET name = CONCAT('"', name, '"') ;
  4. UPDATE clan SET name = CONCAT('"', name, '"') ;
  5. UPDATE account SET name = CONCAT('"', name, '"') ;
  6. UPDATE clan_map_marker SET label = CONCAT('"', label, '"') ;
  7. UPDATE territory SET name = CONCAT('"', name, '"') ;
  8. ALTER TABLE account
  9. CHANGE COLUMN score score INT(11) NOT NULL DEFAULT 0,
  10. CHANGE COLUMN locker locker INT(11) NOT NULL DEFAULT 0;
  11. ALTER TABLE construction
  12. ADD INDEX territory_id (territory_id);
  13.  
  14. ALTER TABLE construction
  15. ADD CONSTRAINT construction_ibfk_2 FOREIGN KEY (territory_id)
  16. REFERENCES territory(id) ON DELETE CASCADE ON UPDATE RESTRICT;
  17.  
  18. ALTER TABLE container
  19. ADD INDEX territory_id (territory_id);
  20. ALTER TABLE container
  21. ADD CONSTRAINT container_ibfk_2 FOREIGN KEY (territory_id)
  22. REFERENCES territory(id) ON DELETE CASCADE ON UPDATE RESTRICT;
  23. ALTER TABLE player
  24. CHANGE COLUMN money money INT(11) UNSIGNED NOT NULL DEFAULT 0;
  25. ALTER TABLE player
  26. DROP PRIMARY KEY,
  27. ADD PRIMARY KEY (id);
  28. ALTER TABLE territory
  29. ADD INDEX flag_stolen_by_uid (flag_stolen_by_uid);
  30. ALTER TABLE territory
  31. ADD CONSTRAINT territory_ibfk_2 FOREIGN KEY (flag_stolen_by_uid)
  32. REFERENCES account(uid) ON DELETE SET NULL ON UPDATE RESTRICT;
  33. ALTER TABLE vehicle
  34. CHANGE COLUMN hitpoints hitpoints TEXT NOT NULL,
  35. CHANGE COLUMN cargo_items cargo_items TEXT NOT NULL,
  36. CHANGE COLUMN cargo_magazines cargo_magazines TEXT NOT NULL,
  37. CHANGE COLUMN cargo_weapons cargo_weapons TEXT NOT NULL,
  38. CHANGE COLUMN cargo_container cargo_container TEXT NOT NULL,
  39. CHANGE COLUMN vehicle_texture vehicle_texture TEXT NOT NULL;
  40. ALTER TABLE vehicle
  41. ADD INDEX vehicle_ibfk_2_idx (territory_id);
  42. ALTER TABLE vehicle
  43. ADD CONSTRAINT vehicle_ibfk_2 FOREIGN KEY (territory_id)
  44. REFERENCES territory(id) ON DELETE CASCADE ON UPDATE RESTRICT;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top