3 class AddRelations < ActiveRecord::Migration
5 # a relation can have members much like a way can have nodes.
7 # way: only nodes / relation: any kind of member
8 # way: ordered sequence of nodes / relation: free-form "role" string
9 create_table "current_relation_members", innodb_table do |t|
10 t.column "id", :bigint, :limit => 64, :null => false
11 t.column "member_type", :string, :limit => 11, :null => false
12 t.column "member_id", :bigint, :limit => 11, :null => false
13 t.column "member_role", :string
15 # enums work like strings but are more efficient
16 alter_column_nwr_enum :current_relation_members, :member_type
18 add_primary_key "current_relation_members", ["id", "member_type", "member_id", "member_role"]
19 add_index "current_relation_members", ["member_type", "member_id"], :name => "current_relation_members_member_idx"
20 # the following is obsolete given the primary key, is it not?
21 # add_index "current_relation_members", ["id"], :name => "current_relation_members_id_idx"
22 create_table "current_relation_tags", myisam_table do |t|
23 t.column "id", :bigint, :limit => 64, :null => false
24 t.column "k", :string, :default => "", :null => false
25 t.column "v", :string, :default => "", :null => false
28 add_index "current_relation_tags", ["id"], :name => "current_relation_tags_id_idx"
29 add_fulltext_index "current_relation_tags", "v"
31 create_table "current_relations", innodb_table do |t|
32 t.column "id", :bigint_pk_64, :null => false
33 t.column "user_id", :bigint, :limit => 20, :null => false
34 t.column "timestamp", :datetime, :null => false
35 t.column "visible", :boolean, :null => false
38 create_table "relation_members", myisam_table do |t|
39 t.column "id", :bigint, :limit => 64, :default => 0, :null => false
40 t.column "member_type", :string, :limit => 11, :null => false
41 t.column "member_id", :bigint, :limit => 11, :null => false
42 t.column "member_role", :string
43 t.column "version", :bigint, :limit => 20, :default => 0, :null => false
46 alter_column_nwr_enum :relation_members, :member_type
47 add_primary_key "relation_members", ["id", "version", "member_type", "member_id", "member_role"]
48 add_index "relation_members", ["member_type", "member_id"], :name => "relation_members_member_idx"
50 create_table "relation_tags", myisam_table do |t|
51 t.column "id", :bigint, :limit => 64, :default => 0, :null => false
52 t.column "k", :string, :null => false, :default => ""
53 t.column "v", :string, :null => false, :default => ""
54 t.column "version", :bigint, :limit => 20, :null => false
57 add_index "relation_tags", ["id", "version"], :name => "relation_tags_id_version_idx"
59 create_table "relations", myisam_table do |t|
60 t.column "id", :bigint, :limit => 64, :null => false, :default => 0
61 t.column "user_id", :bigint, :limit => 20, :null => false
62 t.column "timestamp", :datetime, :null => false
63 t.column "version", :bigint, :limit => 20, :null => false
64 t.column "visible", :boolean, :null => false, :default => true
67 add_primary_key "relations", ["id", "version"]
68 add_index "relations", ["timestamp"], :name => "relations_timestamp_idx"
70 change_column "relations", "version", :bigint_auto_20
76 drop_table :current_relations
77 drop_table :relation_tags
78 drop_table :current_relation_tags
79 drop_table :relation_members
80 drop_table :current_relation_members