-- +--------------------------------------------------------------------+
--- | CiviCRM version 4.3 |
+-- | CiviCRM version 4.4 |
-- +--------------------------------------------------------------------+
-- | Copyright CiviCRM LLC (c) 2004-2013 |
-- +--------------------------------------------------------------------+
-- | GNU Affero General Public License or the licensing of CiviCRM, |
-- | see the CiviCRM license FAQ at http://civicrm.org/licensing |
-- +--------------------------------------------------------------------+
+--
+-- Generated from {$smarty.template}
+-- {$generated}
+--
{$database.comments}
{include file="drop.tpl"}
{if ! $first},{/if}
{assign var='first' value=false}
- `{$field.name}` {$field.sqlType} {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 '{$field.comment}'{/if}
{/foreach} {* table.fields *}
{if $table.primaryKey}