renderAddIndex method

  1. @override
List<String> renderAddIndex(
  1. String tableName,
  2. IndexBlueprint index
)
override

Implementation

@override
List<String> renderAddIndex(String tableName, IndexBlueprint index) {
  final cols = index.columns.map((c) => '`$c`').join(', ');
  if (index.type == ColumnIndex.unique) {
    return ['CREATE UNIQUE INDEX `${index.name}` ON `$tableName` ($cols)'];
  }
  if (index.type == ColumnIndex.fulltext) {
    return ['CREATE FULLTEXT INDEX `${index.name}` ON `$tableName` ($cols)'];
  }
  if (index.type == ColumnIndex.spatial) {
    return ['CREATE SPATIAL INDEX `${index.name}` ON `$tableName` ($cols)'];
  }
  return ['CREATE INDEX `${index.name}` ON `$tableName` ($cols)'];
}