From 06459c91e5c0e1370477be288b173b26a7e04789 Mon Sep 17 00:00:00 2001
From: Tim Otten <totten@civicrm.org>
Date: Mon, 31 Mar 2014 15:31:27 -0700
Subject: [PATCH] GenCode - Apply SQL-escaping to table comments

Fix regression stemming from 9e64deca
---
 xml/templates/schema.tpl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/xml/templates/schema.tpl b/xml/templates/schema.tpl
index 68c9015c91..8305c0484f 100644
--- a/xml/templates/schema.tpl
+++ b/xml/templates/schema.tpl
@@ -52,7 +52,7 @@ CREATE TABLE `{$table.name}` (
 {if ! $first},{/if}
 {assign var='first' value=false}
 
-     `{$field.name}` {$field.sqlType}{if $field.collate} COLLATE {$field.collate}{/if} {if $field.required}{if $field.required == "false"}NULL{else}NOT NULL{/if}{/if} {if $field.autoincrement}AUTO_INCREMENT{/if} {if $field.default|count_characters}DEFAULT {$field.default}{/if} {if $field.comment}COMMENT '{$field.comment}'{/if}
+     `{$field.name}` {$field.sqlType}{if $field.collate} COLLATE {$field.collate}{/if} {if $field.required}{if $field.required == "false"}NULL{else}NOT NULL{/if}{/if} {if $field.autoincrement}AUTO_INCREMENT{/if} {if $field.default|count_characters}DEFAULT {$field.default}{/if} {if $field.comment}COMMENT '{ts escape=sql}{$field.comment}{/ts}'{/if}
 {/foreach} {* table.fields *}
 
 {if $table.primaryKey}
-- 
2.25.1