-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `quantuml_qfsbackupledger`
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `superAdmin` varchar(1) NOT NULL DEFAULT '0',
  `password` varchar(100) DEFAULT NULL,
  `pin` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `superAdmin`, `password`, `pin`) VALUES
(1, 'admin', '1', 'cb8ce1b71ed2850d52a41c4c0586c800', 2721);

-- --------------------------------------------------------

--
-- Table structure for table `investments`
--

CREATE TABLE `investments` (
  `inv_id` bigint NOT NULL,
  `plan_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `created_at` date NOT NULL,
  `next_profit_day` date NOT NULL,
  `end_date` date NOT NULL,
  `return_amount` varchar(255) NOT NULL,
  `deposit_amount` bigint NOT NULL,
  `coin` varchar(255) NOT NULL,
  `inv_status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int NOT NULL,
  `title` text,
  `body` longtext,
  `status` int DEFAULT '0',
  `updated` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `body`, `status`, `updated`) VALUES
(1, 'Welcome', '<p><span style=\"font-weight: normal;\">Bitcoin High Price A Result Of Endless Money Printing</span><br></p>', 0, '11/08/2021');

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `ref` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `notice` int DEFAULT '0',
  `created_at` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `user_id`, `ref`, `subject`, `description`, `file`, `status`, `notice`, `created_at`) VALUES
(2, 233, 'QFS7644', 'Hello josh', '<p>This is sample notification</p>', NULL, 1, 1, '10/04/2023 04:53');

-- --------------------------------------------------------

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `plan_id` bigint NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `min_amount` varchar(255) NOT NULL,
  `max_amount` varchar(255) NOT NULL,
  `profit_percentage` int NOT NULL,
  `interval_period` bigint NOT NULL,
  `time_period` bigint NOT NULL,
  `plan_status` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` int NOT NULL,
  `btc` varchar(255) DEFAULT NULL,
  `eth` varchar(255) DEFAULT NULL,
  `xrp` varchar(255) DEFAULT NULL,
  `usdt` varchar(255) DEFAULT NULL,
  `doge` varchar(255) DEFAULT NULL,
  `ltc` varchar(255) DEFAULT NULL,
  `shiba` varchar(255) DEFAULT NULL,
  `xlm` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` (`id`, `btc`, `eth`, `xrp`, `usdt`, `doge`, `ltc`, `shiba`, `xlm`) VALUES
(1, '26798.714546997', '1557.9756518264', '0.47675351323914', '1.0004955504772', '0.086941080077694', '61.222544995377', '7.2727421254891', '0.10196184186074');

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int NOT NULL,
  `protocol` varchar(100) DEFAULT NULL,
  `domain` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `company_description` longtext,
  `company_email` varchar(255) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `company_phone` varchar(255) DEFAULT NULL,
  `abrv` varchar(100) DEFAULT NULL,
  `chat_code` mediumtext,
  `theme_color` varchar(255) DEFAULT NULL,
  `upload_folder` varchar(255) DEFAULT NULL,
  `theme_folder` varchar(255) DEFAULT NULL,
  `company_logo` varchar(100) DEFAULT NULL,
  `company_favicon` varchar(100) DEFAULT NULL,
  `company_timezone` varchar(255) DEFAULT NULL,
  `captchaPublicKey` varchar(255) DEFAULT NULL,
  `captchaPrivateKey` varchar(255) DEFAULT NULL,
  `live_chat` int DEFAULT '1',
  `im_chat` int DEFAULT '1',
  `im_position` varchar(100) DEFAULT 'left',
  `whatsapp` varchar(255) DEFAULT NULL,
  `telegram` varchar(255) DEFAULT NULL,
  `buy` int NOT NULL DEFAULT '0',
  `bank` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `routing` varchar(255) DEFAULT NULL,
  `swift` varchar(255) DEFAULT NULL,
  `home_address` varchar(255) DEFAULT NULL,
  `paypal_email` varchar(255) DEFAULT NULL,
  `payoneer` varchar(100) DEFAULT NULL,
  `netteller` varchar(100) DEFAULT NULL,
  `perfect_money` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `protocol`, `domain`, `company_name`, `company_description`, `company_email`, `company_address`, `company_phone`, `abrv`, `chat_code`, `theme_color`, `upload_folder`, `theme_folder`, `company_logo`, `company_favicon`, `company_timezone`, `captchaPublicKey`, `captchaPrivateKey`, `live_chat`, `im_chat`, `im_position`, `whatsapp`, `telegram`, `buy`, `bank`, `account_name`, `account_number`, `routing`, `swift`, `home_address`, `paypal_email`, `payoneer`, `netteller`, `perfect_money`) VALUES
