PDMan 模板 添加对索引的支持

来源：Violet_Ice 紫冰

CREATE TABLE {{=it.entity.title}}(
{{ pkList = [] ; }}
{{ indexList = [] ; }}
{{~it.entity.fields:field:index}}
    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}
    `{{=field.name}}` {{=field.type}} {{= field.notNull ? 'NOT NULL' : '' }} {{= field.autoIncrement ? 'AUTO_INCREMENT' : '' }} {{= field.defaultValue ? it.func.join('DEFAULT',field.defaultValue,' ') : '' }} COMMENT '{{=it.func.join(field.chnname,field.remark,' ')}}' {{= index < it.entity.fields.length-1 ? ',' : ( pkList.length>0 ? ',' : it.entity.indexs.length > 0 ? ',' : '' ) }}
{{~}}
{{? pkList.length >0 }}
    PRIMARY KEY ({{~pkList:pkName:i}}`{{= pkName }}`{{= i<pkList.length-1 ? ',' : '' }}{{~}}){{= it.entity.indexs.length > 0 ? ',' : '' }}
{{?}}
{{~it.entity.indexs:row:index}}
    {{= row.isUnique ? 'UNIQUE ' : '' }}INDEX `{{= row.name}}`({{~row.fields:indexName:i}}`{{= indexName}}`{{= i<row.fields.length-1 ? ',' : '' }}{{~}}){{= index < it.entity.indexs.length-1 ? ',' : '' }}
{{~}}
) COMMENT = '{{= it.entity.chnname }}{{? it.entity.remark}} {{= it.entity.remark}}{{?}}'{{=it.separator}}
$blankline

原始模板数据备份：

CREATE TABLE {{=it.entity.title}}(
{{ pkList = [] ; }}
{{~it.entity.fields:field:index}}
    {{? field.pk }}{{ pkList.push(field.name) }}{{?}}
    {{=field.name}} {{=field.type}} {{= field.notNull ? 'NOT NULL' : '' }} {{= field.autoIncrement ? 'AUTO_INCREMENT' : '' }} {{= field.defaultValue ? it.func.join('DEFAULT',field.defaultValue,' ') : '' }} COMMENT '{{=it.func.join(field.chnname,field.remark,' ')}}' {{= index < it.entity.fields.length-1 ? ',' : ( pkList.length>0 ? ',' :'' ) }}
{{~}}
{{? pkList.length >0 }}
    PRIMARY KEY ({{~pkList:pkName:i}}{{= pkName }}{{= i<pkList.length-1 ? ',' : '' }}{{~}})
{{?}}
) COMMENT = '{{=it.func.join(it.entity.chnname,it.entity.remark,' ') }}'{{=it.separator}}
$blankline