diff options
author | Nick Thomas <nick@gitlab.com> | 2019-06-19 16:10:07 +0300 |
---|---|---|
committer | Nick Thomas <nick@gitlab.com> | 2019-06-19 16:11:01 +0300 |
commit | 8802dd24ecf17fa90b3e0200a05224297fa0f462 (patch) | |
tree | 1974b45483993690c43ffc7724aa678b700a75a4 /doc/development/swapping_tables.md | |
parent | 7754029e190eee6eb530c4c8dc45bec57095d92c (diff) |
Update the docs to reflect lack of MySQL support
Now MySQL is no longer supported, we need to change the docs
Diffstat (limited to 'doc/development/swapping_tables.md')
-rw-r--r-- | doc/development/swapping_tables.md | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/doc/development/swapping_tables.md b/doc/development/swapping_tables.md index 29cd6a43aff..5c62900dbff 100644 --- a/doc/development/swapping_tables.md +++ b/doc/development/swapping_tables.md @@ -39,14 +39,6 @@ PostgreSQL you can use the `reset_pk_sequence!` method like so: reset_pk_sequence!('events') ``` -For MySQL however you need to do run the following: - -```ruby -amount = Event.pluck('COALESCE(MAX(id), 1)').first - -execute "ALTER TABLE events AUTO_INCREMENT = #{amount}" -``` - Failure to reset the primary keys will result in newly created rows starting with an ID value of 1. Depending on the existing data this can then lead to duplicate key constraints from popping up, preventing users from creating new |