   ADD CONSTRAINT `garage_sales_items_ibfk_2` FOREIGN KEY (`item_fk_id`) REFERENCES `items` (`item_id`) ON UPDATE CASCADE;
 
 --
--- Constraints for table `invoice`
---
-ALTER TABLE `invoice`
-  ADD CONSTRAINT `invoice_ibfk_1` FOREIGN KEY (`gsale_fk_id`) REFERENCES `garage_sales` (`gsale_id`) ON UPDATE CASCADE,
-  ADD CONSTRAINT `invoice_ibfk_2` FOREIGN KEY (`user_fk_id`) REFERENCES `users` (`user_id`) ON UPDATE CASCADE,
-  ADD CONSTRAINT `invoice_ibfk_3` FOREIGN KEY (`sold_by`) REFERENCES `users` (`user_id`) ON UPDATE CASCADE;
-
---
--- Constraints for table `login_attempts`
---
-ALTER TABLE `login_attempts`
-  ADD CONSTRAINT `login_attempts_ibfk_1` FOREIGN KEY (`user_fk_id`) REFERENCES `users` (`user_id`) ON UPDATE CASCADE;
-
---
--- Constraints for table `looking`
---
-ALTER TABLE `looking`
-  ADD CONSTRAINT `looking_ibfk_1` FOREIGN KEY (`user_fk_id`) REFERENCES `users` (`user_id`) ON UPDATE CASCADE,
-  ADD CONSTRAINT `looking_ibfk_2` FOREIGN KEY (`item_fk_id`) REFERENCES `items` (`item_id`) ON UPDATE CASCADE;
-
---
--- Constraints for table `users_phones`
---
-ALTER TABLE `users_phones`
-  ADD CONSTRAINT `users_phones_ibfk_1` FOREIGN KEY (`users_fk_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
-  ADD CONSTRAINT `users_phones_ibfk_2` FOREIGN KEY (`phones_fk_id`) REFERENCES `phones` (`phone_id`);
-
---
--- Constraints for table `users_places`
---
-ALTER TABLE `users_places`
-  ADD CONSTRAINT `users_places_ibfk_1` FOREIGN KEY (`user_fk_id`) REFERENCES `users` (`user_id`) ON UPDATE CASCADE,
-  ADD CONSTRAINT `users_places_ibfk_2` FOREIGN KEY (`places_fk_id`) REFERENCES `places` (`place_id`);
+-- Constraints for table `garage_sales_phones`
+--
+ALTER TABLE `garage_sales_phones`
+  ADD CONSTRAINT `garage_sales_phones_ibfk_1` FOREIGN KEY (`phone_fk_id`) REFERENCES `phones` (`phone_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `garage_sales_phones_ibfk_2` FOREIGN KEY (`garage_sale_fk_id`) REFERENCES `garage_sales` (`gsale_id`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `garage_sales_places`
+--
+ALTER TABLE `garage_sales_places`
+  ADD CONSTRAINT `garage_sales_places_ibfk_1` FOREIGN KEY (`garage_sale_fk_id`) REFERENCES `garage_sales` (`gsale_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `garage_sales_places_ibfk_2` FOREIGN KEY (`place_fk_id`) REFERENCES `places` (`place_id`) ON DELETE CASCADE ON UPDATE CASCADE;
+
+--
+-- Constraints for table `garage_sales_users`
+--
+ALTER TABLE `garage_sales_users`
+  ADD CONSTRAINT `garage_sales_users_ibfk_1` FOREIGN KEY (`garage_sales_fk_id`) REFERENCES `garage_sales` (`gsale_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `garage_sales_users_ibfk_2` FOREIGN KEY (`user_fk_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
 COMMIT;
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

-- Table structure for table `places`
--

DROP TABLE IF EXISTS `places`;
CREATE TABLE `places` (
  `place_id` int(22) NOT NULL,
  `address` varchar(95) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` int(11) NOT NULL,
  `country` varchar(3) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `places`
--

INSERT INTO `places` (`place_id`, `address`, `city`, `state`, `zip_code`, `country`) VALUES
(1, 'Saint Paul Campus 700 7th Street East', 'Saint Paul', 'MN', 55106, 'US'),
(2, 'Midway Center 1450 Energy Park Drive', 'Saint Paul', 'MN', 55108, 'US');

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


--

INSERT INTO `phones` (`phone_id`, `phone_number`) VALUES
(1, '(651)-681-0684');

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