(1, 'http://', 'www.worldquantumledger.org', 'worldquantumledger.org', 'quantum financial System', 'support@worldquantumledger.org', 'New YORK', '+2347030000453', 'QFS', '<!--Start of Tawk.to Script-->\r\n<script type=\"text/javascript\">\r\nvar Tawk_API=Tawk_API||{}, Tawk_LoadStart=new Date();\r\n(function(){\r\nvar s1=document.createElement(\"script\"),s0=document.getElementsByTagName(\"script\")[0];\r\ns1.async=true;\r\ns1.src=\'https://embed.tawk.to/651fe8f16fcfe87d54b71a03/1hc2absoq\';\r\ns1.charset=\'UTF-8\';\r\ns1.setAttribute(\'crossorigin\',\'*\');\r\ns0.parentNode.insertBefore(s1,s0);\r\n})();\r\n</script>\r\n<!--End of Tawk.to Script-->', '#000000', 'https://worldquantumledger.org/wallet/upload', 'https://worldquantumledger.org/wallet/login_assets', '441footerlogo.png', '996IMG_2861.jpeg', 'US/Central', '6LcVpX4oAAAAAOJWXA9J4apoDWmNpIWl1XEbBbmd ', '6LcVpX4oAAAAAH04poT9lLGkJM1D3dMsYRcyytrB', 1, 0, 'left', '+23470345678', 'lo', 0, '', '', '', '123456', '1234566', '', 'support@worldquantumledger.org', 'support@worldquantumledger.org', 'support@worldquantumledger.org', 'U1234567');

-- --------------------------------------------------------

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` int UNSIGNED NOT NULL,
  `ref` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dept` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int UNSIGNED DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wallet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `coin_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tx_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `name`, `email`, `wallet`, `hash`, `status`, `coin_type`, `transaction_type`, `amount`, `reference`, `tx_date`) VALUES
(233, 235, 'Somtoo', 'Joshia@gmail.com', 'DTckY1so1jZhP3xC2re44Sq2xM9ccgPDwF', NULL, 1, 'SHIBA', 'Receive', '0', 'QFS1011', '10/06/2023 20:58');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint NOT NULL,
  `ref` int DEFAULT '0',
  `name` varchar(200) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `status` int DEFAULT '1',
  `btc` varchar(255) NOT NULL DEFAULT '0',
  `eth` varchar(255) NOT NULL DEFAULT '0',
  `xrp` varchar(255) NOT NULL DEFAULT '0',
  `usdt` varchar(255) DEFAULT '0',
  `doge` varchar(255) DEFAULT '0',
  `ltc` varchar(255) DEFAULT '0',
  `shiba` varchar(255) DEFAULT '0',
  `xlm` varchar(100) DEFAULT NULL,
  `usdt_wallet` varchar(255) DEFAULT NULL,
  `doge_wallet` varchar(255) DEFAULT NULL,
  `ltc_wallet` varchar(255) DEFAULT NULL,
  `shiba_wallet` varchar(255) DEFAULT NULL,
  `btc_wallet` varchar(255) DEFAULT NULL,
  `eth_wallet` varchar(255) DEFAULT NULL,
  `xrp_wallet` varchar(255) DEFAULT NULL,
  `xlm_wallet` varchar(100) DEFAULT NULL,
  `referrer` varchar(255) NOT NULL DEFAULT 'No Referral',
  `lastTime` varchar(255) DEFAULT NULL,
  `lastDate` varchar(255) DEFAULT NULL,
  `lastUrl` varchar(255) DEFAULT NULL,
  `identity` int NOT NULL DEFAULT '0',
  `identityPhoto` varchar(255) DEFAULT NULL,
  `identityType` varchar(255) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL DEFAULT 'user-default.png',
  `country` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `address` text,
  `ip` varchar(100) DEFAULT NULL,
  `phone` varchar(200) DEFAULT NULL,
  `exp` varchar(100) DEFAULT NULL,
  `created_at` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `ref`, `name`, `username`, `email`, `status`, `btc`, `eth`, `xrp`, `usdt`, `doge`, `ltc`, `shiba`, `xlm`, `usdt_wallet`, `doge_wallet`, `ltc_wallet`, `shiba_wallet`, `btc_wallet`, `eth_wallet`, `xrp_wallet`, `xlm_wallet`, `referrer`, `lastTime`, `lastDate`, `lastUrl`, `identity`, `identityPhoto`, `identityType`, `password`, `gender`, `image`, `country`, `city`, `address`, `ip`, `phone`, `exp`, `created_at`) VALUES
(233, 0, 'Josh techs', 'Joshtechs', 'Joshtechs.com@gmail.com', 1, '0', '0', '0', '0', '0', '0', '0', '4000', 'TMxQPBwQC2QNQA8jP9HDJdD92Tw9LUp1vq', '0x093b59e82d890aA4af4A61c7eF9d25518EB8551f', 'ltc1q0fcaxe078qu2mjmru689c59evuk5hmhm4xzxe3', 'DRtDBqaTj7XRJ5BFktpM5aPU1bCfxhEASs', 'bc1qcf5tg8lr6mg4w5ue0zv3wmzvy0ekwd2e0ymc5u', '0x093b59e82d890aA4af4A61c7eF9d25518EB8551f', 'r43y3kHpPJgb4ncfLr9KZiLe5A6vqLVEPk', 'GDJBVBLNE5QPSF27QVBN4PCCZWQE6VCB3ZNI5LHR6Y5RCT6BYSZL6KSV', 'No Referral', NULL, NULL, NULL, 1, NULL, NULL, '202cb962ac59075b964b07152d234b70', NULL, 'user-default.png', NULL, NULL, NULL, NULL, NULL, '202310040425', '10/04/2023 04:20'),
(235, 0, 'Somtoo', 'Jc', 'Joshia@gmail.com', 1, '0', '0', '0', '0', '0', '0', '0', '893.65', '0xD54dc7c46DbfFF41B2B8d3D148D6BaA71e6af689', '0xD54dc7c46DbfFF41B2B8d3D148D6BaA71e6af689', 'ltc1qlh2vyfsf8myenj79nswqqnkg0rqhtxsm8rqxzt', 'DTckY1so1jZhP3xC2re44Sq2xM9ccgPDwF', 'bc1q4q9qnxt6jp9uu2a0zma3ff090m7p2qzge7498e', '0xD54dc7c46DbfFF41B2B8d3D148D6BaA71e6af689', 'rUZy8TQazKe1HFbQY8MXXVUtgSNqBU9oZE', 'GDBRMF55CRAT7CRRKMAMFRK6F2XOHWZKQ3GPZF24BKMMIQBLECV626KN', 'No Referral', NULL, NULL, NULL, 1, '4996FBBB28F-E91A-472B-B256-80FDDAA7D8C6.jpeg', 'Driving License', '73f20762cbb7a28168a2c7c5cc8a58cf', NULL, 'user-default.png', NULL, NULL, NULL, NULL, NULL, '202310060702', '10/06/2023 06:57');

-- --------------------------------------------------------

--
-- Table structure for table `wallet`
--

CREATE TABLE `wallet` (
  `id` int NOT NULL,
  `btc` varchar(100) DEFAULT NULL,
  `eth` varchar(100) DEFAULT NULL,
  `xrp` varchar(100) DEFAULT NULL,
  `shiba` varchar(100) DEFAULT NULL,
  `doge` varchar(100) DEFAULT NULL,
  `ltc` varchar(100) DEFAULT NULL,
  `usdt` varchar(100) DEFAULT NULL,
  `xlm` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wallet`
