Re: temp table or query for API
Posted by: Stephen Strickland
Date: June 01, 2013 01:40PM
Date: June 01, 2013 01:40PM
mysql> show table status part three -> ; +------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+ | 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 | +------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+ | ip2country | InnoDB | 10 | Compact | 126991 | 70 | 8929280 | 0 | 4734976 | 1722810368 | 126644 | 2013-05-16 19:54:22 | NULL | NULL | utf8_general_ci | NULL | | Association between IP range and Country | | ipaddress | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | job_schedule | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Schedule of jobs to be executed. | | l10n_update_file | InnoDB | 10 | Compact | 1084 | 453 | 491520 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | File and download information for project translations. | | l10n_update_project | InnoDB | 10 | Compact | 107 | 153 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Update information for project translations. | | language | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | languages | InnoDB | 10 | Compact | 14 | 1170 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | List of all available languages in the system. | | legal_accepted | InnoDB | 10 | Compact | 350 | 46 | 16384 | 0 | 16384 | 1722810368 | 351 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | legal_conditions | InnoDB | 10 | Compact | 1 | 32768 | 32768 | 0 | 0 | 1722810368 | 2 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | locales_source | InnoDB | 10 | Compact | 21812 | 120 | 2637824 | 0 | 1589248 | 1722810368 | 20070 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | List of English source strings. | | locales_target | InnoDB | 10 | Compact | 101831 | 159 | 16285696 | 0 | 11993088 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores translated versions of strings. | | media | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | media_resource_language | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | media_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | menu_custom | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Holds definitions for top-level custom menus (for example... | | menu_links | InnoDB | 10 | Compact | 1113 | 309 | 344064 | 0 | 376832 | 1722810368 | 8007 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Contains the individual links within a menu. | | menu_router | InnoDB | 10 | Compact | 855 | 1552 | 1327104 | 0 | 311296 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Maps paths to various callbacks (access, page and title) | | metatag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-26 22:54:02 | NULL | NULL | utf8_general_ci | NULL | | | | metatag_config | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 1722810368 | 5 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Storage of meta tag configuration and defaults. | | metatags_quick_path_based | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 1722810368 | 5 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Path based meta tags | | mollom | InnoDB | 10 | Compact | 23 | 712 | 16384 | 0 | 32768 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores Mollom responses for content. | | mollom_form | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores configuration of forms protected by Mollom. | | node | InnoDB | 10 | Compact | 684 | 191 | 131072 | 0 | 294912 | 1722810368 | 1282 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The base table for nodes. | | node_access | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Identifies which realm/grant pairs a user must possess in... | | node_comment_statistics | InnoDB | 10 | Compact | 767 | 85 | 65536 | 0 | 49152 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Maintains statistics of node and comments posts to show ... | | node_counter | InnoDB | 10 | Compact | 399 | 123 | 49152 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Access statistics for nodes. | | node_revision | InnoDB | 10 | Compact | 809 | 162 | 131072 | 0 | 114688 | 1722810368 | 1429 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about each saved version of a node. | | node_type | InnoDB | 10 | Compact | 16 | 1024 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about all defined node types. | | oauth_common_consumer | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Keys and secrets for OAuth consumers, both those provided... | | oauth_common_context | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores contexts for OAuth common | | oauth_common_nonce | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores timestamp against nonce for repeat attacks. | | oauth_common_provider_consumer | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Additional data for OAuth consumers provided by this site. | | oauth_common_provider_token | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Additional data for OAuth tokens provided by this site. | | oauth_common_token | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Tokens stored on behalf of providers or consumers for... | | page_manager_handlers | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 1722810368 | 3 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | page_manager_pages | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 1722810368 | 3 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Contains page subtasks for implementing pages with... | | page_manager_weights | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Contains override weights for page_manager handlers that... | | page_title | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | panels_display | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 1722810368 | 3 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | panels_layout | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Contains exportable customized layouts for this site. | | panels_pane | InnoDB | 10 | Compact | 9 | 1820 | 16384 | 0 | 16384 | 1722810368 | 10 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | panels_renderer_pipeline | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Contains renderer pipelines for Panels. Each pipeline... | | plugin_api_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | plugin_data | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | plugin_file | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | plugin_logo | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | plugins | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | plugins_test | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | poll | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores poll-specific information for poll nodes. | | poll_choice | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 1722810368 | 4 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about all choices for all polls. | | poll_vote | InnoDB | 10 | Compact | 39 | 420 | 16384 | 0 | 49152 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores per-users votes for each poll. | | pollim | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The base table for pollim entities. | | pollim_type | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about defined pollim types. | | pollim_vote | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The base table for pollim votes. | | property_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 | | queue | InnoDB | 10 | Compact | 37 | 1328 | 49152 | 0 | 32768 | 1722810368 | 4015 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores items in queues. | | rdf_mapping | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores custom RDF mappings for user defined content types... | | redirect | InnoDB | 10 | Compact | 58 | 282 | 16384 | 0 | 49152 | 1722810368 | 60 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information on redirects. | | regions | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | registry | InnoDB | 10 | Compact | 509 | 611 | 311296 | 0 | 114688 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Each record is a function, class, or interface name and... | | registry_file | InnoDB | 10 | Compact | 986 | 199 | 196608 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Files parsed to build the registry. | | repositoryType | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | resolution | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | role | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 32768 | 1722810368 | 6 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores user roles. | | role_permission | InnoDB | 10 | Compact | 1003 | 81 | 81920 | 0 | 49152 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores the permissions assigned to user roles. | | rules_config | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 32768 | 1722810368 | 4 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | rules_dependencies | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | rules_tags | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | rules_trigger | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | search_dataset | InnoDB | 10 | Compact | 775 | 422 | 327680 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores items that will be searched. | | search_index | InnoDB | 10 | Compact | 21940 | 102 | 2244608 | 0 | 1556480 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores the search index, associating words, items and... | | search_node_links | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores items (like nodes) that link to other nodes, used... | | search_total | InnoDB | 10 | Compact | 4916 | 49 | 245760 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores search totals for words. | | semaphore | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Table for holding semaphores, locks, flags, etc. that... | | sequences | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | 1497 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores IDs. | | sessions | InnoDB | 10 | Compact | 1087 | 331 | 360448 | 0 | 294912 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Drupalâs session handlers read and write into the... | | shadow_column | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shadow_data_1 | InnoDB | 10 | Compact | 555 | 29 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shadow_filter | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | 3 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shadow_index | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shadow_index_queue | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shadow_query | InnoDB | 10 | Compact | 29 | 1694 | 49152 | 0 | 16384 | 1722810368 | 25 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shadow_table | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 1722810368 | 3 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | shortcut_set | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about sets of shortcuts links. | | shortcut_set_users | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Maps users to shortcut sets. | | simpleads_blocks | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 1722810368 | 3 | 2013-05-10 23:01:21 | NULL | NULL | utf8_general_ci | NULL | | Stores Ad Blocks | | simpleads_clicks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | 1 | 2013-05-10 23:01:21 | NULL | NULL | utf8_general_ci | NULL | | Stores Ad Clicks | | simpleads_impressions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | 1 | 2013-05-10 23:01:21 | NULL | NULL | utf8_general_ci | NULL | | Stores Ad Impressions | | site_verify | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | support_assigned | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-05-20 22:06:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about who tickets are assigned to. | | support_client | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 1722810368 | 1 | 2013-05-20 22:06:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about support clients. | | support_plan | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-20 22:06:18 | NULL | NULL | utf8_general_ci | NULL | | Allows planning of hours required. | | support_priority | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 32768 | 1722810368 | 5 | 2013-05-20 22:06:14 | NULL | NULL | utf8_general_ci | NULL | | All available support priorities. | | support_project | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-05-20 22:06:18 | NULL | NULL | utf8_general_ci | NULL | | Assign projects to support clients. | | support_project_client | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-20 22:06:18 | NULL | NULL | utf8_general_ci | NULL | | | | support_project_ticket | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-20 22:06:18 | NULL | NULL | utf8_general_ci | NULL | | Stores which projects are assigned to tickets. | | support_reference | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-05-20 22:06:19 | NULL | NULL | utf8_general_ci | NULL | | Allow tickets to reference each other. | | support_states | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 49152 | 1722810368 | 5 | 2013-05-20 22:06:14 | NULL | NULL | utf8_general_ci | NULL | | All available support states. | | support_ticket | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | NULL | 2013-05-20 22:06:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about support tickets. | | support_ticket_comment | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-05-20 22:06:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about support ticket comments. | | system | InnoDB | 10 | Compact | 404 | 1297 | 524288 | 0 | 147456 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A list of all modules, themes, and theme engines that are... | | taxonomy_display | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Per vocabulary configuration for term pages. | | taxonomy_index | InnoDB | 10 | Compact | 3937 | 49 | 196608 | 0 | 212992 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Maintains denormalized information about node/term... | | taxonomy_menu | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Links a taxonomy term to a menu item. | | taxonomy_term_data | InnoDB | 10 | Compact | 115 | 142 | 16384 | 0 | 65536 | 1722810368 | 144 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores term information. | | taxonomy_term_hierarchy | InnoDB | 10 | Compact | 115 | 142 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores the hierarchical relationship between terms. | | taxonomy_vocabulary | InnoDB | 10 | Compact | 21 | 780 | 16384 | 0 | 32768 | 1722810368 | 27 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores vocabulary information. | | tmgmt_job | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 32768 | 1722810368 | 159 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A translation job represents a translation order that can... | | tmgmt_job_item | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 16384 | 1722810368 | 180 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A job item connects a source to a translation job. | | tmgmt_message | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A log message can be used to store events that affect a job. | | tmgmt_remote | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | TMGMT job remote mapping. | | tmgmt_translator | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 1722810368 | 4 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A translator is a combination of a translator type and... | | tmpmedia | InnoDB | 10 | Compact | 312 | 262 | 81920 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | latin1_swedish_ci | NULL | | | | tmptable | InnoDB | 10 | Compact | 269 | 304 | 81920 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | latin1_swedish_ci | NULL | | | | twitter | InnoDB | 10 | Compact | 5268 | 301 | 1589248 | 0 | 180224 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores individual Twitter posts. | | twitter_account | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information on specific Twitter user accounts. | | url_alias | InnoDB | 10 | Compact | 1047 | 109 | 114688 | 0 | 147456 | 1722810368 | 1902 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | A list of URL aliases for Drupal paths; a user may visit... | | users | InnoDB | 10 | Compact | 413 | 357 | 147456 | 0 | 131072 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores user data. | | users_roles | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Maps users to roles. | | variable | InnoDB | 10 | Compact | 460 | 14852 | 6832128 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Named variable/value pairs created by Drupal core or any... | | variable_store | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Named variable/value pairs created by modules using... | | views_calc_fields | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 1722810368 | 1 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | views_content_cache | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 147456 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores timestamps for various cache segments showing the... | | views_display | InnoDB | 10 | Compact | 58 | 5649 | 327680 | 0 | 16384 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores information about each display attached to a view. | | views_view | InnoDB | 10 | Compact | 24 | 682 | 16384 | 0 | 16384 | 1722810368 | 30 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Stores the general data for a view. | | votingapi_cache | InnoDB | 10 | Compact | 10 | 1638 | 16384 | 0 | 81920 | 1722810368 | 37 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | votingapi_vote | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 65536 | 1722810368 | 10 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | watchdog | InnoDB | 10 | Compact | 1013 | 452 | 458752 | 0 | 81920 | 1722810368 | 214405 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Table that contains logs of all system events. | | weight_settings | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 0 | 1722810368 | 9 | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | Table for storing Weight configuration | | weight_weights | InnoDB | 10 | Compact | 445 | 36 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | | xmlsitemap | InnoDB | 10 | Compact | 1679 | 156 | 262144 | 0 | 458752 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | The base table for xmlsitemap links. | | xmlsitemap_sitemap | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 0 | 1722810368 | NULL | 2013-04-29 23:14:14 | NULL | NULL | utf8_general_ci | NULL | | | +------------------------------------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+--------------------------------------------------------------+ 382 rows in set (0.57 sec)
I only created maybe 20 of these tables the rest was created by drupal.
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.