kburk1997/RelieveMe

Bathroom data - VCC

Closed this issue · 1 comments

dong-eileen commented

Gather real bathroom data on Voorhees Computing Center.

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 ('Voorhees Computing Center', 3);

  • In building name table:
    -- INSERT INTO building_name (name, building_id) VALUES ('Voorhees Computing Center', INSERT NEW BUILDING ID HERE);
    -- INSERT INTO building_name (name, building_id) VALUES ('VCC', INSERT NEW BUILDING ID HERE);
    -- INSERT INTO building_name (name, building_id) VALUES ('Voorhees', 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.

rrabideau1 commented

complete, but might want a guy to verify men's restroom information