All pastes #750442 Raw Edit

Stuff

public text v1 · immutable
#750442 ·published 2007-10-26 14:46 UTC
rendered paste body
DROP TABLE IF EXISTS `wp_comments`;

CREATE TABLE `wp_comments` (

  `comment_ID` bigint(20) unsigned NOT NULL auto_increment,

  `comment_post_ID` int(11) NOT NULL default '0',

  `comment_author` tinytext character set cp1250 collate cp1250_czech_cs NOT NUL

L,

  `comment_author_email` varchar(100) character set cp1250 collate cp1250_czech_

cs NOT NULL default '',

  `comment_author_url` varchar(200) character set cp1250 collate cp1250_czech_cs

 NOT NULL default '',

  `comment_author_IP` varchar(100) character set cp1250 collate cp1250_czech_cs 

NOT NULL default '',

  `comment_date` datetime NOT NULL default '0000-00-00 00:00:00',

  `comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',

  `comment_content` text character set cp1250 collate cp1250_czech_cs NOT NULL,

  `comment_karma` int(11) NOT NULL default '0',

  `comment_approved` enum('0','1','spam') character set cp1250 collate cp1250_cz

ech_cs NOT NULL default '1',

  `comment_agent` varchar(255) character set cp1250 collate cp1250_czech_cs NOT 

NULL default '',

  `comment_type` varchar(20) character set cp1250 collate cp1250_czech_cs NOT NU

LL default '',

  `comment_parent` bigint(20) NOT NULL default '0',

  `user_id` bigint(20) NOT NULL default '0',

  PRIMARY KEY  (`comment_ID`),

  KEY `comment_approved` (`comment_approved`),

  KEY `comment_post_ID` (`comment_post_ID`)

) ENGINE=MyISAM AUTO_INCREMENT=824 DEFAULT CHARSET=utf8;