New Feature: Complex row quotas (see: https://blueprints.launchpad.net/quexs/+spec/complexquota) - Thank you Marco for sponsoring this feature
New Feature: Time slots extended to cover sample by sample as well as questionnaire by questionnaire - Thank you for sponsoring this feature
Fixed Bug: Check for available cases on no case available page is too time consuming
Fixed Bug lp:1436664 - System sort process fails where database name not 'quexs'
Fixed Bug lp:1452070 - New numbers still drawn when 'allow new numbers to be drawn' set to No
Fixed Bug lp:1459935 - When no operators have an extension assigned, questionnaires in test mode fail to create phone numbers for new cases
Translations: Updated from Launchpad - thank you especially to Russian and Spanish translators for updating your translations!
Database updates:
CREATE TABLE `questionnaire_sample_timeslot` (
`questionnaire_id` bigint( 20 ) NOT NULL ,
`sample_import_id` bigint( 20 ) NOT NULL ,
`availability_group_id` bigint( 20 ) NOT NULL ,
PRIMARY KEY ( `questionnaire_id` , `availability_group_id` , `sample_import_id` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
CREATE TABLE `qsqr_question` (
`qsqr_question_id` bigint(20) NOT NULL AUTO_INCREMENT,
`questionnaire_sample_quota_row_id` bigint(20) NOT NULL,
`lime_sgqa` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
`comparison` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`qsqr_question_id`),
KEY `questionnaire_sample_quota_row_id` (`questionnaire_sample_quota_row_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE `qsqr_sample` (
`qsqr_sample_id` bigint(20) NOT NULL AUTO_INCREMENT,
`questionnaire_sample_quota_row_id` bigint(20) NOT NULL,
`exclude_var` char(128) COLLATE utf8_unicode_ci NOT NULL,
`exclude_val` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`comparison` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`qsqr_sample_id`),
KEY `questionnaire_sample_quota_row_id` (`questionnaire_sample_quota_row_id`),
KEY `exclude_var` (`exclude_var`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
INSERT INTO qsqr_question (questionnaire_sample_quota_row_id,lime_sgqa,value,comparison)
SELECT questionnaire_sample_quota_row_id, lime_sgqa, value, comparison
FROM questionnaire_sample_quota_row
WHERE lime_sgqa != -1 AND lime_sgqa != -2;
INSERT INTO qsqr_sample (questionnaire_sample_quota_row_id,exclude_var,exclude_val,comparison)
SELECT questionnaire_sample_quota_row_id, exclude_var,exclude_val, 'LIKE'
FROM questionnaire_sample_quota_row;
ALTER TABLE `questionnaire_sample_quota_row`
DROP `lime_sgqa`,
DROP `value`,
DROP `comparison`,
DROP `exclude_var`,
DROP `exclude_val`;
