(592,	'Speed Baccarat 12',	'898ec009cf2e34a256e6340238c8d95c',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fevolution%2FSpeedBaccarat12.png&w=384&q=100',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(599,	'Speed VIP Blackjack P',	'868116316bb9c2f9498b2165c7db9bd4',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fevolution%2FSpeedVIPBlackjackP.png&w=384&q=100',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(601,	'Speed VIP Blackjack R',	'ceda0cfac236c9431f061d964ed5062b',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fevolution%2FSpeedVIPBlackjackR.png&w=384&q=100',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(2377,	'Lucky Crew',	'ce7ce12fc51d197681ec98b8fd51fc3e',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(505,	'Salon Privé Baccarat I',	'6407557ea880b7f6276ec9d4e23e7926',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fevolution%2FSalonPriveBlackjackI.png&w=384&q=100',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(507,	'Salon Privé Baccarat H',	'44f46f61a501ab9555f46eeecae266ce',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fevolution%2FSalonPriveBlackjackJ.png&w=384&q=100',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(1984,	'Money Coming',	'db249defce63610fccabfa829a405232',	'Slot Game',	'https://bc.imgix.net/game/image/12159_Money%20Coming.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(510,	'Salon Privé Baccarat D',	'538b9ff225701f1e4e851167e5af1b84',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fevolution%2Fsalon_prive_baccarat_d.png&w=384&q=100',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(684,	'Auto Mega Roulette',	'a973fbb6b172cca38155523ab540d69f',	'CasinoLive',	'https://boxbet.io/_next/image?url=https%3A%2F%2Fcdn.softswiss.net%2Fi%2Fs6%2Fpragmaticexternal%2FAutoMegaRoulette.png&w=384&q=100',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(1227,	'Immortal Romance Video Bingo',	'5ce6870f076a30abbde384da763bce66',	'Video Bingo',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_immortalromance/f1490976-602f-41ab-9ba6-ef983b6c5e16.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1521,	'Lucky Twins & 9 Lions',	'262cda5fa53c68d59c8d236b04595e41',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_luckytwinsand9lions/3b8bb683-3460-47ea-af99-0eb8e39ef77f.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1205,	'Hades Lost Treasures',	'8c5874cfc46c093c3f662bcee65a7173',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_hadeslosttreasures/80228963-ff8c-4cfa-9ae7-ab2f4e20bca8.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1390,	'Halloweenies',	'f6b63e6c189e3c07f1891eb3999f20d2',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_halloweenies/25d6e5b9-503f-4c34-aa07-effc98f6d098.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1393,	'Golden Princess',	'2646c2eb32dd0a23b2a948f83bc00fda',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_goldenprincess/37611da6-3bf8-4225-851d-7243c0f33a1f.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1523,	'Frankenstein',	'9b7446dfd8cbb3714738dad83a8404c7',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_frankenstein/54336c64-c522-41d9-ae8b-316379e68376.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1421,	'Dungeons and Diamonds',	'301a45047cb812f57f1acdeab337d1b3',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_dungeonsanddiamonds/943afe24-d5ee-46af-8750-6fd57bf9c962.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1468,	'Blazing Mammoth',	'47763a8142fb5ead3aff6c55532f0ea3',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_blazingmammoth/62cf42ce-fe0f-4081-991b-1d462930f064.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1484,	'Avalon',	'c1051316caf21845eec6057ed8489214',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_avalon/f2592575-7166-4ec7-b609-aedbc32c7279.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1499,	'Age of Discovery',	'20cd279dee908c992f8b764ffe210169',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_ageofdiscovery/9694a442-c36f-49c1-a50a-fa20a1f3f22c.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(2365,	'Bone Bonanza',	'7d05837c55942cf0f36e2597b7e0ae76',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(1488,	'Asian Beauty',	'90da73be20eab0c1510bc0779fda6077',	'Slots',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/Microgaming/mg_slots_asianbeauty/fd239630-0e4a-43b0-86a7-f62ea162d71d.jpg?w=320',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(714,	'Blackjack X 7 - Azure',	'd64c9a0d9886af9532f70aaa53e622b3',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/513/cad1bdca-fb1d-43b6-af20-94dc8319de2f.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(702,	'Blackjack X 20 - Ruby',	'6255ddedaa5f480b9dfa9fa40f7b8326',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3020/f360ddc7-9bc4-42db-9fec-5fd1bc7057cc.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(704,	'Blackjack X 15 - Ruby',	'a0ee8dc9da394e4b9ae9ad5c9ea1e722',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3015/86abdd9f-4ca7-482f-8bff-8fd256acec9f.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(710,	'BlackjackX 21 - Ruby',	'3e5004fa6ad33e9c5130b1017c0ac6b2',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3021/1aa4a757-541d-4a19-81d0-d4be79094fd5.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(707,	'Blackjack X 8 - Ruby',	'ae96e109c6ebb6b93a5f89c5a61bbfda',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3008/ae71989e-e460-44ef-8f37-4f92110f4c7c.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(719,	'BlackjackX 24 - Azure',	'd9b511ca291529bfe669a154a321386a',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3024/b8bec669-e882-4585-b27a-f58e7697e690.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(720,	'BlackjackX 25 - Azure',	'ac1e682e6ce50f787124ef4daf01f691',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3025/927b8369-749d-4b7d-a6a2-eb593d4c9f8b.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(721,	'BlackjackX 11 - Emerald',	'c730a004b714edfdd4f0c42e9e81fd23',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3046/54142846-a509-4a2f-aaff-403ef4e736aa.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(725,	'BlackjackX 23 - Emerald',	'3e0d79b9e524d8d9888848559192611e',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3050/02f47491-22d1-40ad-8e0e-f637e4577047.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(727,	'BlackjackX 27 - Emerald',	'17785357bb6ff50b3d252fe4300cb881',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3052/4b15e675-6b12-41e6-943e-366a0bf7c0a8.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(729,	'BlackjackX 29 - Emerald',	'3c0994fc8d99afdc3e8b290867679f30',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/3054/500d498b-45ab-46c0-a163-c10c6b283ed3.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(660,	'Mega Baccarat',	'fc836890aa838e03419a2751af98d0ce',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/442/c3c4f460-1339-4d5c-9e66-6f1407978725.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(731,	'One Blackjack',	'892c91e0a653ba19df81a90f89d99bcd',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/901/03abbf6d-d337-4b9b-924c-6ef73f035a0b.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(649,	'Privé Lounge Baccarat 1',	'422384b37bffa38f63d24f6d9e098950',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/454/c4106033-edc9-4bb3-98ba-20a3af5184a8.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(652,	'Privé Lounge Baccarat 4',	'7cd376336ab4101f48c0c8d44fcbdd81',	'CasinoLive',	'',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(631,	'Speed Baccarat 15',	'b8b814a4ce5f191c4a818018db607281',	'CasinoLive',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/427/73c059f8-c8b1-41d9-a48f-3b3da358639d.jpg?w=320',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(812,	'Salon Prive Blackjack',	'9f944a6cb336df7664f81e3ff6aba50e',	'CasinoLive',	'https://d3c3rwqla6qxaf.cloudfront.net/games-images/ezugi/blackjacksalonprive/427x575/BlackjackSalonPrive.webp',	't',	'2025-03-28 18:19:23.906502+00',	'2025-03-28 18:19:23.906502+00',	'ezugi'),
(786,	'Gold Blackjack 1',	'2955688bdb4f23686e3ce61b905aafeb',	'CasinoLive',	'https://d3c3rwqla6qxaf.cloudfront.net/games-images/ezugi/blackjackgold1/427x575/BlackjackGold1_1739896020.webp',	't',	'2025-03-28 18:19:23.906502+00',	'2025-03-28 18:19:23.906502+00',	'ezugi'),
(2021,	'Fortune Gems 2',	'664fba4da609ee82b78820b1f570f4ad',	'Slot Game',	'https://huidu-buckhttps://bc.imgix.net/game/image/13820_Fortune%20Gems%202.png?_v=4&auto=format&dpr=1.25&w=200et.s3.ap-southeast-1.amazonaws.com/api/jili/Fortune-Gems-2.png',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(2094,	'Fortune Gems 3',	'63927e939636f45e9d6d0b3717b3b1c1',	'Slot Game',	'https://bc.imgix.net/game/image/5173237285.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(2049,	'Fortune Bingo',	'2fd70535a3c838a438b4b8003ecce49d',	'Table Game',	'https://bc.imgix.net/game/image/13476_Fortune%20Bingo.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(2001,	'Ali Baba',	'cc686634b4f953754b306317799f1f39',	'Slot Game',	'https://bc.imgix.net/game/image/13446_Ali%20Baba.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(2079,	'AK47',	'488c377662cad37a551bde18e2fbe785',	'India Poker Game',	'https://bc.imgix.net/game/image/1ab23996-631d-40a5-be8c-2a2e67d4e41d.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(1965,	'Shanghai Beauty',	'795d0cae623cbf34d7f1aa93bbcded28',	'Slot Game',	'https://bc.imgix.net/game/image/13422_Shanghai%20Beauty.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(2004,	'Book of Gold',	'6b283c434fd44250d83b7c2420f164f9',	'Slot Game',	'https://bc.imgix.net/game/image/13449_Book%20of%20Gold.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(2018,	'Golden Joker',	'f301fe0b22d1540b1f215d282b20c642',	'Slot Game',	'https://bc.imgix.net/game/image/13463_Golden%20Joker.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(1328,	'Playboy Fortunes',	'77a75ea71bf69fc3b24de3ad49b2b956',	'Slots',	'https://bc.imgix.net/game/image/4b95d9d1-791f-4fd7-b394-918521766e7d.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1288,	'Sugar Craze Bonanza',	'5e4e00fa58ba25a4c9c981e5aa16c84c',	'Slots',	'https://bc.imgix.net/game/image/13715_Sugar%20Craze%20Bonanza.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1447,	'Candy Rush Wilds',	'1f166f78d4346a4c193733a20a295cee',	'Slots',	'https://bc.imgix.net/game/image/13103_Candy%20Rush%20Wilds.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1452,	'Break Da Bank Again MEGAWAYS',	'e955e85224c20a9603f065d3c18a5620',	'Slots',	'https://bc.imgix.net/game/image/8889_Break%20Da%20Bank%20Again%E2%84%A2%20MEGAWAYS%E2%84%A2.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1522,	'Almighty Dionysus Empire',	'5cc75b479a8afe74aa4d0c082f6c0e0c',	'Slots',	'https://bc.imgix.net/game/image/67cfb3e8ff.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1230,	'Break Away Max',	'5172b9d610de76f84fe4eb5e27d3eb1a',	'Slots',	'https://bc.imgix.net/game/image/929e2ad723.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1284,	'Tally Ho',	'8cb5c467a309e5e406c65689889bd190',	'Slots',	'https://bc.imgix.net/game/image/52b1a433-52dc-4418-b347-b51284cb06e0.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-03-28 19:13:08.397003+00',	'2025-03-28 19:13:08.397003+00',	'microgaming'),
(1655,	'Mask Carnival',	'adf297c2666c69b3abc3b61618d593b8',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/PGSoft/pgs_maskcarnival/791f821c-d2d4-4d1f-90e5-9a1aa063b46a.jpg?w=640',	't',	'2025-03-28 19:31:36.487748+00',	'2025-03-28 19:31:36.487748+00',	'pgsoft'),
(1653,	'Spirited Wonders',	'87a05c81af5635bed41765bfd076ee15',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/PGSoft/pgs_spiritedwonders/1b7541ed-fe6c-4ca0-96b4-f2ed37f2e4f8.jpg?w=640',	't',	'2025-03-28 19:31:36.487748+00',	'2025-03-28 19:31:36.487748+00',	'pgsoft'),
(1659,	'Butterfly Blossom',	'116989bb267a72035bd01818c5496126',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/PGSoft/pgs_butterflyblossom/953ba9a3-1b46-48bd-9062-cc092bc3cfc3.jpg?w=640',	't',	'2025-03-28 19:31:36.487748+00',	'2025-03-28 19:31:36.487748+00',	'pgsoft'),
(1666,	'Totem Wonders',	'a03c6e7a918132b50f9caa297df1752d',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/PGSoft/pgs_totemwonders/a6771f64-6d59-45bb-ba2f-86d73c58488f.jpg?w=640',	't',	'2025-03-28 19:31:36.487748+00',	'2025-03-28 19:31:36.487748+00',	'pgsoft'),
(1673,	'Bakery Bonanza',	'd0fe7aa2f7ed5778190b1e60d94e6773',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/HUB88/PGSoft/pgs_bakerybonanza/cd36b26d-13b8-4b14-a3f9-0dbc527ef7a2.jpg?w=640',	't',	'2025-03-28 19:31:36.487748+00',	'2025-03-28 19:31:36.487748+00',	'pgsoft'),
(929,	'Octobeer Fortunes',	'27ac78d33471d4406de187759ebe4729',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/vs20octobeer/ebd4d0a7-c523-428a-a1b8-2570602d052c.jpg?w=640',	't',	'2025-03-28 18:49:48.388269+00',	'2025-03-28 18:49:48.388269+00',	'pragmatic'),
(936,	'Big Bass Splash',	'a1dfe25af8aa67b40e3f5c2b090a7f66',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/vs10txbigbass/a72b5600-107c-4f4f-9ff4-894e81232681.jpg?w=640',	't',	'2025-03-28 18:49:48.388269+00',	'2025-03-28 18:49:48.388269+00',	'pragmatic'),
(945,	'Goblin Heist Powernudge',	'db9b48adb0db83131d1568968c64f8c1',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/vs20gobnudge/78a1165b-36c9-41cd-a9bd-a498c2eef729.jpg?w=640',	't',	'2025-03-28 18:49:48.388269+00',	'2025-03-28 18:49:48.388269+00',	'pragmatic'),
(957,	'Snakes and Ladders Megadice',	'1cd886e37f8219d223515d7f07693069',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/vs10snakeladd/0dd9d988-7a22-4037-b187-008d9c39ac32.jpg?w=640',	't',	'2025-03-28 18:49:48.388269+00',	'2025-03-28 18:49:48.388269+00',	'pragmatic'),
(964,	'Elemental Gems Megaways',	'b83d0a110632be33daadc8c2eb8bca54',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/vswayselements/c9f5ec70-7e53-4963-9215-512d53b4126b.jpg?w=640',	't',	'2025-03-28 18:49:48.388269+00',	'2025-03-28 18:49:48.388269+00',	'pragmatic'),
(998,	'5 Lions Megaways',	'b066c2bdef0f2d541a2317ed5fdac3b4',	'Slot Game',	'https://www.coincasino.com/cdn/imported_games_images/PRAGMATIC/PRAGMATIC/vswayslions/968a2b53-ff32-434e-b495-c71956a6193f.jpg?w=640',	't',	'2025-03-28 18:49:48.388269+00',	'2025-03-28 18:49:48.388269+00',	'pragmatic'),
(2366,	'Maneki 88 Fortunes',	'05d6232a3336a2b4bb2ee83b4b6bcf7d',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2367,	'Wild Cash Dice',	'94783ae2695c2546da00bec3213fcfa0',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2405,	'Heads and Tails XY',	'863bb7621c9909ef5483108f85750b39',	'Casual',	'https://bc.imgix.net/game/image/1591_Heads and Tails.png?_v=4&auto=format&dpr=1.25&w=200',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2368,	'Savage Buffalo Spirit Megaways',	'042f069ea08ab7fb50af2027b2d93725',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2369,	'Dice Million',	'7caaf05ebb3220afa82d1282ebb32599',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2370,	'Luck & Magic',	'171528b4e159244dff9de7e537708a99',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2371,	'Dice Bonanza',	'7806e2ca21a05eb927da4afad816fdeb',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2372,	'Beast Band',	'354e70824d5468eae2ae3f629c22deca',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2373,	'Wild Chicago',	'207fc056bea06ee353baeaadd6f3b8f4',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2378,	'Royal High-Road',	'958d6a70afac2422d0f97fc81bea4c15',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2379,	'Alien Fruits',	'32bb0d3d65638efaf0e5efe17728bff9',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2381,	'Easter Plinko',	'4f0f7204c7aa6d5ff46f151a4449774f',	'Casual',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2382,	'Book of Kemet',	'431eb425b953b75fc4c9162c72bbc8b2',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2383,	'Lucky Oak',	'248e5efc4ef196ae0544413d919153f6',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2384,	'Sweet Rush Megaways',	'110431082a41df5e51d0abc773886d79',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2392,	'Halloween Bonanza',	'3a62ca00bf4534a60c74efe380ebe307',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2393,	'Beer Bonanza',	'ba016ab1146511e9a071fc1f358e8103',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2394,	'Forty Fruity Million',	'f47d7fec5e314d740c193b9bafedced8',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2395,	'Wild Cash x9990',	'72d2fe00c6d3695653e21618eff3bf78',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2396,	'Maneki 88 Gold',	'7ad352371599bf26cdb06088fe5a79ab',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2397,	'Miss Cherry Fruits Jackpot Party',	'e8b58f6c315f13ca2656c8223b424c83',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2398,	'Lady Wolf Moon Megaways',	'994b39d2a09a9adef5a4a906cae22ce5',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2399,	'Gold Rush with Johnny Cash',	'c85996149a518981e5ec641bd33936c9',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2400,	'Big Atlantis Frenzy',	'a290e7d0adc3f98fb3020ac6f260d704',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2401,	'Penny Pelican',	'064f8c5df69877fd0aba492071151248',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2402,	'Wild Cash',	'be8b9cd2c900644f953fc3ec1dde20e3',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2403,	'Lucky Farm Bonanza',	'a0fb85138588c143d2a496dd018b8874',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2404,	'Joker Queen',	'5f2a21d29552a20346014fe0f4406334',	'Video Slot',	'',	't',	'2025-05-04 08:27:24.131354+00',	'2025-05-04 08:27:24.131354+00',	'bgaming'),
(2044,	'Poker King',	'a9b13010273fcb0284c9ef436c5fe2ff',	'Table Game',	'https://tezcdn.io/casino/casino-live/poker.webp',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(555,	'Dragon Tiger',	'1fd20a344c9f147cdef85bbaa7447dcd',	'CasinoLive',	'https://tezcdn.io/casino/casino-live/dragon-tiger.webp',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(370,	'First Person Roulette',	'a82670530f49a6b3445dc1a592a2eb9e',	'CasinoLive',	'https://tezcdn.io/casino/casino-live/roulette2.webp',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(2039,	'7 UP-DOWN',	'f897d3bfa4061b602cd0ce1d1ea88312',	'Table Game',	'https://tezcdn.io/casino/casino-live/7up-down.webp',	't',	'2025-03-30 19:39:26.222855+00',	'2025-03-30 19:39:26.222855+00',	'jili'),
(696,	'Sic Bo',	'17d2621bfb0d446947a49dfa1c6a2445',	'CasinoLive',	'https://tezcdn.io/casino/casino-live/sicbo.webp',	't',	'2025-03-27 19:28:47.429188+00',	'2025-03-27 19:28:47.429188+00',	'pragmaticlive'),
(519,	'Baccarat C',	'21cf3fdf28915845ff76f963695bb8e3',	'CasinoLive',	'https://tezcdn.io/casino/casino-live/baccarat.webp',	't',	'2025-03-27 19:24:10.758202+00',	'2025-03-27 19:24:10.758202+00',	'evolution'),
(831,	'Balloon',	'de88f202c5a8beeaccabbd944f8acfbf',	'CasinoTable',	'https://static-mobile.mbzp67c522.com/su27se/images/games/spribe/Balloon_balloon_en.webp',	't',	'2025-03-28 18:21:21.315621+00',	'2025-03-28 18:21:21.315621+00',	'spribe');

CREATE SEQUENCE logs_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1;

CREATE TABLE "public"."logs" (
    "id" integer DEFAULT nextval('logs_id_seq') NOT NULL,
    "info" text
) WITH (oids = false);


CREATE TABLE "public"."matches" (
    "id" character varying(50) NOT NULL,
    "match_title" character varying(255) NOT NULL,
    "team_one" character varying(100),
    "team_two" character varying(100),
    "result" character varying(100),
    "result_declared_at" timestamptz,
    "created_at" timestamptz DEFAULT now(),
    "updated_at" timestamptz DEFAULT now(),
    CONSTRAINT "matches_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE TABLE "public"."messages" (
    "room_key" text NOT NULL,
    "from_uid" numeric NOT NULL,
    "to_uid" numeric NOT NULL,
    "message" text NOT NULL,
    "date" timestamptz DEFAULT now(),
    "time" text NOT NULL,
    "from_name" text NOT NULL,
    "to_name" text NOT NULL
) WITH (oids = false);


CREATE TABLE "public"."notifications" (
    "title" text NOT NULL,
    "content" text NOT NULL,
    "date" timestamptz DEFAULT now()
) WITH (oids = false);


CREATE SEQUENCE pay_in_transactions_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."pay_in_transactions" (
    "id" integer DEFAULT nextval('pay_in_transactions_id_seq') NOT NULL,
    "user_id" bigint NOT NULL,
    "transaction_id" character varying(255) NOT NULL,
    "out_trade_no" character varying(255) NOT NULL,
    "currency" character varying(10) NOT NULL,
    "amount" numeric(20,8) NOT NULL,
    "pay_amount" numeric(20,8),
    "merchant_ratio" numeric(5,2),
    "real_amount" numeric(20,8),
    "status" smallint DEFAULT '0',
    "pay_type" character varying(20),
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "pay_in_transactions_out_trade_no_key" UNIQUE ("out_trade_no"),
    CONSTRAINT "pay_in_transactions_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "idx_payin_status" ON "public"."pay_in_transactions" USING btree ("status");

CREATE INDEX "idx_payin_user_id" ON "public"."pay_in_transactions" USING btree ("user_id");


CREATE SEQUENCE prioritized_games_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."prioritized_games" (
    "id" integer DEFAULT nextval('prioritized_games_id_seq') NOT NULL,
    "vendor" character varying(50) NOT NULL,
    "game_ids" text NOT NULL,
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "prioritized_games_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "prioritized_games" ("id", "vendor", "game_ids", "created_at", "updated_at") VALUES
(2,	'pragmaticlive',	'681,699,661,693,723,650,695,680,625,735,625,677,670,682,690,689,697,696,712,708',	'2025-03-30 19:45:35.218763',	'2025-03-30 19:45:35.218763'),
(3,	'pgsoft',	'1611,1595,1590,1585,1576,1586,1633,1636,1622,1610,1667,1692,1597,1646,1623,1596,1571,1619,1694,1630',	'2025-03-30 19:45:35.218763',	'2025-03-30 19:45:35.218763'),
(4,	'pragmatic',	'892,1021,919,908,974,1010,1003,1050,979',	'2025-03-30 20:03:13.547799',	'2025-03-30 20:03:13.547799'),
(5,	'microgaming',	'1566,1560,1554,1552,1540,1564,1558,1391,1382,1472, 1496,1422,1423,1404,1432,1417,1420,1411,1426,1434',	'2025-03-30 20:49:05.196925',	'2025-03-30 20:49:05.196925'),
(7,	'netent',	'2250,2101,2098,2236,2120,2155,2290,2167,2184,2102,2223,2166,2192,2121,2143,2119,2109,2160,2161',	'2025-03-31 18:31:04.846269',	'2025-03-31 18:31:04.846269'),
(1,	'evolution',	'2296,343,385,555,407,563,605,378,593,351,367,371,374,380,384,407,606,604,549,558',	'2025-03-30 19:45:35.218763',	'2025-03-30 19:45:35.218763'),
(6,	'ezugi',	'790,745,800,791,742,743',	'2025-03-30 21:55:03.069546',	'2025-03-30 21:55:03.069546'),
(8,	'spribe',	'822,829,830,828,831',	'2025-04-26 19:03:46.274276',	'2025-04-26 19:03:46.274276'),
(9,	'lobby',	'2301,2302,2303,2296',	'2025-05-04 07:44:24.671317',	'2025-05-04 07:44:24.671317'),
(10,	'bgaming',	'2461,2463,2408,2419,2349,2336,2380,2306,2312,2457',	'2025-05-19 21:13:25.407083',	'2025-05-19 21:13:25.407083');

CREATE TABLE "public"."redeembonus" (
    "userid" bigint NOT NULL,
    "code" text NOT NULL,
    "amount" integer NOT NULL,
    "status" text NOT NULL,
    "createdat" timestamp NOT NULL,
    "updatedat" timestamp NOT NULL
) WITH (oids = false);

INSERT INTO "redeembonus" ("userid", "code", "amount", "status", "createdat", "updatedat") VALUES
(1168755224,	'474855',	100,	'redeemed',	'2025-07-31 19:37:03.8518',	'2025-07-31 19:47:53.73836'),
(4195526937,	'AE7B73',	1,	'redeemed',	'2025-07-29 06:48:22.89868',	'2025-08-01 04:17:55.602766'),
(2671612879,	'97209A',	1,	'redeemed',	'2025-08-07 04:11:02.799569',	'2025-08-07 04:28:35.654963'),
(5188413177,	'FC413A',	1,	'active',	'2025-08-07 06:32:52.03231',	'2025-08-07 06:32:52.03231');

CREATE TABLE "public"."rewards" (
    "ownername" text NOT NULL,
    "membername" text,
    "referalCode" text,
    "amount" numeric NOT NULL,
    "createdAt" timestamp NOT NULL,
    "updatedAt" timestamp NOT NULL,
    "coin" text,
    "type" text,
    "locked" boolean DEFAULT true,
    "referalmount" numeric
) WITH (oids = false);

INSERT INTO "rewards" ("ownername", "membername", "referalCode", "amount", "createdAt", "updatedAt", "coin", "type", "locked", "referalmount") VALUES
('deepalithakur290',	'Aliza Vohra',	'deelfmZh',	100,	'2025-07-29 08:06:55.469254',	'2025-07-29 08:06:55.469254',	'bjb',	'referral',	't',	100),
('lok123',	'testmac',	'loktNI3P',	100,	'2025-08-14 10:01:34.790971',	'2025-08-14 10:01:34.790971',	'bjb',	'referral',	't',	100),
('deepalithakur290',	'qwerty',	'deelfmZh',	100,	'2025-08-14 11:35:58.898013',	'2025-08-14 11:35:58.898013',	'bjb',	'referral',	't',	100),
('PriyanshuBhatt',	'testuserthisis',	'PriUXkbx',	100,	'2025-08-14 12:03:49.26526',	'2025-08-14 12:03:49.26526',	'bjb',	'referral',	't',	100),
('deepalithakur290',	'qqwerty',	'deelfmZh',	100,	'2025-08-14 12:07:57.028729',	'2025-08-14 12:07:57.028729',	'bjb',	'referral',	't',	100),
('lok123',	'test1111',	'loktNI3P',	100,	'2025-08-14 12:29:48.608893',	'2025-08-14 12:29:48.608893',	'bjb',	'referral',	't',	100),
('testuserthisis',	'testingtestww',	'tesG8dNP',	100,	'2025-08-14 12:49:00.561483',	'2025-08-14 12:49:00.561483',	'bjb',	'referral',	't',	100);

CREATE SEQUENCE roles_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."roles" (
    "id" integer DEFAULT nextval('roles_id_seq') NOT NULL,
    "name" character varying(50) NOT NULL,
    "level" integer NOT NULL,
    "responsibilities" text,
    CONSTRAINT "roles_name_key" UNIQUE ("name"),
    CONSTRAINT "roles_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "roles" ("id", "name", "level", "responsibilities") VALUES
(1,	'SuperAdmin',	0,	'Full platform control, infinite balance'),
(2,	'Admin',	1,	'Create SubAdmins, fund them, view total hierarchy'),
(3,	'SubAdmin',	2,	'Create Masters, fund them, view own tree'),
(4,	'Master',	3,	'Create Agents, fund them'),
(5,	'Agent',	4,	'Create SubAgents, fund them'),
(6,	'SubAgent',	5,	'Create Users (players), fund them'),
(7,	'User',	6,	'Play games only');

CREATE SEQUENCE roles_keys_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."roles_keys" (
    "id" integer DEFAULT nextval('roles_keys_id_seq') NOT NULL,
    "role_key" text NOT NULL,
    "role" text NOT NULL,
    CONSTRAINT "roles_keys_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "roles_keys_role_key_key" UNIQUE ("role_key")
) WITH (oids = false);

INSERT INTO "roles_keys" ("id", "role_key", "role") VALUES
(1,	'8a37f45e02c57b489f9b5a9949154cf3b8c48540744185c463df5f79f25d9053',	'user'),
(2,	'3c95e1f2a6b8d740c9e3812f5d7694b0a2c8157e943fd6802b5e9c71m4a3h8p9',	'admin');

CREATE TABLE "public"."session_1m" (
    "sessionid" character varying(250),
    "status" character varying(250),
    "win" character varying(250)
) WITH (oids = false);


CREATE TABLE "public"."session_2m" (
    "sessionid" character varying(250),
    "status" character varying(250),
    "win" character varying(250)
) WITH (oids = false);


CREATE TABLE "public"."session_30s" (
    "sessionid" character varying(250),
    "status" character varying(250),
    "win" character varying(250)
) WITH (oids = false);


CREATE TABLE "public"."settings" (
    "bots" text,
    "id" numeric
) WITH (oids = false);


CREATE TABLE "public"."siteconfig" (
    "registerbonus" numeric NOT NULL,
    "createdat" timestamp NOT NULL,
    "updatedat" timestamp NOT NULL,
    "sports" boolean DEFAULT true,
    "affiliatebonus" numeric DEFAULT '20' NOT NULL,
    "comissionpercent" numeric DEFAULT '5' NOT NULL,
    "inr" boolean DEFAULT true,
    "mvr" boolean DEFAULT true,
    "aed" boolean DEFAULT true,
    "pkr" boolean DEFAULT true,
    "cryptocoin" boolean DEFAULT true,
    "bjb" boolean DEFAULT true,
    "casino" boolean DEFAULT true,
    "lotto" boolean DEFAULT true,
    "vipclub" boolean DEFAULT true,
    "clubmembership" boolean DEFAULT true,
    "bonus" boolean DEFAULT true,
    "affiliate" boolean DEFAULT true,
    "crash" boolean DEFAULT true,
    "originals" boolean DEFAULT true,
    "livegames" boolean DEFAULT true,
    "slotsgames" boolean DEFAULT true,
    "alllivegames" boolean DEFAULT true,
    "allslotsgames" boolean DEFAULT true,
    "lotterygames" boolean DEFAULT true,
    "indiangames" boolean DEFAULT true,
    "cards" boolean DEFAULT true,
    "jilli" boolean DEFAULT true,
    "bdt" boolean DEFAULT true,
    "clubrake" numeric,
    "instantgames" boolean DEFAULT true NOT NULL,
    "btc" boolean DEFAULT true NOT NULL,
    "eth" boolean DEFAULT true NOT NULL,
    "ltc" boolean DEFAULT true NOT NULL,
    "bch" boolean DEFAULT true NOT NULL,
    "usdt" boolean DEFAULT true NOT NULL,
    "trx" boolean DEFAULT true NOT NULL,
    "doge" boolean DEFAULT true NOT NULL,
    "ada" boolean DEFAULT true NOT NULL,
    "xrp" boolean DEFAULT true NOT NULL,
    "bnb" boolean DEFAULT true NOT NULL,
    "usdp" boolean DEFAULT true NOT NULL,
    "nexo" boolean DEFAULT true NOT NULL,
    "mkr" boolean DEFAULT true NOT NULL,
    "tusd" boolean DEFAULT true NOT NULL,
    "usdc" boolean DEFAULT true NOT NULL,
    "busd" boolean DEFAULT true NOT NULL,
    "nc" boolean DEFAULT true NOT NULL,
    "npr" boolean DEFAULT true NOT NULL,
    "shib" boolean DEFAULT true NOT NULL,
    "matic" boolean DEFAULT true NOT NULL,
    "sc" boolean DEFAULT true NOT NULL,
    "spribe" boolean DEFAULT true NOT NULL,
    "evolution" boolean DEFAULT true NOT NULL,
    "pragmaticslots" boolean DEFAULT true NOT NULL,
    "pragmaticlive" boolean DEFAULT true NOT NULL,
    "ideal" boolean DEFAULT true NOT NULL,
    "microgaming" boolean DEFAULT true NOT NULL,
    "pgsoft" boolean DEFAULT true NOT NULL,
    "hacksawgaming" boolean DEFAULT true NOT NULL,
    "jili" boolean DEFAULT true NOT NULL,
    "netent" boolean DEFAULT true NOT NULL,
    "esports" boolean DEFAULT true NOT NULL,
    "provablyfair" boolean DEFAULT true NOT NULL
) WITH (oids = false);

INSERT INTO "siteconfig" ("registerbonus", "createdat", "updatedat", "sports", "affiliatebonus", "comissionpercent", "inr", "mvr", "aed", "pkr", "cryptocoin", "bjb", "casino", "lotto", "vipclub", "clubmembership", "bonus", "affiliate", "crash", "originals", "livegames", "slotsgames", "alllivegames", "allslotsgames", "lotterygames", "indiangames", "cards", "jilli", "bdt", "clubrake", "instantgames", "btc", "eth", "ltc", "bch", "usdt", "trx", "doge", "ada", "xrp", "bnb", "usdp", "nexo", "mkr", "tusd", "usdc", "busd", "nc", "npr", "shib", "matic", "sc", "spribe", "evolution", "pragmaticslots", "pragmaticlive", "ideal", "microgaming", "pgsoft", "hacksawgaming", "jili", "netent", "esports", "provablyfair") VALUES
(0,	'2024-12-02 20:48:01.551046',	'2025-08-13 18:34:59.295014',	't',	100,	25,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't');

CREATE SEQUENCE sports_bets_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 114 CACHE 1;

CREATE TABLE "public"."sports_bets" (
    "id" integer DEFAULT nextval('sports_bets_id_seq') NOT NULL,
    "user_id" bigint NOT NULL,
    "game_type" character varying(100) NOT NULL,
    "match_title" character varying(255) NOT NULL,
    "team_one" character varying(255) NOT NULL,
    "team_two" character varying(255) NOT NULL,
    "selection_name" character varying(255) NOT NULL,
    "category" character varying(100) NOT NULL,
    "bet_type" character varying(100) NOT NULL,
    "odds" numeric(10,4) NOT NULL,
    "stake_amount" numeric(15,2) NOT NULL,
    "original_currency" character varying(10) NOT NULL,
    "original_amount" numeric(15,2) NOT NULL,
    "usd_amount" numeric(15,2) NOT NULL,
    "liability" numeric(15,2) NOT NULL,
    "match_start_time" timestamp NOT NULL,
    "match_end_time" timestamp,
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "match_id" character varying(100),
    "exposure_after_bet" numeric(15,2),
    "status" character varying(20),
    "eventid" text,
    CONSTRAINT "sports_bets_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "idx_sports_bets_created_at" ON "public"."sports_bets" USING btree ("created_at");

CREATE INDEX "idx_sports_bets_game_type" ON "public"."sports_bets" USING btree ("game_type");

CREATE INDEX "idx_sports_bets_match_start_time" ON "public"."sports_bets" USING btree ("match_start_time");

CREATE INDEX "idx_sports_bets_user_id" ON "public"."sports_bets" USING btree ("user_id");

INSERT INTO "sports_bets" ("id", "user_id", "game_type", "match_title", "team_one", "team_two", "selection_name", "category", "bet_type", "odds", "stake_amount", "original_currency", "original_amount", "usd_amount", "liability", "match_start_time", "match_end_time", "created_at", "updated_at", "match_id", "exposure_after_bet", "status", "eventid") VALUES
(110,	1168755224,	'MO',	'FK Jablonec v Slavia Prague',	'FK Jablonec',	'Slavia Prague',	'FK Jablonec',	'1',	'lay',	1.6100,	100.00,	'INR',	100.00,	1.20,	61.00,	'2025-08-16 19:34:36.143',	NULL,	'2025-08-16 19:34:36.425517',	'2025-08-16 19:34:36.425517',	'1.246523416',	61.00,	'open',	NULL),
(111,	1168755224,	'MO',	'FK Jablonec v Slavia Prague',	'FK Jablonec',	'Slavia Prague',	'FK Jablonec',	'1',	'back',	1.5400,	100.00,	'INR',	100.00,	1.20,	100.00,	'2025-08-16 19:35:24.81',	NULL,	'2025-08-16 19:35:24.988609',	'2025-08-16 19:35:24.988609',	'1.246523416',	7.00,	'open',	NULL),
(112,	1168755224,	'MO',	'FK Jablonec v Slavia Prague',	'FK Jablonec',	'Slavia Prague',	'FK Jablonec',	'1',	'back',	1.4300,	100.00,	'INR',	100.00,	1.20,	100.00,	'2025-08-16 19:38:39.064',	NULL,	'2025-08-16 19:38:39.235273',	'2025-08-16 19:38:39.235273',	'1.246523416',	100.00,	'open',	NULL),
(113,	1168755224,	'MO',	'FK Jablonec v Slavia Prague',	'FK Jablonec',	'Slavia Prague',	'FK Jablonec',	'1',	'lay',	1.4800,	100.00,	'INR',	100.00,	1.20,	48.00,	'2025-08-16 19:39:09.612',	NULL,	'2025-08-16 19:39:09.795884',	'2025-08-16 19:39:09.795884',	'1.246523416',	12.00,	'open',	NULL),
(114,	4195526937,	'MO',	'Denis Yevseyev v Marat Sharipov',	'Denis Yevseyev',	'Marat Sharipov',	'Denis Yevseyev',	'1',	'back',	1.0200,	100.00,	'INR',	100.00,	1.20,	100.00,	'2025-08-18 04:45:00.028',	NULL,	'2025-08-18 04:44:55.152102',	'2025-08-18 04:44:55.152102',	'1.246758739',	100.00,	'open',	NULL);

CREATE SEQUENCE sports_config_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."sports_config" (
    "id" integer DEFAULT nextval('sports_config_id_seq') NOT NULL,
    "game_id" integer NOT NULL,
    "game_name" character varying(50) NOT NULL,
    "enabled" boolean DEFAULT false,
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "sports_config_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "sports_config" ("id", "game_id", "game_name", "enabled", "created_at", "updated_at") VALUES
(1,	4,	'Cricket',	't',	'2024-12-10 06:16:15.573013',	'2025-01-16 19:25:32.521181'),
(2,	2,	'Tennis',	't',	'2024-12-10 06:16:15.573013',	'2025-01-16 19:25:34.716463'),
(3,	1,	'Soccer',	't',	'2024-12-10 06:16:15.573013',	'2025-01-16 19:25:33.718986'),
(4,	6423,	'American Football',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(5,	7511,	'Baseball',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(6,	7522,	'Basketball',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(7,	6,	'Boxing',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(8,	3503,	'Darts',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(9,	2152880,	'Gaelic Games',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(10,	3,	'Golf',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(11,	4339,	'Greyhound Racing',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(12,	15,	'Greyhound Todays Card',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(13,	13,	'Horse Race Todays Card',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(14,	7,	'Horse Racing',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(15,	26420387,	'Mixed Martial Arts',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(16,	8,	'Motor Sport',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(17,	1477,	'Rugby League',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(18,	5,	'Rugby Union',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678'),
(19,	6422,	'Snooker',	't',	'2025-07-18 21:12:53.747042',	'2025-07-18 21:13:45.828678');

CREATE SEQUENCE staff_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 14 CACHE 1;

DELIMITER ;;;

DELIMITER ;

CREATE TABLE "public"."staff_balances" (
    "staff_id" bigint NOT NULL,
    "inr" numeric DEFAULT '0' NOT NULL,
    CONSTRAINT "staff_balances_pkey" PRIMARY KEY ("staff_id")
) WITH (oids = false);

INSERT INTO "staff_balances" ("staff_id", "inr") VALUES
(14,	1000),
(1,	4982700.96985788600000);

CREATE TABLE "public"."staff_hierarchy" (
    "ancestor_id" bigint NOT NULL,
    "descendant_id" bigint NOT NULL,
    "depth" integer NOT NULL,
    CONSTRAINT "staff_hierarchy_pkey" PRIMARY KEY ("ancestor_id", "descendant_id")
) WITH (oids = false);

INSERT INTO "staff_hierarchy" ("ancestor_id", "descendant_id", "depth") VALUES
(1,	1,	0),
(14,	14,	0),
(1,	14,	1);

CREATE SEQUENCE staff_transfers_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 51 CACHE 1;

CREATE TABLE "public"."staff_transfers" (
    "id" bigint DEFAULT nextval('staff_transfers_id_seq') NOT NULL,
    "from_type" text NOT NULL,
    "from_id" bigint NOT NULL,
    "to_type" text NOT NULL,
    "to_id" bigint NOT NULL,
    "amount" numeric NOT NULL,
    "created_at" timestamptz DEFAULT now() NOT NULL,
    "direction" text,
    CONSTRAINT "staff_transfers_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "staff_transfers_from_id_idx" ON "public"."staff_transfers" USING btree ("from_type", "from_id");

CREATE INDEX "staff_transfers_to_id_idx" ON "public"."staff_transfers" USING btree ("to_type", "to_id");

INSERT INTO "staff_transfers" ("id", "from_type", "from_id", "to_type", "to_id", "amount", "created_at", "direction") VALUES
(1,	'staff',	1,	'user',	1168755224,	10,	'2025-07-18 05:44:12.16047+00',	'deposit'),
(2,	'staff',	1,	'staff',	4,	100,	'2025-07-22 19:29:57.7757+00',	'deposit'),
(3,	'staff',	4,	'user',	3008981754,	50,	'2025-07-22 19:30:26.998686+00',	'deposit'),
(4,	'staff',	1,	'user',	5249927985,	100,	'2025-07-23 10:12:01.689408+00',	'deposit'),
(5,	'staff',	1,	'user',	6178901389,	50,	'2025-07-28 10:16:39.744558+00',	'deposit'),
(6,	'staff',	4,	'staff',	1,	50,	'2025-07-29 04:54:32.834756+00',	NULL),
(7,	'staff',	1,	'staff',	12,	100,	'2025-07-30 05:50:23.602254+00',	'deposit'),
(8,	'staff',	1,	'staff',	12,	100,	'2025-07-30 05:51:26.393111+00',	'deposit'),
(9,	'staff',	12,	'staff',	1,	200,	'2025-07-30 05:51:48.191371+00',	'withdraw'),
(10,	'staff',	1,	'staff',	8,	100,	'2025-07-30 05:52:04.142814+00',	'deposit'),
(11,	'staff',	1,	'staff',	9,	90,	'2025-08-07 04:00:10.195943+00',	'deposit'),
(12,	'staff',	8,	'staff',	1,	90,	'2025-08-07 04:00:37.053183+00',	'withdraw'),
(13,	'staff',	9,	'staff',	1,	90,	'2025-08-07 06:04:43.427723+00',	'withdraw'),
(14,	'staff',	8,	'staff',	1,	10,	'2025-08-07 06:04:53.017502+00',	'withdraw'),
(15,	'staff',	1,	'user',	1168755224,	100,	'2025-08-07 06:12:10.901425+00',	'deposit'),
(16,	'staff',	1,	'user',	1168755224,	87.75386095049717,	'2025-08-07 12:03:15.608411+00',	'deposit'),
(17,	'staff',	1,	'user',	1168755224,	1,	'2025-08-07 12:26:41.267879+00',	'deposit'),
(18,	'staff',	1,	'user',	1168755224,	1,	'2025-08-07 12:28:23.973861+00',	'deposit'),
(19,	'staff',	1,	'user',	1168755224,	1,	'2025-08-07 12:28:48.46768+00',	'deposit'),
(20,	'user',	1168755224,	'staff',	1,	87.75386095049717,	'2025-08-07 12:30:00.176164+00',	'withdraw'),
(21,	'staff',	1,	'user',	2947642541,	87,	'2025-08-07 12:32:07.053837+00',	'deposit'),
(22,	'staff',	1,	'user',	2947642541,	30,	'2025-08-08 06:12:55.418721+00',	'deposit'),
(23,	'user',	2947642541,	'staff',	1,	700,	'2025-08-12 08:02:36.523116+00',	'withdraw'),
(24,	'staff',	1,	'user',	2947642541,	1000,	'2025-08-12 08:12:09.111846+00',	'deposit'),
(25,	'user',	2947642541,	'staff',	1,	1000,	'2025-08-12 08:12:23.067962+00',	'withdraw'),
(26,	'staff',	1,	'user',	2947642541,	1000,	'2025-08-12 08:13:37.384399+00',	'deposit'),
(27,	'user',	2947642541,	'staff',	1,	500545035354.94824,	'2025-08-12 08:15:01.132451+00',	'withdraw'),
(28,	'user',	2947642541,	'staff',	1,	10428021569.894754,	'2025-08-12 08:15:38.204523+00',	'withdraw'),
(29,	'staff',	1,	'user',	2947642541,	70,	'2025-08-12 08:19:56.310568+00',	'deposit'),
(30,	'staff',	1,	'user',	2947642541,	10000,	'2025-08-12 08:23:28.610995+00',	'deposit'),
(31,	'user',	2947642541,	'staff',	1,	10000,	'2025-08-12 08:23:42.869898+00',	'withdraw'),
(32,	'staff',	1,	'user',	2947642541,	10427933.873136114,	'2025-08-12 08:24:12.93798+00',	'deposit'),
(33,	'staff',	1,	'user',	1168755224,	100,	'2025-08-12 08:56:11.614093+00',	'deposit'),
(34,	'staff',	1,	'user',	8349173169,	1000,	'2025-08-12 10:34:36.889171+00',	'deposit'),
(35,	'staff',	1,	'user',	9965188749,	100,	'2025-08-12 11:58:33.409567+00',	'deposit'),
(36,	'staff',	1,	'user',	1168755224,	1000,	'2025-08-12 12:25:30.341296+00',	'deposit'),
(37,	'staff',	1,	'user',	1168755224,	100,	'2025-08-12 12:25:49.236611+00',	'deposit'),
(38,	'staff',	1,	'user',	1168755224,	100,	'2025-08-12 12:28:07.590894+00',	'deposit'),
(39,	'staff',	1,	'user',	1168755224,	5,	'2025-08-12 12:33:42.243827+00',	'deposit'),
(40,	'user',	1168755224,	'staff',	1,	200,	'2025-08-12 18:56:42.258688+00',	'withdraw'),
(41,	'staff',	1,	'user',	1168755224,	2000,	'2025-08-12 19:06:47.358974+00',	'deposit'),
(42,	'staff',	1,	'user',	7654769296,	1000,	'2025-08-13 04:31:26.674834+00',	'deposit'),
(43,	'staff',	1,	'user',	8218194912,	1000,	'2025-08-14 08:09:29.805473+00',	'deposit'),
(44,	'staff',	1,	'user',	2192231263,	100,	'2025-08-14 09:59:50.720355+00',	'deposit'),
(45,	'staff',	1,	'user',	8467591381,	1000,	'2025-08-14 10:03:10.331849+00',	'deposit'),
(46,	'staff',	1,	'user',	8218194912,	10000,	'2025-08-14 10:22:53.487122+00',	'deposit'),
(47,	'staff',	1,	'user',	2192231263,	100,	'2025-08-14 11:56:03.111078+00',	'deposit'),
(48,	'staff',	1,	'user',	9965188749,	100,	'2025-08-14 11:56:29.349591+00',	'deposit'),
(49,	'staff',	1,	'user',	1798669613,	900,	'2025-08-14 12:09:33.424297+00',	'deposit'),
(50,	'staff',	1,	'staff',	14,	1000,	'2025-08-15 18:39:35.696574+00',	'deposit'),
(51,	'staff',	1,	'user',	9552925998,	100,	'2025-08-18 06:02:12.503949+00',	'deposit');

DELIMITER ;;

CREATE TRIGGER "t_staff_fd" AFTER INSERT ON "public"."staff_transfers" FOR EACH ROW EXECUTE FUNCTION trg_staff_first_deposit();;

DELIMITER ;

CREATE TABLE "public"."staff_whatsapp_ref" (
    "staff_id" bigint NOT NULL,
    "slug" text NOT NULL,
    "phone" text NOT NULL,
    "created_at" timestamp DEFAULT now(),
    CONSTRAINT "staff_whatsapp_ref_pkey" PRIMARY KEY ("staff_id"),
    CONSTRAINT "staff_whatsapp_ref_slug_key" UNIQUE ("slug")
) WITH (oids = false);

CREATE INDEX "staff_whatsapp_ref_slug_idx" ON "public"."staff_whatsapp_ref" USING btree ("slug");

INSERT INTO "staff_whatsapp_ref" ("staff_id", "slug", "phone", "created_at") VALUES
(14,	'jdj9rbb',	'6283431134',	'2025-08-15 18:37:19.051917');

CREATE SEQUENCE swap_history_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 29 CACHE 1;

CREATE TABLE "public"."swap_history" (
    "id" bigint DEFAULT nextval('swap_history_id_seq') NOT NULL,
    "uid" bigint NOT NULL,
    "from_currency" character varying(10) NOT NULL,
    "to_currency" character varying(10) NOT NULL,
    "from_amount" numeric(20,8) NOT NULL,
    "to_amount" numeric(20,8) NOT NULL,
    "fee_percentage" numeric(5,4) NOT NULL,
    "fee_amount" numeric(20,8) NOT NULL,
    "fee_currency" character varying(10) NOT NULL,
    "usd_rate_from" numeric(20,8) NOT NULL,
    "usd_rate_to" numeric(20,8) NOT NULL,
    "created_at" timestamp DEFAULT now() NOT NULL,
    CONSTRAINT "swap_history_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "idx_swap_history_uid" ON "public"."swap_history" USING btree ("uid");

INSERT INTO "swap_history" ("id", "uid", "from_currency", "to_currency", "from_amount", "to_amount", "fee_percentage", "fee_amount", "fee_currency", "usd_rate_from", "usd_rate_to", "created_at") VALUES
(1,	3241962943,	'INR',	'BTC',	100.00000000,	0.00000825,	0.1500,	15.00000000,	'INR',	0.01153005,	118758.00000000,	'2025-07-29 05:59:33.934602'),
(2,	4195526937,	'INR',	'BTC',	100.00000000,	0.00000824,	0.1500,	15.00000000,	'INR',	0.01153005,	118977.00000000,	'2025-07-29 06:40:43.725433'),
(3,	4195526937,	'INR',	'USDT',	150.00000000,	1.47019752,	0.1500,	22.50000000,	'INR',	0.01153005,	0.99992100,	'2025-07-29 06:43:54.754481'),
(4,	4195526937,	'INR',	'ETH',	2000.00000000,	0.00529018,	0.1500,	300.00000000,	'INR',	0.01139551,	3661.95000000,	'2025-08-07 05:19:37.53322'),
(5,	3241962943,	'INR',	'USDT',	416.00000000,	4.02945234,	0.1500,	62.40000000,	'INR',	0.01139551,	1.00000000,	'2025-08-07 05:20:04.106175'),
(6,	3241962943,	'USDT',	'INR',	4.00000000,	347.50528936,	0.0100,	0.04000000,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 05:21:49.75102'),
(7,	4195526937,	'ETH',	'INR',	0.00500000,	1593.03374750,	0.0100,	0.00005000,	'ETH',	3667.36000000,	0.01139551,	'2025-08-07 05:22:12.707641'),
(8,	3241962943,	'USDT',	'INR',	0.02900000,	2.51941335,	0.0100,	0.00029000,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 05:22:57.526495'),
(9,	4195526937,	'INR',	'BTC',	10.00000000,	0.00000085,	0.1500,	1.50000000,	'INR',	0.01139551,	114375.00000000,	'2025-08-07 05:25:52.405564'),
(10,	3241962943,	'USDT',	'INR',	0.00045200,	0.03926810,	0.0100,	0.00000452,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 10:26:32.735234'),
(11,	3241962943,	'BTC',	'INR',	0.00000825,	82.80664446,	0.0100,	0.00000008,	'BTC',	115534.00000000,	0.01139551,	'2025-08-07 10:27:22.345926'),
(12,	4195526937,	'USDT',	'INR',	1.47000000,	127.70819384,	0.0100,	0.01470000,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 10:55:42.421139'),
(13,	4195526937,	'USDT',	'INR',	0.00019700,	0.01711464,	0.0100,	0.00000197,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 10:56:08.266306'),
(14,	4195526937,	'USDT',	'INR',	0.00000052,	0.00004518,	0.0100,	0.00000001,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 10:56:27.903959'),
(15,	4195526937,	'ETH',	'INR',	0.00029000,	96.06724649,	0.0100,	0.00000290,	'ETH',	3813.08000000,	0.01139551,	'2025-08-07 10:56:49.251173'),
(16,	4195526937,	'ETH',	'INR',	0.00000010,	0.03312664,	0.0100,	0.00000000,	'ETH',	3813.08000000,	0.01139551,	'2025-08-07 10:57:25.791914'),
(17,	4195526937,	'BTC',	'INR',	0.00000900,	90.96941339,	0.0100,	0.00000009,	'BTC',	116346.00000000,	0.01139551,	'2025-08-07 10:57:55.151091'),
(18,	4195526937,	'BTC',	'INR',	0.00000008,	0.80861701,	0.0100,	0.00000000,	'BTC',	116346.00000000,	0.01139551,	'2025-08-07 10:58:25.061567'),
(19,	3241962943,	'INR',	'BTC',	2500.00000000,	0.00020811,	0.1500,	375.00000000,	'INR',	0.01139551,	116360.00000000,	'2025-08-07 11:02:59.094376'),
(20,	3241962943,	'BTC',	'INR',	0.00020000,	2021.78577352,	0.0100,	0.00000200,	'BTC',	116360.00000000,	0.01139551,	'2025-08-07 11:03:56.304359'),
(21,	3241962943,	'BTC',	'INR',	0.00000810,	81.88232383,	0.0100,	0.00000008,	'BTC',	116360.00000000,	0.01139551,	'2025-08-07 11:04:18.114199'),
(22,	3241962943,	'BTC',	'INR',	0.00000001,	0.10108929,	0.0100,	0.00000000,	'BTC',	116360.00000000,	0.01139551,	'2025-08-07 11:04:38.054437'),
(23,	3241962943,	'USDT',	'INR',	0.00000030,	0.00002606,	0.0100,	0.00000000,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 11:05:38.727107'),
(24,	3241962943,	'INR',	'USDT',	2000.00000000,	19.37236700,	0.1500,	300.00000000,	'INR',	0.01139551,	1.00000000,	'2025-08-07 11:06:32.723866'),
(25,	3241962943,	'USDT',	'INR',	19.37000000,	1682.79436375,	0.0100,	0.19370000,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 11:06:55.155162'),
(26,	3241962943,	'USDT',	'INR',	0.00230000,	0.19981554,	0.0100,	0.00002300,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 11:07:26.101541'),
(27,	3241962943,	'USDT',	'INR',	0.00006700,	0.00582071,	0.0100,	0.00000067,	'USDT',	1.00000000,	0.01139551,	'2025-08-07 11:07:51.923042'),
(28,	4195526937,	'BTC',	'USDT',	0.00010000,	11.77400916,	0.0100,	0.00000100,	'BTC',	118910.00000000,	0.99983700,	'2025-08-12 08:10:05.495881'),
(29,	2192231263,	'INR',	'USDT',	50.00000000,	0.48569808,	0.1500,	7.50000000,	'INR',	0.01142819,	1.00000000,	'2025-08-14 10:11:10.623148');

CREATE TABLE "public"."team" (
    "ownername" text NOT NULL,
    "membername" text NOT NULL,
    "referalCode" text NOT NULL,
    "createdAt" timestamp NOT NULL,
    "updatedAt" timestamp NOT NULL
) WITH (oids = false);

INSERT INTO "team" ("ownername", "membername", "referalCode", "createdAt", "updatedAt") VALUES
('deepalithakur290',	'Aliza Vohra',	'deelfmZh',	'2025-07-29 08:06:55.467757',	'2025-07-29 08:06:55.467757'),
('lok123',	'testmac',	'loktNI3P',	'2025-08-14 10:01:34.78929',	'2025-08-14 10:01:34.78929'),
('deepalithakur290',	'qwerty',	'deelfmZh',	'2025-08-14 11:35:58.896499',	'2025-08-14 11:35:58.896499'),
('PriyanshuBhatt',	'testuserthisis',	'PriUXkbx',	'2025-08-14 12:03:49.263757',	'2025-08-14 12:03:49.263757'),
('deepalithakur290',	'qqwerty',	'deelfmZh',	'2025-08-14 12:07:57.021035',	'2025-08-14 12:07:57.021035'),
('lok123',	'test1111',	'loktNI3P',	'2025-08-14 12:29:48.607459',	'2025-08-14 12:29:48.607459'),
('testuserthisis',	'testingtestww',	'tesG8dNP',	'2025-08-14 12:49:00.560062',	'2025-08-14 12:49:00.560062');

CREATE SEQUENCE transaction_live_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."transaction_live" (
    "id" integer DEFAULT nextval('transaction_live_id_seq') NOT NULL,
    "method" character varying(20),
    "user_code" character varying(50),
    "user_balance" bigint,
    "game_type" character varying(20),
    "provider_code" character varying(50),
    "game_code" character varying(50),
    "type" character varying(20),
    "bet_money" bigint,
    "win_money" bigint,
    "txn_id" character varying(50),
    "txn_type" character varying(20),
    CONSTRAINT "transaction_live_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE SEQUENCE transaction_slot_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."transaction_slot" (
    "id" integer DEFAULT nextval('transaction_slot_id_seq') NOT NULL,
    "method" character varying(20),
    "user_code" character varying(50),
    "user_balance" bigint,
    "game_type" character varying(20),
    "provider_code" character varying(50),
    "game_code" character varying(50),
    "type" character varying(20),
    "bet_money" bigint,
    "win_money" bigint,
    "txn_id" character varying(50),
    "txn_type" character varying(20),
    CONSTRAINT "transaction_slot_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE SEQUENCE transactions_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."transactions" (
    "id" integer DEFAULT nextval('transactions_id_seq') NOT NULL,
    "login" character varying(255) NOT NULL,
    "session_id" character varying(255) NOT NULL,
    "trade_id" character varying(255) NOT NULL,
    "bet" numeric(12,2) NOT NULL,
    "win" numeric(12,2) NOT NULL,
    "balance_before" numeric(12,2) NOT NULL,
    "balance_after" numeric(12,2) NOT NULL,
    "action" character varying(255) NOT NULL,
    "game_name" character varying(255) NOT NULL,
    "bet_info" text,
    "matrix" text,
    "date" timestamp NOT NULL,
    "win_lines" text,
    CONSTRAINT "transactions_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE SEQUENCE unlocked_rewards_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."unlocked_rewards" (
    "id" integer DEFAULT nextval('unlocked_rewards_id_seq') NOT NULL,
    "uid" bigint NOT NULL,
    "ownername" text NOT NULL,
    "membername" text NOT NULL,
    "referalCode" text NOT NULL,
    "amount" numeric NOT NULL,
    "cointype" text DEFAULT 'sbc',
    "wager_amount" numeric NOT NULL,
    "createdAt" timestamptz DEFAULT now(),
    "claimed" boolean DEFAULT false,
    CONSTRAINT "unlocked_rewards_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE SEQUENCE upideposit_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."upideposit" (
    "id" integer DEFAULT nextval('upideposit_id_seq') NOT NULL,
    "uid" character varying(255) NOT NULL,
    "transactioniduser" character varying(255) NOT NULL,
    "transactionidgateway" character varying(255),
    "transactiondate" character varying(255),
    "amount" text NOT NULL,
    "status" character varying(50),
    CONSTRAINT "upideposit_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE TABLE "public"."user_bonus" (
    "uid" bigint NOT NULL,
    "bonus_type" bonus_type,
    "first_deposit" numeric(18,2),
    "bonus_amount" numeric(18,2),
    "wager_required" numeric(18,2),
    "wager_progress" numeric(18,2) DEFAULT '0',
    "status" text DEFAULT 'pending',
    "created_at" timestamptz DEFAULT now() NOT NULL,
    "updated_at" timestamptz DEFAULT now() NOT NULL,
    "claimed_at" timestamptz,
    "selected" boolean DEFAULT false NOT NULL,
    CONSTRAINT "user_bonus_pkey" PRIMARY KEY ("uid")
) WITH (oids = false);

INSERT INTO "user_bonus" ("uid", "bonus_type", "first_deposit", "bonus_amount", "wager_required", "wager_progress", "status", "created_at", "updated_at", "claimed_at", "selected") VALUES
(2947642541,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-21 19:30:13.641889+00',	'2025-07-21 19:30:13.641889+00',	NULL,	'f'),
(1168755224,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-21 19:30:13.641889+00',	'2025-07-21 19:30:13.641889+00',	NULL,	'f'),
(3975178196,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-28 05:25:00.215374+00',	'2025-07-28 05:25:00.215374+00',	NULL,	'f'),
(4195526937,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-29 05:10:01.716437+00',	'2025-07-29 05:10:01.716437+00',	NULL,	'f'),
(3241962943,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-29 05:14:51.95638+00',	'2025-07-29 05:14:51.95638+00',	NULL,	'f'),
(2619588846,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-29 05:41:21.812613+00',	'2025-07-29 05:41:21.812613+00',	NULL,	'f'),
(3738919191,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-29 12:42:36.545657+00',	'2025-07-29 12:42:36.545657+00',	NULL,	'f'),
(8349173169,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-29 14:25:00.022287+00',	'2025-07-29 14:25:00.022287+00',	NULL,	'f'),
(4322449355,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 04:05:01.322413+00',	'2025-07-30 04:05:01.322413+00',	NULL,	'f'),
(3318375122,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 07:03:22.360966+00',	'2025-07-30 07:03:22.360966+00',	NULL,	'f'),
(3323544953,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 11:49:29.532433+00',	'2025-07-30 11:49:29.532433+00',	NULL,	'f'),
(7485641837,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 12:07:19.660762+00',	'2025-07-30 12:07:19.660762+00',	NULL,	'f'),
(8218194912,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 12:13:30.308492+00',	'2025-07-30 12:13:30.308492+00',	NULL,	'f'),
(8295691855,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 12:15:17.336258+00',	'2025-07-30 12:15:17.336258+00',	NULL,	'f'),
(5515176843,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 12:19:09.872661+00',	'2025-07-30 12:19:09.872661+00',	NULL,	'f'),
(3697552633,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-30 12:23:01.336804+00',	'2025-07-30 12:23:01.336804+00',	NULL,	'f'),
(9519742614,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 09:27:19.988131+00',	'2025-07-31 09:27:19.988131+00',	NULL,	'f'),
(7964322788,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 09:30:03.205915+00',	'2025-07-31 09:30:03.205915+00',	NULL,	'f'),
(2657598997,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 09:43:30.430678+00',	'2025-07-31 09:43:30.430678+00',	NULL,	'f'),
(5543122114,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 09:47:47.475998+00',	'2025-07-31 09:47:47.475998+00',	NULL,	'f'),
(8142391878,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 12:52:04.150566+00',	'2025-07-31 12:52:04.150566+00',	NULL,	'f'),
(9537511515,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 12:53:15.663819+00',	'2025-07-31 12:53:15.663819+00',	NULL,	'f'),
(3149553966,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-07-31 12:55:38.531867+00',	'2025-07-31 12:55:38.531867+00',	NULL,	'f'),
(7568636934,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 03:14:27.448927+00',	'2025-08-01 03:14:27.448927+00',	NULL,	'f'),
(6992971844,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 03:50:03.500953+00',	'2025-08-01 03:50:03.500953+00',	NULL,	'f'),
(4542777555,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 08:39:06.322479+00',	'2025-08-01 08:39:06.322479+00',	NULL,	'f'),
(8986325388,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 09:02:19.676257+00',	'2025-08-01 09:02:19.676257+00',	NULL,	'f'),
(1972273847,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 09:04:14.49608+00',	'2025-08-01 09:04:14.49608+00',	NULL,	'f'),
(2192231263,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 10:06:57.025792+00',	'2025-08-01 10:06:57.025792+00',	NULL,	'f'),
(5444377295,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 11:17:12.753666+00',	'2025-08-01 11:17:12.753666+00',	NULL,	'f'),
(5527192744,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-01 12:24:42.369606+00',	'2025-08-01 12:24:42.369606+00',	NULL,	'f'),
(9563822966,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-02 06:49:12.208204+00',	'2025-08-02 06:49:12.208204+00',	NULL,	'f'),
(8953649364,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-04 06:46:01.077099+00',	'2025-08-04 06:46:01.077099+00',	NULL,	'f'),
(8677383327,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-04 06:59:22.188473+00',	'2025-08-04 06:59:22.188473+00',	NULL,	'f'),
(6849137526,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-04 08:01:07.497317+00',	'2025-08-04 08:01:07.497317+00',	NULL,	'f'),
(8876775185,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-05 00:33:49.713705+00',	'2025-08-05 00:33:49.713705+00',	NULL,	'f'),
(1378438125,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 04:36:15.416531+00',	'2025-08-06 04:36:15.416531+00',	NULL,	'f'),
(3185197329,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 05:10:40.058669+00',	'2025-08-06 05:10:40.058669+00',	NULL,	'f'),
(1467427295,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 10:36:42.952732+00',	'2025-08-06 10:36:42.952732+00',	NULL,	'f'),
(7463544444,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 11:38:27.328061+00',	'2025-08-06 11:38:27.328061+00',	NULL,	'f'),
(2671612879,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 11:39:33.70213+00',	'2025-08-06 11:39:33.70213+00',	NULL,	'f'),
(3949828149,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 11:40:45.80989+00',	'2025-08-06 11:40:45.80989+00',	NULL,	'f'),
(5188413177,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 11:47:16.409046+00',	'2025-08-06 11:47:16.409046+00',	NULL,	'f'),
(1842945641,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 11:50:04.350497+00',	'2025-08-06 11:50:04.350497+00',	NULL,	'f'),
(9768223461,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-06 11:57:25.353243+00',	'2025-08-06 11:57:25.353243+00',	NULL,	'f'),
(1655619383,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-07 03:17:37.577272+00',	'2025-08-07 03:17:37.577272+00',	NULL,	'f'),
(3116637147,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-07 06:37:27.500393+00',	'2025-08-07 06:37:27.500393+00',	NULL,	'f'),
(8362255819,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-11 04:47:36.179687+00',	'2025-08-11 04:47:36.179687+00',	NULL,	'f'),
(9965188749,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-11 12:08:40.405955+00',	'2025-08-11 12:08:40.405955+00',	NULL,	'f'),
(5214887864,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-11 13:24:47.651343+00',	'2025-08-11 13:24:47.651343+00',	NULL,	'f'),
(6296468455,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-11 16:56:41.177592+00',	'2025-08-11 16:56:41.177592+00',	NULL,	'f'),
(9298451353,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-11 17:32:42.940698+00',	'2025-08-11 17:32:42.940698+00',	NULL,	'f'),
(8843181811,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-12 09:49:55.546807+00',	'2025-08-12 09:49:55.546807+00',	NULL,	'f'),
(5535982869,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-12 19:10:25.143536+00',	'2025-08-12 19:10:25.143536+00',	NULL,	'f'),
(7654769296,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-13 04:03:35.009567+00',	'2025-08-13 04:03:35.009567+00',	NULL,	'f'),
(1245126654,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-13 10:35:20.769193+00',	'2025-08-13 10:35:20.769193+00',	NULL,	'f'),
(8697663143,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-13 11:56:29.869956+00',	'2025-08-13 11:56:29.869956+00',	NULL,	'f'),
(8467591381,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 04:51:22.908848+00',	'2025-08-14 04:51:22.908848+00',	NULL,	'f'),
(2945191225,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 06:37:08.184359+00',	'2025-08-14 06:37:08.184359+00',	NULL,	'f'),
(9237911113,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 10:01:34.76567+00',	'2025-08-14 10:01:34.76567+00',	NULL,	'f'),
(9552925998,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 11:35:58.872761+00',	'2025-08-14 11:35:58.872761+00',	NULL,	'f'),
(2353589654,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 12:03:49.24+00',	'2025-08-14 12:03:49.24+00',	NULL,	'f'),
(1399923194,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 12:04:48.775054+00',	'2025-08-14 12:04:48.775054+00',	NULL,	'f'),
(1798669613,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 12:07:56.995711+00',	'2025-08-14 12:07:56.995711+00',	NULL,	'f'),
(5494647943,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 12:29:48.590163+00',	'2025-08-14 12:29:48.590163+00',	NULL,	'f'),
(3676977467,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-14 12:49:00.535021+00',	'2025-08-14 12:49:00.535021+00',	NULL,	'f'),
(1886715659,	NULL,	NULL,	NULL,	NULL,	0.00,	'pending',	'2025-08-17 12:11:08.301+00',	'2025-08-17 12:11:08.301+00',	NULL,	'f');

DELIMITER ;;

CREATE TRIGGER "t_user_bonus_u" BEFORE UPDATE ON "public"."user_bonus" FOR EACH ROW EXECUTE FUNCTION trg_set_updated();;

DELIMITER ;

CREATE SEQUENCE user_exposures_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 306 CACHE 1;

CREATE TABLE "public"."user_exposures" (
    "id" integer DEFAULT nextval('user_exposures_id_seq') NOT NULL,
    "user_id" bigint NOT NULL,
    "match_id" character varying NOT NULL,
    "team_name" character varying NOT NULL,
    "exposure_amount" numeric NOT NULL,
    "created_at" timestamptz DEFAULT now(),
    "updated_at" timestamptz DEFAULT now(),
    "match_title" character varying(255),
    CONSTRAINT "user_exposures_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "user_exposures_user_id_match_id_team_name_key" UNIQUE ("user_id", "match_id", "team_name")
) WITH (oids = false);

INSERT INTO "user_exposures" ("id", "user_id", "match_id", "team_name", "exposure_amount", "created_at", "updated_at", "match_title") VALUES
(304,	4195526937,	'1.246758739',	'Denis Yevseyev',	2.0000000000000018,	'2025-08-18 04:44:55.152102+00',	'2025-08-18 04:44:55.152102+00',	'Denis Yevseyev v Marat Sharipov'),
(305,	4195526937,	'1.246758739',	'Marat Sharipov',	-100,	'2025-08-18 04:44:55.152102+00',	'2025-08-18 04:44:55.152102+00',	'Denis Yevseyev v Marat Sharipov'),
(306,	4195526937,	'1.246758739',	'The Draw',	-100,	'2025-08-18 04:44:55.152102+00',	'2025-08-18 04:44:55.152102+00',	'Denis Yevseyev v Marat Sharipov'),
(292,	1168755224,	'1.246523416',	'FK Jablonec',	-12.000000000000014,	'2025-08-16 19:34:36.425517+00',	'2025-08-16 19:39:09.795884+00',	'FK Jablonec v Slavia Prague'),
(293,	1168755224,	'1.246523416',	'Slavia Prague',	0,	'2025-08-16 19:34:36.425517+00',	'2025-08-16 19:39:09.795884+00',	'FK Jablonec v Slavia Prague'),
(294,	1168755224,	'1.246523416',	'The Draw',	0,	'2025-08-16 19:34:36.425517+00',	'2025-08-16 19:39:09.795884+00',	'FK Jablonec v Slavia Prague');

CREATE SEQUENCE user_fcm_tokens_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 102 CACHE 1;

CREATE TABLE "public"."user_game_toggle" (
    "uid" bigint NOT NULL,
    "blacklist" boolean NOT NULL,
    "whitelist" boolean NOT NULL,
    CONSTRAINT "uniq_user_game_toggle_uid" UNIQUE ("uid"),
    CONSTRAINT "user_game_toggle_uid_unique" UNIQUE ("uid")
) WITH (oids = false);

INSERT INTO "user_game_toggle" ("uid", "blacklist", "whitelist") VALUES
(3975178196,	'f',	'f'),
(4195526937,	'f',	'f'),
(1168755224,	'f',	'f'),
(2947642541,	'f',	'f'),
(2619588846,	'f',	'f'),
(3241962943,	'f',	'f'),
(3738919191,	'f',	'f'),
(8349173169,	'f',	'f'),
(4322449355,	'f',	'f'),
(3318375122,	'f',	'f'),
(3323544953,	'f',	'f'),
(7485641837,	'f',	'f'),
(8218194912,	'f',	'f'),
(8295691855,	'f',	'f'),
(5515176843,	'f',	'f'),
(3697552633,	'f',	'f'),
(9519742614,	'f',	'f'),
(7964322788,	'f',	'f'),
(2657598997,	'f',	'f'),
(5543122114,	'f',	'f'),
(8142391878,	'f',	'f'),
(9537511515,	'f',	'f'),
(3149553966,	'f',	'f'),
(7568636934,	'f',	'f'),
(6992971844,	'f',	'f'),
(4542777555,	'f',	'f'),
(8986325388,	'f',	'f'),
(1972273847,	'f',	'f'),
(2192231263,	'f',	'f'),
(5444377295,	'f',	'f'),
(5527192744,	'f',	'f'),
(9563822966,	'f',	'f'),
(8953649364,	'f',	'f'),
(8677383327,	'f',	'f'),
(6849137526,	'f',	'f'),
(8876775185,	'f',	'f'),
(1378438125,	'f',	'f'),
(3185197329,	'f',	'f'),
(1467427295,	'f',	'f'),
(7463544444,	'f',	'f'),
(2671612879,	'f',	'f'),
(3949828149,	'f',	'f'),
(5188413177,	'f',	'f'),
(1842945641,	'f',	'f'),
(9768223461,	'f',	'f'),
(1655619383,	'f',	'f'),
(3116637147,	'f',	'f'),
(8362255819,	'f',	'f'),
(9965188749,	'f',	'f'),
(5214887864,	'f',	'f'),
(6296468455,	'f',	'f'),
(9298451353,	'f',	'f'),
(8843181811,	'f',	'f'),
(5535982869,	'f',	'f'),
(7654769296,	'f',	'f'),
(1245126654,	'f',	'f'),
(8697663143,	'f',	'f'),
(8467591381,	'f',	'f'),
(2945191225,	'f',	'f'),
(9237911113,	'f',	'f'),
(9552925998,	'f',	'f'),
(2353589654,	'f',	'f'),
(1399923194,	'f',	'f'),
(1798669613,	'f',	'f'),
(5494647943,	'f',	'f'),
(3676977467,	'f',	'f'),
(1886715659,	'f',	'f');

CREATE SEQUENCE user_kyc_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 17 CACHE 1;

CREATE TABLE "public"."user_kyc" (
    "id" integer DEFAULT nextval('user_kyc_id_seq') NOT NULL,
    "user_id" character varying(50) NOT NULL,
    "first_name" character varying(100),
    "last_name" character varying(100),
    "gender" character varying(20),
    "date_of_birth" date,
    "address" text,
    "city" character varying(100),
    "country" character varying(50),
    "document_type" character varying(20),
    "id_front_path" character varying(255),
    "id_back_path" character varying(255),
    "passport_path" character varying(255),
    "status" character varying(20) DEFAULT 'Unverified' NOT NULL,
    "rejection_reason" text,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "user_kyc_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "user_kyc_user_id_key" UNIQUE ("user_id")
) WITH (oids = false);

CREATE INDEX "idx_user_kyc_user_id" ON "public"."user_kyc" USING btree ("user_id");

INSERT INTO "user_kyc" ("id", "user_id", "first_name", "last_name", "gender", "date_of_birth", "address", "city", "country", "document_type", "id_front_path", "id_back_path", "passport_path", "status", "rejection_reason", "created_at", "updated_at") VALUES
(1,	'1168755224',	'Jay',	'S',	'male',	'1988-02-10',	'Mohali',	'Mohali',	'IN',	'idcard',	'/uploads/kyc/1168755224_documentFront_1752816903122.png',	'/uploads/kyc/1168755224_documentBack_1752816903122.png',	NULL,	'Verified',	NULL,	'2025-07-18 05:35:03.173208+00',	'2025-07-18 05:50:06.345358+00'),
(17,	'8467591381',	'priyanshu',	'bhatt',	'male',	'2002-06-14',	'ioghohai',	'soghos',	'IN',	'idcard',	'/uploads/kyc/8467591381_documentFront_1755147141454.jpg',	'/uploads/kyc/8467591381_documentBack_1755147141546.jpg',	NULL,	'Pending',	NULL,	'2025-08-14 04:52:21.746977+00',	'2025-08-14 04:52:21.746977+00'),
(16,	'9965188749',	'Rajesh',	'Kumar',	'male',	'1991-01-18',	'Mohali',	'mohali',	'IN',	'idcard',	'/uploads/kyc/9965188749_documentFront_1755146821940.jpg',	'/uploads/kyc/9965188749_documentBack_1755146822008.jpg',	NULL,	'Rejected',	'rejected not proper pics',	'2025-08-14 04:47:02.093022+00',	'2025-08-14 10:40:34.177209+00'),
(2,	'3975178196',	'Andrew',	'Micheal',	'male',	'1960-01-01',	'Andrew@gmail.com',	'Melbourne',	'AU',	'idcard',	'/uploads/kyc/3975178196_documentFront_1753684684861.jpg',	'/uploads/kyc/3975178196_documentBack_1753684685061.jpg',	NULL,	'Rejected',	'Need Clear ID Proof',	'2025-07-28 06:38:05.156134+00',	'2025-07-29 09:43:27.428407+00'),
(9,	'696678',	'priyanshu',	'bhatt',	'male',	'2003-02-01',	'ioghohai',	'soghos',	'IN',	'idcard',	'/uploads/kyc/undefined_documentFront_1753869672711.jpg',	'/uploads/kyc/undefined_documentBack_1753869672887.jpg',	NULL,	'Pending',	NULL,	'2025-07-30 10:01:13.002982+00',	'2025-07-30 10:01:13.002982+00'),
(10,	'8218194912',	'loku',	'toku',	'male',	'2002-11-24',	'hbhbh',	'mat',	'BT',	'passport',	NULL,	NULL,	'/uploads/kyc/8218194912_documentFront_1753904298290.jpeg',	'Pending',	NULL,	'2025-07-30 19:38:18.292795+00',	'2025-07-30 19:38:18.292795+00'),
(11,	'7784574357',	'priyanshu',	'bhatt',	'male',	'2003-02-01',	'ioghohai',	'soghos',	'IN',	'idcard',	'/uploads/kyc/undefined_documentFront_1753933684698.jpg',	'/uploads/kyc/undefined_documentBack_1753933684877.jpg',	NULL,	'Pending',	NULL,	'2025-07-31 03:48:05.0081+00',	'2025-07-31 03:48:05.0081+00'),
(13,	'3116637147',	'Khatoon',	'Singh',	'female',	'1990-08-01',	'Hno: 123, sector 20, chandigarh',	'Chandigarh',	'IN',	'idcard',	'/uploads/kyc/3116637147_documentFront_1754625522377.jpg',	'/uploads/kyc/3116637147_documentBack_1754625522378.jpg',	NULL,	'Verified',	NULL,	'2025-08-08 03:58:42.38065+00',	'2025-08-11 17:07:40.780066+00'),
(12,	'3697552633',	'Salvin',	'Rai',	'male',	'2002-11-24',	'krishna vihar colony ballia mordh mau, uttarpradesh 275101',	'Mau',	'IN',	'idcard',	'/uploads/kyc/3697552633_documentFront_1754573786469.png',	'/uploads/kyc/3697552633_documentBack_1754573786811.png',	NULL,	'Rejected',	'give proper document',	'2025-08-07 13:36:26.898371+00',	'2025-08-11 17:08:03.148092+00'),
(7,	'4195526937',	'Deepali',	'Thakur',	'female',	'1999-11-07',	'Gh: 32 MDC 5 Panchkula',	'Chandigarh',	'GB',	'idcard',	'/uploads/kyc/4195526937_documentFront_1753771861517.png',	'/uploads/kyc/4195526937_documentBack_1753771861864.png',	NULL,	'Verified',	NULL,	'2025-07-29 06:51:02.123962+00',	'2025-08-12 05:23:35.472507+00'),
(8,	'12312344',	'priyanshu',	'bhatt',	'male',	'2003-02-01',	'ioghohai',	'soghos',	'IN',	'idcard',	'/uploads/kyc/undefined_documentFront_1753869666528.jpg',	'/uploads/kyc/undefined_documentBack_1753869666540.jpg',	NULL,	'Rejected',	'pls provide additional documents.',	'2025-07-30 10:00:53.056098+00',	'2025-08-12 08:00:27.032485+00'),
(14,	'7654769296',	'Shivani',	'S',	'female',	'2000-08-13',	'#123 it park',	'Chandigarh',	'IN',	'idcard',	'/uploads/kyc/7654769296_documentFront_1755065698484.jpg',	'/uploads/kyc/7654769296_documentBack_1755065699923.jpg',	NULL,	'Pending',	NULL,	'2025-08-13 06:15:00.251721+00',	'2025-08-13 06:15:00.251721+00'),
(15,	'3241962943',	'Ashish',	'Dangi',	'male',	'1991-12-15',	'Sector 8 Kurukshetra, 136118 Haryana India',	'Kurukshetra',	'IN',	'idcard',	'/uploads/kyc/3241962943_documentFront_1755065772388.jpeg',	'/uploads/kyc/3241962943_documentBack_1755065772892.jpeg',	NULL,	'Rejected',	'For testing purpose only',	'2025-08-13 06:16:12.923329+00',	'2025-08-13 06:17:09.785349+00');

CREATE SEQUENCE user_notifications_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 7 CACHE 1;

CREATE TABLE "public"."user_notifications" (
    "id" integer DEFAULT nextval('user_notifications_id_seq') NOT NULL,
    "user_id" bigint,
    "title" character varying(255) NOT NULL,
    "body" text NOT NULL,
    "type" character varying(50),
    "is_read" boolean DEFAULT false,
    "additional_data" jsonb,
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "user_notifications_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "user_notifications" ("id", "user_id", "title", "body", "type", "is_read", "additional_data", "created_at") VALUES
(5,	3241962943,	'KYC',	'Your KYC is not Complete.',	'info',	't',	'{"extraInfo": ""}',	'2025-07-29 07:06:58.874325'),
(6,	3241962943,	'KYC DONE',	'KYC IS DONE',	'success',	't',	'{"extraInfo": ""}',	'2025-07-29 11:52:45.127361'),
(7,	1168755224,	'hhbhb',	'bhb',	'info',	't',	'{"extraInfo": ""}',	'2025-08-07 06:32:12.094828'),
(4,	4195526937,	'Low Balance',	'Your Balance is Low, Pls redeposit',	'info',	't',	'{"extraInfo": ""}',	'2025-07-29 07:06:26.249404');

CREATE SEQUENCE user_otps_id_seq1 INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."user_otps" (
    "id" integer DEFAULT nextval('user_otps_id_seq1') NOT NULL,
    "email" text NOT NULL,
    "otp_hash" text NOT NULL,
    "purpose" text NOT NULL,
    "attempts" integer DEFAULT '0',
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "expires_at" timestamptz,
    "is_verified" boolean DEFAULT false,
    "user_id" bigint,
    CONSTRAINT "user_otps_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE TABLE "public"."user_profile_stats" (
    "user_id" bigint NOT NULL,
    "ftd_date" timestamptz,
    "std_date" timestamptz,
    "last_bonus_claim_at" timestamptz,
    "bonus_claim_count" integer DEFAULT '0' NOT NULL,
    "kyc_status" kyc_status DEFAULT pending NOT NULL,
    "kyc_verified_at" timestamptz,
    "kyc_rejected_at" timestamptz,
    "email_verified_at" timestamptz,
    "phone_verified_at" timestamptz,
    "account_status" text DEFAULT 'active' NOT NULL,
    "updated_at" timestamptz DEFAULT now() NOT NULL,
    CONSTRAINT "user_profile_stats_pkey" PRIMARY KEY ("user_id")
) WITH (oids = false);


CREATE SEQUENCE user_sessions_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1;

CREATE TABLE "public"."user_sessions" (
    "id" bigint DEFAULT nextval('user_sessions_id_seq') NOT NULL,
    "user_id" bigint NOT NULL,
    "login_at" timestamptz NOT NULL,
    "logout_at" timestamptz,
    "ip_address" inet NOT NULL,
    "geo_location" text,
    "device_info" text,
    "session_token" text,
    "created_at" timestamptz DEFAULT now() NOT NULL,
    CONSTRAINT "user_sessions_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


CREATE TABLE "public"."userbonus" (
    "userid" bigint NOT NULL,
    "name" text NOT NULL,
    "totalbonus" numeric NOT NULL,
    "vipbonus" numeric NOT NULL,
    "specialbonus" numeric NOT NULL,
    "generalbonus" numeric NOT NULL,
    "createdat" timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedat" timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "joiningbonus" numeric,
    "dailybonus" numeric DEFAULT '0',
    "weeklybonus" numeric DEFAULT '0',
    "monthlybonus" numeric DEFAULT '0',
    "last_daily_reset" timestamptz,
    "last_weekly_reset" timestamptz,
    "last_monthly_reset" timestamptz,
    "rakebonus" numeric DEFAULT '0',
    "actualdailybonus" numeric(10,2) DEFAULT '0',
    "actualweeklybonus" numeric(10,2) DEFAULT '0',
    "actualmonthlybonus" numeric(10,2) DEFAULT '0',
    CONSTRAINT "userbonus_userid_unique" UNIQUE ("userid")
) WITH (oids = false);

COMMENT ON COLUMN "public"."userbonus"."dailybonus" IS 'Daily bonus amount available to claim';

COMMENT ON COLUMN "public"."userbonus"."weeklybonus" IS 'Weekly bonus amount available to claim';

COMMENT ON COLUMN "public"."userbonus"."monthlybonus" IS 'Monthly bonus amount available to claim';

COMMENT ON COLUMN "public"."userbonus"."last_daily_reset" IS 'Timestamp of last daily bonus reset';

COMMENT ON COLUMN "public"."userbonus"."last_weekly_reset" IS 'Timestamp of last weekly bonus reset';

COMMENT ON COLUMN "public"."userbonus"."last_monthly_reset" IS 'Timestamp of last monthly bonus reset';

INSERT INTO "userbonus" ("userid", "name", "totalbonus", "vipbonus", "specialbonus", "generalbonus", "createdat", "updatedat", "joiningbonus", "dailybonus", "weeklybonus", "monthlybonus", "last_daily_reset", "last_weekly_reset", "last_monthly_reset", "rakebonus", "actualdailybonus", "actualweeklybonus", "actualmonthlybonus") VALUES
(5188413177,	'New11111',	0,	0,	0,	0,	'2025-08-06 11:47:16.415509',	'2025-08-06 11:47:16.415509',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(7568636934,	'Dangi Ashish',	0,	0,	0,	0,	'2025-08-01 03:14:27.458834',	'2025-08-01 03:14:27.458834',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(6992971844,	'anantgaur',	0,	0,	0,	0,	'2025-08-01 03:50:03.50812',	'2025-08-01 03:50:03.50812',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1842945641,	'Ignoo',	0,	0,	0,	0,	'2025-08-06 11:50:04.360945',	'2025-08-06 11:50:04.360945',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(4542777555,	'newuser123',	0,	0,	0,	0,	'2025-08-01 08:39:06.330453',	'2025-08-01 08:39:06.330453',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8986325388,	'Praksh123',	0,	0,	0,	0,	'2025-08-01 09:02:19.681862',	'2025-08-01 09:02:19.681862',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1972273847,	'newuser1234',	0,	0,	0,	0,	'2025-08-01 09:04:14.502459',	'2025-08-01 09:04:14.502459',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(5444377295,	'sumitsharma',	0,	0,	0,	0,	'2025-08-01 11:17:12.761881',	'2025-08-01 11:17:12.761881',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(5527192744,	'SalvinRai',	0,	0,	0,	0,	'2025-08-01 12:24:42.377995',	'2025-08-01 12:24:42.377995',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8953649364,	'ParkashKumar',	0,	0,	0,	0,	'2025-08-04 06:46:01.095662',	'2025-08-04 06:46:01.095662',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8677383327,	'Rajeshundefined',	0,	0,	0,	0,	'2025-08-04 06:59:22.194726',	'2025-08-04 06:59:22.194726',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(6849137526,	'thakurrrrr',	0,	0,	0,	0,	'2025-08-04 08:01:07.503784',	'2025-08-04 08:01:07.503784',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8876775185,	'jeta777',	0,	0,	0,	0,	'2025-08-05 00:33:49.746247',	'2025-08-05 00:33:49.746247',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(9768223461,	'thakur09',	0,	0,	0,	0,	'2025-08-06 11:57:25.360052',	'2025-08-06 11:57:25.360052',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1655619383,	'Test1',	0,	0,	0,	0,	'2025-08-07 03:17:37.584229',	'2025-08-07 03:17:37.584229',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(2671612879,	'Aliza',	1,	0,	1,	0,	'2025-08-06 11:39:33.707707',	'2025-08-07 04:28:35.654963',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3116637147,	'Khatoon',	0,	0,	0,	0,	'2025-08-07 06:37:27.512325',	'2025-08-07 06:37:27.512325',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(9298451353,	'salvin CFZundefined',	0,	0,	0,	0,	'2025-08-11 17:32:42.965003',	'2025-08-11 17:32:42.965003',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(9563822966,	'SumitSharma',	0,	0,	0,	0,	'2025-08-02 06:49:12.214745',	'2025-08-02 06:49:12.214745',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1886715659,	'winway',	0,	0,	0,	0,	'2025-08-17 12:11:08.309513',	'2025-08-17 12:11:08.309513',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8843181811,	'HarmanSingh',	0,	0,	0,	0,	'2025-08-12 09:49:55.55637',	'2025-08-12 09:49:55.55637',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3241962943,	'AshishDangi',	0,	0,	0,	0,	'2025-07-29 05:14:51.963727',	'2025-07-29 05:14:51.963727',	0,	0,	0,	0,	'2025-08-17 18:30:00.095979+00',	'2025-08-16 18:30:00.058713+00',	'2025-07-30 18:30:00.494803+00',	0,	0.00,	0.00,	0.00),
(5535982869,	'Ezze SoftLtd',	0,	0,	0,	0,	'2025-08-12 19:10:25.153656',	'2025-08-12 19:10:25.153656',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(2945191225,	'testriyanshusuer',	0,	0,	0,	0,	'2025-08-14 06:37:08.192939',	'2025-08-14 06:37:08.192939',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(2619588846,	'Nikhil',	0,	0,	0,	0,	'2025-07-29 05:41:21.820871',	'2025-07-29 05:41:21.820871',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3738919191,	'priyanshu_bhatt',	0,	0,	0,	0,	'2025-07-29 12:42:36.553705',	'2025-07-29 12:42:36.553705',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1378438125,	'kenzo',	0,	0,	0,	0,	'2025-08-06 04:36:15.428839',	'2025-08-06 04:36:15.428839',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3185197329,	'Infiltrator',	0,	0,	0,	0,	'2025-08-06 05:10:40.066691',	'2025-08-06 05:10:40.066691',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(4195526937,	'deepalithakur290',	1.11396627,	0,	1,	0,	'2025-07-29 05:10:01.722844',	'2025-08-01 04:17:55.602766',	0,	0,	0,	0,	'2025-08-17 18:30:00.10421+00',	'2025-08-16 18:30:00.066887+00',	'2025-07-30 18:30:00.508464+00',	0.11396627,	0.00,	0.00,	0.00),
(9519742614,	'adaline',	0,	0,	0,	0,	'2025-07-31 09:27:19.994466',	'2025-07-31 09:27:19.994466',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(4322449355,	'jeta4321',	0,	0,	0,	0,	'2025-07-30 04:05:01.338797',	'2025-07-30 04:05:01.338797',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3318375122,	'testuser',	0,	0,	0,	0,	'2025-07-30 07:03:22.367763',	'2025-07-30 07:03:22.367763',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3323544953,	'testsal123',	0,	0,	0,	0,	'2025-07-30 11:49:29.537784',	'2025-07-30 11:49:29.537784',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3975178196,	'andrew',	0,	0,	0,	0,	'2025-07-28 05:25:00.221825',	'2025-07-28 05:25:00.221825',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1467427295,	'jatin.verma1',	0,	0,	0,	0,	'2025-08-06 10:36:42.960362',	'2025-08-06 10:36:42.960362',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(7463544444,	'Kulpreet',	0,	0,	0,	0,	'2025-08-06 11:38:27.33554',	'2025-08-06 11:38:27.33554',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1245126654,	'Nischalundefined',	0,	0,	0,	0,	'2025-08-13 10:35:20.79046',	'2025-08-13 10:35:20.79046',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3949828149,	'Kush19',	0,	0,	0,	0,	'2025-08-06 11:40:45.816649',	'2025-08-06 11:40:45.816649',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8362255819,	'AshishDangi',	0,	0,	0,	0,	'2025-08-11 04:47:36.199749',	'2025-08-11 04:47:36.199749',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(9237911113,	'testmac',	0,	0,	0,	0,	'2025-08-14 10:01:34.779178',	'2025-08-14 10:01:34.779178',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(9552925998,	'qwerty',	0,	0,	0,	0,	'2025-08-14 11:35:58.887025',	'2025-08-14 11:35:58.887025',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(7964322788,	'thakur',	0,	0,	0,	0,	'2025-07-31 09:30:03.211742',	'2025-07-31 09:30:03.211742',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(2657598997,	'deepalithakur',	0,	0,	0,	0,	'2025-07-31 09:43:30.437009',	'2025-07-31 09:43:30.437009',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(7485641837,	'user123456',	0,	0,	0,	0,	'2025-07-30 12:07:19.666448',	'2025-07-30 12:07:19.666448',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8218194912,	'lok123',	0,	0,	0,	0,	'2025-07-30 12:13:30.316322',	'2025-07-30 12:13:30.316322',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8295691855,	'motheradmin',	0,	0,	0,	0,	'2025-07-30 12:15:17.342453',	'2025-07-30 12:15:17.342453',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(5515176843,	'lok1234',	0,	0,	0,	0,	'2025-07-30 12:19:09.877553',	'2025-07-30 12:19:09.877553',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3697552633,	'lokesh1234',	0,	0,	0,	0,	'2025-07-30 12:23:01.342859',	'2025-07-30 12:23:01.342859',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(5214887864,	'DexterKing',	0,	0,	0,	0,	'2025-08-11 13:24:47.662027',	'2025-08-11 13:24:47.662027',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(6296468455,	'codeFactory',	0,	0,	0,	0,	'2025-08-11 16:56:41.191492',	'2025-08-11 16:56:41.191492',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8697663143,	'SalvinRai',	0,	0,	0,	0,	'2025-08-13 11:56:29.877838',	'2025-08-13 11:56:29.877838',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(5543122114,	'NiteshKumar',	0,	0,	0,	0,	'2025-07-31 09:47:47.481965',	'2025-07-31 09:47:47.481965',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(8142391878,	'newuser@yop',	0,	0,	0,	0,	'2025-07-31 12:52:04.160968',	'2025-07-31 12:52:04.160968',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(9537511515,	'Parkash',	0,	0,	0,	0,	'2025-07-31 12:53:15.669391',	'2025-07-31 12:53:15.669391',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3149553966,	'newuser1',	0,	0,	0,	0,	'2025-07-31 12:55:38.536404',	'2025-07-31 12:55:38.536404',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(2353589654,	'testuserthisis',	0,	0,	0,	0,	'2025-08-14 12:03:49.251056',	'2025-08-14 12:03:49.251056',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(5494647943,	'test1111',	0,	0,	0,	0,	'2025-08-14 12:29:48.597305',	'2025-08-14 12:29:48.597305',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(2947642541,	'jatin.verma',	0,	0,	0,	0,	'2025-07-16 06:16:07.130567',	'2025-07-16 06:16:07.130567',	0,	0,	0,	0,	'2025-08-17 18:30:00.152483+00',	'2025-08-16 18:30:00.143062+00',	NULL,	0,	0.00,	0.00,	0.00),
(1399923194,	'newtest',	0,	0,	0,	0,	'2025-08-14 12:04:48.781182',	'2025-08-14 12:04:48.781182',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(7654769296,	'Shivani ',	0.00891938,	0,	0,	0,	'2025-08-13 04:03:35.019638',	'2025-08-13 04:03:35.019638',	0,	0,	0,	0,	'2025-08-17 18:30:00.144321+00',	'2025-08-16 18:30:00.130781+00',	NULL,	0.00891938,	0.00,	0.00,	0.00),
(1798669613,	'qqwerty',	0,	0,	0,	0,	'2025-08-14 12:07:57.002472',	'2025-08-14 12:07:57.002472',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(3676977467,	'testingtestww',	0,	0,	0,	0,	'2025-08-14 12:49:00.55024',	'2025-08-14 12:49:00.55024',	0,	0,	0,	0,	NULL,	NULL,	NULL,	0,	0.00,	0.00,	0.00),
(1168755224,	'testpro6',	100,	0,	100,	0,	'2025-07-31 19:47:27.102915',	'2025-07-31 19:47:53.73836',	0,	0,	0,	0,	'2025-08-17 18:30:00.128922+00',	'2025-08-16 18:30:00.108682+00',	NULL,	0,	0.00,	0.00,	0.00),
(8467591381,	'PriyanshuBhatt',	0,	0,	0,	0,	'2025-08-14 04:51:22.919296',	'2025-08-14 04:51:22.919296',	0,	0,	0,	0,	'2025-08-17 18:30:00.136817+00',	'2025-08-16 18:30:00.118299+00',	NULL,	0,	0.00,	0.00,	0.00),
(9965188749,	'RajeshChaudhary',	0,	0,	0,	0,	'2025-08-11 12:08:40.424325',	'2025-08-11 12:08:40.424325',	0,	0,	0,	0,	'2025-08-17 18:30:00.118859+00',	'2025-08-16 18:30:00.088478+00',	NULL,	0,	0.00,	0.00,	0.00),
(8349173169,	'JetaSharma',	0,	0,	0,	0,	'2025-07-29 14:25:00.044029',	'2025-07-29 14:25:00.044029',	0,	0,	0,	0,	'2025-08-17 18:30:00.111049+00',	'2025-08-16 18:30:00.077552+00',	NULL,	0,	0.00,	0.00,	0.00),
(2192231263,	'PankajJoshi',	0,	0,	0,	0,	'2025-08-01 10:06:57.032908',	'2025-08-01 10:06:57.032908',	0,	0,	0,	0,	'2025-08-17 18:30:00.084959+00',	'2025-08-16 18:30:00.047709+00',	NULL,	0,	0.00,	0.00,	0.00);

CREATE TABLE "public"."userconfig" (
    "uid" bigint NOT NULL,
    "registerbonus" numeric NOT NULL,
    "affiliatebonus" numeric NOT NULL,
    "comissionpercent" numeric NOT NULL,
    "clubrake" numeric NOT NULL,
    "sports" boolean NOT NULL,
    "inr" boolean NOT NULL,
    "mvr" boolean NOT NULL,
    "aed" boolean NOT NULL,
    "pkr" boolean NOT NULL,
    "cryptocoin" boolean NOT NULL,
    "bjb" boolean NOT NULL,
    "casino" boolean NOT NULL,
    "lotto" boolean NOT NULL,
    "vipclub" boolean NOT NULL,
    "clubmembership" boolean NOT NULL,
    "bonus" boolean NOT NULL,
    "affiliate" boolean NOT NULL,
    "crash" boolean NOT NULL,
    "originals" boolean NOT NULL,
    "livegames" boolean NOT NULL,
    "slotsgames" boolean NOT NULL,
    "alllivegames" boolean NOT NULL,
    "allslotsgames" boolean NOT NULL,
    "lotterygames" boolean NOT NULL,
    "indiangames" boolean NOT NULL,
    "cards" boolean NOT NULL,
    "jilli" boolean NOT NULL,
    "bdt" boolean NOT NULL,
    "instantgames" boolean NOT NULL,
    "btc" boolean NOT NULL,
    "eth" boolean NOT NULL,
    "ltc" boolean NOT NULL,
    "bch" boolean NOT NULL,
    "usdt" boolean NOT NULL,
    "trx" boolean NOT NULL,
    "doge" boolean NOT NULL,
    "ada" boolean NOT NULL,
    "xrp" boolean NOT NULL,
    "bnb" boolean NOT NULL,
    "usdp" boolean NOT NULL,
    "nexo" boolean NOT NULL,
    "mkr" boolean NOT NULL,
    "tusd" boolean NOT NULL,
    "usdc" boolean NOT NULL,
    "busd" boolean NOT NULL,
    "nc" boolean NOT NULL,
    "npr" boolean NOT NULL,
    "shib" boolean NOT NULL,
    "matic" boolean NOT NULL,
    "sc" boolean NOT NULL,
    "spribe" boolean NOT NULL,
    "evolution" boolean NOT NULL,
    "pragmaticslots" boolean NOT NULL,
    "pragmaticlive" boolean NOT NULL,
    "ideal" boolean NOT NULL,
    "microgaming" boolean NOT NULL,
    "pgsoft" boolean NOT NULL,
    "hacksawgaming" boolean NOT NULL,
    "jili" boolean NOT NULL,
    "netent" boolean NOT NULL,
    "esports" boolean NOT NULL,
    "provablyfair" boolean NOT NULL,
    "createdat" timestamptz DEFAULT now() NOT NULL,
    "updatedat" timestamptz DEFAULT now() NOT NULL,
    CONSTRAINT "userconfig_pkey" PRIMARY KEY ("uid")
) WITH (oids = false);

INSERT INTO "userconfig" ("uid", "registerbonus", "affiliatebonus", "comissionpercent", "clubrake", "sports", "inr", "mvr", "aed", "pkr", "cryptocoin", "bjb", "casino", "lotto", "vipclub", "clubmembership", "bonus", "affiliate", "crash", "originals", "livegames", "slotsgames", "alllivegames", "allslotsgames", "lotterygames", "indiangames", "cards", "jilli", "bdt", "instantgames", "btc", "eth", "ltc", "bch", "usdt", "trx", "doge", "ada", "xrp", "bnb", "usdp", "nexo", "mkr", "tusd", "usdc", "busd", "nc", "npr", "shib", "matic", "sc", "spribe", "evolution", "pragmaticslots", "pragmaticlive", "ideal", "microgaming", "pgsoft", "hacksawgaming", "jili", "netent", "esports", "provablyfair", "createdat", "updatedat") VALUES
(1168755224,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-17 07:28:05.20927+00',	'2025-08-07 06:29:38.996549+00'),
(2947642541,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-17 07:28:05.20927+00',	'2025-07-17 07:28:05.20927+00'),
(3116637147,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-07 06:37:27.500393+00',	'2025-08-07 06:37:27.500393+00'),
(8843181811,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-12 09:49:55.546807+00',	'2025-08-12 09:49:55.546807+00'),
(2192231263,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 10:06:57.025792+00',	'2025-08-01 10:06:57.025792+00'),
(5444377295,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 11:17:12.753666+00',	'2025-08-01 11:17:12.753666+00'),
(5527192744,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 12:24:42.369606+00',	'2025-08-01 12:24:42.369606+00'),
(9563822966,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-02 06:49:12.208204+00',	'2025-08-02 06:49:12.208204+00'),
(8953649364,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-04 06:46:01.077099+00',	'2025-08-04 06:46:01.077099+00'),
(8677383327,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-04 06:59:22.188473+00',	'2025-08-04 06:59:22.188473+00'),
(6849137526,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-04 08:01:07.497317+00',	'2025-08-04 08:01:07.497317+00'),
(8876775185,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-05 00:33:49.713705+00',	'2025-08-05 00:33:49.713705+00'),
(1378438125,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 04:36:15.416531+00',	'2025-08-06 04:36:15.416531+00'),
(3185197329,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 05:10:40.058669+00',	'2025-08-06 05:10:40.058669+00'),
(1467427295,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 10:36:42.952732+00',	'2025-08-06 10:36:42.952732+00'),
(7463544444,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 11:38:27.328061+00',	'2025-08-06 11:38:27.328061+00'),
(3738919191,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-29 12:42:36.545657+00',	'2025-07-29 12:42:36.545657+00'),
(8349173169,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-29 14:25:00.022287+00',	'2025-07-29 14:25:00.022287+00'),
(4322449355,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 04:05:01.322413+00',	'2025-07-30 04:05:01.322413+00'),
(3318375122,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 07:03:22.360966+00',	'2025-07-30 07:03:22.360966+00'),
(3323544953,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 11:49:29.532433+00',	'2025-07-30 11:49:29.532433+00'),
(7485641837,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 12:07:19.660762+00',	'2025-07-30 12:07:19.660762+00'),
(8218194912,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 12:13:30.308492+00',	'2025-07-30 12:13:30.308492+00'),
(8295691855,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 12:15:17.336258+00',	'2025-07-30 12:15:17.336258+00'),
(3975178196,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-28 05:25:00.215374+00',	'2025-07-28 05:25:00.215374+00'),
(5515176843,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 12:19:09.872661+00',	'2025-07-30 12:19:09.872661+00'),
(3697552633,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-30 12:23:01.336804+00',	'2025-07-30 12:23:01.336804+00'),
(9519742614,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 09:27:19.988131+00',	'2025-07-31 09:27:19.988131+00'),
(7964322788,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 09:30:03.205915+00',	'2025-07-31 09:30:03.205915+00'),
(2657598997,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 09:43:30.430678+00',	'2025-07-31 09:43:30.430678+00'),
(5543122114,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 09:47:47.475998+00',	'2025-07-31 09:47:47.475998+00'),
(8142391878,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 12:52:04.150566+00',	'2025-07-31 12:52:04.150566+00'),
(9537511515,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 12:53:15.663819+00',	'2025-07-31 12:53:15.663819+00'),
(3149553966,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-31 12:55:38.531867+00',	'2025-07-31 12:55:38.531867+00'),
(2671612879,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 11:39:33.70213+00',	'2025-08-06 11:39:33.70213+00'),
(3949828149,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 11:40:45.80989+00',	'2025-08-06 11:40:45.80989+00'),
(5188413177,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 11:47:16.409046+00',	'2025-08-06 11:47:16.409046+00'),
(4195526937,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-29 05:10:01.716437+00',	'2025-08-11 06:59:26.33518+00'),
(7568636934,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 03:14:27.448927+00',	'2025-08-01 03:14:27.448927+00'),
(6992971844,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 03:50:03.500953+00',	'2025-08-01 03:50:03.500953+00'),
(4542777555,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 08:39:06.322479+00',	'2025-08-01 08:39:06.322479+00'),
(8986325388,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 09:02:19.676257+00',	'2025-08-01 09:02:19.676257+00'),
(3241962943,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-29 05:14:51.95638+00',	'2025-07-29 05:14:51.95638+00'),
(2619588846,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-07-29 05:41:21.812613+00',	'2025-07-29 05:41:21.812613+00'),
(1972273847,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-01 09:04:14.49608+00',	'2025-08-01 09:04:14.49608+00'),
(1842945641,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 11:50:04.350497+00',	'2025-08-06 11:50:04.350497+00'),
(9768223461,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-06 11:57:25.353243+00',	'2025-08-06 11:57:25.353243+00'),
(9965188749,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-11 12:08:40.405955+00',	'2025-08-11 12:08:40.405955+00'),
(1655619383,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-07 03:17:37.577272+00',	'2025-08-07 03:17:37.577272+00'),
(5214887864,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-11 13:24:47.651343+00',	'2025-08-11 13:24:47.651343+00'),
(6296468455,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-11 16:56:41.177592+00',	'2025-08-11 16:56:41.177592+00'),
(8362255819,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-11 04:47:36.179687+00',	'2025-08-11 04:47:36.179687+00'),
(9298451353,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-11 17:32:42.940698+00',	'2025-08-11 17:32:42.940698+00'),
(5535982869,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-12 19:10:25.143536+00',	'2025-08-12 19:10:25.143536+00'),
(7654769296,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-13 04:03:35.009567+00',	'2025-08-13 04:03:35.009567+00'),
(1245126654,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-13 10:35:20.769193+00',	'2025-08-13 10:35:20.769193+00'),
(8697663143,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-13 11:56:29.869956+00',	'2025-08-13 11:56:29.869956+00'),
(8467591381,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 04:51:22.908848+00',	'2025-08-14 04:51:22.908848+00'),
(2945191225,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 06:37:08.184359+00',	'2025-08-14 06:37:08.184359+00'),
(9237911113,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 10:01:34.76567+00',	'2025-08-14 10:01:34.76567+00'),
(9552925998,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 11:35:58.872761+00',	'2025-08-14 11:35:58.872761+00'),
(2353589654,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 12:03:49.24+00',	'2025-08-14 12:03:49.24+00'),
(1399923194,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 12:04:48.775054+00',	'2025-08-14 12:04:48.775054+00'),
(1798669613,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 12:07:56.995711+00',	'2025-08-14 12:07:56.995711+00'),
(5494647943,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 12:29:48.590163+00',	'2025-08-14 12:29:48.590163+00'),
(3676977467,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-14 12:49:00.535021+00',	'2025-08-14 12:49:00.535021+00'),
(1886715659,	0,	100,	25,	10,	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	't',	'2025-08-17 12:11:08.301+00',	'2025-08-17 12:11:08.301+00');

DELIMITER ;;;;;;;

DELIMITER ;

CREATE TABLE "public"."userwager" (
    "uid" bigint NOT NULL,
    "wager" text NOT NULL,
    CONSTRAINT "unique_uid" UNIQUE ("uid")
) WITH (oids = false);

INSERT INTO "userwager" ("uid", "wager") VALUES
(2947642541,	'35.91676'),
(8467591381,	'5.61353'),
(1168755224,	'9.22195'),
(7654769296,	'4.12891'),
(3241962943,	'109.58493'),
(4195526937,	'152.40520'),
(2192231263,	'4.99418'),
(9965188749,	'1,072.46684'),
(8349173169,	'7.98205');

CREATE SEQUENCE userwager_history_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 351 CACHE 1;

CREATE TABLE "public"."userwager_history" (
    "id" bigint DEFAULT nextval('userwager_history_id_seq') NOT NULL,
    "uid" bigint NOT NULL,
    "previous_wager" text NOT NULL,
    "new_wager" text NOT NULL,
    "updated_at" timestamptz DEFAULT now(),
    CONSTRAINT "userwager_history_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

COMMENT ON TABLE "public"."userwager_history" IS 'Stores history of user wager updates';

COMMENT ON COLUMN "public"."userwager_history"."uid" IS 'User ID from userwager table';

COMMENT ON COLUMN "public"."userwager_history"."previous_wager" IS 'Wager amount before update';

COMMENT ON COLUMN "public"."userwager_history"."new_wager" IS 'Wager amount after update';

COMMENT ON COLUMN "public"."userwager_history"."updated_at" IS 'Timestamp of the update';

INSERT INTO "userwager_history" ("id", "uid", "previous_wager", "new_wager", "updated_at") VALUES
(206,	4195526937,	'0',	'1.15301',	'2025-07-29 05:53:56.848608+00'),
(207,	3241962943,	'0',	'1.72951',	'2025-07-29 05:59:06.008663+00'),
(208,	4195526937,	'1.15301',	'2.30601',	'2025-07-29 06:07:38.801777+00'),
(209,	4195526937,	'2.30601',	'5.76503',	'2025-07-29 06:17:32.277925+00'),
(210,	4195526937,	'5.76503',	'22.36830',	'2025-07-29 06:36:34.798099+00'),
(211,	3241962943,	'1.72951',	'103.07865',	'2025-07-29 07:05:35.537515+00'),
(212,	3241962943,	'103.07865',	'104.80815',	'2025-07-29 07:29:10.332254+00'),
(215,	1168755224,	'0',	'0.95873',	'2025-07-31 19:34:09.648837+00'),
(221,	2947642541,	'6.16387',	'35.91676',	'2025-08-02 13:07:47.256242+00'),
(222,	4195526937,	'49.53923',	'49.47952',	'2025-08-05 03:44:30.975524+00'),
(227,	1168755224,	'4.51262',	'7.51262',	'2025-08-07 06:49:14.016084+00'),
(228,	1168755224,	'4.51262',	'7.51262',	'2025-08-07 06:49:14.016084+00'),
(229,	1168755224,	'7.51262',	'9.22195',	'2025-08-07 06:53:26.391811+00'),
(230,	1168755224,	'7.51262',	'9.22195',	'2025-08-07 06:53:26.391811+00'),
(231,	4195526937,	'49.47952',	'49.57047',	'2025-08-07 07:33:47.161386+00'),
(238,	4195526937,	'57.80005',	'94.19504',	'2025-08-12 11:11:49.256756+00'),
(239,	4195526937,	'57.80005',	'94.19504',	'2025-08-12 11:11:49.256756+00'),
(240,	4195526937,	'94.19504',	'95.33534',	'2025-08-12 11:12:20.854758+00'),
(241,	4195526937,	'94.19504',	'95.33534',	'2025-08-12 11:12:20.854758+00'),
(242,	4195526937,	'95.33534',	'96.47563',	'2025-08-12 11:12:35.38685+00'),
(243,	4195526937,	'95.33534',	'96.47563',	'2025-08-12 11:12:35.38685+00'),
(244,	4195526937,	'96.47563',	'97.61592',	'2025-08-12 11:12:45.660087+00'),
(245,	4195526937,	'96.47563',	'97.61592',	'2025-08-12 11:12:45.660087+00'),
(246,	4195526937,	'97.61592',	'98.75622',	'2025-08-12 11:12:56.218293+00'),
(247,	4195526937,	'97.61592',	'98.75622',	'2025-08-12 11:12:56.218293+00'),
(248,	4195526937,	'98.75622',	'99.89651',	'2025-08-12 11:14:13.831133+00'),
(249,	4195526937,	'98.75622',	'99.89651',	'2025-08-12 11:14:13.831133+00'),
(250,	8349173169,	'0',	'7.98205',	'2025-08-12 11:18:05.489156+00'),
(251,	8349173169,	'0',	'7.98205',	'2025-08-12 11:18:05.489156+00'),
(252,	3241962943,	'104.88915',	'105.78498',	'2025-08-12 11:20:43.710902+00'),
(253,	3241962943,	'104.88915',	'105.78498',	'2025-08-12 11:20:43.710902+00'),
(270,	3241962943,	'105.78498',	'106.83841',	'2025-08-13 04:12:46.781545+00'),
(271,	3241962943,	'105.78498',	'106.83841',	'2025-08-13 04:12:46.781545+00'),
(272,	7654769296,	'0',	'0.71857',	'2025-08-13 04:55:17.413169+00'),
(273,	4195526937,	'143.52412',	'144.87229',	'2025-08-13 05:06:38.483646+00'),
(274,	4195526937,	'143.52412',	'144.87229',	'2025-08-13 05:06:38.483646+00'),
(275,	7654769296,	'0.71857',	'2.13289',	'2025-08-13 05:11:40.492962+00'),
(276,	7654769296,	'0.71857',	'2.13289',	'2025-08-13 05:11:40.492962+00'),
(277,	4195526937,	'144.87229',	'145.90224',	'2025-08-13 05:25:49.084661+00'),
(278,	4195526937,	'144.87229',	'145.90224',	'2025-08-13 05:25:49.084661+00'),
(279,	7654769296,	'2.13289',	'2.70318',	'2025-08-13 05:26:20.151125+00'),
(280,	7654769296,	'2.13289',	'2.70318',	'2025-08-13 05:26:20.151125+00'),
(281,	3241962943,	'106.83841',	'107.60260',	'2025-08-13 05:26:26.235613+00'),
(282,	3241962943,	'106.83841',	'107.60260',	'2025-08-13 05:26:26.235613+00'),
(283,	4195526937,	'145.90224',	'146.58659',	'2025-08-13 05:27:52.69621+00'),
(284,	4195526937,	'145.90224',	'146.58659',	'2025-08-13 05:27:52.69621+00'),
(285,	7654769296,	'2.70318',	'4.12891',	'2025-08-13 05:36:36.21454+00'),
(286,	7654769296,	'2.70318',	'4.12891',	'2025-08-13 05:36:36.21454+00'),
(287,	3241962943,	'107.6026',	'108.62912',	'2025-08-13 05:39:36.878781+00'),
(288,	3241962943,	'107.6026',	'108.62912',	'2025-08-13 05:39:36.878781+00'),
(289,	4195526937,	'146.58659',	'148.79019',	'2025-08-13 05:41:56.901332+00'),
(290,	4195526937,	'146.58659',	'148.79019',	'2025-08-13 05:41:56.901332+00'),
(291,	3241962943,	'108.62912',	'109.58493',	'2025-08-13 10:11:14.261804+00'),
(292,	3241962943,	'108.62912',	'109.58493',	'2025-08-13 10:11:14.261804+00'),
(296,	2192231263,	'0',	'1.59995',	'2025-08-14 10:35:39.127109+00'),
(297,	2192231263,	'0',	'1.59995',	'2025-08-14 10:35:39.127109+00'),
(310,	9965188749,	'76.56887',	'99.99666',	'2025-08-14 12:17:01.34164+00'),
(311,	9965188749,	'76.56887',	'99.99666',	'2025-08-14 12:17:01.34164+00'),
(312,	9965188749,	'99.99666',	'113.71049',	'2025-08-14 12:19:15.18057+00'),
(313,	9965188749,	'99.99666',	'113.71049',	'2025-08-14 12:19:15.18057+00'),
(314,	9965188749,	'113.71049',	'123.42445',	'2025-08-14 12:21:55.064421+00'),
(315,	9965188749,	'113.71049',	'123.42445',	'2025-08-14 12:21:55.064421+00'),
(316,	9965188749,	'123.42445',	'126.85291',	'2025-08-14 12:24:15.632365+00'),
(317,	8467591381,	'0.50513',	'3.60217',	'2025-08-14 12:24:18.65938+00'),
(318,	8467591381,	'0.50513',	'3.60217',	'2025-08-14 12:24:18.65938+00'),
(319,	8467591381,	'3.60217',	'4.74498',	'2025-08-14 12:26:09.759818+00'),
(320,	8467591381,	'3.60217',	'4.74498',	'2025-08-14 12:26:09.759818+00'),
(321,	9965188749,	'126.85291',	'131.42419',	'2025-08-14 12:31:01.542988+00'),
(322,	9965188749,	'126.85291',	'131.42419',	'2025-08-14 12:31:01.542988+00'),
(323,	9965188749,	'131.42419',	'163.42312',	'2025-08-14 12:32:04.979613+00'),
(324,	9965188749,	'131.42419',	'163.42312',	'2025-08-14 12:32:04.979613+00'),
(325,	9965188749,	'163.42312',	'166.28016',	'2025-08-14 12:34:20.881129+00'),
(326,	9965188749,	'163.42312',	'166.28016',	'2025-08-14 12:34:20.881129+00'),
(327,	9965188749,	'166.28016',	'170.85144',	'2025-08-14 12:35:47.06363+00'),
(328,	9965188749,	'166.28016',	'170.85144',	'2025-08-14 12:35:47.06363+00'),
(329,	9965188749,	'170.85144',	'216.56420',	'2025-08-14 12:38:41.168223+00'),
(330,	9965188749,	'170.85144',	'216.56420',	'2025-08-14 12:38:41.168223+00'),
(331,	9965188749,	'216.5642',	'285.13334',	'2025-08-14 12:40:30.997702+00'),
(332,	8467591381,	'4.74498',	'5.61353',	'2025-08-14 12:41:37.185908+00'),
(333,	8467591381,	'4.74498',	'5.61353',	'2025-08-14 12:41:37.185908+00'),
(334,	9965188749,	'285.13334',	'290.84744',	'2025-08-14 12:42:26.053194+00'),
(335,	9965188749,	'285.13334',	'290.84744',	'2025-08-14 12:42:26.053194+00'),
(336,	9965188749,	'290.84744',	'293.13307',	'2025-08-14 12:43:10.587679+00'),
(337,	9965188749,	'290.84744',	'293.13307',	'2025-08-14 12:43:10.587679+00'),
(338,	9965188749,	'293.13307',	'327.41764',	'2025-08-14 12:46:30.215928+00'),
(339,	9965188749,	'293.13307',	'327.41764',	'2025-08-14 12:46:30.215928+00'),
(340,	9965188749,	'327.41764',	'328.56046',	'2025-08-14 12:47:37.753661+00'),
(341,	9965188749,	'327.41764',	'328.56046',	'2025-08-14 12:47:37.753661+00'),
(342,	9965188749,	'328.56046',	'333.70315',	'2025-08-14 12:50:09.452547+00'),
(343,	9965188749,	'328.56046',	'333.70315',	'2025-08-14 12:50:09.452547+00'),
(350,	9965188749,	'1072.88573',	'1,072.46684',	'2025-08-18 03:00:20.007928+00'),
(351,	9965188749,	'1072.88573',	'1,072.46684',	'2025-08-18 03:00:20.007928+00'),
(213,	3241962943,	'104.80815',	'105.66212',	'2025-07-30 07:16:43.24653+00'),
(214,	3241962943,	'105.66212',	'104.88915',	'2025-07-31 05:59:00.053298+00'),
(216,	1168755224,	'0.95873',	'1.52955',	'2025-08-01 08:22:06.402297+00'),
(217,	2947642541,	'0',	'3.99510',	'2025-08-01 11:18:57.114875+00'),
(218,	2947642541,	'3.9951',	'6.16387',	'2025-08-01 11:24:26.569577+00'),
(219,	4195526937,	'22.3683',	'37.55394',	'2025-08-01 11:37:28.751019+00'),
(220,	4195526937,	'37.55394',	'49.53923',	'2025-08-01 11:55:15.431335+00'),
(223,	1168755224,	'1.52955',	'4.39867',	'2025-08-07 06:46:39.046306+00'),
(224,	1168755224,	'1.52955',	'4.39867',	'2025-08-07 06:46:39.046306+00'),
(225,	1168755224,	'4.39867',	'4.51262',	'2025-08-07 06:47:49.088614+00'),
(226,	1168755224,	'4.39867',	'4.51262',	'2025-08-07 06:47:49.088614+00'),
(232,	4195526937,	'49.57047',	'52.08926',	'2025-08-08 05:28:07.410138+00'),
(233,	4195526937,	'49.57047',	'52.08926',	'2025-08-08 05:28:07.410138+00'),
(234,	4195526937,	'52.08926',	'54.37357',	'2025-08-08 07:07:52.657398+00'),
(235,	4195526937,	'52.08926',	'54.37357',	'2025-08-08 07:07:52.657398+00'),
(236,	4195526937,	'54.37357',	'57.80005',	'2025-08-08 08:06:42.07086+00'),
(237,	4195526937,	'54.37357',	'57.80005',	'2025-08-08 08:06:42.07086+00'),
(254,	4195526937,	'99.89651',	'100.58068',	'2025-08-12 11:24:53.976617+00'),
(255,	4195526937,	'99.89651',	'100.58068',	'2025-08-12 11:24:53.976617+00'),
(256,	9965188749,	'0',	'0.57015',	'2025-08-12 12:00:09.927546+00'),
(257,	9965188749,	'0',	'0.57015',	'2025-08-12 12:00:09.927546+00'),
(258,	4195526937,	'100.58068',	'102.45076',	'2025-08-12 12:00:16.943652+00'),
(259,	4195526937,	'100.58068',	'102.45076',	'2025-08-12 12:00:16.943652+00'),
(260,	4195526937,	'102.45076',	'103.40861',	'2025-08-12 12:00:44.024949+00'),
(261,	4195526937,	'102.45076',	'103.40861',	'2025-08-12 12:00:44.024949+00'),
(262,	4195526937,	'103.40861',	'104.36646',	'2025-08-12 12:01:26.767186+00'),
(263,	4195526937,	'103.40861',	'104.36646',	'2025-08-12 12:01:26.767186+00'),
(264,	4195526937,	'104.36646',	'105.32430',	'2025-08-12 12:02:05.112088+00'),
(265,	4195526937,	'104.36646',	'105.32430',	'2025-08-12 12:02:05.112088+00'),
(266,	4195526937,	'105.3243',	'129.27046',	'2025-08-12 12:12:24.543528+00'),
(267,	4195526937,	'105.3243',	'129.27046',	'2025-08-12 12:12:24.546795+00'),
(268,	4195526937,	'129.27046',	'143.52412',	'2025-08-12 12:17:03.330972+00'),
(269,	4195526937,	'129.27046',	'143.52412',	'2025-08-12 12:17:03.330972+00'),
(293,	4195526937,	'148.79019',	'149.56187',	'2025-08-14 03:27:22.320216+00'),
(294,	4195526937,	'148.79019',	'149.56187',	'2025-08-14 03:27:22.320216+00'),
(295,	4195526937,	'149.56187',	'152.40520',	'2025-08-14 05:08:11.74829+00'),
(298,	2192231263,	'1.59995',	'3.00279',	'2025-08-14 11:39:28.564285+00'),
(299,	2192231263,	'1.59995',	'3.00279',	'2025-08-14 11:39:28.564285+00'),
(300,	2192231263,	'3.00279',	'3.56393',	'2025-08-14 11:45:39.148838+00'),
(301,	2192231263,	'3.56393',	'4.99418',	'2025-08-14 11:59:56.8868+00'),
(302,	9965188749,	'0.57015',	'1.71423',	'2025-08-14 12:04:21.054991+00'),
(303,	9965188749,	'1.71423',	'36.57021',	'2025-08-14 12:08:44.530523+00'),
(304,	8467591381,	'0',	'0.50513',	'2025-08-14 12:09:01.756722+00'),
(305,	8467591381,	'0',	'0.50513',	'2025-08-14 12:09:01.756722+00'),
(306,	9965188749,	'36.57021',	'53.71249',	'2025-08-14 12:10:12.049552+00'),
(307,	9965188749,	'53.71249',	'63.42645',	'2025-08-14 12:11:51.601723+00'),
(308,	9965188749,	'63.42645',	'76.56887',	'2025-08-14 12:13:24.049799+00'),
(309,	9965188749,	'63.42645',	'76.56887',	'2025-08-14 12:13:24.049799+00'),
(344,	9965188749,	'333.70315',	'472.92876',	'2025-08-16 04:03:42.135578+00'),
(345,	9965188749,	'333.70315',	'472.92876',	'2025-08-16 04:03:42.135578+00'),
(346,	9965188749,	'472.92876',	'1,055.52216',	'2025-08-16 04:06:16.252517+00'),
(347,	9965188749,	'472.92876',	'1,055.52216',	'2025-08-16 04:06:16.252517+00'),
(348,	9965188749,	'1055.52216',	'1,072.88573',	'2025-08-16 04:09:48.585313+00'),
(349,	9965188749,	'1055.52216',	'1,072.88573',	'2025-08-16 04:09:48.585313+00');

CREATE TABLE "v_fx" ("cc" text, "usd_rate" numeric);


CREATE TABLE "v_staff_rollup" ("staff_id" bigint, "tree_balance" numeric, "own_balance" numeric);


CREATE TABLE "public"."vault_pro" (
    "userid" bigint NOT NULL,
    "vaultBalance" bigint NOT NULL,
    "coin" text NOT NULL,
    "createdAt" timestamp NOT NULL,
    "updatedAt" timestamp NOT NULL,
    "incomeDate" timestamp NOT NULL
) WITH (oids = false);


CREATE SEQUENCE wallet_history_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 50 CACHE 1;

CREATE TABLE "public"."wallet_history" (
    "id" integer DEFAULT nextval('wallet_history_id_seq') NOT NULL,
    "uid" bigint NOT NULL,
    "username" text NOT NULL,
    "coin" text NOT NULL,
    "operation" text NOT NULL,
    "amount" numeric NOT NULL,
    "previous_balance" numeric NOT NULL,
    "new_balance" numeric NOT NULL,
    "transaction_time" timestamptz DEFAULT now(),
    "description" text,
    CONSTRAINT "wallet_history_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "wallet_history" ("id", "uid", "username", "coin", "operation", "amount", "previous_balance", "new_balance", "transaction_time", "description") VALUES
(1,	3241962943,	'AshishDangi',	'inr',	'credit',	10,	0,	10,	'2025-07-29 05:50:23.878119+00',	NULL),
(2,	4195526937,	'deepalithakur290',	'inr',	'credit',	10,	0,	10,	'2025-07-29 05:50:47.93128+00',	NULL),
(3,	4195526937,	'deepalithakur290',	'inr',	'credit',	90,	10,	100,	'2025-07-29 05:52:02.369305+00',	NULL),
(4,	3241962943,	'AshishDangi',	'inr',	'credit',	90,	10,	100,	'2025-07-29 05:52:07.931631+00',	NULL),
(5,	2947642541,	'jatin.verma',	'inr',	'credit',	100,	0,	100,	'2025-08-01 11:12:22.794824+00',	NULL),
(6,	2947642541,	'jatin.verma',	'inr',	'credit',	100,	47,	147,	'2025-08-01 11:20:35.549763+00',	NULL),
(7,	2947642541,	'jatin.verma',	'inr',	'credit',	100,	45,	145,	'2025-08-01 11:22:10.740646+00',	NULL),
(8,	4195526937,	'deepalithakur290',	'inr',	'debit',	100000,	104513.23333334,	4513.233333340002,	'2025-08-01 11:54:59.102975+00',	NULL),
(9,	4195526937,	'deepalithakur290',	'inr',	'debit',	513.23,	4513.23333334,	4000.00333334,	'2025-08-01 11:56:27.710574+00',	NULL),
(10,	1168755224,	'testpro6',	'inr',	'debit',	100,	1055.88,	955.8800000000001,	'2025-08-07 06:20:16.089686+00',	NULL),
(11,	1168755224,	'testpro6',	'btc',	'credit',	100,	0,	100,	'2025-08-07 06:21:39.809688+00',	NULL),
(12,	1168755224,	'testpro6',	'btc',	'debit',	100,	100,	0,	'2025-08-07 06:21:59.141313+00',	NULL),
(13,	3116637147,	'Khatoon',	'btc',	'credit',	90,	0,	90,	'2025-08-07 06:57:44.685763+00',	NULL),
(14,	3116637147,	'Khatoon',	'inr',	'credit',	90,	0,	90,	'2025-08-07 06:58:38.894413+00',	NULL),
(15,	1168755224,	'testpro6',	'inr',	'debit',	100,	944.74,	844.74,	'2025-08-07 06:59:13.762451+00',	NULL),
(16,	1168755224,	'testpro6',	'usdt',	'credit',	1,	7,	8,	'2025-08-07 12:03:15.59903+00',	NULL),
(17,	1168755224,	'testpro6',	'INR',	'credit',	1,	0,	1,	'2025-08-07 12:26:41.257657+00',	NULL),
(18,	1168755224,	'testpro6',	'INR',	'credit',	1,	0,	1,	'2025-08-07 12:28:23.96669+00',	NULL),
(19,	1168755224,	'testpro6',	'INR',	'credit',	1,	0,	1,	'2025-08-07 12:28:48.462176+00',	NULL),
(20,	1168755224,	'testpro6',	'USDT',	'debit',	1,	0,	0,	'2025-08-07 12:30:00.151953+00',	NULL),
(21,	2947642541,	'jatin.verma',	'INR',	'credit',	87,	0,	87,	'2025-08-07 12:32:07.045971+00',	NULL),
(22,	2947642541,	'jatin.verma',	'INR',	'credit',	30,	0,	30,	'2025-08-08 06:12:55.412787+00',	NULL),
(23,	2947642541,	'jatin.verma',	'INR',	'debit',	700,	0,	0,	'2025-08-12 08:02:36.515492+00',	NULL),
(24,	2947642541,	'jatin.verma',	'INR',	'credit',	1000,	0,	1000,	'2025-08-12 08:12:09.106688+00',	NULL),
(25,	2947642541,	'jatin.verma',	'INR',	'debit',	1000,	0,	0,	'2025-08-12 08:12:23.060881+00',	NULL),
(26,	2947642541,	'jatin.verma',	'INR',	'credit',	1000,	0,	1000,	'2025-08-12 08:13:37.379371+00',	NULL),
(27,	2947642541,	'jatin.verma',	'BTC',	'debit',	48000,	0,	0,	'2025-08-12 08:15:01.126742+00',	NULL),
(28,	2947642541,	'jatin.verma',	'BTC',	'debit',	1000,	0,	0,	'2025-08-12 08:15:38.17756+00',	NULL),
(29,	2947642541,	'jatin.verma',	'INR',	'credit',	70,	0,	70,	'2025-08-12 08:19:56.305026+00',	NULL),
(30,	2947642541,	'jatin.verma',	'INR',	'credit',	10000,	0,	10000,	'2025-08-12 08:23:28.605599+00',	NULL),
(31,	2947642541,	'jatin.verma',	'INR',	'debit',	10000,	0,	0,	'2025-08-12 08:23:42.863219+00',	NULL),
(32,	2947642541,	'jatin.verma',	'BTC',	'credit',	1,	0,	1,	'2025-08-12 08:24:12.930188+00',	NULL),
(33,	1168755224,	'testpro6',	'INR',	'credit',	100,	0,	100,	'2025-08-12 08:56:11.608387+00',	NULL),
(34,	8349173169,	'JetaSharma',	'INR',	'credit',	1000,	0,	1000,	'2025-08-12 10:34:36.881033+00',	NULL),
(35,	9965188749,	'RajeshChaudhary',	'INR',	'credit',	100,	0,	100,	'2025-08-12 11:58:33.403575+00',	NULL),
(36,	1168755224,	'testpro6',	'INR',	'credit',	1000,	0,	1000,	'2025-08-12 12:25:30.331001+00',	NULL),
(37,	1168755224,	'testpro6',	'INR',	'credit',	100,	0,	100,	'2025-08-12 12:25:49.23013+00',	NULL),
(38,	1168755224,	'testpro6',	'INR',	'credit',	100,	0,	100,	'2025-08-12 12:28:07.585479+00',	NULL),
(39,	1168755224,	'testpro6',	'INR',	'credit',	5,	0,	5,	'2025-08-12 12:33:42.239267+00',	NULL),
(40,	1168755224,	'testpro6',	'INR',	'debit',	200,	0,	0,	'2025-08-12 18:56:42.253161+00',	NULL),
(41,	1168755224,	'testpro6',	'INR',	'credit',	2000,	0,	2000,	'2025-08-12 19:06:47.353584+00',	NULL),
(42,	7654769296,	'Shivani ',	'INR',	'credit',	1000,	0,	1000,	'2025-08-13 04:31:26.667104+00',	NULL),
(43,	8218194912,	'lok123',	'INR',	'credit',	1000,	0,	1000,	'2025-08-14 08:09:29.799559+00',	NULL),
(44,	2192231263,	'PankajJoshi',	'INR',	'credit',	100,	0,	100,	'2025-08-14 09:59:50.713017+00',	NULL),
(45,	8467591381,	'PriyanshuBhatt',	'INR',	'credit',	1000,	0,	1000,	'2025-08-14 10:03:10.323427+00',	NULL),
(46,	8218194912,	'lok123',	'INR',	'credit',	10000,	0,	10000,	'2025-08-14 10:22:53.478201+00',	NULL),
(47,	2192231263,	'PankajJoshi',	'INR',	'credit',	100,	0,	100,	'2025-08-14 11:56:03.097805+00',	NULL),
(48,	9965188749,	'RajeshChaudhary',	'INR',	'credit',	100,	0,	100,	'2025-08-14 11:56:29.343978+00',	NULL),
(49,	1798669613,	'qqwerty',	'INR',	'credit',	900,	0,	900,	'2025-08-14 12:09:33.415847+00',	NULL),
(50,	9552925998,	'qwerty',	'INR',	'credit',	100,	0,	100,	'2025-08-18 06:02:12.498493+00',	NULL);

CREATE TABLE "public"."wallets" (
    "address" text NOT NULL,
    "uid" bigint NOT NULL,
    "coin" text NOT NULL,
    "date" timestamptz DEFAULT now()
) WITH (oids = false);


CREATE SEQUENCE withdrawals_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1;

CREATE TABLE "public"."withdrawals" (
    "uid" bigint NOT NULL,
    "date" timestamptz DEFAULT now() NOT NULL,
    "amount" numeric NOT NULL,
    "wallet" text NOT NULL,
    "status" text NOT NULL,
    "coin" text NOT NULL,
    "id" integer DEFAULT nextval('withdrawals_id_seq') NOT NULL,
    "chain" text,
    CONSTRAINT "withdrawals_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


ALTER TABLE ONLY "public"."bonus_history" ADD CONSTRAINT "bonus_history_userid_fkey" FOREIGN KEY (userid) REFERENCES userwager(uid) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_banner_notification_status" ADD CONSTRAINT "club_banner_notification_status_notification_id_fkey" FOREIGN KEY (notification_id) REFERENCES club_banner_notifications(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_banner_notifications" ADD CONSTRAINT "club_banner_notifications_banner_id_fkey" FOREIGN KEY (banner_id) REFERENCES club_banners(id) NOT DEFERRABLE;
ALTER TABLE ONLY "public"."club_banner_notifications" ADD CONSTRAINT "club_banner_notifications_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_banners" ADD CONSTRAINT "club_banners_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_earnings_log" ADD CONSTRAINT "club_earnings_log_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_memberships" ADD CONSTRAINT "club_memberships_agent_id_fkey" FOREIGN KEY (agent_id) REFERENCES users(id) NOT DEFERRABLE;
ALTER TABLE ONLY "public"."club_memberships" ADD CONSTRAINT "club_memberships_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE;
ALTER TABLE ONLY "public"."club_memberships" ADD CONSTRAINT "club_memberships_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_notification_status" ADD CONSTRAINT "club_notification_status_notification_id_fkey" FOREIGN KEY (notification_id) REFERENCES club_notifications(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."club_notifications" ADD CONSTRAINT "club_notifications_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."clubs" ADD CONSTRAINT "clubs_owner_id_fkey" FOREIGN KEY (owner_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."cricpaytransactions" ADD CONSTRAINT "cricpaytransactions_uid_fkey" FOREIGN KEY (uid) REFERENCES credits(uid) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."fiat_deposits" ADD CONSTRAINT "fiat_deposits_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."game_transactions" ADD CONSTRAINT "game_transactions_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."gis_freespins" ADD CONSTRAINT "gis_freespins_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."gis_freevouchers" ADD CONSTRAINT "gis_freevouchers_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."gis_sessions" ADD CONSTRAINT "gis_sessions_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."gis_transactions" ADD CONSTRAINT "gis_transactions_session_id_fkey" FOREIGN KEY (session_id) REFERENCES gis_sessions(session_id) NOT DEFERRABLE;
ALTER TABLE ONLY "public"."gis_transactions" ADD CONSTRAINT "gis_transactions_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE;

ALTER TABLE ONLY "public"."staff_balances" ADD CONSTRAINT "staff_balances_staff_id_fkey" FOREIGN KEY (staff_id) REFERENCES staff(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."staff_hierarchy" ADD CONSTRAINT "staff_hierarchy_ancestor_id_fkey" FOREIGN KEY (ancestor_id) REFERENCES staff(id) ON DELETE CASCADE NOT DEFERRABLE;
ALTER TABLE ONLY "public"."staff_hierarchy" ADD CONSTRAINT "staff_hierarchy_descendant_id_fkey" FOREIGN KEY (descendant_id) REFERENCES staff(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."staff_whatsapp_ref" ADD CONSTRAINT "staff_whatsapp_ref_staff_id_fkey" FOREIGN KEY (staff_id) REFERENCES staff(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."user_bonus" ADD CONSTRAINT "user_bonus_uid_fkey" FOREIGN KEY (uid) REFERENCES users(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."user_notifications" ADD CONSTRAINT "user_notifications_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."user_otps" ADD CONSTRAINT "fk_email" FOREIGN KEY (email) REFERENCES users(email) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."user_profile_stats" ADD CONSTRAINT "user_profile_stats_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."user_sessions" ADD CONSTRAINT "user_sessions_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."userconfig" ADD CONSTRAINT "userconfig_uid_fkey" FOREIGN KEY (uid) REFERENCES users(id) ON DELETE CASCADE NOT DEFERRABLE;

ALTER TABLE ONLY "public"."userwager_history" ADD CONSTRAINT "userwager_history_uid_fkey" FOREIGN KEY (uid) REFERENCES userwager(uid) ON DELETE CASCADE NOT DEFERRABLE;

CREATE VIEW "v_fx" AS SELECT upper((currency)::text) AS cc,
    (usd_rate)::numeric AS usd_rate
   FROM exchangerate;


-- 2025-08-18 07:05:11.815045+00
