l1lle / orm-mptt Goto Github PK

class Model_Category extends ORM_MPTT {
}

$cat = ORM::factory('Category_Mptt');
$cat->name = 'Music';
$cat->insert_as_new_root();
echo 'Category ID'.$mptt->id.' set at level '.$cat->lvl.' (scope: '.$cat->scope.')';
$c1 = $cat; // Saving id for next example

$cat->clear(); // Clearing ORM object
$cat->name = 'Terminology';
$cat->insert_as_last_child($c1);

CREATE TABLE `test_orm_mptt` (
	`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	`parent_id` INT UNSIGNED NULL,
	`lft` INT UNSIGNED NOT NULL,
	`rgt` INT UNSIGNED NOT NULL,
	`lvl` INT UNSIGNED NOT NULL,
	`scope` INT UNSIGNED NOT NULL
) ENGINE=INNODB;