-- Adminer 4.7.6 PostgreSQL dump

DROP SEQUENCE IF EXISTS admin_configurations_config_id_seq;
CREATE SEQUENCE admin_configurations_config_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;

CREATE TABLE "public"."admin_configurations" (
    "config_id" integer DEFAULT nextval('admin_configurations_config_id_seq') NOT NULL,
    "config_key" character varying(100) NOT NULL,
    "config_value" character varying(255) NOT NULL,
    "last_updated" timestamp DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "admin_configurations_config_key_key" UNIQUE ("config_key"),
    CONSTRAINT "admin_configurations_pkey" PRIMARY KEY ("config_id")
) WITH (oids = false);


DROP SEQUENCE IF EXISTS apaydeposits_id_seq;
CREATE SEQUENCE apaydeposits_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;

CREATE TABLE "public"."apaydeposits" (
    "id" integer DEFAULT nextval('apaydeposits_id_seq') NOT NULL,
    "order_id" character varying(50) NOT NULL,
    "user_id" bigint NOT NULL,
    "amount" numeric(18,2) NOT NULL,
    "currency" character varying(10) NOT NULL,
    "payment_system" character varying(50) NOT NULL,
    "custom_transaction_id" character varying(200),
    "status" character varying(20) DEFAULT 'Pending',
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "payment_details" jsonb,
    "webhook_response" jsonb,
    "error_reason" text,
    CONSTRAINT "apaydeposits_order_id_key" UNIQUE ("order_id"),
    CONSTRAINT "apaydeposits_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "idx_apaydeposits_order_id" ON "public"."apaydeposits" USING btree ("order_id");

CREATE INDEX "idx_apaydeposits_status" ON "public"."apaydeposits" USING btree ("status");

CREATE INDEX "idx_apaydeposits_user_id" ON "public"."apaydeposits" USING btree ("user_id");

INSERT INTO "apaydeposits" ("id", "order_id", "user_id", "amount", "currency", "payment_system", "custom_transaction_id", "status", "created_at", "updated_at", "payment_details", "webhook_response", "error_reason") VALUES
(8,	'69494ad4a0c4c53c',	2386483727,	300.00,	'INR',	'upi',	'TX_1766410964893',	'Pending',	'2025-12-22 14:42:44.626511',	'2025-12-22 14:42:44.626511',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjI0OTc3ODgsImV4cCI6MTc2NjQxNDU2NH0.yhpZc7DtKb1KgwBUft5vMYSpL7n8D5-dCJqGttGbYDE&order_id=69494ad4a0c4c53c", "success": true, "order_id": "69494ad4a0c4c53c"}',	NULL,	NULL),
(9,	'69494ae93bd58741',	2386483727,	301.00,	'INR',	'upi',	'TX_1766410985925',	'Pending',	'2025-12-22 14:43:05.622235',	'2025-12-22 14:43:05.622235',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjI0OTc4MzUsImV4cCI6MTc2NjQxNDU4NX0.qK5AfHmt373ANpi4T6W5lUPEN8AH2l4SYT7KzWr8huI&order_id=69494ae93bd58741", "success": true, "order_id": "69494ae93bd58741"}',	NULL,	NULL),
(10,	'69494b0517d5eff0',	2386483727,	300.00,	'INR',	'upi',	'TX_1766411014076',	'Pending',	'2025-12-22 14:43:33.615009',	'2025-12-22 14:43:33.615009',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjI0OTc4OTQsImV4cCI6MTc2NjQxNDYxM30.ZyxatsDze0OPJLvA1twaIH1tN-vsDIT5tOWA-7GpIQ4&order_id=69494b0517d5eff0", "success": true, "order_id": "69494b0517d5eff0"}',	NULL,	NULL),
(11,	'694989d87c994b7a',	2386483727,	1000.00,	'INR',	'upi',	'TX_1766427096397',	'Pending',	'2025-12-22 19:11:37.152459',	'2025-12-22 19:11:37.152459',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjI1Mjg4MDAsImV4cCI6MTc2NjQzMDY5Nn0.5ftgB66kmibbUJx3rqujg-MSoHLQ1sobSqZoNCtjl-I&order_id=694989d87c994b7a", "success": true, "order_id": "694989d87c994b7a"}',	NULL,	NULL),
(12,	'694a711abf77294e',	2386483727,	1000.00,	'INR',	'upi',	'TX_1766486298024',	'Pending',	'2025-12-23 11:38:18.521639',	'2025-12-23 11:38:18.521639',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjI1NzQ4NDUsImV4cCI6MTc2NjQ4OTg5OH0.YURXkRmu61xBpXHy079TtRFysR-o6ptdr3VW0zhgd7k&order_id=694a711abf77294e", "success": true, "order_id": "694a711abf77294e"}',	NULL,	NULL),
(13,	'694ee2b7a79b0d93',	2386483727,	300.00,	'INR',	'upi',	'TX_1766777526768',	'Pending',	'2025-12-26 20:32:07.836732',	'2025-12-26 20:32:07.836732',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjMwNDEyMzIsImV4cCI6MTc2Njc4MTEyN30.RLV0X1kQ2OtNBf9oXfT4r0EH-_yvy5kaqGrmBh2VpmI&order_id=694ee2b7a79b0d93", "success": true, "order_id": "694ee2b7a79b0d93"}',	NULL,	NULL),
(14,	'694ee2f0268f19a5',	2386483727,	500.00,	'INR',	'upi',	'TX_1766777583515',	'Pending',	'2025-12-26 20:33:04.461131',	'2025-12-26 20:33:04.461131',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjMwNDEzNzIsImV4cCI6MTc2Njc4MTE4NH0.V7cOrgB9mCBvcgYMhzMu_5jfZ6nhymAv5Cgi_inVCW8&order_id=694ee2f0268f19a5", "success": true, "order_id": "694ee2f0268f19a5"}',	NULL,	NULL),
(15,	'694ee3420ac7ecbe',	2386483727,	500.00,	'INR',	'upi',	'TX_1766777665503',	'Pending',	'2025-12-26 20:34:26.308798',	'2025-12-26 20:34:26.308798',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjMwNDE1NDMsImV4cCI6MTc2Njc4MTI2Nn0.FkwfginagmrEyukvuFYHC-GRKar1BVQ7TEomSyChkfg&order_id=694ee3420ac7ecbe", "success": true, "order_id": "694ee3420ac7ecbe"}',	NULL,	NULL),
(16,	'6953bfada9b87e80',	2386483727,	1000.00,	'INR',	'upi',	'TX_1767096237403',	'Pending',	'2025-12-30 13:03:57.936284',	'2025-12-30 13:03:57.936284',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjM1Njc1MzYsImV4cCI6MTc2NzA5OTgzN30.GJ5vTM96u1RYG4EucCmcJJv3vrQ6YE1yQfdIp9UGHU4&order_id=6953bfada9b87e80", "success": true, "order_id": "6953bfada9b87e80"}',	NULL,	NULL),
(17,	'695f7db992681b17',	2386483727,	1000.00,	'INR',	'upi',	'TX_1767865784771',	'Pending',	'2026-01-08 10:49:45.320219',	'2026-01-08 10:49:45.320219',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjQ3ODM5OTUsImV4cCI6MTc2Nzg2OTM4NX0.KD47Hn6hUf6fXTttXLkEEBDv9_fTXKZapaHo1itp5-Q&order_id=695f7db992681b17", "success": true, "order_id": "695f7db992681b17"}',	NULL,	NULL),
(18,	'6960c6cc2f5157e4',	2386483727,	1000.00,	'INR',	'upi',	'TX_1767950028124',	'Pending',	'2026-01-09 10:13:48.576602',	'2026-01-09 10:13:48.576602',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjQ5MjcxODksImV4cCI6MTc2Nzk1MzYyOH0.YjKEYWEn4nnVJTik2Caa0QyVhXpBFV5hZJzA2IMY2XE&order_id=6960c6cc2f5157e4", "success": true, "order_id": "6960c6cc2f5157e4"}',	NULL,	NULL),
(56,	'684aa59ff4f84ca2',	2579393191,	20000.00,	'INR',	'upi',	'TX_1749722525779',	'Failed',	'2025-06-12 10:02:07.215743',	'2025-06-13 10:11:22.659211',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6OTEzMjIwMywiZXhwIjoxNzQ5NzI2MTI3fQ.kCoqM9ylzFJd9F-aGER9wNRdv7QioHnxLXhcPniHOks&order_id=684aa59ff4f84ca2", "success": true, "order_id": "684aa59ff4f84ca2"}',	'{"signature": "b0f61fe843793e04c76e2321f17b8a395bc0be2c", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 20000, "status": "Failed", "currency": "INR", "order_id": "684aa59ff4f84ca2", "created_at": 1749722533, "activated_at": null, "custom_user_id": "2579393191", "payment_system": "imps", "custom_transaction_id": "TX_1749722525779"}]}',	'Payment gateway rejection'),
(85,	'6852a10faace8ef2',	2579393191,	2000.00,	'INR',	'upi',	'TX_1750245644667',	'Success',	'2025-06-18 11:20:47.372967',	'2025-06-18 11:25:37.367463',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6OTM4MjMyNSwiZXhwIjoxNzUwMjQ5MjQ3fQ.5NRoXl4lQ6e9Sgk1UOmxx1X5eVg5_PXffCCcD-Vz25w&order_id=6852a10faace8ef2", "success": true, "order_id": "6852a10faace8ef2"}',	'{"signature": "d11c95fd6ec095c10a08ac760f7df6e9d187e810", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 2000, "status": "Success", "currency": "INR", "order_id": "6852a10faace8ef2", "created_at": 1750245654, "activated_at": 1750245870, "custom_user_id": "2579393191", "payment_system": "phonepe", "custom_transaction_id": "TX_1750245644667"}]}',	NULL),
(86,	'6853dc0f374243e8',	2579393191,	20000.00,	'INR',	'upi',	'TX_1750326284703',	'Success',	'2025-06-19 09:44:47.67685',	'2025-06-19 09:50:05.777081',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6OTQyMjU5NSwiZXhwIjoxNzUwMzI5ODg3fQ.d9REbQi3rpRAS5tjLeYCb80t_G9O-_gTZqwadEzmymc&order_id=6853dc0f374243e8", "success": true, "order_id": "6853dc0f374243e8"}',	'{"signature": "96df224055f9b292f219ece5e37c0377823ecd5e", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 20000, "status": "Success", "currency": "INR", "order_id": "6853dc0f374243e8", "created_at": 1750326296, "activated_at": 1750326565, "custom_user_id": "2579393191", "payment_system": "phonepe", "custom_transaction_id": "TX_1750326284703"}]}',	NULL),
(115,	'686bc46b06df94cb',	3638658674,	300.00,	'INR',	'upi',	'TX_1751893098180',	'Success',	'2025-07-07 12:58:19.53598',	'2025-07-07 13:06:12.051595',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTAyMTcyMDksImV4cCI6MTc1MTg5NjY5OX0.8cpEgwUdvh2XTGWucB3YanSopDYtZKMRvTHv04_PLnk&order_id=686bc46b06df94cb", "success": true, "order_id": "686bc46b06df94cb"}',	'{"signature": "44a044054da01a89ee3c2ce53cd9fcc4afda4e71", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 300, "status": "Success", "currency": "INR", "order_id": "686bc46b06df94cb", "created_at": 1751893111, "activated_at": 1751893542, "custom_user_id": "3638658674", "payment_system": "phonepe", "custom_transaction_id": "TX_1751893098180"}]}',	NULL),
(106,	'68665771e9ae7ce0',	2627859968,	1000.00,	'INR',	'upi',	'TX_1751537520330',	'Failed',	'2025-07-03 10:12:01.475379',	'2025-07-04 10:21:04.108326',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTAwMTUwMTksImV4cCI6MTc1MTU0MTEyMX0.Q5iSDfq4BHaqhEdddTMM1iLMchqq0mKGxhxUQMJSSOg&order_id=68665771e9ae7ce0", "success": true, "order_id": "68665771e9ae7ce0"}',	'{"signature": "a794273f82597ddafc844542d1cbac73c6d998ce", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 1000, "status": "Failed", "currency": "INR", "order_id": "68665771e9ae7ce0", "created_at": 1751537525, "activated_at": null, "custom_user_id": "2627859968", "payment_system": "phonepe", "custom_transaction_id": "TX_1751537520330"}]}',	'Payment gateway rejection'),
(111,	'6866f7ac1aaa769a',	2316169451,	50000.00,	'INR',	'upi',	'TX_1751578539083',	'Failed',	'2025-07-03 21:35:40.444301',	'2025-07-04 21:41:03.613298',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTAwNDIzNzYsImV4cCI6MTc1MTU4MjE0MH0.BonhkYr5sXyn1k4VLGMlav0A3xMEJSMkgTgjzU36yVU&order_id=6866f7ac1aaa769a", "success": true, "order_id": "6866f7ac1aaa769a"}',	'{"signature": "5e8cec435c8d2b8c15d7c1b22febf3d273a528e3", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 50000, "status": "Failed", "currency": "INR", "order_id": "6866f7ac1aaa769a", "created_at": 1751578543, "activated_at": null, "custom_user_id": "2316169451", "payment_system": "phonepe", "custom_transaction_id": "TX_1751578539083"}]}',	'Payment gateway rejection'),
(117,	'686d6577cb4e8128',	9595339986,	10000.00,	'INR',	'upi',	'TX_1751999861438',	'Pending',	'2025-07-08 18:37:43.186661',	'2025-07-08 18:37:43.186661',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTAyOTUzOTAsImV4cCI6MTc1MjAwMzQ2M30.pzecz6NsKsh---K6yKBfiwJt_BlQZSS7UflADmyltS8&order_id=686d6577cb4e8128", "success": true, "order_id": "686d6577cb4e8128"}',	NULL,	NULL),
(90,	'68568f247a02c98a',	5664694811,	1000.00,	'INR',	'upi',	'TX_1750503203765',	'Failed',	'2025-06-21 10:53:24.679381',	'2025-06-22 11:01:09.592232',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6OTUxMjE4MSwiZXhwIjoxNzUwNTA2ODA0fQ.N_fP_XazOn0mnQHRdE9TcspKXLWp4FV5UF1sszvFLrE&order_id=68568f247a02c98a", "success": true, "order_id": "68568f247a02c98a"}',	'{"signature": "495ec459bd4a209095915dae1d3c1fd69f21617d", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 1000, "status": "Failed", "currency": "INR", "order_id": "68568f247a02c98a", "created_at": 1750503210, "activated_at": null, "custom_user_id": "5664694811", "payment_system": "phonepe", "custom_transaction_id": "TX_1750503203765"}]}',	'Payment gateway rejection'),
(100,	'6858f2fc6903eca6',	7889918643,	2000.00,	'INR',	'upi',	'TX_1750659834734',	'Success',	'2025-06-23 06:23:56.414405',	'2025-06-23 06:29:18.365317',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6OTU4MzcwMCwiZXhwIjoxNzUwNjYzNDM2fQ.-tRz6c53J9EOHmPDQjvcg-j26BOjM2-Tozdzr0ZkHlI&order_id=6858f2fc6903eca6", "success": true, "order_id": "6858f2fc6903eca6"}',	'{"signature": "1d029572b8f01d10908dc974b6e56bbde0a844d1", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 2000, "status": "Success", "currency": "INR", "order_id": "6858f2fc6903eca6", "created_at": 1750659850, "activated_at": 1750660137, "custom_user_id": "7889918643", "payment_system": "phonepe", "custom_transaction_id": "TX_1750659834734"}]}',	NULL),
(116,	'686d569a1f0552c5',	4218936684,	3050.00,	'INR',	'upi',	'TX_1751996056917',	'Failed',	'2025-07-08 17:34:18.472685',	'2025-07-09 17:41:26.92781',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTAyOTEyNjgsImV4cCI6MTc1MTk5OTY1OH0.ESVuMq0_rLbEoODlrlvuOHsexd5idLCnrfHbUTOTJ1E&order_id=686d569a1f0552c5", "success": true, "order_id": "686d569a1f0552c5"}',	'{"signature": "3a97d8465a886520302a4019c1211d761ca87136", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 3050, "status": "Failed", "currency": "INR", "order_id": "686d569a1f0552c5", "created_at": 1751996064, "activated_at": null, "custom_user_id": "4218936684", "payment_system": "phonepe", "custom_transaction_id": "TX_1751996056917"}]}',	'Payment gateway rejection'),
(118,	'686e5f8ca2ca8056',	2627859968,	1000.00,	'INR',	'upi',	'TX_1752063883440',	'Failed',	'2025-07-09 12:24:44.792156',	'2025-07-10 12:31:18.033341',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTAzMzAxNjMsImV4cCI6MTc1MjA2NzQ4NH0.GIkehnbR0KWLGqbF5Xl6y57pZ_YqMEfhvIUDiN1PVEA&order_id=686e5f8ca2ca8056", "success": true, "order_id": "686e5f8ca2ca8056"}',	'{"signature": "821b5660fba88bf2d67b8f64c1e08a469eb2bc3d", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 1000, "status": "Failed", "currency": "INR", "order_id": "686e5f8ca2ca8056", "created_at": 1752063892, "activated_at": null, "custom_user_id": "2627859968", "payment_system": "phonepe", "custom_transaction_id": "TX_1752063883440"}]}',	'Payment gateway rejection'),
(119,	'6873b48e18a494c7',	9133584512,	5000.00,	'INR',	'upi',	'TX_1752413325142',	'Failed',	'2025-07-13 13:28:46.287232',	'2025-07-14 13:31:31.526912',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MzA5MTYsImV4cCI6MTc1MjQxNjkyNn0.b43vR2ycCjac5mHH8dmofcErkY1RYCpOLZORdjr93d0&order_id=6873b48e18a494c7", "success": true, "order_id": "6873b48e18a494c7"}',	'{"signature": "47c395593dcaa7a2a2d38a536b0e43807bb0dd3d", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 1, "status": "Failed", "currency": "INR", "order_id": "6873b48e18a494c7", "created_at": 1752413333, "activated_at": null, "custom_user_id": "9133584512", "payment_system": "phonepe", "custom_transaction_id": "TX_1752413325142"}]}',	'Payment gateway rejection'),
(120,	'6873b698cd287715',	9133584512,	5000.00,	'INR',	'upi',	'TX_1752413847160',	'Failed',	'2025-07-13 13:37:28.457281',	'2025-07-14 13:41:07.273587',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA2MzE0OTksImV4cCI6MTc1MjQxNzQ0OH0.wKi84t9U6SEOqQAqk9vaWbzmB4mpiDZmsag19Nvb47c&order_id=6873b698cd287715", "success": true, "order_id": "6873b698cd287715"}',	'{"signature": "102dd861f44514ce49bca9bf4f796876d5ad6ed7", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 5000, "status": "Failed", "currency": "INR", "order_id": "6873b698cd287715", "created_at": 1752413854, "activated_at": null, "custom_user_id": "9133584512", "payment_system": "phonepe", "custom_transaction_id": "TX_1752413847160"}]}',	'Payment gateway rejection'),
(121,	'687722c88e08e71c',	2626926939,	300.00,	'INR',	'upi',	'TX_1752638151553',	'Failed',	'2025-07-16 03:55:52.595631',	'2025-07-17 04:01:20.999287',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA3ODkzMzAsImV4cCI6MTc1MjY0MTc1Mn0.Qok60iMWQ_wcdfD7exLeWIKiw9H6aHLhbCg0w6VXrMM&order_id=687722c88e08e71c", "success": true, "order_id": "687722c88e08e71c"}',	'{"signature": "c324fcbd19714712c412ac329df7fcba344630e3", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 300, "status": "Failed", "currency": "INR", "order_id": "687722c88e08e71c", "created_at": 1752638180, "activated_at": null, "custom_user_id": "2626926939", "payment_system": "phonepe", "custom_transaction_id": "TX_1752638151553"}]}',	'Payment gateway rejection'),
(127,	'687bb4579cbab087',	6183882183,	500.00,	'INR',	'upi',	'TX_1752937588799',	'Failed',	'2025-07-19 15:05:59.762229',	'2025-07-20 15:11:03.114259',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTA5OTUxNDUsImV4cCI6MTc1Mjk0MTE1OX0.ufBH2DMmGI4LcTtv2OJYuYuoHV-qPPUp3XXYhX49EqE&order_id=687bb4579cbab087", "success": true, "order_id": "687bb4579cbab087"}',	'{"signature": "f5ebaeec6e78bbd0b9dcccb2a736aa41457dec83", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 500, "status": "Failed", "currency": "INR", "order_id": "687bb4579cbab087", "created_at": 1752937565, "activated_at": null, "custom_user_id": "6183882183", "payment_system": "phonepe", "custom_transaction_id": "TX_1752937588799"}]}',	'Payment gateway rejection'),
(128,	'687d436fc81799b9',	5263326455,	500.00,	'INR',	'upi',	'TX_1753039726310',	'Failed',	'2025-07-20 19:28:47.451937',	'2025-07-21 19:31:02.784679',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTEwNTQ5NDgsImV4cCI6MTc1MzA0MzMyN30.Tdca-MCCE2hcuISXJzm_IcooXzjtb-2PAWN8teiIKrQ&order_id=687d436fc81799b9", "success": true, "order_id": "687d436fc81799b9"}',	'{"signature": "6e5a54575c006321e1dc5f3d0130ec64dc62d0ec", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 500, "status": "Failed", "currency": "INR", "order_id": "687d436fc81799b9", "created_at": 1753039735, "activated_at": null, "custom_user_id": "5263326455", "payment_system": "phonepe", "custom_transaction_id": "TX_1753039726310"}]}',	'Payment gateway rejection'),
(134,	'68891b6b23eda2ca',	5664694811,	1000.00,	'INR',	'upi',	'TX_1753816016091',	'Failed',	'2025-07-29 19:05:15.497999',	'2025-07-30 19:11:04.037473',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTE1MTA3MDUsImV4cCI6MTc1MzgxOTUxNX0.yE6ebT2n1s4Yxc9NGagLL2pFgawXb6pIrZCjPna73No&order_id=68891b6b23eda2ca", "success": true, "order_id": "68891b6b23eda2ca"}',	'{"signature": "45a95489fa9cd978f21b061629029b6552d5c5bb", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 1000, "status": "Failed", "currency": "INR", "order_id": "68891b6b23eda2ca", "created_at": 1753815920, "activated_at": null, "custom_user_id": "5664694811", "payment_system": "phonepe", "custom_transaction_id": "TX_1753816016091"}]}',	'Payment gateway rejection'),
(136,	'688ad33a1d8201f4',	2316169451,	2500.00,	'INR',	'upi',	'TX_1753928506126',	'Success',	'2025-07-31 02:21:47.046922',	'2025-07-31 02:25:01.921737',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTE1NjM5MTQsImV4cCI6MTc1MzkzMjEwNn0.rI73KEdKdHjQ2E57w7iJ97R1_Epp0MXa1xnZ_FW9uJU&order_id=688ad33a1d8201f4", "success": true, "order_id": "688ad33a1d8201f4"}',	'{"signature": "db2887174a42dd20bec71f83a48014d5f74e6ba6", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 2500, "status": "Success", "currency": "INR", "order_id": "688ad33a1d8201f4", "created_at": 1753928530, "activated_at": 1753928685, "custom_user_id": "2316169451", "payment_system": "phonepe", "custom_transaction_id": "TX_1753928506126"}]}',	NULL),
(135,	'688acbb375112bae',	2579393191,	2000.00,	'INR',	'upi',	'TX_1753926575639',	'Failed',	'2025-07-31 01:49:39.957085',	'2025-08-01 01:51:02.155387',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTE1NjM0MTksImV4cCI6MTc1MzkzMDE3OX0.zGGURCz14Y04Ihu-Fq0OqosSpHZd8IOOof6WcJ9sXp8&order_id=688acbb375112bae", "success": true, "order_id": "688acbb375112bae"}',	'{"signature": "54e6bb224b1d7620611263f257d8a36dfb152ac6", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 2000, "status": "Failed", "currency": "INR", "order_id": "688acbb375112bae", "created_at": 1753926593, "activated_at": null, "custom_user_id": "2579393191", "payment_system": "phonepe", "custom_transaction_id": "TX_1753926575639"}]}',	'Payment gateway rejection'),
(137,	'689c99b06934a844',	1633833479,	4000.00,	'INR',	'upi',	'TX_1755093425184',	'Failed',	'2025-08-13 13:57:04.978806',	'2025-08-14 14:01:04.630211',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MTI0Mzk4ODIsImV4cCI6MTc1NTA5NzAyNH0.JUsfjTHGiZuTPLkhVjc7szvMuwhbR9_HQnI2DgnUtHs&order_id=689c99b06934a844", "success": true, "order_id": "689c99b06934a844"}',	'{"signature": "75dbb8eb04c61967de2ffdaea8563cd676610d1f", "access_key": "f804a8414e6f76fa30ac24ee0910db00", "transactions": [{"amount": 4000, "status": "Failed", "currency": "INR", "order_id": "689c99b06934a844", "created_at": 1755093429, "activated_at": null, "custom_user_id": "1633833479", "payment_system": "phonepe", "custom_transaction_id": "TX_1755093425184"}]}',	'Payment gateway rejection'),
(3,	'6947df7214afa660',	2386483727,	300.00,	'INR',	'upi',	'TX_1766317938291',	'Pending',	'2025-12-21 12:52:18.778602',	'2025-12-21 12:52:18.778602',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjIzOTU5OTAsImV4cCI6MTc2NjMyMTUzOH0.QoDIlK7RQ0QiAUbN21QB3aEWakqSuldvOswI43kViRY&order_id=6947df7214afa660", "success": true, "order_id": "6947df7214afa660"}',	NULL,	NULL),
(4,	'6947e0d66833da6e',	2386483727,	300.00,	'INR',	'upi',	'TX_1766318294640',	'Pending',	'2025-12-21 12:58:15.145565',	'2025-12-21 12:58:15.145565',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjIzOTY1MTksImV4cCI6MTc2NjMyMTg5NH0.mMuvNiUlXKtlC--IxVfKeU_8toIGlgX1e_zfmBUw41o&order_id=6947e0d66833da6e", "success": true, "order_id": "6947e0d66833da6e"}',	NULL,	NULL),
(5,	'6947e11322c80ccb',	2386483727,	300.00,	'INR',	'upi',	'TX_1766318354892',	'Pending',	'2025-12-21 12:59:15.581235',	'2025-12-21 12:59:15.581235',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjIzOTY2MDYsImV4cCI6MTc2NjMyMTk1NX0.ogeFcfmqNEEyJDP_0GHvdzQUvs3ioNy-A0UgpggzySk&order_id=6947e11322c80ccb", "success": true, "order_id": "6947e11322c80ccb"}',	NULL,	NULL),
(6,	'6947e129a34ff54b',	2386483727,	300.00,	'INR',	'upi',	'TX_1766318377282',	'Pending',	'2025-12-21 12:59:37.776449',	'2025-12-21 12:59:37.776449',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjIzOTY2NDYsImV4cCI6MTc2NjMyMTk3N30.2vQ31XllYpVMSdctV_YbZKssMaXeV4Yl4ovmBbDBgOM&order_id=6947e129a34ff54b", "success": true, "order_id": "6947e129a34ff54b"}',	NULL,	NULL),
(7,	'69491f33a0a314cf',	2386483727,	1000.00,	'INR',	'upi',	'TX_1766399794248',	'Pending',	'2025-12-22 11:36:36.121239',	'2025-12-22 11:36:36.121239',	'{"url": "https://dazen1.one/pay/en?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6MjI0Nzk0MTAsImV4cCI6MTc2NjQwMzM5NX0.MinkzZ8dW4SD0mNIHuNt-M5BdGbIjF6wydu3LQxLs4g&order_id=69491f33a0a314cf", "success": true, "order_id": "69491f33a0a314cf"}',	NULL,	NULL);

CREATE TABLE "public"."apigames" (
    "id" bigint,
    "title" text,
    "platform" text,
    "type" text,
    "subtype" text,
    "enabled" bigint,
    "fun_mode" bigint,
    "campaigns" bigint,
    "vendor" text,
    "created_at" text,
    "vendor_groups" text,
    "details_description_en" text,
    "details_thumbnails_300x300" text
) WITH (oids = false);


CREATE TABLE "public"."bank" (
    "btc" numeric DEFAULT '0',
    "eth" numeric DEFAULT '0',
    "ltc" numeric DEFAULT '0',
    "bch" numeric DEFAULT '0',
    "usdt" numeric DEFAULT '0',
    "trx" numeric DEFAULT '0',
    "doge" numeric DEFAULT '0',
    "ada" numeric DEFAULT '0',
    "xrp" numeric DEFAULT '0',
    "bnb" numeric DEFAULT '0',
    "usdp" numeric DEFAULT '0',
    "nexo" numeric DEFAULT '0',
    "mkr" numeric DEFAULT '0',
    "tusd" numeric DEFAULT '0',
    "usdc" numeric DEFAULT '0',
    "busd" numeric DEFAULT '0',
    "id" bigint NOT NULL,
    "inr" numeric DEFAULT '0',
    "sc" numeric DEFAULT '0',
    "mvr" numeric DEFAULT '0',
    "bjb" numeric DEFAULT '0',
    "aed" numeric DEFAULT '0',
    "npr" numeric DEFAULT '0',
    "pkr" numeric DEFAULT '0'
) WITH (oids = false);


DROP SEQUENCE IF EXISTS banners_id_seq;
CREATE SEQUENCE banners_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;

CREATE TABLE "public"."banners" (
    "id" integer DEFAULT nextval('banners_id_seq') NOT NULL,
    "type" character varying(100) NOT NULL,
    "image" character varying(255),
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "banners_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "banners" ("id", "type", "image", "created_at", "updated_at") VALUES
(6,	'banner6',	'image-1764066348181-245453617.png',	'2024-12-15 20:39:34.559268+01',	'2025-11-25 11:25:48.329688+01'),
(5,	'banner5',	'image-1764066446989-946185829.png',	'2024-12-15 20:39:24.807641+01',	'2025-11-25 11:27:27.169031+01'),
(4,	'banner4',	'image-1764066457758-396649407.png',	'2024-12-15 20:39:19.221322+01',	'2025-11-25 11:27:37.923162+01'),
(3,	'banner3',	'image-1764066466530-528748776.png',	'2024-12-15 20:39:13.582703+01',	'2025-11-25 11:27:46.83873+01'),
(2,	'banner2',	'image-1764066474783-401789492.png',	'2024-12-15 20:39:04.161945+01',	'2025-11-25 11:27:55.026459+01'),
(1,	'banner1',	'image-1764066483341-51213543.png',	'2024-12-15 20:38:54.368686+01',	'2025-11-25 11:28:03.747277+01');

CREATE TABLE "public"."betoutcome_1m" (
    "sessionid" character varying(250),
    "betnumber" integer,
    "betcolour" character varying(250)
) WITH (oids = false);


CREATE TABLE "public"."betoutcome_2m" (
    "sessionid" character varying(250),
    "betnumber" integer,
    "betcolour" character varying(250)
) WITH (oids = false);


CREATE TABLE "public"."betoutcome_30s" (
    "sessionid" character varying(250),
    "betnumber" integer,
    "betcolour" character varying(250)
) WITH (oids = false);


CREATE TABLE "public"."bets" (
    "game" text NOT NULL,
    "gid" bigint NOT NULL,
    "uid" bigint NOT NULL,
    "amount" numeric NOT NULL,
    "coin" text NOT NULL,
    "result" json,
    "profit" numeric DEFAULT '0',
    "created" timestamptz DEFAULT now() NOT NULL,
    "hash" text,
    "name" text,
    "cashout" numeric,
    "slot" character varying
) WITH (oids = false);


CREATE TABLE "public"."bets_1m" (
    "uid" character varying(250),
    "value" character varying(250),
    "amount" character varying(250),
    "sessionid" character varying(250),
    "status" character varying(250),
    "cointype" character varying(50)
) WITH (oids = false);

INSERT INTO "bets_1m" ("uid", "value", "amount", "sessionid", "status", "cointype") VALUES
('5622472729',	'2',	'10',	'1729794146450',	'null',	'usdt');

CREATE TABLE "public"."bets_2m" (
    "uid" character varying(250),
    "value" character varying(250),
    "amount" character varying(250),
    "sessionid" character varying(250),
    "status" character varying(250),
    "cointype" character varying(50)
) WITH (oids = false);

INSERT INTO "bets_2m" ("uid", "value", "amount", "sessionid", "status", "cointype") VALUES
('5622472729',	'1',	'10',	'1729710747953',	'null',	'inr'),
('5622472729',	'1',	'10',	'1729710747953',	'null',	'usdt'),
('5622472729',	'4',	'10',	'1729712550571',	'null',	'usdt'),
('5622472729',	'3',	'10',	'1729794165062',	'null',	'usdt'),
('5622472729',	'3',	'10',	'1729794285249',	'null',	'usdt'),
('5622472729',	'8',	'10',	'1729797650430',	'null',	'usdt');

CREATE TABLE "public"."bets_30s" (
    "uid" character varying(250),
    "value" character varying(250),
    "amount" character varying(250),
    "sessionid" character varying(250),
    "status" character varying(250),
    "cointype" character varying(50)
) WITH (oids = false);


DROP SEQUENCE IF EXISTS bonus_history_id_seq;
CREATE SEQUENCE bonus_history_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."bonus_history" (
    "id" bigint DEFAULT nextval('bonus_history_id_seq') NOT NULL,
    "userid" bigint NOT NULL,
    "bonus_type" character varying(10) NOT NULL,
    "wager_change" numeric NOT NULL,
    "bonus_amount" numeric NOT NULL,
    "is_claimed" boolean DEFAULT false,
    "claim_deadline" timestamptz NOT NULL,
    "created_at" timestamptz DEFAULT now(),
    "claimed_at" timestamptz,
    "is_unclaimable" boolean DEFAULT false,
    CONSTRAINT "bonus_history_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "bonus_history_userid_fkey" FOREIGN KEY (userid) REFERENCES userwager(uid) ON DELETE CASCADE NOT DEFERRABLE
) WITH (oids = false);

CREATE INDEX "idx_bonus_history_bonus_type" ON "public"."bonus_history" USING btree ("bonus_type");

CREATE INDEX "idx_bonus_history_userid" ON "public"."bonus_history" USING btree ("userid");

CREATE INDEX "idx_bonus_history_userid_type" ON "public"."bonus_history" USING btree ("userid", "bonus_type");

COMMENT ON TABLE "public"."bonus_history" IS 'Stores history of bonus calculations and claims';

COMMENT ON COLUMN "public"."bonus_history"."userid" IS 'User ID from userwager table';

COMMENT ON COLUMN "public"."bonus_history"."bonus_type" IS 'Type of bonus: daily, weekly, or monthly';

COMMENT ON COLUMN "public"."bonus_history"."wager_change" IS 'Total wager change for the period';

COMMENT ON COLUMN "public"."bonus_history"."bonus_amount" IS 'Calculated bonus amount';

COMMENT ON COLUMN "public"."bonus_history"."is_claimed" IS 'Whether the bonus was claimed';

COMMENT ON COLUMN "public"."bonus_history"."claim_deadline" IS 'Deadline to claim the bonus';

COMMENT ON COLUMN "public"."bonus_history"."created_at" IS 'Timestamp when bonus was calculated';

COMMENT ON COLUMN "public"."bonus_history"."claimed_at" IS 'Timestamp when bonus was claimed';

COMMENT ON COLUMN "public"."bonus_history"."is_unclaimable" IS 'Whether the bonus is no longer claimable';


CREATE TABLE "public"."bonusgame" (
    "userid" bigint NOT NULL,
    "luckyspin" numeric NOT NULL,
    "dailybonus" numeric NOT NULL,
    "weeklybonus" numeric NOT NULL,
    "monthlybonus" numeric NOT NULL,
    "depositbonus" numeric NOT NULL,
    "rollcompetitionbonus" numeric NOT NULL,
    "createdat" timestamp NOT NULL,
    "updatedat" timestamp NOT NULL,
    "rakebackbonus" numeric
) WITH (oids = false);


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


CREATE TABLE "public"."bots" (
    "id" numeric NOT NULL,
    "status" text,
    "time" numeric,
    "game" text,
    "coin" text
) WITH (oids = false);


DROP SEQUENCE IF EXISTS ccdeposit_id_seq;
CREATE SEQUENCE ccdeposit_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;

CREATE TABLE "public"."ccdeposit" (
    "id" integer DEFAULT nextval('ccdeposit_id_seq') NOT NULL,
    "userid" character varying(255),
    "coinid" integer,
    "price" numeric(10,2),
    "orderid" character varying(255),
    "chain" character varying(10),
    "deposit_address" character varying(255),
    "amount" numeric(10,2),
    "memo" character varying(255),
    "checkout_url" character varying(255),
    "confirms_needed" integer,
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp,
    "status" text NOT NULL,
    CONSTRAINT "ccdeposit_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "ccdeposit" ("id", "userid", "coinid", "price", "orderid", "chain", "deposit_address", "amount", "memo", "checkout_url", "confirms_needed", "created_at", "updated_at", "status") VALUES
(4,	'2386483727',	1155,	100.00,	'order1766396723338',	'BTC',	'bc1qpp4skpw5zspddrk63t4885w24xgdz2j3qg6lzh',	100.00,	'',	'https://ccpayment.com/sl/auwto7',	NULL,	'2025-12-22 10:45:23.449773',	'2025-12-22 10:45:23.449773',	'Processing'),
(5,	'2386483727',	1280,	10.00,	'order1766399882539',	'BSC',	'0xF676cD7bDE81Bdf42d77bAE60043C12f162814e8',	10.00,	'',	'https://ccpayment.com/sl/ya7gq',	2,	'2025-12-22 11:38:03.65169',	'2025-12-22 11:38:03.65169',	'Success'),
(6,	'2386483727',	1280,	10.00,	'order1766486383497',	'BSC',	'0xeC0EEFd84BC0D5Be2B21c1667eF6C658E04A37E2',	10.00,	'',	'https://ccpayment.com/sl/dn5zxi',	2,	'2025-12-23 11:39:44.643842',	'2025-12-23 11:39:44.643842',	'Processing'),
(7,	'5156441594',	1280,	55.00,	'order1766839151350',	'ETH',	'0x48A7643307015C2686636eC575898A1c96FeD87C',	55.00,	'',	'https://ccpayment.com/sl/fodza0',	2,	'2025-12-27 13:39:13.163423',	'2025-12-27 13:39:13.163423',	'Processing'),
(8,	'7275244327',	1280,	120.00,	'order1767690145271',	'TRX',	'TPHLpqbLwaiafT6aFAB1aeyjeZJd3zevAo',	120.00,	'',	'https://ccpayment.com/sl/50af7k',	1,	'2026-01-06 10:02:25.85441',	'2026-01-06 10:02:25.85441',	'Processing'),
(9,	'7275244327',	1280,	12121.00,	'order1767690166220',	'BSC',	'0xF676cD7bDE81Bdf42d77bAE60043C12f162814e8',	12121.00,	'',	'https://ccpayment.com/sl/5n3asl',	2,	'2026-01-06 10:02:46.567603',	'2026-01-06 10:02:46.567603',	'Processing'),
(10,	'7275244327',	1161,	121212.00,	'order1767690183645',	'OPTIMISM',	'0x512D6066469d5113cEF15E80c0dC3D404Dc5BAfC',	121212.00,	'',	'https://ccpayment.com/sl/38vk47',	3,	'2026-01-06 10:03:04.960777',	'2026-01-06 10:03:04.960777',	'Processing'),
(3,	'2386483727',	1280,	10.00,	'order1766316451805',	'TRX',	'TTDGTnNMiiEsqn8JC2uycWkwsgiMKXLNQy',	10.00,	'',	'https://ccpayment.com/sl/64gz1l',	1,	'2025-12-21 12:27:33.68962',	'2025-12-21 12:27:33.68962',	'Processing');

CREATE TABLE "public"."chat_brazil" (
    "name" text NOT NULL,
    "message" text NOT NULL,
    "sorter" numeric NOT NULL,
    "date" timestamptz DEFAULT now(),
    "avatar" text,
    "uid" bigint NOT NULL,
    "time" text,
    "level" numeric DEFAULT '1'
) WITH (oids = false);


CREATE TABLE "public"."chat_global" (
    "name" text NOT NULL,
    "message" text NOT NULL,
    "sorter" numeric NOT NULL,
    "date" timestamptz DEFAULT now(),
    "avatar" text,
    "uid" bigint NOT NULL,
    "time" text,
    "level" bigint DEFAULT '1'
) WITH (oids = false);

INSERT INTO "chat_global" ("name", "message", "sorter", "date", "avatar", "uid", "time", "level") VALUES
('4rgb9auak',	'hii',	1703710515765,	'2023-12-27 21:55:15.766363+01',	'http://localhost:3005/uploads/avatar.png',	7811556851,	'20:55',	1),
('4rgb9auak',	'https://media2.giphy.com/media/H2u46cKU3VaXht6Iv9/giphy-downsized.gif?cid=845d262d6ogvvhyd22b2zz30t00pmbkvy42iry5rg4jrzpnw&rid=giphy-downsized.gif&ct=g',	1703710565320,	'2023-12-27 21:56:05.321351+01',	'http://localhost:3005/uploads/avatar.png',	7811556851,	'20:56',	1);

DROP SEQUENCE IF EXISTS club_banner_notification_status_id_seq;
CREATE SEQUENCE club_banner_notification_status_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_banner_notification_status" (
    "id" bigint DEFAULT nextval('club_banner_notification_status_id_seq') NOT NULL,
    "notification_id" bigint NOT NULL,
    "user_id" bigint NOT NULL,
    "is_sent" boolean DEFAULT false,
    "is_read" boolean DEFAULT false,
    "sent_at" timestamptz,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "club_banner_notification_status_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_banner_notification_status_notification_id_fkey" FOREIGN KEY (notification_id) REFERENCES club_banner_notifications(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_banner_notifications_id_seq;
CREATE SEQUENCE club_banner_notifications_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_banner_notifications" (
    "id" bigint DEFAULT nextval('club_banner_notifications_id_seq') NOT NULL,
    "banner_id" bigint NOT NULL,
    "club_id" bigint NOT NULL,
    "sender_id" bigint NOT NULL,
    "title" character varying(255) NOT NULL,
    "body" text NOT NULL,
    "type" character varying(50) DEFAULT 'banner_promotion',
    "additional_data" jsonb,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "club_banner_notifications_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_banner_notifications_banner_id_fkey" FOREIGN KEY (banner_id) REFERENCES club_banners(id) NOT DEFERRABLE,
    CONSTRAINT "club_banner_notifications_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_banners_id_seq;
CREATE SEQUENCE club_banners_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_banners" (
    "id" bigint DEFAULT nextval('club_banners_id_seq') NOT NULL,
    "club_id" bigint NOT NULL,
    "title" character varying(255) NOT NULL,
    "image_path" text NOT NULL,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "is_active" boolean DEFAULT true,
    CONSTRAINT "club_banners_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_banners_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_earnings_configurations_id_seq;
CREATE SEQUENCE club_earnings_configurations_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_earnings_configurations" (
    "id" bigint DEFAULT nextval('club_earnings_configurations_id_seq') NOT NULL,
    "club_id" bigint NOT NULL,
    "configuration_type" character varying(50) NOT NULL,
    "owner_percentage" numeric(5,2) DEFAULT '10.0',
    "agent_percentage" numeric(5,2) DEFAULT '20.0',
    "member_percentage" numeric(5,2) DEFAULT '5.0',
    "active_player_threshold" integer DEFAULT '5',
    "wager_threshold" numeric(10,2) DEFAULT '200.0',
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "club_earnings_configurations_pkey" PRIMARY KEY ("id")
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_earnings_log_id_seq;
CREATE SEQUENCE club_earnings_log_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_earnings_log" (
    "id" bigint DEFAULT nextval('club_earnings_log_id_seq') NOT NULL,
    "club_id" bigint NOT NULL,
    "distribution_date" date NOT NULL,
    "total_club_earnings" numeric(15,2) NOT NULL,
    "owner_earnings" numeric(15,2) NOT NULL,
    "agent_earnings" numeric(15,2) NOT NULL,
    "active_player_count" integer NOT NULL,
    CONSTRAINT "club_earnings_log_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_earnings_log_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_memberships_id_seq;
CREATE SEQUENCE club_memberships_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_memberships" (
    "id" bigint DEFAULT nextval('club_memberships_id_seq') NOT NULL,
    "user_id" bigint NOT NULL,
    "club_id" bigint NOT NULL,
    "role" character varying(50) NOT NULL,
    "agent_id" bigint,
    "unique_agent_code" character varying(50),
    "joined_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "last_active_at" timestamptz,
    "player_rake_percentage" numeric(5,2) DEFAULT '10.0',
    "total_wager" numeric(15,2) DEFAULT '0',
    "parent_club_id" bigint,
    CONSTRAINT "club_memberships_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_memberships_user_id_club_id_key" UNIQUE ("user_id", "club_id"),
    CONSTRAINT "club_memberships_agent_id_fkey" FOREIGN KEY (agent_id) REFERENCES users(id) NOT DEFERRABLE,
    CONSTRAINT "club_memberships_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE,
    CONSTRAINT "club_memberships_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_notification_status_id_seq;
CREATE SEQUENCE club_notification_status_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_notification_status" (
    "id" bigint DEFAULT nextval('club_notification_status_id_seq') NOT NULL,
    "notification_id" bigint NOT NULL,
    "user_id" bigint NOT NULL,
    "is_sent" boolean DEFAULT false,
    "is_read" boolean DEFAULT false,
    "sent_at" timestamptz,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "club_notification_status_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_notification_status_notification_id_fkey" FOREIGN KEY (notification_id) REFERENCES club_notifications(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS club_notifications_id_seq;
CREATE SEQUENCE club_notifications_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."club_notifications" (
    "id" bigint DEFAULT nextval('club_notifications_id_seq') NOT NULL,
    "club_id" bigint NOT NULL,
    "sender_id" bigint NOT NULL,
    "title" character varying(255) NOT NULL,
    "body" text NOT NULL,
    "type" character varying(50) DEFAULT 'club',
    "additional_data" jsonb,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "club_notifications_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "club_notifications_club_id_fkey" FOREIGN KEY (club_id) REFERENCES clubs(id) NOT DEFERRABLE
) WITH (oids = false);


DROP SEQUENCE IF EXISTS clubs_id_seq;
CREATE SEQUENCE clubs_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."clubs" (
    "id" bigint DEFAULT nextval('clubs_id_seq') NOT NULL,
    "name" character varying(255) NOT NULL,
    "unique_club_id" character varying(50) NOT NULL,
    "owner_id" bigint NOT NULL,
    "profile_picture" text,
    "created_at" timestamptz DEFAULT CURRENT_TIMESTAMP,
    "is_active" boolean DEFAULT true,
    "owner_earnings_percentage" numeric(5,2) DEFAULT '10.0',
    "agent_earnings_percentage" numeric(5,2) DEFAULT '20.0',
    "min_active_players_threshold" integer DEFAULT '5',
    "active_player_wager_threshold" numeric(10,2) DEFAULT '200.0',
    "member_earnings_percentage" numeric(5,2) DEFAULT '5.0',
    "parent_club_id" bigint,
    "clubrake" numeric DEFAULT '10',
    CONSTRAINT "clubs_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "clubs_unique_club_id_key" UNIQUE ("unique_club_id"),
    CONSTRAINT "clubs_owner_id_fkey" FOREIGN KEY (owner_id) REFERENCES users(id) NOT DEFERRABLE
) WITH (oids = false);


CREATE TABLE "public"."crashs" (
    "gid" text NOT NULL,
    "busted" numeric,
    "hash" text NOT NULL,
    "date" timestamptz DEFAULT now(),
    "numbers" json
) WITH (oids = false);


CREATE TABLE "public"."credits" (
    "uid" bigint NOT NULL,
    "btc" numeric DEFAULT '0',
    "eth" numeric DEFAULT '0',
    "ltc" numeric DEFAULT '0',
    "bch" numeric DEFAULT '0',
    "usdt" numeric DEFAULT '0',
    "trx" numeric DEFAULT '0',
    "doge" numeric DEFAULT '0',
    "ada" numeric DEFAULT '0',
    "xrp" numeric DEFAULT '0',
    "bnb" numeric DEFAULT '0',
    "usdp" numeric DEFAULT '0',
    "nexo" numeric DEFAULT '0',
    "mkr" numeric DEFAULT '0',
    "tusd" numeric DEFAULT '0',
    "usdc" numeric DEFAULT '0',
    "busd" numeric DEFAULT '0',
    "nc" numeric DEFAULT '0',
    "inr" numeric DEFAULT '0',
    "shib" numeric DEFAULT '0',
    "matic" numeric DEFAULT '0',
    "sc" numeric DEFAULT '0',
    "mvr" numeric DEFAULT '0',
    "bjb" numeric DEFAULT '0',
    "aed" numeric DEFAULT '0',
    "npr" numeric DEFAULT '0',
    "pkr" numeric DEFAULT '0',
    "eur" numeric(18,4) DEFAULT '0',
    CONSTRAINT "credits_uid_unique" UNIQUE ("uid")
) WITH (oids = false);

INSERT INTO "credits" ("uid", "btc", "eth", "ltc", "bch", "usdt", "trx", "doge", "ada", "xrp", "bnb", "usdp", "nexo", "mkr", "tusd", "usdc", "busd", "nc", "inr", "shib", "matic", "sc", "mvr", "bjb", "aed", "npr", "pkr", "eur") VALUES
(1388785165,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.00840429,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(5664694811,	0,	0,	0,	0,	24.93,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1000,	84720.0999998,	0,	0,	0,	0,	0,	0,	0,	100,	0.0000),
(5283519942,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(9385154743,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(2579393191,	0.07419206795557521,	0,	0,	0,	1614.91,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	79584.03949502,	0,	0,	0,	0,	539.878251697889604,	0,	0,	0,	0.0000),
(9595339986,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(9294139522,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(2626926939,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(3194948292,	0.00000000,	0,	0,	0,	107.10636013,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(5156441594,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000),
(5234034987,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	599.8,	0,	0,	0,	0,	0,	0,	0,	0,	25938.5740),
(2386483727,	0.00000000,	0,	0,	0,	109.99,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	8204.6250000000000007,	0,	0,	0,	0,	0.004,	0,	0,	0,	336.3300),
(7275244327,	0.00000000,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0.0000);

DROP SEQUENCE IF EXISTS credits_ledger_id_seq;
CREATE SEQUENCE credits_ledger_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."credits_ledger" (
    "id" bigint DEFAULT nextval('credits_ledger_id_seq') NOT NULL,
    "user_id" text NOT NULL,
    "currency" text DEFAULT 'INR',
    "amount" numeric NOT NULL,
    "reason" text NOT NULL,
    "description" text,
    "eventid" text,
    "job_id" uuid,
    "match_id" text,
    "meta" jsonb,
    "created_at" timestamptz DEFAULT now(),
    "market_type" text,
    CONSTRAINT "credits_ledger_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "idx_credits_ledger_created_at" ON "public"."credits_ledger" USING btree ("created_at");

CREATE INDEX "idx_credits_ledger_eventid" ON "public"."credits_ledger" USING btree ("eventid");

CREATE INDEX "idx_credits_ledger_user_id" ON "public"."credits_ledger" USING btree ("user_id");


DROP SEQUENCE IF EXISTS cricpaytransactions_id_seq;
CREATE SEQUENCE cricpaytransactions_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."cricpaytransactions" (
    "id" bigint DEFAULT nextval('cricpaytransactions_id_seq') NOT NULL,
    "uid" bigint NOT NULL,
    "transaction_code" character varying(50) NOT NULL,
    "amount" numeric NOT NULL,
    "payment_method" character varying(50) NOT NULL,
    "status" character varying(20) NOT NULL,
    "fee" numeric DEFAULT '0',
    "remark" text,
    "created_at" timestamp NOT NULL,
    "updated_at" timestamp,
    CONSTRAINT "cricpaytransactions_pkey" PRIMARY KEY ("id"),
    CONSTRAINT "cricpaytransactions_transaction_code_key" UNIQUE ("transaction_code"),
    CONSTRAINT "cricpaytransactions_uid_fkey" FOREIGN KEY (uid) REFERENCES credits(uid) NOT DEFERRABLE
) WITH (oids = false);

INSERT INTO "cricpaytransactions" ("id", "uid", "transaction_code", "amount", "payment_method", "status", "fee", "remark", "created_at", "updated_at") VALUES
(65,	2579393191,	'DW-1750324340464-3307',	3000,	'PS002',	'Failed',	0,	NULL,	'2025-06-19 09:12:20.465097',	NULL),
(86,	2579393191,	'DW-1753926999994-9696',	3000,	'PS002',	'Failed',	0,	NULL,	'2025-07-31 01:56:39.99468',	NULL),
(87,	2579393191,	'DW-1753927017107-3288',	3000,	'PS003',	'Failed',	0,	NULL,	'2025-07-31 01:56:57.107398',	NULL),
(88,	3194948292,	'DW-1759904025065-5524',	1000,	'PS003',	'Failed',	0,	NULL,	'2025-10-08 06:13:45.065692',	NULL),
(74,	9294139522,	'DW-1751130580429-9907',	2000,	'PS002',	'Failed',	0,	NULL,	'2025-06-28 17:09:40.429337',	NULL),
(75,	1388785165,	'DW-1751566991977-4316',	200000,	'PS002',	'Failed',	0,	NULL,	'2025-07-03 18:23:11.97768',	NULL),
(89,	3194948292,	'DW-1759904243824-8996',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-10-08 06:17:23.824673',	NULL),
(18,	5664694811,	'DW-1747303327597-8594',	1000,	'UPI',	'Failed',	0,	NULL,	'2025-05-15 10:02:07.599368',	NULL),
(19,	5664694811,	'DW-1747304797257-7725',	1000,	'PS002',	'Successful',	59.5,	'',	'2025-05-15 10:26:37.258166',	'2025-05-15 10:42:08.895561'),
(20,	5664694811,	'DW-1747304923916-9025',	1000,	'PS002',	'Failed',	0,	'Test',	'2025-05-15 10:28:43.916856',	'2025-05-15 10:42:26.475721'),
(21,	5664694811,	'DW-1747304948772-7249',	3000,	'PS002',	'Successful',	178.5,	'',	'2025-05-15 10:29:08.772985',	'2025-05-15 10:43:08.961014'),
(90,	3194948292,	'DW-1759904262390-4597',	1000,	'PS003',	'Failed',	0,	NULL,	'2025-10-08 06:17:42.390408',	NULL),
(22,	5664694811,	'DW-1747307276413-7753',	1000,	'PS002',	'Successful',	59.5,	'',	'2025-05-15 11:07:56.413782',	'2025-05-15 11:12:13.350658'),
(25,	5664694811,	'DW-1747477038629-1707',	1000,	'PS002',	'Pending',	0,	NULL,	'2025-05-17 10:17:18.629876',	NULL),
(26,	5664694811,	'DW-1747477526763-6488',	1000,	'PS003',	'Failed',	0,	NULL,	'2025-05-17 10:25:26.763882',	NULL),
(27,	5664694811,	'DW-1747477547774-4316',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-05-17 10:25:47.77457',	NULL),
(28,	5664694811,	'DW-1747477737180-7198',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-05-17 10:28:57.181161',	NULL),
(29,	5664694811,	'DW-1747477744337-6396',	1000,	'PS002',	'Pending',	0,	NULL,	'2025-05-17 10:29:04.338203',	NULL),
(30,	5664694811,	'DW-1747477841952-8103',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-05-17 10:30:41.952532',	NULL),
(31,	5664694811,	'DW-1747478556869-9434',	1000,	'PS003',	'Pending',	0,	NULL,	'2025-05-17 10:42:36.869464',	NULL),
(32,	5664694811,	'DW-1747481417374-3829',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-05-17 11:30:17.374955',	NULL),
(33,	5664694811,	'DW-1747481678730-5081',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-05-17 11:34:38.731206',	NULL),
(34,	5664694811,	'DW-1747507616627-232',	1000,	'PS002',	'Pending',	0,	NULL,	'2025-05-17 18:46:56.627483',	NULL),
(35,	5664694811,	'DW-1747507648522-9454',	1000,	'PS003',	'Failed',	0,	NULL,	'2025-05-17 18:47:28.523223',	NULL),
(36,	5664694811,	'DW-1747507721159-7187',	1000,	'PS003',	'Pending',	0,	NULL,	'2025-05-17 18:48:41.159283',	NULL),
(37,	5664694811,	'DW-1747507745381-2574',	1000,	'PS002',	'Pending',	0,	NULL,	'2025-05-17 18:49:05.381852',	NULL),
(80,	9595339986,	'DW-1751999893847-7934',	100000,	'PS002',	'Failed',	0,	NULL,	'2025-07-08 18:38:13.84772',	NULL),
(41,	5664694811,	'DW-1747529373096-1429',	1000,	'PS003',	'Pending',	0,	NULL,	'2025-05-18 00:49:33.096429',	NULL),
(42,	5664694811,	'DW-1747529434172-5445',	1000,	'PS002',	'Pending',	0,	NULL,	'2025-05-18 00:50:34.173112',	NULL),
(44,	5664694811,	'DW-1747636845594-4531',	1000,	'PS003',	'Pending',	0,	NULL,	'2025-05-19 06:40:45.595391',	NULL),
(45,	5283519942,	'DW-1747678752185-8374',	1000,	'PS003',	'Pending',	0,	NULL,	'2025-05-19 18:19:12.186208',	NULL),
(82,	2626926939,	'DW-1752638227151-9268',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-07-16 03:57:07.152307',	NULL),
(61,	2579393191,	'DW-1750245868299-7413',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-06-18 11:24:28.299698',	NULL),
(62,	2579393191,	'DW-1750245879370-3223',	1000,	'PS002',	'Failed',	0,	NULL,	'2025-06-18 11:24:39.370629',	NULL),
(63,	2579393191,	'DW-1750245895459-2177',	2000,	'PS002',	'Failed',	0,	NULL,	'2025-06-18 11:24:55.459595',	NULL),
(64,	2579393191,	'DW-1750245904595-2930',	1000,	'PS003',	'Failed',	0,	NULL,	'2025-06-18 11:25:04.595417',	NULL);

CREATE TABLE "public"."cronbonus" (
    "userid" bigint NOT NULL,
    "viplevel" integer NOT NULL,
    "dailybonus" integer NOT NULL,
    "weeklybonus" integer NOT NULL,
    "monthlybonus" integer NOT NULL,
    "dailydate" timestamp NOT NULL,
    "weeklydate" timestamp NOT NULL,
    "monthlydate" timestamp NOT NULL,
    "dailyclaim" boolean NOT NULL,
    "weeklyclaim" boolean NOT NULL,
    "monthlyclaim" boolean NOT NULL,
    "status" boolean NOT NULL
) WITH (oids = false);


DROP SEQUENCE IF EXISTS currency_payment_details_id_seq;
CREATE SEQUENCE currency_payment_details_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;

CREATE TABLE "public"."currency_payment_details" (
    "id" integer DEFAULT nextval('currency_payment_details_id_seq') NOT NULL,
    "coin_type" character varying(10) NOT NULL,
    "bank_name" character varying(255),
    "account_number" character varying(100),
    "ifsc_code" character varying(20),
    "account_holder_name" character varying(255),
    "qr_image" bytea,
    "upi_id" character varying(100),
    "created_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "updated_at" timestamp DEFAULT CURRENT_TIMESTAMP,
    "is_active" boolean DEFAULT true,
    CONSTRAINT "currency_payment_details_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

CREATE INDEX "idx_currency_payment_details_coin_type" ON "public"."currency_payment_details" USING btree ("coin_type");

INSERT INTO "currency_payment_details" ("id", "coin_type", "bank_name", "account_number", "ifsc_code", "account_holder_name", "qr_image", "upi_id", "created_at", "updated_at", "is_active") VALUES
(5,	'MVR',	'MIB',	'77300000000',	NULL,	'Skyla',	NULL,	NULL,	'2025-03-01 23:32:51.598109',	'2025-03-01 23:32:51.598109',	'f');
INSERT INTO "currency_payment_details" ("id", "coin_type", "bank_name", "account_number", "ifsc_code", "account_holder_name", "qr_image", "upi_id", "created_at", "updated_at", "is_active") VALUES
(4,	'MVR',	'test',	'12132321',	'UGD2B3',	'TESTETST',	'\x[encoded data, 468436 characters]