+---------------------------------------------+
| Tables_in_mage |
+---------------------------------------------+
| admin_assert |
| admin_role |
| admin_rule |
| admin_user |
| adminnotification_inbox |
| api2_acl_attribute |
| api2_acl_role |
| api2_acl_rule |
| api2_acl_user |
| api_assert |
| api_role |
| api_rule |
| api_session |
| api_user |
| captcha_log |
| catalog_category_anc_categs_index_idx |
| catalog_category_anc_categs_index_tmp |
| catalog_category_anc_products_index_idx |
| catalog_category_anc_products_index_tmp |
| catalog_category_entity |
| catalog_category_entity_datetime |
| catalog_category_entity_decimal |
| catalog_category_entity_int |
| catalog_category_entity_text |
| catalog_category_entity_varchar |
| catalog_category_flat_store_1 |
| catalog_category_flat_store_2 |
| catalog_category_flat_store_3 |
| catalog_category_flat_store_4 |
| catalog_category_product |
| catalog_category_product_index |
| catalog_category_product_index_enbl_idx |
| catalog_category_product_index_enbl_tmp |
| catalog_category_product_index_idx |
| catalog_compare_item |
| catalog_eav_attribute |
| catalog_product_bundle_option |
| catalog_product_bundle_option_value |
| catalog_product_bundle_price_index |
| catalog_product_bundle_selection |
| catalog_product_bundle_selection_price |
| catalog_product_bundle_stock_index |
| catalog_product_enabled_index |
| catalog_product_entity |
| catalog_product_entity_datetime |
| catalog_product_entity_decimal |
| catalog_product_entity_gallery |
| catalog_product_entity_group_price |
| catalog_product_entity_int |
| catalog_product_entity_media_gallery |
| catalog_product_entity_media_gallery_value |
| catalog_product_entity_text |
| catalog_product_entity_tier_price |
| catalog_product_entity_varchar |
| catalog_product_flat_1 |
| catalog_product_flat_2 |
| catalog_product_flat_3 |
| catalog_product_flat_4 |
| catalog_product_index_eav |
| catalog_product_index_eav_decimal |
| catalog_product_index_eav_decimal_idx |
| catalog_product_index_eav_decimal_tmp |
| catalog_product_index_eav_idx |
| catalog_product_index_eav_tmp |
| catalog_product_index_group_price |
| catalog_product_index_price |
| catalog_product_index_price_bundle_idx |
| catalog_product_index_price_bundle_opt_idx |
| catalog_product_index_price_bundle_opt_tmp |
| catalog_product_index_price_bundle_sel_idx |
| catalog_product_index_price_bundle_sel_tmp |
| catalog_product_index_price_bundle_tmp |
| catalog_product_index_price_cfg_opt_agr_idx |
| catalog_product_index_price_cfg_opt_agr_tmp |
| catalog_product_index_price_cfg_opt_idx |
| catalog_product_index_price_cfg_opt_tmp |
| catalog_product_index_price_downlod_idx |
| catalog_product_index_price_downlod_tmp |
| catalog_product_index_price_final_idx |
| catalog_product_index_price_final_tmp |
| catalog_product_index_price_idx |
| catalog_product_index_price_opt_agr_idx |
| catalog_product_index_price_opt_agr_tmp |
| catalog_product_index_price_opt_idx |
| catalog_product_index_price_opt_tmp |
| catalog_product_index_price_tmp |
| catalog_product_index_tier_price |
| catalog_product_index_website |
| catalog_product_link |
| catalog_product_link_attribute |
| catalog_product_link_attribute_decimal |
| catalog_product_link_attribute_int |
| catalog_product_link_attribute_varchar |
| catalog_product_link_type |
| catalog_product_option |
| catalog_product_option_price |
| catalog_product_option_title |
| catalog_product_option_type_price |
| catalog_product_option_type_title |
| catalog_product_option_type_value |
| catalog_product_relation |
| catalog_product_super_attribute |
| catalog_product_super_attribute_label |
| catalog_product_super_attribute_pricing |
| catalog_product_super_link |
| catalog_product_website |
| cataloginventory_stock |
| cataloginventory_stock_item |
| cataloginventory_stock_status |
| cataloginventory_stock_status_idx |
| cataloginventory_stock_status_tmp |
| catalogrule |
| catalogrule_affected_product |
| catalogrule_customer_group |
| catalogrule_group_website |
| catalogrule_product |
| catalogrule_product_price |
| catalogrule_website |
| catalogsearch_fulltext |
| catalogsearch_query |
| catalogsearch_result |
| checkout_agreement |
| checkout_agreement_store |
| chronopay_api_debug |
| cms_block |
| cms_block_store |
| cms_page |
| cms_page_store |
| core_cache |
| core_cache_option |
| core_cache_tag |
| core_config_data |
| core_email_queue |
| core_email_queue_recipients |
| core_email_template |
| core_flag |
| core_layout_link |
| core_layout_update |
| core_resource |
| core_session |
| core_store |
| core_store_group |
| core_translate |
| core_url_rewrite |
| core_variable |
| core_variable_value |
| core_website |
| coupon_aggregated |
| coupon_aggregated_order |
| coupon_aggregated_updated |
| cron_schedule |
| customer_address_entity |
| customer_address_entity_datetime |
| customer_address_entity_decimal |
| customer_address_entity_int |
| customer_address_entity_text |
| customer_address_entity_varchar |
| customer_eav_attribute |
| customer_eav_attribute_website |
| customer_entity |
| customer_entity_datetime |
| customer_entity_decimal |
| customer_entity_int |
| customer_entity_text |
| customer_entity_varchar |
| customer_form_attribute |
| customer_group |
| cybermut_api_debug |
| dataflow_batch |
| dataflow_batch_export |
| dataflow_batch_import |
| dataflow_import_data |
| dataflow_profile |
| dataflow_profile_history |
| dataflow_session |
| design_change |
| directory_country |
| directory_country_format |
| directory_country_region |
| directory_country_region_name |
| directory_currency_rate |
| downloadable_link |
| downloadable_link_price |
| downloadable_link_purchased |
| downloadable_link_purchased_item |
| downloadable_link_title |
| downloadable_sample |
| downloadable_sample_title |
| eav_attribute |
| eav_attribute_group |
| eav_attribute_label |
| eav_attribute_option |
| eav_attribute_option_value |
| eav_attribute_set |
| eav_entity |
| eav_entity_attribute |
| eav_entity_datetime |
| eav_entity_decimal |
| eav_entity_int |
| eav_entity_store |
| eav_entity_text |
| eav_entity_type |
| eav_entity_varchar |
| eav_form_element |
| eav_form_fieldset |
| eav_form_fieldset_label |
| eav_form_type |
| eav_form_type_entity |
| eway_api_debug |
| flo2cash_api_debug |
| gift_message |
| googlecheckout_notification |
| googleoptimizer_code |
| googleshopping_attributes |
| googleshopping_items |
| googleshopping_types |
| ideal_api_debug |
| importexport_importdata |
| index_event |
| index_process |
| index_process_event |
| log_customer |
| log_quote |
| log_summary |
| log_summary_type |
| log_url |
| log_url_info |
| log_visitor |
| log_visitor_info |
| log_visitor_online |
| mf_shippingrule |
| mf_shippingrule_product_attribute |
| newsletter_problem |
| newsletter_queue |
| newsletter_queue_link |
| newsletter_queue_store_link |
| newsletter_subscriber |
| newsletter_template |
| oauth_consumer |
| oauth_nonce |
| oauth_token |
| paybox_api_debug |
| paybox_question_number |
| paypal_cert |
| paypal_payment_transaction |
| paypal_settlement_report |
| paypal_settlement_report_row |
| persistent_session |
| poll |
| poll_answer |
| poll_store |
| poll_vote |
| product_alert_price |
| product_alert_stock |
| protx_api_debug |
| rating |
| rating_entity |
| rating_option |
| rating_option_vote |
| rating_option_vote_aggregated |
| rating_store |
| rating_title |
| report_compared_product_index |
| report_event |
| report_event_types |
| report_viewed_product_aggregated_daily |
| report_viewed_product_aggregated_monthly |
| report_viewed_product_aggregated_yearly |
| report_viewed_product_index |
| review |
| review_detail |
| review_entity |
| review_entity_summary |
| review_status |
| review_store |
| sales_bestsellers_aggregated_daily |
| sales_bestsellers_aggregated_monthly |
| sales_bestsellers_aggregated_yearly |
| sales_billing_agreement |
| sales_billing_agreement_order |
| sales_flat_creditmemo |
| sales_flat_creditmemo_comment |
| sales_flat_creditmemo_grid |
| sales_flat_creditmemo_item |
| sales_flat_invoice |
| sales_flat_invoice_comment |
| sales_flat_invoice_grid |
| sales_flat_invoice_item |
| sales_flat_order |
| sales_flat_order_address |
| sales_flat_order_grid |
| sales_flat_order_item |
| sales_flat_order_payment |
| sales_flat_order_status_history |
| sales_flat_quote |
| sales_flat_quote_address |
| sales_flat_quote_address_item |
| sales_flat_quote_item |
| sales_flat_quote_item_option |
| sales_flat_quote_payment |
| sales_flat_quote_shipping_rate |
| sales_flat_shipment |
| sales_flat_shipment_comment |
| sales_flat_shipment_grid |
| sales_flat_shipment_item |
| sales_flat_shipment_track |
| sales_invoiced_aggregated |
| sales_invoiced_aggregated_order |
| sales_order_aggregated_created |
| sales_order_aggregated_updated |
| sales_order_status |
| sales_order_status_label |
| sales_order_status_state |
| sales_order_tax |
| sales_order_tax_item |
| sales_payment_transaction |
| sales_recurring_profile |
| sales_recurring_profile_order |
| sales_refunded_aggregated |
| sales_refunded_aggregated_order |
| sales_shipping_aggregated |
| sales_shipping_aggregated_order |
| salesrule |
| salesrule_coupon |
| salesrule_coupon_usage |
| salesrule_customer |
| salesrule_customer_group |
| salesrule_label |
| salesrule_product_attribute |
| salesrule_website |
| sendfriend_log |
| shipping_tablerate |
| sitemap |
| social_facebook_actions |
| strikeiron_tax_rate |
| tag |
| tag_properties |
| tag_relation |
| tag_summary |
| tax_calculation |
| tax_calculation_rate |
| tax_calculation_rate_title |
| tax_calculation_rule |
| tax_class |
| tax_order_aggregated_created |
| tax_order_aggregated_updated |
| weee_discount |
| weee_tax |
| widget |
| widget_instance |
| widget_instance_page |
| widget_instance_page_layout |
| wishlist |
| wishlist_item |
| wishlist_item_option |
| xmlconnect_application |
| xmlconnect_config_data |
| xmlconnect_history |
| xmlconnect_images |
| xmlconnect_notification_template |
| xmlconnect_queue |
+---------------------------------------------+
+------------------------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+----------------------+------+-----+---------+-------+
| attribute_id | smallint(5) unsigned | NO | PRI | NULL | |
| is_visible | smallint(5) unsigned | NO | | 1 | |
| input_filter | varchar(255) | YES | | NULL | |
| multiline_count | smallint(5) unsigned | NO | | 1 | |
| validate_rules | text | YES | | NULL | |
| is_system | smallint(5) unsigned | NO | | 0 | |
| sort_order | int(10) unsigned | NO | | 0 | |
| data_model | varchar(255) | YES | | NULL | |
| is_used_for_customer_segment | int(10) unsigned | NO | | 0 | |
+------------------------------+----------------------+------+-----+---------+-------+
+--------------+------------+--------------+-----------------+----------------------------------------------------------------+-----------+------------+----------------------------------+------------------------------+
| attribute_id | is_visible | input_filter | multiline_count | validate_rules | is_system | sort_order | data_model | is_used_for_customer_segment |
+--------------+------------+--------------+-----------------+----------------------------------------------------------------+-----------+------------+----------------------------------+------------------------------+
| 1 | 1 | NULL | 0 | NULL | 1 | 10 | NULL | 0 |
| 2 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 3 | 1 | NULL | 0 | NULL | 1 | 20 | NULL | 0 |
| 4 | 0 | NULL | 0 | NULL | 0 | 30 | NULL | 0 |
| 5 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 40 | NULL | 1 |
| 6 | 1 | NULL | 0 | NULL | 1 | 50 | NULL | 0 |
| 7 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 60 | NULL | 1 |
| 8 | 0 | NULL | 0 | NULL | 0 | 70 | NULL | 0 |
| 9 | 1 | NULL | 0 | a:1:{s:16:"input_validation";s:5:"email";} | 1 | 80 | NULL | 1 |
| 10 | 1 | NULL | 0 | NULL | 1 | 25 | NULL | 1 |
| 11 | 0 | date | 0 | a:1:{s:16:"input_validation";s:4:"date";} | 0 | 90 | NULL | 1 |
| 12 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 13 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 1 |
| 14 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 1 |
| 15 | 0 | NULL | 0 | a:1:{s:15:"max_text_length";i:255;} | 0 | 100 | NULL | 0 |
| 16 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 17 | 0 | datetime | 0 | NULL | 0 | 0 | NULL | 1 |
| 18 | 0 | NULL | 0 | a:0:{} | 0 | 110 | NULL | 1 |
| 19 | 0 | NULL | 0 | NULL | 0 | 10 | NULL | 0 |
| 20 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 20 | NULL | 1 |
| 21 | 1 | NULL | 0 | NULL | 1 | 30 | NULL | 0 |
| 22 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 40 | NULL | 1 |
| 23 | 0 | NULL | 0 | NULL | 0 | 50 | NULL | 0 |
| 24 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 60 | NULL | 1 |
| 25 | 1 | NULL | 2 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 70 | NULL | 1 |
| 26 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 80 | NULL | 1 |
| 27 | 1 | NULL | 0 | NULL | 1 | 90 | NULL | 1 |
| 28 | 1 | NULL | 0 | NULL | 1 | 100 | NULL | 0 |
| 29 | 1 | NULL | 0 | NULL | 1 | 100 | NULL | 1 |
| 30 | 1 | NULL | 0 | a:0:{} | 1 | 110 | customer/attribute_data_postcode | 1 |
| 31 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 120 | NULL | 1 |
| 32 | 1 | NULL | 0 | a:2:{s:15:"max_text_length";i:255;s:15:"min_text_length";i:1;} | 1 | 130 | NULL | 0 |
| 33 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 34 | 0 | NULL | 0 | a:1:{s:16:"input_validation";s:4:"date";} | 1 | 0 | NULL | 0 |
| 35 | 1 | NULL | 0 | NULL | 1 | 28 | NULL | 0 |
| 36 | 1 | NULL | 0 | NULL | 1 | 140 | NULL | 0 |
| 37 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 38 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 39 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 40 | 0 | NULL | 0 | NULL | 1 | 0 | NULL | 0 |
| 149 | 0 | NULL | 1 | NULL | 0 | 0 | NULL | 0 |
| 150 | 0 | NULL | 1 | NULL | 0 | 0 | NULL | 0 |
+--------------+------------+--------------+-----------------+----------------------------------------------------------------+-----------+------------+----------------------------------+------------------------------+
eav_entity
+------------------+----------------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+----------------------+------+-----+---------------------+-----------------------------+
| entity_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| entity_type_id | smallint(5) unsigned | NO | MUL | 0 | |
| attribute_set_id | smallint(5) unsigned | NO | | 0 | |
| increment_id | varchar(50) | YES | | NULL | |
| parent_id | int(10) unsigned | NO | | 0 | |
| store_id | smallint(5) unsigned | NO | MUL | 0 | |
| created_at | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| updated_at | timestamp | NO | | 0000-00-00 00:00:00 | |
| is_active | smallint(5) unsigned | NO | | 1 | |
+------------------+----------------------+------+-----+---------------------+-----------------------------+
+------------------+----------------+--------------------+------------+
| attribute_set_id | entity_type_id | attribute_set_name | sort_order |
+------------------+----------------+--------------------+------------+
| 1 | 1 | Default | 1 |
| 2 | 2 | Default | 1 |
| 3 | 3 | Default | 1 |
| 4 | 4 | Default | 1 |
| 5 | 5 | Default | 1 |
| 6 | 6 | Default | 1 |
| 7 | 7 | Default | 1 |
| 8 | 8 | Default | 1 |
| 10 | 4 | Books & Music | 0 |
| 11 | 4 | Accessories | 0 |
| 12 | 4 | Bed & Bath | 0 |
| 13 | 4 | Clothing | 0 |
| 14 | 4 | Electronics | 0 |
| 15 | 4 | Eyewear | 0 |
| 16 | 4 | Home & Decor | 0 |
| 17 | 4 | Jewelry | 0 |
| 18 | 4 | Shoes | 0 |
| 19 | 4 | caps | 0 |
| 20 | 4 | My Attribute Set | 0 |
+------------------+----------------+--------------------+------------+
eav_attribute
+-----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------------------+------+-----+---------+----------------+
| attribute_id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| entity_type_id | smallint(5) unsigned | NO | MUL | 0 | |
| attribute_code | varchar(255) | YES | | NULL | |
| attribute_model | varchar(255) | YES | | NULL | |
| backend_model | varchar(255) | YES | | NULL | |
| backend_type | varchar(8) | NO | | static | |
| backend_table | varchar(255) | YES | | NULL | |
| frontend_model | varchar(255) | YES | | NULL | |
| frontend_input | varchar(50) | YES | | NULL | |
| frontend_label | varchar(255) | YES | | NULL | |
| frontend_class | varchar(255) | YES | | NULL | |
| source_model | varchar(255) | YES | | NULL | |
| is_required | smallint(5) unsigned | NO | | 0 | |
| is_user_defined | smallint(5) unsigned | NO | | 0 | |
| default_value | text | YES | | NULL | |
| is_unique | smallint(5) unsigned | NO | | 0 | |
| note | varchar(255) | YES | | NULL | |
+-----------------+----------------------+------+-----+---------+----------------+
+----------------+-----------------------------+----------------------------------------------+--------------+----------------------------------------+----------------+--------------------------------------------+
| entity_type_id | attribute_code | backend_model | backend_type | frontend_model | frontend_input | source_model |
+----------------+-----------------------------+----------------------------------------------+--------------+----------------------------------------+----------------+--------------------------------------------+
| 1 | confirmation | NULL | varchar | NULL | text | NULL |
| 1 | created_at | NULL | static | NULL | datetime | NULL |
| 1 | created_in | NULL | varchar | NULL | text | NULL |
| 1 | default_billing | customer/customer_attribute_backend_billing | int | NULL | text | NULL |
| 1 | default_shipping | customer/customer_attribute_backend_shipping | int | NULL | text | NULL |
| 1 | disable_auto_group_change | customer/attribute_backend_data_boolean | static | NULL | boolean | NULL |
| 1 | dob | eav/entity_attribute_backend_datetime | datetime | eav/entity_attribute_frontend_datetime | date | NULL |
| 1 | email | NULL | static | NULL | text | NULL |
| 1 | firstname | NULL | varchar | NULL | text | NULL |
| 1 | gender | NULL | int | NULL | select | eav/entity_attribute_source_table |
| 1 | group_id | NULL | static | NULL | select | customer/customer_attribute_source_group |
| 1 | lastname | NULL | varchar | NULL | text | NULL |
| 1 | middlename | NULL | varchar | NULL | text | NULL |
| 1 | password_hash | customer/customer_attribute_backend_password | varchar | NULL | hidden | NULL |
| 1 | prefix | NULL | varchar | NULL | text | NULL |
| 1 | reward_update_notification | NULL | int | NULL | text | NULL |
| 1 | reward_warning_notification | NULL | int | NULL | text | NULL |
| 1 | rp_token | NULL | varchar | NULL | hidden | NULL |
| 1 | rp_token_created_at | NULL | datetime | NULL | date | NULL |
| 1 | store_id | customer/customer_attribute_backend_store | static | NULL | select | customer/customer_attribute_source_store |
| 1 | suffix | NULL | varchar | NULL | text | NULL |
| 1 | taxvat | NULL | varchar | NULL | text | NULL |
| 1 | website_id | customer/customer_attribute_backend_website | static | NULL | select | customer/customer_attribute_source_website |
+----------------+-----------------------------+----------------------------------------------+--------------+----------------------------------------+----------------+--------------------------------------------+
+----------+----------------+--------------+-----------+---------------------------------------------------------------------+
| value_id | entity_type_id | attribute_id | entity_id | value |
+----------+----------------+--------------+-----------+---------------------------------------------------------------------+
| 320 | 1 | 5 | 24 | Jack |
| 322 | 1 | 7 | 24 | Fitz |
| 325 | 1 | 12 | 24 | 4fe96cf8b888c1f20e1726450896940a2cea453128c51fa07539536a4205e12b:t6 |
| 326 | 1 | 3 | 24 | Admin |
| 328 | 1 | 5 | 25 | Mark |
+----------+----------------+--------------+-----------+---------------------------------------------------------------------+