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

START TRANSACTION;



--
-- Database: `takemeeasy_signalapp`
--

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

--
-- 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` decimal(10,2) NOT NULL DEFAULT 0.00,
  `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.00, 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', 30.00, 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-02 22:07:37'),
(3, 'Premium Quarterly', 'Premium', 50.00, 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-02 22:07:18'),
(4, 'Lifetime Access', 'Lifetime', 400.00, 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-02 22:06:57');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

