@@ -6,7 +6,14 @@
 @Target(ElementType.TYPE)
 @Repeatable(Indices.class)
 public @interface Index {
+    Type type() default Type.AUTO;
     boolean unique() default false;
     String id() default "";
     String[] value() default {};
+
+    enum Type {
+        AUTO,
+        BTREE,
+        HASH
+    }
 }
@@ -136,6 +136,8 @@ private static void migrateTable(SQL sql, TableInfo info, boolean tableExists) {
             StringBuilder sb = new StringBuilder("CREATE ");
             if (index.unique())
                 sb.append("UNIQUE ");
+            if (index.type() != Index.Type.AUTO)
+                sb.append("USING ").append(index.type().name()).append(" ");
             sb.append("INDEX `")
                     .append(id)
                     .append("` ON `")