From 1261645736407dfb114ddc50119d36a0ff4055c5 Mon Sep 17 00:00:00 2001 From: "Donald A. Lobo" Date: Tue, 19 Mar 2013 19:38:11 -0700 Subject: [PATCH] CRM-12151 --- xml/templates/schema.tpl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/xml/templates/schema.tpl b/xml/templates/schema.tpl index 8025fa44a9..198947d14b 100644 --- a/xml/templates/schema.tpl +++ b/xml/templates/schema.tpl @@ -65,7 +65,7 @@ CREATE TABLE `{$table.name}` ( {if $index.unique} UNIQUE{/if} INDEX `{$index.name}`( {assign var='firstIndexField' value=true} {foreach from=$index.field item=fieldName} - {if $firstIndexField}{assign var='firstIndexField' value=false}{else}, {/if}`{$fieldName}` + {if $firstIndexField}{assign var='firstIndexField' value=false}{else}, {/if}{$fieldName} {/foreach} ) {/foreach} {* table.index *} @@ -75,7 +75,7 @@ CREATE TABLE `{$table.name}` ( {foreach from=$table.foreignKey item=foreign} {if ! $first},{/if} {assign var='first' value=false} - {if $mysql eq 'simple'} INDEX FKEY_{$foreign.name} ( `{$foreign.name}` ) , {/if} + {if $mysql eq 'simple'} INDEX FKEY_{$foreign.name} ( `{$foreign.name}` ) , {/if} CONSTRAINT {$foreign.uniqName} FOREIGN KEY (`{$foreign.name}`) REFERENCES `{$foreign.table}`(`{$foreign.key}`) {if $foreign.onDelete}ON DELETE {$foreign.onDelete}{/if} {/foreach} {* table.foreignKey *} {/if} {* table.foreignKey *} -- 2.25.1