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

START TRANSACTION;



--
-- Database: `soulmate`
--

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

--
-- Table structure for table `career`
--

CREATE TABLE IF NOT EXISTS `career` (
  `uid` int(11) NOT NULL,
  `status` varchar(30) NOT NULL,
  `job_desc` text NOT NULL,
  `college` text,
  `entre` enum('yes','no') DEFAULT NULL,
  `owns_biz` text,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `career`
--

INSERT INTO `career` (`uid`, `status`, `job_desc`, `college`, `entre`, `owns_biz`) VALUES
(3, 'working', 'Designer', 'Nike Inc', 'no', ''),
(4, 'student', 'Microbiology', 'Caltech', 'yes', 'zivame.com'),
(5, 'working', 'Historian', 'Discovery Inc', 'yes', 'Truffler.co'),
(6, 'student', 'Psychiatry', 'Chowgule College', 'no', ''),
(8, 'student', 'CSE', 'GEC', 'yes', 'Shopify.in'),
(9, 'student', 'Computer Science', 'IIT-B', 'no', ''),
(10, 'working', 'Hair Stylist', 'L\'oreal Paris', 'no', ' '),
(11, 'working', 'Gamer', 'Ubisoft', 'no', ' '),
(12, 'working', 'actor', 'disney studios', 'yes', ' learnacting.com'),
(13, 'working', 'dancer', 'Pro Dance Academy', 'yes', 'prodancer.com'),
(14, 'student', 'biotech engg', 'IIIT-B', 'no', ' '),
(15, 'working', 'Lead Animator', 'Microsoft India', 'no', ' '),
(16, 'working', 'Ex-CEO', 'Microsoft Inc', 'yes', 'Microsoft Inc'),
(17, 'working', 'Software Developer', 'TCS', 'no', ''),
(18, 'student', 'CSE', 'IIT-B', 'yes', 'I run my family biyaatch'),
(19, 'student', 'you', 'your heart', 'no', ''),
(20, 'working', 'Business', 'Wayne Towers', 'yes', 'Gotham CLub'),
(21, 'working', 'Spiderman', 'MCU', 'yes', 'Pizza Boii'),
(23, 'working', 'Heart Surgeon', 'Apollo Hospital', 'no', ''),
(28, 'Working', 'Engineer', 'SpaceX', 'yes', 'Tesla Inc'),
(29, 'working', 'Engineer', 'Amazon', 'yes', 'AWS');

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

--
-- Table structure for table `hobbies`
--

CREATE TABLE IF NOT EXISTS `hobbies` (
  `uid` int(11) NOT NULL,
  `streaming_movies_and_shows` enum('1','0') NOT NULL,
  `anime` enum('1','0') NOT NULL,
  `stand_up_comedy` enum('1','0') NOT NULL,
  `reading` enum('1','0') NOT NULL,
  `writing` enum('1','0') NOT NULL,
  `meditation` enum('1','0') NOT NULL,
  `music` enum('1','0') NOT NULL,
  `eating` enum('1','0') NOT NULL,
  `dancing` enum('1','0') NOT NULL,
  `singing` enum('1','0') NOT NULL,
  `baking` enum('1','0') NOT NULL,
  `cooking` enum('1','0') NOT NULL,
  `gardening` enum('1','0') NOT NULL,
  `arts_and_crafts` enum('1','0') NOT NULL,
  `painting` enum('1','0') NOT NULL,
  `sketching` enum('1','0') NOT NULL,
  `fishing` enum('1','0') NOT NULL,
  `running` enum('1','0') NOT NULL,
  `walking` enum('1','0') NOT NULL,
  `swimming` enum('1','0') NOT NULL,
  `working_out` enum('1','0') NOT NULL,
  `yoga` enum('1','0') NOT NULL,
  `bicycling` enum('1','0') NOT NULL,
  `driving` enum('1','0') NOT NULL,
  `riding` enum('1','0') NOT NULL,
  `sports` enum('1','0') NOT NULL,
  `video_games` enum('1','0') NOT NULL,
  `travelling` enum('1','0') NOT NULL,
  `hiking` enum('1','0') NOT NULL,
  `collecting` enum('1','0') NOT NULL,
  `volunteer_work` enum('1','0') NOT NULL,
  `working` enum('1','0') NOT NULL,
  `audiobooks_and_podcasts` enum('1','0') NOT NULL,
  `youtube` enum('1','0') NOT NULL,
  `social_media` enum('1','0') NOT NULL,
  `housework` enum('1','0') NOT NULL,
  `shopping` enum('1','0') NOT NULL,
  `coding` enum('1','0') NOT NULL,
  `hacking` enum('1','0') NOT NULL,
  `photoshop` enum('1','0') NOT NULL,
  `video_editing` enum('1','0') NOT NULL,
  `filmmaking` enum('1','0') NOT NULL,
  `science` enum('1','0') NOT NULL,
  `astronomy` enum('1','0') NOT NULL,
  `astrology` enum('1','0') NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `hobbies`
--

INSERT INTO `hobbies` (`uid`, `streaming_movies_and_shows`, `anime`, `stand_up_comedy`, `reading`, `writing`, `meditation`, `music`, `eating`, `dancing`, `singing`, `baking`, `cooking`, `gardening`, `arts_and_crafts`, `painting`, `sketching`, `fishing`, `running`, `walking`, `swimming`, `working_out`, `yoga`, `bicycling`, `driving`, `riding`, `sports`, `video_games`, `travelling`, `hiking`, `collecting`, `volunteer_work`, `working`, `audiobooks_and_podcasts`, `youtube`, `social_media`, `housework`, `shopping`, `coding`, `hacking`, `photoshop`, `video_editing`, `filmmaking`, `science`, `astronomy`, `astrology`) VALUES
(3, '1', '0', '1', '0', '1', '1', '0', '1', '1', '1', '0', '0', '1', '0', '1', '0', '0', '1', '0', '1', '0', '0', '1', '0', '1', '0', '0', '0', '1', '1', '1', '0', '1', '1', '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', '1'),
(4, '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '0', '0', '0', '1', '0', '0', '0', '1', '0', '0', '1', '1', '0', '0', '1', '0', '1', '0', '1', '0', '1', '1', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '1'),
(5, '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0'),
(6, '1', '0', '0', '0', '0', '0', '1', '1', '0', '0', '1', '0', '1', '0', '0', '1', '0', '0', '1', '1', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '0', '1'),
(8, '1', '0', '1', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '1', '0', '1', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(9, '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', '1', '0', '0', '0', '0', '1', '0', '1', '1', '1', '0', '1', '1', '1', '0', '1', '1', '1', '1', '0', '1', '1', '1'),
(16, '1', '0', '0', '1', '0', '1', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '1', '1', '0', '1', '1', '0', '0', '0', '0', '0', '1', '1', '1', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0'),
(17, '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '1', '1', '1', '1', '1', '1'),
(18, '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0'),
(19, '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '0', '1', '1', '0', '0', '0', '1', '1', '0', '0', '0', '0'),
(20, '0', '1', '0', '0', '1', '0', '0', '0', '1', '0', '0', '0', '1', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '1', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0'),
(21, '1', '1', '1', '0', '0', '1', '1', '1', '1', '0', '0', '1', '1', '1', '1', '0', '0', '1', '0', '0', '1', '1', '1', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '1'),
(23, '1', '0', '0', '0', '1', '1', '1', '1', '0', '1', '0', '1', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '1', '0', '1', '1', '0', '1', '0', '1', '0', '0', '0', '0'),
(28, '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1'),
(29, '1', '1', '0', '1', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '1', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '1', '0', '1', '1', '0', '0', '0', '1', '0', '0', '0', '0');

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

--
-- Table structure for table `match`
--

CREATE TABLE IF NOT EXISTS `match` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `uid1` int(11) NOT NULL,
  `uid2` int(11) NOT NULL,
  `status` enum('pending','match','blocked') NOT NULL,
  `first_liked_by` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`mid`),
  KEY `uid1` (`uid1`),
  KEY `uid2` (`uid2`),
  KEY `first_liked_by` (`first_liked_by`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `match`
--

INSERT INTO `match` (`mid`, `uid1`, `uid2`, `status`, `first_liked_by`, `created_at`) VALUES
(59, 28, 3, 'match', 28, '2022-06-24 21:29:31'),
(60, 28, 4, 'blocked', 28, '2022-06-24 21:29:34'),
(61, 29, 3, 'match', 29, '2022-06-27 11:25:10'),
(62, 29, 4, 'blocked', 29, '2022-06-27 11:25:12'),
(63, 29, 6, 'blocked', 29, '2022-06-27 11:25:13'),
(64, 29, 9, 'pending', 29, '2022-06-27 11:25:14'),
(65, 29, 10, 'blocked', 29, '2022-06-27 11:34:13');

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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `incoming_msg_id` int(255) NOT NULL,
  `outgoing_msg_id` int(255) NOT NULL,
  `msg` varchar(1000) NOT NULL,
  PRIMARY KEY (`msg_id`),
  KEY `incoming_msg_id` (`incoming_msg_id`),
  KEY `outgoing_msg_id` (`outgoing_msg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`msg_id`, `incoming_msg_id`, `outgoing_msg_id`, `msg`) VALUES
(32, 879670352, 886245528, 'Hey Jane!'),
(33, 886245528, 879670352, 'Oh hello Elon :)');

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

--
-- Table structure for table `notification`
--

CREATE TABLE IF NOT EXISTS `notification` (
  `nid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `type` enum('match','default','chat') NOT NULL,
  `content` text NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `seen_by_user` enum('yes','no') DEFAULT 'no',
  PRIMARY KEY (`nid`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`nid`, `uid`, `type`, `content`, `created_at`, `seen_by_user`) VALUES
(2, 5, 'default', 'Welcome to SoulMate!', '2021-12-11 07:52:52', 'yes'),
(3, 5, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-11 07:52:52', 'yes'),
(5, 3, 'default', 'Welcome to SoulMate!', '2021-12-12 11:39:09', 'yes'),
(6, 3, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-12 11:39:09', 'yes'),
(7, 4, 'default', 'Welcome to SoulMate!', '2021-12-12 11:51:28', 'yes'),
(8, 4, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-12 11:51:28', 'yes'),
(9, 6, 'default', 'Welcome to SoulMate!', '2021-12-12 11:57:45', 'yes'),
(10, 6, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-12 11:57:45', 'yes'),
(11, 9, 'default', 'Welcome to SoulMate!', '2021-12-12 12:03:18', 'yes'),
(12, 9, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-12 12:03:18', 'yes'),
(39, 16, 'default', 'Welcome to SoulMate!', '2021-12-16 11:23:01', 'yes'),
(40, 16, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-16 11:23:01', 'yes'),
(49, 17, 'default', 'Welcome to SoulMate!', '2021-12-16 21:25:16', 'yes'),
(50, 17, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-16 21:25:16', 'yes'),
(51, 18, 'default', 'Welcome to SoulMate!', '2021-12-17 05:48:44', 'yes'),
(52, 18, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-17 05:48:44', 'yes'),
(55, 19, 'default', 'Welcome to SoulMate!', '2021-12-17 06:32:19', 'yes'),
(56, 19, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-17 06:32:19', 'yes'),
(59, 20, 'default', 'Welcome to SoulMate!', '2021-12-17 08:01:03', 'yes'),
(60, 20, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-17 08:01:03', 'yes'),
(63, 21, 'default', 'Welcome to SoulMate!', '2021-12-18 20:21:09', 'yes'),
(64, 21, 'default', 'Browse through recommendations to find your perfect match!', '2021-12-18 20:21:09', 'yes'),
(65, 23, 'default', 'Welcome to SoulMate!', '2022-01-06 18:09:24', 'yes'),
(66, 23, 'default', 'Browse through recommendations to find your perfect match!', '2022-01-06 18:09:24', 'yes'),
(67, 28, 'default', 'Welcome to SoulMate!', '2022-06-24 21:27:26', 'yes'),
(68, 28, 'default', 'Browse through recommendations to find your perfect match!', '2022-06-24 21:28:02', 'yes'),
(71, 28, 'match', 'You have matched with Jane!', '2022-06-24 21:44:17', 'no'),
(72, 3, 'match', 'You have matched with Elon!', '2022-06-24 21:44:17', 'yes'),
(73, 29, 'default', 'Welcome to SoulMate!', '2022-06-27 11:22:51', 'yes'),
(74, 29, 'default', 'Browse through recommendations to find your perfect match!', '2022-06-27 11:22:51', 'yes'),
(75, 29, 'match', 'You have matched with Jane!', '2022-06-27 11:27:03', 'no'),
(76, 3, 'match', 'You have matched with Jeff!', '2022-06-27 11:27:03', 'no');

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

--
-- Table structure for table `social`
--

CREATE TABLE IF NOT EXISTS `social` (
  `uid` int(11) NOT NULL,
  `ig` varchar(30) DEFAULT NULL,
  `sc` varchar(30) DEFAULT NULL,
  `twit` varchar(30) DEFAULT NULL,
  `fb` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `social`
--

INSERT INTO `social` (`uid`, `ig`, `sc`, `twit`, `fb`) VALUES
(3, 'jane12', 'janexoxo', '', ''),
(4, 'prianke12', 'priya', '', 'Priyanka Tripathi'),
(5, 'kashyap010', '', '', ''),
(6, 'pratima121', '', 'pratusmorty', ''),
(8, '_.joel._.fernandes._', 'momojojo1690', '_JoelFernandes_', 'Joel Fernandes'),
(9, 'shizushizu121_23', 'shizukayy', 'shizukayy', 'Shizuka D\'sa'),
(16, 'billyboy', '', '', ''),
(17, 'TonyRodrigo', '', 'Tony Rodrigoes', ''),
(18, 'shivashiv', '', '', ''),
(19, 'shashi', '', '', ''),
(20, 'hgfhg', '', 'hff', ''),
(21, '', '', '', ''),
(23, 'gigolo121', '', 'Gigolo2122', ''),
(29, 'jeff.bezos', '', 'jeff@bezos', '');

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

--
-- Table structure for table `userprofile`
--

CREATE TABLE IF NOT EXISTS `userprofile` (
  `uid` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `age` int(2) NOT NULL,
  `gender` enum('M','F') NOT NULL,
  `height` text,
  `weight` text,
  `latitude` text NOT NULL,
  `longitude` text NOT NULL,
  `profile_photo` varchar(100) NOT NULL,
  `bio` text NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `userprofile`
--

INSERT INTO `userprofile` (`uid`, `name`, `age`, `gender`, `height`, `weight`, `latitude`, `longitude`, `profile_photo`, `bio`) VALUES
(3, 'Jane Dias', 21, 'F', '172', '50', '15.2756659', '73.9780985', './public/user-profiles/user-10-8.jpg', 'Wanderer, Reader, Conquistador '),
(4, 'Priyanka Tripathi', 25, 'F', '168', '60', '15.2742894', '73.9731740', './public/user-profiles/user-4-3.jpg', 'My profile is enough to make an impression :3'),
(5, 'Kashyap Shirodkar', 18, 'M', '11', '12', '15.2768872', '73.9692472', './public/user-profiles/user-5-photo-1529665253569-6d01c0eaf7b6.jpg', 'I shall ask God how good you are'),
(6, 'Pratima Joshi', 18, 'F', '', '', '15.2680897', '73.9716397', './public/user-profiles/user-13-8.jpg', 'I go where life takes me\r\nNever regret anything in life\r\nLove travelling and singing'),
(8, 'joel ferns', 21, 'M', '170', '69', '15.2669305', '73.9535295', './public/user-profiles/user-8-1.jpg', 'COMP\r\nC - Charismatic\r\nO - (my blood group hehe xd)\r\nM - Member of Illuminati \r\nP - Pakistan mein gaya tha bhag ke wapas aya'),
(9, 'Shizuka D\'souza', 28, 'F', '140', '70', '15.2753347', '73.9531861', './public/user-profiles/user-9-4.jpg', 'Geek, Geek and Beautiful'),
(10, 'Miley Joseph', 21, 'F', ' ', ' ', '15.2619209', '73.9685498', './public/user-profiles/user-10-5.jpg', 'I love working out a lot!'),
(11, 'Shloka Naik', 25, 'F', '160', '52', '15.2465603', '74.0019809', './public/user-profiles/user-11-6.jpg', 'India\'s best procrastinator'),
(12, 'Trixie Pixie', 20, 'F', '160', '52', '15.2565800', '74.0139972', './public/user-profiles/user-12-7.jpg', 'Best known for eating vadapavs endlessly'),
(13, 'Meenal Shanku', 26, 'F', '160', '52', '15.2340142', '73.9760171', './public/user-profiles/user-13-3.jpg', 'Stoic, OSHO....\r\nAlso, world sucks :)'),
(14, 'Angelina Ferns', 19, 'F', '160', '52', '15.2648540', '73.9778174', './public/user-profiles/user-14-9.jpg', 'No I don\'t date Nathan Ferns'),
(15, 'Nandita Chowdhary', 18, 'F', '160', '52', '15.2609519', '73.9742877', './public/user-profiles/user-15-10.jpg', 'Bengal is best state of India. \r\nDon\'t prove me wrong. \r\nIdc actually.'),
(16, 'Bill Gates', 40, 'M', '', '', '18.6161', '73.7286', './public/user-profiles/user-16-pexels-italo-melo-2379004.jpg', 'I run Microsoft Inc\r\nPlayboy pimp for life\r\nI hate Belinda Gates so I divorced her'),
(17, 'Tony Martinez', 25, 'M', '', '', '15.265501', '73.9806075', './public/user-profiles/user-17-pexels-pixabay-220453.jpg', 'I am Tony\r\nI suck at Origami\r\nAaj blue hai pani-pani\r\nKabhi hume sunao tumhari kahani'),
(18, 'Shivam Dessai', 20, 'M', '', '', '18.5204303', '73.8567437', './public/user-profiles/user-18-shivam.jpg', 'Fitness Freak\r\nKTM Bro\r\nJo mai bolta hoon wo mai definitely karta hoon'),
(19, 'Shashikala Kholapurkar', 22, 'F', '', '', '18.5204303', '73.8567437', './public/user-profiles/user-19-female-photo_2021-12-17_11-11-49.jpg', 'I believe in breaking stereotypes'),
(20, 'Bruce  Wayne', 21, 'M', '', '', '20.0063', '77.006', './public/user-profiles/user-20-chris-bale.jpg', 'I am Bruce Wayne\r\n(secretly Batman)'),
(21, 'Toby Maguire', 31, 'M', '', '', '15.2655249', '73.9806296', './public/user-profiles/user-21-spiderman-3-2007_4bc992ca-b799-11ea-bb4b-1e210f9e7edf.jpg', 'I was cast as the 1st Spiderman in MCU'),
(23, 'Gigolo Georgiovani', 30, 'M', '', '', '15.2655525', '73.9804974', './public/user-profiles/user-23-giovani.jpg', 'My life is as interesting as my name...\r\nHmu for intriguing conversations!'),
(28, 'Elon Musk', 50, 'M', ' ', ' ', '15.2756669', '73.8567437', './public/user-profiles/user-28-elon-musk.jpg', 'Smartest Man in the Universe'),
(29, 'Jeff Bezos', 54, 'M', '', '', '15.2756661', '73.9780988', './public/user-profiles/user-29-jeff-bezos.jpeg', 'I run Amazon.Inc');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `career`
--
ALTER TABLE `career`
  ADD CONSTRAINT `career_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `usertable` (`uid`);

--
-- Constraints for table `hobbies`
--
ALTER TABLE `hobbies`
  ADD CONSTRAINT `hobbies_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `usertable` (`uid`);

--
-- Constraints for table `match`
--
ALTER TABLE `match`
  ADD CONSTRAINT `match_ibfk_1` FOREIGN KEY (`uid1`) REFERENCES `usertable` (`uid`),
  ADD CONSTRAINT `match_ibfk_2` FOREIGN KEY (`uid2`) REFERENCES `usertable` (`uid`),
  ADD CONSTRAINT `match_ibfk_3` FOREIGN KEY (`first_liked_by`) REFERENCES `usertable` (`uid`);

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`incoming_msg_id`) REFERENCES `usertable` (`unique_id`),
  ADD CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`outgoing_msg_id`) REFERENCES `usertable` (`unique_id`);

--
-- Constraints for table `notification`
--
ALTER TABLE `notification`
  ADD CONSTRAINT `notification_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `usertable` (`uid`);

--
-- Constraints for table `social`
--
ALTER TABLE `social`
  ADD CONSTRAINT `social_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `usertable` (`uid`);

--
-- Constraints for table `userprofile`
--
ALTER TABLE `userprofile`
  ADD CONSTRAINT `userprofile_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `usertable` (`uid`);
COMMIT;

