summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorgumi <git@gumi.ca>2018-09-18 22:13:44 -0400
committergumi <git@gumi.ca>2018-09-18 22:13:44 -0400
commite71e41b36b47590c607f19affc1d438c8f441641 (patch)
tree5fbb1154cd8fdf2ba5961f5d94e8d6bc7c4039e0
parent611bda248b3cb221bef4ad81f74c0508a76095d9 (diff)
downloadhercules-e71e41b36b47590c607f19affc1d438c8f441641.tar.gz
hercules-e71e41b36b47590c607f19affc1d438c8f441641.tar.bz2
hercules-e71e41b36b47590c607f19affc1d438c8f441641.tar.xz
hercules-e71e41b36b47590c607f19affc1d438c8f441641.zip
add missing `IF NOT EXISTS` clause to the `char_achievements` table creation query
-rw-r--r--sql-files/main.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index d29f05a2e..2fa6f1332 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -121,7 +121,7 @@ CREATE TABLE IF NOT EXISTS `autotrade_merchants` (
-- Table structure for table `char_achievements`
--
-CREATE TABLE `char_achievements` (
+CREATE TABLE IF NOT EXISTS `char_achievements` (
`char_id` INT(11) UNSIGNED NOT NULL,
`ach_id` INT(11) UNSIGNED NOT NULL,
`completed_at` INT(10) UNSIGNED NOT NULL DEFAULT '0',