Login   Register  
PHP Classes
elePHPant
Icontem

File: tableStructure.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mark Stuppacher  >  Nested set  >  tableStructure.sql  >  Download  
File: tableStructure.sql
Role: Auxiliary data
Content type: text/plain
Description: Structure of database table
Class: Nested set
Manipulate a tree node structure stored in MySQL
Author: By
Last change:
Date: 2009-02-16 13:31
Size: 344 bytes
 

Contents

Class file image Download 
--
-- table tree
--

CREATE TABLE IF NOT EXISTS `tree` (
  `id` int(12) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `lft` int(12) unsigned NOT NULL,
  `rgt` int(12) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `lft` (`lft`),
  KEY `rgt` (`rgt`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;