mysql> SHOW CREATE TABLE blogs;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                           |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| blogs | CREATE TABLE `blogs` (
  `blog_sakey` int(11) NOT NULL auto_increment,
  `topic` varchar(255) NOT NULL default '',
  `description` text,
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `site_sakey` int(11) NOT NULL default '0',
  `email_on_reply` smallint(6) default NULL,
  PRIMARY KEY  (`blog_sakey`),
  UNIQUE KEY `UC_blog_sakey` (`blog_sakey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)