ALTER TABLE dining_tables ADD COLUMN zone TEXT NOT NULL DEFAULT 'Sala';
--> statement-breakpoint
UPDATE dining_tables
SET zone = CASE
  WHEN instr(label, '·') > 0 THEN trim(substr(label, instr(label, '·') + 1))
  ELSE 'Sala'
END;
--> statement-breakpoint
CREATE INDEX IF NOT EXISTS idx_dining_tables_restaurant_zone
ON dining_tables (restaurant_id, zone, table_number);
--> statement-breakpoint
PRAGMA optimize;