rendered paste bodymysql> 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)