All pastes #792038 Raw Edit

Someone

public sql v1 · immutable
·published 2007-11-21 03:18 UTC
rendered paste body
REATE 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));