Tables

Table Surveys

• Changed field OptionType to int use an Enum
  • RadioButton: old value 'R' -> new value 0
  • CheckBox: old value 'C' -> new value 1
• Changed the length of Question to nvarchar(max)
• Added RepeatDirection and RepeatColumns for Radiobuttons and Checkboxes
• Added NumberOfRows for text answers
• Added ChartType
• Added LastModifiedDate and ModifiedByUserID
• Added Index to ModuleID (Foreign Key)
• Added Index to ModuleID + ViewOrder

Table SurveyOptions

• Changed the length of OptionName to nvarchar(max)
• Added a default value of 0 for Votes
• Added CreatedDate, CreatedByUserID, LastModifiedDate and LastModifiedByUserID
• Added index to SurveyID (Foreign Key)
• Added index to SurveyID + ViewOrder

Table SurveyResults

• Added IPAddess field
• Added TextAnswer field
• Added anonymous pseudo User-GUID
• Added Index to SurveyOptionID (Foreign Key)

Stored Procedures

Stored Procedures Surveys

• Added Stored Procedures
  • Surveys_AddOrChange
  • Surveys_CsvExport
  • Surveys_HasVoted
  • Surveys_Sort
• Removed Stored Procedures
  • AddSurvey
  • DeleteSurvey
  • GetSurvey
  • GetSurveys
  • UpdateSurvey

Stored Procedures SurveyOptions

• Added Stored Procedures
  • SurveyOptions_AddOrChange
• Removed Stored Procedures
  • AddSurveyOption
  • DeleteSurveyOption
  • GetSurveyOptions
  • UpdateSurveyOption

Stored Procedures SurveyResult

• Added Stored Procedures

  • SurveyResults_Add
  • SurveyResults_Get
  • SurveyResults_GetAll
  • SurveyResultData_Delete

• Removed stored procedures

  • AddSurveyResult
  • AddSurveyResult_cookie
  • DeleteSurveyResultData
  • GetSurveyResultData

Views

Views Surveys

• Added Views
  • vSurveys_CsvExport