Guest User

Fixed transistep.sql

a guest
Dec 2nd, 2019
833
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.55 KB | None | 0 0
  1. INSERT INTO `addon_account` (name, label, shared) VALUES
  2.     ('society_transistep', 'Transistep', 1)
  3. ;
  4.  
  5. INSERT INTO `addon_inventory` (name, label, shared) VALUES 
  6.     ('society_transistep', 'Transistep', 1),
  7.     ('society_transistep_depot', 'Transistep Dépôt', 1)
  8. ;
  9.  
  10. INSERT INTO `datastore` (name, label, shared) VALUES
  11.     ('society_transistep', 'Transistep', 1)
  12. ;
  13.  
  14. INSERT INTO `jobs` (name, label) VALUES
  15.     ('transistep', 'Transistep')
  16. ;
  17.  
  18. INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
  19.     ('transistep', 0, 'recrue', 'Recrue', 0, '{}', '{}'),
  20.     ('transistep', 1, 'transporter', 'Transporteur', 0, '{}', '{}'),
  21.     ('transistep', 2, 'boss', 'Boss', 0, '{}', '{}')
  22. ;
  23.  
  24. CREATE TABLE `convoy_list`
  25. (
  26.     id         INT(11) NOT NULL
  27. );
  28.  
  29. INSERT INTO `convoy_list` (id) VALUES
  30.     (1),
  31.     (2),
  32.     (3),
  33.     (4),
  34.     (5),
  35.     (6),
  36.     (7),
  37.     (8); -- add as many as you want
  38.  
  39. CREATE TABLE `convoy_registered_list`
  40. (
  41.     `convoy_id`         INT(11) NOT NULL,
  42.     `identifier`        VARCHAR(60) NOT NULL,
  43.     `is_trailer_stored` BOOLEAN,
  44.     `is_paid`           BOOLEAN
  45. );
  46.  
  47. -- Only if you are not using my customized esx_advanced_garage
  48. -- -> https://github.com/Skulrag/unknown-story/tree/master/resources/%5Bscripts%5D/%5Bdivers%5D/esx_advancedgarage
  49.  
  50. -- ALTER TABLE owned_vehicles
  51. -- ADD put_by varchar(255),
  52. --     in_garage_type varchar(255);
  53.  
  54. -- /!\ Make sure you have all these columns in owned_vehicles => owner, vehicle, plate, type, job, stored, in_garage_type, put_by
Advertisement
Add Comment
Please, Sign In to add comment