Bathroom data - 87 Gym
Closed this issue · 0 comments
dong-eileen commented
Gather real bathroom data on 87 Gymnasium.
Update the bathroom data spreadsheet.
Backend:
- Edit data.sql
Insert the following into data.sql:
-
In building table:
-- INSERT INTO building (proper_name, region_id) VALUES ('87 Gymnasium', 3); -
In building name table:
-- INSERT INTO building_name (name, building_id) VALUES ('87 Gymnasium', INSERT NEW BUILDING ID HERE);
-- INSERT INTO building_name (name, building_id) VALUES ('87 Gym', INSERT NEW BUILDING ID HERE); -
Insert floor data
-
Insert floor plan data
-
Insert bathroom data
Look at existing data.sql for example queries and format.