Skip to content

Instantly share code, notes, and snippets.

@jayar95

jayar95/appointments table

Last active January 5, 2017 19:29
Show Gist options
  • Save jayar95/91227e17156bcc658b7333fa3be1c76c to your computer and use it in GitHub Desktop.
Save jayar95/91227e17156bcc658b7333fa3be1c76c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
appointments table
ALTER TABLE `appointments`
ADD COLUMN `outcome` INT(10) UNSIGNED NULL DEFAULT NULL COMMENT '' AFTER `campaign`,
ADD INDEX `fk_appointments_disposition1_idx` (`outcome` ASC) COMMENT '';
ALTER TABLE `appointments`
ADD CONSTRAINT `fk_appointments_disposition1`
FOREIGN KEY (`disposition`)
REFERENCES `disposition` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment