PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u423589436/domains/cargobridge.online/public_html/update/version5DB.sql

CREATE TABLE `autologin_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count` int(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `bnc_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `deposit_id` bigint unsigned NOT NULL,
  `prepay_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `kycs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `social_media` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frontimg` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backimg` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



ALTER TABLE mt4_details
    ADD reminded_at datetime DEFAULT NULL AFTER end_date;

  ALTER TABLE settings
    ADD enable_kyc_registration varchar(191) DEFAULT NULL AFTER enable_kyc,
    ADD return_capital tinyint(1) DEFAULT '1' AFTER enable_kyc,
    ADD should_cancel_plan tinyint(1) DEFAULT '1' AFTER enable_kyc,
    ADD auto_merchant_option varchar(191) DEFAULT 'Coinpayment' AFTER deposit_option,
    ADD deposit_bonus int(20) DEFAULT NULL AFTER signup_bonus,
    ADD welcome_message text DEFAULT NULL AFTER newupdate,
    ADD website_theme varchar(191) DEFAULT 'purpose.css' AFTER newupdate,
    ADD deduction_option varchar(191) DEFAULT 'userRequest' AFTER website_theme,
    ADD modules JSON DEFAULT NULL AFTER newupdate,
    ADD redirect_url varchar(191) DEFAULT NULL AFTER newupdate,
    ADD merchant_key varchar(191) DEFAULT NULL AFTER newupdate,
    ADD credit_card_provider varchar(191) DEFAULT 'Paystack' AFTER website_theme;

  ALTER TABLE settings_conts
    ADD flw_public_key varchar(191) DEFAULT NULL AFTER transfer_charges,
    ADD flw_secret_key varchar(191) DEFAULT NULL AFTER transfer_charges,
    ADD flw_secret_hash varchar(191) DEFAULT NULL AFTER transfer_charges,
    ADD bnc_api_key varchar(191) DEFAULT NULL AFTER transfer_charges,
    ADD bnc_secret_key varchar(191) DEFAULT NULL AFTER transfer_charges,
    ADD purchase_code varchar(191) DEFAULT 'xxxxxx' AFTER min_transfer,
    ADD telegram_bot_api varchar(191) DEFAULT NULL AFTER use_transfer;

  ALTER TABLE users
    ADD kyc_id bigint DEFAULT NULL AFTER id,
    ADD usdt_address varchar(191)  DEFAULT NULL AFTER btc_address;

DELETE FROM wdmethods WHERE name='Paystack';
DELETE FROM wdmethods WHERE name='Stripe';

INSERT INTO `wdmethods` (`name`, `defaultpay`, `status`, `type`, `methodtype`, `network`, `created_at`, `updated_at`) VALUES
('Credit Card', 'yes', 'enabled', 'deposit', 'currency', '-', '2021-04-14 02:45:06', '2021-11-22 00:00:52'),
('USDT', 'yes', 'enabled', 'both', 'crypto', 'TRC20', '2021-04-14 02:45:06', '2021-11-22 00:00:52'),
('BUSD', 'yes', 'enabled', 'deposit', 'crypto', 'ERC20', '2021-04-14 02:45:06', '2021-11-22 00:00:52');
Back to Directory=ceiIENDB`