From e71e41b36b47590c607f19affc1d438c8f441641 Mon Sep 17 00:00:00 2001
From: gumi <git@gumi.ca>
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/main.sql')

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

