 INSERT INTO `users` (`user_id`, `username`, `password`, `fname`, `lname`, `email`) VALUES
 (1, 'id4766wa', '$2y$10$3Sk7watLoZ.KPxZIf3kwUOyVA/MUy4f8M9vq7k5ciSppgFI3ETJmO', 'gary', 'webb', 'id4766wa@metrostate.edu'),
 (2, 'yn0619nj', '$2y$10$dvRizOKMZ9o0PjkX7qODIOSWr2CiKDgPRnXFImeritw8oE3cJslua', 'david', 'gruenberg', 'yn0619nj@metrostate.edu'),
-(3, 'dd0517tz', '$2y$10$WaTGBmAXOjJ/3tc4S//Wu.I7bswVXvgyX5Z40/xih.wWcfgHi89GC', 'yeshewa', 'berhane', 'dd0517tz@metrostate.edu'),
-(4, 'Jumperv3', '$2y$10$6TJJd59Fv3CyYo.secbNMu4/cow88wHvRDgn/bAPOnByW2SoD2./i', 'gary', 'webb', 'id4766wa@metrostate.edu');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `users_phones`
---
-
-DROP TABLE IF EXISTS `users_phones`;
-CREATE TABLE `users_phones` (
-  `users_fk_id` int(22) NOT NULL,
-  `phones_fk_id` int(22) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `users_phones`
---
-
-INSERT INTO `users_phones` (`users_fk_id`, `phones_fk_id`) VALUES
-(1, 1),
-(2, 1),
-(3, 1);
-
--- --------------------------------------------------------
-
---
--- Table structure for table `users_places`
---
-
-DROP TABLE IF EXISTS `users_places`;
-CREATE TABLE `users_places` (
-  `user_fk_id` int(22) NOT NULL,
-  `places_fk_id` int(22) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-
---
--- Dumping data for table `users_places`
---
-
-INSERT INTO `users_places` (`user_fk_id`, `places_fk_id`) VALUES
-(1, 1),
-(3, 2),
-(2, 1);
+(3, 'dd0517tz', '$2y$10$WaTGBmAXOjJ/3tc4S//Wu.I7bswVXvgyX5Z40/xih.wWcfgHi89GC', 'yeshewa', 'berhane', 'dd0517tz@metrostate.edu');
 
 --
 -- Indexes for dumped tables

-- Indexes for table `garage_sales`
--
ALTER TABLE `garage_sales`
  ADD PRIMARY KEY (`gsale_id`),
  ADD KEY `user_fk_id` (`user_fk_id`),
  ADD KEY `garage_sales_ibfk_1` (`places_fk_id`);

--
-- Indexes for table `garage_sales_items`

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

--
-- Table structure for table `looking`
--

CREATE TABLE `looking` (
  `user_fk_id` int(22) NOT NULL COMMENT 'user that is looking for an item',
  `item_fk_id` int(22) NOT NULL COMMENT 'item that matches users parameters'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `password_saver`
--

CREATE TABLE `password_saver` (
  `session_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date and time of login attempt',
  `user_fk_id` int(22) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `password_saver`
--

INSERT INTO `password_saver` (`session_id`, `time_stamp`, `user_fk_id`) VALUES
('ac77ce5c25df91ea9b2b32bfe085f568cd5475c99ab280238f3c91c44f32e8b5', '2017-11-04 09:02:40', 1);

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

