-- ----------------------------------------------------------------
-- Change in settings table for more language settings
-- ----------------------------------------------------------------
ALTER TABLE `sod_settings` 
	DROP FOREIGN KEY `sod_settings_ibfk_1`;
ALTER TABLE `sod_settings` 
	CHANGE COLUMN `workflow_notifications` `workflow_notifications` CHAR(9) NOT NULL DEFAULT '111111111' AFTER `workflow_notifications_email`,
	CHANGE COLUMN `system_reaction` `system_reaction` INT(11) NOT NULL DEFAULT '4' ,
	CHANGE COLUMN `system_reaction_available` `system_reaction_available` VARCHAR(6) NOT NULL DEFAULT '100110' ,
	CHANGE COLUMN `workflow_notifications_language` `default_language` CHAR(2) NOT NULL DEFAULT 'en' ;
ALTER TABLE `sod_settings` 
	ADD CONSTRAINT `sod_settings_ibfk_1`
		FOREIGN KEY (`system_reaction`)
		REFERENCES `sod_warning_types` (`id`);