USE rma_db;

-- Clear existing data
TRUNCATE TABLE project_images;
TRUNCATE TABLE projects;

-- Project 1: Modern Villa
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(1, 'Modern Villa', 'Residential', 'Private Client', '2024', 'Dhaka, Bangladesh', 'A luxurious modern villa designed for comfort and style, blending indoor and outdoor living spaces seamlessly.', 'https://picsum.photos/id/10/1200/800', 'The main challenge was to maximize the living space within a relatively small and irregularly shaped plot while maintaining privacy from neighboring buildings.', 'We adopted a vertical design approach with cantilevered spaces to create shade and depth. Large glass windows were strategically placed to allow natural light while using louvers for privacy.', 'A stunning contemporary residence that feels spacious and airy, providing a tranquil retreat in the heart of the bustling city.');
INSERT INTO project_images (project_id, image_url) VALUES (1, 'https://picsum.photos/id/11/800/600'), (1, 'https://picsum.photos/id/12/800/600'), (1, 'https://picsum.photos/id/13/800/600');

-- Project 2: Tech Office HQ
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(2, 'Tech Office HQ', 'Commercial', 'Innovate Corp', '2023', 'Sylhet, Bangladesh', 'An open-plan office space designed to foster collaboration and creativity among a dynamic team of developers and designers.', 'https://picsum.photos/id/20/1200/800', 'Creating a workspace that balances open collaboration areas with quiet zones for focused work, all within a limited budget.', 'We utilized modular furniture and acoustic partitions to define zones without building permanent walls. Biophilic design elements were introduced to enhance well-being.', 'A vibrant and flexible office environment that has significantly boosted employee morale and productivity.');
INSERT INTO project_images (project_id, image_url) VALUES (2, 'https://picsum.photos/id/21/800/600'), (2, 'https://picsum.photos/id/22/800/600'), (2, 'https://picsum.photos/id/23/800/600');

-- Project 3: Urban Green Park
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(3, 'Urban Green Park', 'Landscape', 'City Corporation', '2022', 'Chittagong, Bangladesh', 'A revitalization project transforming a neglected urban lot into a thriving green park for the community.', 'https://picsum.photos/id/30/1200/800', 'The site was previously a dumping ground with poor soil quality and lack of drainage.', 'Extensive soil remediation was performed, and native plant species were selected for their resilience. A rainwater harvesting system was integrated into the landscape design.', 'A lush, green oasis that serves as a recreational hub for local residents and has improved the local microclimate.');
INSERT INTO project_images (project_id, image_url) VALUES (3, 'https://picsum.photos/id/31/800/600'), (3, 'https://picsum.photos/id/32/800/600'), (3, 'https://picsum.photos/id/33/800/600');

-- Project 4: Riverside Resort
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(4, 'Riverside Resort', 'Hospitality', 'River View Hotels', '2023', 'Barisal, Bangladesh', 'An eco-friendly resort located on the banks of a serene river, offering guests a connection with nature.', 'https://picsum.photos/id/40/1200/800', 'Designing a resort that minimizes environmental impact and withstands seasonal flooding.', 'The structures were built on stilts to accommodate rising water levels. Local, sustainable materials like bamboo and recycled timber were used for construction.', 'A sustainable and picturesque resort that attracts eco-tourists and supports the local economy.');
INSERT INTO project_images (project_id, image_url) VALUES (4, 'https://picsum.photos/id/41/800/600'), (4, 'https://picsum.photos/id/42/800/600'), (4, 'https://picsum.photos/id/43/800/600');

-- Project 5: Minimalist Apartment
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(5, 'Minimalist Apartment', 'Interior', 'Private Client', '2024', 'Dhaka, Bangladesh', 'A sleek and minimalist apartment renovation focusing on clean lines and functional spaces.', 'https://picsum.photos/id/50/1200/800', 'The original layout was cramped and dark, with unnecessary partition walls.', 'We removed non-structural walls to create an open floor plan. A neutral color palette and built-in storage solutions were used to enhance the sense of space.', 'A bright and spacious apartment that feels much larger than its actual footprint.');
INSERT INTO project_images (project_id, image_url) VALUES (5, 'https://picsum.photos/id/51/800/600'), (5, 'https://picsum.photos/id/52/800/600'), (5, 'https://picsum.photos/id/53/800/600');

