PHP Classes

File: adjacency_demo.sql

Recommend this page to a friend!
  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: 14 years ago
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;