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

START TRANSACTION;



--
-- Database: `takemeeasy_signalapp`
--

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

--
-- Table structure for table `ActiveSignals`
--

CREATE TABLE `ActiveSignals` (
  `id` int(11) NOT NULL,
  `Pair` varchar(20) NOT NULL,
  `Direction` varchar(10) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `CreateTime` varchar(20) NOT NULL,
  `GMT` varchar(10) NOT NULL,
  `EntryPrice` varchar(20) DEFAULT NULL,
  `TakeProfit1` varchar(20) DEFAULT NULL,
  `TakeProfit2` varchar(20) DEFAULT NULL,
  `TakeProfit3` varchar(20) DEFAULT NULL,
  `StopLoss` varchar(20) DEFAULT NULL,
  `ProfitLoss` varchar(20) DEFAULT NULL,
  `TradeResult` varchar(20) DEFAULT NULL,
  `LastUpdate` varchar(20) DEFAULT NULL,
  `SignalType` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ActiveSignals`
--

INSERT INTO `ActiveSignals` (`id`, `Pair`, `Direction`, `Status`, `CreateTime`, `GMT`, `EntryPrice`, `TakeProfit1`, `TakeProfit2`, `TakeProfit3`, `StopLoss`, `ProfitLoss`, `TradeResult`, `LastUpdate`, `SignalType`) VALUES
(2, 'EURUSD', 'Buy', 'active', '01/09/2024 10:00:00', 'GMT+4', '1.1100', '1.1150', '1.1200', '1.1050', '1.1000', '-20PIPS', 'Waiting', '01/09/2024', 'Free'),
(3, 'GBPUSD', 'Sell', 'active', '02/09/2024 11:00:00', 'GMT+4', '1.3200', '1.3100', '1.3050', '1.3250', '1.3300', '+15PIPS', 'Waiting', '02/09/2024', 'Free'),
(4, 'EURGBP', 'Buy', 'active', '03/09/2024 12:00:00', 'GMT+4', '0.8500', '0.8550', '0.8600', '0.8450', '0.8400', '-10PIPS', 'Waiting', '03/09/2024', 'Free'),
(5, 'EURJPY', 'Sell', 'active', '04/09/2024 13:00:00', 'GMT+4', '140.00', '139.50', '139.00', '140.50', '141.00', '+25PIPS', 'Waiting', '04/09/2024', 'Free'),
(6, 'GBPJPY', 'Buy', 'active', '05/09/2024 14:00:00', 'GMT+4', '155.00', '156.00', '157.00', '154.00', '153.00', '-30PIPS', 'Waiting', '05/09/2024', 'Premium'),
(7, 'USDJPY', 'Sell', 'active', '06/09/2024 15:00:00', 'GMT+4', '110.00', '109.50', '109.00', '110.50', '111.00', '+20PIPS', 'Waiting', '06/09/2024', 'Premium'),
(8, 'USDCAD', 'Buy', 'active', '07/09/2024 16:00:00', 'GMT+4', '1.2500', '1.2600', '1.2700', '1.2400', '1.2300', '-25PIPS', 'Waiting', '07/09/2024', 'Premium'),
(9, 'USDCHF', 'Sell', 'active', '08/09/2024 17:00:00', 'GMT+4', '0.9300', '0.9200', '0.9100', '0.9400', '0.9500', '+10PIPS', 'Waiting', '08/09/2024', 'Premium'),
(10, 'Indices', 'Buy', 'active', '09/09/2024 18:00:00', 'GMT+4', '12000', '12200', '12400', '11800', '11600', '-15PIPS', 'Waiting', '09/09/2024', 'Standard'),
(11, 'XAUUSD', 'Sell', 'active', '10/09/2024 19:00:00', 'GMT+4', '1800', '1750', '1700', '1850', '1900', '+5PIPS', 'Waiting', '10/09/2024', 'Standard'),
(12, 'GBPUSD', 'Buy', 'active', '11/09/2024 20:00:00', 'GMT+4', '1.3300', '1.3400', '1.3500', '1.3200', '1.3100', '-10PIPS', 'Waiting', '11/09/2024', 'Standard'),
(13, 'EURJPY', 'Sell', 'active', '12/09/2024 21:00:00', 'GMT+4', '141.00', '142.00', '143.00', '140.00', '139.00', '+30PIPS', 'Waiting', '12/09/2024', 'Standard'),
(14, 'EURUSD', 'Buy', 'active', '13/09/2024 22:00:00', 'GMT+4', '1.1200', '1.1250', '1.1300', '1.1150', '1.1100', '-5PIPS', 'Waiting', '13/09/2024', 'Lifetime'),
(15, 'GBPJPY', 'Sell', 'active', '14/09/2024 23:00:00', 'GMT+4', '155.50', '156.50', '157.50', '154.50', '153.50', '+10PIPS', 'Waiting', '14/09/2024', 'Lifetime'),
(16, 'USDJPY', 'Buy', 'active', '15/09/2024 00:00:00', 'GMT+4', '111.00', '112.00', '113.00', '110.00', '109.00', '-20PIPS', 'Waiting', '15/09/2024', 'Lifetime'),
(17, 'USDCAD', 'Sell', 'active', '16/09/2024 01:00:00', 'GMT+4', '1.2600', '1.2700', '1.2800', '1.2500', '1.2400', '+15PIPS', 'Waiting', '16/09/2024', 'Lifetime');

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

--
-- Table structure for table `ExpiredSignals`
--

CREATE TABLE `ExpiredSignals` (
  `id` int(11) NOT NULL,
  `Pair` varchar(20) NOT NULL,
  `Direction` varchar(10) NOT NULL,
  `Status` varchar(10) NOT NULL,
  `CreateTime` varchar(20) NOT NULL,
  `GMT` varchar(10) NOT NULL,
  `EntryPrice` varchar(20) DEFAULT NULL,
  `TakeProfit1` varchar(20) DEFAULT NULL,
  `TakeProfit2` varchar(20) DEFAULT NULL,
  `TakeProfit3` varchar(20) DEFAULT NULL,
  `StopLoss` varchar(20) DEFAULT NULL,
  `ProfitLoss` varchar(20) DEFAULT NULL,
  `TradeResult` varchar(20) DEFAULT NULL,
  `LastUpdate` varchar(20) DEFAULT NULL,
  `SignalType` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ExpiredSignals`
--

INSERT INTO `ExpiredSignals` (`id`, `Pair`, `Direction`, `Status`, `CreateTime`, `GMT`, `EntryPrice`, `TakeProfit1`, `TakeProfit2`, `TakeProfit3`, `StopLoss`, `ProfitLoss`, `TradeResult`, `LastUpdate`, `SignalType`) VALUES
(21, 'EURUSD', 'Buy', 'expired', '01/09/2023 10:00:00', 'GMT+4', '1.1100', '1.1150', '1.1200', '1.1050', '1.1000', '-20PIPS', 'Stop Loss', '01/09/2023', 'Free'),
(22, 'GBPUSD', 'Sell', 'expired', '02/09/2023 11:00:00', 'GMT+4', '1.3200', '1.3100', '1.3050', '1.3250', '1.3300', '+15PIPS', 'Take Profit', '02/09/2023', 'Premium'),
(23, 'EURGBP', 'Buy', 'expired', '03/09/2023 12:00:00', 'GMT+4', '0.8500', '0.8550', '0.8600', '0.8450', '0.8400', '-10PIPS', 'Stop Loss', '03/09/2023', 'Standard'),
(24, 'EURJPY', 'Sell', 'expired', '04/09/2023 13:00:00', 'GMT+4', '140.00', '139.50', '139.00', '140.50', '141.00', '+25PIPS', 'Take Profit', '04/09/2023', 'Lifetime'),
(25, 'GBPJPY', 'Buy', 'expired', '05/09/2023 14:00:00', 'GMT+4', '155.00', '156.00', '157.00', '154.00', '153.00', '-30PIPS', 'Stop Loss', '05/09/2023', 'Free'),
(26, 'USDJPY', 'Sell', 'expired', '06/09/2023 15:00:00', 'GMT+4', '110.00', '109.50', '109.00', '110.50', '111.00', '+20PIPS', 'Take Profit', '06/09/2023', 'Premium'),
(27, 'USDCAD', 'Buy', 'expired', '07/09/2023 16:00:00', 'GMT+4', '1.2500', '1.2600', '1.2700', '1.2400', '1.2300', '-25PIPS', 'Stop Loss', '07/09/2023', 'Standard'),
(28, 'USDCHF', 'Sell', 'expired', '08/09/2023 17:00:00', 'GMT+4', '0.9300', '0.9200', '0.9100', '0.9400', '0.9500', '+10PIPS', 'Take Profit', '08/09/2023', 'Lifetime'),
(29, 'Indices', 'Buy', 'expired', '09/09/2023 18:00:00', 'GMT+4', '12000', '12200', '12400', '11800', '11600', '-15PIPS', 'Stop Loss', '09/09/2023', 'Free'),
(30, 'XAUUSD', 'Sell', 'expired', '10/09/2023 19:00:00', 'GMT+4', '1800', '1750', '1700', '1850', '1900', '+5PIPS', 'Take Profit', '10/09/2023', 'Premium');

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

--
-- Table structure for table `Fairs`
--

CREATE TABLE `Fairs` (
  `id` int(11) NOT NULL,
  `Currency` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Fairs`
--

INSERT INTO `Fairs` (`id`, `Currency`) VALUES
(1, 'EURUSD'),
(2, 'GBPUSD'),
(3, 'EURGBP'),
(4, 'EURJPY'),
(5, 'GBPJPY'),
(6, 'USDJPY'),
(7, 'USDCAD'),
(8, 'USDCHF'),
(9, 'Indices'),
(10, 'US30'),
(11, 'US100'),
(12, 'Commodities'),
(13, 'XAUUSD');

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

--
-- Table structure for table `Plans`
--

CREATE TABLE `Plans` (
  `id` int(11) NOT NULL,
  `plan_name` varchar(50) NOT NULL,
  `plan_type` varchar(20) NOT NULL,
  `price` float NOT NULL DEFAULT 0,
  `duration_days` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `plan_status` varchar(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Plans`
--

INSERT INTO `Plans` (`id`, `plan_name`, `plan_type`, `price`, `duration_days`, `description`, `plan_status`, `created_at`, `updated_at`) VALUES
(1, 'Free Basic', 'Free', 0, 0, 'Access to daily forex signals.\\nLimited one-on-one support.\\nSuitable for beginners.\\nGet started with forex trading.', 'Active', '2024-09-02 19:11:10', '2024-09-02 22:08:06'),
(2, 'Standard Monthly', 'Standard', 11, 30, 'Full access to all forex signals.\\nReal-time updates and alerts.\\nMonthly market insights.\\nPriority support and resources.', 'Active', '2024-09-02 19:11:11', '2024-09-27 13:17:28'),
(3, 'Premium Quarterly', 'Premium', 2, 90, 'Premium forex signals with advanced features.\\nWeekly expert analysis.\\nExclusive trading tips and strategies.\\nPersonalized support from experts.', 'Active', '2024-09-02 19:11:11', '2024-09-27 13:17:23'),
(4, 'Lifetime Access', 'Lifetime', 1, 0, 'Lifetime access to all forex signals.\\nUnlimited updates and insights.\\nExclusive member-only resources.\\nPriority customer service and consultations', 'Active', '2024-09-02 19:11:11', '2024-09-27 13:17:31');

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

--
-- Table structure for table `Posts`
--

CREATE TABLE `Posts` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Posts`
--

INSERT INTO `Posts` (`id`, `title`, `content`, `image_url`, `created_at`) VALUES
(2, 'Stay Ahead with Expert Forex Trading Signals', 'Discover a comprehensive suite of forex trading signals that offer real-time insights and market analysis. Designed for both novice and seasoned traders, our signals guide you through the complexities of the forex market, helping you identify profitable opportunities and manage risks effectively. Make smarter trading decisions with our reliable signal service.', 'https://us.123rf.com/450wm/oanwongteerayut/oanwongteerayut2107/oanwongteerayut210700272/172133796-the-sign-or-symbol-of-bitcoin-cryptocurrency-with-and-fall-graph-for-bitcoin-blockchain-technologies.jpg?ver=6', '2024-09-19 20:46:19'),
(3, 'Transform Your Trading with Real-Time Forex Signals', 'Enhance your trading experience with up-to-date forex trading signals that keep you informed about market movements. Our signals come with detailed analyses, allowing you to make strategic decisions that align with current trends. Whether you\'re looking to enter or exit a position, our insights provide the support you need for successful trading.', 'https://tradingguide.co.uk/wp-content/uploads/2023/08/45-Best-Forex-Signal-Providers-in-the-UK.png', '2024-09-19 20:46:19'),
(4, 'Maximize Your Profits with Reliable Forex Trading Signals', 'Access expert forex trading signals that deliver real-time insights and analysis to elevate your trading game. Our signals help you navigate the forex market by identifying trends, potential entry and exit points, and risk management strategies. With our guidance, you can trade with confidence and aim for greater profitability.', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcS1XWXULXL08sAU6XpSfilN7Hb6qwAD9ivYIA&s', '2024-09-19 20:46:19'),
(5, 'Unlock Your Trading Potential', 'Join our forex trading community and access signals that help you unlock your trading potential. Our expert insights empower you to make informed decisions in a volatile market, increasing your chances of success.', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTzUyyBFkpJ45Q_0Np_Uqas50Dh8-WOF4AcoQ&s', '2024-09-19 20:46:19'),
(6, 'Stay Updated with Market Trends', 'Keep your trading strategy sharp with our timely forex signals. We analyze market trends to provide you with actionable insights, helping you stay ahead of the curve.', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSPQyLdwDq4NdQ6gX2gDq-0vVL341OYqqgs9A&s', '2024-09-19 20:46:19'),
(7, 'Get Instant Alerts for Forex Opportunities', 'Never miss a trading opportunity again! Our forex signals provide instant alerts for potential trades, ensuring you can act quickly in the fast-paced forex market.', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTxpPK7LyynE8naLwocMZ-x70y5YKmP4Odsn0eWZL9lKEPsjhGfSV7UfAJCFm9ESQ7BzGc&usqp=CAU', '2024-09-19 20:46:19'),
(8, 'Master the Art of Forex Trading', 'Dive into the world of forex trading with our expert signals and resources. Learn the strategies used by successful traders and apply them to your own trading approach.', 'https://m.media-amazon.com/images/I/51ld6nJPplL._SL500_.jpg', '2024-09-19 20:46:19'),
(9, 'Become a Confident Trader', 'With our forex signals, you can build confidence in your trading decisions. We provide clear guidance and market insights, helping you grow as a trader.', 'https://miro.medium.com/v2/resize:fit:1400/1*CXjh8bUGuP3feycPvbXJew.jpeg', '2024-09-19 20:46:19'),
(10, 'Achieve Your Trading Goals', 'Set and achieve your trading goals with our reliable forex signals. Our insights and analyses provide a solid foundation for your trading success.', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRTnSjaZrSYadDd-6WXKwLRG0mA6olUOt68iNLyIhHBU8xbHWohlbT-zZmhVSuF6iY0rs8&usqp=CAU', '2024-09-19 20:46:19');

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

--
-- Table structure for table `SignalComments`
--

CREATE TABLE `SignalComments` (
  `id` int(11) NOT NULL,
  `CommentType` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `SignalComments`
--

INSERT INTO `SignalComments` (`id`, `CommentType`) VALUES
(1, 'Take Profit'),
(2, 'Stop Loss'),
(3, 'Waiting');

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

--
-- Table structure for table `TransactionsHistory`
--

CREATE TABLE `TransactionsHistory` (
  `id` int(11) NOT NULL,
  `txn_id` varchar(255) NOT NULL,
  `buyer_email` varchar(255) NOT NULL,
  `amount1` int(15) NOT NULL,
  `currency1` varchar(10) NOT NULL,
  `status` int(11) NOT NULL,
  `plan_name` varchar(255) NOT NULL,
  `plan_duration` varchar(255) NOT NULL,
  `purchase_date` date NOT NULL,
  `expired_date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `TransactionsHistory`
--

INSERT INTO `TransactionsHistory` (`id`, `txn_id`, `buyer_email`, `amount1`, `currency1`, `status`, `plan_name`, `plan_duration`, `purchase_date`, `expired_date`, `created_at`) VALUES
(28, 'C14xpKJO4bgaBsAOKTj0', 'mdaliajgorshimul@gmail.com', 0, 'paypal', 100, 'Free Basic', '0', '2024-09-11', '2024-09-11', '2024-09-11 14:44:06'),
(29, 'CPII7IHH5TUN5VCP2L38MZ6DK4', 'julian@signifx.com', 1, 'USD', 100, 'Standard Monthly', '30', '2024-09-11', '2024-10-11', '2024-09-11 16:19:04'),
(30, 'uD0e7XWNvbwR5nhruXPu', 'mdaliajgorshimul@gmail.com', 0, 'paypal', 100, 'Free Basic', '0', '2024-09-27', '2024-09-27', '2024-09-27 13:15:00'),
(31, 'QgZBiUgtsBx81w7RIIcC', 'mdaliajgorshimul@gmail.com', 1, 'paypal', 100, 'Lifetime Access', '0', '2024-09-27', '2024-09-27', '2024-09-27 13:18:36');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

