-- INFINITY API HUB database export
-- Generated: 2026-09-21T23:58:20+00:00
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
DROP TABLE IF EXISTS "api_logs";
CREATE TABLE "api_logs" ("id" integer primary key autoincrement not null, "user_id" integer, "key_id" integer, "service_id" integer, "param_summary" varchar not null default '', "ip" varchar not null default '', "status" varchar check ("status" in ('success', 'error')) not null default 'success', "response_code" integer not null default '0', "latency_ms" integer not null default '0', "credits_used" integer not null default '0', "response_snippet" text, "source" varchar check ("source" in ('api', 'panel')) not null default 'api', "created_at" datetime not null default CURRENT_TIMESTAMP, foreign key("user_id") references "users"("id") on delete cascade, foreign key("key_id") references "service_keys"("id") on delete cascade, foreign key("service_id") references "api_services"("id") on delete set null);
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('1', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'success', '200', '3995', '1', '{"uid":"1704140050","name":"^_^Masud^_^","username":"^_^Masud^_^","update_version":"OB55","value":"5,541 TK","market_value":"5,541 TK","level":58,"likes":"2,844","exp":727709,"prime_level":"Prime 1","region":"BD","profile_picture":"https://market-value-api.ffxapis.workers.dev/api/image/1704140050.webp","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:13');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('2', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1351', '0', '{"error":true,"msg":"cooldown","retry_after":4,"message":"Please wait 4 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:24');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('3', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'success', '200', '1955', '1', '{"uid":"1704140050","name":"^_^Masud^_^","username":"^_^Masud^_^","update_version":"OB55","value":"5,541 TK","market_value":"5,541 TK","level":58,"likes":"2,844","exp":727709,"prime_level":"Prime 1","region":"BD","profile_picture":"https://market-value-api.ffxapis.workers.dev/api/image/1704140050.webp","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:25');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('4', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1042', '0', '{"error":true,"msg":"cooldown","retry_after":3,"message":"Please wait 3 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:25');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('5', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'success', '200', '3214', '1', '{"uid":"1704140050","name":"^_^Masud^_^","username":"^_^Masud^_^","update_version":"OB55","value":"5,541 TK","market_value":"5,541 TK","level":58,"likes":"2,844","exp":727709,"prime_level":"Prime 1","region":"BD","profile_picture":"https://market-value-api.ffxapis.workers.dev/api/image/1704140050.webp","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:25');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('6', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1037', '0', '{"error":true,"msg":"cooldown","retry_after":2,"message":"Please wait 2 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:26');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('7', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'success', '200', '4326', '1', '{"uid":"1704140050","name":"^_^Masud^_^","username":"^_^Masud^_^","update_version":"OB55","value":"5,541 TK","market_value":"5,541 TK","level":58,"likes":"2,844","exp":727709,"prime_level":"Prime 1","region":"BD","profile_picture":"https://market-value-api.ffxapis.workers.dev/api/image/1704140050.webp","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:26');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('8', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'success', '200', '4393', '1', '{"uid":"1704140050","name":"^_^Masud^_^","username":"^_^Masud^_^","update_version":"OB55","value":"5,541 TK","market_value":"5,541 TK","level":58,"likes":"2,844","exp":727709,"prime_level":"Prime 1","region":"BD","profile_picture":"https://market-value-api.ffxapis.workers.dev/api/image/1704140050.webp","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:27');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('9', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1469', '0', '{"error":true,"msg":"cooldown","retry_after":1,"message":"Please wait 1 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:27');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('10', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1390', '0', '{"error":true,"msg":"cooldown","retry_after":1,"message":"Please wait 1 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:27');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('11', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1298', '0', '{"error":true,"msg":"cooldown","retry_after":3,"message":"Please wait 3 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:28');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('12', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '502', '2372', '0', '{"error":true,"status":502,"msg":"provider_http_error","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:29');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('13', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '502', '2277', '0', '{"error":true,"status":502,"msg":"provider_http_error","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:29');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('14', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '502', '4390', '0', '{"error":true,"status":502,"msg":"provider_http_error","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:29');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('15', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1384', '0', '{"error":true,"msg":"cooldown","retry_after":2,"message":"Please wait 2 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:31');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('16', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '502', '5056', '0', '{"error":true,"status":502,"msg":"provider_http_error","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:31');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('17', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '502', '1940', '0', '{"error":true,"status":502,"msg":"provider_http_error","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:33');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('18', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '429', '1258', '0', '{"error":true,"msg":"cooldown","retry_after":2,"message":"Please wait 2 seconds before trying again.","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:35');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('19', '2', '5', '5', 'uid=1704140050', '10.58.242.1', 'error', '502', '1399', '0', '{"error":true,"status":502,"msg":"provider_token_unavailable","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:30:40');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('20', '2', '1', '1', 'uid=1704140050', '10.58.242.1', 'success', '200', '2575', '1', '{
    "status": false,
    "message": "Missing UID or API Key"
}', 'panel', '2026-09-21 04:32:43');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('21', '2', '1', '1', 'uid=1704140050', '10.58.242.1', 'success', '200', '2737', '1', '{
    "status": false,
    "message": "Missing UID or API Key"
}', 'panel', '2026-09-21 04:32:54');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('22', '2', '1', '1', 'uid=2769409057', '10.58.242.1', 'success', '200', '3507', '1', '{
    "status": false,
    "message": "Missing UID or API Key"
}', 'panel', '2026-09-21 04:33:08');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('23', '2', '5', '1', 'ff-uid', '10.58.242.1', 'error', '0', '0', '0', 'This key belongs to a different API.', 'api', '2026-09-21 04:38:30');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('24', '2', '4', '4', 'uid=1704140050', '10.58.242.1', 'success', '200', '5658', '1', '{"error":false,"status":200,"msg":"id_found","version":"V7X","data":{"identity":{"record_id":56,"uid":"1704140050","username":"^_^Masud^_^","region":"BD"},"profile":{"level":58,"likes":"2844","prime_level":1,"bio":"I LOVE FREE FIRE MAX!!.","created_at":"2019-12-30T11:53:04.000Z","account_age":{"years":6,"months":8,"label":"6 years and 8 months"},"last_login":"2026-09-16T12:53:51.000Z","last_updated":"2026-09-17T01:56:36.000Z","banner_image":"/api/banner/banner_1704140050.webp"},"account_info":{"', 'panel', '2026-09-21 04:43:21');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('25', '2', '1', '1', 'uid=2769409057', '10.58.242.1', 'success', '200', '2366', '1', '{
    "status": false,
    "message": "Missing UID or API Key"
}', 'panel', '2026-09-21 04:48:25');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('26', '2', '3', '3', 'uid=1704140050', '10.58.242.1', 'success', '200', '1996', '1', '<html><body><script type="text/javascript" src="/aes.js" ></script><script>function toNumbers(d){var e=[];d.replace(/(..)/g,function(d){e.push(parseInt(d,16))});return e}function toHex(){for(var d=[],d=1==arguments.length&&arguments[0].constructor==Array?arguments[0]:arguments,e="",f=0;f<d.length;f++)e+=(16>d[f]?"0":"")+d[f].toString(16);return e.toLowerCase()}var a=toNumbers("f655ba9d09a112d4968c63579db590b4"),b=toNumbers("98344c2eee86c3994890592585b49f80"),c=toNumbers("1c77ea15631bf2822a3a05d8', 'panel', '2026-09-21 04:49:27');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('27', '2', '5', '5', 'uid=2769409057', '10.58.242.1', 'success', '200', '3797', '1', '{"uid":"2769409057","name":"④ʜᴇxᴀ ᴄᴏᴅᴇ⌯⌲","username":"④ʜᴇxᴀ ᴄᴏᴅᴇ⌯⌲","update_version":"OB54","value":"5,094 TK","market_value":"5,094 TK","level":60,"likes":"3,811","exp":1017225,"prime_level":"Prime 1","region":"BD","profile_picture":"https://market-value-api.ffxapis.workers.dev/api/image/2769409057.webp","creator":{"Create":"TG: @zerox6t9","Channel":"Infinity_codex"}}', 'panel', '2026-09-21 04:49:49');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('28', '9', '36', '1', 'uid=1704140050', '10.1.118.1', 'success', '200', '2581', '1', '{
    "status": false,
    "message": "Missing UID or API Key"
}', 'panel', '2026-09-21 10:12:09');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('29', '9', '38', '3', 'uid=2769409057', '10.129.31.1', 'error', '0', '0', '0', '', 'panel', '2026-09-21 15:49:35');
INSERT INTO "api_logs" ("id", "user_id", "key_id", "service_id", "param_summary", "ip", "status", "response_code", "latency_ms", "credits_used", "response_snippet", "source", "created_at") VALUES ('30', '9', '39', '4', 'uid=2769409057', '10.129.31.1', 'success', '200', '7923', '1', '{"error":false,"status":200,"msg":"id_found","version":"V7X","data":{"identity":{"record_id":912,"uid":"2769409057","username":"④ʜᴇxᴀ ᴄᴏᴅᴇ⌯⌲","region":"BD"},"profile":{"level":60,"likes":"3811","prime_level":1,"bio":"কেমন দিলাম।","created_at":"2021-01-28T01:56:54.000Z","account_age":{"years":5,"months":7,"label":"5 years and 7 months"},"last_login":"2026-09-12T03:16:05.000Z","last_updated":"2026-09-16T17:07:26.000Z","banner_image":null},"account_info":{"exp":1017225,"season_id":53,"credit_score"', 'panel', '2026-09-21 15:49:54');
DROP TABLE IF EXISTS "api_services";
CREATE TABLE "api_services" ("id" integer primary key autoincrement not null, "name" varchar not null, "slug" varchar not null, "description" varchar not null default '', "icon" varchar not null default 'fa-plug', "provider_url" text not null, "method" varchar check ("method" in ('GET', 'POST')) not null default 'GET', "headers" text, "provider_key" varchar not null default '', "params" text, "credits_per_hit" integer not null default '1', "free_quota" integer not null default '25', "status" varchar check ("status" in ('active', 'inactive')) not null default 'active', "show_on_home" tinyint(1) not null default '1', "sort_order" integer not null default '0', "docs_text" text, "sample_response" text, "created_at" datetime, "updated_at" datetime, "docs_markdown" text, "docs_error_codes" text, "docs_rate_limit" varchar not null default '', "docs_example_params" text, "credit_price" numeric not null default '1');
INSERT INTO "api_services" ("id", "name", "slug", "description", "icon", "provider_url", "method", "headers", "provider_key", "params", "credits_per_hit", "free_quota", "status", "show_on_home", "sort_order", "docs_text", "sample_response", "created_at", "updated_at", "docs_markdown", "docs_error_codes", "docs_rate_limit", "docs_example_params", "credit_price") VALUES ('1', 'Free Fire UID Check', 'ff-uid', 'Get Free Fire player nickname from UID instantly.', 'fa-gamepad', 'https://nanobd.shop/ffnamecheck/api.php?uid={uid}&key={provider_key}&type=rs', 'GET', '[]', '', '[{"name":"uid","label":"Player UID","required":1,"placeholder":"2535040417"}]', '1', '25', 'active', '1', '1', 'Enter the player UID to get the current nickname. Works for all regions.', '{"status": true, "data": {"username": "Player Name Here"}}', '2026-09-21 04:00:55', '2026-09-21 04:00:55', NULL, NULL, '', NULL, '1');
INSERT INTO "api_services" ("id", "name", "slug", "description", "icon", "provider_url", "method", "headers", "provider_key", "params", "credits_per_hit", "free_quota", "status", "show_on_home", "sort_order", "docs_text", "sample_response", "created_at", "updated_at", "docs_markdown", "docs_error_codes", "docs_rate_limit", "docs_example_params", "credit_price") VALUES ('2', 'IP Information', 'ip-info', 'Get country, city and ISP info of any IP address.', 'fa-location-dot', 'http://ip-api.com/json/{ip}?fields=status,country,city,isp,query', 'GET', '[]', '', '[{"name":"ip","label":"IP Address","required":1,"placeholder":"8.8.8.8"}]', '1', '25', 'active', '1', '2', 'Pass any public IPv4 address to get geolocation details. No provider key needed.', '{"status": "success", "country": "United States", "city": "Ashburn", "isp": "Google LLC", "query": "8.8.8.8"}', '2026-09-21 04:00:55', '2026-09-21 04:00:55', NULL, NULL, '', NULL, '1');
INSERT INTO "api_services" ("id", "name", "slug", "description", "icon", "provider_url", "method", "headers", "provider_key", "params", "credits_per_hit", "free_quota", "status", "show_on_home", "sort_order", "docs_text", "sample_response", "created_at", "updated_at", "docs_markdown", "docs_error_codes", "docs_rate_limit", "docs_example_params", "credit_price") VALUES ('3', 'FF UID Lookup', 'ff-uid-lookup', 'Look up a Free Fire player profile by UID.', 'fa-gamepad', 'http://ixbd.qd.je/ff.php?uid={uid}', 'GET', '[]', '', '[{"name":"uid","label":"Player UID","required":1,"placeholder":"2769409057"}]', '1', '25', 'active', '1', '3', 'Send a Free Fire UID to receive the provider response. Use a valid UID for the selected region.', '{"uid":"2769409057","name":"Player Name"}', '2026-09-21 04:26:37', '2026-09-21 04:26:37', NULL, NULL, '', NULL, '1');
INSERT INTO "api_services" ("id", "name", "slug", "description", "icon", "provider_url", "method", "headers", "provider_key", "params", "credits_per_hit", "free_quota", "status", "show_on_home", "sort_order", "docs_text", "sample_response", "created_at", "updated_at", "docs_markdown", "docs_error_codes", "docs_rate_limit", "docs_example_params", "credit_price") VALUES ('4', 'FF Player Info', 'ff-player-info', 'Get detailed Free Fire profile, rank and account information.', 'fa-id-card', 'https://ffxinfo-ffx.ffxapis.workers.dev/ffinfo?uid={uid}', 'GET', '[]', '', '[{"name":"uid","label":"Player UID","required":1,"placeholder":"2769409057"}]', '1', '25', 'active', '1', '4', 'Send a Free Fire UID to receive the provider response. Use a valid UID for the selected region.', '{"error":false,"status":200,"data":{"identity":{"uid":"2769409057"}}}', '2026-09-21 04:26:37', '2026-09-21 04:26:37', NULL, NULL, '', NULL, '1');
INSERT INTO "api_services" ("id", "name", "slug", "description", "icon", "provider_url", "method", "headers", "provider_key", "params", "credits_per_hit", "free_quota", "status", "show_on_home", "sort_order", "docs_text", "sample_response", "created_at", "updated_at", "docs_markdown", "docs_error_codes", "docs_rate_limit", "docs_example_params", "credit_price") VALUES ('5', 'FF Market Value', 'ff-market-value', 'Estimate a Free Fire account market value by UID.', 'fa-chart-line', 'https://market-value-api.ffxapis.workers.dev/market-value?uid={uid}', 'GET', '[]', '', '[{"name":"uid","label":"Player UID","required":1,"placeholder":"2769409057"}]', '1', '25', 'active', '1', '5', 'Send a Free Fire UID to receive the provider response. Use a valid UID for the selected region.', '{"uid":"1704140050","name":"Player Name","market_value":"5,541 TK"}', '2026-09-21 04:26:37', '2026-09-21 04:26:37', NULL, NULL, '', NULL, '1');
DROP TABLE IF EXISTS "invoices";
CREATE TABLE "invoices" ("id" integer primary key autoincrement not null, "order_id" integer not null, "user_id" integer not null, "invoice_number" varchar not null, "pdf_path" varchar not null default '', "emailed_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("order_id") references "orders"("id") on delete cascade, foreign key("user_id") references "users"("id") on delete cascade);
DROP TABLE IF EXISTS "migrations";
CREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null);
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('1', '2026_01_01_000001_create_users_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('2', '2026_01_01_000002_create_api_services_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('3', '2026_01_01_000003_create_service_keys_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('4', '2026_01_01_000004_create_packages_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('5', '2026_01_01_000005_create_orders_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('6', '2026_01_01_000006_create_api_logs_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('7', '2026_01_01_000007_create_notifications_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('8', '2026_01_01_000008_create_settings_table', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('9', '2026_01_01_000009_create_tickets_tables', '1');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('10', '2026_09_21_110000_add_google_id_to_users', '2');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('11', '2026_09_22_000001_add_nagorikpay_hardening', '3');
INSERT INTO "migrations" ("id", "migration", "batch") VALUES ('12', '2026_09_22_000002_create_wallets_and_credit_fields', '4');
DROP TABLE IF EXISTS "nagorikpay_logs";
CREATE TABLE "nagorikpay_logs" ("id" integer primary key autoincrement not null, "type" varchar not null default 'create', "url" varchar not null default '', "order_id" integer, "transaction_id" varchar not null default '', "http_status" integer not null default '0', "api_key_masked" varchar not null default '', "request_payload" text, "response_payload" text, "ip" varchar not null default '', "created_at" datetime, "updated_at" datetime, foreign key("order_id") references "orders"("id") on delete set null);
DROP TABLE IF EXISTS "notifications";
CREATE TABLE "notifications" ("id" integer primary key autoincrement not null, "title" varchar not null, "message" text not null, "type" varchar check ("type" in ('info', 'success', 'warning', 'error')) not null default 'info', "target" varchar check ("target" in ('all', 'users')) not null default 'all', "status" varchar check ("status" in ('active', 'inactive')) not null default 'active', "created_at" datetime, "updated_at" datetime);
INSERT INTO "notifications" ("id", "title", "message", "type", "target", "status", "created_at", "updated_at") VALUES ('1', 'Welcome to INFINITY API HUB!', 'Create a free account and instantly get an API key for every service with bonus credits. Open any API page to start.', 'success', 'all', 'active', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
DROP TABLE IF EXISTS "orders";
CREATE TABLE "orders" ("id" integer primary key autoincrement not null, "user_id" integer not null, "service_id" integer, "package_id" integer, "key_id" integer, "amount" numeric not null default '0', "payment_method" varchar not null default '', "sender_number" varchar not null default '', "txn_id" varchar not null default '', "status" varchar check ("status" in ('pending', 'approved', 'rejected')) not null default 'pending', "admin_note" varchar not null default '', "created_at" datetime, "updated_at" datetime, "reviewed_at" datetime, "expires_at" datetime, "nagorikpay_txn" varchar not null default '', "attempts" integer not null default '0', "order_kind" varchar not null default 'credit_purchase', "credit_quantity" integer not null default '0', "unit_price" numeric not null default '0', "wallet_amount" numeric not null default '0', foreign key("user_id") references "users"("id") on delete cascade, foreign key("service_id") references "api_services"("id") on delete set null, foreign key("package_id") references "packages"("id") on delete set null, foreign key("key_id") references "service_keys"("id") on delete set null);
INSERT INTO "orders" ("id", "user_id", "service_id", "package_id", "key_id", "amount", "payment_method", "sender_number", "txn_id", "status", "admin_note", "created_at", "updated_at", "reviewed_at", "expires_at", "nagorikpay_txn", "attempts", "order_kind", "credit_quantity", "unit_price", "wallet_amount") VALUES ('1', '9', '4', '14', '39', '100', 'bKash', '019650650308', 'TRXHHSHS', 'rejected', 'Payment not verified', '2026-09-21 11:59:04', '2026-09-21 23:57:25', '2026-09-21 23:57:25', '2026-09-21 12:29:04', '', '0', 'credit_purchase', '0', '0', '0');
DROP TABLE IF EXISTS "packages";
CREATE TABLE "packages" ("id" integer primary key autoincrement not null, "service_id" integer not null, "name" varchar not null, "price" numeric not null default '0', "requests" integer not null default '100', "validity_days" integer not null default '30', "features" text, "highlight" tinyint(1) not null default '0', "status" varchar check ("status" in ('active', 'inactive')) not null default 'active', "sort_order" integer not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("service_id") references "api_services"("id") on delete cascade);
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('1', '1', 'Free Starter', '0', '10', '7', 'Instant activation
Community support', '0', 'active', '1', '2026-09-21 04:00:55', '2026-09-21 16:02:28');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('2', '1', 'Basic', '100', '1000', '30', 'Instant activation
Email support', '0', 'active', '2', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('3', '1', 'Pro', '400', '5000', '30', 'Priority speed
Priority support', '1', 'active', '3', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('4', '1', 'Business', '1200', '20000', '60', 'Highest speed
Dedicated support', '0', 'active', '4', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('5', '2', 'Free Starter', '0', '100', '7', 'Instant activation
Community support', '0', 'active', '1', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('6', '2', 'Basic', '100', '1000', '30', 'Instant activation
Email support', '0', 'active', '2', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('7', '2', 'Pro', '400', '5000', '30', 'Priority speed
Priority support', '1', 'active', '3', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('8', '2', 'Business', '1200', '20000', '60', 'Highest speed
Dedicated support', '0', 'active', '4', '2026-09-21 04:00:55', '2026-09-21 04:00:55');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('9', '3', 'Free Starter', '0', '100', '7', 'Instant activation
Community support', '0', 'active', '1', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('10', '3', 'Basic', '100', '1000', '30', 'Instant activation
Email support', '0', 'active', '2', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('11', '3', 'Pro', '400', '5000', '30', 'Priority speed
Priority support', '1', 'active', '3', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('12', '3', 'Business', '1200', '20000', '60', 'Highest speed
Dedicated support', '0', 'active', '4', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('13', '4', 'Free Starter', '0', '100', '7', 'Instant activation
Community support', '0', 'active', '1', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('14', '4', 'Basic', '100', '1000', '30', 'Instant activation
Email support', '0', 'active', '2', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('15', '4', 'Pro', '400', '5000', '30', 'Priority speed
Priority support', '1', 'active', '3', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('16', '4', 'Business', '1200', '20000', '60', 'Highest speed
Dedicated support', '0', 'active', '4', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('17', '5', 'Free Starter', '0', '100', '7', 'Instant activation
Community support', '0', 'active', '1', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('18', '5', 'Basic', '100', '1000', '30', 'Instant activation
Email support', '0', 'active', '2', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('19', '5', 'Pro', '400', '5000', '30', 'Priority speed
Priority support', '1', 'active', '3', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
INSERT INTO "packages" ("id", "service_id", "name", "price", "requests", "validity_days", "features", "highlight", "status", "sort_order", "created_at", "updated_at") VALUES ('20', '5', 'Business', '1200', '20000', '60', 'Highest speed
Dedicated support', '0', 'active', '4', '2026-09-21 10:00:31', '2026-09-21 10:00:31');
DROP TABLE IF EXISTS "service_keys";
CREATE TABLE "service_keys" ("id" integer primary key autoincrement not null, "user_id" integer not null, "service_id" integer not null, "api_key" varchar not null, "label" varchar not null default 'My API Key', "total_request" integer not null default '0', "used_request" integer not null default '0', "exp_date" date, "status" varchar check ("status" in ('active', 'inactive', 'expired')) not null default 'active', "last_used_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("service_id") references "api_services"("id") on delete cascade);
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('1', '2', '1', 'INF-FFUI-94PB-GYS7-BBG6', 'My API Key', '50', '4', '2026-10-21 00:00:00', 'active', '2026-09-21 04:48:25', '2026-09-21 04:23:00', '2026-09-21 04:48:25');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('2', '2', '2', 'INF-IPIN-CPC9-T35Q-X5P8', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 04:23:00', '2026-09-21 04:23:00');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('3', '2', '3', 'INF-FFUI-ZJGW-HGPN-ZVQK', 'My API Key', '25', '1', '2026-10-21 00:00:00', 'active', '2026-09-21 04:49:27', '2026-09-21 04:29:54', '2026-09-21 04:49:27');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('4', '2', '4', 'INF-FFPL-MTEC-TZEU-FFG8', 'My API Key', '25', '1', '2026-10-21 00:00:00', 'active', '2026-09-21 04:43:21', '2026-09-21 04:29:58', '2026-09-21 04:57:19');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('5', '2', '5', 'INF-FFMA-VUBB-NGXP-YYZJ', 'My API Key', '25', '6', '2026-10-21 00:00:00', 'active', '2026-09-21 04:49:49', '2026-09-21 04:29:59', '2026-09-21 04:49:49');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('6', '3', '1', 'INF-FFUI-8227-PXJG-DDEC', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 04:49:49', '2026-09-21 04:49:49');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('7', '3', '2', 'INF-IPIN-B9RF-ZQSR-LZCZ', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 04:49:49', '2026-09-21 04:49:49');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('8', '3', '3', 'INF-FFUI-8QMP-ZC9H-8HSW', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 04:49:49', '2026-09-21 04:49:49');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('9', '3', '4', 'INF-FFPL-F6SH-TRX5-2GP6', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 04:49:49', '2026-09-21 04:49:49');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('10', '3', '5', 'INF-FFMA-2LS7-R9WG-SSY3', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 04:49:49', '2026-09-21 04:49:49');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('36', '9', '1', 'INF-FFUI-SQNX-PFEU-PU66', 'My API Key', '50', '1', '2026-10-21 00:00:00', 'active', '2026-09-21 10:12:09', '2026-09-21 10:10:30', '2026-09-21 10:12:09');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('37', '9', '2', 'INF-IPIN-SBMZ-M82C-L6NK', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 10:10:30', '2026-09-21 10:10:30');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('38', '9', '3', 'INF-FFUI-TFX4-63HB-JAZN', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 10:10:30', '2026-09-21 10:10:30');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('39', '9', '4', 'INF-FFPL-2JCA-6WSZ-PAB7', 'My API Key', '50', '1', '2026-10-21 00:00:00', 'active', '2026-09-21 15:49:54', '2026-09-21 10:10:30', '2026-09-21 15:49:54');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('40', '9', '5', 'INF-FFMA-R3WR-HW4C-LHYW', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 10:10:30', '2026-09-21 10:10:30');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('51', '12', '1', 'INF-FFUI-KLX7-YAA2-SHCD', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 11:50:25', '2026-09-21 11:50:25');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('52', '12', '2', 'INF-IPIN-C7SL-C7BM-F54Z', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 11:50:25', '2026-09-21 11:50:25');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('53', '12', '3', 'INF-FFUI-9FHM-389A-6L24', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 11:50:25', '2026-09-21 11:50:25');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('54', '12', '4', 'INF-FFPL-VZZV-UN8N-QFZ5', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 11:50:25', '2026-09-21 11:50:25');
INSERT INTO "service_keys" ("id", "user_id", "service_id", "api_key", "label", "total_request", "used_request", "exp_date", "status", "last_used_at", "created_at", "updated_at") VALUES ('55', '12', '5', 'INF-FFMA-Q483-CJN3-6XNH', 'My API Key', '50', '0', '2026-10-21 00:00:00', 'active', NULL, '2026-09-21 11:50:25', '2026-09-21 11:50:25');
DROP TABLE IF EXISTS "settings";
CREATE TABLE "settings" ("id" integer primary key autoincrement not null, "setting_key" varchar not null, "setting_value" text);
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('1', 'site_name', 'INFINITY API HUB');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('2', 'site_tagline', 'Premium API Platform');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('3', 'logo', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('4', 'announcement', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('5', 'registration_open', '1');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('6', 'primary_color', '#2563eb');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('7', 'hero_badge', 'Trusted API Platform');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('8', 'hero_title', 'Powerful APIs for {hl}Modern Apps{/hl}');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('9', 'hero_subtitle', 'One key per API. Blazing-fast gaming, verification and utility APIs with simple integration and instant delivery.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('10', 'feat1_title', 'Lightning Fast');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('11', 'feat1_desc', 'Optimized gateway with millisecond response times.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('12', 'feat2_title', 'Secure Keys');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('13', 'feat2_desc', 'Dedicated key per API with expiry and limits.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('14', 'feat3_title', 'Easy Integration');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('15', 'feat3_desc', 'Copy-paste code samples for PHP, JS and Python.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('16', 'feat4_title', '24/7 Support');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('17', 'feat4_desc', 'Tickets plus Telegram and WhatsApp support.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('18', 'footer_text', 'Fast, reliable and developer-friendly APIs with instant delivery, live monitoring and 24/7 support.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('19', 'custom_css', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('20', 'pay_bkash', '01XXXXXXXXX');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('21', 'pay_nagad', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('22', 'pay_rocket', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('23', 'pay_instruction', 'Send Money to the number below, then submit the Transaction ID.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('24', 'global_provider_key', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('25', 'key_prefix', 'INF-');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('26', 'api_rate_limit', '60');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('27', 'signup_bonus', '50');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('28', 'signup_validity', '30');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('29', 'service_free_quota', '25');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('30', 'status_threshold', '50');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('31', 'support_telegram', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('32', 'support_whatsapp', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('33', 'support_facebook', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('34', 'support_youtube', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('35', 'maintenance_mode', '0');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('36', 'maintenance_msg', 'We are upgrading our systems. Please come back soon.');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('37', 'nagorikpay_enabled', '0');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('38', 'nagorikpay_mode', 'sandbox');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('39', 'nagorikpay_base_url', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('40', 'nagorikpay_create_path', 'api/payment/create');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('41', 'nagorikpay_verify_path', 'api/payment/verify');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('42', 'nagorikpay_api_key', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('43', 'nagorikpay_api_key_live', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('44', 'nagorikpay_api_key_sandbox', 'eyJpdiI6InFncThtbENlaStHalp6bEdZbEtSd3c9PSIsInZhbHVlIjoieEdyL2xLWWdhUE83VFgxTUZWYzBFMTl6bzg0NFdaOVhFN09RdVVCY3c2ND0iLCJtYWMiOiI4ZTU0NmQyODgyNjUwYjc4YjQ1NzQ1ODljMjY2MTdkN2IzZjcwN2M0MzEzN2IzZjJjNGQwMWIxNjhlODJjY2NkIiwidGFnIjoiIn0=');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('45', 'nagorikpay_webhook_secret', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('46', 'nagorikpay_webhook_secret_live', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('47', 'nagorikpay_webhook_secret_sandbox', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('48', 'nagorikpay_brand_id', '');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('49', 'nagorikpay_expire_minutes', '30');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('50', 'nagorikpay_recheck_minutes', '5');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('51', 'nagorikpay_auto_verify', '1');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('52', 'wallet_min_topup', '10');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('53', 'wallet_max_topup', '100000');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('54', 'credit_price_default', '1');
INSERT INTO "settings" ("id", "setting_key", "setting_value") VALUES ('55', 'footer_logo', 'footer-logo.png');
DROP TABLE IF EXISTS "ticket_replies";
CREATE TABLE "ticket_replies" ("id" integer primary key autoincrement not null, "ticket_id" integer not null, "user_id" integer not null, "is_admin" tinyint(1) not null default '0', "message" text not null, "created_at" datetime, "updated_at" datetime, foreign key("ticket_id") references "tickets"("id") on delete cascade, foreign key("user_id") references "users"("id") on delete cascade);
DROP TABLE IF EXISTS "tickets";
CREATE TABLE "tickets" ("id" integer primary key autoincrement not null, "user_id" integer not null, "service_id" integer, "subject" varchar not null, "priority" varchar check ("priority" in ('low', 'medium', 'high')) not null default 'medium', "status" varchar check ("status" in ('open', 'answered', 'closed')) not null default 'open', "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("service_id") references "api_services"("id") on delete set null);
DROP TABLE IF EXISTS "users";
CREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "phone" varchar not null default '', "password" varchar not null, "role" varchar check ("role" in ('admin', 'user')) not null default 'user', "status" varchar check ("status" in ('active', 'suspended')) not null default 'active', "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "google_id" varchar, "password_changed_at" datetime, "must_change_password" tinyint(1) not null default '0');
INSERT INTO "users" ("id", "name", "email", "phone", "password", "role", "status", "remember_token", "created_at", "updated_at", "google_id", "password_changed_at", "must_change_password") VALUES ('1', 'Super Admin', 'admin@infinity.hub', '', '$2y$12$qzUqm3yCwBr8gepz6U/VauWN6QvNza6cAXe1yTu0DSBdx.ZNPkHNe', 'admin', 'active', '6XdHHpMrN5sdTxD7qzejLiikPmozv3dDrLpEuWRVZhlDKE2houIAp7GPE3pZ', '2026-09-21 04:00:55', '2026-09-21 04:00:55', NULL, NULL, '1');
INSERT INTO "users" ("id", "name", "email", "phone", "password", "role", "status", "remember_token", "created_at", "updated_at", "google_id", "password_changed_at", "must_change_password") VALUES ('2', 'riadalhasan', 'riadalhasan68@gmail.com', '01965064030', '$2y$12$LYRoTa5uVwW6.tBirJ7njOkQmu1krIrUwfetWCvEvHJ0y7cro5dx.', 'user', 'active', NULL, '2026-09-21 04:23:00', '2026-09-21 04:23:00', NULL, NULL, '0');
INSERT INTO "users" ("id", "name", "email", "phone", "password", "role", "status", "remember_token", "created_at", "updated_at", "google_id", "password_changed_at", "must_change_password") VALUES ('3', 'QA Slider User', 'qa.slider.20260921@example.com', '01700000000', '$2y$12$7efcSQUdgiJXc4MIvVQyGO0Y8l4Fx3l6eGN9zKvJh8edp6mAc9EC.', 'user', 'active', NULL, '2026-09-21 04:49:49', '2026-09-21 04:49:49', NULL, NULL, '0');
INSERT INTO "users" ("id", "name", "email", "phone", "password", "role", "status", "remember_token", "created_at", "updated_at", "google_id", "password_changed_at", "must_change_password") VALUES ('9', 'RAAD BHAI', 'riadalhasan202@gmail.com', '01965064030', '$2y$12$shtL1Y1uRwkav7y9Ffx9X.i9JunjT7HbWUdPCAy7JVAOe0FvZXMD2', 'user', 'active', NULL, '2026-09-21 10:10:30', '2026-09-21 15:16:04', NULL, NULL, '0');
INSERT INTO "users" ("id", "name", "email", "phone", "password", "role", "status", "remember_token", "created_at", "updated_at", "google_id", "password_changed_at", "must_change_password") VALUES ('12', 'Mobile Frame Tester', 'mobile-frame-tester-20260921@example.test', '01700000000', '$2y$12$z3F8451pg9/VfZ1VqrOkwemMD/j53Du82p/D9jpAOAV4Bw7qybCXu', 'user', 'active', NULL, '2026-09-21 11:50:25', '2026-09-21 11:50:25', NULL, NULL, '0');
INSERT INTO "users" ("id", "name", "email", "phone", "password", "role", "status", "remember_token", "created_at", "updated_at", "google_id", "password_changed_at", "must_change_password") VALUES ('13', 'Administrator', 'admin@gmail.com', '', '$2y$12$znWtRjCS0Z7XKwVFpM4hJO.7YVbwrcPVswpRfTI9ijfIBSB7VEMOW', 'admin', 'active', NULL, '2026-09-21 15:55:32', '2026-09-21 15:55:32', NULL, '2026-09-21 15:55:32', '0');
DROP TABLE IF EXISTS "wallet_transactions";
CREATE TABLE "wallet_transactions" ("id" integer primary key autoincrement not null, "wallet_id" integer not null, "user_id" integer not null, "order_id" integer, "type" varchar not null, "amount" numeric not null, "balance_after" numeric not null default '0', "reference" varchar, "description" varchar not null default '', "metadata" text, "created_at" datetime, "updated_at" datetime, foreign key("wallet_id") references "wallets"("id") on delete cascade, foreign key("user_id") references "users"("id") on delete cascade, foreign key("order_id") references "orders"("id") on delete set null);
DROP TABLE IF EXISTS "wallets";
CREATE TABLE "wallets" ("id" integer primary key autoincrement not null, "user_id" integer not null, "balance" numeric not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade);
INSERT INTO "wallets" ("id", "user_id", "balance", "created_at", "updated_at") VALUES ('1', '12', '0', '2026-09-21 12:08:55', '2026-09-21 12:08:55');
INSERT INTO "wallets" ("id", "user_id", "balance", "created_at", "updated_at") VALUES ('2', '9', '0', '2026-09-21 13:11:29', '2026-09-21 13:11:29');
CREATE INDEX "api_logs_created_at_index" on "api_logs" ("created_at");
CREATE UNIQUE INDEX "api_services_slug_unique" on "api_services" ("slug");
CREATE UNIQUE INDEX "invoices_invoice_number_unique" on "invoices" ("invoice_number");
CREATE INDEX "nagorikpay_logs_created_at_index" on "nagorikpay_logs" ("created_at");
CREATE INDEX "nagorikpay_logs_order_id_index" on "nagorikpay_logs" ("order_id");
CREATE INDEX "nagorikpay_logs_transaction_id_index" on "nagorikpay_logs" ("transaction_id");
CREATE UNIQUE INDEX "orders_payment_method_txn_unique" on "orders" ("payment_method", "txn_id");
CREATE UNIQUE INDEX "service_keys_api_key_unique" on "service_keys" ("api_key");
CREATE UNIQUE INDEX "service_keys_user_id_service_id_unique" on "service_keys" ("user_id", "service_id");
CREATE UNIQUE INDEX "settings_setting_key_unique" on "settings" ("setting_key");
CREATE UNIQUE INDEX "users_email_unique" on "users" ("email");
CREATE UNIQUE INDEX "users_google_id_unique" on "users" ("google_id");
CREATE UNIQUE INDEX "wallet_transactions_reference_unique" on "wallet_transactions" ("reference");
CREATE UNIQUE INDEX "wallets_user_id_unique" on "wallets" ("user_id");
COMMIT;
PRAGMA foreign_keys=ON;