Re: temp table or query for API
Posted by: Stephen Strickland
Date: June 01, 2013 01:39PM

mysql> show table status part two
    -> ;
+------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+
| 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                                                      |
+------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+
                 |
| field_data_field_required_plugin         | InnoDB |      10 | Compact    |    637 |            102 |       65536 |               0 |       147456 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 21 (field_required_plugin)            |
| field_data_field_resolution              | InnoDB |      10 | Compact    |    526 |            124 |       65536 |               0 |       147456 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 10 (field_resolution)                 |
| field_data_field_revision_date           | InnoDB |      10 | Compact    |     43 |            381 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 80 (field_revision_date)              |
| field_data_field_router                  | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 70 (field_router)                     |
| field_data_field_site_url                | InnoDB |      10 | Compact    |    391 |            167 |       65536 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 7 (field_site_url)                    |
| field_data_field_slink                   | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 93 (field_slink)                      |
| field_data_field_smartphone              | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 71 (field_smartphone)                 |
| field_data_field_source                  | InnoDB |      10 | Compact    |    614 |            106 |       65536 |               0 |       147456 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 12 (field_source)                     |
| field_data_field_source_image            | InnoDB |      10 | Compact    |      3 |           5461 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 25 (field_source_image)               |
| field_data_field_source_location         | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 84 (field_source_location)            |
| field_data_field_summary                 | InnoDB |      10 | Compact    |     29 |           1694 |       49152 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 32 (field_summary)                    |
| field_data_field_tablet                  | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 72 (field_tablet)                     |
| field_data_field_tags                    | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 3 (field_tags)                        |
| field_data_field_television              | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 69 (field_television)                 |
| field_data_field_test                    | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 60 (field_test)                       |
| field_data_field_thumbnail               | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 22 (field_thumbnail)                  |
| field_data_field_version                 | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 79 (field_version)                    |
| field_data_meta_description              | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 28 (meta_description)                 |
| field_data_meta_keywords                 | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 29 (meta_keywords)                    |
| field_data_meta_revisit_after            | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 30 (meta_revisit_after)               |
| field_data_paypal_donate_currency        | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 95 (paypal_donate_currency)           |
| field_data_paypal_donate_email           | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 94 (paypal_donate_email)              |
| field_data_support_ticket_upload         | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-20 22:06:15 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 113 (support_ticket_upload)           |
| field_data_taxonomy_forums               | InnoDB |      10 | Compact    |      8 |           2048 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 5 (taxonomy_forums)                   |
| field_data_title_field                   | InnoDB |      10 | Compact    |     80 |            204 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Data storage for field 56 (title_field)                      |
| field_revision_body                      | InnoDB |      10 | Compact    |    129 |            889 |      114688 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 2 (body)                  |
| field_revision_comment_body              | InnoDB |      10 | Compact    |      9 |           1820 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 1 (comment_body)          |
| field_revision_field_ad_category         | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:31 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 103 (field_ad_category)   |
| field_revision_field_ad_end_date         | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:32 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 105 (field_ad_end_date)   |
| field_revision_field_ad_flash            | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:31 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 100 (field_ad_flash)      |
| field_revision_field_ad_image            | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:31 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 99 (field_ad_image)       |
| field_revision_field_ad_start_date       | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:32 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 104 (field_ad_start_date) |
| field_revision_field_ad_status           | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:32 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 107 (field_ad_status)     |
| field_revision_field_ad_text             | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:31 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 101 (field_ad_text)       |
| field_revision_field_ad_type             | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:30 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 98 (field_ad_type)        |
| field_revision_field_ad_url              | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:31 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 102 (field_ad_url)        |
| field_revision_field_ad_url_taget        | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-10 23:01:32 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 106 (field_ad_url_taget)  |
| field_revision_field_amazon_link         | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-16 19:36:42 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 112 (field_amazon_link)   |
| field_revision_field_audio_player        | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 73 (field_audio_player)   |
| field_revision_field_author              | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 75 (field_author)         |
| field_revision_field_blu_ray             | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 68 (field_blu_ray)        |
| field_revision_field_compatibility_links | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 91 (field...              |
| field_revision_field_description         | InnoDB |      10 | Compact    |    350 |            468 |      163840 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 6 (field_description)     |
| field_revision_field_device_manufacture  | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 90 (field_device...       |
| field_revision_field_device_type         | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 89 (field_device_type)    |
| field_revision_field_file                | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 27 (field_file)           |
| field_revision_field_icon                | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 26 (field_icon)           |
| field_revision_field_iframe              | InnoDB |      10 | Compact    |     10 |           1638 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 57 (field_iframe)         |
| field_revision_field_image               | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 4 (field_image)           |
| field_revision_field_image_1             | InnoDB |      10 | Compact    |      2 |           8192 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-06-01 07:50:02 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 114 (field_image_1)       |
| field_revision_field_information         | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 31 (field_information)    |
| field_revision_field_installs            | InnoDB |      10 | Compact    |    722 |             90 |       65536 |               0 |       294912 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 17 (field_installs)       |
| field_revision_field_language            | InnoDB |      10 | Compact    |    740 |             88 |       65536 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 11 (field_language)       |
| field_revision_field_media_count         | InnoDB |      10 | Compact    |     41 |            399 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 97 (field_media_count)    |
| field_revision_field_media_image         | InnoDB |      10 | Compact    |      3 |           5461 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 24 (field_media_image)    |
| field_revision_field_media_link          | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 88 (field_media_link)     |
| field_revision_field_media_streamer      | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 74 (field_media_streamer) |
| field_revision_field_media_type          | InnoDB |      10 | Compact    |    679 |             96 |       65536 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 13 (field_media_type)     |
| field_revision_field_media_url           | InnoDB |      10 | Compact    |    565 |            260 |      147456 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 8 (field_media_url)       |
| field_revision_field_media_url_temp      | InnoDB |      10 | Compact    |    197 |            249 |       49152 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 8 (field_media_url)       |
| field_revision_field_name                | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 19 (field_name)           |
| field_revision_field_plugin_instructions | InnoDB |      10 | Compact    |     42 |            390 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 85 (field_plugin...       |
| field_revision_field_plugin_links        | InnoDB |      10 | Compact    |     43 |            381 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 86 (field_plugin_links)   |
| field_revision_field_plugin_logo         | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 82 (field_plugin_logo)    |
| field_revision_field_plugin_rating       | InnoDB |      10 | Compact    |      4 |           4096 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 81 (field_plugin_rating)  |
| field_revision_field_plugin_status       | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 83 (field_plugin_status)  |
| field_revision_field_plugin_tyle         | InnoDB |      10 | Compact    |     43 |            381 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 77 (field_plugin_tyle)    |
| field_revision_field_plugin_website      | InnoDB |      10 | Compact    |     43 |            381 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 78 (field_plugin_website) |
| field_revision_field_plugins             | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 20 (field_plugins)        |
| field_revision_field_quality             | InnoDB |      10 | Compact    |      2 |           8192 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 14 (field_quality)        |
| field_revision_field_region              | InnoDB |      10 | Compact    |    710 |             92 |       65536 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 9 (field_region)          |
| field_revision_field_region_image        | InnoDB |      10 | Compact    |      4 |           4096 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 23 (field_region_image)   |
| field_revision_field_reliability         | InnoDB |      10 | Compact    |      2 |           8192 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 15 (field_reliability)    |
| field_revision_field_required_plugin     | InnoDB |      10 | Compact    |    596 |            109 |       65536 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 21 (field_required...     |
| field_revision_field_resolution          | InnoDB |      10 | Compact    |    701 |             93 |       65536 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 10 (field_resolution)     |
| field_revision_field_revision_date       | InnoDB |      10 | Compact    |     43 |            381 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 80 (field_revision_date)  |
| field_revision_field_router              | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 70 (field_router)         |
| field_revision_field_site_url            | InnoDB |      10 | Compact    |    850 |            134 |      114688 |               0 |       147456 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 7 (field_site_url)        |
| field_revision_field_slink               | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 93 (field_slink)          |
| field_revision_field_smartphone          | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 71 (field_smartphone)     |
| field_revision_field_source              | InnoDB |      10 | Compact    |    602 |            108 |       65536 |               0 |       344064 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 12 (field_source)         |
| field_revision_field_source_image        | InnoDB |      10 | Compact    |      3 |           5461 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 25 (field_source_image)   |
| field_revision_field_source_location     | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 84 (field_source...       |
| field_revision_field_summary             | InnoDB |      10 | Compact    |     15 |           3276 |       49152 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 32 (field_summary)        |
| field_revision_field_tablet              | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 72 (field_tablet)         |
| field_revision_field_tags                | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 3 (field_tags)            |
| field_revision_field_television          | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 69 (field_television)     |
| field_revision_field_test                | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 60 (field_test)           |
| field_revision_field_thumbnail           | InnoDB |      10 | Compact    |      7 |           2340 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 22 (field_thumbnail)      |
| field_revision_field_version             | InnoDB |      10 | Compact    |     44 |            372 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 79 (field_version)        |
| field_revision_meta_description          | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 28 (meta_description)     |
| field_revision_meta_keywords             | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 29 (meta_keywords)        |
| field_revision_meta_revisit_after        | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        98304 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 30 (meta_revisit_after)   |
| field_revision_paypal_donate_currency    | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 95 (paypal_donate...      |
| field_revision_paypal_donate_email       | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 94 (paypal_donate_email)  |
| field_revision_support_ticket_upload     | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-05-20 22:06:15 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 113 (support_ticket...    |
| field_revision_taxonomy_forums           | InnoDB |      10 | Compact    |      8 |           2048 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 5 (taxonomy_forums)       |
| field_revision_title_field               | InnoDB |      10 | Compact    |     80 |            204 |       16384 |               0 |       114688 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Revision archive storage for field 56 (title_field)          |
| field_validation_rule                    | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        16384 | 1722810368 |              1 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Stores rule definitions                                      |
| file_managed                             | InnoDB |      10 | Compact    |    113 |            434 |       49152 |               0 |        81920 | 1722810368 |            189 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Stores information for uploaded files.                       |
| file_usage                               | InnoDB |      10 | Compact    |    126 |            130 |       16384 |               0 |        49152 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Track where a file is used.                                  |
| filter                                   | InnoDB |      10 | Compact    |     96 |            853 |       81920 |               0 |        16384 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Table that maps filters (HTML corrector) to text formats ... |
| filter_format                            | InnoDB |      10 | Compact    |      9 |           1820 |       16384 |               0 |        32768 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Stores text formats: custom groupings of filters, such as... |
| flag_actions                             | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |            0 | 1722810368 |              1 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                |                                                              |
| flag_content                             | InnoDB |      10 | Compact    |      9 |           1820 |       16384 |               0 |        65536 | 1722810368 |            391 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Content that has been flagged.                               |
| flag_counts                              | InnoDB |      10 | Compact    |      8 |           2048 |       16384 |               0 |        65536 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | The number of times an item has been flagged.                |
| flag_types                               | InnoDB |      10 | Compact    |      2 |           8192 |       16384 |               0 |        16384 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | The types (usually as defined in node_type) that are...      |
| flags                                    | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |        16384 | 1722810368 |              2 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | All available flags in the system.                           |
| flood                                    | InnoDB |      10 | Compact    |      2 |           8192 |       16384 |               0 |        32768 | 1722810368 |           4031 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Flood controls the threshold of events, such as the...       |
| formatters                               | InnoDB |      10 | Compact    |      1 |          16384 |       16384 |               0 |            0 | 1722810368 |           NULL | 2013-05-14 20:40:04 | NULL                | NULL       | utf8_general_ci   |     NULL |                |                                                              |
| forum                                    | InnoDB |      10 | Compact    |      8 |           2048 |       16384 |               0 |        32768 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Stores the relationship of nodes to forum terms.             |
| forum_index                              | InnoDB |      10 | Compact    |      4 |           4096 |       16384 |               0 |        49152 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Maintains denormalized information about node/term...        |
| history                                  | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        16384 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | A record of which users have read which nodes.               |
| i18n_block_language                      | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        16384 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Sets block visibility based on language                      |
| i18n_string                              | InnoDB |      10 | Compact    |    489 |            167 |       81920 |               0 |        49152 | 1722810368 |           NULL | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Metadata for source strings.                                 |
| i18n_translation_set                     | InnoDB |      10 | Compact    |      3 |           5461 |       16384 |               0 |        16384 | 1722810368 |              4 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Translation set.                                             |
| image_effects                            | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        32768 | 1722810368 |              1 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Stores configuration options for image effects.              |
| image_styles                             | InnoDB |      10 | Compact    |      0 |              0 |       16384 |               0 |        16384 | 1722810368 |              1 | 2013-04-29 23:14:14 | NULL                | NULL       | utf8_general_ci   |     NULL |                | Stores configuration options for image styles.               |
| install_counts                           | NULL   |    NULL | NULL       |   NULL |           NULL |        NULL |            NULL |         NULL |       NULL |           NULL | NULL                | NULL                | NULL       | NULL              |     NULL | NULL           | VIEW                                                         |

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.