FamilyTreeSQL

gistfile1.txt

-- ---
-- Globals
-- ---

-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET FOREIGN_KEY_CHECKS=0;

-- ---
-- Table 'People'
-- 
-- ---

DROP TABLE IF EXISTS `People`;

CREATE TABLE `People` (
  `id` INTEGER NULL AUTO_INCREMENT DEFAULT NULL,
  `name` MEDIUMTEXT NULL DEFAULT NULL,
  `mother_id` INTEGER NULL DEFAULT NULL,
  `father_id` INTEGER NULL DEFAULT NULL,
  `gender` MEDIUMTEXT NULL DEFAULT NULL,
  `birthday` DATE NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

-- ---
-- Foreign Keys
-- ---

ALTER TABLE `People` ADD FOREIGN KEY (mother_id) REFERENCES `People` (`id`);
ALTER TABLE `People` ADD FOREIGN KEY (mother_id) REFERENCES `People` (`id`);
ALTER TABLE `People` ADD FOREIGN KEY (father_id) REFERENCES `People` (`id`);
ALTER TABLE `People` ADD FOREIGN KEY (father_id) REFERENCES `People` (`id`);

-- ---
-- Table Properties
-- ---

-- ALTER TABLE `People` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ---
-- Test Data
-- ---

-- INSERT INTO `People` (`id`,`name`,`mother_id`,`father_id`,`gender`,`birthday`) VALUES
-- ('','','','','','');