# Create shopping cart page and a menu link for it on the main menu.
INSERT INTO `pages` SET `site_id`=1, `category_id`=null, `content_type_id`=(SELECT `content_type_id` FROM `content_types` WHERE `filename`="cart"), `created`=NOW(), `title`="Shopping Cart", `title_heading_level`=1, `url`="cart", `description`=null, `content`=null, `rss`=0, `searchable`=0, `allow_url_segments`=1, `allow_url_query`=1, `published`=1;
SELECT MAX(page_id) FROM `pages` INTO @page_id;
INSERT INTO `menu_items` SET `menu_id`=1, `parent_id`=null, `title`="Shopping Cart", `page_id`=(SELECT MAX(page_id) FROM pages), `url`="", `target`="", `sort`=2, `published`=1;
SELECT MAX(menu_item_id) FROM `menu_items` INTO @menu_item_id;

INSERT INTO `content_values` SET `page_id`=@page_id, `key`="module", `value`="cart";
UPDATE `sites` SET `cart_page_id`=@page_id, `shop`=1 WHERE `site_id`=1 AND `cart_page_id` IS NULL;

# ACL
INSERT INTO `acl` SET `acl_role_id`=1, `page_id`=@page_id, `read`=1, `write`=0;
INSERT INTO `acl` SET `acl_role_id`=2, `page_id`=@page_id, `read`=1, `write`=0;
INSERT INTO `acl` SET `acl_role_id`=3, `page_id`=@page_id, `read`=1, `write`=1;
INSERT INTO `acl` SET `acl_role_id`=1, `menu_item_id`=@menu_item_id, `read`=1, `write`=0;
INSERT INTO `acl` SET `acl_role_id`=2, `menu_item_id`=@menu_item_id, `read`=1, `write`=0;
INSERT INTO `acl` SET `acl_role_id`=3, `menu_item_id`=@menu_item_id, `read`=1, `write`=1;
