Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. ALTER TABLE `fg_vehicles`
  2. CHANGE `color` `color` longtext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'JSON z kolorem' AFTER `z`,
  3. CHANGE `plate` `plate` varchar(8) COLLATE 'utf8_general_ci' NOT NULL DEFAULT 'BRAK' AFTER `color`,
  4. CHANGE `damage` `damage` longtext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'JSON z obrażeniami' AFTER `plate`,
  5. CHANGE `owner` `owner` int(11) NOT NULL COMMENT 'type 1 - uid postaci, type 2 - uid grupy, type 3 - uid pracy' AFTER `damage`,
  6. CHANGE `ownerType` `ownerType` smallint NOT NULL COMMENT '1 - gracz, 2 - grupa, 3 - praca' AFTER `owner`,
  7. CHANGE `tuning` `tuning` longtext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'JSON z tuningiem' AFTER `ownerType`,
  8. CHANGE `fuel` `fuel` int(11) NOT NULL COMMENT '0 - 100' AFTER `rotz`,
  9. CHANGE `distance` `distance` bigint NOT NULL COMMENT 'przebieg w metrach' AFTER `fuel`,
  10. CHANGE `variants` `variants` longtext COLLATE 'utf8_general_ci' NOT NULL COMMENT 'JSON z wariantami' AFTER `distance`,
  11. CHANGE `block` `block` tinyint NOT NULL DEFAULT '0' COMMENT '0 - nie, 1 -tak' AFTER `variants`,
  12. CHANGE `description` `description` text(300) COLLATE 'utf8_general_ci' NOT NULL AFTER `block`,
  13. CHANGE `hp` `hp` int(4) NOT NULL DEFAULT '1000' AFTER `description`,
  14. CHANGE `spawn` `spawn` tinyint NOT NULL DEFAULT '0' COMMENT '0 - nie, 1 - tak' AFTER `hp`,
  15. CHANGE `special` `special` tinyint NOT NULL DEFAULT '0' COMMENT '0 - nie, 1 - tak' AFTER `spawn`,
  16. CHANGE `temp` `temp` tinyint NOT NULL DEFAULT '0' COMMENT '0 - nie, 1 - tak' AFTER `special`,
  17. ADD `assignBy` int(11) NOT NULL COMMENT 'UID postaci która przypisała pojazd';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement