Contents

create_table :categories, id: :bigserial do |t|
  t.string :name, limit: 250, null: true
end
create_table :advertisers, id: :bigserial do |t|
  t.string  :name, limit: 250, null: true
  t.integer :category_id, limit: 8, null: false
end
create_table :affiliates, id: :bigserial do |t|
  t.string  :name, limit: 250, null: true
  t.integer :category_id, limit: 8, null: false
end
add_index :advertisers, [:category_id], name: :index_advertisers_on_category_id
add_index :affiliates, [:category_id], name: :index_affiliates_on_category_id
add_foreign_key :advertisers, :categories, column: :category_id, name: :index_advertisers_on_category_id
add_foreign_key :affiliates, :categories, column: :category_id, name: :index_affiliates_on_category_id

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
declare_schema-2.3.2	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.3.1	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.3.0	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.3.0.pre.is.0	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.2.1	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.2.0.colin.1	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.2.0	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.1.0	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt
declare_schema-2.1.0.pre.1	spec/fixtures/migrations/postgresql/will_generate_unique_constraint_names_rails_6.txt