Database changes in version 09.00.00
over 5 years ago by Michael Tobisch
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