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

START TRANSACTION;



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

--
-- 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 `country_in`
--

CREATE TABLE `country_in` (
  `id` int(10) NOT NULL,
  `name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `country_in`
--

INSERT INTO `country_in` (`id`, `name`) VALUES
(1, 'India'),
(2, 'Canada'),
(3, 'United States'),
(4, 'Afghanistan'),
(5, 'Albania'),
(6, 'Algeria'),
(7, 'Andorra'),
(8, 'Angola'),
(9, 'Antigua and Barbuda'),
(10, 'Argentina'),
(11, 'Armenia'),
(12, 'Australia'),
(13, 'Austria'),
(14, 'Azerbaijan'),
(15, 'The Bahamas'),
(16, 'Bahrain'),
(17, 'Bangladesh'),
(18, 'Barbados'),
(19, 'Belarus'),
(20, 'Belgium'),
(21, 'Belize'),
(22, 'Benin'),
(23, 'Bhutan'),
(24, 'Bolivia'),
(25, 'Bosnia and Herzegovina'),
(26, 'Botswana'),
(27, 'Brazil'),
(28, 'Brunei'),
(29, 'Bulgaria'),
(30, 'Burkina Faso'),
(31, 'Burundi'),
(32, 'Cabo Verde'),
(33, 'Cambodia'),
(34, 'Cameroon'),
(35, 'Central African Republic'),
(36, 'Chad'),
(37, 'Chile'),
(38, 'China'),
(39, 'Colombia'),
(40, 'Comoros'),
(41, 'Congo, Democratic Republic of the'),
(42, 'Congo, Republic of the'),
(43, 'Costa Rica'),
(44, 'Côte d’Ivoire'),
(45, 'Croatia'),
(46, 'Cuba'),
(47, 'Cyprus'),
(48, 'Czech Republic'),
(49, 'Denmark'),
(50, 'Djibouti'),
(51, 'Dominica'),
(52, 'Dominican Republic'),
(53, 'East Timor (Timor-Leste)'),
(54, 'Ecuador'),
(55, 'Egypt'),
(56, 'El Salvador'),
(57, 'Equatorial Guinea'),
(58, 'Eritrea'),
(59, 'Estonia'),
(60, 'Eswatini'),
(61, 'Ethiopia'),
(62, 'Fiji'),
(63, 'Finland'),
(64, 'France'),
(65, 'Gabon'),
(66, 'The Gambia'),
(67, 'Georgia'),
(68, 'Germany'),
(69, 'Ghana'),
(70, 'Greece'),
(71, 'Grenada'),
(72, 'Guatemala'),
(73, 'Guinea'),
(74, 'Guinea-Bissau'),
(75, 'Guyana'),
(76, 'Haiti'),
(77, 'Honduras'),
(78, 'Hungary'),
(79, 'Iceland'),
(80, 'Indonesia'),
(81, 'Iran'),
(82, 'Iraq'),
(83, 'Ireland'),
(84, 'Israel'),
(85, 'Italy'),
(86, 'Jamaica'),
(87, 'Japan'),
(88, 'Jordan'),
(89, 'Kazakhstan'),
(90, 'Kenya'),
(91, 'Kiribati'),
(92, 'Korea, North'),
(93, 'Korea, South'),
(94, 'Kosovo'),
(95, 'Kuwait'),
(96, 'Kyrgyzstan'),
(97, 'Laos'),
(98, 'Latvia'),
(99, 'Lebanon'),
(100, 'Lesotho'),
(101, 'Liberia'),
(102, 'Libya'),
(103, 'Liechtenstein'),
(104, 'Lithuania'),
(105, 'Luxembourg'),
(106, 'Madagascar'),
(107, 'Malawi'),
(108, 'Malaysia'),
(109, 'Maldives'),
(110, 'Mali'),
(111, 'Malta'),
(112, 'Marshall Islands'),
(113, 'Mauritania'),
(114, 'Mauritius'),
(115, 'Mexico'),
(116, 'Micronesia, Federated States of'),
(117, 'Moldova'),
(118, 'Monaco'),
(119, 'Mongolia'),
(120, 'Montenegro'),
(121, 'Morocco'),
(122, 'Mozambique'),
(123, 'Myanmar (Burma)'),
(124, 'Namibia'),
(125, 'Nauru'),
(126, 'Nepal'),
(127, 'Netherlands'),
(128, 'New Zealand'),
(129, 'Nicaragua'),
(130, 'Niger'),
(131, 'Nigeria'),
(132, 'North Macedonia'),
(133, 'Norway'),
(134, 'Oman'),
(135, 'Pakistan'),
(136, 'Palau'),
(137, 'Panama'),
(138, 'Papua New Guinea'),
(139, 'Paraguay'),
(140, 'Peru'),
(141, 'Philippines'),
(142, 'Poland'),
(143, 'Portugal'),
(144, 'Qatar'),
(145, 'Romania'),
(146, 'Russia'),
(147, 'Rwanda'),
(148, 'Saint Kitts and Nevis'),
(149, 'Saint Lucia'),
(150, 'Saint Vincent and the Grenadines'),
(151, 'Samoa'),
(152, 'San Marino'),
(153, 'Sao Tome and Principe'),
(154, 'Saudi Arabia'),
(155, 'Senegal'),
(156, 'Serbia'),
(157, 'Seychelles'),
(158, 'Sierra Leone'),
(159, 'Singapore'),
(160, 'Slovakia'),
(161, 'Solomon Islands'),
(162, 'Somalia'),
(163, 'South Africa'),
(164, 'Spain'),
(165, 'Sri Lanka'),
(166, 'Sudan'),
(167, 'Sudan, South'),
(168, 'Suriname'),
(169, 'Sweden'),
(170, 'Switzerland'),
(171, 'Syria'),
(172, 'Taiwan'),
(173, 'Tajikistan'),
(174, 'Tanzania'),
(175, 'Thailand'),
(176, 'Togo'),
(177, 'Tonga'),
(178, 'Trinidad and Tobago'),
(179, 'Tunisia'),
(180, 'Turkey'),
(181, 'Turkmenistan'),
(182, 'Tuvalu'),
(183, 'Uganda'),
(184, 'Ukraine'),
(185, 'United Arab Emirates'),
(186, 'United Kingdom'),
(187, 'Uruguay'),
(188, 'Uzbekistan'),
(189, 'Vanuatu'),
(190, 'Vatican City'),
(191, 'Venezuela'),
(192, 'Vietnam'),
(193, 'Yemen'),
(194, 'Zambia'),
(195, 'Zimbabwe');

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

--
-- Table structure for table `designations`
--

CREATE TABLE `designations` (
  `id` int(10) NOT NULL,
  `name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `designations`
--

INSERT INTO `designations` (`id`, `name`) VALUES
(1, 'Accounts'),
(2, 'Actor/ Model'),
(3, 'Administration'),
(4, 'Agent'),
(5, 'Air Hosterss'),
(6, 'Airline Professional'),
(7, 'Analyst'),
(8, 'Architect'),
(9, 'Artist'),
(10, 'Auditor'),
(11, 'Banking'),
(12, 'Beautician'),
(13, 'Builder'),
(14, 'Bussiness Owner'),
(15, 'Chairman'),
(16, 'Chartered Accountant'),
(17, 'Civil Services'),
(18, 'Clerk'),
(19, 'Company Secretary'),
(20, 'Contractor'),
(21, 'Customer Service Professional'),
(22, 'Designer'),
(23, 'Director'),
(24, 'Driver'),
(25, 'Event Mangment'),
(26, 'Executive'),
(27, 'Fashion Designer'),
(28, 'Financial Accountant'),
(29, 'Hardware professional'),
(30, 'Healthcare Professional'),
(31, 'Interior Designer'),
(32, 'Jewellery Designer'),
(33, 'Lab Technician'),
(34, 'Lawyer'),
(35, 'Manager'),
(36, 'MBBS Student'),
(37, 'MD/MS'),
(38, 'MD/MS Student'),
(39, 'MDS'),
(40, 'Mechanic'),
(41, 'Media & Entertainiment'),
(42, 'Not Working'),
(43, 'Officer'),
(44, 'Photo / Videographer'),
(45, 'Physiotherapist'),
(46, 'Politician'),
(47, 'President'),
(48, 'Product Manager'),
(49, 'Project manager'),
(50, 'Scientist/ Researcher'),
(51, 'Secretary'),
(52, 'Social Worker'),
(53, 'Software Professional'),
(54, 'Student'),
(55, 'Supervisor'),
(56, 'Surgeon'),
(57, 'Tailor'),
(58, 'Technician'),
(59, 'Travel Profession'),
(60, 'Veterinary Doctor'),
(61, 'Web Designer'),
(62, 'None');

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

--
-- 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, 'B.tech', NULL, NULL),
(2, 'B.A', NULL, NULL),
(3, 'B.Arch', NULL, NULL),
(4, 'B.Com', NULL, NULL),
(5, 'B.Ed', NULL, NULL),
(6, 'B.Sc', NULL, NULL),
(7, 'B.Sc IT Computer Science', NULL, NULL),
(8, 'B.Sc Nursing', NULL, NULL),
(9, 'BBA', NULL, NULL),
(10, 'BDS', NULL, NULL),
(11, 'BPharma', NULL, NULL),
(12, 'BPT', NULL, NULL),
(13, 'Bussiness', NULL, NULL),
(14, 'CA', NULL, NULL),
(15, 'Degree', NULL, NULL),
(16, 'Diploma', NULL, NULL),
(17, 'Engineering', NULL, NULL),
(18, 'Finsncial Management ', NULL, NULL),
(19, 'Higher Secondary Shool', NULL, NULL),
(20, 'Hospital Administration', NULL, NULL),
(21, 'Hotel Management', NULL, NULL),
(22, 'IAS', NULL, NULL),
(23, 'IFC', NULL, NULL),
(24, 'Inter', NULL, NULL),
(25, 'IPS', NULL, NULL),
(26, 'IRS', NULL, NULL),
(27, 'LL.B', NULL, NULL),
(28, 'LL.M', NULL, NULL),
(29, 'M.A', NULL, NULL),
(30, 'M.Ed', NULL, NULL),
(31, 'M.L', NULL, NULL),
(32, 'M.S ( Engg)', NULL, NULL),
(33, 'M.Sc IT', NULL, NULL),
(34, 'M.tech', NULL, NULL),
(35, 'masters Degree in Legal', NULL, NULL),
(36, 'MBA', NULL, NULL),
(37, 'MBBS', NULL, NULL),
(38, 'MCA', NULL, NULL),
(39, 'MCAM Arch', NULL, NULL),
(40, 'Mcom', NULL, NULL),
(41, 'MD/MS( medical)', NULL, NULL),
(42, 'MDS', NULL, NULL),
(43, 'ME', NULL, NULL),
(44, 'MPharma', NULL, NULL),
(45, 'Other Bachelor Degree in Medicine', NULL, NULL),
(46, 'Other Degree in Service', NULL, NULL),
(47, 'Ph.D', NULL, NULL),
(48, 'SSC', NULL, NULL),
(49, 'Trade School', NULL, NULL);

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

--
-- 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 `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 `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'),
(18, 'None', NULL, NULL);

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

--
-- 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 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 `country_in`
--
ALTER TABLE `country_in`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `designations`
--
ALTER TABLE `designations`
  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 `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 `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 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 `country_in`
--
ALTER TABLE `country_in`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;

--
-- AUTO_INCREMENT for table `designations`
--
ALTER TABLE `designations`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `education_details`
--
ALTER TABLE `education_details`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- 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 `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 `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=19;

--
-- 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 `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;

