INSERT INTO `cities` (`city_id`, `name`) VALUES
(1, 'Sofia'),
(2, 'Varna'),
(3, 'Plovdiv'),
(4, 'Burgas'),
(5, 'Ruse'),
(6, 'Stara Zagora'),
(7, 'Pleven'),
(8, 'Sliven'),
(9, 'Dobrich'),
(10, 'Shumen'),
(11, 'Haskovo'),
(12, 'Pazardzhik'),
(13, 'Yambol'),
(14, 'Pernik'),
(15, 'Blagoevgrad'),
(16, 'Veliko Tarnovo'),
(17, 'Vratsa'),
(18, 'Kardzhali'),
(19, 'Kyustendil'),
(20, 'Gabrovo'),
(21, 'Vidin'),
(22, 'Montana'),
(23, 'Targovishte'),
(24, 'Silistra'),
(25, 'Lovech'),
(26, 'Razgrad'),
(27, 'Smolyan'),
(28, 'Velingrad'),
(29, 'Lom'),
(30, 'Svishtov'),
(31, 'Peshtera'),
(32, 'Panagyurishte'),
(33, 'Berkovitsa'),
(34, 'Pomorie'),
(35, 'Nesebar'),
(36, 'Balchik'),
(37, 'Kozloduy'),
(38, 'Kavarna'),
(39, 'Knezha'),
(40, 'Tutrakan'),
(41, 'Kubrat'),
(42, 'Rakitovo'),
(43, 'Septemvri'),
(44, 'Krumovgrad'),
(45, 'Dzhebel'),
(46, 'Belene'),
(47, 'Beloslav'),
(48, 'Tervel'),
(49, 'Zlatograd'),
(50, 'Slivnitsa'),
(51, 'General Toshevo'),
(52, 'Devin'),
(53, 'Varshets'),
(54, 'Belogradchik'),
(55, 'Bobov Dol'),
(56, 'Oryahovo'),
(57, 'Sozopol'),
(58, 'Dve Mogili'),
(59, 'Nikopol'),
(60, 'Nedelino'),
(61, 'Godech'),
(62, 'Rudozem'),
(63, 'Slivo Pole'),
(64, 'Zavet'),
(65, 'Sarnitsa'),
(66, 'Primorsko'),
(67, 'Gulyantsi'),
(68, 'Valchedram'),
(69, 'Shabla'),
(70, 'Dragoman'),
(71, 'Mizia'),
(72, 'Kula'),
(73, 'Batak'),
(74, 'Borino'),
(75, 'Tran'),
(76, 'Dospat'),
(77, 'Bregovo'),
(78, 'Borovo'),
(79, 'Medkovets'),
(80, 'Boychinovtsi'),
(81, 'Alfatar'),
(82, 'Krushari'),
(83, 'Drenovets'),
(84, 'Gramada'),
(85, 'Hayredin'),
(86, 'Dimovo'),
(87, 'Brusartsi'),
(88, 'Spasovo'),
(89, 'Novo Selo'),
(90, 'Ivanovo'),
(91, 'Ruzhintsi'),
(92, 'Kirkovo'),
(93, 'Kaynardzha'),
(94, 'Nevestino'),
(95, 'Shiroka Laka'),
(96, 'Chuprene'),
(97, 'Boynitsa'),
(98, 'Makresh'),
(99, 'Madan'),
(100, 'Iskar'),
(101, 'Sitovo'),
(102, 'Tsenovo'),
(103, 'Byala');

