Skip to content

Instantly share code, notes, and snippets.

@Anakin-Hao

Anakin-Hao/Alter albi_puff table

Created March 18, 2019 03:56
Show Gist options
  • Save Anakin-Hao/1b16353930bd2378dd2ffb601ef87c32 to your computer and use it in GitHub Desktop.
Save Anakin-Hao/1b16353930bd2378dd2ffb601ef87c32 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Alter albi_puff table
BEGIN;
ALTER TABLE albi_puff drop constraint albi_puff_realm_id_fkey;
ALTER TABLE albi_puff add constraint albi_puff_realm_id_fkey
FOREIGN KEY (realm_id)
REFERENCES realm(id)
ON DELETE CASCADE;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment