-- Sample data for REMS Lots
-- Inserting 10 sample lots for project ID 1

-- Insert block A lots (A1-A3)
INSERT INTO `mod_rems_lots` (
    `mod_rems_lots_block`,
    `mod_rems_lots_number`,
    `mod_rems_lots_name`,
    `mod_rems_lots_area_m2`,
    `mod_rems_lots_available`,
    `mod_rems_lots_status`,
    `mod_rems_lots_details`,
    `mod_rems_lots_project_id`,
    `mod_rems_lots_coordinates`,
    `mod_rems_lots_state`
) VALUES
('MZA-05', 1, 'Lote 1', 647.27, 1, 'disponible', 'Detalles del lote 1', 1, 'POLYGON((...))', 1),
('MZA-05', 2, 'Lote 2', 360.51, 1, 'disponible', 'Detalles del lote 2', 1, 'POLYGON((...))', 1),
('MZA-05', 3, 'Lote 3', 363.49, 1, 'disponible', 'Detalles del lote 3', 1, 'POLYGON((...))', 1),
('MZA-05', 4, 'Lote 4', 361.54, 1, 'disponible', 'Detalles del lote 4', 1, 'POLYGON((...))', 1),
('MZA-05', 5, 'Lote 5', 360.79, 1, 'disponible', 'Detalles del lote 5', 1, 'POLYGON((...))', 1),
('MZA-05', 6, 'Lote 6', 362.11, 1, 'disponible', 'Detalles del lote 6', 1, 'POLYGON((...))', 1),
('MZA-05', 7, 'Lote 7', 403.23, 1, 'disponible', 'Detalles del lote 7', 1, 'POLYGON((...))', 1),
('MZA-05', 8, 'Lote 8', 544.66, 1, 'disponible', 'Detalles del lote 8', 1, 'POLYGON((...))', 1),
('MZA-05', 9, 'Lote 9', 379.76, 1, 'disponible', 'Detalles del lote 9', 1, 'POLYGON((...))', 1),
('MZA-05', 10, 'Lote 10', 368.21, 1, 'disponible', 'Detalles del lote 10', 1, 'POLYGON((...))', 1),
('MZA-05', 11, 'Lote 11', 367.28, 1, 'disponible', 'Detalles del lote 11', 1, 'POLYGON((...))', 1),
('MZA-05', 12, 'Lote 12', 362.17, 1, 'disponible', 'Detalles del lote 12', 1, 'POLYGON((...))', 1),
('MZA-05', 13, 'Lote 13', 362.08, 1, 'disponible', 'Detalles del lote 13', 1, 'POLYGON((...))', 1),
('MZA-05', 14, 'Lote 14', 360.57, 1, 'disponible', 'Detalles del lote 14', 1, 'POLYGON((...))', 1),
('MZA-05', 15, 'Lote 15', 360.94, 1, 'disponible', 'Detalles del lote 15', 1, 'POLYGON((...))', 1),
('MZA-05', 16, 'Lote 16', 545.04, 1, 'disponible', 'Detalles del lote 16', 1, 'POLYGON((...))', 1);


-- Note: The coordinates are simplified examples. In a real scenario, you would use actual coordinates for each lot.
-- The `created_at` and `updated_at` fields will be automatically set by the database.
-- All lots are set as available (1) and active (1) by default.