X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/c5f33db61e8ac24e578ae431f95a2566255fbf27..602b7b6d3fc602288804ebe16d00181f4acfa239:/db/migrate/011_create_node_tags.rb diff --git a/db/migrate/011_create_node_tags.rb b/db/migrate/011_create_node_tags.rb index e0e791404..6f84043ee 100644 --- a/db/migrate/011_create_node_tags.rb +++ b/db/migrate/011_create_node_tags.rb @@ -1,18 +1,15 @@ class CreateNodeTags < ActiveRecord::Migration def self.up create_table "current_node_tags", myisam_table do |t| - t.column "id", :bigint, :limit => 64 - t.column "sequence_id", :bigint, :limit => 11 - t.column "k", :string, :default => "", :null => false - t.column "v", :string, :default => "", :null => false + 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_index "current_node_tags", ["id"], :name => "current_node_tags_id_idx" - add_primary_key "current_node_tags", ["sequence_id", "id"] + 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