PHP Classes

File: install/mptt.sql

Recommend this page to a friend!
  Classes of Stefan Gabos   Zebra MPTT   install/mptt.sql   Download  
File: install/mptt.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Zebra MPTT
Store a tree using the MPTT algorithm in MySQL
Author: By
Last change:
Date: 5 years ago
Size: 296 bytes
 

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS `mptt` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `lft` int(11) NOT NULL default '0',
  `rgt` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;