Bathroom data - CII

[dong-eileen]

Gather real bathroom data on Low Center for Industrial Innovation.

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 ('Low Center for Industrial Innovation', 3);

• In building name table:
  -- INSERT INTO building_name (name, building_id) VALUES ('Low Center for Industrial Innovation', INSERT NEW BUILDING ID HERE);
  -- INSERT INTO building_name (name, building_id) VALUES ('Low', INSERT NEW BUILDING ID HERE);
  -- INSERT INTO building_name (name, building_id) VALUES ('CII', 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.