nicholas

CREATE TABLE `pastebin` (
      `pid` int(11) NOT NULL auto_increment,
      `poster` varchar(16) default NULL,
      `posted` datetime default NULL,
      `code` text,
      `parent_pid` int(11) default '0',
      `format` varchar(16) default NULL,
      `codefmt` mediumtext,
      `codecss` text,
      `domain` varchar(255) default '',
      `expires` DATETIME,
      `expiry_flag` ENUM('d','m', 'f') NOT NULL DEFAULT 'm',

      PRIMARY KEY  (`pid`),
      KEY `domain` (`domain`),
      KEY (`parent_pid`),
      KEY (`expires`)
    );

create table recent
(
    domain varchar(255),
    pid int not null,
    seq_no int not null,

    primary key(domain,seq_no)
);