INSERT INTO `scooters` (`scooter_id`, `model`, `gps_position`, `is_taken`) VALUES
(1, 'WUDDA', '42.69949879382975, 23.326295399993107', 1),
(2, 'QUKWT', '42.70696401672336, 23.311650717854764', 1),
(3, 'DKSZT', '42.70181705557794, 23.330677807501363', 1),
(4, 'WUJTY', '42.69314086675325, 23.322441781641842', 1),
(5, 'LGAZK', '42.68541541284759, 23.322447043459743', 0),
(6, 'TKNRA', '43.21669714164902, 27.9070699334506', 0),
(7, 'IHEKP', '43.20357049756781, 27.907485325254026', 0),
(8, 'HHQHG', '43.2164247180307, 27.914482881428142', 0),
(9, 'YAKOR', '43.20875571105151, 27.918365416162807', 0),
(10, 'UVEBX', '43.21928924866736, 27.905093988834146', 0),
(11, 'JLQES', '43.19808530936438, 27.913776851222277', 0),
(12, 'IXVHH', '43.21246451263281, 27.902881338469427', 0),
(13, 'RCGUX', '43.210712049882694, 27.904752364030788', 1),
(14, 'TEYKL', '43.2181671728403, 27.914701624964326', 0),
(15, 'SMMDO', '43.220189736056255, 27.904112120020713', 0),
(16, 'YFAZV', '43.22239742322113, 27.906283637838158', 1),
(17, 'MRFDY', '43.212555479734114, 27.909959989484193', 1),
(18, 'UPVCX', '43.21178085440428, 27.920893115791486', 0),
(19, 'HOJID', '43.198321006787786, 27.91669913880141', 0),
(20, 'XUOAT', '43.21428174131044, 27.91526148309477', 1),
(21, 'KHQPU', '43.21532431272467, 27.914852565193563', 1),
(22, 'LMHOS', '43.19954161626924, 27.908411908002442', 0),
(23, 'AYPZF', '43.20799123620979, 27.913066048010947', 0),
(24, 'LBJVC', '43.206807504417206, 27.911781074830298', 1),
(25, 'DGGTX', '43.211069314156724, 27.910770779007727', 0),
(26, 'ZAAVX', '43.20407795666774, 27.921280548246024', 0),
(27, 'TBVHH', '43.20377769230064, 27.92070519846278', 0),
(28, 'SSUUW', '43.21117557467272, 27.91680048896675', 0),
(29, 'MPLAQ', '43.212406154818574, 27.899578392079007', 0),
(30, 'TPCYY', '43.20747292168194, 27.913885089277095', 0),
(31, 'MCOHF', '43.206924664629824, 27.91949524077271', 0),
(32, 'TMJNE', '43.218581474354316, 27.905872457391027', 1),
(33, 'QKBHS', '43.21486973063581, 27.912242461249118', 0),
(34, 'MQCOY', '43.1985185438836, 27.910082794205646', 0),
(35, 'FISNT', '43.21857865388337, 27.909484610016445', 0),
(36, 'DQXSH', '43.20307472132199, 27.902544170930565', 0),
(37, 'LNOMH', '43.2136827240839, 27.91151527681577', 0),
(38, 'WEYDM', '43.219031104234936, 27.899544336031997', 0),
(39, 'SUIBW', '43.205223964873674, 27.91301837892638', 0),
(40, 'VCIMK', '43.199756799104016, 27.905253558993262', 0),
(41, 'BTYXH', '43.21240134216846, 27.900548194482386', 0),
(42, 'HIUOH', '42.15529938583142, 24.753864020862505', 0),
(43, 'YVZTY', '42.14172367370931, 24.74468397163036', 0),
(44, 'MGBHK', '42.14550196872569, 24.747676252887782', 0),
(45, 'GZDNV', '42.1384358648737, 24.74978337451609', 1),
(46, 'JHGQE', '42.13225588606338, 24.746031432031156', 1),
(47, 'CMHBR', '42.13005599149738, 24.75300522485964', 0),
(48, 'ULBUZ', '42.146607484973735, 24.747164262154808', 0),
(49, 'EUEWF', '42.1348048659059, 24.759227386856434', 0),
(50, 'IERUQ', '42.15334186397215, 24.743648045410357', 0),
(51, 'QTBEE', '42.13673307234142, 24.759667659250916', 0),
(52, 'HGGUQ', '42.14303033068649, 24.75173696194596', 0),
(53, 'PUNYM', '42.13840623760223, 24.743519706344845', 0),
(54, 'AWTYO', '42.153541276215854, 24.751848979413612', 1),
(55, 'VGRAA', '42.140275104568126, 24.739710560642205', 0),
(56, 'IDLCX', '42.13207519602868, 24.746176263307316', 0),
(57, 'OVFHQ', '42.152890925914726, 24.739215584839393', 0),
(58, 'SGVAK', '42.1318515945114, 24.75513343755688', 0),
(59, 'YOKET', '42.14408642347324, 24.760625473161', 0),
(60, 'ZGPZB', '42.13726971226735, 24.744269732376996', 0),
(61, 'FBJOP', '42.13341088761437, 24.751609948224687', 0),
(62, 'WFWHY', '42.147074262131426, 24.74036649436271', 0),
(63, 'DTNKT', '42.14202998246269, 24.738384375826204', 0),
(64, 'OEFLO', '42.13270177747428, 24.751914559141795', 0),
(65, 'SOGQB', '42.13102708107644, 24.750521168780125', 1),
(66, 'LTOLT', '42.150480183920486, 24.74773057852163', 1),
(67, 'HGMBR', '42.137556007337814, 24.76082855280723', 0),
(68, 'NLZRA', '42.15171298827997, 24.757354614203326', 1),
(69, 'RGQOD', '42.14812295336566, 24.756700069635965', 0),
(70, 'KNFZB', '42.14798966105269, 24.75161715242967', 0),
(71, 'YNCBN', '42.155147165401644, 24.74951518746966', 0),
(72, 'ZQPAJ', '42.14701824124539, 24.76039167195272', 0),
(73, 'MYJYK', '42.14709806103243, 24.75125719206449', 0),
(74, 'ROQYI', '42.147664320467314, 24.736936577868764', 0),
(75, 'RHSEN', '42.1403104817589, 24.739153868556734', 0),
(76, 'ZVXNG', '42.14860235005524, 24.751919571207754', 0),
(77, 'YQOAM', '42.1460989291142, 24.747100148684343', 0),
(78, 'GJVBA', '42.15128349103083, 24.751914863638653', 1),
(79, 'FGLAK', '42.135628616678495, 24.749438232483943', 0),
(80, 'OUAXR', '42.15599410026738, 24.752272070885333', 0),
(81, 'HILBN', '42.14493256435483, 24.73729343848947', 0),
(82, 'BELHZ', '42.13229064743446, 24.7410585479512', 0),
(83, 'UDWSM', '42.14863430331271, 24.74688894707323', 0),
(84, 'DPCQZ', '42.14668236369964, 24.755642923951186', 0),
(85, 'ANLMO', '42.14126266619311, 24.751042536212378', 0),
(86, 'LRGXM', '42.15359619376106, 24.7411037714917', 0),
(87, 'EISQQ', '42.155405169388956, 24.742030785924978', 0),
(88, 'LXYRK', '42.147926718699054, 24.736075756197938', 0),
(89, 'HPQXE', '42.13644764647099, 24.7413865421125', 0),
(90, 'HSLII', '42.148071325836824, 24.758043537602216', 1),
(91, 'JLIXS', '42.13957265337754, 24.73826116273529', 0),
(92, 'MAHWU', '42.499433270875834, 27.45994757474421', 1),
(93, 'HXLWC', '42.49034421551888, 27.47471235339736', 0),
(94, 'SCDGK', '42.50381424261945, 27.45977765360226', 1),
(95, 'QXKHP', '42.50919605404152, 27.461475792003274', 1),
(96, 'HLMBC', '42.50434299242179, 27.45425735359749', 0),
(97, 'JFBGF', '42.500204289141855, 27.469411001805685', 1),
(98, 'QKBKF', '42.50809449486235, 27.45541017075201', 0),
(99, 'UTGBB', '42.501816915354496, 27.456854050417743', 0),
(100, 'SNELL', '42.48833827064731, 27.46805093780653', 1),
(101, 'KNIKV', '42.48930690856691, 27.464382428412033', 0),
(102, 'LCPFL', '43.85289776595947, 25.951720236548248', 0),
(103, 'SRBXW', '43.84369442973793, 25.94110218751328', 0),
(104, 'YFKND', '43.8369070518329, 25.96132070235462', 0),
(105, 'HSGDR', '43.847511182450155, 25.954527501614464', 0),
(106, 'UFAGF', '43.84057104557738, 25.941966797869522', 0),
(107, 'LEPTR', '43.84838842555459, 25.956698693692154', 0),
(108, 'ECLZQ', '43.84800135729171, 25.963657434298607', 0),
(109, 'QEKCX', '43.856440583006794, 25.94805035572165', 0),
(110, 'IGQHT', '43.85341816461174, 25.95730699220213', 0),
(111, 'DPGOI', '43.855914422336525, 25.952176388860117', 0),
(112, 'JOPFZ', '43.834694396212846, 25.96130841853516', 0),
(113, 'LBAUU', '43.84487565940258, 25.945075477868297', 0),
(114, 'ECJLT', '43.849458853675316, 25.959290913759943', 0),
(115, 'TRKMP', '43.830660519456764, 25.958231121607824', 0),
(116, 'AYXGM', '43.84595686136812, 25.9427513288311', 0),
(117, 'SYMIA', '43.850618949083014, 25.951470332486874', 0),
(118, 'WDUZS', '43.84457035656591, 25.94188455770741', 0),
(119, 'LYRTW', '43.84082807273722, 25.9555147535137', 0),
(120, 'GKEKL', '43.84416696154247, 25.953140463832565', 0),
(121, 'YDTOF', '43.84254410049489, 25.94667422178872', 0),
(122, 'CLKFH', '43.85019956100867, 25.942567373190997', 0),
(123, 'ZQLLP', '43.83455701015572, 25.948651206954693', 0),
(124, 'HADEO', '43.84951044342684, 25.947287508649552', 0),
(125, 'NCHHB', '43.84453977434695, 25.945660323795476', 0),
(126, 'SVXKW', '43.84304124372719, 25.94665645472764', 0),
(127, 'JGZLA', '43.8340380183559, 25.952294478758112', 0),
(128, 'KIENZ', '43.841962188696, 25.943624108620966', 0),
(129, 'RVHMR', '43.83816990668702, 25.958730605103568', 0),
(130, 'DRARC', '43.84948112974517, 25.964537368847843', 0),
(131, 'KATUD', '43.83385235728588, 25.946012227766396', 0),
(132, 'QIZUA', '43.84743327314471, 25.957252770271932', 0),
(133, 'JXUHZ', '43.83756906490208, 25.949118882277062', 0),
(134, 'DKZBI', '43.855448231586244, 25.955076969607845', 0),
(135, 'LZPMX', '43.835430411254904, 25.95605075876866', 0),
(136, 'KQUBY', '43.845833730853975, 25.948539801092473', 0),
(137, 'VKQBP', '43.849128828664085, 25.948602123728755', 0),
(138, 'EFTME', '43.85571613593561, 25.948647463476192', 0),
(139, 'VBWDP', '43.852171744311484, 25.946498010497983', 0),
(140, 'GLQHA', '43.85222960585863, 25.9618039594323', 0),
(141, 'UDUEE', '43.85304075112598, 25.964187403875233', 0),
(142, 'IMQRY', '43.84216604366409, 25.94813255413531', 0),
(143, 'NRTHI', '42.42288847316784, 25.636316063751966', 0),
(144, 'BUITN', '42.42992353135946, 25.642406387542593', 0),
(145, 'ARGIT', '42.431419528240276, 25.635923481049655', 1),
(146, 'NETWX', '42.41425407739119, 25.637929264789758', 0),
(147, 'TSVME', '42.430728348293776, 25.635281871188532', 0),
(148, 'ZWMTM', '42.430670001620534, 25.62896111538884', 0),
(149, 'YIJBJ', '42.413922543933836, 25.635745945008633', 0),
(150, 'YGSZC', '42.43757662503304, 25.627445481906797', 0),
(151, 'POKMI', '42.43715046883278, 25.63100099324817', 0),
(152, 'KJFYC', '42.42666553295585, 25.639316535569765', 0),
(153, 'MQSRV', '42.41294942125308, 25.6414797560717', 0),
(154, 'TSUOG', '42.43193849503107, 25.639046031777468', 0),
(155, 'KCHCL', '42.421170814330196, 25.627210034800054', 0),
(156, 'PYKNC', '42.419831062437886, 25.644678652149317', 0),
(157, 'AWYQO', '42.41921011772073, 25.631702525490695', 0),
(158, 'SJCXX', '42.428552243010714, 25.647195349133742', 0),
(159, 'XJMPX', '42.43623552132576, 25.633409682158295', 0),
(160, 'ZBXVI', '42.41922252956819, 25.632020458781884', 0),
(161, 'MHJRR', '42.43452263587867, 25.642441940158182', 0),
(162, 'SMBMC', '42.413129123369266, 25.637806200007585', 0),
(163, 'VRRVY', '42.439537611096554, 25.63741100961649', 0),
(164, 'CAZCO', '42.42641571093246, 25.63800825192773', 1),
(165, 'YSOYC', '42.41711281388149, 25.637211171236384', 0),
(166, 'JPGOA', '42.42818795013905, 25.62128164709134', 0),
(167, 'DQMRA', '42.42441194469231, 25.634644351494938', 0),
(168, 'IKTUT', '42.426228492499476, 25.627334791024172', 0),
(169, 'OSDHH', '42.416883179287964, 25.63797791031691', 0),
(170, 'IJMMA', '42.42035100181656, 25.630867960849734', 0),
(171, 'OHRFJ', '42.41710352254905, 25.630888544667602', 0),
(172, 'EFBAO', '42.42294191371382, 25.629702556914996', 0),
(173, 'ZBGFR', '42.4244809229444, 25.62192264335358', 0),
(174, 'CGPXL', '42.42700514760512, 25.640247164379154', 0),
(175, 'XEXEI', '42.418315833771686, 25.640549659032928', 0),
(176, 'FEUZG', '42.42753292165061, 25.64309143346338', 0),
(177, 'QAKJC', '42.42342746694166, 25.631533041076644', 0),
(178, 'OMIIR', '42.42741653136702, 25.63376627277519', 0),
(179, 'YMJDN', '43.40421063924804, 24.61848178448796', 0),
(180, 'XTNLC', '43.41179473493264, 24.621389389009444', 1),
(181, 'VNNIR', '43.41385973739512, 24.62447694023139', 1),
(182, 'EXQHA', '43.424248988773364, 24.610043148700687', 0),
(183, 'INEEZ', '43.41002642681758, 24.62111442658693', 0),
(184, 'FPEOY', '42.68174204288854, 26.336322364111066', 0),
(185, 'RVAZJ', '42.666545354922015, 26.331741870743564', 1),
(186, 'OTNZU', '43.55253112909812, 27.829851974272852', 0),
(187, 'BQIWL', '43.567895193321746, 27.821279393130347', 0),
(188, 'XHWCN', '43.564400913103945, 27.84448885260585', 0),
(189, 'JFRCA', '43.281934461039526, 26.925863377539496', 0),
(190, 'UMZKL', '43.279112649621744, 26.915834549572594', 0),
(191, 'SXFFS', '43.27676474839193, 26.933759387962198', 0),
(192, 'MYIBZ', '43.26205458627482, 26.91454901702736', 0),
(193, 'FFDEK', '41.9430335992355, 25.555212242659188', 0),
(194, 'OOHOV', '41.93879045755911, 25.552970630102813', 1),
(195, 'TXSBZ', '42.191323356907326, 24.326633299185637', 1),
(196, 'KFEKA', '42.18026314228859, 24.340613776266125', 0),
(197, 'XVYDH', '42.19159602189536, 24.342855275746295', 0),
(198, 'TWAYG', '42.490899218255436, 26.513210196519985', 0),
(199, 'ZEHDR', '42.61463830812224, 23.023096754624653', 1),
(200, 'DRYFD', '42.0047962172868, 23.083097130566568', 0),
(201, 'FCTJX', '43.09475517522079, 25.62661528244752', 0),
(202, 'NIUDJ', '43.08121165941318, 25.638644228574375', 0),
(203, 'SAKSH', '43.07601140154632, 25.627305505708257', 0),
(204, 'ZAVKK', '43.07725638489627, 25.63499974957413', 0),
(205, 'BKRML', '43.0757557474074, 25.622382251486435', 0),
(206, 'ELUQE', '43.20290377590358, 23.53591352149612', 1),
(207, 'ALNWX', '41.63243806763511, 25.36046666138679', 0),
(208, 'CJGOH', '42.272764424122514, 22.680851066996347', 0),
(209, 'YBUFB', '42.2802472350776, 22.69034683833523', 0),
(210, 'ERPKZ', '42.29074127621376, 22.681568035061172', 1),
(211, 'MKOLS', '42.86046276545135, 25.32129872668605', 1),
(212, 'ZOGBR', '42.88009182110856, 25.313565959267866', 0),
(213, 'DVDAM', '43.97768711567002, 22.876457582717002', 0),
(214, 'IHMBX', '43.979543369097804, 22.881819865643795', 0),
(215, 'KCCNQ', '43.9789004481173, 22.873494518026718', 0),
(216, 'TVJOV', '43.97890488953122, 22.88409118383201', 0),
(217, 'DMUHJ', '43.99136653169797, 22.87572348470655', 0),
(218, 'WTVDH', '43.40770931271302, 23.233364577530025', 0),
(219, 'HNHDY', '43.403917769555754, 23.234400421132083', 0),
(220, 'GZDVL', '43.41110266933921, 23.218079614152145', 1),
(221, 'VJLMR', '43.41784004732697, 23.227798370292597', 0),
(222, 'AQVAJ', '43.24968756883493, 26.565624491749563', 0),
(223, 'JFIJV', '43.236732884368486, 26.573784220622017', 0),
(224, 'AMXII', '43.23553671084052, 26.580888212637937', 0),
(225, 'EINJH', '43.24178908695831, 26.56345634390149', 0),
(226, 'NWJXG', '44.11919861512526, 27.24799460732376', 0),
(227, 'AITCS', '44.11188171610634, 27.270958091593407', 0),
(228, 'UKNJG', '44.10962584517327, 27.26455595460693', 0),
(229, 'VUIXC', '44.12079652946083, 27.271450802526353', 0),
(230, 'MHHXB', '44.133005355082844, 27.26074402525443', 0),
(231, 'ODREY', '43.12657574588674, 24.712996485103233', 0),
(232, 'FUFEM', '43.13358534370473, 24.707363254543587', 0),
(233, 'EELGM', '43.14741948970164, 24.719042566309653', 0),
(234, 'FYRNB', '43.12428418425724, 24.720048225357367', 0),
(235, 'DTCKF', '43.515551041762556, 26.527633839533642', 0),
(236, 'ABWFH', '43.52354932285744, 26.52401742548012', 1),
(237, 'ICBBQ', '43.51276516678953, 26.523449070477046', 0),
(238, 'ZYDYB', '43.53835048836716, 26.51581372576051', 0),
(239, 'PGURU', '43.52342263811359, 26.517177104493797', 0),
(240, 'QEFAS', '41.571934041077974, 24.71848854289071', 0),
(241, 'ONFGX', '42.02939837618244, 23.98699396581441', 0),
(242, 'EFQPE', '42.01568501198816, 23.98531570480465', 0),
(243, 'YPEJS', '43.820981801311646, 23.248415163632668', 1),
(244, 'AGNBP', '43.614630895945126, 25.351413062681697', 0),
(245, 'XZFRN', '43.61268864306759, 25.34879952389628', 0),
(246, 'LQSMY', '43.60731308421098, 25.35022164114916', 0),
(247, 'MIJEU', '43.603626949012074, 25.358963260334363', 0),
(248, 'WHVTU', '43.61033460993035, 25.349430903394744', 0),
(249, 'QXEDL', '42.03059302412712, 24.29469462885736', 0),
(250, 'PXTRW', '42.02760101981876, 24.312499576953552', 1),
(251, 'LGZXV', '42.51190527540292, 24.187247614372446', 0),
(252, 'SDXEM', '42.5081203552849, 24.188379856974112', 0),
(253, 'BSXLR', '43.24186505490921, 23.11486068246983', 0),
(254, 'YPNWS', '43.23967623390781, 23.138336535652375', 0),
(255, 'IXSYM', '43.227391055540515, 23.133645319576782', 0),
(256, 'GSNXE', '43.23931713544519, 23.13321615313899', 0),
(257, 'EOABJ', '42.5542755922894, 27.634657074189807', 0),
(258, 'BXPCO', '42.566988187425245, 27.630399592303153', 0),
(259, 'KZLTC', '42.56556030778206, 27.643027242590197', 0),
(260, 'HHNAK', '42.56364015082902, 27.64004603205713', 0),
(261, 'FQYCL', '42.656706986919644, 27.717756608607132', 0),
(262, 'VMPYI', '42.66442540616534, 27.726566744327133', 0),
(263, 'PYPFP', '43.41865909564935, 28.166499585958732', 0),
(264, 'VXBTX', '43.4184468583166, 28.16643135596071', 0),
(265, 'ZISAF', '43.41687507429647, 28.151384388049266', 0),
(266, 'RIUYW', '43.41378594620368, 28.166663582203224', 0),
(267, 'TAZHD', '43.39943006996969, 28.165434281796315', 0),
(268, 'MPULB', '43.77907935394699, 23.738632081151845', 0),
(269, 'MNGEU', '43.4256309398335, 28.330268179709204', 0),
(270, 'EWKMK', '43.482369004702356, 24.08520720681646', 0),
(271, 'ADVPI', '43.50151983519103, 24.07658215503926', 0),
(272, 'UGRIF', '44.03781771051371, 26.606343243148057', 0),
(273, 'MAYKZ', '44.043679927568526, 26.612699178597232', 0),
(274, 'YJWSD', '44.058466530536116, 26.606189462920952', 0),
(275, 'NFIIN', '44.03704928382933, 26.604554621579172', 0),
(276, 'EWYIE', '44.04345376784208, 26.60857348142046', 0),
(277, 'NHGOG', '43.79292824169123, 26.513883497898515', 0),
(278, 'WQJFL', '43.79565900113203, 26.507336922525674', 0),
(279, 'LVFTU', '41.999421528252206, 24.080635390690514', 0),
(280, 'WLZLC', '41.98730942397291, 24.095885116891967', 0),
(281, 'BZSDI', '42.226693485943514, 24.117638030854955', 0),
(282, 'MOWZY', '41.47147927528571, 25.64655789333404', 1),
(283, 'ZJUKI', '41.46258568167851, 25.646865684538035', 0),
(284, 'NYJQH', '41.47521676831771, 25.66434893570505', 0),
(285, 'EEZIQ', '41.50321925594243, 25.300459223011153', 1),
(286, 'OWPQQ', '41.51095694946797, 25.291245279161867', 0),
(287, 'ZQZMM', '41.495155344223406, 25.29095076789307', 0),
(288, 'QGWBU', '43.64273393747131, 25.136760515129183', 0),
(289, 'DGTDX', '43.63815462612272, 25.136326278290902', 0),
(290, 'AYGVH', '43.63920865818835, 25.13558533808191', 0),
(291, 'SSOUR', '43.64507212288044, 25.118548764066894', 0),
(292, 'BXTAN', '43.19822867069692, 27.69837668012845', 0),
(293, 'ADHAT', '43.1856032360867, 27.71181405245559', 0),
(294, 'FCVLZ', '43.19354261870065, 27.693019170167908', 0),
(295, 'RGZXE', '43.184241648733654, 27.714016516058702', 0),
(296, 'KKTWG', '43.762833434828124, 27.39783709356728', 1),
(297, 'XKYYN', '43.75492003444816, 27.38899169953458', 0),
(298, 'GSWII', '43.75433686234624, 27.410857382082813', 0),
(299, 'XZTOK', '43.75187115546278, 27.413335077439907', 0),
(300, 'YUOFH', '43.739997050424776, 27.397916341868086', 0),
(301, 'QTREZ', '41.38052489766429, 25.09668317898964', 0),
(302, 'FEZOU', '41.38102146093602, 25.09341590490482', 0),
(303, 'RGRBZ', '41.376778770981836, 25.0968078562147', 0),
(304, 'XDJWU', '42.851456887593585, 23.045651237684982', 0),
(305, 'FKXSP', '42.844939790696756, 23.04950462772894', 0),
(306, 'CDKKI', '43.71239096245983, 28.037170644533926', 0),
(307, 'DBQQC', '43.69009753579034, 28.031073110752054', 0),
(308, 'BJKTI', '41.749112603121816, 24.40286693692866', 0),
(309, 'FTQSI', '41.75028316506463, 24.408535983409465', 0),
(310, 'BRNZI', '41.732897793445616, 24.406669650841256', 0),
(311, 'NCCTG', '41.744703035292325, 24.408765770131566', 0),
(312, 'CBUSE', '43.19574906376162, 23.298271242957426', 0),
(313, 'UZKQQ', '43.20804519931523, 23.28582074864126', 1),
(314, 'OBTTT', '43.618703171193175, 22.67887354808391', 0),
(315, 'HGWDE', '42.36463265058725, 23.007156764512622', 0),
(316, 'POQKR', '42.35048194287438, 22.9960654987471', 1),
(317, 'ZJPSM', '42.35278425430572, 22.996020839365812', 0),
(318, 'WWJCU', '43.74954838448469, 23.96308364059755', 0),
(319, 'ACNHA', '43.736770822114295, 23.9721096838645', 0),
(320, 'VXHNV', '43.735521852014365, 23.962296569132402', 0),
(321, 'KTKYQ', '42.431686942337535, 27.69113088051144', 1),
(322, 'ZPFLZ', '42.4213457236876, 27.683195066570594', 1),
(323, 'LOKKP', '42.41744382119765, 27.685013287841592', 0),
(324, 'VHMOR', '42.41963726510153, 27.698566500697655', 1),
(325, 'PNRNN', '43.60867337249438, 25.868981296191738', 0),
(326, 'KOGDY', '43.5972978268694, 25.8655515751533', 1),
(327, 'GLDHO', '43.688438061274084, 24.898136699717373', 0),
(328, 'FHCBH', '43.697224615909676, 24.90226695761881', 0),
(329, 'HVKRA', '43.696658023288194, 24.88462799350233', 0),
(330, 'GBSYV', '43.70194158126306, 24.88691530473192', 0),
(331, 'TAZIH', '41.46348377218888, 25.066819331324034', 0),
(332, 'SUMZT', '41.46182974844478, 25.084471605562566', 0),
(333, 'NZPQP', '41.44849474528725, 25.075467034936743', 0),
(334, 'ZJQTO', '41.45428598572798, 25.07696368956932', 0),
(335, 'RAUBU', '41.451488888739185, 25.074529106006832', 0),
(336, 'NOEHT', '43.02062158742763, 23.048213580295503', 0),
(337, 'CPHDB', '43.01816520242294, 23.04275541406223', 0),
(338, 'IRFNN', '43.01326905117662, 23.041065243492973', 0),
(339, 'FWRMZ', '43.01184432743907, 23.035196128628233', 0),
(340, 'ZCOWR', '43.02517783282524, 23.035727458200306', 0),
(341, 'FDEPZ', '41.48556760235085, 24.84876777250103', 1),
(342, 'XXMZK', '41.49710803199421, 24.841189180718573', 0),
(343, 'CWHOC', '43.92745194595415, 26.206930639627977', 0),
(344, 'QXWGW', '43.93866684685902, 26.213379775452612', 0),
(345, 'PLUDZ', '43.928138410388996, 26.201042925927958', 0),
(346, 'CYSOD', '43.95210774790544, 26.20014977715062', 0),
(347, 'KUOZC', '43.759595378822155, 26.685522815702644', 1),
(348, 'TYFGK', '41.73440436374887, 24.015213277476732', 0),
(349, 'YINWP', '41.73193805675176, 24.02747546580241', 0),
(350, 'QLEVF', '41.75039435526315, 24.02222420180731', 0),
(351, 'FZMQH', '41.730366091488996, 24.035467625491712', 0),
(352, 'WSTGR', '42.27385208157309, 27.752188275874996', 0),
(353, 'RGIJB', '42.28076753506057, 27.75143958874228', 0),
(354, 'ECSZQ', '42.25739221613307, 27.762635255827135', 0),
(355, 'BVHSR', '42.26931548003025, 27.765943318500156', 0),
(356, 'BWYDE', '43.64365806125988, 24.6818366409682', 0),
(357, 'YGGXC', '43.62966114062262, 24.688788705705033', 0),
(358, 'OKIIG', '43.70081345772012, 23.448906492936956', 0),
(359, 'WFXUI', '43.6861767802254, 23.453165246991613', 1),
(360, 'XMWYD', '43.542711889394305, 28.53273061371164', 0),
(361, 'TUJII', '43.53443515563719, 28.527999163450804', 0),
(362, 'CMKMT', '42.9282999992173, 22.941365241036973', 0),
(363, 'SVAKG', '42.91701727069681, 22.91986667470625', 0),
(364, 'FAUCO', '42.918008455862314, 22.937060278179256', 1),
(365, 'SWUVJ', '42.91701924437924, 22.91852620033034', 1),
(366, 'DOZVD', '43.68999021944428, 23.840827529198506', 1),
(367, 'NXSXR', '43.68436772264497, 23.862835516596633', 0),
(368, 'XPMOG', '43.87675195475442, 22.51775710348171', 0),
(369, 'PTJJY', '43.87066160710972, 22.519087523991587', 0),
(370, 'GYLYJ', '43.884066766637474, 22.50473500035534', 0),
(371, 'LRSWS', '41.94178545863812, 24.206603192669633', 0),
(372, 'XCNSP', '41.67473347773063, 24.29055746357094', 0),
(373, 'IDKTK', '41.683808945692924, 24.292953407023003', 0),
(374, 'AOBXB', '41.683426191051076, 24.279759950869302', 0),
(375, 'UNWRB', '42.83354854801172, 22.662848129783256', 1),
(376, 'PEOMP', '42.83217967906646, 22.661835485120324', 0),
(377, 'SRCSY', '42.83858152902884, 22.655979074708615', 0),
(378, 'WOSDJ', '41.65914819075437, 24.162585389202967', 0),
(379, 'OEXFO', '41.64503093488412, 24.154312986104372', 0),
(380, 'XDDMI', '41.64283893133321, 24.161937319637765', 0),
(381, 'NLNFD', '44.151364539923186, 22.637074429353163', 1),
(382, 'MDKXK', '44.16061877666786, 22.65535189290018', 0),
(383, 'DDTDA', '43.49997617532825, 25.80916924050699', 0),
(384, 'QXTLN', '43.49156296561401, 25.79985939210805', 0),
(385, 'VQLAN', '43.47865091483182, 25.813761826916554', 0),
(386, 'FTZOK', '43.6304612828469, 23.18843248159159', 0),
(387, 'CGYFL', '43.63447613837072, 23.180180627014018', 0),
(388, 'FLNQY', '43.47033896251618, 23.327823256357547', 1),
(389, 'ZMWKH', '43.937913722316566, 27.284525578437336', 0),
(390, 'GQVDR', '43.940953028328046, 27.298310693222366', 0),
(391, 'JIXCW', '43.944880092850795, 27.281226983764707', 0),
(392, 'LONTE', '43.938913636357114, 27.289040515323983', 1),
(393, 'YTSZU', '43.81992473306313, 27.771205310098285', 0),
(394, 'XVEAM', '43.816606808217635, 27.75583333512779', 0),
(395, 'IVHEA', '43.82262494134629, 27.762480542358393', 0),
(396, 'PCJFD', '43.812546438715366, 27.770648238766135', 0),
(397, 'FZPGC', '43.82293145612649, 27.749756181133126', 1),
(398, 'SLAXZ', '43.70162905461707, 22.98543277469456', 0),
(399, 'NRINY', '43.70645467561977, 22.978024023974232', 0),
(400, 'IQVGA', '43.82718316622782, 22.66395135186262', 0),
(401, 'IWBYA', '43.825044255798836, 22.654097085038746', 0),
(402, 'PHGQT', '43.61285640556007, 23.667732670389103', 0),
(403, 'BUQQT', '43.59180600712113, 23.665287176045474', 0),
(404, 'CBEQD', '43.60245196250119, 23.670861254604194', 0),
(405, 'VKFYM', '43.72919134681931, 22.721423871775478', 0),
(406, 'FDUNG', '43.73070526713161, 22.7348409215417', 0),
(407, 'SHZYU', '43.74559215951796, 22.72842938950346', 0),
(408, 'SIHPY', '43.735820382362114, 22.73539895982537', 0),
(409, 'DPGOX', '43.73124857784078, 22.727943561205127', 1),
(410, 'NPSZI', '43.678920785128966, 23.071379196738675', 0),
(411, 'AGISG', '43.67346116276175, 23.064725188190184', 0),
(412, 'VNFGI', '43.673686224483326, 23.05486605269445', 0),
(413, 'EFYDX', '43.671632270700066, 23.060255285453092', 0),
(414, 'ESVMY', '43.66856684652458, 23.068709535361204', 0),
(415, 'QTEZR', '43.70110678214942, 28.294876538975117', 0),
(416, 'YLEPE', '43.71435469723608, 28.307011367240857', 0),
(417, 'XXOBG', '43.70189657458943, 28.311505613473127', 0),
(418, 'WGIYM', '44.167300966622484, 22.777667381263015', 0),
(419, 'NKUDA', '44.150849495546, 22.796210651111473', 0),
(420, 'YLZTF', '43.68809772453245, 25.951666341759942', 0),
(421, 'UPHEY', '43.68061838487062, 25.958405457937225', 0),
(422, 'TYMJG', '43.6835690580503, 25.94950816454179', 0),
(423, 'YHVTG', '43.68935617197692, 25.955927018570605', 0),
(424, 'TKFKM', '43.68833856602486, 25.966708855754337', 1),
(425, 'CUZCB', '43.62369109306213, 22.823188780509398', 0),
(426, 'LOFVV', '43.622607709372474, 22.84217533186907', 0),
(427, 'QISGD', '43.62849307521866, 22.81873063415748', 0),
(428, 'BNSFI', '41.33649243507648, 25.366224795528808', 0),
(429, 'XWHDW', '41.33448133400452, 25.375512851787803', 0),
(430, 'WDZIJ', '41.32948717272363, 25.367731395528494', 0),
(431, 'NNUED', '41.331796051586565, 25.3781649717532', 0),
(432, 'EWUWF', '43.9904743302371, 27.492070785033597', 0),
(433, 'CRBPB', '42.26499800216325, 22.8485098117288', 0),
(434, 'BLNJV', '42.25578150977609, 22.84510889609649', 0),
(435, 'UVJZU', '42.26238558454363, 22.858136411095916', 0),
(436, 'PREKJ', '41.6905347819833, 24.59478712700328', 0),
(437, 'EFQYG', '41.69010496920623, 24.585514018831592', 0),
(438, 'VOQTC', '41.67681183258347, 24.59526637878646', 0),
(439, 'UFKGH', '41.676565673908286, 24.58791324754515', 0),
(440, 'IFXUC', '41.67549471730561, 24.594626353218366', 0),
(441, 'WLJCM', '43.52096005505986, 22.664192301073', 0),
(442, 'KVMVQ', '43.95162746473416, 22.54241123451732', 0),
(443, 'JMSMB', '43.943600901549466, 22.541676227328946', 0),
(444, 'VXRUZ', '43.952198405026984, 22.53663396305499', 1),
(445, 'PRKLC', '43.94405042259693, 22.536385897961033', 0),
(446, 'RPYJY', '43.943438198784435, 22.53004327412276', 0),
(447, 'XVDLS', '43.761088006793194, 22.667166122525998', 0),
(448, 'BHYPR', '43.754934389977464, 22.66584099995834', 0),
(449, 'KZDKY', '41.49963328265868, 24.938016237432134', 0),
(450, 'RMFVW', '43.67446102368923, 24.463538118348488', 0),
(451, 'YQQUD', '43.67177272273137, 24.439637747726593', 0),
(452, 'SYNWS', '43.678643806880004, 24.447134929582496', 0),
(453, 'YYIBN', '44.02896802085274, 27.019857521142484', 0),
(454, 'UGDEI', '44.02226625166222, 27.01315005886701', 0),
(455, 'WMLAU', '43.53436879801777, 25.64428063812374', 0),
(456, 'CTUFV', '43.54193999947286, 25.654085341411363', 0),
(457, 'SJMQT', '43.536406281663915, 25.66088770151901', 0),
(458, 'OOVKH', '43.532953928632786, 25.666915587728415', 0),
(459, 'IZNYO', '42.879491864594826, 27.88697185096367', 0),
(460, 'KCWRT', '42.86771299149722, 27.89945998107387', 0),
(461, 'BXDNR', '42.86851735308337, 27.883393356024047', 0),
(462, 'MXKAV', '42.86096156045485, 27.885410335087645', 0);

