update `admin_menus_description` set menu_text='Site Maintenance' where menu_id='159';

update `admin_menus` set params='gID=16' where menu_id='159';

delete from `admin_menus` where menu_id='162';

delete from `admin_menus` where menu_id='163';

delete from `admin_menus_description` where menu_id='162';

delete from `admin_menus_description` where menu_id='163';

INSERT INTO `admin_menus` (`menu_id`, `parent_id`, `admin_groups_id`, `menu_pos`,  `filename`, `params`, `menu_item_type`)
VALUES  (323,104,'1',6,'reports_products_reconciliation.php','',''); 

INSERT INTO `admin_menus_description` (`menu_id`, `menu_text`, `language_id`) VALUES  (323,'Reconciliation',1); 

ALTER TABLE customers_basket ADD `discount_id` int(11) NOT NULL default '0';

ALTER TABLE orders_products ADD `discount_type` char(1) default NULL;
ALTER TABLE orders_products ADD `discount_text` varchar(200) default NULL;
ALTER TABLE orders_products ADD `discount_id` int(11) NOT NULL default '0';

ALTER TABLE salemaker_sales ADD `sale_discount_type` char(1) NOT NULL default 'S';
ALTER TABLE salemaker_sales ADD `choice_text` varchar(255) default '';
ALTER TABLE salemaker_sales ADD `choice_warning` text;
ALTER TABLE salemaker_sales ADD `sale_products_selected` text;
ALTER TABLE `salemaker_sales` MODIFY COLUMN `sale_categories_all` VARCHAR(255) NOT NULL default '';

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, 
`configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) 
VALUES (NULL,'Hide Product added text','HIDE_PRODUCT_ADDED_TEXT','false','Hide this product was added to our catalog ..',150,10,'2008-03-08 03:33:17','0000-00-00','','tep_cfg_select_option(array(''true'', ''false''),'),
(NULL,'Hide Also available','HIDE_ALSO_AVAILABLE','false','Hide the display of Also Available products on the 
homepage',150,11,'2008-03-08 03:33:20','0000-00-00','','tep_cfg_select_option(array(''true'', ''false''),');

Alter table salemaker_sales add apply_to_cross_sale char(1) NOT NULL default 'N';

INSERT INTO  admin_files (admin_files_name, admin_files_is_boxes, admin_files_to_boxes,  admin_groups_id,`admin_new_group_id`) values ('checkout_process.php',0,0,'1','100');

INSERT INTO  admin_files (admin_files_name, admin_files_is_boxes, admin_files_to_boxes,  admin_groups_id,`admin_new_group_id`) values ('checkout_payment.php',0,0,'1','101');

INSERT INTO  admin_files (admin_files_name, admin_files_is_boxes, admin_files_to_boxes,  admin_groups_id,`admin_new_group_id`) values ('customers_create_order_process.php',0,0,'1','102');

INSERT into sql_queries values('freeway_v1_3_6.sql',now());

