# # 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) );