deptrack/deptrack.sql

   1 #
   2 # Table structure for table `dep`
   3 #
   4
   5 CREATE TABLE dep (
   6   id int(8) NOT NULL auto_increment,
   7   dir int(6) NOT NULL default '0',
   8   page int(6) NOT NULL default '0',
   9   dep int(6) NOT NULL default '0',
  10   type enum('include','image','link') NOT NULL default 'include',
  11   PRIMARY KEY  (id)
  12 ) TYPE=MyISAM;
  13 # --------------------------------------------------------
  14
  15 #
  16 # Table structure for table `dir`
  17 #
  18
  19 CREATE TABLE dir (
  20   id int(6) NOT NULL auto_increment,
  21   path varchar(255) NOT NULL default '',
  22   PRIMARY KEY  (id),
  23   UNIQUE KEY path (path)
  24 ) TYPE=MyISAM;
  25 # --------------------------------------------------------
  26
  27 #
  28 # Table structure for table `file`
  29 #
  30
  31 CREATE TABLE file (
  32   id int(6) NOT NULL auto_increment,
  33   path varchar(255) NOT NULL default '',
  34   type enum('dead','page','include','image') NOT NULL default 'dead',
  35   dir int(6) NOT NULL default '0',
  36   PRIMARY KEY  (id),
  37   UNIQUE KEY path (path)
  38 ) TYPE=MyISAM;
  39