55Q5iviy

1CREATE TABLE IF NOT EXISTS `learning_objectives` (
2  `id` INT NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR(255) NOT NULL,
4  `parent_id` INT DEFAULT NULL COMMENT '/**INCLUDE_ONLY*/, <BackwardReference="children">',
5  PRIMARY KEY (`id`),
6  KEY `fk_learning_objectives_id` (`parent_id`),
7  CONSTRAINT `fk_learning_objectives_id` FOREIGN KEY (`parent_id`) REFERENCES `learning_objectives` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='DB_CONNECTOR_ODATA';
9
10INSERT INTO `bugfour`.`learning_objectives` (`id`, `name`) VALUES ('1', '1');
11INSERT INTO `bugfour`.`learning_objectives` (`id`, `name`, `parent_id`) VALUES ('2', '2', '1');
12INSERT INTO `bugfour`.`learning_objectives` (`id`, `name`, `parent_id`) VALUES ('3', '3', '1');
13INSERT INTO `bugfour`.`learning_objectives` (`id`, `name`, `parent_id`) VALUES ('4', '4', '2');
14INSERT INTO `bugfour`.`learning_objectives` (`id`, `name`, `parent_id`) VALUES ('5', '5', '4');
15INSERT INTO `bugfour`.`learning_objectives` (`id`, `name`, `parent_id`) VALUES ('6', '6', '3');