search

PLOKMJNB / FiveM-Civ-Car-Pack

A big library of civilian cars you can fork or download for your server
281 stars 267 forks source link

SQL for importing vehicles into database #99

Open porterslug opened 2 months ago

porterslug commented 2 months ago

Is there a sql-file availlable so that i can import them all into my database?

MacSyst commented 2 months ago

INSERT INTO vehicle_categories(name, label) VALUES ("aston", "Aston Martin"), ("audi", "Audi"), ("bentley","Bentley"), ("bmw","BMW"), ("bugatti","Bugatti"), ("cadillac", "Cadillac"), ("chevrolet", "Chevrolet"), ("dodge", "Dodge"), ("dacia", "Dacia"), ("ferrari", "Ferrari"), ("ford","Ford"), ("honda", "Honda"), ("italdesign", "Italdesign"), ("jaguar","Jaguar"), ("jeep", "Jeep"), ("koenigsegg", "Koenigsegg"), ("lamborghini", "Lamborghini"), ("lexus", "Lexus"), ("landrover", "Land Rover"), ("lotus", "Lotus"), ("quartz", "Quartz"), ("maserati", "Maserati"), ("mazda", "Mazda"), ("mclaren","McLaren"), ("mercedesbenz", "Mercedes-Benz"), ("mercedesamg", "Mercedes-AMG"), ("mitsubishi", "Mitsubishi"), ("nissan", "Nissan"), ("porsche","Porsche"), ("peugeot", "Peugeot"), ("rangerover","Range Rover"), ("renault", "Renault"), ("rollsroyce", "Rolls-Royce"), ("subaru", "Subaru"), ("suzuki", "Suzuki"), ("tesla", "Tesla"), ("toyota", "Toyota"), ("volkswagen", "Volkswagen"), ("volvo", "Volvo"), ("wmotors", "W-Motors") ;

