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

START TRANSACTION;



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

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

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

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

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

CREATE TABLE `btc` (
  `id` int(11) NOT NULL,
  `offer_id` int(11) NOT NULL,
  `btc` double NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `buyer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `paymode` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `recmode` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `amount_paid` double NOT NULL,
  `type` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `usd` double NOT NULL,
  `image` tinyblob NOT NULL,
  `btctnx` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `tnxid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `refcode` varchar(111) COLLATE utf8_unicode_ci NOT NULL,
  `referred` varchar(111) COLLATE utf8_unicode_ci NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `btc` (`id`, `offer_id`, `btc`, `username`, `buyer`, `paymode`, `recmode`, `amount_paid`, `type`, `usd`, `image`, `btctnx`, `email`, `status`, `tnxid`, `refcode`, `referred`, `date`) VALUES
(74, 0, 0, 'Prestigeguy', 'Prestigeguym', 'Bitcoin (BTC)', 'Ethereum (ETH),Bitcoin diamond (BCD),Elastos (ELA)', 1050, 'sale', 1000, '', 'jhdghxhgm ', 'prestigeguy10@gmail.com', 'sold', 'tnx62545799d09be', '', '', '2022-04-11 16:30:17'),
(75, 74, 0, 'Prestigeguy', 'Prestigeguym', 'Elastos (ELA)', 'Bitcoin (BTC)', 1050, 'sold', 1000, '', 'jhdghxhgm ', 'prestigeguv10@gmail.com', 'approved', 'tnx62545b90d29c8', '', '', '2022-04-11 16:47:12'),
(76, 0, 0, 'Prestigeguym', 'Prestigeguy', 'Bitcoin (BTC)', 'Ethereum (ETH)', 525, 'buy', 500, '', 'jhdghxhgm ', 'prestigeguv10@gmail.com', 'sold', 'tnx62545c326bbd0', '', '', '2022-04-11 16:49:54'),
(77, 76, 0, 'Prestigeguym', 'Prestigeguy', 'Ethereum (ETH)', 'Bitcoin (BTC)', 0, 'sold', 0, '', 'jhdghxhgm ', 'prestigeguy10@gmail.com', 'pending', 'tnx62545cebb631e', '', '', '2022-04-11 16:52:59'),
(78, 76, 0, 'Prestigeguym', 'Prestigeguy', 'Ethereum (ETH)', 'Bitcoin (BTC)', 0, 'sold', 0, '', 'jhdghxhgm', 'prestigeguy10@gmail.com', 'pending', 'tnx62545d3de21fc', '', '', '2022-04-11 16:54:21'),
(79, 76, 0, 'Prestigeguym', 'Prestigeguy', 'Ethereum (ETH)', 'Bitcoin (BTC)', 0, 'sold', 50, '', 'jhdghxhgmjj', 'prestigeguy10@gmail.com', 'pending', 'tnx62545eeee7ab5', '', '', '2022-04-11 17:01:34'),
(80, 76, 0, 'Prestigeguym', 'Prestigeguy', 'Ethereum (ETH)', 'Bitcoin (BTC)', 525, 'sold', 788, '', 'jhdghxhgmjj', 'prestigeguy10@gmail.com', 'pending', 'tnx6254611753dc5', '', '', '2022-04-11 17:10:47'),
(81, 76, 0, 'Prestigeguym', 'Prestigeguy', 'Ethereum (ETH)', 'Bitcoin (BTC)', 1107.75, 'sold', 1055, '', 'jhdghxhgm ', 'prestigeguy10@gmail.com', 'approved', 'tnx625462f7d9a47', '', '', '2022-04-11 17:18:47');

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

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

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

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

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

CREATE TABLE `package1` (
  `id` int(6) NOT NULL,
  `email` varchar(122) COLLATE utf8_unicode_ci NOT NULL,
  `pname` varchar(122) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_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);

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

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

CREATE TABLE `settings` (
  `id` int(200) NOT NULL,
  `sname` varchar(200) NOT NULL,
  `wl` int(200) NOT NULL,
  `rb` int(200) 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;

--
-- 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, 'ecoin45.com', 200, 20, '', '', 'Escrow Trust', '', 'admin@ecoin45.com', '', 'Welcome to Trustdeck', '', '2009', '../../vendor/twilio/sdk/Services/header.php', 'https://scriptsdemo.website/superadmin/btc_activation.php', '../../vendor/twilio/sdk/Services/initializer.php', '');

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

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

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `asset` varchar(255) NOT NULL,
  `wallet` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `wallet` (`id`, `asset`, `wallet`) VALUES
(4, 'Bitcoin (BTC)', 'bc1qljvt7v8a3ylwwpqdhekk97ghgg4fa8uw6mppmt'),
(5, 'Ethereum (ETH)', '0x0669e527f8236EC15977f73912D5AfE93B34549a'),
(6, 'Bitcoin diamond (BCD)', '1CKSCpWXP5Qz9eSpgSqtc4Em1CMGe5p9bH'),
(8, 'Elastos (ELA)', 'Ec1QKeYkwUPGqc7HT1N48SrUQmVJp6ZBcD'),
(9, 'Binance Coin (BNB)', 'bnb1dfh0urksx4jr64fchnl350nsc7p6mfpr2mgd9t'),
(10, 'Cardano (ADA)', 'addr1qxvzp0sn9f0gt7dk459f3hukc2klq48wumz2jehjk30fak7v3d5sfnud2g3p9yc9f2r60zrdzkgsdcsynauhpepqsarsk3sgau'),
(11, 'Bitcoin Gold (BTG)', 'GNEdmpZaN8AV716m8hVM34WUfc18hZBxgR'),
(12, 'Stellar (XLM)', 'GA2QXKLGXI6WQJ54MAXWMWFI4O5WQJFJJZ6FRZF5LMVQJ4SSCRNDLKK7'),
(13, 'Dogecoin (DOGE)', 'DRR3jt59VgMFbtNvoCTssnGBpN5eE5Apmc'),
(14, 'Ripple (XRP)', 'rDpHpajqNJWH8D5RD61ZFs8cB3QYksnRZQ'),
(15, 'Litecoin (LTC)', 'LbGRDpf9YeDyDDsonVWbrDzVUVeBLxDkYP'),
(16, 'Tether (USDT)', '0x96d2f6520Fb26aEDadF5Fc4011D5E8eB6B442027'),
(18, 'Ergo (ERG)', '9eZfXtVpSVgNSaZCUfqM32ctzt3uJjnMV9HLJzJqs7q7gz3rxks'),
(19, 'USD Coin (USDC)', '0xaea1bd5d116a895cf029a39a7e8f82ea8a7822e3'),
(20, 'Avalanche (AVAX)', 'X-avax1edsjxkxwvzqhv0q8pu67exnvmynkypcmwdk0ww'),
(21, 'Palkadot (DOT)', '14Uqc4xycoofVSgxZ5hySW8QM83oCUkicCtrEm9YhkAjrUUE'),
(22, 'Tron (TRX)', 'TP46bEMs2wmTCeG2Lr7h488T2FuHMtxkym'),
(24, 'SocialGood (SG)', '0xb114aFf02762b5731c6C14273b7e10971ae3023D');

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

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

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

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

INSERT INTO `wbtc` (`id`, `moni`, `mode`, `email`, `status`, `tnx`, `wal`, `date`) VALUES
(6, 36000, 'Bitcoin (BTC)', 'geunimjae@gmail.com', 'completed', 'tnx6201291e5141b', 'Ffghjjkjug', '2022-02-07 14:13:50');

--
-- 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 `wallet`
--
ALTER TABLE `wallet`
  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(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

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

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

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

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

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

