Skip to content

Instantly share code, notes, and snippets.

@camwest
Created June 11, 2010 14:31
Show Gist options
  • Select an option

  • Save camwest/434538 to your computer and use it in GitHub Desktop.

Select an option

Save camwest/434538 to your computer and use it in GitHub Desktop.
+--------------------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+-------------------+
| 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 |
+--------------------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+-------------------+
| access_rights | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 0 | 89 | 2010-02-25 14:04:01 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
| accounts | MyISAM | 10 | Dynamic | 22 | 74 | 1644 | 281474976710655 | 6144 | 0 | 78 | 2010-04-15 11:33:02 | 2010-06-10 13:12:37 | NULL | utf8_general_ci | NULL | | |
| accounts_roles | MyISAM | 10 | Fixed | 1 | 25 | 25 | 7036874417766399 | 2048 | 0 | NULL | 2009-11-05 16:42:19 | 2009-11-05 16:42:22 | 2009-11-05 16:42:19 | utf8_general_ci | NULL | | |
| categories | MyISAM | 10 | Dynamic | 14 | 48 | 824 | 281474976710655 | 3072 | 152 | 79 | 2009-11-18 12:48:35 | 2010-06-10 12:19:29 | NULL | utf8_general_ci | NULL | | |
| categorizations | InnoDB | 10 | Compact | 18 | 910 | 16384 | 0 | 49152 | 0 | 76 | 2010-05-27 08:23:12 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
| channels | MyISAM | 10 | Dynamic | 40 | 57 | 2292 | 281474976710655 | 3072 | 0 | 151 | 2010-05-27 08:23:12 | 2010-06-03 13:48:11 | NULL | utf8_general_ci | NULL | | |
| completions | InnoDB | 10 | Compact | 147 | 111 | 16384 | 0 | 16384 | 0 | 167 | 2009-11-09 13:56:43 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
| courses | MyISAM | 10 | Dynamic | 4 | 94 | 376 | 281474976710655 | 3072 | 0 | 53 | 2010-05-27 08:23:12 | 2010-06-10 13:16:19 | NULL | utf8_general_ci | NULL | | |
| groups | MyISAM | 10 | Dynamic | 24 | 26 | 632 | 281474976710655 | 3072 | 0 | 69 | 2009-11-05 16:42:20 | 2010-05-27 11:21:57 | 2009-11-05 16:42:20 | utf8_general_ci | NULL | | |
| memberships | MyISAM | 10 | Fixed | 13 | 13 | 299 | 3659174697238527 | 4096 | 130 | 121 | 2009-11-05 16:42:20 | 2010-05-13 11:56:42 | 2009-11-05 16:42:20 | utf8_general_ci | NULL | | |
| package_selections | MyISAM | 10 | Dynamic | 5 | 61 | 1184 | 281474976710655 | 3072 | 876 | 152 | 2009-11-12 13:37:55 | 2010-06-02 08:24:17 | 2009-11-12 13:37:55 | utf8_general_ci | NULL | | |
| packages | MyISAM | 10 | Dynamic | 3 | 85 | 1148 | 281474976710655 | 2048 | 892 | 62 | 2010-03-25 12:47:29 | 2010-05-06 13:49:17 | NULL | utf8_general_ci | NULL | | |
| partnerships | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 0 | 4 | 2010-06-10 11:44:21 | NULL | NULL | utf8_general_ci | NULL | | InnoDB free: 0 kB |
| roles | MyISAM | 10 | Dynamic | 25 | 50 | 1264 | 281474976710655 | 7168 | 0 | 110 | 2009-11-05 16:42:21 | 2010-06-10 11:16:08 | 2009-11-05 16:42:21 | utf8_general_ci | NULL | | |
| roles_users | MyISAM | 10 | Fixed | 23 | 25 | 575 | 7036874417766399 | 4096 | 0 | NULL | 2009-11-05 16:42:21 | 2010-06-10 11:16:08 | 2009-11-05 16:42:21 | utf8_general_ci | NULL | | |
| schema_migrations | MyISAM | 10 | Dynamic | 86 | 20 | 1720 | 281474976710655 | 5120 | 0 | NULL | 2009-11-05 16:18:44 | 2010-06-10 11:44:21 | NULL | utf8_general_ci | NULL | | |
| subscriptions | MyISAM | 10 | Fixed | 22 | 40 | 880 | 11258999068426239 | 4096 | 0 | 1042160663 | 2010-04-15 11:33:02 | 2010-06-10 13:20:23 | NULL | utf8_general_ci | NULL | | |
| supplement_types | MyISAM | 10 | Dynamic | 2 | 58 | 492 | 281474976710655 | 3072 | 376 | 22 | 2009-11-05 16:42:21 | 2010-05-06 13:43:03 | 2009-11-05 16:42:21 | utf8_general_ci | NULL | | |
| supplements | MyISAM | 10 | Dynamic | 0 | 0 | 440 | 281474976710655 | 4096 | 440 | 41 | 2010-01-14 13:15:24 | 2010-05-06 13:43:03 | 2010-01-14 13:15:24 | utf8_general_ci | NULL | | |
| units | MyISAM | 10 | Dynamic | 5 | 58 | 928 | 281474976710655 | 4096 | 636 | 104 | 2009-11-05 16:42:22 | 2010-05-27 13:49:25 | 2009-11-05 16:42:22 | utf8_general_ci | NULL | | |
| users | MyISAM | 10 | Dynamic | 35 | 425 | 14900 | 281474976710655 | 3072 | 0 | 180 | 2009-11-05 16:42:22 | 2010-06-10 13:20:54 | 2009-11-05 16:42:22 | utf8_general_ci | NULL | | |
| viewables | MyISAM | 10 | Dynamic | 28 | 119 | 7408 | 281474976710655 | 4096 | 4068 | 550 | 2010-01-29 11:44:59 | 2010-06-03 11:27:49 | NULL | utf8_general_ci | NULL | | |
| viewings | MyISAM | 10 | Fixed | 6 | 31 | 186 | 8725724278030335 | 5120 | 0 | 554 | 2010-05-10 14:11:03 | 2010-06-07 08:16:15 | NULL | utf8_general_ci | NULL | | |
+--------------------+--------+---------+------------+------+----------------+-------------+-------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+-------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment