Function createIndex

packages/sql/src/schema/SchemaHelper.ts:1086–1112

(index: IndexDef, table: DatabaseTable, createPrimary = false)

  }

  createIndex(index: IndexDef, table: DatabaseTable, createPrimary = false): string {
    if (index.primary && !createPrimary) {
      return '';
    }

    if (index.expression) {
      return index.expression;
    }

    const columns = index.columnNames.map(c => this.quote(c)).join(', ');
    const defer = index.deferMode ? ` deferrable initially ${index.deferMode}` : '';

    if (index.primary) {
      const keyName = this.hasNonDefaultPrimaryKeyName(table) ? `constraint ${index.keyName} ` : '';
      return `alter table ${table.getQuotedName()} add ${keyName}primary key (${columns})${defer}`;
    }

    if (index.type === 'fulltext') {
      const columns = index.columnNames.map(name => ({ name, type: table.getColumn(name)!.type }));

      if (this.platform.supportsCreatingFullTextIndex()) {
        return this.platform.getFullTextIndexExpression(index.keyName, table.schema, table.name, columns);
      }
    }

    return this.getCreateIndexSQL(table.getShortestName(), index);
  }

  createCheck(table: DatabaseTable, check: CheckDef): string {
    const expression = check.expression as string;