MYSQL VERSION=>8
STARTING UPDATE(s)
Creating Table languages..
Table languages already exist.

Creating Table stripe_logs..
Table stripe_logs already exist.

Updating Table admin_user.
Field user_lang already exist
Field email_address already exist
Field lost_password_code already exist

Creating Table sms_broadcast..
Table sms_broadcast already exist.
Creating Table sms_broadcast_details..
Table sms_broadcast_details already exist.
Creating Table sms_package..
Table sms_package already exist.
Creating Table sms_broadcast_details..
Table sms_package_trans already exist.
Creating Table payment_order..
Table payment_order already exist.

Updating Table merchant.
Field user_lang already exist
Field membership_purchase_date already exist
Field sort_featured already exist
Field is_commission already exist
Field percent_commision already exist


Updating Table packages.
Field sell_limit already exist

Creating Table merchant_user..
Table merchant_user already exist.

Updating Table payment_order.
Field payment_type already exist


Updating Table client.
Field status already exist
Field token already exist
Field mobile_verification_code already exist
Field mobile_verification_date already exist
Field custom_field1 already exist
Field custom_field2 already exist
Field avatar already exist
Field email_verification_code already exist

Creating Table bookingtable..
Table bookingtable already exist.

Updating Booking table
Field status already exist
Field viewed already exist

Updating Table bank_deposit..
(Done)

Updating Bank deposit table
Field transaction_type already exist
Field client_id already exist
Field order_id already exist


Updating custom_page table
Field open_new_tab already exist
Field is_custom_link already exist


Updating order table
Field order_change already exist
Field payment_provider_name already exist
Field discounted_amount already exist
Field discount_percentage already exist
Field percent_commision already exist
Field total_commission already exist
Field commision_ontop already exist
Field merchant_earnings already exist
Field packaging already exist
Field cart_tip_percentage already exist
Field cart_tip_value already exist
Field card_fee already exist
Field donot_apply_tax_delivery already exist
Field order_locked already exist
Field request_from already exist
Field mobile_cart_details already exist

Creating Table _payment_provider..
(Done)
Creating Table _offers..
(Done)
Creating Table _newsletter..
(Done)

Updating Table sms_broadcast_details.
Field gateway already exist

Creating Table barclay_trans..
(Done)
Creating Table ingredients..
(Done)
Field ingredients already exist
Field spicydish already exist
Field two_flavors already exist
Field two_flavors_position already exist
Field require_addon already exist
Field dish already exist
Field item_name_trans already exist
Field item_description_trans already exist
Field non_taxable already exist
Field not_available already exist
Field gallery_photo already exist

Field ingredients already exist
Field non_taxable already exist

Creating Table withdrawal..
(Done)
Field bank_type already exist

Field contact_email already exist
Field session_token already exist

Field abn already exist
Field session_token already exist
Field commision_type already exist

Creating Table fax_package..
(Done)
Creating Table fax_package_trans..
(Done)
Creating Table fax_broadcast..
(Done)
Creating Table shipping_rate..
(Done)
Field spicydish already exist
Field spicydish_notes already exist
Field dish already exist
Field category_name_trans already exist
Field category_description_trans already exist

Field session_token already exist
Field last_login already exist
Field user_access already exist

Creating Table order_delivery_address..
(Done)
Field fee already exist

Field contact_phone already exist

Field status already exist
Field subcategory_name_trans already exist
Field subcategory_description_trans already exist

        ALTER TABLE {{currency}} CHANGE 
       `currency_symbol` `currency_symbol` VARCHAR( 100 )  
        CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
Creating Table dishes..
(Done)
Creating Table voucher_new..
(Done)
Creating Table address_book..
(Done)
Field size_name_trans already exist

Field ingredients_name_trans already exist

Field sub_item_name_trans already exist
Field item_description_trans already exist

Field cooking_name_trans already exist

Field used_once already exist

Field order_id already exist

Creating Table order_history..
(Done)
Creating Table order_sms..
(Done)
Creating Table zipcode..
(Done)
Field cuisine_name_trans already exist

Field parent_cat_id already exist

