und Teil 2:
– Constraints der Tabelle s_order_attributes
ALTER TABLE s_order_attributes
ADD CONSTRAINT s_order_attributes_ibfk_1 FOREIGN KEY (orderID) REFERENCES s_order (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_basket_attributes
ALTER TABLE s_order_basket_attributes
ADD CONSTRAINT s_order_basket_attributes_ibfk_2 FOREIGN KEY (basketID) REFERENCES s_order_basket (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_billingaddress_attributes
ALTER TABLE s_order_billingaddress_attributes
ADD CONSTRAINT s_order_billingaddress_attributes_ibfk_2 FOREIGN KEY (billingID) REFERENCES s_order_billingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_details_attributes
ALTER TABLE s_order_details_attributes
ADD CONSTRAINT s_order_details_attributes_ibfk_1 FOREIGN KEY (detailID) REFERENCES s_order_details (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_documents_attributes
ALTER TABLE s_order_documents_attributes
ADD CONSTRAINT s_order_documents_attributes_ibfk_1 FOREIGN KEY (documentID) REFERENCES s_order_documents (ID) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_shippingaddress_attributes
ALTER TABLE s_order_shippingaddress_attributes
ADD CONSTRAINT s_order_shippingaddress_attributes_ibfk_1 FOREIGN KEY (shippingID) REFERENCES s_order_shippingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_premium_dispatch_attributes
ALTER TABLE s_premium_dispatch_attributes
ADD CONSTRAINT s_premium_dispatch_attributes_ibfk_1 FOREIGN KEY (dispatchID) REFERENCES s_premium_dispatch (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_product_streams_articles
ALTER TABLE s_product_streams_articles
ADD CONSTRAINT s_product_streams_articles_fk_article_id FOREIGN KEY (article_id) REFERENCES s_articles (id) ON DELETE CASCADE,
ADD CONSTRAINT s_product_streams_articles_fk_stream_id FOREIGN KEY (stream_id) REFERENCES s_product_streams (id) ON DELETE CASCADE;
– Constraints der Tabelle s_product_streams_attributes
ALTER TABLE s_product_streams_attributes
ADD CONSTRAINT s_product_streams_attributes_ibfk_1 FOREIGN KEY (streamID) REFERENCES s_product_streams (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_product_streams_selection
ALTER TABLE s_product_streams_selection
ADD CONSTRAINT s_product_streams_selection_fk_article_id FOREIGN KEY (article_id) REFERENCES s_articles (id) ON DELETE CASCADE,
ADD CONSTRAINT s_product_streams_selection_fk_stream_id FOREIGN KEY (stream_id) REFERENCES s_product_streams (id) ON DELETE CASCADE;
– Constraints der Tabelle s_user_addresses
ALTER TABLE s_user_addresses
ADD CONSTRAINT s_user_addresses_ibfk_1 FOREIGN KEY (country_id) REFERENCES s_core_countries (id) ON UPDATE CASCADE,
ADD CONSTRAINT s_user_addresses_ibfk_2 FOREIGN KEY (state_id) REFERENCES s_core_countries_states (id) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT s_user_addresses_ibfk_3 FOREIGN KEY (user_id) REFERENCES s_user (id) ON DELETE CASCADE ON UPDATE CASCADE;
– Constraints der Tabelle s_user_addresses_attributes
ALTER TABLE s_user_addresses_attributes
ADD CONSTRAINT s_user_addresses_attributes_ibfk_1 FOREIGN KEY (address_id) REFERENCES s_user_addresses (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_user_attributes
ALTER TABLE s_user_attributes
ADD CONSTRAINT s_user_attributes_ibfk_1 FOREIGN KEY (userID) REFERENCES s_user (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_user_billingaddress_attributes
ALTER TABLE s_user_billingaddress_attributes
ADD CONSTRAINT s_user_billingaddress_attributes_ibfk_1 FOREIGN KEY (billingID) REFERENCES s_user_billingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_user_shippingaddress_attributes
ALTER TABLE s_user_shippingaddress_attributes
ADD CONSTRAINT s_user_shippingaddress_attributes_ibfk_1 FOREIGN KEY (shippingID) REFERENCES s_user_shippingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;