Changeset 8628 for trunk

Timestamp:

01/14/12 09:02:07 (17 months ago)

Author:

MELERIX

Message:

BETA/STABLE: Missing safe check update from [8332].

File:

• trunk/L2J_DataPack/dist/sql/game/updates/20110831update.sql (modified) (1 diff)

trunk/L2J_DataPack/dist/sql/game/updates/20110831update.sql

@@ -1 +1 @@
 ALTER TABLE `characters` ADD `createDate` date NOT NULL DEFAULT '0000-00-00' AFTER `createTime`;
-UPDATE `characters` SET `createDate` = FROM_UNIXTIME(`createTime`/1000, '%Y-%m%-%d');
+UPDATE `characters` SET `createDate`=FROM_UNIXTIME(`createTime`/1000, '%Y-%m%-%d');
+UPDATE `characters` SET `createDate`=CURDATE() WHERE `createDate`='0000-00-00';
 ALTER TABLE `characters` DROP `createTime`;