X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Ftemplates%2Fschema.tpl;h=8305c0484f277d9d9829c6eda2b66db9e44d0ddb;hb=026e3376b287552e68a62785f392ddc0a17266d6;hp=dd0d4ab143bb76efdaaab2bb9213a2ee1ab651f5;hpb=639a47e989e0b5b12be546d93f99ec0571f887ee;p=civicrm-core.git diff --git a/xml/templates/schema.tpl b/xml/templates/schema.tpl index dd0d4ab143..8305c0484f 100644 --- a/xml/templates/schema.tpl +++ b/xml/templates/schema.tpl @@ -1,7 +1,7 @@ -- +--------------------------------------------------------------------+ --- | CiviCRM version 4.4 | +-- | CiviCRM version 4.5 | -- +--------------------------------------------------------------------+ --- | Copyright CiviCRM LLC (c) 2004-2013 | +-- | Copyright CiviCRM LLC (c) 2004-2014 | -- +--------------------------------------------------------------------+ -- | This file is a part of CiviCRM. | -- | | @@ -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}