freshened up docs

[old-projects.git] / deptrack / deptrack.sql

#
# Table structure for table `dep`
#

CREATE TABLE dep (
  id int(8) NOT NULL auto_increment,
  dir int(6) NOT NULL default '0',
  page int(6) NOT NULL default '0',
  dep int(6) NOT NULL default '0',
  type enum('include','image','link') NOT NULL default 'include',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `dir`
#

CREATE TABLE dir (
  id int(6) NOT NULL auto_increment,
  path varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY path (path)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `file`
#

CREATE TABLE file (
  id int(6) NOT NULL auto_increment,
  path varchar(255) NOT NULL default '',
  type enum('dead','page','include','image') NOT NULL default 'dead',
  dir int(6) NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY path (path)
) TYPE=MyISAM;