Database changes in version 09.00.00

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