CREATE TABLE `predb`
  (
     `ID`         INT(12) NOT NULL AUTO_INCREMENT,
     `ctime`      INT(12) NOT NULL,
     `dirname`    VARCHAR(255) NOT NULL,
     `category`   VARCHAR(20) NOT NULL,
     `nuketype`   VARCHAR(20) DEFAULT '',
     `nukereason` VARCHAR(255) DEFAULT '',
     `nuketime`   INT(12) DEFAULT 0,
     `filesize`   FLOAT(12) DEFAULT 0,
     `filecount`  INT(6) DEFAULT 0,
     `filename`   VARCHAR(255) DEFAULT '',
     PRIMARY KEY (`ID`),
     UNIQUE KEY `dirname` (`dirname`)
  )
ENGINE=MYISAM
DEFAULT CHARSET=utf8;

ALTER TABLE releases ADD `pre` INT(1) DEFAULT 0 NOT NULL;
INSERT INTO site (setting, value, updateddate) VALUES ('nzprearticles', 500, now());
INSERT INTO site (setting, value, updateddate) VALUES ('nzprekey', '', now());