#
# Table structure for table 'comments'
#
CREATE TABLE comments (
  Id int(11) DEFAULT 0 NOT NULL,
  CommentDate int(11) DEFAULT 0 NOT NULL,
  Commenter varchar(13) DEFAULT '' NOT NULL,
  Comment text NOT NULL,
  KEY Id (Id)
);

#
# Table structure for table 'errors'
#
CREATE TABLE errors (
  Id int(11) DEFAULT 0 NOT NULL auto_increment,
  DirEntryDate int(11) DEFAULT 0 NOT NULL,
  EntryDate int(11) DEFAULT 0 NOT NULL,
  FixDate int(11),
  Directory varchar(150) DEFAULT '' NOT NULL,
  Filename varchar(100) DEFAULT '' NOT NULL,
  Category enum('ROOM','OBJECT','RITUAL','SPELL','HELP','COMMAND','GENERAL') DEFAULT 'ROOM' NOT NULL,
  Type enum('TYPO','BUG','IDEA') DEFAULT 'BUG' NOT NULL,
  Name varchar(255) DEFAULT '',
  Reporter varchar(13) DEFAULT '' NOT NULL,
  Fixer varchar(13),
  Status enum('OPEN','FIXING','CONSIDERING','DENIED','FIXED') DEFAULT 'OPEN' NOT NULL,
  Report text,
  Runtime text,
  PRIMARY KEY (Id),
  KEY Type (Type),
  KEY Status (Status),
  KEY Filename (Filename),
  KEY Directory (Directory)
);


# Table structure for table 'forwards'
#
CREATE TABLE forwards (
  Id int(11) DEFAULT 0 NOT NULL,
  ForwardDate int(11) DEFAULT 0 NOT NULL,
  Forwarder varchar(13) DEFAULT '' NOT NULL,
  OldDirectory varchar(150) DEFAULT '' NOT NULL,
  KEY Id (Id)
);
