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

START TRANSACTION;



--
-- Database: `lovekbkg_recomm`
--

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `email` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `subject` text DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `subscriptionid` int(11) NOT NULL,
  `heading` text DEFAULT NULL,
  `price` text DEFAULT NULL,
  `records` text DEFAULT NULL,
  `payment_status` enum('paid','unpaid') NOT NULL DEFAULT 'unpaid',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `userid`, `subscriptionid`, `heading`, `price`, `records`, `payment_status`, `created_at`, `updated_at`) VALUES
(8, 106, 3, 'Basic', '9.99', '50', 'paid', '2024-08-08 22:50:19', '2024-08-12 17:33:41');

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

--
-- Table structure for table `records`
--

CREATE TABLE `records` (
  `id` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `postal_code` text DEFAULT NULL,
  `state` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `mls_number` text DEFAULT NULL,
  `commission` text DEFAULT NULL,
  `type` text DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `price` text DEFAULT NULL,
  `payment_status` enum('paid','unpaid') DEFAULT NULL,
  `record_type` enum('subscription','withoutsubscription') DEFAULT NULL,
  `bulk` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `records`
--

INSERT INTO `records` (`id`, `userid`, `name`, `phone`, `address`, `postal_code`, `state`, `city`, `mls_number`, `commission`, `type`, `status`, `price`, `payment_status`, `record_type`, `bulk`, `created_at`, `updated_at`) VALUES
(10, 106, 'Cassandra Bright', '+1 (453) 996-5177', 'Laborum nisi delect', '53', 'Officia mollitia dig', 'Totam sit et irure s', '675', '35', '%', '1', '1', 'paid', 'withoutsubscription', NULL, '2024-08-08 22:47:04', '2024-08-12 08:27:28'),
(11, 106, 'Cairo Pugh', '+1 (474) 333-7485', 'Laborum quam similiq', '45', 'Ad eu in repellendus', 'Velit aute et dolore', '404', '95', '$', '1', '1', 'paid', 'withoutsubscription', NULL, '2024-08-08 22:47:33', '2024-08-12 08:23:50'),
(12, 106, 'Ruth Stephens', '+1 (389) 124-3868', 'Rerum rerum modi ut', '25', 'Cillum proident aut', 'Optio aute odio sun', '582', '93', '%', '1', NULL, NULL, 'subscription', NULL, '2024-08-08 22:50:36', '2024-08-08 22:50:36');

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `location` varchar(255) NOT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `logo` varchar(255) NOT NULL,
  `favicon` varchar(255) NOT NULL,
  `adminlogo` text DEFAULT NULL,
  `footer_description` text NOT NULL,
  `privacy` text DEFAULT NULL,
  `policy` text DEFAULT NULL,
  `terms_condition` text DEFAULT NULL,
  `tiny_api_key` text DEFAULT NULL,
  `google_analytics_code` text DEFAULT NULL,
  `stripe_public` text DEFAULT NULL,
  `stripe_secret` text DEFAULT NULL,
  `referral_discount` int(11) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `allow_purchasing` enum('YES','NO') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `name`, `phone`, `email`, `location`, `facebook`, `twitter`, `instagram`, `whatsapp`, `logo`, `favicon`, `adminlogo`, `footer_description`, `privacy`, `policy`, `terms_condition`, `tiny_api_key`, `google_analytics_code`, `stripe_public`, `stripe_secret`, `referral_discount`, `remember_token`, `allow_purchasing`, `created_at`, `updated_at`) VALUES