INSERT INTO vehicles(name, model, price, category) VALUES ("Acura TL Type-S", "tltypes", 24000, "aston"), ("2013 Aston Martin Vanquish", "ast", 24000, "aston"), ("Aston Martin DBX Carbon Edition", "amdbx", 24000, "aston"), ("2017 Audi A4 Quattro ABT","aaq4",24000,"audi"), ("2020 Audi Q8 50TDI","q820",15000,"audi"), ("2013 Audi R8 V10","r8ppi",19000,"audi"), ("2020 Audi R8","r820",55000,"audi"), ("2016 Audi RS6 C7","rs6",35000,"audi"), ("2020 Audi RS7","rs72020",28000,"audi"), ("2016 Audi SQ7","sq72016",30000,"audi"), ("2010 Audi TT RS","ttrs",125000,"audi"), ("Bentley Bentayga","bbentayga",20000,"bentley"), ("2020 Bentley Continental GT Convertible","cgts",30000,"bentley"), ("2004 BMW 760Li Individual (E66/PFL)","760li04",40000,"bmw"), ("2016 BMW M2","m2",12500,"bmw"), ("1997 BMW M3 E36","m3e36",18000,"bmw"), ("2008 BMW M3 e92","m3e92",20000,"bmw"), ("BMW X6M F16","x6m",20000,"bmw"), ("BMW X5 E53 2005 Sport Package","x5e53",20000,"bmw"), ("2015 BMW i8 (I12)","i8",20000,"bmw"), ("2015 BMW M3 (F80)","m3f80",25000,"bmw"), ("2018 BMW M5 F90","bmci",20000,"bmw"), ("2015 BMW M4 F82","m4f82",11500,"bmw"), ("BMW M6 F13 Shadow Line","m6f13",16000,"bmw"), ("2019 BMW Z4 M40i","z419",14000,"bmw"), ("2020 Bugatti Bolide","bolide",12500,"bugatti"), ("2016 Cadillac ATS-V Coupe","cats",7200,"cadillac"), ("2021 Cadillac Escalade","cesc21",8000,"cadillac"), ("2009 Chevrolet Tahoe","09tahoe",18000,"chevrolet"), ("2015 Chevrolet Tahoe","15tahoe",10000,"chevrolet"), ("2020 Chevrolet Camaro SS","2020ss",10000,"chevrolet"), ("2017 Chevrolet Camaro RS","camrs17",12000,"chevrolet"), ("2021 Chevrolet Tahoe RST","tahoe21",45000,"chevrolet"), ("Chevrolet Corvette C5 Z06","corvettec5z06",32000,"chevrolet"), ("2009 Chevrolet Corvette ZR1","czr1",19000,"chevrolet"), ("2014 Chevrolet Corvette C7 Stingray","c7",29000,"chevrolet"), ("2020 Chevrolet Corvette C8 Stingray","stingray",42000,"chevrolet"), ("2016 Dodge Charger","16charger",45000,"dodge"), ("1999 Dodge Viper GTS ACR","99viper",6500,"dodge"), ("Dodge Charger Hellcat Widebody 2021","chr20",13000,"dodge"), ("2018 Dodge Challenger SRT Demon","demon",18000,"dodge"), ("Dodge Challenger Raid","raid",35000,"dodge"), ("2015 Dodge RAM 2500","ram2500",19000,"dodge"), ("Dodge Neon SRT-4","srt4",15000,"dodge"), ("2017 Dodge RAM 1500 Rebel TRX","trx",19500,"dodge"), ("2016 Dodge Challenger","16challenger",12000,"dodge"), ("Dacia logan pickup ","cutlass",12000,"dacia"), ("2008 Dacia Logan","logan",12000,"dacia"), ("Dacia 1310 2001","1310",12000,"dacia"), ("Dacia Sandero 2014","sandero",12000,"dacia"), ("Dacia Sandero Stepway 2014","stepway",12000,"dacia"), ("Ferrari 488 Spider","488",10800,"ferrari"), ("Ferrari F430 Scuderia","f430s",14500,"ferrari"), ("2018 Ferrari 812 Superfast","f812",5500,"ferrari"), ("2015 Ferrari California T","fct",55000,"ferrari"), ("Ferrari FXX-K Hybrid Hypercar","fxxk",8500,"ferrari"), ("2015 Ferrari LaFerrari","laferrari",12000,"ferrari"), ("Ferrari Enzo","mig",6500,"ferrari"), ("458 Italia","yFe458i1",7500,"ferrari"), ("458 Speciale","yFe458i2",8000,"ferrari"), ("458 Spider","yFe458s1",14000,"ferrari"), ("458 Speciale Aperta","yFe458s2",5000,"ferrari"), ("Ferrari F60 America","yFeF12A",25000,"ferrari"), ("Ferrari F12 TRS Roadster","yFeF12T",90000,"ferrari"), ("2012 Ford F150 SVT Raptor R","f150",130000,"ford"), ("2005 Ford GT","fgt",30000,"ford"), ("2017 Ford GT","gt17",4000,"ford"), ("2017 Ford Raptor","raptor2017",40000,"ford"), ("2021 Ford Bronco Wildtrak","wildtrak",60000,"ford"), ("Honda CRX SiR 1991","honcrx91",55000,"honda"), ("1992 Honda NSX-R (NA1)","na1",70000,"honda"), ("Honda S2000 AP2","ap2",45000,"honda"), ("2018 Honda Civic Type-R (FK8)","fk8",60000,"honda"), ("2017 Italdesign Zerouno","it18",17000,"italdesign"), ("Jaguar F-pace 2017 Hamann Edition","fpacehm",50000,"jaguar"), ("2012 Jeep Wrangler","jeep2012",47500,"jeep"), ("Jeep Renegade","jeepreneg",40000,"jeep"), ("2015 Jeep SRT-8","srt8",35000,"jeep"), ("2018 Jeep Grand Cherokee","trhawk",16000,"jeep"), ("2017 Koenigsegg Agera RS","agerars",40000,"koenigsegg"), ("Koenigsegg Regera","regera",55000,"koenigsegg"), ("Lamborghini Huracan Super Trofeo","huracanst",29000,"lamborghini"), ("Lamborghini Sesto Elemento","lambose",45000,"lamborghini"), ("2009 Lamborghini Murcielago LP 670-4 SV","lp670sv",25000,"lamborghini"), ("2013 Lamborghini Aventador LP700-4 Roadster","lp700r",32000,"lamborghini"), ("Lamborghini Aventador SVJ","svj63",62000,"lamborghini"), ("Lamborghini Urus","urus",85000,"lamborghini"), ("Lamborghini Veneno","veneno",155000,"lamborghini"), ("Lexus GS 350","gs350",30000,"lexus"), ("2014 Lexus IS 350","is350mod",40000,"lexus"), ("2015 Lexus RCF","rcf",12800,"lexus"), ("1973 Land Rover Range Rover","lrrr",55000,"landrover"), ("2002 Lotus Esprit V8","esprit02",20000,"lotus"), ("Quartz Regalia 723","regalia",80000,"quartz"), ("Maserati Levante","levante",75000,"maserati"), ("1984 Mazda RX-7 Stanced Version","84rx7k",65000,"mazda"), ("2002 Mazda RX-7 FD Drag","dragfd",220000,"mazda"), ("Mazda RX7 FC3S","fc3s",12000,"mazda"), ("Mazda RX-7 FD","majfd",16000,"mazda"), ("1989 Mazda Miata NA","miata3",6500,"mazda"), ("Mazda MX-5 Miata (NA6C)","na6",8500,"mazda"), ("McLaren 650S Coupe","650s",45000,"mclaren"), ("2016 McLaren 675LT Coupe","675lt",120000,"mclaren"), ("2017 McLaren 720S","720s",8000,"mclaren"), ("1996 McLaren F1 GTR","gtr96",45000,"mclaren"), ("2020 McLaren Speedtail","mcst",35000,"mclaren"), ("McLaren MP4-12C","mp412c",55000,"mclaren"), ("2019 McLaren Senna","senna",210000,"mclaren"), ("2020 Mercedes-Benz AMG GT-R Roadster","amggtrr20",60000,"mercedesbenz"), ("2020 Mercedes-AMG C63s","c6320",80000,"mercedesamg"), ("2013 Mercedes-Benz G65 AMG","G65",55000,"mercedesbenz"), ("2019 Mercedes-Benz E400 Coupe 4matic (C238)","e400",32000,"mercedesbenz"), ("Mercedes-Benz GL63 AMG","gl63",40000,"mercedesbenz"), ("2012 Mercedes-Benz C63 AMG Coupe Black Series","mbc63",42000,"mercedesbenz"), ("2014 Mercedes-Benz S500 W222","s500w222",55000,"mercedesbenz"), ("1995 Mercedes-Benz SL500","sl500",38000,"mercedesbenz"), ("Mercedes-Benz V-class 250 Bluetec LWB","v250",35000,"mercedesbenz"), ("Mitsubishi Lancer Evo VI T.M.E (CP9A)","cp9a",32000,"mitsubishi"), ("Mitsubishi FTO GP Version-R","fto",40000,"mitsubishi"), ("Nissan 180SX Type-X","180sx",95000,"nissan"), ("2017 Nissan GTR","gtr",125000,"nissan"), ("2017 R35 Nissan GTR Convertible","gtrc",36000,"nissan"), ("Nissan Fairlady Z Z33","maj350",45000,"nissan"), ("Nissan Silvia S15 Spec-R","nis15",65000,"nissan"), ("2017 Nissan Titan Warrior","nissantitan17",80000,"nissan"), ("Nissan 350z Stardast","ns350",60000,"nissan"), ("Nissan 370z Pandem","nzp",70000,"nissan"), ("1998 Nissan Silvia K","s14",55000,"nissan"), ("1997 Nissan Patrol Super Safari Y60","Safari97",12000,"nissan"), ("Nissan Skyline GT-R (BNR34)","skyline",20000,"nissan"), ("Nissan 300ZX Z32","z32",75000,"nissan"), ("1978 Porsche 935 Moby Dick","maj935",65000,"porsche"), ("2018 Porsche Cayenne S","pcs18",65000,"porsche"), ("Porsche 718 Cayman S","718caymans",80000,"porsche"), ("2003 Porsche Carrera GT (980)","cgt",38500,"porsche"), ("2019 Porsche Macan Turbo","pm19",55000,"porsche"), ("2020 Porsche Taycan Turbo S","taycan",45000,"porsche"), ("Peugeot 205 Turbo 16", "yPG205t16B",45000,"peugeot"), ("Peugeot 205 Rally", "yPG205t16A",45000,"peugeot"), ("Renault Twingo I", "twingo", 45000, "renault"), ("Range Rover Evoque","rrevoque",40000,"rangerover"), ("Range Rover Vogue Startech","rrst",65000,"rangerover"), ("2016 Range Rover Sport SVR","rsvr16",135000,"rangerover"), ("2016 Rolls-Royce Dawn Onyx","dawnonyx",38000,"rollsroyce"), ("Rolls-Royce Wraith","wraith",30000,"rollsroyce"), ("Rolls Royce Cullinan","rculi",40000,"rollsroyce"), ("2018 Rolls-Royce Phantom VIII","rrphantom",70000,"rollsroyce"), ("2008 Subaru WRX STi","subisti08",65000,"subaru"), ("2004 Subaru Impreza WRX STI","subwrx",130000,"subaru"), ("1996 Subaru Alcyone SVX","svx",35000,"subaru"), ("2019 Suzuki GSX-R1000R","gsxr19",28000,"suzuki"), ("2019 Suzuki Katana","katana",35000,"suzuki"), ("2020 Tesla Roadster","tr22",45000,"tesla"), ("Tesla Model X Performance","p90d",50000,"tesla"), ("2016 Tesla Model S P90D","models",39500,"tesla"), ("2018 Tesla Model 3","tmodel",15000,"tesla"), ("2016 Tesla Model X P90D","teslax",50000,"tesla"), ("2017 Tesla Model S","teslapd",40000,"tesla"), ("2018 Toyota Camry XSE","cam8tun",70000,"toyota"), ("2016 Toyota Land Cruiser VXR","vxr",900000,"toyota"), ("1998 Toyota Supra Turbo (A80)","toysupmk4",255000,"toyota"), ("Toyota Mark II JZX100","mk2100",90000,"toyota"), ("2015 Volkswagen Golf GTI MK7","golfgti7",375000,"volkswagen"), ("2016 Volkswagen Passat B8","passat",375000,"volkswagen"), ("Volkswagen Scirocco R 2011","vwr",375000,"volkswagen"), ("2018 Volkswagen Amarok V6","amarok",375000,"volkswagen"), ("Volvo XC90 T8","xc90",425000,"volvo"), ("W-Motors Fenyr Supersport","wmfenyr",220000,"wmotors"), ("W-Motors Lykan HyperSport","lykan",185000,"wmotors")

;