From ea070e44e0542b56108fd1ae39ba64eb8d4a7f3d Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 31 Jan 2012 15:13:38 +0100 Subject: Core/Items: Defined "unk" field in HotfixInfo --- sql/updates/world/2012_01_31_02_world_hotfix_data.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2012_01_31_02_world_hotfix_data.sql (limited to 'sql') diff --git a/sql/updates/world/2012_01_31_02_world_hotfix_data.sql b/sql/updates/world/2012_01_31_02_world_hotfix_data.sql new file mode 100644 index 00000000000..ce45feed943 --- /dev/null +++ b/sql/updates/world/2012_01_31_02_world_hotfix_data.sql @@ -0,0 +1,5 @@ +ALTER TABLE hotfix_data ADD `hotfixDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `unk`; +UPDATE `hotfix_data` SET `hotfixDate`=FROM_UNIXTIME(`unk`); +ALTER TABLE `hotfix_data` DROP PRIMARY KEY; +ALTER TABLE `hotfix_data` ADD PRIMARY KEY (`entry`,`type`,`hotfixDate`); +ALTER TABLE `hotfix_data` DROP `unk`; -- cgit v1.2.3