SWAMPy

✎ CARVE FLESH

EDITING: 002_media_seed.sql

-- JILMEK media and project seed; safe to run after schema.sql and 001_foundation.sql.
SET NAMES utf8mb4;

INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/logo_22da56e1.png','/media/logo_22da56e1.png','logo_22da56e1.png','image/png',181277,760,336,'6381bcb04c0e594b16dd31fd997a2553ef59edfde979660b82426c6860f8cafa','JILMEK Roofing & Construction Ltd logo','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/hero-red-roof_78e57ca6.jpeg','/media/hero-red-roof_78e57ca6.jpeg','hero-red-roof_78e57ca6.jpeg','image/jpeg',103645,1080,608,'cc44cf5fb2569fd2742b9a840dd7eddd04749c066fc1be7feaa9f5b59378ee1a','JILMEK roofing and construction project with red roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/home-pink-roof_178510ed.jpeg','/media/home-pink-roof_178510ed.jpeg','home-pink-roof_178510ed.jpeg','image/jpeg',153359,1000,750,'9f997308864cfe0abf673b6ab06c5915a41b68d9c3cbc8dd9a6f237d08f90596','Residential home with pink roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/home-blue-roof_36d157bc.jpeg','/media/home-blue-roof_36d157bc.jpeg','home-blue-roof_36d157bc.jpeg','image/jpeg',101673,1000,562,'1b393eb4071aa5fa7e1169d2b7ef52676a3d67debdab153cf288dfcb47931dea','Residential home with blue roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/colonnade_cc91d531.jpeg','/media/colonnade_cc91d531.jpeg','colonnade_cc91d531.jpeg','image/jpeg',102826,1000,562,'a2be847ac35df1dbc25420a4246fbe7d4e94940832df0d000fe4c7a15bd460da','Residential building with colonnade frontage','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/construction-frame_e0f41e5a.jpeg','/media/construction-frame_e0f41e5a.jpeg','construction-frame_e0f41e5a.jpeg','image/jpeg',148250,1000,750,'cd387ad510e30c9c80bde7f971323f5dbbf78b49f11129d8e23c8c8bb899a968','Construction frame and timber roof structure','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/house-grey_2ed75e58.jpeg','/media/house-grey_2ed75e58.jpeg','house-grey_2ed75e58.jpeg','image/jpeg',121245,1000,750,'09b304beeb87aa82dd8e56339e12bbb7a232caf1aded925283d1e7175df2f29e','Completed home with grey roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/house-red_3d6d39f5.jpeg','/media/house-red_3d6d39f5.jpeg','house-red_3d6d39f5.jpeg','image/jpeg',143489,1000,750,'98341b38b21658b1c0d3ff3bfdc7c41c2aaf8fa8b07df237a79f7fc7d27cbf4e','Completed home with red roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/tall-house_60c0ab4a.jpeg','/media/tall-house_60c0ab4a.jpeg','tall-house_60c0ab4a.jpeg','image/jpeg',151642,1000,750,'bda9657374eb1e3d9f7e36c867a7bdd837592664f3630ed9eed47b37c3caec44','Tall residential building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/roof-frame_e50d38a3.jpeg','/media/roof-frame_e50d38a3.jpeg','roof-frame_e50d38a3.jpeg','image/jpeg',99341,984,432,'e25e633e0cdbb2b644dffa4f0309b1ef310d817dc0675fb5c149bf4fb1281af4','Timber roof frame under construction','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/brick-home_3a6fc288.jpeg','/media/brick-home_3a6fc288.jpeg','brick-home_3a6fc288.jpeg','image/jpeg',116654,1000,562,'57a10fc27b604ec6af41f073fc569f5dffd3d1886fb8123f3f3efc9153cc884a','Brick residential home','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-colonnade-residence.jpeg','/media/projects/red-roof-colonnade-residence.jpeg','red-roof-colonnade-residence.jpeg','image/jpeg',124397,1080,810,'19fd4ec2bfaaa257e2e6c697a9b397d7a9ad26d1d3bf9c24ae8e47188004bc06','Ornate red roof with arched colonnade frontage on a residential build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-colonnade-residence-thumb.jpeg','/media/projects/red-roof-colonnade-residence-thumb.jpeg','red-roof-colonnade-residence-thumb.jpeg','image/jpeg',54969,560,420,'97b176f8ffd52d9aa7066a4f50386eb91c4011d1bbdbb9dbc89518fa286c2a41','Ornate red roof with arched colonnade frontage on a residential build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/maroon-roof-veranda-build.jpeg','/media/projects/maroon-roof-veranda-build.jpeg','maroon-roof-veranda-build.jpeg','image/jpeg',169451,1000,750,'b8a0ce245101b8722850603a595140ac4c0cf1c4c1d64e205dc389ba2eec7ed7','Maroon roofing sheets over a block-built residence with open veranda','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/maroon-roof-veranda-build-thumb.jpeg','/media/projects/maroon-roof-veranda-build-thumb.jpeg','maroon-roof-veranda-build-thumb.jpeg','image/jpeg',54373,560,420,'1ae30b08dfbe3bd338370e323a5c237e9d22cee1e04a301ac122ee049dc26784','Maroon roofing sheets over a block-built residence with open veranda','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/long-span-brown-roofline.jpeg','/media/projects/long-span-brown-roofline.jpeg','long-span-brown-roofline.jpeg','image/jpeg',115685,1080,810,'e2a9454d1bc7a1d45eee14d250d83ab7c2c24b303c51321536834d5d642710bd','Long brown roofline running the length of a completed building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/long-span-brown-roofline-thumb.jpeg','/media/projects/long-span-brown-roofline-thumb.jpeg','long-span-brown-roofline-thumb.jpeg','image/jpeg',47462,560,420,'5c067375dc1f195da94cf3eaeaf65dbc28021dac1246f800b48bb99f683a1d05','Long brown roofline running the length of a completed building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-red-roof-shell.jpeg','/media/projects/two-storey-red-roof-shell.jpeg','two-storey-red-roof-shell.jpeg','image/jpeg',100863,1000,750,'b4d02d5eddbbbd2bd85656080568bc75de812a2e991beb7c912b5605f804018b','Two-storey block structure topped with a new red roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-red-roof-shell-thumb.jpeg','/media/projects/two-storey-red-roof-shell-thumb.jpeg','two-storey-red-roof-shell-thumb.jpeg','image/jpeg',44192,560,420,'9d21abc28a0f82dfc94c922ca3382811a3fff54a8978cf214e19c4fe10e09a27','Two-storey block structure topped with a new red roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/timber-truss-single-storey.jpeg','/media/projects/timber-truss-single-storey.jpeg','timber-truss-single-storey.jpeg','image/jpeg',66842,984,432,'609a0e6c604540dd06c5e99e94fa4b56b50e7f837371e3bf1680fcf756cf9507','Timber roof trusses set out across a single-storey block shell','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/timber-truss-single-storey-thumb.jpeg','/media/projects/timber-truss-single-storey-thumb.jpeg','timber-truss-single-storey-thumb.jpeg','image/jpeg',28205,560,246,'06624629d92730b1af7f1e50d0594e9e68fb6c70b0f3140dce0dbe350e221313','Timber roof trusses set out across a single-storey block shell','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/blue-roof-rendered-home.jpeg','/media/projects/blue-roof-rendered-home.jpeg','blue-roof-rendered-home.jpeg','image/jpeg',83571,1080,810,'e80241043a6d3c2fbdacc5905278c174a0c3e345b8c8dd049fda2369f5d3fe53','Dark blue roofing sheets on a rendered family home','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/blue-roof-rendered-home-thumb.jpeg','/media/projects/blue-roof-rendered-home-thumb.jpeg','blue-roof-rendered-home-thumb.jpeg','image/jpeg',37783,560,420,'13142a126b8d30bc4f34148e1d205fd1bebb4c8c1a6cfdce4a462f6f2ec3be05','Dark blue roofing sheets on a rendered family home','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/completed-blue-hip-roof-home.jpeg','/media/projects/completed-blue-hip-roof-home.jpeg','completed-blue-hip-roof-home.jpeg','image/jpeg',97912,1080,608,'347453bc209fb5660ca731a192b6c2800f8097abcb266a8b7ac7e1b25bd2a294','Completed home with a blue hip roof and finished green walls','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/completed-blue-hip-roof-home-thumb.jpeg','/media/projects/completed-blue-hip-roof-home-thumb.jpeg','completed-blue-hip-roof-home-thumb.jpeg','image/jpeg',41031,560,315,'469c5ad3e9915857f6f9fccb66b2b69634d464595c1566986af4e56ba9d5e160','Completed home with a blue hip roof and finished green walls','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/grey-hip-roof-residence.jpeg','/media/projects/grey-hip-roof-residence.jpeg','grey-hip-roof-residence.jpeg','image/jpeg',144283,1000,750,'c9177ff5057ec8d4312d35d36985073a968fe51dc601834cecac6674496bbb43','Grey hip roof on a block residence seen across farmland','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/grey-hip-roof-residence-thumb.jpeg','/media/projects/grey-hip-roof-residence-thumb.jpeg','grey-hip-roof-residence-thumb.jpeg','image/jpeg',55592,560,420,'18262ba6638619d43ccdbe4be2c5b944071e43e353cac7cef304a11c3c0f2075','Grey hip roof on a block residence seen across farmland','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-hip-roof-colonnade.jpeg','/media/projects/red-hip-roof-colonnade.jpeg','red-hip-roof-colonnade.jpeg','image/jpeg',93243,1080,608,'d6f3a6bb5bbbe6e05026c1d4c81e4d7f2cdca901e36025b56c92ccf8074129a8','Red hip roof over a colonnade-fronted block residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-hip-roof-colonnade-thumb.jpeg','/media/projects/red-hip-roof-colonnade-thumb.jpeg','red-hip-roof-colonnade-thumb.jpeg','image/jpeg',41640,560,315,'514512fa514b0963f5eab7a54fe2dbb8814e0b9cb054a9ec6624b8516cfe352a','Red hip roof over a colonnade-fronted block residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-veranda-in-progress.jpeg','/media/projects/red-roof-veranda-in-progress.jpeg','red-roof-veranda-in-progress.jpeg','image/jpeg',85661,1080,810,'a11547088c54b98950f88f4f0f5dea025e16e0cc971461ba3cd94e3a60085a65','Red roofing sheets installed on a residence still under construction','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-veranda-in-progress-thumb.jpeg','/media/projects/red-roof-veranda-in-progress-thumb.jpeg','red-roof-veranda-in-progress-thumb.jpeg','image/jpeg',37417,560,420,'522589322389baa463db10f68e04e1427535e694ad08504a951f5bbc91aa79a0','Red roofing sheets installed on a residence still under construction','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/hillside-maroon-roof-home.jpeg','/media/projects/hillside-maroon-roof-home.jpeg','hillside-maroon-roof-home.jpeg','image/jpeg',141129,1000,750,'dbd5cd79bcfd97788d74498a295d354837d8e37899cfb21a322cb8a827cb9aaf','Maroon-roofed residence set on a cleared hillside plot','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/hillside-maroon-roof-home-thumb.jpeg','/media/projects/hillside-maroon-roof-home-thumb.jpeg','hillside-maroon-roof-home-thumb.jpeg','image/jpeg',55915,560,420,'8531cfc28dc6b5ed0c03583adfcb690bca591359607cbebdf2909a1eb9267599','Maroon-roofed residence set on a cleared hillside plot','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-open-pavilion.jpeg','/media/projects/red-roof-open-pavilion.jpeg','red-roof-open-pavilion.jpeg','image/jpeg',72833,1080,608,'2a1b70cde16bb3aa29411dccefed6ab8ed7a0d8b4f1f76c0247d103a18fd25aa','Open pavilion structure with columns and a red roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-open-pavilion-thumb.jpeg','/media/projects/red-roof-open-pavilion-thumb.jpeg','red-roof-open-pavilion-thumb.jpeg','image/jpeg',32572,560,315,'9eb2d6825434255a80f1c1e4b03239ae1ce48b3a04c65bf2e9bc409d20979846','Open pavilion structure with columns and a red roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/blue-roof-installation.jpeg','/media/projects/blue-roof-installation.jpeg','blue-roof-installation.jpeg','image/jpeg',72172,1032,581,'52358212902813d9d74e19bd1724b2292e2490356da0ab74a5d3582ee0685da1','JILMEK team installing blue roofing sheets on a new build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/blue-roof-installation-thumb.jpeg','/media/projects/blue-roof-installation-thumb.jpeg','blue-roof-installation-thumb.jpeg','image/jpeg',34630,560,315,'14a4eb957aa42e53e5e23475422e63f4365cf251e7e5958fd68494666c2c927f','JILMEK team installing blue roofing sheets on a new build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/green-hip-roof-residence.jpeg','/media/projects/green-hip-roof-residence.jpeg','green-hip-roof-residence.jpeg','image/jpeg',88599,1080,608,'d82fe2cd8710325e7e54cec07688ef97230bda245d26a361e931c20cecbff4fa','Green hip roof over a block-built residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/green-hip-roof-residence-thumb.jpeg','/media/projects/green-hip-roof-residence-thumb.jpeg','green-hip-roof-residence-thumb.jpeg','image/jpeg',35596,560,315,'0f9320a25c66759ef8ec063e1a95dee6dedea9f2e650b23a8515ccc58c01f1b7','Green hip roof over a block-built residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-shell-plot.jpeg','/media/projects/two-storey-shell-plot.jpeg','two-storey-shell-plot.jpeg','image/jpeg',147242,1000,750,'63b337185d3eb230664a7cdf4a8955e409a8d04e6b9722409bf469903b53bfe7','Two-storey building shell awaiting finishing on an open plot','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-shell-plot-thumb.jpeg','/media/projects/two-storey-shell-plot-thumb.jpeg','two-storey-shell-plot-thumb.jpeg','image/jpeg',52526,560,420,'4762cdfe8d687e9631542a169e3b44283a166d43fb30e4d1e65c12fb95240648','Two-storey building shell awaiting finishing on an open plot','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-block-residence.jpeg','/media/projects/red-roof-block-residence.jpeg','red-roof-block-residence.jpeg','image/jpeg',125923,1000,750,'fd8ec294413bed686f47933cf1db9e5b7f29d0514e4c7697f87bfc1a40f60f3b','Red roof completed over a block residence in open ground','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-block-residence-thumb.jpeg','/media/projects/red-roof-block-residence-thumb.jpeg','red-roof-block-residence-thumb.jpeg','image/jpeg',54068,560,420,'bd31cdbc0c4f8f649dedc7c722ba22d5d7465e5b6564b87fd29802f8f9ce18a3','Red roof completed over a block residence in open ground','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/truss-frame-worker.jpeg','/media/projects/truss-frame-worker.jpeg','truss-frame-worker.jpeg','image/jpeg',82242,984,432,'5df287169972f6a59e90d6d66890855298aeb19510c70ffe62b137887dd4af1f','Carpenter working across a completed timber truss frame','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/truss-frame-worker-thumb.jpeg','/media/projects/truss-frame-worker-thumb.jpeg','truss-frame-worker-thumb.jpeg','image/jpeg',34940,560,246,'a23520d303ab87f8ba8c02465a9aa5ab6d2b1bfff9a1e76882aaa08d92f328f9','Carpenter working across a completed timber truss frame','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-garage-doors.jpeg','/media/projects/red-roof-garage-doors.jpeg','red-roof-garage-doors.jpeg','image/jpeg',104903,1080,648,'0028808b82bfae4402fae4e0819cc7220765a07b164fb4f4cc274a0da6694c51','Red roof and matching garage doors on a finished residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-garage-doors-thumb.jpeg','/media/projects/red-roof-garage-doors-thumb.jpeg','red-roof-garage-doors-thumb.jpeg','image/jpeg',43516,560,336,'6b450a151b7676f35f59557f1187bbbe2ede06bcf5bf79f19b7be371c4d0020c','Red roof and matching garage doors on a finished residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/wide-truss-frame-build.jpeg','/media/projects/wide-truss-frame-build.jpeg','wide-truss-frame-build.jpeg','image/jpeg',92036,984,432,'17cbe7bf8f3e48ef1c4bb8694d333225db9454b0af580771d001db36bad8e2ce','Wide timber truss frame spanning a long block building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/wide-truss-frame-build-thumb.jpeg','/media/projects/wide-truss-frame-build-thumb.jpeg','wide-truss-frame-build-thumb.jpeg','image/jpeg',36991,560,246,'ac2440a9bd48d70ac69beaa325e8876cb15f67d2a65033cb15b57cea61b55f9c','Wide timber truss frame spanning a long block building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/architectural-gable-build.jpeg','/media/projects/architectural-gable-build.jpeg','architectural-gable-build.jpeg','image/jpeg',133794,1000,750,'872674bea46cdee83ad8db5190a25aa830176f207693e5b5661e080e481354c8','Architectural gable frontage taking shape on a residential build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/architectural-gable-build-thumb.jpeg','/media/projects/architectural-gable-build-thumb.jpeg','architectural-gable-build-thumb.jpeg','image/jpeg',49908,560,420,'c932dfc919e2de70b3ae8f48e24cf3071d0313391d0c7e7296ce6c7175508205','Architectural gable frontage taking shape on a residential build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/completed-grey-roof-home.jpeg','/media/projects/completed-grey-roof-home.jpeg','completed-grey-roof-home.jpeg','image/jpeg',75396,1080,608,'d32e8f2be6119f2d4160e87a5c707f63144986a23dce99b32e91be156c325a66','Completed home with grey hip roof and finished rendered walls','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/completed-grey-roof-home-thumb.jpeg','/media/projects/completed-grey-roof-home-thumb.jpeg','completed-grey-roof-home-thumb.jpeg','image/jpeg',32894,560,315,'61bd665f957b6cdcf692022dd4e1463143b1e2edd23bf57799d113eb34487343','Completed home with grey hip roof and finished rendered walls','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-green-roof-project.jpeg','/media/projects/two-storey-green-roof-project.jpeg','two-storey-green-roof-project.jpeg','image/jpeg',91290,1080,810,'8f2ec2e26bd82bd2e75ac43d7939bfd40a60709d4ba4c93a29598ee502516639','Large two-storey project under construction with a green roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-green-roof-project-thumb.jpeg','/media/projects/two-storey-green-roof-project-thumb.jpeg','two-storey-green-roof-project-thumb.jpeg','image/jpeg',38966,560,420,'91c8f92db3bacf459033da0a38ef4f38c13ccb24523a06ca85daa8bace0c75cd','Large two-storey project under construction with a green roof','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/truss-frame-team-build.jpeg','/media/projects/truss-frame-team-build.jpeg','truss-frame-team-build.jpeg','image/jpeg',91129,984,432,'2e9ad30e15c5c97bd5a6fb23e55f473209ad7a31eee1e8c01ccd9c463cd0f628','JILMEK team setting timber trusses on a block structure','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/truss-frame-team-build-thumb.jpeg','/media/projects/truss-frame-team-build-thumb.jpeg','truss-frame-team-build-thumb.jpeg','image/jpeg',39130,560,246,'9efd07663142a8824d9a8f622640b0a1bbedefe86fdb806fbc2201aef2b9e531','JILMEK team setting timber trusses on a block structure','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/bright-red-roof-completed.jpeg','/media/projects/bright-red-roof-completed.jpeg','bright-red-roof-completed.jpeg','image/jpeg',80655,1080,648,'7d8eecc210a1d86e69cd6b6184a4198fd771c0da6cd3e6d8f450f812d1607af0','Bright red roof completed across a long residential building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/bright-red-roof-completed-thumb.jpeg','/media/projects/bright-red-roof-completed-thumb.jpeg','bright-red-roof-completed-thumb.jpeg','image/jpeg',34495,560,336,'efde1b8967e4496130c3f8c79e0a573dff0a2d39fb03f4a2e3a602b141c6b439','Bright red roof completed across a long residential building','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-roadside-build.jpeg','/media/projects/two-storey-roadside-build.jpeg','two-storey-roadside-build.jpeg','image/jpeg',95827,1000,750,'53811af99f072ac136faf823de2622f17aef933772eef3d3af9b77689d3dd384','Two-storey residence under construction beside a gravel access road','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/two-storey-roadside-build-thumb.jpeg','/media/projects/two-storey-roadside-build-thumb.jpeg','two-storey-roadside-build-thumb.jpeg','image/jpeg',44311,560,420,'405bda55a04312a4cf42dab4cdd5136b88d8a47a55f94eae2c64d752a6aeb170','Two-storey residence under construction beside a gravel access road','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/grey-roof-colonnade-shell.jpeg','/media/projects/grey-roof-colonnade-shell.jpeg','grey-roof-colonnade-shell.jpeg','image/jpeg',114420,1000,750,'7275da9de75779bc56ac65ecd1d0b2ea8951e52249102ac503e38d2321925fd7','Grey roof fitted over a colonnade-fronted block shell','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/grey-roof-colonnade-shell-thumb.jpeg','/media/projects/grey-roof-colonnade-shell-thumb.jpeg','grey-roof-colonnade-shell-thumb.jpeg','image/jpeg',49619,560,420,'6bf73bfad77525f4b9f94951b1d23632710aa247fffab73f8dc695d9ab94d51b','Grey roof fitted over a colonnade-fronted block shell','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-multi-gable.jpeg','/media/projects/red-roof-multi-gable.jpeg','red-roof-multi-gable.jpeg','image/jpeg',60909,1080,608,'1a33d86f3966772f02a1b4e38105403540df3e2b998caef4084bda565fa10f18','Multi-gable red roof over a residence nearing completion','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/red-roof-multi-gable-thumb.jpeg','/media/projects/red-roof-multi-gable-thumb.jpeg','red-roof-multi-gable-thumb.jpeg','image/jpeg',27497,560,315,'de2be98e03f6bbc6f20bea9b825663a7c74c6e67a809fc994c2ebbfe20ddc947','Multi-gable red roof over a residence nearing completion','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/roof-installation-in-progress.jpeg','/media/projects/roof-installation-in-progress.jpeg','roof-installation-in-progress.jpeg','image/jpeg',128205,1080,810,'1aebcbb9f64c0c88d805c8cfa49cb41b9eea55a0876fed156f6949e7208c98d4','Roofing team working on site over an arched veranda residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/roof-installation-in-progress-thumb.jpeg','/media/projects/roof-installation-in-progress-thumb.jpeg','roof-installation-in-progress-thumb.jpeg','image/jpeg',49684,560,420,'18817136c1ccb50221044c1736db3dec4507367c0c02d0603912e325c71c2154','Roofing team working on site over an arched veranda residence','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/grey-roof-portico-residence.jpeg','/media/projects/grey-roof-portico-residence.jpeg','grey-roof-portico-residence.jpeg','image/jpeg',69016,1032,581,'aea5e38c73f55a3e5bacb84721c6476b5ba64b945ebf050b5798d1888370a364','Grey hip roof and columned portico on a residential build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/grey-roof-portico-residence-thumb.jpeg','/media/projects/grey-roof-portico-residence-thumb.jpeg','grey-roof-portico-residence-thumb.jpeg','image/jpeg',30523,560,315,'d241ddf1af581441c24104e9db48b49cc78c658bcf1c12c8df934ae7cebb54fb','Grey hip roof and columned portico on a residential build','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/brown-roof-block-walls.jpeg','/media/projects/brown-roof-block-walls.jpeg','brown-roof-block-walls.jpeg','image/jpeg',85375,1080,608,'b90bfc3d2daec88518e82d3e0c2190d158c122821eb4e1654e274946931735d0','Brown roofing sheets over newly laid block walls','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';
INSERT INTO media (storage_key, public_url, original_filename, mime_type, file_size, width, height, checksum_sha256, alt_text, status, created_at) VALUES ('media/projects/brown-roof-block-walls-thumb.jpeg','/media/projects/brown-roof-block-walls-thumb.jpeg','brown-roof-block-walls-thumb.jpeg','image/jpeg',35424,560,315,'aa610a539f7fcc4e9c0eee41c26064b04e7653e19f6bd75281ec0a96ee3db342','Brown roofing sheets over newly laid block walls','public',NOW()) ON DUPLICATE KEY UPDATE public_url=VALUES(public_url), original_filename=VALUES(original_filename), mime_type=VALUES(mime_type), file_size=VALUES(file_size), width=VALUES(width), height=VALUES(height), checksum_sha256=VALUES(checksum_sha256), alt_text=VALUES(alt_text), status='public';

