update admin_files set admin_new_group_id='7' where admin_files_name like 'create_order_new.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers_mainpage.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers_subscription_groups.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers_groups.php';

update admin_files set admin_new_group_id='7' where admin_files_name like 'customers_orders.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers_orders_refund.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers_invoice.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'customers_import.php';

update admin_files set admin_new_group_id='5' where admin_files_name like 'stats_customers.php';

update admin_files set admin_new_group_id='7' where admin_files_name like 'checkout_success.php';

update admin_files set admin_new_group_id='7' where admin_files_name like 'customers_create_order_process.php';

update admin_files set admin_new_group_id='8' where admin_files_name like 'customers_payment_wallet.php';

update admin_files set admin_new_group_id='21' where admin_files_name like 'reports_refund_products.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'admin_files.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'configuration.php';

update admin_files set admin_new_group_id='30' where admin_files_name like 'modules.php';

update admin_files set admin_new_group_id='30' where admin_files_name like 'paypal_notify.php';

update admin_files set admin_new_group_id='30' where admin_files_name like 'paypalipn_txn.php';

update admin_files set admin_new_group_id='30' where admin_files_name like 'paypalipn_tests.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'products_mainpage.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'products_create.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'products_manufacturers.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'banner_manager.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'banner_statistics.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'products_reviews.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'products_specials.php';

update admin_files set admin_new_group_id='18' where admin_files_name like 'products_expected.php';

update admin_files set admin_new_group_id='18' where admin_files_name like 'products_quick_popup.php';

update admin_files set admin_new_group_id='18' where admin_files_name like 'products_feactured.php';

update admin_files set admin_new_group_id='18' where admin_files_name like 'products_freight.php';

update admin_files set admin_new_group_id='18' where admin_files_name like 'products_options.php';

update admin_files set admin_new_group_id='15' where admin_files_name like 'marketing_products_message.php';

update admin_files set admin_new_group_id='11' where admin_files_name like 'marketing_affiliate_emarketing.php';

update admin_files set admin_new_group_id='11' where admin_files_name like 'marketing_affiliate_commission.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'stats_products_purchased.php';

update admin_files set admin_new_group_id='17' where admin_files_name like 'sales_maker.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'cache.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'server_info.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'myaccount_update_account.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'search_links.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'skynet_zone_settings.php';

update admin_files set admin_new_group_id='15' where admin_files_name like 'mail.php';

update admin_files set admin_new_group_id='15' where admin_files_name like 'marketing_newsletters.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'sales_xsell_products.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'products_easypopulate.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'products.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'products_export.php';

update admin_files set admin_new_group_id='16' where admin_files_name like 'products_import.php';

update admin_files set admin_new_group_id='2' where admin_files_name like 'cms_mainpage.php';

update admin_files set admin_new_group_id='2' where admin_files_name like 'cms_homepage.php';

update admin_files set admin_new_group_id='2' where admin_files_name like 'cms.php';

update admin_files set admin_new_group_id='21' where admin_files_name like 'reports_monthly_sales.php';

update admin_files set admin_new_group_id='21' where admin_files_name like 'sales_discount_coupons.php'; 

update admin_files set admin_new_group_id='21' where admin_files_name like 'sales_subscription_discounts.php'; 

update admin_files set admin_new_group_id='21' where admin_files_name like 'sales_services_discounts.php'; 

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_booking.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events.php';



update admin_files set admin_new_group_id='9' where admin_files_name like 'events_pop_questions.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_options.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_waitlists.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'send_email.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'send_sms_email.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_copy_messages.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_booking_search.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_copy_surveys.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_browse.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_payment_details.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_check_in.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_ticket.php';

update admin_files set admin_new_group_id='9' where admin_files_name like 'events_mainpage.php';

update admin_files set admin_new_group_id='27' where admin_files_name like 'services.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'marketing_email_messages.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'marketing_seo.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'marketing.php';

update admin_files set admin_new_group_id='21' where admin_files_name like 'sales.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'marketing_wallet.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'reports_wallet.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'reports.php';

update admin_files set admin_new_group_id='12' where admin_files_name like 'reports_general_customer_detail.php';

update admin_files set admin_new_group_id='21' where admin_files_name like 'sales_events_discounts.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'admin_letters.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'language_tool.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'language_admin.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'site_settings.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'configuration_new.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'quick_links.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'configuration_mainpage.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'menus.php';

update admin_files set admin_new_group_id='28' where admin_files_name like 'myaccount.php';

update admin_files set admin_new_group_id='27' where admin_files_name like 'send_services_messages_script_new.php';

update admin_files set admin_new_group_id='27' where admin_files_name like 'services_send_sms_messages.php';

update admin_files set admin_new_group_id='20' where admin_files_name like 'reports_general_customer_details.php';

update admin_files set admin_new_group_id='20' where admin_files_name like 'reports_general_call_center_orders.php';

update admin_files_groups set admin_files_groups_name='customers_orders' where admin_files_groups_id='7';

update admin_files_groups set admin_files_groups_name='Products' where admin_files_groups_id='16';

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