Anonymous

CREATE TABLE `Ueland`.`pastebin` (
`pid` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`poster` VARCHAR( 16 ) NOT NULL ,
`posted` DATE NOT NULL ,
`code` TEXT NOT NULL ,
`parent_id` INT( 11 ) NOT NULL DEFAULT '0',
`format` VARCHAR( 16 ) NOT NULL ,
`codefmt` MEDIUMTEXT NOT NULL ,
`codecss` TEXT NOT NULL ,
`domain` VARCHAR( 255 ) NOT NULL ,
`expires` DATETIME NOT NULL ,
`expiry_flag``` ENUM( 'd', 'm', 'f' ) NOT NULL DEFAULT 'm',
PRIMARY KEY ( `pid` ) ,
INDEX ( `parent_id` , `expires` ) 
) ENGINE = MYISAM