-- Published project records used by the frontend project catalog.
INSERT INTO projects (slug,title,category,summary,location,featured,sort_order,status,published_at,created_at,updated_at) VALUES ('red-roof-colonnade-residence','Colonnade residence, red long-span roof','Roofing','A multi-gable red roof set over an arched colonnade frontage.','Bono East Region',1,35,'published',NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE title=VALUES(title), category=VALUES(category), summary=VALUES(summary), location=VALUES(location), featured=VALUES(featured), sort_order=VALUES(sort_order), status='published', published_at=COALESCE(published_at,NOW()), updated_at=NOW();
INSERT INTO projects (slug,title,category,summary,location,featured,sort_order,status,published_at,created_at,updated_at) VALUES ('blue-roof-installation','Blue roof installation, single-storey residence','Roofing','A full roofing installation captured mid-build.','Bono East Region',1,27,'published',NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE title=VALUES(title), category=VALUES(category), summary=VALUES(summary), location=VALUES(location), featured=VALUES(featured), sort_order=VALUES(sort_order), status='published', published_at=COALESCE(published_at,NOW()), updated_at=NOW();
INSERT INTO projects (slug,title,category,summary,location,featured,sort_order,status,published_at,created_at,updated_at) VALUES ('timber-truss-frames','Timber truss frames, block structures','Construction','Carpentry work across block-built structures before sheeting.','Bono East Region',0,33,'published',NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE title=VALUES(title), category=VALUES(category), summary=VALUES(summary), location=VALUES(location), featured=VALUES(featured), sort_order=VALUES(sort_order), status='published', published_at=COALESCE(published_at,NOW()), updated_at=NOW();
INSERT INTO projects (slug,title,category,summary,location,featured,sort_order,status,published_at,created_at,updated_at) VALUES ('completed-residences','Completed residences, finishing works','Finishing','Buildings taken through to a finished state.','Bono East Region',1,35,'published',NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE title=VALUES(title), category=VALUES(category), summary=VALUES(summary), location=VALUES(location), featured=VALUES(featured), sort_order=VALUES(sort_order), status='published', published_at=COALESCE(published_at,NOW()), updated_at=NOW();
INSERT INTO projects (slug,title,category,summary,location,featured,sort_order,status,published_at,created_at,updated_at) VALUES ('two-storey-projects','Two-storey builds & larger structures','Construction','Larger-format projects at different stages of completion.','Bono East Region',0,36,'published',NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE title=VALUES(title), category=VALUES(category), summary=VALUES(summary), location=VALUES(location), featured=VALUES(featured), sort_order=VALUES(sort_order), status='published', published_at=COALESCE(published_at,NOW()), updated_at=NOW();
INSERT INTO projects (slug,title,category,summary,location,featured,sort_order,status,published_at,created_at,updated_at) VALUES ('roof-profiles-colours','Roof profiles & colour options in place','Roofing','JILMEK roofs in red, blue, green, grey and brown.','Across JILMEK project sites',0,28,'published',NOW(),NOW(),NOW()) ON DUPLICATE KEY UPDATE title=VALUES(title), category=VALUES(category), summary=VALUES(summary), location=VALUES(location), featured=VALUES(featured), sort_order=VALUES(sort_order), status='published', published_at=COALESCE(published_at,NOW()), updated_at=NOW();

-- Link projects to full-size media; the first image is the cover.
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 0, 1 FROM projects p JOIN media m ON m.storage_key='media/projects/red-roof-colonnade-residence.jpeg' WHERE p.slug='red-roof-colonnade-residence' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 1, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/red-roof-multi-gable.jpeg' WHERE p.slug='red-roof-colonnade-residence' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 2, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/red-hip-roof-colonnade.jpeg' WHERE p.slug='red-roof-colonnade-residence' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
UPDATE projects p JOIN media m ON m.storage_key='media/projects/red-roof-colonnade-residence.jpeg' SET p.cover_media_id=m.id WHERE p.slug='red-roof-colonnade-residence';
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 0, 1 FROM projects p JOIN media m ON m.storage_key='media/projects/blue-roof-installation.jpeg' WHERE p.slug='blue-roof-installation' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 1, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/roof-installation-in-progress.jpeg' WHERE p.slug='blue-roof-installation' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 2, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/blue-roof-rendered-home.jpeg' WHERE p.slug='blue-roof-installation' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
UPDATE projects p JOIN media m ON m.storage_key='media/projects/blue-roof-installation.jpeg' SET p.cover_media_id=m.id WHERE p.slug='blue-roof-installation';
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 0, 1 FROM projects p JOIN media m ON m.storage_key='media/projects/wide-truss-frame-build.jpeg' WHERE p.slug='timber-truss-frames' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 1, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/truss-frame-worker.jpeg' WHERE p.slug='timber-truss-frames' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 2, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/truss-frame-team-build.jpeg' WHERE p.slug='timber-truss-frames' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 3, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/timber-truss-single-storey.jpeg' WHERE p.slug='timber-truss-frames' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
UPDATE projects p JOIN media m ON m.storage_key='media/projects/wide-truss-frame-build.jpeg' SET p.cover_media_id=m.id WHERE p.slug='timber-truss-frames';
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 0, 1 FROM projects p JOIN media m ON m.storage_key='media/projects/completed-grey-roof-home.jpeg' WHERE p.slug='completed-residences' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 1, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/completed-blue-hip-roof-home.jpeg' WHERE p.slug='completed-residences' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 2, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/grey-roof-portico-residence.jpeg' WHERE p.slug='completed-residences' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 3, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/bright-red-roof-completed.jpeg' WHERE p.slug='completed-residences' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
UPDATE projects p JOIN media m ON m.storage_key='media/projects/completed-grey-roof-home.jpeg' SET p.cover_media_id=m.id WHERE p.slug='completed-residences';
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 0, 1 FROM projects p JOIN media m ON m.storage_key='media/projects/two-storey-green-roof-project.jpeg' WHERE p.slug='two-storey-projects' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 1, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/two-storey-red-roof-shell.jpeg' WHERE p.slug='two-storey-projects' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 2, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/two-storey-roadside-build.jpeg' WHERE p.slug='two-storey-projects' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 3, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/two-storey-shell-plot.jpeg' WHERE p.slug='two-storey-projects' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
UPDATE projects p JOIN media m ON m.storage_key='media/projects/two-storey-green-roof-project.jpeg' SET p.cover_media_id=m.id WHERE p.slug='two-storey-projects';
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 0, 1 FROM projects p JOIN media m ON m.storage_key='media/projects/green-hip-roof-residence.jpeg' WHERE p.slug='roof-profiles-colours' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 1, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/grey-hip-roof-residence.jpeg' WHERE p.slug='roof-profiles-colours' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 2, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/long-span-brown-roofline.jpeg' WHERE p.slug='roof-profiles-colours' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 3, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/red-roof-garage-doors.jpeg' WHERE p.slug='roof-profiles-colours' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 4, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/brown-roof-block-walls.jpeg' WHERE p.slug='roof-profiles-colours' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
INSERT INTO project_media (project_id, media_id, sort_order, is_cover) SELECT p.id, m.id, 5, 0 FROM projects p JOIN media m ON m.storage_key='media/projects/maroon-roof-veranda-build.jpeg' WHERE p.slug='roof-profiles-colours' ON DUPLICATE KEY UPDATE sort_order=VALUES(sort_order), is_cover=VALUES(is_cover);
UPDATE projects p JOIN media m ON m.storage_key='media/projects/green-hip-roof-residence.jpeg' SET p.cover_media_id=m.id WHERE p.slug='roof-profiles-colours';

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📄 001_foundation.sql	SQL	2.1 KB	2026-11-06 10:12	EDIT
📄 002_media_seed.sql	SQL	63.1 KB	2026-11-06 11:41	EDIT
📄 media-manifest.json	JSON	41.7 KB	2026-11-06 11:41	EDIT
📄 schema.sql	SQL	3.5 KB	2026-11-06 10:05	EDIT