(1, 'Real Estate Commission Database', '1234567890', 'chkhateeb96@gmail.com', '4517 Washington Ave. Manch ester, Kentucky 39495', NULL, NULL, NULL, NULL, '1723013295logo.png', '1723013251favicon.png', '1713885286logo.png', 'Welcome to GRO-MART: Your one-stop shop for all things fresh and fabulous! From farm-fresh produce to pantry staples, we\'ve got you covered. Shop now for convenient delivery and unbeatable quality. Let\'s make grocery shopping a breeze!', '<h2>Privacy Commitment and Policy Overview</h2>\r\n<div class=\"single-content\">\r\n<h3>Protecting Your Information</h3>\r\n<p>At Supreme Asset Management Group, we prioritize the privacy and security of your personal information. Our Privacy Policy outlines how we collect, use, and protect the data you provide to us. Rest assured, we are committed to maintaining the confidentiality and integrity of your information.<br>When you interact with our website or utilize our services, we may collect certain personal information, such as your name, contact details, and preferences. This information is gathered with your consent and is used solely for the purpose of providing you with the best possible service experience. We do not share your information with third parties for marketing purposes without your explicit consent.</p>\r\n<p>To safeguard your data, we employ industry-standard security measures and protocols. Our website is secured with encryption technology to protect against unauthorized access, and we regularly review and update our security practices to mitigate risks. While we strive to maintain the highest level of security, please note that no method of transmission over the internet is entirely foolproof.<br>Your trust is paramount to us, and we are committed to earning and maintaining it. By entrusting us with your personal information, you can be confident that we will handle it with the utmost care and respect for your privacy. If you have any questions or concerns about our Privacy Policy or how we handle your data, please don\'t hesitate to reach out to us.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Our Commitment to Your Privacy</h3>\r\n<p>At Supreme Asset Management Group, safeguarding your personal information is at the core of our business practices. Our Data Protection Policy outlines our commitment to protecting your privacy and ensuring the security of your data.<br>When you provide us with personal information, such as your name, contact details, and preferences, we collect and use it responsibly, in accordance with applicable privacy laws and regulations. We do not sell, rent, or share your information with third parties for marketing purposes without your explicit consent.</p>\r\n<p>To maintain the confidentiality and integrity of your data, we implement robust security measures, including encryption technology, access controls, and regular audits. While we take every precaution to protect your information, it\'s important to note that no system is entirely immune to security breaches, and we cannot guarantee absolute security.<br>Your privacy matters to us, and we are committed to earning and preserving your trust. If you have any questions or concerns about how we handle your data or our Data Protection Policy, please feel free to contact us. We value your feedback and are here to assist you in any way we can.</p>\r\n</div>', '<p><br>販売業者 &nbsp; &nbsp;合同会社　The Moon Lights<br>代表責任者 &nbsp; &nbsp;高橋伸子<br>所在地 &nbsp; &nbsp;〒103-0026 東京都中央区日本橋兜町17-2<br>電話番号 &nbsp; &nbsp;080-7593-0329<br>電話受付時間 &nbsp; &nbsp;9：00〜18：00(土・日・祝日以外)<br>メールアドレス &nbsp; &nbsp;support@themoonlights.jp<br>サイトURL &nbsp; &nbsp;https://www.themoonlights.jp<br>販売価格 &nbsp; &nbsp;各商品の紹介ページに記載している価格とします。<br>商品代金以外に必要な料金 &nbsp; &nbsp;消費税、送料（全国一律800円）<br>引き渡し時期 &nbsp; &nbsp;ご注文日から製作依頼をし、1ヶ月以内に発送します。<br>お支払い方法とお支払いの時期 &nbsp; &nbsp;クレジットカード決済：ご注文時にお支払いが確定します。<br>返品・交換・キャンセルについて &nbsp; &nbsp;商品発送後の返品・交換・キャンセルには、基本的に対応しておりません。<br>商品に欠陥がある場合のみ交換が可能ですのでご連絡ください。<br>返品期限 &nbsp; &nbsp;商品到着日から7日以内にご連絡ください。<br>返品送料 &nbsp; &nbsp;商品に欠陥がある場合は、弊社で負担いたします。<br>それ以外は、お客さまのご負担になります。<br>製品・役務の種類 &nbsp; &nbsp;①情報・教育プログラム<br>②体を整えるツール：純銀棒<br>③体を整えるツール：純金棒</p>\r\n<p>特定負担に関する事項 &nbsp; &nbsp;①紹介活動が行える会員<br>登録に係る初期費用100,000円、次月以降毎月10,000円以上のセミナー代金、レベルアップ費200,000円以上<br>特定利益の計算方法（報酬）<br>報酬（特定利益）は、The Moon Lightsが提供する初期登録費用と毎月のセミナー代金から会員のレベルによって報酬還元率が変わり、紹介者実績により計算し支払われます。<br>【条件1】 あなたが特定商取引法ならびに関連法規、「会員規約」を遵守し、弊社との信頼関係のもと健全なビジネス活動を行っていること。<br>【条件2】 あなたが毎月のセミナー代金を支払い、有効期間が発生していること。<br>【条件3】 あなたが会員であること。<br>【条件4】 あなたが直接紹介した人が1人以上いて、かつそのうち1人以上に有効期間があること。<br>【条件5】会社が会員の健全なビジネス活動のために適宜行う、「概要書面」「会員規約」などの改定やその他重要な決定事項の通知が、あなたに常に届く状態であること。</p>\r\n<p>※【条件5】の通知が会員都合により届かない状況にある場合、その会員が健全なビジネス活動が可能かをThe Moon Lightsにて審議し、不可能との結論になった場合、The Moon Lightsは報酬の支払いを停止することができます。また、ビジネス活動が行われていない場合や、関連法規や会員規約に違反した、または、The Moon Lightsとの信頼関係を崩す行為が発覚した場合は、その事実確認の期間においても、The Moon Lightsは報酬の支払いを減額ならびに停止することができます。また、停止された報酬の復益は、弊社の審査・承認により決定されます。<br>ボーナスの種類は以下の通りです。<br>【レベルアップボーナス】<br>詳細は、概要書面および会員規約をご参照ください。<br>（2023年6月15日現在）</p>\r\n<p>&nbsp;</p>', '<h1><strong>Navigating Our Terms and Conditions</strong></h1>\r\n<div class=\"single-content\">\r\n<h3>Agreement to Terms of Service</h3>\r\n<p>Welcome to Supreme Asset Management Group. These Terms &amp; Conditions govern your use of our website and services. By accessing or using our website, you agree to be bound by these Terms &amp; Conditions, as well as our Privacy Policy. If you do not agree with any part of these terms, please refrain from using our website.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Use of Website</h3>\r\n<p>You must be at least 18 years old to use our website and services. By using our website, you represent that you are of legal age to form a binding contract.<br>You agree to use our website and services for lawful purposes only and in compliance with all applicable laws and regulations.<br>You are responsible for maintaining the confidentiality of your account credentials and for all activities that occur under your account.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Intellectual Property</h3>\r\n<p>All content on our website, including text, graphics, logos, images, and software, is the property of Supreme Asset Management Group and is protected by copyright and other intellectual property laws.<br>You may not reproduce, distribute, modify, or transmit any part of our website or its contents without our prior written consent.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Disclaimer of Warranties</h3>\r\n<p>Our website and services are provided on an \"as is\" and \"as available\" basis, without any warranties of any kind, either express or implied.<br>We make no representations or warranties about the accuracy, reliability, completeness, or timeliness of the content on our website or the results that may be obtained from using our services.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Limitation of Liability</h3>\r\n<p>In no event shall Supreme Asset Management Group be liable for any indirect, incidental, special, or consequential damages arising out of or in connection with your use of our website or services.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Governing Law</h3>\r\n<p>These Terms &amp; Conditions shall be governed by and construed in accordance with the laws of USA, without regard to its conflict of law provisions.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Changes to Terms</h3>\r\n<p>We reserve the right to update or modify these Terms &amp; Conditions at any time without prior notice. Your continued use of our website and services after any changes indicates your acceptance of the updated terms.</p>\r\n</div>\r\n<div class=\"single-content\">\r\n<h3>Contact Us</h3>\r\n<p>If you have any questions or concerns about these Terms &amp; Conditions, please contact us. Thank you for reviewing our Terms &amp; Conditions. We appreciate your cooperation and trust in Supreme Asset Management Group.</p>\r\n</div>', 'slqzq9p4jfyu3f1nzvbomd2qq198chen520bsjv05lggwszl', '<!-- Google tag (gtag.js) -->', 'pk_test_51HqZ6uEGbslLkEmzXyduMaJlHooG46wHWJbrfXVijuRQV0CRQODnmt2sY7iV3W1u30rE3OIFYatcIoPJEyHZfP6e00psa8NlQp', 'sk_test_51HqZ6uEGbslLkEmz6Y1g5kxIinsFqyrGrDo5ZYznhvkv6HFp98Ae2Zrl0iVpBjXEud416TsT54uEz5TqMupPRNxy00UmniiJfH', 10, NULL, 'NO', '2023-03-20 06:55:50', '2024-08-08 23:00:39');

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

