X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/550ce43250208b25d459247d3bbb5bbc25fa3ff4..1c5db113e215892ecff6090c571ffa1c4b9737db:/db/migrate/007_add_relations.rb diff --git a/db/migrate/007_add_relations.rb b/db/migrate/007_add_relations.rb index b4aff6e09..41d62928f 100644 --- a/db/migrate/007_add_relations.rb +++ b/db/migrate/007_add_relations.rb @@ -1,17 +1,20 @@ +require 'migrate' + class AddRelations < ActiveRecord::Migration def self.up + # enums work like strings but are more efficient + create_enumeration :nwr_enum, ["Node", "Way", "Relation"] + # a relation can have members much like a way can have nodes. # differences: # way: only nodes / relation: any kind of member # way: ordered sequence of nodes / relation: free-form "role" string create_table "current_relation_members", innodb_table do |t| - t.column "id", :bigint, :limit => 64, :null => false - t.column "member_type", :string, :limit => 11, :null => false - t.column "member_id", :bigint, :limit => 11, :null => false + t.column "id", :bigint, :limit => 64, :null => false + t.column "member_type", :nwr_enum, :null => false + t.column "member_id", :bigint, :limit => 11, :null => false t.column "member_role", :string end - # enums work like strings but are more efficient - execute "alter table current_relation_members change column member_type member_type enum('node','way','relation');" add_primary_key "current_relation_members", ["id", "member_type", "member_id", "member_role"] add_index "current_relation_members", ["member_type", "member_id"], :name => "current_relation_members_member_idx" @@ -34,14 +37,13 @@ class AddRelations < ActiveRecord::Migration end create_table "relation_members", myisam_table do |t| - t.column "id", :bigint, :limit => 64, :default => 0, :null => false - t.column "member_type", :string, :limit => 11, :null => false - t.column "member_id", :bigint, :limit => 11, :null => false + t.column "id", :bigint, :limit => 64, :default => 0, :null => false + t.column "member_type", :nwr_enum, :null => false + t.column "member_id", :bigint, :limit => 11, :null => false t.column "member_role", :string - t.column "version", :bigint, :limit => 20, :default => 0, :null => false + t.column "version", :bigint, :limit => 20, :default => 0, :null => false end - execute "alter table relation_members change column member_type member_type enum('node','way','relation');" add_primary_key "relation_members", ["id", "version", "member_type", "member_id", "member_role"] add_index "relation_members", ["member_type", "member_id"], :name => "relation_members_member_idx" @@ -76,5 +78,6 @@ class AddRelations < ActiveRecord::Migration drop_table :current_relation_tags drop_table :relation_members drop_table :current_relation_members + drop_enumeration :nwr_enum end end