mysql> show create table janberlin_posts; show table status like 'janberlin_posts'; +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | janberlin_posts |CREATE TABLE `janberlin_posts` ( `ID` bigint(20) unsigned NOT NULL auto_increment, `post_author` bigint(20) NOT NULL default '0', `post_date` datetime NOT NULL default '0000-00-00 00:00:00', `post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00', `post_content` longtext collate latin1_german2_ci NOT NULL, `post_title` text collate latin1_german2_ci NOT NULL, `post_category` int(4) NOT NULL default '0', `post_excerpt` text collate latin1_german2_ci NOT NULL, `post_status` enum('publish','draft','private','static','object','attachment') collate latin1_german2_ci NOT NULL default 'publish', `comment_status` enum('open','closed','registered_only') collate latin1_german2_ci NOT NULL default 'open', `ping_status` enum('open','closed') collate latin1_german2_ci NOT NULL default 'open', `post_password` varchar(20) collate latin1_german2_ci NOT NULL default '', `post_name` varchar(200) collate latin1_german2_ci NOT NULL default '', `to_ping` text collate latin1_german2_ci NOT NULL, `pinged` text collate latin1_german2_ci NOT NULL, `post_modified` datetime NOT NULL default '0000-00-00 00:00:00', `post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00', `post_content_filtered` text collate latin1_german2_ci NOT NULL, `post_parent` bigint(20) NOT NULL default '0', `guid` varchar(255) collate latin1_german2_ci NOT NULL default '', `menu_order` int(11) NOT NULL default '0', `post_type` varchar(100) collate latin1_german2_ci NOT NULL default '', `post_mime_type` varchar(100) collate latin1_german2_ci NOT NULL default '', `comment_count` bigint(20) NOT NULL default '0', PRIMARY KEY (`ID`), KEY `post_name` (`post_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci | +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ | janberlin_posts | MyISAM | 10 | Dynamic | 6 | 260 | 1564 | 281474976710655 | 3072 | 0 | 7 | 2006-02-17 00:50:45 | 2006-03-12 14:24:30 | 2006-05-12 03:30:37 | latin1_german2_ci | NULL | | | +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+ 1 row in set (0.01 sec) mysql>