diff options
| author | gumi <git@gumi.ca> | 2018-09-18 22:13:44 -0400 |
|---|---|---|
| committer | gumi <git@gumi.ca> | 2018-09-18 22:13:44 -0400 |
| commit | e71e41b36b47590c607f19affc1d438c8f441641 (patch) | |
| tree | 5fbb1154cd8fdf2ba5961f5d94e8d6bc7c4039e0 | |
| parent | 611bda248b3cb221bef4ad81f74c0508a76095d9 (diff) | |
| download | hercules-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.sql | 2 |
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', |