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


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;