From 28ae27806adaba18cf2a374d9521a8721662e61a Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Sun, 19 May 2013 22:37:15 +0200 Subject: [PATCH] SQLParser only supports the CREATE INDEX syntax --- com.woltlab.wcf/update_post_b1.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/com.woltlab.wcf/update_post_b1.sql b/com.woltlab.wcf/update_post_b1.sql index bfe01e448e..ef35bd8a0e 100644 --- a/com.woltlab.wcf/update_post_b1.sql +++ b/com.woltlab.wcf/update_post_b1.sql @@ -1,5 +1,5 @@ -ALTER TABLE wcf1_acp_template ADD UNIQUE KEY applicationTemplate (application, templateName); +CREATE UNIQUE INDEX applicationTemplate ON wcf1_acp_template (application, templateName); -ALTER TABLE wcf1_package_installation_file_log ADD UNIQUE KEY applicationFile (application, filename); +CREATE UNIQUE INDEX applicationFile ON wcf1_package_installation_file_log (application, filename); -ALTER TABLE wcf1_template ADD UNIQUE KEY applicationTemplate (application, templateGroupID templateName); \ No newline at end of file +CREATE UNIQUE INDEX applicationTemplate ON wcf1_template (application, templateGroupID templateName); -- 2.20.1