Login   Register  
PHP Classes
elePHPant
Icontem

File: adjacency_demo.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Peter Drinnan  >  Adjacency Model  >  adjacency_demo.sql  >  Download  
File: adjacency_demo.sql
Role: Auxiliary data
Content type: text/plain
Description: Sample MySQL data table structure. Can be modified.
Class: Adjacency Model
Create and manipulate adjacency lists in MySQL
Author: By
Last change:
Date: 2010-04-18 07:17
Size: 362 bytes
 

Contents

Class file image Download 
CREATE TABLE IF NOT EXISTS `adjacency_demo_groups` (
  `ID` int(6) NOT NULL AUTO_INCREMENT,
  `parent_id` int(6) NOT NULL DEFAULT '0',
  `Group_Name` varchar(255) NOT NULL DEFAULT '',
  `Color` varchar(25) DEFAULT NULL,
  `position` int(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;