-- script_yugarantia.sql
-- Insere todos os planos YUGarantia Mensal + Pagamento Único

-- Exemplo Mensal
INSERT IGNORE INTO produtos (tipo, nome_plano, descricao, preco_mensal, preco_anual, pais_disponivel, ativo)
VALUES
('YUGARANTIA','Mensal - 0-50€ (Extra)','Garantia Extra Mensal (0-50€)',0.30,0.00,'ES',1),
('YUGARANTIA','Mensal - 0-50€ (Danos)','Cobertura Danos Mensal (0-50€)',0.70,0.00,'ES',1),
('YUGARANTIA','Mensal - 51-100€ (Extra)','Garantia Extra Mensal (51-100€)',0.50,0.00,'ES',1),
('YUGARANTIA','Mensal - 51-100€ (Danos)','Cobertura Danos Mensal (51-100€)',1.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 101-150€ (Extra)','Garantia Extra Mensal (101-150€)',0.80,0.00,'ES',1),
('YUGARANTIA','Mensal - 101-150€ (Danos)','Cobertura Danos Mensal (101-150€)',1.50,0.00,'ES',1),
('YUGARANTIA','Mensal - 151-200€ (Extra)','Garantia Extra Mensal (151-200€)',1.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 151-200€ (Danos)','Cobertura Danos Mensal (151-200€)',2.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 201-300€ (Extra)','Garantia Extra Mensal (201-300€)',1.50,0.00,'ES',1),
('YUGARANTIA','Mensal - 201-300€ (Danos)','Cobertura Danos Mensal (201-300€)',2.50,0.00,'ES',1),
('YUGARANTIA','Mensal - 301-500€ (Extra)','Garantia Extra Mensal (301-500€)',2.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 301-500€ (Danos)','Cobertura Danos Mensal (301-500€)',3.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 501-700€ (Extra)','Garantia Extra Mensal (501-700€)',3.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 501-700€ (Danos)','Cobertura Danos Mensal (501-700€)',4.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 701-1000€ (Extra)','Garantia Extra Mensal (701-1000€)',4.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 701-1000€ (Danos)','Cobertura Danos Mensal (701-1000€)',5.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 1001-1500€ (Extra)','Garantia Extra Mensal (1001-1500€)',5.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 1001-1500€ (Danos)','Cobertura Danos Mensal (1001-1500€)',7.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 1501-2000€ (Extra)','Garantia Extra Mensal (1501-2000€)',6.00,0.00,'ES',1),
('YUGARANTIA','Mensal - 1501-2000€ (Danos)','Cobertura Danos Mensal (1501-2000€)',9.00,0.00,'ES',1);

-- Exemplo PU
INSERT IGNORE INTO produtos (tipo, nome_plano, descricao, preco_mensal, preco_anual, pais_disponivel, ativo)
VALUES
('YUGARANTIA','PU 0-50€ (1 ano Extra)','Garantia Extra 1 ano (0-50€)',5.00,0.00,'ES',1),
('YUGARANTIA','PU 0-50€ (2 anos Extra)','Garantia Extra 2 anos (0-50€)',6.00,0.00,'ES',1),
('YUGARANTIA','PU 0-50€ (3 anos Extra)','Garantia Extra 3 anos (0-50€)',8.00,0.00,'ES',1),
('YUGARANTIA','PU 0-50€ (Danos 1º ano)','Proteção Danos 1 ano (0-50€)',20.00,0.00,'ES',1),

('YUGARANTIA','PU 51-100€ (1 ano Extra)','Garantia Extra 1 ano (51-100€)',8.00,0.00,'ES',1),
('YUGARANTIA','PU 51-100€ (2 anos Extra)','Garantia Extra 2 anos (51-100€)',10.00,0.00,'ES',1),
('YUGARANTIA','PU 51-100€ (3 anos Extra)','Garantia Extra 3 anos (51-100€)',15.00,0.00,'ES',1),
('YUGARANTIA','PU 51-100€ (Danos 1º ano)','Proteção Danos 1 ano (51-100€)',30.00,0.00,'ES',1);

-- etc. Repita para 101-150€, 151-200€, etc.

