Welcome to mirror list, hosted at ThFree Co, Russian Federation.

gitlab.com/gitlab-org/gitlab-foss.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNick Thomas <nick@gitlab.com>2019-06-19 16:10:07 +0300
committerNick Thomas <nick@gitlab.com>2019-06-19 16:11:01 +0300
commit8802dd24ecf17fa90b3e0200a05224297fa0f462 (patch)
tree1974b45483993690c43ffc7724aa678b700a75a4 /doc/development/swapping_tables.md
parent7754029e190eee6eb530c4c8dc45bec57095d92c (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.md8
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