SliceHub — Database Setup

Migration 006 — Studio Mission Control

ALTER TABLE sh_categories ADD COLUMN default_vat_dine_in DECIMAL(5,2) NOT NULL D...

SKIP (already exists)

ALTER TABLE sh_categories ADD COLUMN default_vat_takeaway DECIMAL(5,2) NOT NULL ...

SKIP (already exists)

ALTER TABLE sh_categories ADD COLUMN default_vat_delivery DECIMAL(5,2) NOT NULL ...

SKIP (already exists)

ALTER TABLE sh_menu_items ADD COLUMN printer_group VARCHAR(64) NULL DEFAULT NULL...

SKIP (already exists)

ALTER TABLE sh_menu_items ADD COLUMN plu_code VARCHAR(32) NULL DEFAULT NULL...

SKIP (already exists)

ALTER TABLE sh_menu_items ADD COLUMN available_days VARCHAR(32) NULL DEFAULT '1,...

SKIP (already exists)

ALTER TABLE sh_menu_items ADD COLUMN available_start TIME NULL DEFAULT NULL...

SKIP (already exists)

ALTER TABLE sh_menu_items ADD COLUMN available_end TIME NULL DEFAULT NULL...

SKIP (already exists)

Migration 007 — POS Engine Columns

ALTER TABLE sh_orders ADD COLUMN receipt_printed TINYINT(1) NOT NULL DEFAULT 0...

SKIP (already exists)

ALTER TABLE sh_orders ADD COLUMN kitchen_ticket_printed TINYINT(1) NOT NULL DEFA...

SKIP (already exists)

ALTER TABLE sh_orders ADD COLUMN kitchen_changes TEXT NULL...

SKIP (already exists)

ALTER TABLE sh_orders ADD COLUMN cart_json JSON NULL...

SKIP (already exists)

ALTER TABLE sh_orders ADD COLUMN nip VARCHAR(32) NULL...

SKIP (already exists)

Migration 008 — Driver Locations

sh_driver_locations

SKIP (already exists)

Migration 012 — Visual Layers

sh_visual_layers

SKIP (already exists)

Migration 013 — Board Companions

sh_board_companions

SKIP (already exists)

Migration 014 — Global Assets

sh_global_assets

SKIP (already exists)

Migration 014b — Ingredient Assets

sh_ingredient_assets

SKIP (already exists)

Migration 016 — Visual Compositor Upgrade

sh_visual_layers.product_filename

SKIP (exists)

sh_visual_layers.cal_scale

SKIP (exists)

sh_visual_layers.cal_rotate

SKIP (exists)

sh_board_companions.product_filename

SKIP (exists)

storefront_surface_bg setting

SKIP (exists)

Migration 017 — Online Module Extensions

sh_visual_layers.version

SKIP (exists)

sh_visual_layers.library_category

SKIP (exists)

sh_visual_layers.library_sub_type

SKIP (exists)

sh_orders.tracking_token

SKIP (exists)

sh_visual_layers.idx_vl_library

SKIP (index exists)

sh_orders.idx_orders_tracking

SKIP (index exists)

sh_checkout_locks

SKIP (already exists)

setting: online_min_order_value

OK

setting: online_default_eta_min

OK

setting: online_guest_checkout

OK

setting: online_apple_pay_enabled

OK

setting: online_promotion_banner

OK

Migration 018 — Magic Dictionary (modifier ↔ visual asset)

sh_modifier_visual_map

SKIP (already exists)

Verify — Schema

006 — VAT on categories

Column EXISTS

006 — printer_group

Column EXISTS

006 — available_days

Column EXISTS

007 — cart_json

Column EXISTS

007 — nip

Column EXISTS

016 — VL product_filename

Column EXISTS

016 — VL cal_scale

Column EXISTS

016 — VL cal_rotate

Column EXISTS

016 — BC product_filename

Column EXISTS

017 — VL version (optimistic lock)

Column EXISTS

017 — VL library_category

Column EXISTS

017 — VL library_sub_type

Column EXISTS

017 — orders tracking_token

Column EXISTS

008 — sh_driver_locations

Table EXISTS

012 — sh_visual_layers

Table EXISTS

013 — sh_board_companions

Table EXISTS

014 — sh_global_assets

Table EXISTS

014b — sh_ingredient_assets

Table EXISTS

017 — sh_checkout_locks

Table EXISTS