[openstreetmap/openstreetmap-website] Align structure.sql with generated output (Issue #4298)

[Andy Allan]

There are a few small differences between our structure.sql file, and the output generated from rails schema dumping on my system. I'm not sure whether this is because of different rails versions or different postgresql versions used between the time that these bits of the file were generated, and today. But it's a bit annoying when trying to develop migrations, so if it's possible for us to resolve them it'll make our developers lives a little bit easier.

On my own system, I get four main differences:
* The `AS integer` phrase for sequences isn't included on my system, but we have it in our structure.sql file
* The `ar_internal_metadata` table has a slightly different definition, i.e.
  ```diff
  -    created_at timestamp(6) without time zone NOT NULL,
  -    updated_at timestamp(6) without time zone NOT NULL
  +    created_at timestamp without time zone NOT NULL,
  +    updated_at timestamp without time zone NOT NULL
  ```
* There is a comment added on the btree_gist extension
* The schema_migrations table has a wildly different order, but I'll ignore that for now

I'm interested to know, before I make a pull request, whether my experience is typical. You can test yourself by running `bundle exec rails db:schema:dump` followed by `git diff` to see what the differences are on your own system between the schema dump and what we have in structure.sql.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/4298
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/issues/4298 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20231018/4d151aec/attachment.htm>