INSERT INTO `users` (`user_id`, `username`, `password`, `first_name`, `last_name`, `balance`, `city_id`, `register_date`) VALUES
(1, 'Dimitar.Yordanov.529', 'tDmAc32F', 'Dimitar', 'Yordanov', '0.00', 3, '2020-09-07 00:00:00'),
(2, 'Stefan.Atanasov.403', 'JC92R3v9', 'Stefan', 'Atanasov', '99.00', 19, '2021-08-09 00:00:00'),
(3, 'Krasimir.Atanasov.998', 'vCaEy2t9', 'Krasimir', 'Atanasov', '85.00', 4, '2020-01-11 00:00:00'),
(4, 'Nikolay.Atanasov.388', 'UWwbLjJW', 'Nikolay', 'Atanasov', '12.00', 7, '2021-08-01 00:00:00'),
(5, 'Dimitar.Petrov.436', '34kQ65UQ', 'Dimitar', 'Petrov', '8.00', 26, '2021-01-02 00:00:00'),
(6, 'Georgi.Stefanov.724', 'TRzYCmnw', 'Georgi', 'Stefanov', '79.00', 4, '2020-11-06 00:00:00'),
(7, 'Yordan.Ivanov.701', 'rSRjKvWz', 'Yordan', 'Ivanov', '78.00', 82, '2021-08-25 00:00:00'),
(8, 'Martin.Georgiev.543', 'EdPDAWJ5', 'Martin', 'Georgiev', '79.00', 28, '2020-03-14 00:00:00'),
(9, 'Stefan.Hristov.57', 'VD8x7W29', 'Stefan', 'Hristov', '42.00', 48, '2021-04-08 00:00:00'),
(10, 'Dimitar.Georgiev.601', 'Xh34ptFX', 'Dimitar', 'Georgiev', '9.00', 53, '2020-04-17 00:00:00'),
(11, 'Angel.Hristov.497', 't5GmCFkd', 'Angel', 'Hristov', '42.00', 97, '2020-08-28 00:00:00'),
(12, 'Petya.Shtereva.91', 'mbd8WeaX', 'Petya', 'Shtereva', '24.00', 1, '2021-12-12 00:00:00'),
(13, 'Milena.Georgieva.104', 'e4Ah8Y6L', 'Milena', 'Georgieva', '80.00', 4, '2021-09-18 00:00:00'),
(14, 'Elena.Shtereva.115', 'hjVWRh2b', 'Elena', 'Shtereva', '39.00', 14, '2020-03-12 00:00:00'),
(15, 'Margarita.Shtereva.287', 'HGw9YYSK', 'Margarita', 'Shtereva', '92.00', 70, '2021-01-09 00:00:00'),
(16, 'Yordana.Todorova.119', 'VFke5Uhe', 'Yordana', 'Todorova', '21.00', 2, '2021-12-07 00:00:00'),
(17, 'Yordana.Todorova.701', 'at5A6GZM', 'Yordana', 'Todorova', '73.00', 1, '2021-07-22 00:00:00'),
(18, 'Stoyan.Dimitrov.684', '79U2dC8w', 'Stoyan', 'Dimitrov', '78.00', 81, '2021-09-11 00:00:00'),
(19, 'Dimitar.Nikolaev.249', 'JyxfzZMg', 'Dimitar', 'Nikolaev', '49.00', 3, '2020-09-03 00:00:00'),
(20, 'Vasil.Dimitrov.559', 'EGfYhtyV', 'Vasil', 'Dimitrov', '34.00', 2, '2020-09-29 00:00:00'),
(21, 'Aleksandar.Nikolaev.442', 'ty6cecJj', 'Aleksandar', 'Nikolaev', '84.00', 1, '2020-03-17 00:00:00'),
(22, 'Nikola.Dimitrov.514', 'ZHSMAQhR', 'Nikola', 'Dimitrov', '42.00', 17, '2021-10-03 00:00:00'),
(23, 'Angel.Dimitrov.815', 'xxJBMpyN', 'Angel', 'Dimitrov', '43.00', 1, '2020-11-09 00:00:00'),
(24, 'Ivan.Petrov.192', 'QzkpsP7z', 'Ivan', 'Petrov', '52.00', 26, '2020-12-12 00:00:00'),
(25, 'Nikola.Todorov.570', 'K22Ncb4C', 'Nikola', 'Todorov', '77.00', 27, '2021-06-09 00:00:00'),
(26, 'Nikolay.Yordanov.970', 'qQ49yf5C', 'Nikolay', 'Yordanov', '19.00', 90, '2021-05-22 00:00:00'),
(27, 'Hristo.Stefanov.801', 'GxmkYfLh', 'Hristo', 'Stefanov', '50.00', 12, '2021-01-30 00:00:00'),
(28, 'Atanas.Stoyanov.419', '2mD9cWdT', 'Atanas', 'Stoyanov', '77.00', 64, '2020-11-23 00:00:00'),
(29, 'Ivaylo.Atanasov.177', 'zsveFdMC', 'Ivaylo', 'Atanasov', '59.00', 55, '2021-05-01 00:00:00'),
(30, 'Aleksandar.Stoyanov.58', 'g7RMYZDw', 'Aleksandar', 'Stoyanov', '39.00', 1, '2020-01-05 00:00:00'),
(31, 'Georgi.Atanasov.403', 'K3arFp9M', 'Georgi', 'Atanasov', '62.00', 2, '2020-11-27 00:00:00'),
(32, 'Ivaylo.Ivanov.217', 'patTxZz7', 'Ivaylo', 'Ivanov', '85.00', 18, '2021-12-29 00:00:00'),
(33, 'Georgi.Nikolaev.947', 'yphPXgG9', 'Georgi', 'Nikolaev', '76.00', 68, '2021-09-09 00:00:00'),
(34, 'Milena.Dimova.635', 'LrnVTzZt', 'Milena', 'Dimova', '29.00', 44, '2020-02-16 00:00:00'),
(35, 'Rositsa.Todorova.685', 'wcJghzvM', 'Rositsa', 'Todorova', '71.00', 62, '2020-03-24 00:00:00'),
(36, 'Denislava.Ivanova.573', 'GbPCf5hU', 'Denislava', 'Ivanova', '19.00', 77, '2020-06-07 00:00:00'),
(37, 'Milena.Slavova.480', 'KL3YsWQ6', 'Milena', 'Slavova', '55.00', 63, '2020-04-08 00:00:00'),
(38, 'Rumyana.Dimova.843', 'tuUNEPt3', 'Rumyana', 'Dimova', '24.00', 4, '2021-05-25 00:00:00'),
(39, 'Nikolay.Stefanov.261', 'wMWW8tmS', 'Nikolay', 'Stefanov', '5.00', 17, '2021-11-17 00:00:00'),
(40, 'Vasil.Todorov.544', 'G5C7jdkz', 'Vasil', 'Todorov', '97.00', 86, '2021-07-17 00:00:00'),
(41, 'Aleksandar.Hristov.663', '3SbSHBXC', 'Aleksandar', 'Hristov', '14.00', 69, '2021-08-20 00:00:00'),
(42, 'Stoyan.Yordanov.91', 'ybCJbDfr', 'Stoyan', 'Yordanov', '77.00', 65, '2021-06-30 00:00:00'),
(43, 'Atanas.Georgiev.860', 'bcd5NCLq', 'Atanas', 'Georgiev', '76.00', 22, '2021-08-10 00:00:00'),
(44, 'Krasimir.Petrov.991', 'yF5CAE5u', 'Krasimir', 'Petrov', '97.00', 79, '2020-06-20 00:00:00'),
(45, 'Dimitar.Georgiev.154', 'vVQXYRys', 'Dimitar', 'Georgiev', '92.00', 3, '2020-05-23 00:00:00'),
(46, 'Nikolay.Dimitrov.761', '6vgwUk8V', 'Nikolay', 'Dimitrov', '49.00', 30, '2021-04-06 00:00:00'),
(47, 'Valentin.Todorov.528', 'yUHuse98', 'Valentin', 'Todorov', '60.00', 57, '2020-01-27 00:00:00'),
(48, 'Ivan.Atanasov.753', 'zeh8JAnr', 'Ivan', 'Atanasov', '42.00', 2, '2020-06-19 00:00:00'),
(49, 'Yordan.Dimitrov.929', 'XhxaGAZd', 'Yordan', 'Dimitrov', '100.00', 29, '2021-09-23 00:00:00'),
(50, 'Martin.Hristov.642', 'dssEnxhQ', 'Martin', 'Hristov', '37.00', 80, '2021-06-13 00:00:00'),
(51, 'Ivan.Stefanov.209', 'HdaqBme8', 'Ivan', 'Stefanov', '55.00', 77, '2021-09-08 00:00:00'),
(52, 'Angel.Petrov.673', 'ckem9stE', 'Angel', 'Petrov', '46.00', 68, '2021-04-27 00:00:00'),
(53, 'Aleksandar.Todorov.852', 'QuuxR2nh', 'Aleksandar', 'Todorov', '0.00', 10, '2020-02-22 00:00:00'),
(54, 'Dimitar.Georgiev.439', '8779qnPR', 'Dimitar', 'Georgiev', '34.00', 20, '2020-03-25 00:00:00'),
(55, 'Yordan.Dimitrov.733', '4ZktVwRT', 'Yordan', 'Dimitrov', '90.00', 70, '2020-11-11 00:00:00'),
(56, 'Ivan.Hristov.664', 'qbNXXHZy', 'Ivan', 'Hristov', '12.00', 45, '2020-11-13 00:00:00'),
(57, 'Vasil.Stefanov.278', 'nXjgEX98', 'Vasil', 'Stefanov', '76.00', 80, '2021-09-09 00:00:00'),
(58, 'Vasil.Stoyanov.555', 'LcqUvP3Y', 'Vasil', 'Stoyanov', '91.00', 3, '2020-07-05 00:00:00'),
(59, 'Stefan.Stoyanov.548', 'fTJPF4zh', 'Stefan', 'Stoyanov', '0.00', 61, '2021-03-14 00:00:00'),
(60, 'Stefan.Nikolaev.173', 'azthJZ7R', 'Stefan', 'Nikolaev', '87.00', 76, '2020-12-02 00:00:00'),
(61, 'Martin.Todorov.460', '5EHCXn8m', 'Martin', 'Todorov', '68.00', 85, '2020-02-18 00:00:00'),
(62, 'Margarita.Ruseva.824', '5ZDLXQjr', 'Margarita', 'Ruseva', '90.00', 4, '2021-02-06 00:00:00'),
(63, 'Denislava.Aleksandrova.689', 'hkzGDedJ', 'Denislava', 'Aleksandrova', '78.00', 6, '2021-01-31 00:00:00'),
(64, 'Petya.Dimova.913', '4xDFxADT', 'Petya', 'Dimova', '60.00', 4, '2020-02-26 00:00:00'),
(65, 'Margarita.Dimova.874', 'UUkpLTzC', 'Margarita', 'Dimova', '86.00', 3, '2020-05-30 00:00:00'),
(66, 'Gergana.Aleksandrova.509', 'Y8MZFut5', 'Gergana', 'Aleksandrova', '59.00', 14, '2021-12-12 00:00:00'),
(67, 'Rumyana.Ivanova.716', '7WMBrNTS', 'Rumyana', 'Ivanova', '31.00', 2, '2020-12-20 00:00:00'),
(68, 'Rumyana.Dimitrova.73', 'PTfEq3Gk', 'Rumyana', 'Dimitrova', '90.00', 8, '2020-05-24 00:00:00'),
(69, 'Denislava.Ivanova.251', 'hvLHCtNR', 'Denislava', 'Ivanova', '34.00', 54, '2020-09-15 00:00:00'),
(70, 'Gergana.Slavova.745', 'C6jrMdpC', 'Gergana', 'Slavova', '0.00', 1, '2021-06-19 00:00:00'),
(71, 'Gergana.Ivanova.562', 'B4ndXWkY', 'Gergana', 'Ivanova', '68.00', 5, '2020-07-02 00:00:00'),
(72, 'Denislava.Ruseva.328', 'baWT2WxX', 'Denislava', 'Ruseva', '22.00', 6, '2021-06-24 00:00:00'),
(73, 'Silvia.Stoyanova.404', 'PJ9SMtYF', 'Silvia', 'Stoyanova', '37.00', 75, '2020-04-02 00:00:00'),
(74, 'Denislava.Dimova.843', 'La8VhUwu', 'Denislava', 'Dimova', '6.00', 17, '2020-09-01 00:00:00'),
(75, 'Maria.Aleksandrova.999', 'dh3yQRB2', 'Maria', 'Aleksandrova', '3.00', 54, '2021-08-13 00:00:00'),
(76, 'Rumyana.Petrova.209', 'mv8WtKGu', 'Rumyana', 'Petrova', '15.00', 55, '2020-10-08 00:00:00'),
(77, 'Rositsa.Stoyanova.479', 'mS3ym38L', 'Rositsa', 'Stoyanova', '43.00', 2, '2021-12-29 00:00:00'),
(78, 'Elena.Georgieva.390', 'yYr3pfff', 'Elena', 'Georgieva', '0.00', 61, '2021-06-19 00:00:00'),
(79, 'Maria.Dimitrova.607', 'zr5DurkA', 'Maria', 'Dimitrova', '66.00', 31, '2021-02-13 00:00:00'),
(80, 'Elena.Stoyanova.190', 'tmnnPUMy', 'Elena', 'Stoyanova', '28.00', 4, '2021-01-17 00:00:00'),
(81, 'Milena.Aleksandrova.220', 'rgPJ87Jg', 'Milena', 'Aleksandrova', '2.00', 57, '2021-08-31 00:00:00'),
(82, 'Milena.Slavova.68', 'x3ac9wZR', 'Milena', 'Slavova', '8.00', 7, '2020-05-16 00:00:00'),
(83, 'Yordana.Tomova.928', 'SwDTsjQe', 'Yordana', 'Tomova', '65.00', 77, '2021-05-27 00:00:00'),
(84, 'Daniela.Dimitrova.40', 'jwssy8Cq', 'Daniela', 'Dimitrova', '44.00', 18, '2020-05-11 00:00:00'),
(85, 'Yordana.Dimova.99', 'CKrRH35P', 'Yordana', 'Dimova', '25.00', 68, '2020-09-14 00:00:00'),
(86, 'Silvia.Dimitrova.554', '7D4Jr2Nv', 'Silvia', 'Dimitrova', '33.00', 58, '2020-01-02 00:00:00'),
(87, 'Petya.Dimitrova.136', '69KjBeBL', 'Petya', 'Dimitrova', '98.00', 71, '2021-07-08 00:00:00'),
(88, 'Milena.Ivanova.505', '7k65XFaD', 'Milena', 'Ivanova', '0.00', 3, '2020-02-18 00:00:00'),
(89, 'Emilia.Todorova.766', 'gscDFx8F', 'Emilia', 'Todorova', '51.00', 4, '2021-05-29 00:00:00'),
(90, 'Viktoria.Stoyanova.872', 'pTBsjXRs', 'Viktoria', 'Stoyanova', '43.00', 3, '2020-11-28 00:00:00'),
(91, 'Petya.Tomova.15', 'qkcuqKWn', 'Petya', 'Tomova', '16.00', 11, '2020-10-13 00:00:00'),
(92, 'Margarita.Dimova.862', '6wQ2uQHq', 'Margarita', 'Dimova', '82.00', 1, '2020-11-13 00:00:00'),
(93, 'Silvia.Slavova.650', '4K6PqYLc', 'Silvia', 'Slavova', '57.00', 4, '2020-04-17 00:00:00'),
(94, 'Gergana.Petrova.470', 'AsbgSnpg', 'Gergana', 'Petrova', '20.00', 17, '2021-09-11 00:00:00'),
(95, 'Petya.Aleksandrova.479', 'xJfeM7cy', 'Petya', 'Aleksandrova', '92.00', 67, '2020-08-20 00:00:00'),
(96, 'Rositsa.Petrova.520', 'tfwSxCvL', 'Rositsa', 'Petrova', '61.00', 72, '2021-04-06 00:00:00'),
(97, 'Rumyana.Todorova.609', 'WuQYmxp6', 'Rumyana', 'Todorova', '62.00', 85, '2020-07-09 00:00:00'),
(98, 'Viktoria.Stoyanova.287', 'BSq9uvmC', 'Viktoria', 'Stoyanova', '44.00', 80, '2020-11-29 00:00:00'),
(99, 'Nadezhda.Todorova.619', '2gtBwZCb', 'Nadezhda', 'Todorova', '25.00', 3, '2021-09-18 00:00:00'),
(100, 'Rositsa.Dimitrova.697', 'H8dWCTe8', 'Rositsa', 'Dimitrova', '51.00', 1, '2020-08-03 00:00:00'),
(101, 'Yordana.Dimova.6', 'nrvv5Lwk', 'Yordana', 'Dimova', '6.00', 102, '2021-12-13 00:00:00'),
(102, 'Maria.Todorova.638', 'JHhxD2kK', 'Maria', 'Todorova', '30.00', 4, '2021-06-19 00:00:00'),
(103, 'Viktoria.Petrova.613', 'gvtpcgGE', 'Viktoria', 'Petrova', '99.00', 4, '2020-08-17 00:00:00'),
(104, 'Maria.Stoyanova.294', 'GkNdV2Cr', 'Maria', 'Stoyanova', '22.00', 80, '2021-08-07 00:00:00'),
(105, 'Elena.Ruseva.604', 'tUMqCTYQ', 'Elena', 'Ruseva', '99.00', 11, '2021-09-12 00:00:00'),
(106, 'Viktoria.Todorova.978', 'NJ8DAqZy', 'Viktoria', 'Todorova', '50.00', 3, '2020-04-19 00:00:00'),
(107, 'Maria.Stoyanova.63', 'cd7Sqs4N', 'Maria', 'Stoyanova', '40.00', 3, '2021-07-08 00:00:00'),
(108, 'Milena.Dimova.492', 'HswQ7wQ2', 'Milena', 'Dimova', '51.00', 86, '2021-08-26 00:00:00');

