-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 14, 2021 at 05:51 AM -- Server version: 10.4.13-MariaDB -- PHP Version: 7.4.8 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: `pellichupulu` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` int(10) UNSIGNED NOT NULL, `photo_url` varchar(200) NOT NULL, `name` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `mobile` varchar(12) NOT NULL, `age` int(3) UNSIGNED NOT NULL, `gender` enum('M','F','TG') NOT NULL, `address` varchar(2000) NOT NULL, `password` varchar(200) NOT NULL, `remember_token` varchar(200) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `photo_url`, `name`, `email`, `mobile`, `age`, `gender`, `address`, `password`, `remember_token`, `status`, `updated_at`, `created_at`) VALUES (1, 'admin/YSgelECrGlAWm86BBy2tg6Zxc0uXnLklxoaregbC.jpeg', 'Mic', 'michel@pc.com', '7896541230', 12, 'M', 'hello', '$2y$10$2P3kSXTHvUzGPqAWypi4We7M/Tn1f/IxBvRoLEr3z9hPqQoCdeZ0O', NULL, 1, '2020-12-07 03:28:38', '2020-05-31 13:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `blocked_profiles` -- CREATE TABLE `blocked_profiles` ( `id` int(10) NOT NULL, `blocked_by_member_id` int(10) NOT NULL, `blocked_member_id` int(10) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `blocked_profiles` -- INSERT INTO `blocked_profiles` (`id`, `blocked_by_member_id`, `blocked_member_id`, `created_at`) VALUES (3, 1, 2, '2020-12-09 16:55:08'); -- -------------------------------------------------------- -- -- Table structure for table `castes` -- CREATE TABLE `castes` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `castes` -- INSERT INTO `castes` (`id`, `name`) VALUES (1, 'Arya Vysya'), (2, 'Balija'), (3, 'Besta'), (4, 'Brahmin (All)\r\n'), (5, 'Chettiar'), (6, 'Darji'), (7, 'Goud'), (8, 'Intercaste'), (9, 'Kamma'), (10, 'Kamma Naidu'), (11, 'Kapu'), (12, 'Kapu Naidu'), (13, 'Kapu Reddy'), (14, 'Kshatriya'), (15, 'Kummari'), (16, 'Lingayath'), (17, 'Madiga'), (18, 'Mala'), (19, 'Mudaliyar'), (20, 'Mudiraj'), (21, 'Munnuru Kapu'), (22, 'Naidu'), (23, 'Padmashali'), (24, 'Rajaka'), (25, 'Reddy'), (26, 'Telaga'), (27, 'Kapu'), (28, 'Vanjara'), (29, 'Velama (All)'), (30, 'Viswabrahmin'), (31, 'Yadav'), (32, 'Others'); -- -------------------------------------------------------- -- -- Table structure for table `education_details` -- CREATE TABLE `education_details` ( `id` int(10) NOT NULL, `name` varchar(200) NOT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `education_details` -- INSERT INTO `education_details` (`id`, `name`, `updated_at`, `created_at`) VALUES (1, 'Graduated', '2020-10-12 13:00:00', '2020-10-10 13:00:00'), (2, 'Post Graduated', '2020-10-12 13:00:00', '2020-10-10 13:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `employment_types` -- CREATE TABLE `employment_types` ( `id` int(10) NOT NULL, `name` varchar(200) NOT NULL, `is_for` int(10) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `employment_types` -- INSERT INTO `employment_types` (`id`, `name`, `is_for`, `updated_at`, `created_at`) VALUES (1, 'Agriculture', 0, '2020-10-20 13:00:00', '2020-10-21 13:00:00'), (2, 'Business', 0, '2020-10-27 13:00:00', '2020-10-29 13:00:00'), (3, 'Defense', 0, '2020-10-14 13:00:00', '2020-10-27 13:00:00'), (4, 'Government Job', 0, '2020-10-28 13:00:00', '2020-10-21 13:00:00'), (5, 'Private Job', 0, '2020-10-28 13:00:00', '2020-10-14 13:00:00'), (6, 'Not Working', 0, '2020-10-28 13:00:00', '2020-10-28 13:00:00'), (7, 'Self Employed', 0, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `family_statuses` -- CREATE TABLE `family_statuses` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `family_statuses` -- INSERT INTO `family_statuses` (`id`, `name`, `updated_at`, `created_at`) VALUES (1, 'Middle Class', '2020-10-27 13:00:00', '2020-10-27 13:00:00'), (2, 'Upper Middle Class', '2020-10-27 13:00:00', '2020-10-27 13:00:00'), (3, 'Rich', '2020-10-14 13:00:00', '2020-10-27 13:00:00'), (4, 'Rich and affluent', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `family_values` -- CREATE TABLE `family_values` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `family_values` -- INSERT INTO `family_values` (`id`, `name`, `updated_at`, `created_at`) VALUES (1, 'Traditional', '2020-10-27 13:00:00', '2020-10-26 13:00:00'), (2, 'Moderate', '2020-10-27 13:00:00', '2020-10-29 13:00:00'), (3, 'Liberal', '2020-10-14 13:00:00', '2020-10-27 13:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `happy_stories` -- CREATE TABLE `happy_stories` ( `id` int(10) NOT NULL, `admin_id` int(10) DEFAULT NULL, `title` varchar(200) DEFAULT NULL, `photo_url` varchar(200) DEFAULT NULL, `description` varchar(2000) DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `married_at` date DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `happy_stories` -- INSERT INTO `happy_stories` (`id`, `admin_id`, `title`, `photo_url`, `description`, `status`, `married_at`, `updated_at`, `created_at`) VALUES (1, NULL, 'Anish & Aswathi', 'happy_story/eQtbmCZUO7EoEy7Y6be8N8n204QqXq3CeQrWEtDS.jpg', 'They have had their own share of arguments and their lovely memories but that is how they learn. Aswathi and Anish say that marriage is all about complimenting one another and growing together.', 1, '2020-12-16', '2020-12-24 07:59:35', '2020-12-07 03:21:31'), (2, NULL, 'Ajay & Sneha', 'happy_story/2TPcJukyb1bWmW3N1XU8Sc2ty8KpjKWuI2UqTrYi.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry Lorem Ipsum has been the industry\'s standard dummy text ever sinceLorem Ipsum is simply dummy text of the printing and typesetting industry', 1, '2020-12-01', '2020-12-31 04:34:39', '2020-12-24 13:31:16'), (3, NULL, 'Vijay & Arya', 'happy_story/nQew0jI0BV9PqvhYgGgpWGAA2ePSOPj8qbnupoB9.jpg', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry Lorem Ipsum has been the industry\'s standard dummy text ever sinceLorem Ipsum is simply dummy text', 1, '2020-12-24', NULL, '2020-12-24 13:35:15'), (4, NULL, 'Romeo & Juliet', 'happy_story/960zVydp0tblxd6sDLJpea2MhjDqqLxJ1E89SP0c.jpg', 'They have had their own share of arguments and their lovely memories but that is how they learn. Aswathi and Anish say that marriage is all about complimenting one another and growing together.', 1, '2020-12-23', NULL, '2020-12-24 13:43:35'); -- -------------------------------------------------------- -- -- Table structure for table `marital_statuses` -- CREATE TABLE `marital_statuses` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `marital_statuses` -- INSERT INTO `marital_statuses` (`id`, `name`) VALUES (1, 'Un Married'), (2, 'Widowed'), (3, 'Divorced'); -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` int(10) NOT NULL, `religion_id` int(10) DEFAULT NULL, `mother_tongue_id` int(10) DEFAULT NULL, `caste_id` int(10) DEFAULT NULL, `marital_status_id` int(10) DEFAULT NULL, `skin_complexion_id` int(10) DEFAULT NULL, `physical_status_id` int(10) DEFAULT NULL, `highest_education_id` int(10) DEFAULT NULL, `employment_type_id` int(10) DEFAULT NULL, `salary_id` int(10) DEFAULT NULL, `family_value_id` int(10) DEFAULT NULL, `family_status_id` int(10) DEFAULT NULL, `residence_state_id` int(10) DEFAULT 1, `package_id` int(10) DEFAULT NULL, `reg_no` varchar(20) NOT NULL, `name` varchar(200) DEFAULT NULL, `photo_url` varchar(200) DEFAULT NULL, `about` text DEFAULT NULL, `email` varchar(200) DEFAULT NULL, `password` varchar(200) NOT NULL, `dob` timestamp NULL DEFAULT NULL COMMENT 'date and time', `pob` varchar(200) DEFAULT NULL, `mobile` varchar(12) NOT NULL, `age` int(3) DEFAULT NULL, `gender` enum('M','F') DEFAULT NULL, `height` int(3) DEFAULT NULL COMMENT 'in cm', `weight` int(10) DEFAULT NULL COMMENT 'in KG', `designation` varchar(200) DEFAULT NULL, `work_district` varchar(200) DEFAULT NULL, `work_address` varchar(200) DEFAULT NULL, `residence_district` varchar(200) DEFAULT NULL, `residence_address` varchar(200) DEFAULT NULL, `family_address` varchar(200) DEFAULT NULL, `sisters_count` int(10) DEFAULT NULL, `brothers_count` int(10) DEFAULT NULL, `brothers_married_count` int(10) DEFAULT NULL, `sisters_married_count` int(10) DEFAULT NULL, `additional_education` varchar(200) DEFAULT NULL, `credits_left` int(10) NOT NULL DEFAULT 0, `total_credits` int(10) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `profile_for` enum('myself','sister','brother','son','daughter','relative','friend') NOT NULL DEFAULT 'myself', `email_verification_token` varchar(200) DEFAULT NULL, `expired_at` timestamp NULL DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `religion_id`, `mother_tongue_id`, `caste_id`, `marital_status_id`, `skin_complexion_id`, `physical_status_id`, `highest_education_id`, `employment_type_id`, `salary_id`, `family_value_id`, `family_status_id`, `residence_state_id`, `package_id`, `reg_no`, `name`, `photo_url`, `about`, `email`, `password`, `dob`, `pob`, `mobile`, `age`, `gender`, `height`, `weight`, `designation`, `work_district`, `work_address`, `residence_district`, `residence_address`, `family_address`, `sisters_count`, `brothers_count`, `brothers_married_count`, `sisters_married_count`, `additional_education`, `credits_left`, `total_credits`, `is_active`, `profile_for`, `email_verification_token`, `expired_at`, `email_verified_at`, `updated_at`, `created_at`) VALUES (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'PC00000001', 'Michel', 'member/MbvARky0JHdxVZeN3zh8e3nPPdiic200ZcchB7xI.jpeg', 'testtesttesttest', 'test@gmail.cm', '$2y$10$ww7eD08qQJJ.A.dnG4mDSex6ZV8XTltBoV9CfAnYzFNBnoHqL647u', '1996-12-04 09:44:26', 'test', '1234679', NULL, 'M', 10, 50, 'test', NULL, 'testtesttest', NULL, 'testtesttesttesttest', NULL, 0, 0, 0, 0, 'test', 4, 15, 1, 'myself', NULL, '2021-01-09 14:58:31', '2020-12-15 05:00:50', '2020-12-24 23:42:50', '2020-12-01 03:50:07'), (2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000002', 'Angel', 'member/PeYkUL2PvQDjpEfxJEkxbFltTaOIagw3l0mOu9l6.jpg', 'testtesttesttest', 'angel@gmail.com', '$2y$10$LQO4Nghg0c986TJfJfckTusoz88xxdGUwtYLrjLhz8UvRxC4ieoqS', '2020-12-09 14:49:37', 'test', '7896541231', NULL, 'F', 10, 50, 'test', NULL, 'testtesttesttest', NULL, 'testtesttesttest', NULL, 0, 0, 0, 0, 'test', 9, 0, 1, 'myself', NULL, NULL, '2020-12-15 05:00:48', '2020-12-24 23:42:50', '2020-12-09 14:52:25'), (3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000003', 'Elza', 'member/gxqIMG6f9MV7pSW5csLKziP1NZHYx8Z5fIoZDoJ1.jpg', 'testtesttesttest', 'elza@gmail.com', '$2y$10$1T2bV0AoYjtF0XUoiAE/POCRceATRpR9McFgeryKo3pbfPE9ot5aC', '1996-12-09 15:07:43', 'test', '123456789', NULL, 'F', 10, 60, 'test', NULL, 'testtest', NULL, 'test', NULL, 1, 1, 1, 1, 'test', 9, 0, 1, 'myself', NULL, NULL, '2020-12-09 05:00:42', '2020-12-24 23:42:50', '2020-12-09 15:08:49'), (4, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000004', 'John Snow', 'member/LkwVKU3IFgP7GEnKxLomHMWUIjHCmCOaoP5sD72n.jpg', 'HyderabadHyderabad', 'john@gmail.com', '$2y$10$MaciVR3IZEiHNska4KMrX.d715NEeDymtQAQixkyJqttTxPj5Ac.C', '2020-12-12 11:46:56', 'Hyderabad', '7896541232', NULL, 'M', 10, 50, NULL, NULL, 'HyderabadHyderabad', NULL, 'HyderabadHyderabadHyderabad', NULL, 2, 2, 2, 2, 'test', 9, 0, 1, 'myself', NULL, NULL, '2020-12-15 05:00:37', '2020-12-24 23:42:50', '2020-12-24 11:48:37'), (5, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '1608019531', 'Test', 'member/XD2KJiXLr7fkhTZq9mml2Sn7FICbmpQNaUldJSnE.jpg', 'Test1Test1', 'Test1@gmail.com', '$2y$10$v3UHmRE.tVyv72PdxBNUg.d3qzcMjbW2FOFo3borKXCY5dGIXKGjm', '1996-12-12 14:42:12', 'Test1', '8848936826', NULL, 'M', 10, 50, 'Test1', NULL, 'Test1Test1', NULL, 'Test1Test1Test1', NULL, 1, 1, 1, 1, 'Test1', 9, 0, 1, 'myself', NULL, NULL, '2020-12-08 05:00:34', '2020-12-24 23:42:50', '2020-12-16 08:05:31'), (6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '1608029979', 'Test2', 'member/RNwOWevu4MqUty0ExH1xNyX0DqfxMBmGjxkYlTEO.jpg', 'test2test2', 'test2@gmail.com', '$2y$10$3m4bxltEKFOaq2Piw9B.XukJ9xZgo5beM.4t.nOCwNIpM6dJgcrUe', '1992-12-12 04:40:10', 'test2', '7896541233', NULL, 'M', 10, 50, 'test2', NULL, 'test2', NULL, 'test2test2', NULL, 1, 1, 1, 1, 'test2', 9, 0, 1, 'myself', NULL, NULL, '2020-12-08 05:00:31', '2020-12-24 23:42:50', '2020-12-17 10:59:39'), (7, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000007', 'Test3', 'member/vLFxcTKz3tKm5saLvAueCg2SavA9Dbhdoaaww53F.jpg', 'test2test2', 'test3@gmail.com', '$2y$10$msnt0McfxTp9Ziz58g8h9elMCZqCn0h0kpT4dtmjJvfY0rYukAAuK', '1992-12-12 04:40:10', 'test2', '7896541234', NULL, 'M', 10, 50, 'test2', NULL, 'test2', NULL, 'test2test2', NULL, 1, 1, 1, 1, 'test2', 9, 0, 1, 'myself', NULL, NULL, '2020-12-01 05:00:29', '2020-12-24 23:42:50', '2020-12-18 11:01:38'), (8, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000008', 'Test4', 'member/AY2EoGL7PQ6S5uNvWiDR7DgTlyfQyZIn8dyFGMQC.jpg', 'Test4Test4', 'test4@gmail.com', '$2y$10$jDvCH83vCkB2N7TloSwvBulzbvA18vl.9h9IUIUwi44w6rW.Xz6ia', '1996-12-10 05:41:11', 'Test4', '7896541241', NULL, 'M', 10, 40, 'Test4', NULL, 'Test4', NULL, 'Test4Test4', NULL, 1, 1, 1, 1, 'Test4', 9, 0, 1, 'myself', NULL, NULL, '2020-12-01 05:00:26', '2020-12-24 23:42:50', '2020-12-19 11:08:03'), (9, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000009', 'test5', 'member/qpAWmvbPHd8Z4jtyLACuKzCLMqhu1g5RH84LrpgV.jpg', 'test5test5', 'test5@gmail.com', '$2y$10$wDWW556zvphtnGQKwGHZV.N3cgoCjmTlOd4dQm5tc4ZZZg4HFHBte', '1996-10-10 04:40:10', 'test5', '7896541236', NULL, 'M', 10, 50, 'test5', NULL, 'test5test5', NULL, 'test5test5', NULL, 1, 1, 1, 1, 'test5', 9, 0, 1, 'myself', NULL, NULL, '2020-12-01 05:00:23', '2020-12-24 23:42:50', '2020-12-20 11:11:04'), (10, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000010', 'test6', 'member/YUpkibJY1v0pWU7SIrxoFFqRpz11aBWxXAMU72to.jpg', 'test6test6', 'test6@gmail.com', '$2y$10$ax7iBZGvwL3vtM3U8hFdte8tZRdGx7YtjIfiWfn0KmDwtSFhSCuCK', '1998-10-10 04:40:10', 'test6', '7896541237', NULL, 'M', 10, 50, 'test6', NULL, 'test6test6', NULL, 'test6', NULL, 1, 1, 1, 1, 'test6', 9, 0, 1, 'myself', NULL, NULL, '2020-12-01 05:00:21', '2020-12-24 23:42:50', '2020-12-21 11:26:15'), (11, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000011', 'test7', 'member/P5cdzBYWyqn1bAOa5y10BBNGLeNoNpsJliQLlcvY.jpg', 'test7test7test7', 'test7@gmail.com', '$2y$10$bdG1hnkqZsJm3e.i7L6woO9sbjaiN5AXTk3jCrAiWr7BI0Z7UKhfK', '1996-10-10 04:40:10', 'test7', '7896541271', NULL, 'M', 10, 50, 'test7', NULL, 'test7test7', NULL, 'test7test7', NULL, 0, 0, 0, 0, 'test7', 9, 0, 1, 'myself', NULL, NULL, '2020-12-01 05:00:17', '2020-12-24 23:42:50', '2020-12-22 07:33:43'), (12, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000012', 'test8 new', 'member/dpne6Ko9BdeI5yrlt8V0OtLdET9oCqebCgk8XKf5.jpg', 'test8test8', 'test8@gmail.com', '$2y$10$.hrOfqmeXWvnLKv8.HB5v.nTcDPjZVrCp1D1oHzKXhW9xMhqNbbbW', '2018-12-12 06:30:00', 'test8', '7896541239', NULL, 'M', 144, 0, 'test8', NULL, 'test8test8', NULL, 'aa', NULL, 0, 0, 0, 0, 'test8', 0, 0, 1, 'myself', 'eef3ce96705ac7f2787d86063748166f7b55a515954423801f9850dd6f34a312', NULL, '2020-12-16 04:03:52', '2021-01-05 00:41:07', '2020-12-23 09:05:13'), (13, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000013', 'test9', 'member/DFkDrQzN3h3NaYH2gqxHhJHhkRJXlVkDDQvSn0dd.jpg', 'test9test9test9', 'test9@gmail.com', '$2y$10$v0la.dy/l2uxU7sxp37XIOiws8rXrT36YaerS9PEHg06.zBc/aeA2', '1996-10-10 04:40:10', 'test9', '7896541210', NULL, 'M', 10, 50, 'test9', NULL, 'test9test9test9', NULL, 'test9test9test9test9', NULL, 0, 0, 0, 0, 'test9', 13, 15, 1, 'myself', '6d0d3db618ab367d3896060c95da2d2583025c61f7d5a1372eedd2f882c8289a', NULL, '2020-12-23 07:06:47', '2020-12-24 23:42:50', '2020-12-25 12:33:34'), (14, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '1609321849', 'test12', 'member/zMX3VQ8BeTESXHSd56pMLBt88UYqhgV3u6My038b.jpg', 'sssssssssssss', 'test12@gmail.com', '$2y$10$kkZ0L62sNT4W89lteI6rmOyLlK2X8CJYxcUJZutW8tU2WCH/rLkHe', '1996-12-02 09:50:09', 's', '7896541238', NULL, 'M', 10, 60, 's', NULL, 's', NULL, NULL, NULL, 0, 0, 0, 0, 's', 0, 0, 1, 'myself', NULL, NULL, NULL, NULL, '2020-12-30 09:50:49'), (15, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000015', 'test13', 'member/b7surZVVlkoxGxMr0HArHjMKy209ZLV4ILX9REoa.jpg', 'sssssssssssss', 'test13@gmail.com', '$2y$10$lS6N3WJuAfP/zv5m7nlX6uv.vqRmp5MKeIXcRvabkJBsQsqzzQn5e', '1996-12-02 09:50:09', 's', '7896541235', NULL, 'M', 10, 60, 's', NULL, 's', NULL, NULL, NULL, 0, 0, 0, 0, 's', 0, 0, 1, 'myself', '1a21e5b602fc2ccf20fe6e559016ccd290d09686c338e2da1890418fe852cf8f', NULL, '2020-12-30 04:23:36', '2020-12-30 10:07:54', '2020-12-30 09:52:05'), (16, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00000016', 'test14', 'member/6kmgzs7L0udRKCGGpRM2o5gMt6SFK6gI8FWdr3a4.jpg', 'test14test14', 'test14@gmail.com', '$2y$10$wO0jHiy8xk49kVpqaZZbZu0i.4i3da93bL42VwUQjvUPn0aG/a3aS', '1996-12-02 07:52:29', 'test14', '1236547800', NULL, 'M', 10, 50, 'test14', NULL, 'test14', NULL, NULL, NULL, 0, 0, 0, 0, 'test14', 0, 0, 1, 'myself', 'f9500081be252a7072bb54cd83e338fe3babc504976b3ce29079a85e90553815', NULL, NULL, '2020-12-31 02:23:49', '2020-12-31 07:53:49'), (17, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00017', 'test17', 'member/THHhOg2MVAQbuO4XKRkJHBsyBSPvlndd5HmNDok1.jpg', 'ddddddddd', NULL, '$2y$10$Gl02BRYMzN.KlHXm5O3/1uOEXRQB2Yvw..5CKNhu6uEPlRzoJ2nt6', '2002-12-31 19:31:00', 'ff', '3216549870', NULL, 'M', 137, 50, 'dddddddddd', NULL, 'ddddddddddddd', NULL, NULL, NULL, 0, 0, 0, 0, 'dddddddd', 0, 0, 1, 'myself', 'f8bb41fde21b4895acac75947aaff3e1ac315f3504e0f5e06d2616b7e312654a', NULL, NULL, '2021-01-08 02:36:08', '2021-01-08 08:06:07'), (18, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, 'PC00018', 'test18', 'member/Adlko3vPEFPrsKGHEiNzfUnPUtPmJi9pkfEKGqFY.jpg', 'ddddddddd', NULL, '$2y$10$7V.ptbB7q3L9Gyx1b8NUqeMa8e1s4KInEyJpcqJ69zAaUxmsKJqu6', '2002-12-31 19:31:00', 'ff', '9216549870', NULL, 'M', 137, 50, 'dddddddddd', NULL, 'ddddddddddddd', NULL, NULL, NULL, 0, 0, 0, 0, 'dddddddd', 0, 0, 1, 'myself', NULL, NULL, NULL, '2021-01-08 03:41:02', '2021-01-08 08:07:23'); -- -------------------------------------------------------- -- -- Table structure for table `member_photos` -- CREATE TABLE `member_photos` ( `id` int(10) NOT NULL, `member_id` int(10) NOT NULL, `photo_url` varchar(2000) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `member_photos` -- INSERT INTO `member_photos` (`id`, `member_id`, `photo_url`, `created_at`) VALUES (20, 17, 'member/8ZuzKAhC928ewGAOzgiNabchrz8yUcq6Byl7UcRy.jpg', '2021-01-08 08:06:07'), (21, 18, 'member/UE3epqyQqMEfmsboQp2ALlgecCFQnXrqIDjCphay.jpg', '2021-01-08 08:07:23'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_100000_create_password_resets_table', 1), (2, '2019_08_19_000000_create_failed_jobs_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `mother_tongues` -- CREATE TABLE `mother_tongues` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `mother_tongues` -- INSERT INTO `mother_tongues` (`id`, `name`) VALUES (1, 'Telugu'), (2, 'Hindi'), (3, 'Urdu'), (4, 'Kannada'), (5, 'Malayalam'), (6, 'Tamil'); -- -------------------------------------------------------- -- -- Table structure for table `my_interests` -- CREATE TABLE `my_interests` ( `int` int(10) NOT NULL, `send_member_id` int(10) NOT NULL, `receiver_member_id` int(10) NOT NULL, `status_id` int(10) UNSIGNED NOT NULL DEFAULT 1, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `my_interests` -- INSERT INTO `my_interests` (`int`, `send_member_id`, `receiver_member_id`, `status_id`, `updated_at`, `created_at`) VALUES (1, 12, 3, 1, '2020-12-17 02:11:55', '2020-12-17 02:11:55'), (4, 13, 3, 1, '2020-12-23 07:08:12', '2020-12-23 07:08:12'), (6, 10, 12, 3, '2020-12-25 07:05:42', NULL), (7, 12, 2, 1, '2020-12-25 07:07:25', '2020-12-25 07:07:25'); -- -------------------------------------------------------- -- -- Table structure for table `my_interest_status` -- CREATE TABLE `my_interest_status` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(20) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `my_interest_status` -- INSERT INTO `my_interest_status` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'Pending', '2020-11-07 11:36:08', NULL), (2, 'Accepted', '2020-11-07 11:36:08', NULL), (3, 'Rejected', '2020-11-07 11:36:17', NULL); -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` int(10) NOT NULL, `title` varchar(2000) NOT NULL, `description` varchar(200) NOT NULL, `filter` varchar(200) NOT NULL DEFAULT 'all', `expired_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `notifications` -- INSERT INTO `notifications` (`id`, `title`, `description`, `filter`, `expired_at`, `updated_at`, `created_at`) VALUES (1, 'Happy diwali!!', 'Happy diwali!!Happy diwali!!Happy diwali!!', 'all', '2020-12-31 09:50:29', NULL, '2020-12-05 09:53:58'), (2, 'happ xmas!!', 'happ xmas!!happ xmas!!', 'all', '2020-12-31 09:53:29', NULL, '2020-12-05 09:53:54'), (3, 'Lorem Ipsum', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry', 'all', '2020-12-23 14:44:45', NULL, '2020-12-24 14:45:15'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_gateways` -- CREATE TABLE `payment_gateways` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL, `description` varchar(2000) DEFAULT NULL, `currency` varchar(3) NOT NULL DEFAULT 'INR', `redirect_url` varchar(200) DEFAULT NULL, `return_url` varchar(200) DEFAULT NULL, `secret_key` varchar(200) NOT NULL, `merchant_no` varchar(200) DEFAULT NULL, `service_charge` float(6,2) NOT NULL DEFAULT 0.00, `type` enum('per','add') NOT NULL DEFAULT 'add', `status` tinyint(1) NOT NULL DEFAULT 1, `gateway_type` enum('razorpay') NOT NULL DEFAULT 'razorpay', `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `physical_statuses` -- CREATE TABLE `physical_statuses` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `physical_statuses` -- INSERT INTO `physical_statuses` (`id`, `name`) VALUES (1, 'Normal'), (2, 'Athletics'), (3, 'Physically Handicap'); -- -------------------------------------------------------- -- -- Table structure for table `profile_reports` -- CREATE TABLE `profile_reports` ( `id` int(10) NOT NULL, `reported_by_member_id` int(10) DEFAULT NULL, `reported_member_id` int(10) NOT NULL, `description` varchar(2000) NOT NULL, `status_id` int(10) NOT NULL DEFAULT 1, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `profile_report_status` -- CREATE TABLE `profile_report_status` ( `id` int(10) NOT NULL, `name` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `profile_report_status` -- INSERT INTO `profile_report_status` (`id`, `name`) VALUES (1, 'Pending'), (2, 'Completed'); -- -------------------------------------------------------- -- -- Table structure for table `religions` -- CREATE TABLE `religions` ( `id` int(10) NOT NULL, `name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `religions` -- INSERT INTO `religions` (`id`, `name`) VALUES (1, 'Hindu'), (2, 'Muslim'), (3, 'Christian'), (4, 'Sikh'), (5, 'Jain'), (6, 'Inter Religion'); -- -------------------------------------------------------- -- -- Table structure for table `salary_details` -- CREATE TABLE `salary_details` ( `id` int(10) NOT NULL, `name` varchar(200) NOT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `salary_details` -- INSERT INTO `salary_details` (`id`, `name`, `updated_at`, `created_at`) VALUES (1, '1 Lakh', '2020-10-05 13:00:00', '2020-10-05 13:00:00'), (2, '2 Lakh', '2020-10-27 13:00:00', '2020-10-29 13:00:00'), (3, '3 Lakh', '2020-10-27 13:00:00', '2020-10-29 13:00:00'), (4, '4 Lakh', '2020-10-27 13:00:00', '2020-10-29 13:00:00'), (5, '5 Lakhs', '2020-10-27 13:00:00', '2020-10-26 13:00:00'), (6, '6 Lakhs', '2020-10-27 13:00:00', '2020-10-29 13:00:00'), (7, '7 Lakhs', '2020-10-14 13:00:00', '2020-10-27 13:00:00'), (8, '8 Lakhs', '2020-10-28 13:00:00', '2020-10-21 13:00:00'), (9, '9 Lakhs', '2020-10-28 13:00:00', '2020-10-14 13:00:00'), (10, '10 Lakhs', '2020-10-28 13:00:00', '2020-10-28 13:00:00'), (11, '11 Lakhs', '2020-10-27 13:00:00', '2020-10-27 13:00:00'), (12, '12 Lakhs', '2020-10-27 13:00:00', '2020-10-27 13:00:00'), (13, 'Above 12 Lakhs', '2020-10-27 13:00:00', '2020-10-27 13:00:00'), (14, 'Above 15 Lakhs', '2020-10-26 13:00:00', '2020-10-27 13:00:00'), (15, 'Above 20 Lakhs', '2020-10-27 13:00:00', '2020-10-28 13:00:00'), (16, 'Above 25 Lakhs', '2020-10-21 13:00:00', '2020-10-27 13:00:00'), (17, 'Above 50 Lakhs', '2020-10-27 13:00:00', '2020-10-27 13:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `shortlists` -- CREATE TABLE `shortlists` ( `id` int(10) NOT NULL, `shortlisted_by_member_id` int(10) NOT NULL, `shortlisted_member_id` int(10) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `shortlists` -- INSERT INTO `shortlists` (`id`, `shortlisted_by_member_id`, `shortlisted_member_id`, `created_at`, `updated_at`) VALUES (17, 13, 2, '2020-12-23 12:42:33', '2020-12-23 07:12:33'); -- -------------------------------------------------------- -- -- Table structure for table `skin_complexions` -- CREATE TABLE `skin_complexions` ( `id` int(10) NOT NULL, `name` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `skin_complexions` -- INSERT INTO `skin_complexions` (`id`, `name`) VALUES (1, 'Dark'), (2, 'Wheatish'), (3, 'Fair'), (4, 'Very Fair'); -- -------------------------------------------------------- -- -- Table structure for table `states` -- CREATE TABLE `states` ( `id` int(10) NOT NULL, `name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `states` -- INSERT INTO `states` (`id`, `name`) VALUES (1, 'Andhra Pradesh'), (2, 'Telangana'); -- -------------------------------------------------------- -- -- Table structure for table `tentative_packages` -- CREATE TABLE `tentative_packages` ( `id` int(10) NOT NULL, `name` varchar(100) NOT NULL, `description` text DEFAULT NULL, `price` decimal(7,2) NOT NULL, `duration` int(3) NOT NULL DEFAULT 3 COMMENT 'in months', `credits` int(10) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tentative_packages` -- INSERT INTO `tentative_packages` (`id`, `name`, `description`, `price`, `duration`, `credits`, `created_at`, `updated_at`) VALUES (1, 'Parichaya', '15 Contacts', '1000.00', 1, 15, '2020-12-07 07:27:48', NULL), (2, 'Prakriya', '50 Contacts', '3000.00', 3, 50, '2020-12-07 07:27:48', NULL), (3, 'Paripurna', '100 contacts', '10000.00', 6, 100, '2020-12-07 07:28:22', NULL); -- -------------------------------------------------------- -- -- Table structure for table `transactions` -- CREATE TABLE `transactions` ( `id` int(10) NOT NULL, `member_id` int(10) NOT NULL, `package_id` int(10) DEFAULT NULL, `transaction_no` varchar(200) NOT NULL, `package_name` varchar(200) NOT NULL, `tax` float(6,2) NOT NULL DEFAULT 0.00, `extra_amount` float(6,2) NOT NULL DEFAULT 0.00, `total_amount` float(7,2) NOT NULL, `credits` int(10) NOT NULL, `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending', `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `transactions` -- INSERT INTO `transactions` (`id`, `member_id`, `package_id`, `transaction_no`, `package_name`, `tax`, `extra_amount`, `total_amount`, `credits`, `status`, `updated_at`, `created_at`) VALUES (1, 1, 1, '12365479', 'Parichaya', 180.00, 0.00, 180.00, 15, 'paid', NULL, '2020-12-08 14:55:21'); -- -------------------------------------------------------- -- -- Table structure for table `unlocked_profiles` -- CREATE TABLE `unlocked_profiles` ( `id` int(10) NOT NULL, `unlocked_by_member_id` int(10) NOT NULL, `unlocked_member_id` int(10) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `unlocked_profiles` -- INSERT INTO `unlocked_profiles` (`id`, `unlocked_by_member_id`, `unlocked_member_id`, `created_at`, `updated_at`) VALUES (12, 12, 2, '2020-12-24 23:42:50', NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blocked_profiles` -- ALTER TABLE `blocked_profiles` ADD PRIMARY KEY (`id`), ADD KEY `blocked_profiles_fk0` (`blocked_by_member_id`), ADD KEY `blocked_id` (`blocked_member_id`); -- -- Indexes for table `castes` -- ALTER TABLE `castes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `education_details` -- ALTER TABLE `education_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `employment_types` -- ALTER TABLE `employment_types` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `family_statuses` -- ALTER TABLE `family_statuses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `family_values` -- ALTER TABLE `family_values` ADD PRIMARY KEY (`id`); -- -- Indexes for table `happy_stories` -- ALTER TABLE `happy_stories` ADD PRIMARY KEY (`id`), ADD KEY `happystories_fk0` (`admin_id`); -- -- Indexes for table `marital_statuses` -- ALTER TABLE `marital_statuses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `mobile` (`mobile`), ADD UNIQUE KEY `email` (`email`), ADD KEY `user_fk0` (`religion_id`), ADD KEY `user_fk1` (`mother_tongue_id`), ADD KEY `user_fk2` (`caste_id`), ADD KEY `user_fk3` (`marital_status_id`), ADD KEY `user_fk4` (`skin_complexion_id`), ADD KEY `user_fk5` (`physical_status_id`), ADD KEY `user_fk6` (`highest_education_id`), ADD KEY `user_fk7` (`employment_type_id`), ADD KEY `user_fk8` (`salary_id`), ADD KEY `user_fk9` (`family_value_id`), ADD KEY `user_fk10` (`family_status_id`), ADD KEY `residence_state_id` (`residence_state_id`), ADD KEY `package_id` (`package_id`); -- -- Indexes for table `member_photos` -- ALTER TABLE `member_photos` ADD PRIMARY KEY (`id`), ADD KEY `member_id` (`member_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mother_tongues` -- ALTER TABLE `mother_tongues` ADD PRIMARY KEY (`id`); -- -- Indexes for table `my_interests` -- ALTER TABLE `my_interests` ADD PRIMARY KEY (`int`), ADD KEY `my_interests_fk0` (`send_member_id`), ADD KEY `receiver_id` (`receiver_member_id`), ADD KEY `status_id` (`status_id`); -- -- Indexes for table `my_interest_status` -- ALTER TABLE `my_interest_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payment_gateways` -- ALTER TABLE `payment_gateways` ADD PRIMARY KEY (`id`); -- -- Indexes for table `physical_statuses` -- ALTER TABLE `physical_statuses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `profile_reports` -- ALTER TABLE `profile_reports` ADD PRIMARY KEY (`id`), ADD KEY `profile_reports_fk0` (`reported_by_member_id`), ADD KEY `reported_id` (`reported_member_id`), ADD KEY `status_id` (`status_id`); -- -- Indexes for table `profile_report_status` -- ALTER TABLE `profile_report_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `religions` -- ALTER TABLE `religions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `salary_details` -- ALTER TABLE `salary_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shortlists` -- ALTER TABLE `shortlists` ADD PRIMARY KEY (`id`); -- -- Indexes for table `skin_complexions` -- ALTER TABLE `skin_complexions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `states` -- ALTER TABLE `states` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tentative_packages` -- ALTER TABLE `tentative_packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD KEY `transactions_fk0` (`member_id`), ADD KEY `package_id` (`package_id`); -- -- Indexes for table `unlocked_profiles` -- ALTER TABLE `unlocked_profiles` ADD PRIMARY KEY (`id`), ADD KEY `unlocked_profiles_fk0` (`unlocked_by_member_id`), ADD KEY `unlocked_id` (`unlocked_member_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `blocked_profiles` -- ALTER TABLE `blocked_profiles` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `castes` -- ALTER TABLE `castes` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `education_details` -- ALTER TABLE `education_details` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `employment_types` -- ALTER TABLE `employment_types` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `family_statuses` -- ALTER TABLE `family_statuses` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `family_values` -- ALTER TABLE `family_values` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `happy_stories` -- ALTER TABLE `happy_stories` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `marital_statuses` -- ALTER TABLE `marital_statuses` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `member_photos` -- ALTER TABLE `member_photos` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `mother_tongues` -- ALTER TABLE `mother_tongues` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `my_interests` -- ALTER TABLE `my_interests` MODIFY `int` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `my_interest_status` -- ALTER TABLE `my_interest_status` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `notifications` -- ALTER TABLE `notifications` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `payment_gateways` -- ALTER TABLE `payment_gateways` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `physical_statuses` -- ALTER TABLE `physical_statuses` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `profile_reports` -- ALTER TABLE `profile_reports` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `profile_report_status` -- ALTER TABLE `profile_report_status` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `religions` -- ALTER TABLE `religions` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `salary_details` -- ALTER TABLE `salary_details` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `shortlists` -- ALTER TABLE `shortlists` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `skin_complexions` -- ALTER TABLE `skin_complexions` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `states` -- ALTER TABLE `states` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tentative_packages` -- ALTER TABLE `tentative_packages` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `transactions` -- ALTER TABLE `transactions` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `unlocked_profiles` -- ALTER TABLE `unlocked_profiles` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- Constraints for dumped tables -- -- -- Constraints for table `blocked_profiles` -- ALTER TABLE `blocked_profiles` ADD CONSTRAINT `blocked_profiles_ibfk_1` FOREIGN KEY (`blocked_by_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `blocked_profiles_ibfk_2` FOREIGN KEY (`blocked_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `members` -- ALTER TABLE `members` ADD CONSTRAINT `members_ibfk_1` FOREIGN KEY (`employment_type_id`) REFERENCES `employment_types` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_10` FOREIGN KEY (`skin_complexion_id`) REFERENCES `skin_complexions` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_11` FOREIGN KEY (`residence_state_id`) REFERENCES `states` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_2` FOREIGN KEY (`family_status_id`) REFERENCES `family_statuses` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_3` FOREIGN KEY (`family_value_id`) REFERENCES `family_values` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_4` FOREIGN KEY (`highest_education_id`) REFERENCES `education_details` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_5` FOREIGN KEY (`marital_status_id`) REFERENCES `marital_statuses` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_6` FOREIGN KEY (`mother_tongue_id`) REFERENCES `mother_tongues` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_7` FOREIGN KEY (`physical_status_id`) REFERENCES `physical_statuses` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_8` FOREIGN KEY (`religion_id`) REFERENCES `religions` (`id`) ON UPDATE CASCADE, ADD CONSTRAINT `members_ibfk_9` FOREIGN KEY (`salary_id`) REFERENCES `salary_details` (`id`) ON UPDATE CASCADE; -- -- Constraints for table `member_photos` -- ALTER TABLE `member_photos` ADD CONSTRAINT `member_photos_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `my_interests` -- ALTER TABLE `my_interests` ADD CONSTRAINT `my_interests_ibfk_1` FOREIGN KEY (`receiver_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `my_interests_ibfk_2` FOREIGN KEY (`send_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `my_interests_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `my_interest_status` (`id`) ON UPDATE CASCADE; -- -- Constraints for table `profile_reports` -- ALTER TABLE `profile_reports` ADD CONSTRAINT `profile_reports_ibfk_1` FOREIGN KEY (`reported_by_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `profile_reports_ibfk_2` FOREIGN KEY (`reported_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `profile_reports_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `profile_report_status` (`id`) ON UPDATE CASCADE; -- -- Constraints for table `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `tentative_packages` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `unlocked_profiles` -- ALTER TABLE `unlocked_profiles` ADD CONSTRAINT `unlocked_profiles_ibfk_1` FOREIGN KEY (`unlocked_member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `unlocked_profiles_ibfk_2` FOREIGN KEY (`unlocked_by_member_id`) REFERENCES `members` (`id`) 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 */;