CREATE TABLE `person` (
	`person_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NOT NULL,
	`author_id` INT(11) UNSIGNED NULL DEFAULT NULL,
	`user_id` INT(11) UNSIGNED NULL DEFAULT NULL COMMENT 'creator of person',
	PRIMARY KEY (`person_id`),
	UNIQUE INDEX `author_id` (`author_id`),
	INDEX `FK_person_user` (`user_id`),
	CONSTRAINT `FK_person_author` FOREIGN KEY (`author_id`) REFERENCES `author` (`author_id`) ON DELETE SET NULL,
	CONSTRAINT `FK_person_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE SET NULL
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=45;