/* claw machine upgrade SKUs */
INSERT INTO product (sku, name, price, active, upgrade_id, group_id, priority)
VALUES ("1KW1", "200 Extra Tokens", 29, true, 54, 4, 50);

/*INSERT INTO product (sku, name, price, active, upgrade_id, group_id, priority)
VALUES ("TPE6", "Additional Stuffed Plushies", 0, false, 0, 4, 60);*/

INSERT INTO product (sku, name, price, active, upgrade_id, group_id, priority)
VALUES ("GAE4", "Setup for Quarters", 0, true, 52, 4, 70);

INSERT INTO product (sku, name, price, active, upgrade_id, group_id, priority)
VALUES ("3BA1", "Kids Always Win Mode", 0, true, 51, 4, 80);

INSERT INTO product (sku, name, price, active, upgrade_id, group_id, priority)
VALUES ("ZU7I", "Dollar Bill Acceptor", 269, true, 50, 4, 60);

INSERT INTO website_info(name, description, img_url, product_id, old_price, is_sale_priced)
SELECT name, "", "", id, 0, 0
FROM product WHERE product.group_id = 4;

INSERT INTO arcade_info(arcade_type_id, web_name, cart_name, sku, price, old_price, shipping, in_stock, valid)
VALUES (8, "Dreamcade® Claw Machine", "Dream Arcades Claw Machine", "claw", 1699, 1799, 495, true, true);

/* 200 Extra Tokens */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET old_price = 49,
description = "Each of our Claw Crane machines include 100 free tokens. Plus you can add 200 more (for 300 total) and never have to worry about running out!",
img_url = "images/clawMachine/coins.jpg",
w.name = "200 Extra Tokens"
WHERE sku = "1KW1";

/* Setup for Quarters */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET description = "This full-sized claw machine game for sale is designed for use with the included standard US tokens. However, we can pre-configure the crane machine for quarters at no charge. Want to change it later? It's no problem as it's simple to change to accept any coin.",
w.name = "Set to accept quarters"
WHERE sku = "GAE4";

/* Kids Always Win Mode */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET description = 'Hate Losing? Or maybe you want to get your kids to do chores in exchange for a prize? With our exclusive "Kids Always Win" mode, one token allows your kid to play until they win a prize! Plus, you can easily turn off this setting!',
w.name = "Kids Always Win Mode"
WHERE sku = "3BA1";

/* Dollar Bill Acceptor */
UPDATE product AS p
JOIN website_info AS w ON p.id = w.product_id
SET old_price = 299,
description = "While designed for home use, the Dreamcade Claw Machine is built to commercial specifications, and can easily be used in a public location. Adding a bill acceptor will enable your customers to pay with $1, $5, $10 or $20's. This add-on may delay your shipping date while we install and configure it.",
img_url = "images/clawMachine/bill.jpg",
w.name = "Dollar Bill Acceptor"
WHERE sku = "ZU7I";