-- Crear tabla de sucursales delivery personalizables
CREATE TABLE IF NOT EXISTS delivery_branches (
  id VARCHAR(50) PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  zone VARCHAR(100) NOT NULL,
  address VARCHAR(255) NOT NULL,
  phone VARCHAR(50) NULL,
  whatsapp VARCHAR(50) NULL,
  order_url VARCHAR(255) NULL,
  rappi_url VARCHAR(255) NULL,
  schedule VARCHAR(150) NOT NULL DEFAULT 'Lunes a Domingo • 1:00 PM a 1:00 AM',
  is_coming_soon TINYINT(1) NOT NULL DEFAULT 0,
  is_active TINYINT(1) NOT NULL DEFAULT 1,
  sort_order INT NOT NULL DEFAULT 1,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO delivery_branches (id, name, zone, address, phone, whatsapp, order_url, rappi_url, schedule, is_coming_soon, is_active, sort_order)
VALUES 
  ('montejo', 'Lapa Montejo', 'Fracc. Gonzalo Guerrero', 'Calle 50 Diag #476, Fracc. Gonzalo Guerrero C.P. 97118', '(999) 400 7979', '529993701305', 'https://lapalaparest.com/sucursal/montejo', 'https://www.rappi.com.mx/restaurantes/lapa', 'Lun - Mié: 13:00 a 00:00 | Jue - Sáb: 13:00 a 02:00 | Dom: 12:00 a 00:00', 0, 1, 1),
  ('altabrisa', 'Lapa Altabrisa', 'Colonia Maya / Altabrisa', 'Calle 18 #499 x 7 y 9, Colonia Maya C.P. 97134', '(999) 213 0004', '529993701312', 'https://lapalaparest.com/sucursal/altabrisa', 'https://www.rappi.com.mx/restaurantes/lapa', 'Lun - Mié: 13:00 a 00:00 | Jue - Sáb: 13:00 a 02:00 | Dom: 12:00 a 00:00', 0, 1, 2),
  ('dorada', 'Lapa Dorada', 'Zona Dorada II', 'Calle 21 #204 x 52 y 60, Col. Zona Dorada II', '(999) 945 0555', '529991347691', 'https://lapalaparest.com/sucursal/dorada', 'https://www.rappi.com.mx/restaurantes/lapa', 'Lun - Mié: 13:00 a 00:00 | Jue - Sáb: 13:00 a 02:00 | Dom: 12:00 a 00:00', 0, 1, 3),
  ('kukulcan', 'Lapa Kukulcán', 'Ampliación Salvador Alvarado Sur', 'Calle 99 #300, Ampliación Salvador Alvarado Sur C.P. 97195', '(999) 983 0033', '529992713485', NULL, NULL, 'Próxima apertura oficial', 1, 1, 4)
ON DUPLICATE KEY UPDATE 
  name = VALUES(name),
  zone = VALUES(zone),
  address = VALUES(address),
  phone = VALUES(phone),
  whatsapp = VALUES(whatsapp),
  order_url = VALUES(order_url),
  rappi_url = VALUES(rappi_url),
  schedule = VALUES(schedule),
  is_coming_soon = VALUES(is_coming_soon),
  is_active = VALUES(is_active),
  sort_order = VALUES(sort_order);