33 lines
2.0 KiB
SQL
33 lines
2.0 KiB
SQL
-- Insert new rows into rooms table for rooms 140-163
|
|
-- Use ON CONFLICT to update existing records if name already exists
|
|
INSERT INTO rooms (name, room_type_id, s3_suffix) VALUES
|
|
('room140_wallpaper_standing', 2, 'standing/wallpaper/room140.jpg'),
|
|
('room141_wallpaper_standing', 2, 'standing/wallpaper/room141.jpg'),
|
|
('room142_wallpaper_standing', 2, 'standing/wallpaper/room142.jpg'),
|
|
('room143_wallpaper_standing', 2, 'standing/wallpaper/room143.jpg'),
|
|
('room144_wallpaper_standing', 2, 'standing/wallpaper/room144.jpg'),
|
|
('room145_wallpaper_standing', 2, 'standing/wallpaper/room145.jpg'),
|
|
('room146_wallpaper_standing', 2, 'standing/wallpaper/room146.jpg'),
|
|
('room147_wallpaper_standing', 2, 'standing/wallpaper/room147.jpg'),
|
|
('room148_wallpaper_standing', 2, 'standing/wallpaper/room148.jpg'),
|
|
('room149_wallpaper_standing', 2, 'standing/wallpaper/room149.jpg'),
|
|
('room150_wallpaper_standing', 2, 'standing/wallpaper/room150.jpg'),
|
|
('room151_wallpaper_standing', 2, 'standing/wallpaper/room151.jpg'),
|
|
('room152_wallpaper_standing', 2, 'standing/wallpaper/room152.jpg'),
|
|
('room153_wallpaper_standing', 2, 'standing/wallpaper/room153.jpg'),
|
|
('room154_wallpaper_standing', 2, 'standing/wallpaper/room154.jpg'),
|
|
('room155_wallpaper_standing', 2, 'standing/wallpaper/room155.jpg'),
|
|
('room156_wallpaper_standing', 2, 'standing/wallpaper/room156.jpg'),
|
|
('room157_wallpaper_standing', 2, 'standing/wallpaper/room157.jpg'),
|
|
('room158_wallpaper_standing', 2, 'standing/wallpaper/room158.jpg'),
|
|
('room159_wallpaper_standing', 2, 'standing/wallpaper/room159.jpg'),
|
|
('room160_wallpaper_standing', 2, 'standing/wallpaper/room160.jpg'),
|
|
('room161_wallpaper_standing', 2, 'standing/wallpaper/room161.jpg'),
|
|
('room162_wallpaper_standing', 2, 'standing/wallpaper/room162.jpg'),
|
|
('room163_wallpaper_standing', 2, 'standing/wallpaper/room163.jpg')
|
|
ON CONFLICT (name)
|
|
DO UPDATE SET
|
|
room_type_id = EXCLUDED.room_type_id,
|
|
s3_suffix = EXCLUDED.s3_suffix;
|
|
|