-- FASE 14 - configurações da loja
CREATE TABLE IF NOT EXISTS store_settings (
 id TINYINT UNSIGNED PRIMARY KEY,
 store_name VARCHAR(160) NOT NULL DEFAULT 'Cestão Valença',
 phone VARCHAR(30) NULL,
 whatsapp VARCHAR(30) NULL,
 address VARCHAR(255) NULL,
 minimum_order DECIMAL(10,2) NOT NULL DEFAULT 0,
 default_delivery_fee DECIMAL(10,2) NOT NULL DEFAULT 10.00,
 maintenance_mode TINYINT(1) NOT NULL DEFAULT 0,
 maintenance_message VARCHAR(255) NULL,
 allow_scheduling TINYINT(1) NOT NULL DEFAULT 1,
 updated_at DATETIME NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS store_hours (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 weekday TINYINT UNSIGNED NOT NULL,
 is_open TINYINT(1) NOT NULL DEFAULT 1,
 open_time TIME NULL,
 close_time TIME NULL,
 UNIQUE KEY uq_weekday(weekday)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO store_settings(id,store_name,minimum_order,default_delivery_fee,maintenance_mode,allow_scheduling)
SELECT 1,'Cestão Valença',0,10.00,0,1
WHERE NOT EXISTS (SELECT 1 FROM store_settings WHERE id=1);

INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 0,0,NULL,NULL WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=0);
INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 1,1,'08:00:00','18:00:00' WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=1);
INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 2,1,'08:00:00','18:00:00' WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=2);
INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 3,1,'08:00:00','18:00:00' WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=3);
INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 4,1,'08:00:00','18:00:00' WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=4);
INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 5,1,'08:00:00','18:00:00' WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=5);
INSERT INTO store_hours(weekday,is_open,open_time,close_time)
SELECT 6,1,'08:00:00','14:00:00' WHERE NOT EXISTS(SELECT 1 FROM store_hours WHERE weekday=6);