Skip to content

Instantly share code, notes, and snippets.

@timabell
Last active February 12, 2019 15:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timabell/503b2da4e4baa974c2726296e31be256 to your computer and use it in GitHub Desktop.
Save timabell/503b2da4e4baa974c2726296e31be256 to your computer and use it in GitHub Desktop.
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