PHP Classes

File: tableStructure.sql

Recommend this page to a friend!
  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: 15 years ago
Size: 344 bytes


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 ;