-- =========================
-- SEED: LA LIBERTAD (13)
-- =========================

INSERT INTO regiones (id, nombre) VALUES (13, 'La Libertad');

-- =========================
-- PROVINCIAS (12)
-- =========================
INSERT INTO provincias (id, region_id, nombre, ubigeo) VALUES
(1301, 13, 'Trujillo', '1301'),
(1302, 13, 'Ascope', '1302'),
(1303, 13, 'Bolívar', '1303'),
(1304, 13, 'Chepén', '1304'),
(1305, 13, 'Julcán', '1305'),
(1306, 13, 'Otuzco', '1306'),
(1307, 13, 'Pacasmayo', '1307'),
(1308, 13, 'Pataz', '1308'),
(1309, 13, 'Sánchez Carrión', '1309'),
(1310, 13, 'Santiago de Chuco', '1310'),
(1311, 13, 'Gran Chimú', '1311'),
(1312, 13, 'Virú', '1312');

-- =========================
-- DISTRITOS (83)
-- =========================

-- TRUJILLO (11 + Trujillo = 12)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1301, 'Trujillo', '130101'),
(1301, 'El Porvenir', '130102'),
(1301, 'Florencia de Mora', '130103'),
(1301, 'Huanchaco', '130104'),
(1301, 'La Esperanza', '130105'),
(1301, 'Laredo', '130106'),
(1301, 'Moche', '130107'),
(1301, 'Poroto', '130108'),
(1301, 'Salaverry', '130109'),
(1301, 'Simbal', '130110'),
(1301, 'Victor Larco Herrera', '130111');

-- ASCOPE (8)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1302, 'Ascope', '130201'),
(1302, 'Chicama', '130202'),
(1302, 'Chocope', '130203'),
(1302, 'Magdalena de Cao', '130204'),
(1302, 'Paiján', '130205'),
(1302, 'Rázuri', '130206'),
(1302, 'Santiago de Cao', '130207'),
(1302, 'Casa Grande', '130208');

-- BOLÍVAR (6)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1303, 'Bolívar', '130301'),
(1303, 'Bambamarca', '130302'),
(1303, 'Condormarca', '130303'),
(1303, 'Longotea', '130304'),
(1303, 'Uchumarca', '130305'),
(1303, 'Ucuncha', '130306');

-- CHEPÉN (3)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1304, 'Chepén', '130401'),
(1304, 'Pacanga', '130402'),
(1304, 'Pueblo Nuevo', '130403');

-- JULCÁN (4)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1305, 'Julcán', '130501'),
(1305, 'Calamarca', '130502'),
(1305, 'Carabamba', '130503'),
(1305, 'Huaso', '130504');

-- OTUZCO (10)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1306, 'Otuzco', '130601'),
(1306, 'Agallpampa', '130602'),
(1306, 'Charat', '130603'),
(1306, 'Huaranchal', '130604'),
(1306, 'La Cuesta', '130605'),
(1306, 'Mache', '130606'),
(1306, 'Paranday', '130607'),
(1306, 'Salpo', '130608'),
(1306, 'Sinsicap', '130609'),
(1306, 'Usquil', '130610');

-- PACASMAYO (5)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1307, 'San Pedro de Lloc', '130701'),
(1307, 'Guadalupe', '130702'),
(1307, 'Jequetepeque', '130703'),
(1307, 'Pacasmayo', '130704'),
(1307, 'San José', '130705');

-- PATAZ (13)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1308, 'Tayabamba', '130801'),
(1308, 'Buldibuyo', '130802'),
(1308, 'Chillia', '130803'),
(1308, 'Huancaspata', '130804'),
(1308, 'Huaylillas', '130805'),
(1308, 'Huayo', '130806'),
(1308, 'Ongón', '130807'),
(1308, 'Parcoy', '130808'),
(1308, 'Pataz', '130809'),
(1308, 'Pías', '130810'),
(1308, 'Santiago de Challas', '130811'),
(1308, 'Taurija', '130812'),
(1308, 'Urpay', '130813');

-- SÁNCHEZ CARRIÓN (8)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1309, 'Huamachuco', '130901'),
(1309, 'Chugay', '130902'),
(1309, 'Cochorco', '130903'),
(1309, 'Curgos', '130904'),
(1309, 'Marcabal', '130905'),
(1309, 'Sanagorán', '130906'),
(1309, 'Sarin', '130907'),
(1309, 'Sartimbamba', '130908');

-- SANTIAGO DE CHUCO (8)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1310, 'Santiago de Chuco', '131001'),
(1310, 'Angasmarca', '131002'),
(1310, 'Cachicadán', '131003'),
(1310, 'Mollebamba', '131004'),
(1310, 'Mollepata', '131005'),
(1310, 'Quiruvilca', '131006'),
(1310, 'Santa Cruz de Chuca', '131007'),
(1310, 'Sitabamba', '131008');

-- GRAN CHIMÚ (7)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1311, 'Cascas', '131101'),
(1311, 'Lucma', '131102'),
(1311, 'Marmot', '131103'),
(1311, 'Sayapullo', '131104'),
(1311, 'Compín', '131105'),
(1311, 'Cochapeti', '131106'),
(1311, 'Jango', '131107');

-- VIRÚ (3)
INSERT INTO distritos (provincia_id, nombre, ubigeo) VALUES
(1312, 'Virú', '131201'),
(1312, 'Chao', '131202'),
(1312, 'Guadalupito', '131203');
