Release 2.2.5

• Added a value to the Race enum as requested by Algozzine.
• Added the classOfferingUpdate procedure for Michelle.

Release 2.2.4

Final release for the semester. No further structural changes will be made.

Updates

• addressID added to Sites table for one-to-one relationship.
• REFERRALTYPE enum fixed spelling of Sheriff
• Other minor procedural updates

Release 2.2.3

NEED CHANGE LOG

Release 2.2.1

Procedures
The attendanceInsert stored procedure has been fixed.

Release 2.2

Inserts
Fix Curriculm Names
Removed relationship between classes and curricula

Procedures
Modify createOutOfHouseParticipant to return Void
Made addressUpdate

Updates
Added update file for forms team

Views
Added relatedContactAgency, participantEmergencyContactInfo, participantContactInfo

Other
Updated ER Diagram

Release 2.1

UPDATES

• VIEWS
  • SelfReferralInfo VIEW Removed family information
  • AgencyReferralInfo VIEW Removed family information
  • IntakePacketInfo VIEW Removed family information
• PROCEDURES
  • employeeInsert PROCEDURE Changed DF to boolean(false) from 0
  • agencyMemberInsert PROCEDURE Changed phone number to be TEXT instead of INT
• INSERTS
  • Adjusted the sequence number to account for inserted classes and curricula
  • Reordered curricula inserts to not waster sequence numbers

Release 2.0

UPDATES

• TABLES
  • Sites contain foreign key constraint with Addresses
  • ClassOffering PRIMARY KEYs are now only date & siteName
  • Surveys are neither linked to Participants nor Forms, instead we are going to use participantName as a TEXT field
• VIEWS
  • IntakePacketInfo VIEW created for forms team
  • AgencyReferralInfo VIEW created for forms team
  • SelfReferralInfo VIEW created for forms team
  • ParticipantModal VIEW created for UI team
  • ContactAgencyModal VIEW created for UI team
• PROCEDURES
  • Significant logic updates for all PROCEDUREs
  • SurveyInsert PROCEDURE created for Surveys team
  • From now on all procedures requiring the insertion or update of participant data will take participantID as a parameter instead of fName and lName to avoid conflicts during lookup
• INSERTS
  • Created sensible data Classes, Curricula, and Languages
  • Removed sample data from test directory
    • All sample data will be placed in INSERTS.sql from now on
• doc
  • Updated documentation for current features

Release 1.0

First full release for client. Deployed at the CPCA.