diff options
| author | Andrei Karas <akaras@inbox.ru> | 2016-07-08 02:59:20 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2016-07-08 03:12:49 +0300 |
| commit | 6a84cbb2d527a0fb263a9104690bcfcb24f182e1 (patch) | |
| tree | 38e440734065a76cdf36dc74b1011687cd5d8927 /sql-files/upgrades/eAthena-logs-upgrade.sql | |
| parent | 45b2d8b7858c22e80457ebc4e3732e104b48bcb1 (diff) | |
| download | hercules-6a84cbb2d527a0fb263a9104690bcfcb24f182e1.tar.gz hercules-6a84cbb2d527a0fb263a9104690bcfcb24f182e1.tar.bz2 hercules-6a84cbb2d527a0fb263a9104690bcfcb24f182e1.tar.xz hercules-6a84cbb2d527a0fb263a9104690bcfcb24f182e1.zip | |
Add sql upgrade scripts for convert date/datetime default values.
Diffstat (limited to 'sql-files/upgrades/eAthena-logs-upgrade.sql')
| -rw-r--r-- | sql-files/upgrades/eAthena-logs-upgrade.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql-files/upgrades/eAthena-logs-upgrade.sql b/sql-files/upgrades/eAthena-logs-upgrade.sql index 09ed4d8d0..014f119e3 100644 --- a/sql-files/upgrades/eAthena-logs-upgrade.sql +++ b/sql-files/upgrades/eAthena-logs-upgrade.sql @@ -42,3 +42,12 @@ ALTER TABLE `zenylog` MODIFY `type` ENUM('M','T','V','S','N','A','E','B','I','D' -- Add 'P' and 'C' types in `zenylog` ALTER TABLE `zenylog` MODIFY `type` ENUM('T','V','P','M','S','N','D','C','A','E','I','B') NOT NULL DEFAULT 'S'; + +ALTER TABLE `atcommandlog` MODIFY `atcommand_date` DATETIME NULL; +ALTER TABLE `branchlog` MODIFY `branch_date` DATETIME NULL; +ALTER TABLE `chatlog` MODIFY `time` DATETIME NULL; +ALTER TABLE `loginlog` MODIFY `time` DATETIME NULL; +ALTER TABLE `mvplog` MODIFY `mvp_date` DATETIME NULL; +ALTER TABLE `npclog` MODIFY `npc_date` DATETIME NULL; +ALTER TABLE `picklog` MODIFY `time` DATETIME NULL; +ALTER TABLE `zenylog` MODIFY `time` DATETIME NULL; |