diff options
| author | Haru <haru@dotalux.com> | 2016-07-08 02:21:04 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-08 02:21:04 +0200 |
| commit | 72a06cdfa933534319a99cecc781b56acecce9cd (patch) | |
| tree | 38e440734065a76cdf36dc74b1011687cd5d8927 /sql-files/upgrades/rAthena-logs-upgrade.sql | |
| parent | a088c365019a92251c7163a2379cfcdce8bedd12 (diff) | |
| parent | 6a84cbb2d527a0fb263a9104690bcfcb24f182e1 (diff) | |
| download | hercules-72a06cdfa933534319a99cecc781b56acecce9cd.tar.gz hercules-72a06cdfa933534319a99cecc781b56acecce9cd.tar.bz2 hercules-72a06cdfa933534319a99cecc781b56acecce9cd.tar.xz hercules-72a06cdfa933534319a99cecc781b56acecce9cd.zip | |
Merge pull request #1344 from 4144/sqlfix
Replace in sql files fields with default date/datetime into default N…
Diffstat (limited to 'sql-files/upgrades/rAthena-logs-upgrade.sql')
| -rw-r--r-- | sql-files/upgrades/rAthena-logs-upgrade.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql-files/upgrades/rAthena-logs-upgrade.sql b/sql-files/upgrades/rAthena-logs-upgrade.sql index 5e9dbf60c..09a571818 100644 --- a/sql-files/upgrades/rAthena-logs-upgrade.sql +++ b/sql-files/upgrades/rAthena-logs-upgrade.sql @@ -40,3 +40,11 @@ ALTER TABLE `picklog` MODIFY `card0` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `picklog` MODIFY `card1` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `picklog` MODIFY `card2` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `picklog` MODIFY `card3` INT(11) NOT NULL DEFAULT '0'; +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; |