From e71e41b36b47590c607f19affc1d438c8f441641 Mon Sep 17 00:00:00 2001 From: gumi Date: Tue, 18 Sep 2018 22:13:44 -0400 Subject: add missing `IF NOT EXISTS` clause to the `char_achievements` table creation query --- sql-files/main.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files') 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', -- cgit v1.2.3-70-g09d2