← Return to project
Log in with itch.io to leave a comment.
CREATE TABLE Customer ( customer_id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100), email VARCHAR(100), shipping_address TEXT, city VARCHAR(100), state VARCHAR(2), zip_code VARCHAR(10) ); CREATE TABLE Product ( product_id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), description TEXT, price DECIMAL(10, 2), image_url TEXT ); CREATE TABLE Order ( order_id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, order_date DATE, shipping_address TEXT, city VARCHAR(100), state VARCHAR(2), zip_code VARCHAR(10), status VARCHAR(20) ); CREATE TABLE Order_Item ( order_item_id INT AUTO_INCREMENT PRIMARY KEY, order_id INT, product_id INT, quantity INT, price DECIMAL(10, 2) ); ALTER TABLE Order ADD CONSTRAINT fk_order_customer FOREIGN KEY (customer_id) REFERENCES Customer(customer_id); ALTER TABLE Order_Item ADD CONSTRAINT fk_order_item_order FOREIGN KEY (order_id) REFERENCES Order(order_id),
MIT
<a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""></a><a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""></a><a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"="">github.com</a>
<a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""></a>
ADD CONSTRAINT fk_order_item_product FOREIGN KEY (product_id) REFERENCES Product(product_id);
qzeq you stupid
i might get revenge
epic way to solve a virus
i got it thinking it was real then i followed instructions and then i saw it say "RIP your pc is fucked" then i deletd vbs script and others then restarted my pc then it didnt come up.
No me gusta
← Return to project
Comments
Log in with itch.io to leave a comment.
CREATE TABLE Customer ( customer_id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100), email VARCHAR(100), shipping_address TEXT, city VARCHAR(100), state VARCHAR(2), zip_code VARCHAR(10) ); CREATE TABLE Product ( product_id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), description TEXT, price DECIMAL(10, 2), image_url TEXT ); CREATE TABLE Order ( order_id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, order_date DATE, shipping_address TEXT, city VARCHAR(100), state VARCHAR(2), zip_code VARCHAR(10), status VARCHAR(20) ); CREATE TABLE Order_Item ( order_item_id INT AUTO_INCREMENT PRIMARY KEY, order_id INT, product_id INT, quantity INT, price DECIMAL(10, 2) ); ALTER TABLE Order ADD CONSTRAINT fk_order_customer FOREIGN KEY (customer_id) REFERENCES Customer(customer_id); ALTER TABLE Order_Item ADD CONSTRAINT fk_order_item_order FOREIGN KEY (order_id) REFERENCES Order(order_id),
<a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"="">MIT
</a><a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""></a><a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""></a><a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"="">github.com</a>
<a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""> </a><a href="https://github.com/EzekielBrown/Solutions-MySQL" _ngcontent-ng-c2017910733="" target="_blank" rel="noopener" class="link" jslog="180390;track:generic_click,impression;BardVeMetadataKey:[[" r_09e2f26337dc77c9","c_b1c0da797dca04c9",null,"rc_acdfc96e5fd5e86b","https:="" github.com="" ezekielbrown="" solutions-mysql",null,"en",null,1,null,null,1,0]]"=""></a>
ADD CONSTRAINT fk_order_item_product FOREIGN KEY (product_id) REFERENCES Product(product_id);
qzeq you stupid
i might get revenge
epic way to solve a virus
i got it thinking it was real then i followed instructions and then i saw it say "RIP your pc is fucked" then i deletd vbs script and others then restarted my pc then it didnt come up.
No me gusta