-- Project 6: Corporate Tower
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(6, 'Corporate Tower', 'Commercial', 'Global Group', '2021', 'Dhaka, Bangladesh', 'A landmark high-rise building designed to house the headquarters of a multinational corporation.', 'https://picsum.photos/id/60/1200/800', 'Designing a skyscraper that is energy-efficient and structurally resilient in a dense urban context.', 'We implemented a double-skin facade to reduce heat gain and used high-strength concrete for the structural core. The building also features a rooftop garden.', 'An iconic addition to the city skyline that sets a new standard for sustainable high-rise construction.');
INSERT INTO project_images (project_id, image_url) VALUES (6, 'https://picsum.photos/id/61/800/600'), (6, 'https://picsum.photos/id/62/800/600'), (6, 'https://picsum.photos/id/63/800/600');

-- Project 7: Community Center
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(7, 'Community Center', 'Public', 'Local Government', '2022', 'Khulna, Bangladesh', 'A vibrant community hub providing space for social gatherings, workshops, and cultural events.', 'https://picsum.photos/id/70/1200/800', 'Creating a welcoming and inclusive space that caters to diverse age groups and activities.', 'The design features flexible multi-purpose halls, a library, and outdoor recreational areas. The architecture reflects local cultural motifs.', 'A beloved community asset that fosters social interaction and cultural exchange.');
INSERT INTO project_images (project_id, image_url) VALUES (7, 'https://picsum.photos/id/71/800/600'), (7, 'https://picsum.photos/id/72/800/600'), (7, 'https://picsum.photos/id/73/800/600');

-- Project 8: Lakeside Villa
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(8, 'Lakeside Villa', 'Residential', 'Private Client', '2023', 'Gazipur, Bangladesh', 'A tranquil weekend home overlooking a natural lake, designed for relaxation and connection with nature.', 'https://picsum.photos/id/80/1200/800', 'Ensuring the building design respects the natural topography and minimizes disruption to the lakeside ecosystem.', 'The villa was designed with large terraces and floor-to-ceiling windows to maximize views. Natural stone and wood were used to blend with the surroundings.', 'A peaceful retreat that offers a perfect escape from city life, harmonizing with its natural setting.');
INSERT INTO project_images (project_id, image_url) VALUES (8, 'https://picsum.photos/id/81/800/600'), (8, 'https://picsum.photos/id/82/800/600'), (8, 'https://picsum.photos/id/83/800/600');

-- Project 9: Boutique Hotel
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(9, 'Boutique Hotel', 'Hospitality', 'Heritage Stays', '2024', 'Sylhet, Bangladesh', 'A charming boutique hotel that blends traditional architecture with modern amenities.', 'https://picsum.photos/id/90/1200/800', 'Renovating an existing heritage building while preserving its historical character and meeting modern hospitality standards.', 'We carefully restored the original facade and structural elements. The interiors were updated with contemporary comforts while retaining vintage charm.', 'A unique hospitality experience that celebrates local history and culture, attracting discerning travelers.');
INSERT INTO project_images (project_id, image_url) VALUES (9, 'https://picsum.photos/id/91/800/600'), (9, 'https://picsum.photos/id/92/800/600'), (9, 'https://picsum.photos/id/93/800/600');

-- Project 10: Industrial Loft
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(10, 'Industrial Loft', 'Interior', 'Creative Agency', '2022', 'Dhaka, Bangladesh', 'A raw and edgy office space converted from an old warehouse.', 'https://picsum.photos/id/100/1200/800', 'Transforming a dark, industrial space into a bright and inspiring creative studio.', 'We exposed the original brick walls and concrete beams. Skylights were added to bring in natural light, and an open layout was adopted to encourage collaboration.', 'A stimulating work environment that reflects the agency\'s creative identity.');
INSERT INTO project_images (project_id, image_url) VALUES (10, 'https://picsum.photos/id/101/800/600'), (10, 'https://picsum.photos/id/102/800/600'), (10, 'https://picsum.photos/id/103/800/600');

