You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
628 B
17 lines
628 B
/**
|
|
* @signature add628927ee030469f5d3272ebda1e16
|
|
* @version v1.15
|
|
* @title Alter dept_id and priority_id in email table
|
|
*
|
|
* This patch changes dept_id and priority_id fron tinyint to int
|
|
*/
|
|
|
|
-- change dept_id
|
|
ALTER TABLE `%TABLE_PREFIX%email` CHANGE `dept_id` `dept_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
|
|
-- change priority_id
|
|
ALTER TABLE `%TABLE_PREFIX%email` CHANGE `priority_id` `priority_id` INT( 11 ) UNSIGNED NOT NULL DEFAULT '2';
|
|
|
|
-- Finished with patch
|
|
UPDATE `%TABLE_PREFIX%config`
|
|
SET `value` = 'add628927ee030469f5d3272ebda1e16'
|
|
WHERE `key` = 'schema_signature' AND `namespace` = 'core';
|