:command:
:debug: false
:hide_default_column_types: ''
-:hide_limit_column_types: 'integer,boolean'
+:hide_limit_column_types: 'integer,bigint,boolean'
:ignore_columns:
:ignore_routes:
:models: true
#
# Table name: acls
#
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
# address :inet
# k :string not null
# v :string
#
# Table name: changesets
#
-# id :bigint(8) not null, primary key
-# user_id :bigint(8) not null
+# id :bigint not null, primary key
+# user_id :bigint not null
# created_at :datetime not null
# min_lat :integer
# max_lat :integer
# Table name: changeset_comments
#
# id :integer not null, primary key
-# changeset_id :bigint(8) not null
-# author_id :bigint(8) not null
+# changeset_id :bigint not null
+# author_id :bigint not null
# body :text not null
# created_at :datetime not null
# visible :boolean not null
#
# Table name: changeset_tags
#
-# changeset_id :bigint(8) not null, primary key
+# changeset_id :bigint not null, primary key
# k :string default(""), not null, primary key
# v :string default(""), not null
#
#
# Table name: diary_comments
#
-# id :bigint(8) not null, primary key
-# diary_entry_id :bigint(8) not null
-# user_id :bigint(8) not null
+# id :bigint not null, primary key
+# diary_entry_id :bigint not null
+# user_id :bigint not null
# body :text not null
# created_at :datetime not null
# updated_at :datetime not null
#
# Table name: diary_entries
#
-# id :bigint(8) not null, primary key
-# user_id :bigint(8) not null
+# id :bigint not null, primary key
+# user_id :bigint not null
# title :string not null
# body :text not null
# created_at :datetime not null
#
# Table name: diary_entry_subscriptions
#
-# user_id :bigint(8) not null, primary key
-# diary_entry_id :bigint(8) not null, primary key
+# user_id :bigint not null, primary key
+# diary_entry_id :bigint not null, primary key
#
# Indexes
#
#
# Table name: friends
#
-# id :bigint(8) not null, primary key
-# user_id :bigint(8) not null
-# friend_user_id :bigint(8) not null
+# id :bigint not null, primary key
+# user_id :bigint not null
+# friend_user_id :bigint not null
# created_at :datetime
#
# Indexes
#
# Table name: messages
#
-# id :bigint(8) not null, primary key
-# from_user_id :bigint(8) not null
+# id :bigint not null, primary key
+# from_user_id :bigint not null
# title :string not null
# body :text not null
# sent_on :datetime not null
# message_read :boolean default(FALSE), not null
-# to_user_id :bigint(8) not null
+# to_user_id :bigint not null
# to_user_visible :boolean default(TRUE), not null
# from_user_visible :boolean default(TRUE), not null
# body_format :enum default("markdown"), not null
#
# Table name: current_nodes
#
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
# latitude :integer not null
# longitude :integer not null
-# changeset_id :bigint(8) not null
+# changeset_id :bigint not null
# visible :boolean not null
# timestamp :datetime not null
-# tile :bigint(8) not null
-# version :bigint(8) not null
+# tile :bigint not null
+# version :bigint not null
#
# Indexes
#
#
# Table name: current_node_tags
#
-# node_id :bigint(8) not null, primary key
+# node_id :bigint not null, primary key
# k :string default(""), not null, primary key
# v :string default(""), not null
#
#
# Table name: notes
#
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
# latitude :integer not null
# longitude :integer not null
-# tile :bigint(8) not null
+# tile :bigint not null
# updated_at :datetime not null
# created_at :datetime not null
# status :enum not null
# closed_at :datetime
# description :text default(""), not null
-# user_id :bigint(8)
+# user_id :bigint
# user_ip :inet
#
# Indexes
#
# Table name: note_comments
#
-# id :bigint(8) not null, primary key
-# note_id :bigint(8) not null
+# id :bigint not null, primary key
+# note_id :bigint not null
# visible :boolean not null
# created_at :datetime not null
# author_ip :inet
-# author_id :bigint(8)
+# author_id :bigint
# body :text
# event :enum
#
#
# Table name: note_subscriptions
#
-# user_id :bigint(8) not null, primary key
-# note_id :bigint(8) not null, primary key
+# user_id :bigint not null, primary key
+# note_id :bigint not null, primary key
#
# Indexes
#
#
# Table name: oauth_applications
#
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
# owner_type :string not null
-# owner_id :bigint(8) not null
+# owner_id :bigint not null
# name :string not null
# uid :string not null
# secret :string not null
#
# Table name: nodes
#
-# node_id :bigint(8) not null, primary key
+# node_id :bigint not null, primary key
# latitude :integer not null
# longitude :integer not null
-# changeset_id :bigint(8) not null
+# changeset_id :bigint not null
# visible :boolean not null
# timestamp :datetime not null
-# tile :bigint(8) not null
-# version :bigint(8) not null, primary key
+# tile :bigint not null
+# version :bigint not null, primary key
# redaction_id :integer
#
# Indexes
#
# Table name: node_tags
#
-# node_id :bigint(8) not null, primary key
-# version :bigint(8) not null, primary key
+# node_id :bigint not null, primary key
+# version :bigint not null, primary key
# k :string default(""), not null, primary key
# v :string default(""), not null
#
#
# Table name: relations
#
-# relation_id :bigint(8) not null, primary key
-# changeset_id :bigint(8) not null
+# relation_id :bigint not null, primary key
+# changeset_id :bigint not null
# timestamp :datetime not null
-# version :bigint(8) not null, primary key
+# version :bigint not null, primary key
# visible :boolean default(TRUE), not null
# redaction_id :integer
#
#
# Table name: relation_members
#
-# relation_id :bigint(8) not null, primary key
+# relation_id :bigint not null, primary key
# member_type :enum not null
-# member_id :bigint(8) not null
+# member_id :bigint not null
# member_role :string not null
-# version :bigint(8) default(0), not null, primary key
+# version :bigint default(0), not null, primary key
# sequence_id :integer default(0), not null, primary key
#
# Indexes
#
# Table name: relation_tags
#
-# relation_id :bigint(8) not null, primary key
+# relation_id :bigint not null, primary key
# k :string default(""), not null, primary key
# v :string default(""), not null
-# version :bigint(8) not null, primary key
+# version :bigint not null, primary key
#
# Foreign Keys
#
#
# Table name: ways
#
-# way_id :bigint(8) not null, primary key
-# changeset_id :bigint(8) not null
+# way_id :bigint not null, primary key
+# changeset_id :bigint not null
# timestamp :datetime not null
-# version :bigint(8) not null, primary key
+# version :bigint not null, primary key
# visible :boolean default(TRUE), not null
# redaction_id :integer
#
#
# Table name: way_nodes
#
-# way_id :bigint(8) not null, primary key
-# node_id :bigint(8) not null
-# version :bigint(8) not null, primary key
-# sequence_id :bigint(8) not null, primary key
+# way_id :bigint not null, primary key
+# node_id :bigint not null
+# version :bigint not null, primary key
+# sequence_id :bigint not null, primary key
#
# Indexes
#
#
# Table name: way_tags
#
-# way_id :bigint(8) not null, primary key
+# way_id :bigint not null, primary key
# k :string not null, primary key
# v :string not null
-# version :bigint(8) not null, primary key
+# version :bigint not null, primary key
#
# Foreign Keys
#
# description :text not null
# created_at :datetime
# updated_at :datetime
-# user_id :bigint(8) not null
+# user_id :bigint not null
# description_format :enum default("markdown"), not null
#
# Foreign Keys
#
# Table name: current_relations
#
-# id :bigint(8) not null, primary key
-# changeset_id :bigint(8) not null
+# id :bigint not null, primary key
+# changeset_id :bigint not null
# timestamp :datetime not null
# visible :boolean not null
-# version :bigint(8) not null
+# version :bigint not null
#
# Indexes
#
#
# Table name: current_relation_members
#
-# relation_id :bigint(8) not null, primary key
+# relation_id :bigint not null, primary key
# member_type :enum not null
-# member_id :bigint(8) not null
+# member_id :bigint not null
# member_role :string not null
# sequence_id :integer default(0), not null, primary key
#
#
# Table name: current_relation_tags
#
-# relation_id :bigint(8) not null, primary key
+# relation_id :bigint not null, primary key
# k :string default(""), not null, primary key
# v :string default(""), not null
#
#
# Table name: gpx_files
#
-# id :bigint(8) not null, primary key
-# user_id :bigint(8) not null
+# id :bigint not null, primary key
+# user_id :bigint not null
# visible :boolean default(TRUE), not null
# name :string default(""), not null
-# size :bigint(8)
+# size :bigint
# latitude :float
# longitude :float
# timestamp :datetime not null
# trackid :integer not null
# latitude :integer not null
# longitude :integer not null
-# gpx_id :bigint(8) not null
+# gpx_id :bigint not null
# timestamp :datetime
-# tile :bigint(8)
+# tile :bigint
#
# Indexes
#
#
# Table name: gpx_file_tags
#
-# gpx_id :bigint(8) not null
+# gpx_id :bigint not null
# tag :string not null
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
#
# Indexes
#
# Table name: users
#
# email :string not null
-# id :bigint(8) not null, primary key
+# id :bigint not null, primary key
# pass_crypt :string not null
# creation_time :datetime not null
# display_name :string default(""), not null
# diary_entries_count :integer default(0), not null
# image_use_gravatar :boolean default(FALSE), not null
# auth_provider :string
-# home_tile :bigint(8)
+# home_tile :bigint
# tou_agreed :datetime
# diary_comments_count :integer default(0)
# note_comments_count :integer default(0)
# Table name: user_blocks
#
# id :integer not null, primary key
-# user_id :bigint(8) not null
-# creator_id :bigint(8) not null
+# user_id :bigint not null
+# creator_id :bigint not null
# reason :text not null
# ends_at :datetime not null
# needs_view :boolean default(FALSE), not null
-# revoker_id :bigint(8)
+# revoker_id :bigint
# created_at :datetime
# updated_at :datetime
# reason_format :enum default("markdown"), not null
#
# Table name: user_mutes
#
-# id :bigint(8) not null, primary key
-# owner_id :bigint(8) not null
-# subject_id :bigint(8) not null
+# id :bigint not null, primary key
+# owner_id :bigint not null
+# subject_id :bigint not null
# created_at :datetime not null
# updated_at :datetime not null
#
#
# Table name: user_preferences
#
-# user_id :bigint(8) not null, primary key
+# user_id :bigint not null, primary key
# k :string not null, primary key
# v :string not null
#
# Table name: user_roles
#
# id :integer not null, primary key
-# user_id :bigint(8) not null
-# role :enum not null
+# user_id :bigint not null
# created_at :datetime
# updated_at :datetime
-# granter_id :bigint(8) not null
+# role :enum not null
+# granter_id :bigint not null
#
# Indexes
#
#
# Table name: current_ways
#
-# id :bigint(8) not null, primary key
-# changeset_id :bigint(8) not null
+# id :bigint not null, primary key
+# changeset_id :bigint not null
# timestamp :datetime not null
# visible :boolean not null
-# version :bigint(8) not null
+# version :bigint not null
#
# Indexes
#
#
# Table name: current_way_nodes
#
-# way_id :bigint(8) not null, primary key
-# node_id :bigint(8) not null
-# sequence_id :bigint(8) not null, primary key
+# way_id :bigint not null, primary key
+# node_id :bigint not null
+# sequence_id :bigint not null, primary key
#
# Indexes
#
#
# Table name: current_way_tags
#
-# way_id :bigint(8) not null, primary key
+# way_id :bigint not null, primary key
# k :string default(""), not null, primary key
# v :string default(""), not null
#