2016_07_17_Minions-world-creature_template_outfits.sql

[Talmeron]

2016_07_17_Minions-world-creature_template_outfits.sql Line 66, Usual error saying Syntax bad.

Current behaviour: Dies

Expected behaviour: Doesn't die ;)

Steps to reproduce the problem:

1. Auto load SQL updates from fresh DB April 2016
   .

Branch(es): 335

TC hash/commit: Lastest as of Yesterday.

Operating system: Ubuntu

[conan513]

hmm strange but it's working for me with mariaDB 10.1.22

[Tedris]

MySQL has an issue with IF NOT EXISTS, you need to comment out at least that line or use MariaDB instead.

[Tedris]

Specifically the issue is in adding the primary key if not exists, that throws an error in MySQL but not in MariaDB.

[t880216t]

I delete this sql ,it can be done .
ALTER TABLE creature_template_outfits ADD PRIMARY KEY IF NOT EXISTS (entry);