create on indexes

sdepold · sdepold · commit d61bdaebed2f · 2013-05-20T14:00:46.000+02:00
diff --git a/lib/node/indexes.js b/lib/node/indexes.js
@@ -3,10 +3,12 @@
 var Node = require(__dirname);
 var IndexesNode = module.exports = Node.define({
   type: 'INDEXES',
-  constructor: function () {
+
+  constructor: function(table) {
     Node.call(this);
-    this.names = [];
-    this.columns = [];
+    this.table     = table;
+    this.names     = [];
+    this.columns   = [];
     this.valueSets = [];
   }
 });
diff --git a/lib/node/query.js b/lib/node/query.js
@@ -229,7 +229,8 @@ var Query = Node.define({
     return this;
   },
   indexes: function() {
-    this.add(new Indexes());
+    var indexes = new Indexes({ table: this.table });
+    this.add(indexes);
     return this;
   }
 });
diff --git a/lib/table.js b/lib/table.js
@@ -210,6 +210,6 @@ Table.prototype.indexes = function() {
   var query = new Query(this);
   query.indexes.apply(query, arguments);
   return query;
-}
+};
 
 module.exports = Table;
diff --git a/test/dialects/indexes-tests.js b/test/dialects/indexes-tests.js
@@ -9,3 +9,14 @@ Harness.test({
   mysql:  "SHOW INDEX FROM `post`",
   sqlite: "PRAGMA INDEX_LIST(\"post\")"
 });
+
+Harness.test({
+  query: post.indexes().create({
+    type:      'unique',
+    algorithm: 'btree',
+    parser:    'foo',
+    name:      'bar',
+    columns:   [post.id, post.userId]
+  }),
+  mysql: "CREATE UNIQUE INDEX `bar` USING BTREE ON `post` (`post`.`id`, `post`.`userId`) WITH PARSER foo"
+})