--
-- Table structure for table `stripe_customers`
--

CREATE TABLE `stripe_customers` (
  `id` int(11) NOT NULL,
  `user_id` text DEFAULT NULL,
  `customer_id` text DEFAULT NULL,
  `subscription_id` text DEFAULT NULL,
  `orderid` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `stripe_customers`
--

INSERT INTO `stripe_customers` (`id`, `user_id`, `customer_id`, `subscription_id`, `orderid`, `created_at`, `updated_at`) VALUES
(2, '102', 'cus_QchnID5hDB0O3m', '7', '3', '2024-08-08 13:11:23', '2024-08-08 13:11:23'),
(3, '102', 'cus_QcpLdmojBMN5J8', '3', '4', '2024-08-08 20:59:24', '2024-08-08 20:59:24'),
(4, '106', 'cus_QcpmOz7lqye9Wl', '6', '5', '2024-08-08 21:26:55', '2024-08-08 21:26:55'),
(5, '106', 'cus_QcqMGJOx21Xu9y', '3', '6', '2024-08-08 22:03:00', '2024-08-08 22:03:00'),
(6, '106', 'cus_Qcr6d9y3MFpLVh', '3', '7', '2024-08-08 22:49:14', '2024-08-08 22:49:14'),
(7, '106', 'cus_Qcr7V0Q9ENp4E4', '3', '8', '2024-08-08 22:50:19', '2024-08-08 22:50:19');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int(11) NOT NULL,
  `heading` text DEFAULT NULL,
  `price` text DEFAULT NULL,
  `records` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `heading`, `price`, `records`, `slug`, `created_at`, `updated_at`) VALUES
