Skip to content

Instantly share code, notes, and snippets.

@marceloandrader
Created December 16, 2014 20:58
Show Gist options
  • Save marceloandrader/d0870e43887307f271f9 to your computer and use it in GitHub Desktop.
Save marceloandrader/d0870e43887307f271f9 to your computer and use it in GitHub Desktop.
CREATE TABLE `account_preferences` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`account_id` INT(10) UNSIGNED NOT NULL,
`first_name` VARCHAR(45) NULL,
`last_name` VARCHAR(45) NULL,
`details` TEXT NOT NULL,
`created_dt` DATETIME NULL,
`updated_dt` DATETIME NULL,
PRIMARY KEY (`id`),
INDEX `fk_account_preferences_1_idx` (`account_id` ASC),
CONSTRAINT `fk_account_preferences_1`
FOREIGN KEY (`account_id`)
REFERENCES `account` (`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