csgo.sql

-- --------------------------------------------------------
-- Hoszt:                        52.155.250.97
-- Szerver verzió:               11.3.2-MariaDB-1:11.3.2+maria~ubu2310 - mariadb.org binary distribution
-- Szerver OS:                   debian-linux-gnu
-- HeidiSQL Verzió:              12.6.0.6765
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Adatbázis struktúra mentése a csgo.
CREATE DATABASE IF NOT EXISTS `csgo` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */;
USE `csgo`;

-- Struktúra mentése tábla csgo. case_items
CREATE TABLE IF NOT EXISTS `case_items` (
  `case_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  PRIMARY KEY (`case_id`,`item_id`),
  KEY `IX_case_items_item_id` (`item_id`),
  CONSTRAINT `case_items_ibfk_1` FOREIGN KEY (`case_id`) REFERENCES `items` (`item_id`) ON DELETE CASCADE,
  CONSTRAINT `case_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

-- Tábla adatainak mentése csgo.case_items: ~138 rows (hozzávetőleg)
INSERT INTO `case_items` (`case_id`, `item_id`) VALUES
	(8, 13),
	(8, 14),
	(8, 15),
	(1, 16),
	(8, 16),
	(1, 17),
	(2, 17),
	(8, 17),
	(1, 18),
	(8, 18),
	(12, 18),
	(8, 19),
	(8, 20),
	(10, 20),
	(12, 20),
	(8, 21),
	(10, 21),
	(8, 22),
	(10, 22),
	(12, 22),
	(8, 23),
	(11, 23),
	(12, 23),
	(8, 24),
	(11, 24),
	(8, 25),
	(11, 25),
	(12, 25),
	(8, 26),
	(11, 26),
	(12, 26),
	(2, 27),
	(4, 27),
	(11, 27),
	(12, 27),
	(4, 28),
	(1, 29),
	(4, 29),
	(2, 30),
	(4, 30),
	(2, 31),
	(4, 31),
	(4, 32),
	(11, 32),
	(12, 32),
	(4, 33),
	(11, 33),
	(12, 33),
	(4, 34),
	(11, 34),
	(4, 35),
	(10, 35),
	(9, 36),
	(12, 36),
	(9, 37),
	(11, 37),
	(1, 38),
	(2, 38),
	(9, 38),
	(1, 39),
	(9, 39),
	(11, 40),
	(12, 40),
	(12, 42),
	(1, 43),
	(1, 44),
	(1, 45),
	(2, 45),
	(11, 46),
	(1, 47),
	(2, 47),
	(1, 48),
	(2, 48),
	(1, 49),
	(1, 50),
	(10, 53),
	(12, 53),
	(10, 54),
	(12, 54),
	(10, 55),
	(12, 55),
	(10, 56),
	(11, 57),
	(1, 58),
	(2, 58),
	(5, 59),
	(5, 60),
	(5, 61),
	(5, 62),
	(5, 63),
	(5, 64),
	(5, 65),
	(5, 66),
	(5, 67),
	(5, 68),
	(5, 69),
	(5, 70),
	(5, 71),
	(5, 72),
	(5, 73),
	(6, 74),
	(11, 74),
	(6, 75),
	(10, 75),
	(6, 76),
	(10, 76),
	(6, 77),
	(10, 77),
	(1, 78),
	(6, 78),
	(1, 79),
	(6, 79),
	(6, 80),
	(3, 95),
	(11, 95),
	(3, 111),
	(3, 112),
	(3, 113),
	(10, 113),
	(3, 114),
	(11, 114),
	(3, 115),
	(7, 116),
	(7, 117),
	(7, 118),
	(7, 119),
	(7, 120),
	(7, 121),
	(7, 122),
	(7, 123),
	(7, 124),
	(7, 125),
	(7, 126);

-- Struktúra mentése tábla csgo. giveaways
CREATE TABLE IF NOT EXISTS `giveaways` (
  `giveaway_id` int(11) NOT NULL AUTO_INCREMENT,
  `giveaway_name` varchar(255) NOT NULL,
  `giveaway_description` text DEFAULT NULL,
  `winner_user_id` int(11) DEFAULT NULL,
  `giveaway_date` datetime(6) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`giveaway_id`),
  KEY `item_id` (`item_id`),
  KEY `winner_user_id` (`winner_user_id`),
  CONSTRAINT `giveaways_ibfk_1` FOREIGN KEY (`winner_user_id`) REFERENCES `users` (`user_id`),
  CONSTRAINT `giveaways_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

-- Tábla adatainak mentése csgo.giveaways: ~10 rows (hozzávetőleg)
INSERT INTO `giveaways` (`giveaway_id`, `giveaway_name`, `giveaway_description`, `winner_user_id`, `giveaway_date`, `item_id`) VALUES
	(1, 'asd', 'asd', 1, '2024-03-28 10:43:22.521000', 44),
	(2, 'Április 1. heti nyereményjáték', 'Csatlakozz és nyerj egy értékes M4 kinézetet!', NULL, '0001-01-01 01:00:00.000000', 20),
	(3, 'Április 1. heti nyereményjáték', 'Csatlakozz és nyerj egy értékes M4 kinézetet!', NULL, '0001-01-01 01:00:00.000000', 20),
	(4, 'Teszt', 'Tesztüzem', NULL, '0001-01-01 01:00:00.000000', 24),
	(5, 'Április 1. heti nyereményjáték', 'Csatlakozz és nyerj egy értékes M4 kinézetet!', 2, '2024-04-07 14:00:00.186000', 20),
	(6, 'Tavaszi nyereményjáték', 'Nyerj értékes skineket!', 1, '2024-04-08 10:22:00.468000', 40),
	(7, 'Teszt', 'Teszt', 2, '2024-04-08 10:00:00.778000', 63),
	(8, 'Szezonális nyereményjáték', 'Csatlakozz és gyűjts be egy nem mindennapi Kés kinézetet!', NULL, '2024-05-01 15:30:00.730000', 70),
	(9, 'Szezonális nyereményjáték', 'Csatlakozz és gyűjts be egy nem mindennapi Kés kinézetet!', NULL, '2024-05-01 15:30:00.730000', 70),
	(10, 'Teszt', 'Teszt', 2, '2024-04-08 10:00:00.111000', 70);

-- Struktúra mentése tábla csgo. giveaway_users
CREATE TABLE IF NOT EXISTS `giveaway_users` (
  `userID` int(11) NOT NULL,
  `giveawayID` int(11) NOT NULL,
  PRIMARY KEY (`userID`,`giveawayID`),
  KEY `FK_giveaway_users_giveaways` (`giveawayID`),
  CONSTRAINT `FK_giveaway_users_giveaways` FOREIGN KEY (`giveawayID`) REFERENCES `giveaways` (`giveaway_id`),
  CONSTRAINT `FK_giveaway_users_users` FOREIGN KEY (`userID`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

-- Tábla adatainak mentése csgo.giveaway_users: ~9 rows (hozzávetőleg)
INSERT INTO `giveaway_users` (`userID`, `giveawayID`) VALUES
	(1, 8),
	(2, 8),
	(5, 8),
	(7, 8),
	(9, 8),
	(10, 8),
	(1, 9),
	(2, 9),
	(9, 9),
	(10, 9);

-- Struktúra mentése tábla csgo. items
CREATE TABLE IF NOT EXISTS `items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(255) NOT NULL,
  `item_description` text DEFAULT NULL,
  `item_type` int(11) NOT NULL,
  `rarity` int(11) NOT NULL,
  `item_value` decimal(10,2) DEFAULT NULL,
  `asset_url` varchar(255) DEFAULT NULL,
  `skin_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

-- Tábla adatainak mentése csgo.items: ~99 rows (hozzávetőleg)
INSERT INTO `items` (`item_id`, `item_name`, `item_description`, `item_type`, `rarity`, `item_value`, `asset_url`, `skin_name`) VALUES
	(1, 'Milspec', NULL, 2, 0, 2.50, '/images/milspec_case.png', NULL),
	(2, '1% BIG WIN', NULL, 2, 0, 2.00, '/images/1_big_win_case.png', NULL),
	(3, 'AK-47', NULL, 2, 0, 4.00, '/images/ak-47_case.png', NULL),
	(4, 'AWP', NULL, 2, 0, 3.50, '/images/awp_case.png', NULL),
	(5, 'Knfie', NULL, 2, 0, 150.00, '/images/knife_case.png', NULL),
	(6, 'Agent', NULL, 2, 0, 3.50, '/images/agent_case.png', NULL),
	(7, 'Glock-18', NULL, 2, 0, 6.50, '/images/glock_18_case.png', NULL),
	(8, 'M4', NULL, 2, 0, 7.50, '/images/m4_case.png', NULL),
	(9, 'USP-S', NULL, 2, 0, 8.00, '/images/usp-s_case.png', NULL),
	(10, 'Restriced', NULL, 2, 0, 15.00, '/images/restricted_case.png', NULL),
	(11, 'Covert', NULL, 2, 0, 20.00, '/images/covert_case.png', NULL),
	(12, 'Diamond', NULL, 2, 0, 35.80, '/images/diamond_case.png', NULL),
	(13, 'M4A4', 'Assault Rifle', 1, 2, 6.43, '/images/m4a4_urban_ddpat.png', 'Urban DDPAT'),
	(14, 'M4A4', 'Assault Rifle', 1, 2, 18.18, '/images/m4a4_dark_blossom.png', 'Dark Blossom'),
	(15, 'M4A4', 'Assault Rifle', 1, 2, 63.21, '/images/m4a4_tornado.png', 'Tornado'),
	(16, 'M4A4', 'Assault Rifle', 1, 3, 7.11, '/images/m4a4_magnesium.png', 'Magnesium (StatTrak)'),
	(17, 'M4A4', 'Assault Rifle', 1, 3, 0.83, '/images/m4a4_converter.png', 'Converter'),
	(18, 'M4A4', 'Assault Rifle', 1, 3, 440.69, '/images/m4a4_radiation_hazard.png', 'Radiation Hazard'),
	(19, 'M4A4', 'Assault Rifle', 1, 4, 3.50, '/images/m4a4_evil_daimyo.png', 'Evil Daimyo'),
	(20, 'M4A4', 'Assault Rifle', 1, 5, 1023.35, '/images/m4a4_poseidon.png', 'Poseidon'),
	(21, 'M4A4', 'Assault Rifle', 1, 5, 40.00, '/images/m4a4_hellfire.png', 'Hellfire'),
	(22, 'M4A4', 'Assault Rifle', 1, 5, 18.50, '/images/m4a4_dragon_king.png', '龍王 (Dragon King)'),
	(23, 'M4A4', 'Assault Rifle', 1, 6, 83.21, '/images/m4a4_asiimov.png', 'Asiimov'),
	(24, 'M4A4', 'Assault Rifle', 1, 6, 23.10, '/images/m4a4_bullet_rain.png', 'Bullet Rain'),
	(25, 'M4A4', 'Assault Rifle', 1, 6, 55.61, '/images/m4a4_the_coalition.png', 'The Coalition'),
	(26, 'M4A4', 'Assault Rifle', 1, 6, 4535.78, '/images/m4a4_howl.png', 'Howl'),
	(27, 'AWP', 'Sniper Rifle', 1, 6, 535.00, '/images/awp_lightning_strike.png', 'Lightning Strike'),
	(28, 'AWP', 'Sniper Rifle', 1, 4, 5.35, '/images/awp_pop_awp.png', 'POP AWP'),
	(29, 'AWP', 'Sniper Rifle', 1, 3, 1.00, '/images/awp_acheron.png', 'Acheron'),
	(30, 'AWP', 'Sniper Rifle', 1, 4, 0.30, '/images/awp_pit_viper.png', 'Pit Viper'),
	(31, 'AWP', 'Sniper Rifle', 1, 2, 0.13, '/images/awp_safari_mesh.png', 'Safari Mesh'),
	(32, 'AWP', 'Sniper Rifle', 1, 6, 8432.13, '/images/awp_dragon_lore.png', 'Dragon Lore'),
	(33, 'AWP', 'Sniper Rifle', 1, 6, 62.13, '/images/awp_chrome_cannon.png', 'Chrome Cannon'),
	(34, 'AWP', 'Sniper Rifle', 1, 6, 4.25, '/images/awp_chromatic_aberration.png', 'Chromatic Aberration'),
	(35, 'AWP', 'Sniper Rifle', 1, 5, 11.38, '/images/awp_duality.png', 'Duality'),
	(36, 'USP-S', 'Pistol', 1, 4, 81.37, '/images/usp-s_dark_water.png', 'Dark Water'),
	(37, 'USP-S', 'Pistol', 1, 6, 11.37, '/images/usp-s_the_traitor.png', 'The Traitor'),
	(38, 'USP-S', 'Pistol', 1, 3, 1.00, '/images/usp-s_check_engine.png', 'Check Engine'),
	(39, 'USP-S', 'Pistol', 1, 3, 12.89, '/images/usp-s_purple_ddpat.png', 'Purple DDPAT'),
	(40, 'P90', 'SMG', 1, 6, 39.77, '/images/p90_death_by_kitty.png', 'Death by Kitty'),
	(41, 'P90', 'SMG', 1, 4, 1.49, '/images/p90_vent_rush.png', 'Vent Rush'),
	(42, 'P90', 'SMG', 1, 4, 275.00, '/images/p90_astral_jörmungandr.png', 'Astral Jörmungandr'),
	(43, 'Dual Berettas', 'Pistol', 1, 3, 0.31, '/images/dual_berettas_hideout.png', 'Hideout'),
	(44, 'MAC-10', 'SMG', 1, 3, 1.25, '/images/mac-10_light_box.png', 'Light Box'),
	(45, 'Nova', 'Shotgun', 1, 3, 0.38, '/images/nova_dark_sigil.png', 'Dark Sigil'),
	(46, 'M4A1-S', 'Assault Rifle', 1, 6, 36.88, '/images/m4a1-s_chanticos_fire.png', 'Chantico\'s Fire'),
	(47, 'SSG 08', 'Sniper Rifle', 1, 3, 0.59, '/images/ssg-08_dezastre.png', 'Dezastre'),
	(48, 'Tec-9', 'Pistol', 1, 3, 0.45, '/images/tec-9_slag.png', 'Slag'),
	(49, 'UMP-45', 'SMG', 1, 3, 0.35, '/images/ump-45_motorized.png', 'Motorized'),
	(50, 'XM1014', 'Shotgun', 1, 3, 0.34, '/images/xm1014_irezumi.png', 'Irezumi'),
	(51, 'Glock-18', 'Pistol', 1, 4, 4.34, '/images/glock-18_block-18.png', 'Block-18'),
	(52, 'M4A4', 'Assault Rifle', 1, 4, 5.12, '/images/m4a4_etch_lord.png', 'Etch Lord'),
	(53, 'M4A1-S', 'Assault Rifle', 1, 5, 57.38, '/images/m4a1-s_black_lotus.png', 'Black Lotus'),
	(54, 'Zeus x27', 'Shock Gun', 1, 5, 32.68, '/images/zeus_x27_olympus.png', 'Olympus'),
	(55, 'SG-553', 'Assault Rifle', 1, 5, 25.18, '/images/sg-553_colony_iv.png', 'Colony IV'),
	(56, 'SSG 08', 'Sniper Rifle', 1, 5, 50.46, '/images/ssg-08_bloodshot.png', 'Bloodshot'),
	(57, 'PP-Bizon', 'SMG', 1, 6, 7.78, '/images/bizon_judgement_of_anubis.png', 'Judgement of Anubis'),
	(58, 'MP9', 'SMG', 1, 3, 0.08, '/images/mp9_bioleak.png', 'Bioleak'),
	(59, 'Gut Knife', 'Knife', 1, 6, 233.24, '/images/gut_knife_doppler.png', 'Doppler'),
	(60, 'Shadow Daggers', 'Knife', 1, 6, 156.33, '/images/shadow_daggers_lore.png', 'Lore'),
	(61, 'Navaja Knife', 'Knife', 1, 6, 90.27, '/images/navaja_knife_ultraviolet.png', 'Ultraviolet'),
	(62, 'Huntsman Knife', 'Knife', 1, 6, 222.10, '/images/huntsman_knife_black_laminate.png', 'Black Laminate'),
	(63, 'Bowie Knife', 'Knife', 1, 6, 193.95, '/images/bowie_knife_autotronic.png', 'Autotronic'),
	(64, 'Navaja Knife', 'Knife', 1, 6, 81.12, '/images/navaja_knife_scorched.png', 'Scorched'),
	(65, 'Bayonet', 'Knife', 1, 6, 841.12, '/images/bayonet_doppler.png', 'Doppler'),
	(66, 'Survival Knife', 'Knife', 1, 6, 445.32, '/images/survival_knife_case_hardened.png', 'Case Hardened'),
	(67, 'Paracord Knife', 'Knife', 1, 6, 276.44, '/images/paracord_knife_night_stripe.png', 'Night Stripe'),
	(68, 'Ursus Knife', 'Knife', 1, 6, 357.35, '/images/ursus_knife_tiger_tooth.png', 'Tiger Tooth'),
	(69, 'Stiletto Knife', 'Knife', 1, 6, 337.15, '/images/stiletto_knife_crimson_web.png', 'Crimson Web'),
	(70, 'Karambit', 'Knife', 1, 6, 954.16, '/images/karambit_freehand.png', 'Freehand'),
	(71, 'Butterfly Knife', 'Knife', 1, 6, 2046.61, '/images/butterfly_knife_slaughter.png', 'Slaughter'),
	(72, 'Kukri Knife', 'Knife', 1, 6, 1549.97, '/images/kukri_kinfe_fade.png', 'Fade'),
	(73, 'Skeleton Knife', 'Knife', 1, 6, 1548.70, '/images/skeleton_knife_fade.png', 'Fade'),
	(74, 'Sir Bloody Miami Darryl', 'Agent', 1, 6, 75.45, '/images/sir_bloody_miami_darryl_the_professionals.png', 'The Professionals'),
	(75, 'Number K', 'Agent', 1, 5, 42.40, '/images/number_k_the_professionals.png', 'The Professionals'),
	(76, 'Chem-Haz Capitaine', 'Agent', 1, 5, 12.14, '/images/chem-haz_capitaine_gendarmerie_nationale.png', 'Gendarmerie Nationale'),
	(77, '\'Two Times\' McCoy', 'Agent', 1, 5, 3.70, '/images/two_times_mccoy_usaf_tacp.png', 'USAF TACP'),
	(78, 'Enforcer', 'Agent', 1, 3, 1.87, '/images/enforcer_phoenix.png', 'Phoenix'),
	(79, 'Soldier', 'Agent', 1, 3, 1.64, '/images/soldier_phoenix.png', 'Phoenix'),
	(80, 'Sous-Lieutenant Medic', 'Agent', 1, 4, 5.17, '/images/sous-lieutenant_medic_gendarmerie_nationale.png', 'Gendarmerie Nationale'),
	(95, 'AK-47', 'Assault Rifle', 1, 6, 70.96, '/images/ak-47_aquamarine_revenge.png', 'Aquamarine Revenge'),
	(96, 'MP9', 'SMG', 1, 4, 4.56, '/images/mp9_food_chain.png', 'Food Chain'),
	(111, 'AK-47', 'Asssault Rifle', 1, 3, 1.50, '/images/ak-47_elite_build.png', 'Elite Build'),
	(112, 'AK-47', 'Asssault Rifle', 1, 2, 0.03, '/images/ak-47_safari_mesh.png', 'Safari Mesh'),
	(113, 'AK-47', 'Asssault Rifle', 1, 5, 13.22, '/images/ak-47_redline.png', 'Redline'),
	(114, 'AK-47', 'Asssault Rifle', 1, 6, 18.73, '/images/ak-47_legion_of_anubis.png', 'Legion of Anubis'),
	(115, 'AK-47', 'Asssault Rifle', 1, 4, 3.22, '/images/ak-47_blue_laminate.png', 'Blue Laminate'),
	(116, 'Glock-18', 'Pistol', 1, 3, 0.80, '/images/glock-18_candy_apple.png', 'Candy Apple'),
	(117, 'Glock-18', 'Pistol', 1, 2, 0.16, '/images/glock-18_high_beam.png', 'High Beam'),
	(118, 'Glock-18', 'Pistol', 1, 3, 11.14, '/images/glock-18_reactor.png', 'Reactor'),
	(119, 'Glock-18', 'Pistol', 1, 3, 0.50, '/images/glock-18_bunsen_burner.png', 'Bunsen Burner'),
	(120, 'Glock-18', 'Pistol', 1, 4, 1384.11, '/images/glock-18_fade.png', 'Fade'),
	(121, 'Glock-18', 'Pistol', 1, 4, 0.63, '/images/glock-18_weasel.png', 'Weasel'),
	(122, 'Glock-18', 'Pistol', 1, 5, 8.54, '/images/glock-18_water_elemental.png', 'Water Elemental'),
	(123, 'Glock-18', 'Pistol', 1, 5, 9.22, '/images/glock-18_vogue.png', 'Vogue'),
	(124, 'Glock-18', 'Pistol', 1, 6, 6.62, '/images/glock-18_wasteland_rebel.png', 'Wasteland Rebel'),
	(125, 'Glock-18', 'Pistol', 1, 6, 47.91, '/images/glock-18_bullet_queen.png', 'Bullet Queen'),
	(126, 'Glock-18', 'Pistol', 1, 6, 23.33, '/images/glock-18_neo-noir.png', 'Neo-Noir');

-- Struktúra mentése tábla csgo. userinventory
CREATE TABLE IF NOT EXISTS `userinventory` (
  `inventory_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`inventory_id`),
  KEY `item_id1` (`item_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `userinventory_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
  CONSTRAINT `userinventory_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=713 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

-- Tábla adatainak mentése csgo.userinventory: ~138 rows (hozzávetőleg)
INSERT INTO `userinventory` (`inventory_id`, `user_id`, `item_id`) VALUES
	(1, 1, 10),
	(44, 1, 27),
	(65, 1, 27),
	(66, 1, 32),
	(67, 1, 32),
	(106, 1, 32),
	(305, 1, 32),
	(315, 1, 32),
	(316, 1, 32),
	(326, 1, 32),
	(366, 2, 17),
	(369, 1, 73),
	(373, 1, 61),
	(374, 1, 69),
	(376, 1, 61),
	(377, 1, 67),
	(379, 1, 71),
	(381, 1, 69),
	(383, 1, 62),
	(387, 2, 17),
	(389, 2, 13),
	(390, 2, 17),
	(393, 2, 17),
	(394, 2, 13),
	(395, 2, 50),
	(396, 2, 14),
	(397, 2, 111),
	(398, 2, 112),
	(399, 2, 112),
	(400, 2, 115),
	(401, 2, 111),
	(402, 2, 112),
	(403, 2, 16),
	(404, 2, 17),
	(405, 2, 17),
	(406, 2, 13),
	(407, 2, 17),
	(408, 2, 17),
	(409, 2, 17),
	(410, 2, 13),
	(411, 2, 17),
	(412, 2, 17),
	(413, 2, 17),
	(414, 2, 13),
	(415, 2, 13),
	(416, 2, 17),
	(418, 2, 17),
	(420, 2, 16),
	(421, 2, 79),
	(423, 2, 31),
	(427, 2, 29),
	(429, 2, 29),
	(430, 2, 31),
	(431, 2, 29),
	(432, 2, 29),
	(433, 2, 29),
	(442, 2, 19),
	(444, 2, 16),
	(445, 2, 16),
	(446, 2, 16),
	(447, 2, 16),
	(448, 2, 16),
	(450, 2, 17),
	(451, 2, 16),
	(452, 2, 17),
	(454, 2, 16),
	(461, 2, 16),
	(462, 2, 17),
	(464, 2, 16),
	(466, 2, 16),
	(467, 1, 68),
	(470, 1, 34),
	(558, 7, 61),
	(563, 9, 112),
	(587, 9, 72),
	(593, 7, 15),
	(595, 9, 15),
	(596, 9, 14),
	(598, 9, 36),
	(599, 9, 17),
	(600, 9, 28),
	(601, 9, 16),
	(603, 9, 16),
	(604, 7, 17),
	(605, 7, 15),
	(606, 7, 17),
	(607, 7, 17),
	(608, 7, 78),
	(609, 7, 78),
	(610, 7, 13),
	(611, 7, 16),
	(612, 7, 13),
	(613, 1, 60),
	(614, 7, 15),
	(621, 7, 59),
	(622, 7, 64),
	(624, 7, 60),
	(627, 7, 63),
	(628, 9, 27),
	(630, 7, 64),
	(631, 7, 69),
	(632, 7, 62),
	(633, 7, 62),
	(634, 7, 64),
	(638, 7, 62),
	(639, 7, 63),
	(640, 7, 60),
	(641, 7, 69),
	(642, 7, 61),
	(643, 7, 64),
	(644, 7, 68),
	(645, 7, 68),
	(646, 7, 60),
	(647, 7, 61),
	(651, 7, 69),
	(654, 9, 53),
	(656, 9, 36),
	(658, 9, 18),
	(660, 7, 71),
	(662, 7, 72),
	(664, 2, 66),
	(674, 1, 32),
	(678, 7, 32),
	(679, 7, 67),
	(684, 7, 120),
	(687, 8, 27),
	(688, 2, 114),
	(689, 2, 64),
	(690, 2, 64),
	(691, 2, 32),
	(692, 2, 37),
	(693, 2, 124),
	(695, 2, 32),
	(696, 2, 95),
	(697, 2, 67),
	(698, 2, 48),
	(699, 2, 31),
	(706, 10, 36),
	(711, 10, 20),
	(712, 10, 37);

-- Struktúra mentése tábla csgo. users
CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `balance` double NOT NULL,
  `login_streak` int(11) NOT NULL,
  `last_claim_date` datetime(6) NOT NULL DEFAULT '1970-01-01 00:00:00.000000',
  `totp_enabled` tinyint(1) NOT NULL,
  `totp_secret` varchar(255) DEFAULT NULL,
  `webauthn_enabled` tinyint(1) NOT NULL,
  `webauthn_credential_id` varchar(255) DEFAULT NULL,
  `webauthn_public_key` text DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

-- Tábla adatainak mentése csgo.users: ~10 rows (hozzávetőleg)
INSERT INTO `users` (`user_id`, `username`, `email`, `password_hash`, `balance`, `login_streak`, `last_claim_date`, `totp_enabled`, `totp_secret`, `webauthn_enabled`, `webauthn_credential_id`, `webauthn_public_key`, `is_admin`) VALUES
	(1, 'Babli', 'orosz.balazs.kevin@gmail.com', '$2a$11$42GJ6k.I2jkUygitYgPx2Ow7nC3eV81kMt1frUFuFWyeloG4A8mIy', 2064.58, 3, '2024-04-23 07:29:22.787784', 0, 'O74E6ONRYEIVPW3FUIFMM4N5P2FJWIVH', 0, NULL, NULL, 1),
	(2, 'IvadiZs', 'ehzy169@gmail.com', '$2a$11$d0sHYOzpzcY8B6famvco5ud6mYG6Msq57Q59fuLkZEOdhuvGKqF3.', 10000156565.309982, 2, '2024-04-24 06:01:18.609744', 0, 'HABS45BTADK6BJC3LVNSYBRZBUBMZEEZ', 0, NULL, NULL, 1),
	(3, 'tesztfiok_izs', 'tesztfiok@tf.tf', '$2a$11$2KogW77ICdXSIXv1c4GQf.MHiprLa.Vtb0VMuviYDvowf1oHj/pCa', 0, 0, '1970-01-01 00:00:00.000000', 0, NULL, 0, NULL, NULL, 0),
	(4, 'Tesztuser', 'teszt@teszt.ru', '$2a$11$Orq4323b3zDTfLg3le/fn.nuHc2ap1zdNdo1kxgBCkUtPXwExA3Cy', 0, 0, '1970-01-01 00:00:00.000000', 0, NULL, 0, NULL, NULL, 0),
	(5, 'KisBela12', 'kisbela14@gmail.com', '$2a$11$hZHUsYNR5cxebEIEwNHw.OBphkM0xUgUHuf1CXFnbECAdwDdCdl/G', 5, 1, '2024-04-21 14:28:10.427585', 0, NULL, 0, NULL, NULL, 0),
	(6, 'TesztJozsi', 'jozsivok@gmail.com', '$2a$11$2v02ka348X0e1Dv7YWUp/OzxiHBRRbas6OPnf77Uv7W0uxKn0luAG', 4.6, 1, '2024-04-22 16:08:33.016884', 0, NULL, 0, NULL, NULL, 0),
	(7, 'csicskaBalazs', 'balazsm@kkszki.hu', '$2a$11$82LKEq62NVm30hKmTl0em.fKzlTt8mN21aKZmQIePkxVG076i8eNS', 109986110.20000014, 1, '2024-04-23 06:52:59.580955', 0, NULL, 0, NULL, NULL, 0),
	(8, 'Xenith', 'vargabalint051@gmail.com', '$2a$11$AVfzYKmSQNLN9w3ybYspJezIBT7B2qqXPf8oX90f.vgj1ec0uvm7a', 4658.099999999997, 1, '2024-04-23 07:07:17.207045', 0, NULL, 0, NULL, NULL, 0),
	(9, 'damn', 'tothm@kkszki.hu', '$2a$11$5djsewNQLLJN6PsaQSvlYePZDufAgrLU7gG8WmZ2JrQSk7.6r0bwW', 4493.599999999999, 1, '2024-04-23 07:10:10.729001', 0, NULL, 0, NULL, NULL, 0),
	(10, 'fasz', 'celesta-tubal.0u@icloud.com', '$2a$11$9LcBnHrLudqy.30ZQSbsNOodztdZphfh9M2X0EQnxLwz7kARXA/tS', 869.6000000000001, 1, '2024-04-25 20:55:38.662995', 0, NULL, 0, NULL, NULL, 0);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;