mysql> SHOW CREATE TABLE users;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| users | CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `crypted_password` varchar(40) default NULL,
  `salt` varchar(40) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `remember_token` varchar(255) default NULL,
  `remember_token_expires_at` datetime default NULL,
  `activation_code` varchar(40) default NULL,
  `activated_at` datetime default NULL,
  `state` varchar(255) default 'passive',
  `deleted_at` datetime default NULL,
  `password_reset_code` varchar(40) default NULL,
  `guid` varchar(36) default NULL,
  `kart_id` int(11) default NULL,
  `primary_address_id` int(11) default NULL,
  `tos_ok` tinyint(1) default '0',
  `generate_mail_at` datetime default NULL,
  `signup_image_id` int(11) default NULL,
  `ip` varchar(15) default NULL,
  `cancelled_invites_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `index_users_on_guid` (`guid`),
  UNIQUE KEY `index_users_on_primary_address_id` (`primary_address_id`),
  UNIQUE KEY `index_users_on_email` (`email`),
  UNIQUE KEY `index_users_on_password_reset_code` (`password_reset_code`),
  UNIQUE KEY `index_users_on_remember_token` (`remember_token`),
  KEY `index_users_on_kart_id` (`kart_id`),
  KEY `index_users_on_generate_mail_at` (`generate_mail_at`),
  KEY `index_users_on_created_at` (`created_at`),
  KEY `index_users_on_updated_at` (`updated_at`),
  KEY `index_users_on_remember_token_expires_at` (`remember_token_expires_at`),
  KEY `index_users_on_activated_at` (`activated_at`),
  KEY `index_users_on_deleted_at` (`deleted_at`),
  KEY `index_users_on_login` (`login`),
  KEY `index_users_on_state` (`state`),
  KEY `index_users_on_signup_image_id` (`signup_image_id`),
  KEY `index_users_on_ip` (`ip`),
  KEY `index_users_on_tos_ok` (`tos_ok`),
  KEY `index_users_on_cancelled_invites_at` (`cancelled_invites_at`)
) ENGINE=InnoDB AUTO_INCREMENT=106769 DEFAULT CHARSET=utf8 |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE friendships;
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| friendships | CREATE TABLE `friendships` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `friend_id` int(11) NOT NULL,
  `created_at` datetime default NULL,
  `accepted_at` datetime default NULL,
  `requested_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `index_friendships_on_friend_id_and_user_id` (`friend_id`,`user_id`),
  UNIQUE KEY `index_friendships_on_friend_id_and_user_id_and_accepted_at` (`friend_id`,`user_id`,`accepted_at`),
  KEY `index_friendships_on_user_id` (`user_id`),
  KEY `index_friendships_on_friend_id` (`friend_id`),
  KEY `index_friendships_on_created_at` (`created_at`),
  KEY `index_friendships_on_accepted_at` (`accepted_at`),
  KEY `index_friendships_on_requested_at` (`requested_at`),
  KEY `index_friendships_on_requested_at_and_accepted_at` (`requested_at`,`accepted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=170922 DEFAULT CHARSET=utf8 |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)