WikiStart: polnenje.sql

insert into pilots  (pilot_id, pilot_name, first_name, last_name, birth_date, email, password, member_since, bio)
        values  (1, 'bnikov', 'Bojan', 'Nikov', '2000-09-25', 'nikov.bojan@gmail.com', 'admin', '2022-01-01', null),
                        (2, 'johnFPV', 'John', 'Johnson', '1971-11-27', 'john_fpv@gmail.com', 'johnismyname', '2022-02-01', 'I am John'),
                        (3, 'MrSteele', 'Steele', 'Davis', '1980-05-11', 'mrsteele@yahoo.com', 'drones123', '2022-01-02', ':)');
                        


insert into pilot_videos(pilot_id, video_id, video_link)
        values  (1, 1, 'https://www.youtube.com/watch?v=uaV_650oheY'),
                        (1, 2, 'https://www.youtube.com/watch?v=tA5Y1Ic0vk0');
                        

insert into organizers(organizer_id, organizer_name)
        values  (1, 'FAI'),
                        (2, 'MultiGP'),
                        (3, 'DroneRacingLeague'),
                        (4, 'DroneChampionsLeague');
                        

                        
insert into drones(drone_id, motors, esc, frame, flight_controller, battery, drone_pilot_id)
        values  (1, 'Tmotor V2 1950KV', 'HobbyWing 60A ESC', 'MCK Frame', 'Furious FPV RacePit FC', 'Lumenier 1250MAH 6S 120C', 1), 
                        (2, 'Ethix Mr Steele 2306 1750kv V3', 'FETtec 45A', 'ImpulseRC Mr.Steele Apex', 'FETtec KISS F7', 'Thunder Power 1100mAh 6S 100C', 3);
                        


insert into countries(country_id, country_name)
        values  (1, 'Macedonia'),
                        (2, 'Serbia'),
                        (3, 'Bulgaria'),
                        (4, 'Germany'),
                        (5, 'Spain'),
                        (6, 'Portugal'),
                        (7, 'South Korea'),
                        (8, 'China'),
                        (9, 'Austria'),
                        (10, 'Switzerland'),
                        (11, 'Belgium'),
                        (12, 'United States'),
                        (13, 'United Arab Emirates'),
                        (14, 'Poland'),
                        (15, 'Lithuania'),
                        (16, 'Czech Republic'),
                        (17, 'Hungary');


insert into cities(city_id, city_name, country_id)
        values  (1, 'Skopje', 1),
                        (2, 'Prilep', 1),
                        (3, 'Bela Crkva', 2),
                        (4, 'Plovdiv', 3),
                        (5, 'Kyustendil', 3),
                        (6, 'Sofia', 3),
                        (7, 'Nordlingen', 4), 
                        (8, 'Barcelona', 5),
                        (9, 'Madrid', 5),
                        (10, 'Setubal', 6), 
                        (11, 'Daegu', 7),
                        (12, 'Ningbo',8),
                        (13, 'Shenzhen', 8),
                        (14, 'Vienna', 9),
                        (15, 'Zurich', 10),
                        (16, 'Antwerp', 11),
                        (17, 'Birmingham, Alabama', 12),
                        (18, 'Dubai', 13),
                        (19, 'Warsaw', 14),
                        (20, 'Vilnius', 15),
                        (21, 'Prague', 16),
                        (22, 'Budapest', 17);
        
                


--decode('',' base64')


                        
insert into participants(pilot_id, race_id)
        values  (1, 1),
                        (1, 2),
                        (2, 1),
                        (2, 2),
                        (3, 1),
                        (3, 2);