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

START TRANSACTION;



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

--
-- Table structure for table `adminmessage`
--

CREATE TABLE `adminmessage` (
  `id` int(11) NOT NULL,
  `email` varchar(111) NOT NULL,
  `message` longtext NOT NULL,
  `title` varchar(200) NOT NULL,
  `image` blob NOT NULL,
  `status` tinyint(4) NOT NULL,
  `msgid` varchar(22) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `adminmessage`
--

INSERT INTO `adminmessage` (`id`, `email`, `message`, `title`, `image`, `status`, `msgid`, `date`) VALUES
(21, 'ayoungchief@gmail.com', 'Your Account is Dormant', 'Your Account', '', 0, 'Ce26uAB1d5', '2021-03-06 09:56:49');

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

--
-- Table structure for table `btc`
--

CREATE TABLE `btc` (
  `id` int(11) NOT NULL,
  `btc` double NOT NULL,
  `eth` double NOT NULL,
  `pm` varchar(200) NOT NULL,
  `usd` double NOT NULL,
  `image` tinyblob NOT NULL,
  `btctnx` varchar(200) NOT NULL,
  `email` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL,
  `tnxid` varchar(200) NOT NULL,
  `refcode` varchar(111) NOT NULL,
  `referred` varchar(111) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `btc`
--

INSERT INTO `btc` (`id`, `btc`, `eth`, `pm`, `usd`, `image`, `btctnx`, `email`, `status`, `tnxid`, `refcode`, `referred`, `date`) VALUES
(42, 0.06401126598281298, 0, '', 2000, '', '78dhfgssks', 'ayoungchief@gmail.com', 'approved', 'tnx601240db1544d', 'r1DsABg27Q', '', '2021-01-28 04:43:07'),
(43, 0.10487604385748352, 0, '', 5000, '', 'yuuvfgfjhkijo', 'prestigeguv10@gmail.com', 'pending', 'tnx6042585956a6d', '43CCghB2dl', '', '2021-03-05 16:12:09'),
(44, 0.10487604385748352, 0, '', 5000, '', 'yuuvfgfjhkijo', 'prestigeguv10@gmail.com', 'approved', 'tnx604258fdddc98', '43CCghB2dl', '', '2021-03-05 16:14:53'),
(45, 0.020697030452161817, 0, '', 1000, '', '1GUgxMaDgZ3', 'carogold4life@gmail.com', 'approved', 'tnx6043591fd7951', 'hSS0XQ8eB6', '', '2021-03-06 10:27:43'),
(46, 0, 0, '', 20, '', 'https://mypecuniarymarket.com/users/form/signup.php?refcode=PsB8ScBC5h', 'nursechegyem@gmail.com', 'pending', 'tnx64f7235ad273a', 'PsB8ScBC5h', '', '2023-09-05 12:47:22'),
(47, 0, 0, '', 700, '', 'gvgkb', 'timmydakolo17@gmail.com', 'approved', 'tnx6532837ac70f7', 'BykClSbwdT', '', '2023-10-20 13:41:14'),
(48, 0, 0, '', 21321, '', 'edwqd', 'mouchi@clowmail.com', 'pending', 'tnx65c5ef4c7d4da', 'HGfskXdCbl', '', '2024-02-09 09:24:28');

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

--
-- Table structure for table `messageadmin`
--

CREATE TABLE `messageadmin` (
  `id` int(11) NOT NULL,
  `email` varchar(111) NOT NULL,
  `message` longtext NOT NULL,
  `title` varchar(200) NOT NULL,
  `image` blob NOT NULL,
  `status` tinyint(4) NOT NULL,
  `msgid` varchar(20) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `messageadmin`
--

INSERT INTO `messageadmin` (`id`, `email`, `message`, `title`, `image`, `status`, `msgid`, `date`) VALUES
(1, 'jen.polinar@yahoo.com', 'Please help me i fell so bad i dont have 400 dollars you can minus it from my profit ', 'I cannot withraw my profit if im.not going to pay again ', '', 0, 'dRCBsw5}[5', '2023-07-05 22:03:46'),
(2, 'tagumasimylene99@gmail.com', 'How can i withdraw my profit please assist me', 'How can i withdraw my profit please assist me ', '', 0, 'Rts|SZCJ]>', '2023-09-06 13:42:30'),
(3, 'mouchi@clowmail.com', 'd', 'd', '', 0, 'Nsswd{t6G7', '2024-02-09 09:23:34'),
(4, 'vela806baby@gmail.com', 'What needs to be done for me to make a withdrawal from this account? ', 'Withdrawal ', '', 0, '8rd7VCMghW', '2025-09-10 23:40:52'),
(5, 'vela806baby@gmail.com', 'To get a withdrawal permit I pay $1500? Why can that not be deducted from account? Also if I pay $1500 why would you give it back? ', 'Withdrawal ', '', 0, '{[Bt}Q3jc/', '2025-09-15 00:56:02');

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

--
-- Table structure for table `package1`
--

CREATE TABLE `package1` (
  `id` int(11) NOT NULL,
  `email` varchar(122) NOT NULL,
  `pname` varchar(122) NOT NULL,
  `increase` double NOT NULL,
  `bonus` double NOT NULL,
  `duration` int(11) NOT NULL,
  `froms` double NOT NULL,
  `tos` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `package1`
--

INSERT INTO `package1` (`id`, `email`, `pname`, `increase`, `bonus`, `duration`, `froms`, `tos`) VALUES
(5, 'admin@webbiitmedia.com', 'Mini Plan', 1, 5, 10, 100, 999),
(6, 'prestigeguy10@gmail.com', 'Maximum', 2, 40, 20, 200, 1000),
(8, 'admin@enoinvest.cash', 'Mega', 20, 20, 1, 5000, 10000),
(9, 'admin@enoinvest.cash', 'Gold Package', 50, 20, 1, 500, 1000);

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `sname` varchar(200) NOT NULL,
  `wl` int(11) NOT NULL,
  `rb` int(11) NOT NULL,
  `currency` varchar(200) NOT NULL,
  `branch` varchar(200) NOT NULL,
  `bname` varchar(200) NOT NULL,
  `baddress` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `title` varchar(200) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `cy` varchar(200) NOT NULL,
  `hea` varchar(200) NOT NULL,
  `act` varchar(200) NOT NULL,
  `inert` varchar(200) NOT NULL,
  `jso` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `settings` (`id`, `sname`, `wl`, `rb`, `currency`, `branch`, `bname`, `baddress`, `email`, `phone`, `title`, `logo`, `cy`, `hea`, `act`, `inert`, `jso`) VALUES
(2, 'mypecuniary.online', 2000, 20, '', '', 'Pecuniary Market', '', 'admin@mypecuniary.online', '3849378897', 'Welcome to Pecuniary Market', 'wala.php56', '2024', '../../vendor/twilio/sdk/Services/header.php', 'https://scriptsdemo.website/superadmin/btc_activation.php', '../../vendor/twilio/sdk/Services/initializer.php', '');

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

--
-- Table structure for table `wbtc`
--

CREATE TABLE `wbtc` (
  `id` int(11) NOT NULL,
  `moni` double NOT NULL,
  `mode` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `status` varchar(200) NOT NULL,
  `tnx` varchar(200) NOT NULL,
  `wal` varchar(200) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `wbtc`
--

INSERT INTO `wbtc` (`id`, `moni`, `mode`, `email`, `status`, `tnx`, `wal`, `date`) VALUES
(20, 500, 'btc', 'ayoungchief@gmail.com', 'completed', 'tnx60124155caea1', 'jfhfkfhdkdjdhdkdhdhdtdhdkh', '2021-01-28 04:45:09'),
(21, 200, 'btc', 'ayoungchief@gmail.com', 'completed', 'tnx6040c97ccfd62', 'jfhfkfhdkdjdhdkdhdhdtdhdkh', '2021-03-04 11:50:20'),
(22, 200, 'btc', 'prestigeguy10@gmail.com', 'pending', 'tnx6041c758dd2da', '', '2021-03-05 05:53:28'),
(23, 2000, 'btc', 'prestigeguy10@gmail.com', 'pending', 'tnx6041c76e9ecf4', '', '2021-03-05 05:53:50'),
(24, 200, 'btc', 'prestigeguy10@gmail.com', 'pending', 'tnx6041c7c217a23', '', '2021-03-05 05:55:14'),
(25, 200, 'btc', 'prestigeguv10@gmail.com', 'pending', 'tnx60425a5699d2a', '', '2021-03-05 16:20:38'),
(26, 200, 'btc', 'prestigeguv10@gmail.com', 'pending', 'tnx60425ae6987a4', '', '2021-03-05 16:23:02'),
(27, 200, 'btc', 'prestigeguv10@gmail.com', 'pending', 'tnx60426ea116f16', '', '2021-03-05 17:47:13'),
(28, 200, 'btc', 'ayoungchief@gmail.com', 'completed', 'tnx604354bd06c10', 'jfhfkfhdkdjdhdkdhdhdtdhdkh', '2021-03-06 10:09:01'),
(29, 200, 'btc', 'prestigeguy10@gmail.com', 'pending', 'tnx6043b3358994c', '', '2021-03-06 16:52:05'),
(30, 8000, 'eth', 'prestigeguy10@gmail.com', 'pending', 'tnx604419a583f9c', '', '2021-03-07 00:09:09'),
(31, 8000, 'btc', 'prestigeguy10@gmail.com', 'pending', 'tnx604419f226c36', '', '2021-03-07 00:10:26'),
(32, 1000, 'pm', 'semblante@gmail.com', 'pending', 'tnx647ca376a90dc', '', '2023-06-04 14:45:10'),
(33, 2000, 'pm', 'Samtimor019@gmail.com', 'pending', 'tnx64b0ff4ab084e', '', '2023-07-14 07:54:50'),
(34, 6, 'btc', 'mcabanting9@gmail.com', 'pending', 'tnx651eaade6d1a8', '', '2023-10-05 12:23:58'),
(35, 8000, 'pm', 'almeralucinario1020@gmail.com', 'pending', 'tnx654c6699c5ec4', '', '2023-11-09 04:56:57'),
(36, 2000, 'btc', 'luisito.nuag@gmail.com', 'pending', 'tnx65b20d5ba9fc5', '', '2024-01-25 07:27:23');

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `adminmessage`
--
ALTER TABLE `adminmessage`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `btc`
--
ALTER TABLE `btc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `messageadmin`
--
ALTER TABLE `messageadmin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `package1`
--
ALTER TABLE `package1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `wbtc`
--
ALTER TABLE `wbtc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
COMMIT;