(3, 'Basic', '9.99', '50', 'basic', '2024-08-07 03:14:13', '2024-08-07 03:14:13'),
(6, 'Advanced', '20', '100', 'advanced', '2024-08-07 03:30:11', '2024-08-07 03:30:11'),
(7, 'Premium', '50', '500', 'premium', '2024-08-07 03:30:36', '2024-08-07 03:30:36'),
(500, 'Custom', '1', '1', 'custom', '2024-08-07 03:35:44', '2024-08-08 18:40:12');

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

--
-- Table structure for table `subscriptions_detail`
--

CREATE TABLE `subscriptions_detail` (
  `id` int(11) NOT NULL,
  `subscriptionid` int(11) NOT NULL,
  `detail` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscriptions_detail`
--

INSERT INTO `subscriptions_detail` (`id`, `subscriptionid`, `detail`, `created_at`, `updated_at`) VALUES
(1, 3, 'Access to basic support', '2024-08-07 08:14:13', NULL),
(2, 3, 'Monthly data backup', '2024-08-07 08:14:13', NULL),
(3, 3, 'Free search access', '2024-08-07 08:14:13', NULL),
(8, 6, 'Priority support', '2024-08-07 08:30:11', NULL),
(9, 6, 'Weekly data backup', '2024-08-07 08:30:11', NULL),
(10, 6, 'Free search access', '2024-08-07 08:30:11', NULL),
(11, 7, '24/7 dedicated support', '2024-08-07 08:30:36', NULL),
(12, 7, 'Daily data backup', '2024-08-07 08:30:36', NULL),
(13, 7, 'Free search access', '2024-08-07 08:30:36', NULL),
(23, 500, 'Price per record', '2024-08-08 17:17:37', NULL),
(24, 500, 'Monthly data backup', '2024-08-08 17:17:37', NULL),
(25, 500, 'Free search access', '2024-08-08 17:17:37', NULL);

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `email_verification` enum('0','1') NOT NULL DEFAULT '0',
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `type` enum('admin','user') NOT NULL DEFAULT 'user',
  `status` enum('active','inactive') NOT NULL DEFAULT 'inactive',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `email_verification`, `password`, `phone`, `address`, `image`, `type`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@gmail.com', NULL, '1', '$2y$12$Bcvo1WT2Z7xMdaPe4eh98upMcTDf3cIwll/QY4QUsbNm6jk6EEC9a', '+123-4567-890', 'USA', 'Fw4Add.jpeg', 'admin', 'active', NULL, NULL, '2024-08-09 08:09:17'),
(106, 'khateeb ullah', 'chkhateeb96@gmail.com', '2024-08-08 21:23:40', '1', '$2y$12$P7WvSj8FPxDifUI22zXO..OUAnj3FFT0a37Jpdlf0B.SDmvBx1GWi', '03474570876', NULL, NULL, 'user', 'active', NULL, '2024-08-08 21:23:12', '2024-08-08 21:23:40');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `subscriptions_detail`
--
ALTER TABLE `subscriptions_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscriptionid` (`subscriptionid`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `subscriptions_detail`
--
ALTER TABLE `subscriptions_detail`
  ADD CONSTRAINT `subscriptions_detail_ibfk_1` FOREIGN KEY (`subscriptionid`) REFERENCES `subscriptions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

