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

START TRANSACTION;



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

--
-- 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 `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 `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 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 `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `letter_user_user_id_foreign` (`user_id`);

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

--
-- 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 `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

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

