import { IfNotExistsOption, Name, Reversible } from "../generalTypes.js";
import { MigrationOptions } from "../../migrationOptions.js";
import { IndexColumn } from "./shared.js";
import { DropIndexOptions } from "./dropIndex.js";

//#region src/operations/indexes/createIndex.d.ts
interface CreateIndexOptions extends IfNotExistsOption {
  name?: string;
  unique?: boolean;
  where?: string;
  concurrently?: boolean;
  method?: 'btree' | 'hash' | 'gist' | 'spgist' | 'gin';
  include?: string | string[];
  nulls?: 'distinct' | 'not distinct';
}
type CreateIndexFn = (tableName: Name, columns: string | Array<string | IndexColumn>, indexOptions?: CreateIndexOptions & DropIndexOptions) => string;
type CreateIndex = Reversible<CreateIndexFn>;
declare function createIndex(mOptions: MigrationOptions): CreateIndex;
//#endregion
export { CreateIndex, CreateIndexFn, CreateIndexOptions, createIndex };