Skip to content

Latest commit

 

History

History
17 lines (15 loc) · 732 Bytes

README.md

File metadata and controls

17 lines (15 loc) · 732 Bytes

SadParkingViolations

Setup

  1. Setup and run the Mysql server.
  2. Download the SadParkingViolations repo to the "www" directory
  3. Modify the file path on line 59 of project2-create-populate to point to the downloaded Parking_Violations_Issued_-_Fiscal_Year_2017.csv file
  4. Run the db setup files in this order:
    • project2-create-populate.sql,
    • project2-validation-triggers.sql,
    • project2-views.sql,
    • project2-insert-all-sp.sql,
    • project2-aggregation-sps.sql,
    • project2-audit-triggers.sql
  5. Modify conn.php for the proper credentials to connect to the database. Provided are the default MAC and Windows credentials.
  6. open localhost/<project-dir>/index2.html
  7. Navigate the site.