INSERT INTO admin_files ( admin_files_name, admin_files_is_boxes, admin_files_to_boxes, admin_groups_id) VALUES ( 'customers_orders_refund.php', 1, 1, '1');

INSERT INTO `orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES (5,1,'Refunded');

DROP TABLE IF EXISTS `refunds`;
CREATE TABLE `refunds` (
  `orders_id` int(11) NOT NULL,
  `customers_id` int(11) NOT NULL,
  `refund_type` char(1) NOT NULL default 'F',
  `amount_type` char(1) NOT NULL default 'A',
  `refund_amount` decimal(8,2) NOT NULL,
  `comments` text,
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO admin_files ( admin_files_name, admin_files_is_boxes, admin_files_to_boxes, admin_groups_id) VALUES ( 'reports_refund_products.php', 1, 8, '1');

INSERT INTO `admin_menus` (`menu_id`, `parent_id`, `admin_groups_id`, `menu_pos`, `filename`, `params`, `menu_item_type`) VALUES 
(301,1,'1',301,'customers_orders.php','','');

INSERT INTO `admin_menus_description` (`menu_id`, `menu_text`, `language_id`) VALUES 
(301,'Orders',1);


INSERT INTO `admin_menus` (`menu_id`, `parent_id`, `admin_groups_id`, `menu_pos`, `filename`, `params`, `menu_item_type`) VALUES 
(305,102,'1',248,'reports_refund_products.php','','');

INSERT INTO `admin_menus_description` (`menu_id`, `menu_text`, `language_id`) VALUES 
(305,'Refunds',1);


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