Updating table order_delivery_address
Field formatted_address already exist
Field google_lat already exist
Field google_lng already exist
Updating table bookingtable
Field client_id already exist
Updating table client
Field is_guest already exist
Creating Table receive_post..
(Done)
Creating Table email_logs..
(Done)
Field email_provider already exist
Creating Table minimum_table..
(Done)
Updating table _order
Field apply_food_tax already exist
Field order_id_token already exist
Field admin_viewed already exist
Field merchantapp_viewed already exist
Field dinein_number_of_guest already exist
Field dinein_special_instruction already exist
Field critical already exist
Field commision_type already exist
Updating table _merchant
Field merchant_key already exist
Field latitude already exist
Field lontitude already exist
Field delivery_charges already exist
Field minimum_order already exist
Field delivery_minimum_order already exist
Field delivery_maximum_order already exist
Field pickup_minimum_order already exist
Field pickup_maximum_order already exist
Field country_name already exist
Field country_id already exist
Field state_id already exist
Field city_id already exist
Field area_id already exist
Field logo already exist
Field merchant_type already exist
Field invoice_terms already exist
Creating Table bookingtable_history..
(Done)
Creating Table location_area..
(Done)
Creating Table location_cities..
(Done)
Creating Table location_countries..
(Done)
Creating Table location_states..
(Done)
Creating Table location_rate..
(Done)
Updating table order_delivery_address
Field area_name already exist
Creating Table invoice..
(Done)
Creating Table invoice_history..
(Done)
Updating table review
Field parent_id already exist
Field reply_from already exist
Field date_modified already exist
Field cc_id already exist
Updating table order
Field sofort_trans_id already exist
Updating table offers
Field applicable_to already exist
Updating table order
Field calculation_method already exist
Updating table order
Field request_cancel already exist
Field request_cancel_viewed already exist
Field request_cancel_status already exist
Creating Table address_book_location..
(Done)
Updating table item
Field packaging_fee already exist
Field packaging_incremental already exist
Updating table category
Field monday already exist
Field tuesday already exist
Field wednesday already exist
Field thursday already exist
Field friday already exist
Field saturday already exist
Field sunday already exist
Creating table favorites
(Done)
Updating table order
Field dinein_table_number already exist
Creating table sms_trans_logs
(Done)
Updating table package_trans
Field merchant_ref already exist
Updating table sms_package_trans
Field merchant_ref already exist
Updating table payment_order
Field merchant_ref already exist
Updating table cuisine
Field status already exist
Field featured_image already exist
Field payment_gateway_ref already exist
Field payment_gateway_ref already exist
Field user_access already exist
Field encrypted_card already exist
Field encrypted_card already exist
Field date_modified already exist
Creating table stripe_logger
(Done)
Field payment_customer_id already exist
Field social_id already exist
Field verify_code_requested already exist
Field single_app_merchant_id already exist
Field payment_customer_type already exist
Field update_by_type already exist
Field update_by_id already exist
Field update_by_name already exist
Field page_name_trans already exist
Field content_trans already exist
Field seo_title_trans already exist
Field meta_description_trans already exist
Field meta_keywords_trans already exist
Field distance already exist
Field cancel_reason already exist
Field latitude already exist
Field longitude already exist
Field distance_unit already exist
Field delivery_distance_covered already exist
Field slug already exist
Field request_cancel already exist
Field as_anonymous already exist
Field first_name already exist
Field last_name already exist
Field contact_email already exist
Field dinein_number_of_guest already exist
Field dinein_special_instruction already exist
Field dinein_table_number already exist
Field opt_contact_delivery already exist
Field estimated_time already exist
Field estimated_date_time already exist
Field size_id already exist
Field cat_id already exist
Field single_app_keys already exist
Field pin already exist
Field close_store already exist
Field item_token already exist
Field with_size already exist
Field track_stock already exist
Field supplier_id already exist
Field description already exist
Field as_default already exist
Field is_hidden already exist
Field currency_position already exist
Field exchange_rate already exist
Field exchange_rate_fee already exist
Field number_decimal already exist
Field decimal_separator already exist
Field thousand_separator already exist
Field used_currency already exist
Field base_currency already exist
Field exchange_rate already exist
Updating view Table view_ratings..
(Done)
Updating view Table merchant..
(Done)
Creating Table view_order_details..
(Done)
Creating Table view_location_rate..
(Done)
Creating Table view_cuisine_merchant..
(Done)
Array
(
    [0] => Create table {{view_item}} done
    [1] => Create table {{view_item_cat}} done
    [2] => Create table {{view_rs_category}} done
    [3] => Create table {{view_order}} done
    [4] => Create table {{view_order_summary}} done
)

FINISH UPDATE(s)

Update done click here to go back