INSERT INTO `systemflags` (`id`, `valueType`, `name`, `value`, `isActive`, `isDelete`, `created_at`, `updated_at`, `displayName`, `flagGroupId`, `description`, `parent_id`, `viewenable`) VALUES
(1, 'File', 'Logo', 'assets/img/uploads/Logo1755588247.jpg', '1', '0', '2023-04-05 10:32:46', '2025-08-19 07:24:07', 'Logo', 12, '', 0, 1),
(2, 'Text', 'AiraloClientId', '', '1', '0', NULL, '2025-08-28 12:56:42', 'Airalo Client ID', 74, '', 0, 1),
(3, 'Text', 'AiraloClientSecretKey', '', '1', '0', NULL, '2025-08-28 12:56:42', 'Airalo Client Secret Key', 74, '', 0, 1),
(4, 'Number', 'PackageCommission', '30', '1', '0', '2023-03-31 07:04:26', '2025-08-28 12:56:42', 'Package Commission (%)', 11, '', 0, 1),
(5, 'Number', 'TopUpCommission', '30', '1', '0', '2023-03-31 07:04:26', '2025-08-28 12:56:42', 'TopUp Commission (%)', 11, '', 0, 1),
(6, 'Text', 'appName', 'ESIMTEL', '1', '0', '2025-08-11 10:21:17', '2025-08-28 12:56:42', 'App Name', 1, '', 0, 1),
(7, 'MultiSelect', 'Language', '2,3', '1', '0', '2023-04-08 10:21:17', '2025-08-28 12:56:42', 'App Language', 1, '', 0, 1),
(8, 'Text', 'AiraloGrantType', 'client_credentials', '1', '0', NULL, '2025-08-28 12:56:42', 'Airalo Grant Type', 74, '', 0, 1),
(9, 'Text', 'AiraloBaseUrl', 'https://partners-api.airalo.com/v2', '1', '0', NULL, '2025-08-28 12:56:42', 'Airalo Base Url', 74, '', 0, 1),
(10, 'File', 'favicon', 'assets/img/uploads/favicon1755593908.png', '1', '0', '2025-08-14 10:32:46', '2025-08-19 08:58:28', 'Favicon', 12, '', 0, 1),
(11, 'Text', 'referralPoint', '50', '1', '0', '2025-08-11 10:21:17', '2025-08-28 12:56:42', 'Referral Points', 1, 'On App share get points to referred person', 0, 1),
(12, 'PaymentRadio', 'paymentMode', '0', '1', '0', '2025-08-20 19:27:25', '2025-08-28 12:56:42', 'In App Billing Payment Mode', 2, 'You can enable In-App Billing for digital goods.After enabling it, other payment methods in the app will be automatically disabled.', 0, 1),
(13, 'timezoneSelect', 'timezone', 'Asia/Kolkata', '1', '0', '2025-08-21 19:27:25', '2025-08-28 12:56:42', 'Select Timezone', 65, 'Selected timezone show time accordingly', 0, 1),
(14, 'GatewayRadio', 'isActiveRazorpay', '1', '1', '0', '2025-08-21 19:27:25', '2025-08-28 12:56:42', 'Razorpay Active or Inactive', 66, ' ', 0, 1),
(15, 'GatewayRadio', 'isActiveStripe', '0', '1', '0', '2025-08-21 19:27:25', '2025-08-28 12:56:42', 'Stripe Active or Inactive', 67, ' ', 0, 1),
(16, 'GatewayRadio', 'isActiveCashfree', '0', '1', '0', '2025-08-21 19:27:25', '2025-08-28 12:56:42', 'Cashfree Active or Inactive', 68, ' ', 0, 1),
(17, 'Text', 'razorpayTestingkeyId', '', '1', '0', '2024-02-19 19:27:25', '2025-08-28 12:56:42', 'Razorpay Testingkey', 66, ' ', 0, 1),
(18, 'Text', 'razorpayTestingSecretkey', '', '1', '0', '2024-02-19 19:27:25', '2025-08-28 12:56:42', 'Razorpay Testing Secretkey', 66, ' ', 0, 1),
(19, 'Text', 'razorpayLivekeyId', '', '1', '0', '2024-02-19 19:27:25', '2025-08-28 12:56:42', 'Razorpay Livekey', 66, ' ', 0, 1),
(20, 'Text', 'razorpayLiveSecretkey', '', '1', '0', '2024-02-19 19:27:25', '2025-08-28 12:56:42', 'Razorpay Live Secretkey', 66, ' ', 0, 1),
(21, 'Text', 'stripeLiveSecretkey', '', '1', '0', '2025-08-20 19:27:25', '2025-08-28 12:56:42', 'Stripe Live Secretkey', 67, ' ', 0, 1),
(22, 'Text', 'stripeLivePublishkey', '', '1', '0', '2025-08-20 19:27:25', '2025-08-28 12:56:42', 'Stripe Live Publishkey', 67, ' ', 0, 1),
(23, 'Text', 'stripeTestingSecretkey', '', '1', '0', '2025-08-20 19:27:25', '2025-08-28 12:56:42', 'Stripe Testing Secretkey', 67, ' ', 0, 1),
(24, 'Text', 'stripeTestingPublishkey', '', '1', '0', '2025-08-20 19:27:25', '2025-08-28 12:56:42', 'Stripe Testing Publishkey', 67, ' ', 0, 1),
(25, 'Text', 'cashfreeAppId', '', '1', '0', '2025-08-21 19:27:25', '2025-08-28 12:56:42', 'Cashfree App Id', 68, ' ', 0, 1),
(26, 'Text', 'cashfreeSecretKey', '', '1', '0', '2025-08-21 19:27:25', '2025-08-28 12:56:42', 'Cashfree Secret Key', 68, ' ', 0, 1),
(27, 'PaymentModeSelect', 'paymentModeEnvRazorpay', '0', '1', '0', '2025-08-21 19:27:25', '2025-08-28 07:55:55', 'Environment Mode', 66, ' Payment Gateway Test or Production Mode', 0, 1),
(28, 'PaymentModeSelect', 'paymentModeEnvStripe', '0', '1', '0', '2025-08-21 19:27:25', '2025-08-28 07:55:55', 'Environment Mode', 67, ' Payment Gateway Test or Production Mode', 0, 1),
(29, 'PaymentModeSelect', 'paymentModeEnvCashfree', '0', '1', '0', '2025-08-21 19:27:25', '2025-08-28 07:55:55', 'Environment Mode', 68, ' Payment Gateway Test or Production Mode', 0, 1),
(30, 'AiraloSyncDataButton', 'airaloSyncButton', 'Sync', '1', '0', '2025-08-21 19:27:25', '2025-08-26 07:55:55', 'Sync Airalo Package Data', 69, 'Sync Package from Airalo', 0, 1),
(31, 'Text', 'androidPackageName', 'com.esimtel.app', '1', '0', '2025-08-11 10:21:17', '2025-08-28 12:56:42', 'Android Package Name', 1, 'For Android', 0, 1),
(32, 'defaultCurrencySelect', 'iapDefaultCurrency', '', '1', '0', '2025-09-18 10:21:17', '2025-09-18 06:43:25', 'In App Product Default Currency', 1, 'Set Default currency', 0, 1),
(33, 'SyncToGoogleDataButton', 'googleSyncButton', 'Sync To Google', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Sync In App Product to Google Play Console', 69, 'Upload In App Product to Google play console', 0, 1),
(34, 'SyncToAppleDataButton', 'appleSyncButton', 'Sync To Apple Store', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Sync In App Product to Apple Store', 69, 'Upload In App Product to Apple Store', 0, 1),
(35, 'Text', 'iosAppId', '', '1', '0', '2025-10-09 07:36:46', '2025-10-09 07:36:46', 'App ID', 70, 'IOS App ID', 0, 1),
(36, 'Text', 'iosKeyId', '', '1', '0', '2025-10-09 07:36:46', '2025-10-09 07:36:46', 'Key ID', 70, 'IOS Key ID', 0, 1),
(37, 'Text', 'iosIssuerId', '', '1', '0', '2025-10-09 07:36:46', '2025-10-09 07:36:46', 'Issuer ID', 70, 'IOS Issuer ID', 0, 1),
(38, 'Text', 'firebaseApiKey', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase Api Key', 72, 'Set Firebase API Key', 0, 1),
(39, 'Text', 'firebaseAuthDomain', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase Auth Domain', 72, 'Set Firebase Auth Domain', 0, 1),
(40, 'Text', 'firebaseProjectId', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase Project Id', 72, 'Set Firebase Project ID', 0, 1),
(41, 'Text', 'firebaseStorageBucket', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase Storage Bucket', 72, 'Set Firebase Storage Bucket URL', 0, 1),
(42, 'Text', 'firebaseSenderId', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase Sendor ID', 72, 'Set Firebase Sender ID', 0, 1),
(43, 'Text', 'firebaseAppId', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase App Id', 72, 'Set Firebase APP ID', 0, 1),
(44, 'Text', 'firebaseVapidKey', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Firebase Vap Id', 72, 'Set Firebase VAP ID', 0, 1),
(45, 'Text', 'webBaseUrl', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Web Base URL', 73, '', 0, 1),
(46, 'Text', 'contactEmail', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Email', 73, '', 0, 1),
(47, 'Text', 'contactPhone', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Phone', 73, '', 0, 1),
(48, 'Text', 'address', '', '1', '0', '2025-09-18 19:27:25', '2025-09-18 19:27:25', 'Address', 73, '', 0, 1),
(49, 'File', 'DarkLogo', 'assets/img/uploads/Logo1755588247.jpg', '1', '0', '2025-10-31 10:32:46', '2025-10-31 07:24:07', 'Dark Logo', 12, '', 0, 1),
(50, 'Text', 'esimGoKey', '1GUdfNPcm1SRs2i_tVb9gOT630Og22sdYbOwlZ7i', '1', '0', '2025-10-29 10:15:26', '2025-10-31 10:32:46', 'Esim Go Key', 76, '', 0, 1),
(51, 'Text', 'esimGoApiUrl', 'https://api.esim-go.com/v2.4', '1', '0', '2025-10-29 10:15:26', '2025-10-31 10:32:46', 'Esim Go Api Url', 76, '', 0, 1),
(52, 'Text', 'esimAccessCode', 'bcd1bd5624344412a42e5beaceb3a97c', '1', '0', '2025-10-29 10:15:26', '2025-10-31 10:32:46', 'Esim Access Code', 75, '', 0, 1),
(53, 'Text', 'esimAccessSecretKey', '0870c0b84cf544aaba1d01cef94dc560', '1', '0', '2025-10-29 10:15:26', '2025-10-31 10:32:46', 'Esim Access Key', 75, '', 0, 1),
(54, 'Text', 'esimAccessApiUrl', 'https://api.esimaccess.com/api/v1', '1', '0', '2025-10-29 10:15:26', '2025-10-31 10:32:46', 'Esim Access Api Url', 75, '', 0, 1),
(55, 'EsimProviderRadio', 'esimProvider', 'airalo', '1', '0', '2025-10-29 10:15:26', '2025-10-31 10:32:46', 'Choose Your Active eSIM Provider', 9, '', 0, 1),
(56, 'EsimaccessSyncDataButton', 'esimaccessSyncButton', 'Sync', '1', '0', '2025-08-21 19:27:25', '2025-08-26 07:55:55', 'Sync Esimaccess Package Data', 69, 'Sync Package from Esimaccess', 0, 1),
(57, 'EsimgoSyncDataButton', 'esimgoSyncButton', 'Sync', '1', '0', '2025-08-21 19:27:25', '2025-08-26 07:55:55', 'Sync Esimgo Package Data', 69, 'Sync Package from Esimgo', 0, 1);