-- Project 11: University Campus
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(11, 'University Campus', 'Education', 'National University', '2023', 'Rajshahi, Bangladesh', 'A modern university campus designed to facilitate learning and research.', 'https://picsum.photos/id/110/1200/800', 'Designing a campus that promotes interaction between different faculties and provides ample green spaces.', 'The master plan features a central pedestrian spine connecting various academic buildings. Courtyards and plazas are integrated to encourage social interaction.', 'A vibrant academic community with state-of-the-art facilities that supports holistic education.');
INSERT INTO project_images (project_id, image_url) VALUES (11, 'https://picsum.photos/id/111/800/600'), (11, 'https://picsum.photos/id/112/800/600'), (11, 'https://picsum.photos/id/113/800/600');

-- Project 12: Rooftop Garden
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(12, 'Rooftop Garden', 'Landscape', 'Private Client', '2024', 'Dhaka, Bangladesh', 'An urban oasis created on the rooftop of a residential building.', 'https://picsum.photos/id/120/1200/800', 'Creating a lush garden on a rooftop with load constraints and exposure to strong winds and sun.', 'We used lightweight soil and planters. Windbreakers and pergolas were installed to provide protection and shade. Drought-tolerant plants were selected.', 'A beautiful and functional rooftop retreat that provides a breath of fresh air in the city.');
INSERT INTO project_images (project_id, image_url) VALUES (12, 'https://picsum.photos/id/121/800/600'), (12, 'https://picsum.photos/id/122/800/600'), (12, 'https://picsum.photos/id/123/800/600');

-- Project 13: Art Gallery
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(13, 'Modern Art Gallery', 'Public', 'Art Foundation', '2022', 'Dhaka, Bangladesh', 'A contemporary art gallery designed to showcase local and international artists.', 'https://picsum.photos/id/130/1200/800', 'Designing a space that is flexible enough to accommodate various types of art installations while maintaining optimal lighting conditions.', 'We used movable partition walls and a sophisticated lighting system that can be adjusted for different exhibitions. The architecture itself is minimalist to let the art take center stage.', 'A dynamic cultural venue that has become a hub for the local art scene.');
INSERT INTO project_images (project_id, image_url) VALUES (13, 'https://picsum.photos/id/131/800/600'), (13, 'https://picsum.photos/id/132/800/600'), (13, 'https://picsum.photos/id/133/800/600');

-- Project 14: Eco Resort
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(14, 'Eco Jungle Resort', 'Hospitality', 'Green Travels', '2023', 'Bandarban, Bangladesh', 'An immersive eco-resort nestled deep in the hill tracts, offering a raw nature experience.', 'https://picsum.photos/id/140/1200/800', 'Building in a remote and sensitive ecological zone without disrupting the local flora and fauna.', 'The resort was constructed using traditional methods and locally sourced materials. Solar power and rainwater harvesting make it self-sufficient.', 'A sustainable tourism destination that offers a unique connection with nature while preserving the environment.');
INSERT INTO project_images (project_id, image_url) VALUES (14, 'https://picsum.photos/id/141/800/600'), (14, 'https://picsum.photos/id/142/800/600'), (14, 'https://picsum.photos/id/143/800/600');

-- Project 15: Shopping Complex
INSERT INTO projects (id, title, category, client, year, location, description, main_image, challenge, solution, result) VALUES
(15, 'City Mall', 'Commercial', 'Retail Giants', '2021', 'Chittagong, Bangladesh', 'A modern shopping complex offering a mix of retail, dining, and entertainment options.', 'https://picsum.photos/id/152/1200/800', 'Designing a large-scale commercial complex that is easy to navigate and provides a comfortable shopping experience.', 'We designed a clear circulation path with a central atrium for orientation. Natural light and indoor landscaping create a pleasant atmosphere.', 'A popular shopping destination that offers a diverse range of experiences for visitors.');
INSERT INTO project_images (project_id, image_url) VALUES (15, 'https://picsum.photos/id/153/800/600'), (15, 'https://picsum.photos/id/154/800/600'), (15, 'https://picsum.photos/id/155/800/600');
