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

START TRANSACTION;



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

--
-- Table structure for table `monthly_plans`
--

CREATE TABLE `monthly_plans` (
  `id` int(5) NOT NULL,
  `3m_starterprice` varchar(255) NOT NULL,
  `3m_starterpricef` varchar(255) NOT NULL,
  `3m_midiumprice` varchar(255) NOT NULL,
  `3m_midiumpricef` varchar(255) NOT NULL,
  `3m_proprice` varchar(255) NOT NULL,
  `3m_propricef` varchar(255) NOT NULL,
  `plan_one` varchar(255) NOT NULL,
  `plan_two` varchar(255) NOT NULL,
  `plan_three` varchar(255) NOT NULL,
  `plan_one_features` varchar(255) NOT NULL,
  `plan_two_features` varchar(255) NOT NULL,
  `plan_three_features` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `monthly_plans`
--

INSERT INTO `monthly_plans` (`id`, `3m_starterprice`, `3m_starterpricef`, `3m_midiumprice`, `3m_midiumpricef`, `3m_proprice`, `3m_propricef`, `plan_one`, `plan_two`, `plan_three`, `plan_one_features`, `plan_two_features`, `plan_three_features`) VALUES
(1, '50.00', '59.50', '95.00', '110.00', '150.00', '180.00', 'Starter, Level: Getting Started', 'Midium, Level: Growing Investor', 'Pro, Level: Seasoned Trader', '10 Active Bots, Three strategies, Email Notificatios', '50 Active Bots, Seven strategies, Email / Phone Notificatios', 'Unlimited, All Available strategies, Email / Phone Notificatios'),
(2, '90.00', '110.00', '120.00', '150.00', '300.00', '350.00', '', '', '', '', '', ''),
(3, '180.00', '220.00', '240.00', '300.00', '600.00', '700.00', '', '', '', '', '', '');

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

--
-- Table structure for table `plan_definitions`
--

CREATE TABLE `plan_definitions` (
  `id` int(5) NOT NULL,
  `plan_one` varchar(255) NOT NULL,
  `level_one` varchar(244) NOT NULL,
  `plan_one_name` varchar(255) NOT NULL,
  `plan_two` varchar(255) NOT NULL,
  `level_two` varchar(255) NOT NULL,
  `plan_two_name` varchar(255) NOT NULL,
  `plan_three` varchar(255) NOT NULL,
  `level_three` varchar(255) NOT NULL,
  `plan_three_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `subscription_agreement`
--

CREATE TABLE `subscription_agreement` (
  `id` int(5) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `payer_email` varchar(255) NOT NULL,
  `subscription_id` varchar(255) NOT NULL,
  `subscription_validity` varchar(255) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `payment_gross` varchar(255) NOT NULL,
  `valid_from` varchar(255) NOT NULL,
  `valid_to` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

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

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

--
-- AUTO_INCREMENT for table `plan_definitions`
--
ALTER TABLE `plan_definitions`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscription_agreement`
--
ALTER TABLE `subscription_agreement`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;
COMMIT;

