Story #121 Update database to support multiple levels of email opt out | Technical Documentation - cseseniordesign/reservations GitHub Wiki

Database

• Changes within the database:
  • Created a new table email_types to hold the types of emails. The columns of the table include:
    • id INT(11) PK NOT NULL AUTOINCREMENT
    • name VARCHAR(255)
  • Added a new column to the preset_emails table to hold a foreign key to the new email_types table. Column added:
    • event_type INT(11)
  • Also wrote a script to update current preset emails to have event types.