--
-- Constraints for dumped tables
--

--
-- Constraints for table `sblt_customers`
--
ALTER TABLE `sblt_customers`
  ADD CONSTRAINT `sblt_customers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `sblt_people` (`person_id`);

--
-- Constraints for table `sblt_employees`
--
ALTER TABLE `sblt_employees`
  ADD CONSTRAINT `sblt_employees_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `sblt_people` (`person_id`);

--
-- Constraints for table `sblt_inventory`
--
ALTER TABLE `sblt_inventory`
  ADD CONSTRAINT `sblt_inventory_ibfk_1` FOREIGN KEY (`trans_items`) REFERENCES `sblt_items` (`item_id`),
  ADD CONSTRAINT `sblt_inventory_ibfk_2` FOREIGN KEY (`trans_user`) REFERENCES `sblt_employees` (`person_id`),
  ADD CONSTRAINT `sblt_inventory_ibfk_3` FOREIGN KEY (`trans_location`) REFERENCES `sblt_stock_locations` (`location_id`);

--
-- Constraints for table `sblt_items`
--
ALTER TABLE `sblt_items`
  ADD CONSTRAINT `sblt_items_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `sblt_suppliers` (`person_id`);

--
-- Constraints for table `sblt_items_taxes`
--
ALTER TABLE `sblt_items_taxes`
  ADD CONSTRAINT `sblt_items_taxes_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`) ON DELETE CASCADE;

--
-- Constraints for table `sblt_item_kit_items`
--
ALTER TABLE `sblt_item_kit_items`
  ADD CONSTRAINT `sblt_item_kit_items_ibfk_1` FOREIGN KEY (`item_kit_id`) REFERENCES `sblt_item_kits` (`item_kit_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sblt_item_kit_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`)  ON DELETE CASCADE;

--
-- Constraints for table `sblt_permissions`
--
ALTER TABLE `sblt_permissions`
  ADD CONSTRAINT `sblt_permissions_ibfk_1` FOREIGN KEY (`module_id`) REFERENCES `sblt_modules` (`module_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sblt_permissions_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `sblt_stock_locations` (`location_id`) ON DELETE CASCADE;

--
-- Constraints for table `sblt_grants`
--
ALTER TABLE `sblt_grants`
  ADD CONSTRAINT `sblt_grants_ibfk_1` foreign key (`permission_id`) references `sblt_permissions` (`permission_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `sblt_grants_ibfk_2` foreign key (`person_id`) references `sblt_employees` (`person_id`) ON DELETE CASCADE;

--
-- Constraints for table `sblt_receivings`
--
ALTER TABLE `sblt_receivings`
  ADD CONSTRAINT `sblt_receivings_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `sblt_employees` (`person_id`),
  ADD CONSTRAINT `sblt_receivings_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `sblt_suppliers` (`person_id`);

--
-- Constraints for table `sblt_receivings_items`
--
ALTER TABLE `sblt_receivings_items`
  ADD CONSTRAINT `sblt_receivings_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`),
  ADD CONSTRAINT `sblt_receivings_items_ibfk_2` FOREIGN KEY (`receiving_id`) REFERENCES `sblt_receivings` (`receiving_id`);

--
-- Constraints for table `sblt_sales`
--
ALTER TABLE `sblt_sales`
  ADD CONSTRAINT `sblt_sales_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `sblt_employees` (`person_id`),
  ADD CONSTRAINT `sblt_sales_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `sblt_customers` (`person_id`);

--
-- Constraints for table `sblt_sales_items`
--
ALTER TABLE `sblt_sales_items`
  ADD CONSTRAINT `sblt_sales_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`),
  ADD CONSTRAINT `sblt_sales_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `sblt_sales` (`sale_id`),
  ADD CONSTRAINT `sblt_sales_items_ibfk_3` FOREIGN KEY (`item_location`) REFERENCES `sblt_stock_locations` (`location_id`);

--
-- Constraints for table `sblt_sales_items_taxes`
--
ALTER TABLE `sblt_sales_items_taxes`
  ADD CONSTRAINT `sblt_sales_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sblt_sales_items` (`sale_id`),
  ADD CONSTRAINT `sblt_sales_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`);

--
-- Constraints for table `sblt_sales_payments`
--
ALTER TABLE `sblt_sales_payments`
  ADD CONSTRAINT `sblt_sales_payments_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sblt_sales` (`sale_id`);

--
-- Constraints for table `sblt_sales_suspended`
--
ALTER TABLE `sblt_sales_suspended`
  ADD CONSTRAINT `sblt_sales_suspended_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `sblt_employees` (`person_id`),
  ADD CONSTRAINT `sblt_sales_suspended_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `sblt_customers` (`person_id`);

--
-- Constraints for table `sblt_sales_suspended_items`
--
ALTER TABLE `sblt_sales_suspended_items`
  ADD CONSTRAINT `sblt_sales_suspended_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`),
  ADD CONSTRAINT `sblt_sales_suspended_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `sblt_sales_suspended` (`sale_id`),
  ADD CONSTRAINT `sblt_sales_suspended_items_ibfk_3` FOREIGN KEY (`item_location`) REFERENCES `sblt_stock_locations` (`location_id`);

--
-- Constraints for table `sblt_sales_suspended_items_taxes`
--
ALTER TABLE `sblt_sales_suspended_items_taxes`
  ADD CONSTRAINT `sblt_sales_suspended_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sblt_sales_suspended_items` (`sale_id`),
  ADD CONSTRAINT `sblt_sales_suspended_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`);

--
-- Constraints for table `sblt_sales_suspended_payments`
--
ALTER TABLE `sblt_sales_suspended_payments`
  ADD CONSTRAINT `sblt_sales_suspended_payments_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `sblt_sales_suspended` (`sale_id`);

--
-- Constraints for table `sblt_item_quantities`
--
ALTER TABLE `sblt_item_quantities`
  ADD CONSTRAINT `sblt_item_quantities_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `sblt_items` (`item_id`),
  ADD CONSTRAINT `sblt_item_quantities_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `sblt_stock_locations` (`location_id`);

--
-- Constraints for table `sblt_suppliers`
--
ALTER TABLE `sblt_suppliers`
  ADD CONSTRAINT `sblt_suppliers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `sblt_people` (`person_id`);
  
--
-- Constraints for table `sblt_giftcards`
--
ALTER TABLE `sblt_giftcards`
  ADD CONSTRAINT `sblt_giftcards_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `sblt_people` (`person_id`);