INSERT INTO `rents` (`rent_id`, `user_id`, `scooter_id`, `start_date`, `end_date`, `is_completed`) VALUES
(1, 52, 359, '2021-10-22 05:10:08', '2021-11-15 16:11:03', 1),
(2, 77, 32, '2022-01-04 23:01:57', '2022-01-14 20:01:19', 1),
(3, 79, 250, '2021-06-14 01:06:27', NULL, 0),
(4, 14, 199, '2022-01-10 17:01:58', '2022-01-10 20:01:16', 1),
(5, 7, 397, '2021-09-26 05:09:31', '2021-12-17 17:12:17', 1),
(6, 36, 381, '2021-04-02 03:04:18', NULL, 0),
(7, 38, 95, '2021-07-17 05:07:38', NULL, 0),
(8, 74, 206, '2020-09-20 16:09:24', '2021-10-19 22:10:02', 1),
(9, 81, 321, '2021-12-21 07:12:52', '2022-01-02 20:01:34', 1),
(10, 76, 316, '2020-12-14 20:12:00', '2020-12-15 21:27:05', 1),
(11, 103, 100, '2021-05-03 12:05:00', '2021-07-18 18:07:35', 1),
(12, 12, 2, '2022-01-14 11:01:28', '2022-01-15 02:01:05', 1),
(13, 86, 326, '2020-03-16 05:03:49', NULL, 0),
(14, 73, 375, '2021-10-19 20:10:30', '2021-11-13 21:11:51', 1),
(15, 106, 90, '2021-05-13 09:05:30', '2021-10-15 16:10:36', 1),
(16, 35, 341, '2021-01-14 01:01:53', '2021-06-23 05:06:52', 1),
(17, 19, 45, '2021-03-24 10:03:13', '2021-11-04 04:11:57', 1),
(18, 91, 194, '2020-12-25 19:12:46', '2021-07-26 20:07:04', 1),
(19, 102, 92, '2021-11-09 18:11:27', '2021-12-05 09:12:31', 1),
(20, 67, 24, '2021-10-04 03:10:37', NULL, 0),
(21, 105, 194, '2021-10-02 09:10:33', '2021-12-24 23:12:45', 1),
(22, 34, 282, '2020-08-30 02:08:04', NULL, 0),
(23, 33, 359, '2021-09-11 05:09:32', '2021-09-16 00:12:03', 1),
(24, 31, 16, '2021-06-25 19:06:00', '2021-08-29 17:08:13', 1),
(25, 107, 78, '2022-01-15 08:01:05', '2022-01-15 10:01:59', 1),
(26, 16, 17, '2021-12-19 10:12:08', '2022-01-05 10:01:29', 1),
(27, 15, 365, '2021-06-24 05:06:47', '2021-06-24 08:30:21', 1),
(28, 54, 211, '2021-09-30 09:09:11', '2021-10-20 10:10:21', 1),
(29, 30, 1, '2021-03-01 20:03:29', '2021-12-19 00:12:39', 1),
(30, 104, 388, '2021-09-12 14:08:27', '2021-09-12 14:11:49', 1),
(31, 47, 324, '2020-02-28 13:02:14', '2020-08-11 20:08:35', 1),
(32, 87, 366, '2021-11-20 21:11:19', '2021-12-04 06:12:45', 1),
(33, 11, 444, '2020-10-28 12:10:25', '2021-04-24 19:04:33', 1),
(34, 3, 97, '2021-05-06 09:05:19', '2022-01-10 01:01:57', 1),
(35, 2, 210, '2021-11-19 17:11:22', NULL, 0),
(36, 4, 181, '2021-10-15 14:10:43', '2021-11-11 18:11:32', 1),
(37, 18, 392, '2021-09-16 23:09:34', '2021-09-17 22:09:57', 1),
(38, 62, 100, '2022-01-12 16:01:11', '2022-01-13 20:01:19', 1),
(39, 26, 424, '2021-12-16 14:12:52', '2021-12-16 18:12:31', 1),
(40, 27, 195, '2021-05-26 08:05:59', '2021-08-11 17:08:14', 1),
(41, 40, 409, '2021-08-28 07:08:19', NULL, 0),
(42, 64, 95, '2021-03-19 04:03:56', '2021-03-19 06:30:21', 1),
(43, 90, 46, '2021-10-21 14:10:10', NULL, 0),
(44, 50, 388, '2021-08-27 07:08:54', '2021-08-30 15:30:29', 1),
(45, 68, 185, '2021-11-14 11:11:48', NULL, 0),
(46, 45, 68, '2021-07-21 11:07:13', '2021-08-09 23:08:57', 1),
(47, 43, 220, '2021-09-05 18:09:24', '2022-01-01 16:01:54', 1),
(48, 49, 243, '2021-12-29 09:12:02', '2022-01-04 22:01:34', 1),
(49, 10, 313, '2020-06-21 08:06:03', '2022-01-06 21:01:11', 1),
(50, 66, 199, '2022-01-04 18:01:07', '2022-01-10 09:01:35', 1),
(51, 13, 94, '2021-10-28 14:10:54', '2021-12-14 11:12:24', 1),
(52, 9, 296, '2021-12-04 00:12:47', '2021-12-06 11:12:02', 1),
(53, 63, 164, '2021-03-17 16:03:05', '2021-09-26 22:09:03', 1),
(54, 62, 94, '2021-04-02 03:04:57', '2021-09-20 19:09:18', 1),
(55, 31, 21, '2021-04-23 13:04:29', '2021-09-15 16:09:51', 1),
(56, 33, 359, '2021-11-18 14:09:04', '2021-12-28 15:12:19', 1),
(57, 38, 100, '2021-07-30 11:07:02', '2021-11-13 01:11:41', 1),
(58, 74, 206, '2021-11-19 13:11:37', '2021-11-24 00:11:08', 1),
(59, 56, 285, '2021-02-06 02:02:21', '2021-10-12 08:10:58', 1),
(60, 72, 145, '2021-11-03 10:11:36', '2021-11-08 02:11:09', 1),
(61, 4, 180, '2021-10-29 17:10:53', NULL, 0),
(62, 70, 4, '2021-07-20 10:07:16', '2021-12-11 17:12:18', 1),
(63, 98, 388, '2021-12-31 04:12:28', '2021-12-31 06:01:36', 1),
(64, 17, 3, '2021-09-11 00:09:20', '2021-11-21 18:11:27', 1),
(65, 39, 206, '2021-12-23 15:12:49', NULL, 0),
(66, 1, 65, '2021-08-25 22:08:40', '2021-11-25 09:11:27', 1),
(67, 12, 3, '2021-12-15 17:12:56', NULL, 0),
(68, 81, 321, '2021-09-19 14:09:09', '2021-11-01 21:11:39', 1),
(69, 15, 365, '2021-02-03 18:02:48', '2021-02-03 19:00:21', 1),
(70, 47, 322, '2021-07-29 05:07:43', NULL, 0),
(71, 55, 364, '2021-09-01 01:09:06', '2021-09-26 11:09:45', 1),
(72, 28, 347, '2021-10-01 15:10:53', NULL, 0),
(73, 54, 211, '2021-08-23 17:08:44', '2021-09-19 17:10:26', 1),
(74, 67, 20, '2021-06-13 06:06:37', '2021-10-13 23:10:57', 1),
(75, 19, 66, '2021-09-07 02:09:02', '2021-10-26 13:10:22', 1),
(76, 5, 236, '2021-05-11 17:05:31', '2021-11-23 16:11:01', 1),
(77, 65, 54, '2020-09-08 23:09:46', '2021-09-07 04:09:39', 1),
(78, 50, 388, '2021-10-16 09:10:46', '2021-10-16 13:10:11', 1),
(79, 24, 236, '2021-12-01 03:12:57', NULL, 0),
(80, 94, 206, '2021-11-27 06:09:14', '2021-11-27 14:12:24', 1),
(81, 48, 13, '2021-03-19 12:03:06', '2021-07-11 10:07:01', 1),
(82, 29, 316, '2021-11-09 10:11:50', NULL, 0);