Last active
February 12, 2019 15:56
-
-
Save timabell/503b2da4e4baa974c2726296e31be256 to your computer and use it in GitHub Desktop.
Fixup postgres sequence names. See https://github.com/DFE-Digital/manage-courses-backend/pull/105
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER SEQUENCE mc_organisation_id_seq RENAME TO organisation_id_seq; | |
ALTER TABLE organisation ALTER id SET DEFAULT nextval('organisation_id_seq'::regclass); | |
ALTER SEQUENCE mc_organisation_institution_id_seq RENAME TO organisation_provider_id_seq; | |
ALTER TABLE organisation_provider ALTER id SET DEFAULT nextval('organisation_provider_id_seq'::regclass); | |
ALTER SEQUENCE mc_organisation_user_id_seq RENAME TO organisation_user_id_seq; | |
ALTER TABLE organisation_user ALTER id SET DEFAULT nextval('organisation_user_id_seq'::regclass); | |
ALTER SEQUENCE "UcasInstitutions_Id_seq" RENAME TO provider_id_seq; | |
ALTER TABLE provider ALTER id SET DEFAULT nextval('provider_id_seq'::regclass); | |
ALTER SEQUENCE institution_enrichment_id_seq RENAME TO provider_enrichment_id_seq; | |
ALTER TABLE provider_enrichment ALTER id SET DEFAULT nextval('provider_enrichment_id_seq'::regclass); | |
ALTER SEQUENCE mc_session_id_seq RENAME TO session_id_seq; | |
ALTER TABLE session ALTER id SET DEFAULT nextval('session_id_seq'::regclass); | |
ALTER SEQUENCE "UcasCampuses_Id_seq" RENAME TO site_id_seq; | |
ALTER TABLE site ALTER id SET DEFAULT nextval('site_id_seq'::regclass); | |
ALTER SEQUENCE "UcasSubjects_Id_seq" RENAME TO subject_id_seq; | |
ALTER TABLE subject ALTER id SET DEFAULT nextval('subject_id_seq'::regclass); | |
ALTER SEQUENCE mc_user_id_seq RENAME TO user_id_seq; | |
ALTER TABLE "user" ALTER id SET DEFAULT nextval('user_id_seq'::regclass); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment