createIndex method

Future<void> createIndex(
  1. String indexName,
  2. String table,
  3. List<String> columns, {
  4. bool unique = false,
})

Create an index

Implementation

Future<void> createIndex(
  String indexName,
  String table,
  List<String> columns, {
  bool unique = false,
}) async {
  final uniqueStr = unique ? 'UNIQUE ' : '';
  final columnsStr = columns.join(', ');
  await executor.runCustom(
      'CREATE ${uniqueStr}INDEX $indexName ON $table($columnsStr)');
}