X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/c5f33db61e8ac24e578ae431f95a2566255fbf27..b8f87e04666479d1037e27aed86f6a024d9e0208:/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..316602d69 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