move migrations around

[rails.git] / db / migrate / 012_create_node_tags.rb

diff --git a/db/migrate/012_create_node_tags.rb b/db/migrate/012_create_node_tags.rb
new file mode 100644 (file)
index 0000000..316602d
--- /dev/null
+++ b/db/migrate/012_create_node_tags.rb
@@ -0,0 +1,18 @@
+class CreateNodeTags < ActiveRecord::Migration
+  def self.up
+    create_table "current_node_tags", myisam_table do |t|
+      t.column "id",          :bigint, :limit => 64,                 :null => false
+      t.column "sequence_id", :bigint, :limit => 11,                 :null => false
+      t.column "k",           :string,              :default => "", :null => false
+      t.column "v",           :string,              :default => "", :null => false
+    end
+
+    add_primary_key "current_node_tags", ["id", "sequence_id"]
+       
+    execute "CREATE FULLTEXT INDEX `current_node_tags_v_idx` ON `current_node_tags` (`v`)"
+  end
+
+  def self.down
+    drop_table :current_node_tags
+  end
+end