--

INSERT INTO `wallet` (`id`, `btc`, `eth`, `xrp`, `shiba`, `doge`, `ltc`, `usdt`, `xlm`) VALUES
(9, 'bc1q4q9qnxt6jp9uu2a0zma3ff090m7p2qzge7498e', '0xD54dc7c46DbfFF41B2B8d3D148D6BaA71e6af689', 'rUZy8TQazKe1HFbQY8MXXVUtgSNqBU9oZE', '0xD54dc7c46DbfFF41B2B8d3D148D6BaA71e6af689', 'DTckY1so1jZhP3xC2re44Sq2xM9ccgPDwF', 'ltc1qlh2vyfsf8myenj79nswqqnkg0rqhtxsm8rqxzt', '0xD54dc7c46DbfFF41B2B8d3D148D6BaA71e6af689', 'GDBRMF55CRAT7CRRKMAMFRK6F2XOHWZKQ3GPZF24BKMMIQBLECV626KN');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `investments`
--
ALTER TABLE `investments`
  ADD PRIMARY KEY (`inv_id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`plan_id`);

--
-- Indexes for table `rates`
--
ALTER TABLE `rates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `letter_user_user_id_foreign` (`user_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hi1` (`status`);

--
-- Indexes for table `wallet`
--
ALTER TABLE `wallet`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `investments`
--
ALTER TABLE `investments`
  MODIFY `inv_id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `plan_id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `rates`
--
ALTER TABLE `rates`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=234;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=236;

--
-- AUTO_INCREMENT for table `wallet`
--
ALTER TABLE `wallet`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
COMMIT;

