-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 01, 2025 at 07:01 PM
-- Server version: 10.6.20-MariaDB-cll-lve
-- PHP Version: 8.3.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `clocubak_earnings`
--

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

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

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL DEFAULT 'admin',
  `password` text NOT NULL DEFAULT 'android908'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'Admore', 'burntless');

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

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int(11) NOT NULL,
  `user` varchar(40) NOT NULL,
  `path` text NOT NULL,
  `type` text NOT NULL,
  `time` text NOT NULL,
  `status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `igroup`
--

CREATE TABLE `igroup` (
  `id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `igroup`
--

INSERT INTO `igroup` (`id`, `name`) VALUES
(11, 'Cryptocurrency Investment'),
(9, 'Gold Investment '),
(12, 'Greens (Cannabis Investment)'),
(13, 'Non-fungible token (Promo Package)');

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

--
-- Table structure for table `investment`
--

CREATE TABLE `investment` (
  `id` int(11) NOT NULL,
  `name` varchar(90) NOT NULL,
  `percentage` double NOT NULL,
  `type` text NOT NULL,
  `min` double NOT NULL,
  `max` double NOT NULL,
  `igroup` varchar(40) DEFAULT NULL,
  `days` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `investment`
--

INSERT INTO `investment` (`id`, `name`, `percentage`, `type`, `min`, `max`, `igroup`, `days`) VALUES
(15, 'Gold Starter 1', 2, 'Daily', 10000, 30000, 'Gold Investment ', 90),
(16, 'Gold Starter 2', 2.5, 'Daily', 50000, -1, 'Gold Investment ', 90),
(17, 'Entry Package ', 0.65, 'Daily', 200, 500, 'Cryptocurrency Investment', 7),
(18, 'Starter Package', 0.9, 'Daily', 1000, 9999, 'Cryptocurrency Investment', 14),
(19, 'Enthusiast Package', 1.2, 'Daily', 10000, 29999, 'Cryptocurrency Investment', 14),
(22, 'Pro Plan', 1.5, 'Daily', 50000, -1, 'Cryptocurrency Investment', 30),
(24, 'Farm Size (100-1000 Plants)', 1, 'Daily', 200, 4999, 'Greens (Cannabis Investment)', 185),
(25, 'Farm Size (1100-5000 Plants)', 1.5, 'Daily', 5000, 19999, 'Greens (Cannabis Investment)', 365),
(26, 'Farm Size (5100-50,000 Plants)', 2.1, 'Daily', 20000, 100000, 'Greens (Cannabis Investment)', 365);

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `date` text NOT NULL,
  `package` text NOT NULL,
  `paymentMode` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `user` varchar(40) NOT NULL,
  `confirmedDate` text DEFAULT NULL,
  `roi` double DEFAULT NULL,
  `days` int(11) DEFAULT NULL,
  `proof` text DEFAULT NULL,
  `iType` text DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `cReturns` double DEFAULT NULL,
  `wBalance` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `loginrecords`
--

CREATE TABLE `loginrecords` (
  `id` int(11) NOT NULL,
  `user` varchar(40) NOT NULL,
  `browser` text DEFAULT NULL,
  `device` text DEFAULT NULL,
  `ip` text DEFAULT NULL,
  `location` text DEFAULT NULL,
  `timeDate` text NOT NULL,
  `brand` text DEFAULT NULL,
  `model` text DEFAULT NULL,
  `os` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `loginrecords`
--

INSERT INTO `loginrecords` (`id`, `user`, `browser`, `device`, `ip`, `location`, `timeDate`, `brand`, `model`, `os`) VALUES
(19552, 'interiorpatricia@freesourcecodes.com', 'Firefox 134.0', 'desktop', '146.70.99.251', 'Switzerland, Swiss Confederation', '1734691466', 'Not set', 'Not set', 'Windows 10');

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

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

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `body` text NOT NULL,
  `date` text NOT NULL,
  `fav` text NOT NULL DEFAULT 'false'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `news` (`id`, `title`, `body`, `date`, `fav`) VALUES
(17, 'Gold Rises 2% in a Week; ', 'Precious metals climbed as a group. Gold, silver and palladium posted sharp weekly gains. Gold traded 2% higher this week after 1% last week', '1618722664', 'false');

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

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

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `link` text NOT NULL,
  `title` text NOT NULL,
  `label` text NOT NULL,
  `seen` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `paymentwallet`
--

CREATE TABLE `paymentwallet` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `address` text NOT NULL,
  `symbol` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paymentwallet`
--

INSERT INTO `paymentwallet` (`id`, `name`, `address`, `symbol`) VALUES
(56, 'XRP', 'rUzWJkXyEtT8ekSSxkBYPqCvHpngcy6Fks ...... TAG: 1214980', 'XRP'),
(57, 'Cardano', 'Ae2tdPwUPEZGxgWZS9M9wy8BQYBjDp9zAAsSjuJxfCayH26WEp6yDjE2Cik', 'ADA'),
(58, 'Binance Coin', 'bnb136ns6lfw4zs5hg4n85vdthaad7hq5m4gtkgf23 ..... MEMO: 649073776', 'BNB'),
(60, 'TRON', 'TPwPsCQR14UnE4LNY93nqkWbgmmrsoLgwT', 'TRX'),
(61, 'Stellar', 'GBGII2C7M4TOEC2MVAZYG3TRFM3ATCCEWANSN4Q3AHEX3NRKXJCVZDEV..... MEMO: 180953', 'XLM'),
(62, 'Dogecoin', 'ADYS9vxnn4JKgrYxMkBuEvauiU5REhq8go', 'DOGE'),
(68, 'Tether', 'Usdt-Trc20; TPwPsCQR14UnE4LNY93nqkWbgmmrsoLgwT ', 'usdt'),
(70, 'Gala', 'Gala-Erc20; 0xffb661702968b638800000d783c3287af8fd5359', 'gala'),
(71, 'Polkadot', '17gPjTxEfDmbL2py3NeXZoWSazBVmuNrYUEcfeXsYkHX92B', 'dot'),
(72, 'Shiba Inu', 'Shib-Erc20; 0xffb661702968b638800000d783c3287af8fd5359', 'shib'),
(73, 'Bitcoin', '38Zkv9BN8XbXG7Yut62hrc3TgXxbXq2ies', 'btc'),
(74, 'Ethereum', '0xD1C45f3be963ACD8ECCaA5499619E6B8fe70A7Cd', 'eth'),
(75, 'Bitcoin Cash', '3AtNSJaLHmEkDz6HKAktCkUE43HLTaaPm4', 'bch'),
(76, 'Solana', '9PkjscGYP4Jt1aNvVyU5aZSGRepQE7vkbhCxDR3zAAAQ', 'sol'),
(77, 'Polygon', 'MATIC-ERC20: 0xffb661702968b638800000d783c3287af8fd5359', 'matic'),
(78, 'Arweave', 'OSj-8xtceEBQF_L1gp40b4yifOswNXSxhsWIGdtsL84', 'ar'),
(79, 'Decentraland', 'MANA-ERC20: 0xffb661702968b638800000d783c3287af8fd5359', 'mana'),
(80, 'Avalanche', 'AVAX X-Chain: X-avax1flnxrjpwr5d0w9get2fgfvveqk9nlzmqg9vv2k', 'AVAX'),
(81, 'USD Coin', '0xffb661702968b638800000d783c3287af8fd5359 (USDC-ERC20)', 'usdc'),
(82, 'USD Coin', 'TPwPsCQR14UnE4LNY93nqkWbgmmrsoLgwT (USDC-TRC20)', 'usdc');

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

--
-- Table structure for table `ptoken`
--

CREATE TABLE `ptoken` (
  `id` int(11) NOT NULL,
  `user` varchar(30) NOT NULL,
  `date` text NOT NULL,
  `token` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ptoken`
--

INSERT INTO `ptoken` (`id`, `user`, `date`, `token`) VALUES
(31, 'smailtravel65@gmail.com', '1638436462', '191369'),
(32, 'bbwellness2013@gmail.com', '1638577864', '941184'),
(80, 'mmichael@live.com.au', '1641269445', '121169'),
(87, 'anothernameandface@gmail.com', '1654225386', '646673'),
(88, 'anothernameandface@gmail.com', '1654225432', '126896');

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

--
-- Table structure for table `referral`
--

CREATE TABLE `referral` (
  `id` int(11) NOT NULL,
  `user` varchar(40) NOT NULL,
  `guest` text NOT NULL,
  `date` text NOT NULL,
  `status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `emailVerification` tinyint(1) NOT NULL DEFAULT 1,
  `kyc` tinyint(1) NOT NULL DEFAULT 1,
  `withdrawal` tinyint(1) NOT NULL DEFAULT 0,
  `liveChat` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `settings` (`id`, `emailVerification`, `kyc`, `withdrawal`, `liveChat`) VALUES
(1, 1, 0, 0, 0);

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

--
-- Table structure for table `token`
--

CREATE TABLE `token` (
  `id` int(11) NOT NULL,
  `user` varchar(40) NOT NULL,
  `date` text NOT NULL,
  `token` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `token`
--

INSERT INTO `token` (`id`, `user`, `date`, `token`) VALUES
(18, 'interiorpatricia@freesourcecodes.com', '1734254134', '815812'),
(19, 'ghanapeertopeer@gmail.com', '1735719644', '742783');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` varchar(40) NOT NULL,
  `password` text NOT NULL,
  `status` text NOT NULL,
  `phone` text NOT NULL,
  `dateCreated` text NOT NULL,
  `country` text NOT NULL,
  `wallet` text NOT NULL,
  `image` text NOT NULL DEFAULT 'assets/img/avatar.svg',
  `fa` text DEFAULT NULL,
  `secret` text DEFAULT NULL,
  `wSettings` text DEFAULT 'Weekly',
  `istatus` text DEFAULT NULL,
  `imessage` text DEFAULT NULL,
  `gender` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `password`, `status`, `phone`, `dateCreated`, `country`, `wallet`, `image`, `fa`, `secret`, `wSettings`, `istatus`, `imessage`, `gender`) VALUES
(427, 'James', 'interiorpatricia@freesourcecodes.com', 'D=;P+SF@q47gx)M', 'newUser', '09090901199', '1734254134', 'Algeria', '695597b5cdf037bac984a5d774', 'assets/img/avatar.svg', NULL, NULL, 'Weekly', NULL, NULL, 'male'),
(428, 'Stanley Orca', 'ghanapeertopeer@gmail.com', 'qazqaz10', 'newUser', '0123849573', '1735719644', 'Albania', '4ee833ea303f0d888c2768d676', 'assets/img/avatar.svg', NULL, NULL, 'Weekly', NULL, NULL, 'male');

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

--
-- Table structure for table `usettings`
--

CREATE TABLE `usettings` (
  `tor` tinyint(1) NOT NULL DEFAULT 1,
  `twofa` tinyint(1) NOT NULL DEFAULT 0,
  `news` tinyint(1) NOT NULL DEFAULT 1,
  `user` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `user` varchar(40) NOT NULL,
  `amount` double NOT NULL,
  `date` text NOT NULL,
  `status` text NOT NULL,
  `proof` text NOT NULL,
  `sender` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `user` varchar(40) NOT NULL,
  `amount` double NOT NULL,
  `wallet` text DEFAULT NULL,
  `date` text NOT NULL,
  `status` text NOT NULL,
  `type` text DEFAULT NULL,
  `receiver` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`);

--
-- Indexes for table `igroup`
--
ALTER TABLE `igroup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `investment`
--
ALTER TABLE `investment`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `igroup` (`igroup`);

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`);

--
-- Indexes for table `loginrecords`
--
ALTER TABLE `loginrecords`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`);

--
-- 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 `paymentwallet`
--
ALTER TABLE `paymentwallet`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `referral`
--
ALTER TABLE `referral`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`);

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

--
-- Indexes for table `token`
--
ALTER TABLE `token`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`);

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

--
-- Indexes for table `usettings`
--
ALTER TABLE `usettings`
  ADD KEY `user` (`user`);

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

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user` (`user`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `documents`
--
ALTER TABLE `documents`
  ADD CONSTRAINT `documents_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `investment`
--
ALTER TABLE `investment`
  ADD CONSTRAINT `investment_ibfk_1` FOREIGN KEY (`igroup`) REFERENCES `igroup` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `invoice`
--
ALTER TABLE `invoice`
  ADD CONSTRAINT `invoice_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `loginrecords`
--
ALTER TABLE `loginrecords`
  ADD CONSTRAINT `loginrecords_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `referral`
--
ALTER TABLE `referral`
  ADD CONSTRAINT `referral_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `token`
--
ALTER TABLE `token`
  ADD CONSTRAINT `token_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `usettings`
--
ALTER TABLE `usettings`
  ADD CONSTRAINT `usettings_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `wallet`
--
ALTER TABLE `wallet`
  ADD CONSTRAINT `wallet_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD CONSTRAINT `withdrawals_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`email`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
