Skip to content
This repository has been archived by the owner on Jul 24, 2021. It is now read-only.

rails db migrate script errors #483

Closed
openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment
Closed

rails db migrate script errors #483

openstreetmap-trac opened this issue Jul 23, 2021 · 1 comment

Comments

@openstreetmap-trac
Copy link

Reporter: writetodan[at]yahoo.com
[Submitted to the original trac issue database at 2.00pm, Wednesday, 23rd May 2007]

source:sites/rails_port/db/migrate/001_create_osm_db.rb

has some problems:

  • some duplicate indexes (by default rails creates primary key on 'id' field)
  • makes node coordinates single-precision
  • default 'id' PK enforces uniqueness on way 'id' in way segments and tags tables

the attached path attempts to fix this, but i haven't verified as yet.

once set 'id => false', might also need to add:
t.column "id", :integer
...statements to current_way_segments and current_way_tags

@openstreetmap-trac
Copy link
Author

Author: tom[at]compton.nu
[Added to the original trac issue at 11.20am, Friday, 22nd June 2007]

Change r3293 modified the migrate script to make it produce a database that exactly matches that on the live system (as confirmed by dumping both schemas and comparing them).

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant