Re: temp table or query for API
Posted by: Stephen Strickland
Date: June 01, 2013 01:36PM
Date: June 01, 2013 01:36PM
mysql> show table status -> ; +------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+ | 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 | +------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+ | API_by_Country | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | Media_temp | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | Plugin_Type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | accesslog | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores site access information for statistics. | | actions | InnoDB | 10 | Compact | 23 | 712 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores action information. | | amazon_book | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-11 11:42:28 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_dvd | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-11 11:42:28 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_item | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-11 11:42:26 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_item_editorial_review | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-05-11 11:42:26 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_item_image | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-05-11 11:42:26 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_item_node | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 1722810368 | NULL | 2013-05-11 11:42:26 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_item_participant | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-05-11 11:42:26 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_music | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-11 11:42:28 | NULL | NULL | utf8_general_ci | NULL | | | | amazon_software | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-11 11:42:28 | NULL | NULL | utf8_general_ci | NULL | | | | api_access | InnoDB | 10 | Compact | 21912 | 120 | 2637824 | 0 | 0 | 1722810368 | 31251 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | api_install | InnoDB | 10 | Compact | 8307 | 51 | 425984 | 0 | 0 | 1722810368 | 11600 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | api_install_counts | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | api_install_table_create | 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 22 (field_region) | | api_install_vid | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | api_votes | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | authmap | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores distributed authentication mapping. | | batch | InnoDB | 10 | Compact | 1 | 49152 | 49152 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores details about batches (processes that run in... | | block | InnoDB | 10 | Compact | 345 | 189 | 65536 | 0 | 32768 | 1722810368 | 408 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores block settings, such as region and visibility... | | block_custom | InnoDB | 10 | Compact | 18 | 910 | 16384 | 0 | 16384 | 1722810368 | 21 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores contents of custom-made blocks. | | block_node_type | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Sets up display criteria for blocks based on content types | | block_role | InnoDB | 10 | Compact | 14 | 1170 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Sets up access permissions for blocks based on user roles | | blocked_ips | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores blocked IP addresses. | | cache | MyISAM | 10 | Dynamic | 11 | 34134 | 375480 | 281474976710655 | 9216 | 0 | NULL | 2013-01-07 23:00:16 | 2013-01-07 23:00:18 | NULL | utf8_general_ci | NULL | | Generic cache table for caching things not separated out... | | cache_admin_menu | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for Administration menu to store client-side... | | cache_block | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the Block module to store already built... | | cache_bootstrap | InnoDB | 10 | Compact | 17 | 8673 | 147456 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for data required to bootstrap Drupal, may be... | | cache_control_allow_cache | InnoDB | 10 | Compact | 13 | 1260 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Table for router paths that may be cached by the client | | cache_control_page_component | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | User-specific components for a cached page | | cache_control_rebuild_form | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Forms that may require dynamic rebuilding at some point... | | cache_field | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Generic cache table for caching things not separated out... | | cache_filter | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the Filter module to store already... | | cache_form | InnoDB | 10 | Compact | 2686 | 12949 | 34783232 | 0 | 1064960 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the form system to store recently built... | | cache_htmlpurifier | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the HTML Purifier module just like cache... | | cache_image | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table used to store information about image... | | cache_l10n_update | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the Localization Update module to store... | | cache_libraries | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table to store library information. | | cache_menu | InnoDB | 10 | Compact | 25 | 8519 | 212992 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the menu system to store router... | | cache_metatag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the generated meta tag output. | | cache_page | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table used to store compressed pages for anonymous... | | cache_path | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for path alias lookup. | | cache_performance_hacks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table used by performance hacks module, mainly... | | cache_rules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the rules engine to store configured items. | | cache_shadow | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the shadow module. | | cache_tmgmt | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Generic cache table for caching things not separated out... | | cache_token | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for token information. | | cache_update | InnoDB | 10 | Compact | 169 | 8434 | 1425408 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for the Update module to store information... | | cache_variable | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for variables. | | cache_views | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Generic cache table for caching things not separated out... | | cache_views_data | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Cache table for views to store pre-rendered queries,... | | captcha_points | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | This table describes which challenges should be added to... | | captcha_sessions | InnoDB | 10 | Compact | 677 | 242 | 163840 | 0 | 49152 | 1722810368 | 19712 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores the data about CAPTCHA sessions (solution, IP... | | comment | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 98304 | 1722810368 | 10 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores comments and associated data. | | contact | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 1722810368 | 2 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Contact form category settings. | | context | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Storage for normal (user-defined) contexts. | | continents | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | latin1_swedish_ci | NULL | | | | counter | InnoDB | 10 | Compact | 7241 | 219 | 1589248 | 0 | 507904 | 1722810368 | 7199 | 2013-05-06 22:00:38 | NULL | NULL | utf8_general_ci | NULL | | | | counter_data | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-06 22:00:38 | NULL | NULL | utf8_general_ci | NULL | | | | countries | InnoDB | 10 | Compact | 249 | 65 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | latin1_swedish_ci | NULL | | | | country | InnoDB | 10 | Compact | 248 | 66 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | latin1_swedish_ci | NULL | | | | ctools_css_cache | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A special cache used to store CSS that must be non-volatile. | | ctools_object_cache | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A special cache used to store objects that are being... | | data_table_node | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Relate data records to nodes | | data_tables | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Tables managed by Data module. | | date_format_locale | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores configured date formats for each locale. | | date_format_type | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores configured date format types. | | date_formats | InnoDB | 10 | Compact | 36 | 455 | 16384 | 0 | 16384 | 1722810368 | 37 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores configured date formats. | | ds_field_settings | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The table that holds Display Suite field settings per... | | ds_fields | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The table that holds custom fields managed by Display Suite. | | ds_layout_settings | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 49152 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The table that holds the layouts configuration. | | ds_view_modes | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The table that holds custom view modes managed by Display... | | entity_translation | InnoDB | 10 | Compact | 85 | 192 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Table to track entity translations | | entity_translation_upgrade_history | InnoDB | 10 | Compact | 20 | 819 | 16384 | 0 | 32768 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The history table for node translations. | | feeds_importer | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Configuration of feeds objects. | | feeds_item | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Tracks items such as nodes, terms, users. | | feeds_log | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 81920 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Table that contains logs of feeds events. | | feeds_push_subscriptions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | PubSubHubbub subscriptions. | | feeds_source | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 49152 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Source definitions for feeds. | | field_config | InnoDB | 10 | Compact | 71 | 1615 | 114688 | 0 | 131072 | 1722810368 | 115 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | field_config_instance | InnoDB | 10 | Compact | 145 | 1016 | 147456 | 0 | 32768 | 1722810368 | 231 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | field_data_body | InnoDB | 10 | Compact | 82 | 1398 | 114688 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 2 (body) | | field_data_comment_body | InnoDB | 10 | Compact | 9 | 1820 | 16384 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 1 (comment_body) | | field_data_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 | | Data storage for field 103 (field_ad_category) | | field_data_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 | | Data storage for field 105 (field_ad_end_date) | | field_data_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 | | Data storage for field 100 (field_ad_flash) | | field_data_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 | | Data storage for field 99 (field_ad_image) | | field_data_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 | | Data storage for field 104 (field_ad_start_date) | | field_data_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 | | Data storage for field 107 (field_ad_status) | | field_data_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 | | Data storage for field 101 (field_ad_text) | | field_data_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 | | Data storage for field 98 (field_ad_type) | | field_data_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 | | Data storage for field 102 (field_ad_url) | | field_data_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 | | Data storage for field 106 (field_ad_url_taget) | | field_data_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 | | Data storage for field 112 (field_amazon_link) | | field_data_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 | | Data storage for field 73 (field_audio_player) | | field_data_field_author | InnoDB | 10 | Compact | 44 | 372 | 16384 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 75 (field_author) | | field_data_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 | | Data storage for field 68 (field_blu_ray) | | field_data_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 | | Data storage for field 91 (field_compatibility_links) | | field_data_field_description | InnoDB | 10 | Compact | 181 | 543 | 98304 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 6 (field_description) | | field_data_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 | | Data storage for field 90 (field_device_manufacture) | | field_data_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 | | Data storage for field 89 (field_device_type) | | field_data_field_file | 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 27 (field_file) | | field_data_field_icon | 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 26 (field_icon) | | field_data_field_iframe | InnoDB | 10 | Compact | 10 | 1638 | 16384 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 57 (field_iframe) | | field_data_field_image | 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 4 (field_image) | | field_data_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 | | Data storage for field 114 (field_image_1) | | field_data_field_information | 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 31 (field_information) | | field_data_field_installs | InnoDB | 10 | Compact | 364 | 180 | 65536 | 0 | 131072 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 17 (field_installs) | | field_data_field_language | InnoDB | 10 | Compact | 502 | 130 | 65536 | 0 | 147456 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 11 (field_language) | | field_data_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 | | Data storage for field 97 (field_media_count) | | field_data_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 | | Data storage for field 24 (field_media_image) | | field_data_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 | | Data storage for field 88 (field_media_link) | | field_data_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 | | Data storage for field 74 (field_media_streamer) | | field_data_field_media_type | InnoDB | 10 | Compact | 527 | 124 | 65536 | 0 | 147456 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 13 (field_media_type) | | field_data_field_media_url | InnoDB | 10 | Compact | 543 | 181 | 98304 | 0 | 147456 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 8 (field_media_url) | | field_data_field_name | InnoDB | 10 | Compact | 44 | 372 | 16384 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 19 (field_name) | | field_data_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 | | Data storage for field 85 (field_plugin_instructions) | | field_data_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 | | Data storage for field 86 (field_plugin_links) | | field_data_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 | | Data storage for field 82 (field_plugin_logo) | | field_data_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 | | Data storage for field 81 (field_plugin_rating) | | field_data_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 | | Data storage for field 83 (field_plugin_status) | | field_data_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 | | Data storage for field 77 (field_plugin_tyle) | | field_data_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 | | Data storage for field 78 (field_plugin_website) | | field_data_field_plugins | InnoDB | 10 | Compact | 44 | 372 | 16384 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 20 (field_plugins) | | field_data_field_quality | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 98304 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 14 (field_quality) | | field_data_field_region | InnoDB | 10 | Compact | 550 | 119 | 65536 | 0 | 147456 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 9 (field_region) | | field_data_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 | | Data storage for field 23 (field_region_image) | | field_data_field_reliability | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 98304 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Data storage for field 15 (field_reliability)
Subject
Written By
Posted
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.