Advertisement
a-harvie

Output: SHOW COLUMNS FROM catalog_product_flat_1

Nov 14th, 2015
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 5.29 KB | None | 0 0
  1. entity_id int(10) unsigned  NO  PRI NULL  
  2. attribute_set_id  smallint(5) unsigned  NO  MUL 0
  3. type_id varchar(32) NO  MUL simple  
  4. cost  decimal(12,4) YES   NULL  
  5. created_at  timestamp YES   NULL  
  6. custom_design_from  datetime  YES   NULL  
  7. custom_design_to  datetime  YES   NULL  
  8. custom_layout_update  text  YES   NULL  
  9. description text  YES   NULL  
  10. dimension text  YES   NULL  
  11. enable_googlecheckout smallint(6) YES   NULL  
  12. gallery varchar(255)  YES   NULL  
  13. gift_message_available  smallint(6) YES   NULL  
  14. has_options smallint(6) NO    0
  15. image varchar(255)  YES   NULL  
  16. image_label varchar(255)  YES   NULL  
  17. is_recurring  smallint(6) YES   NULL  
  18. links_exist int(11) YES   NULL  
  19. links_purchased_separately  int(11) YES   NULL  
  20. links_title varchar(255)  YES   NULL  
  21. manufacturer  int(11) YES   NULL  
  22. manufacturer_value  varchar(255)  YES   NULL  
  23. media_gallery varchar(255)  YES   NULL  
  24. meta_description  varchar(255)  YES   NULL  
  25. meta_keyword  text  YES   NULL  
  26. meta_title  varchar(255)  YES   NULL  
  27. minimal_price decimal(12,4) YES   NULL  
  28. msrp  decimal(12,4) YES   NULL  
  29. msrp_display_actual_price_type  varchar(255)  YES   NULL  
  30. msrp_enabled  smallint(6) YES   NULL  
  31. name  varchar(255)  YES MUL NULL  
  32. news_from_date  datetime  YES   NULL  
  33. news_to_date  datetime  YES   NULL  
  34. old_id  int(11) YES   NULL  
  35. price decimal(12,4) YES MUL NULL  
  36. price_type  int(11) YES   NULL  
  37. price_view  int(11) YES   NULL  
  38. recurring_profile text  YES   NULL  
  39. required_options  smallint(5) unsigned  NO    0
  40. samples_title varchar(255)  YES   NULL  
  41. shipment_type int(11) YES   NULL  
  42. short_description text  YES   NULL  
  43. sku varchar(64) YES   NULL  
  44. sku_type  int(11) YES   NULL  
  45. small_image varchar(255)  YES   NULL  
  46. small_image_label varchar(255)  YES   NULL  
  47. special_from_date datetime  YES   NULL  
  48. special_price decimal(12,4) YES   NULL  
  49. special_to_date datetime  YES   NULL  
  50. tax_class_id  int(10) unsigned  YES   NULL  
  51. thumbnail varchar(255)  YES   NULL  
  52. thumbnail_label varchar(255)  YES   NULL  
  53. updated_at  timestamp YES   NULL  
  54. url_key varchar(255)  YES   NULL  
  55. url_path  varchar(255)  YES   NULL  
  56. visibility  smallint(5) unsigned  YES   NULL  
  57. weight  decimal(12,4) YES   NULL  
  58. weight_type int(11) YES   NULL  
  59. compatible_radio_model  varchar(255)  YES   NULL  
  60. product_promotions  text  YES   NULL  
  61. average_battery_life  varchar(255)  YES   NULL  
  62. connector_type  int(11) YES   NULL  
  63. connector_type_value  varchar(255)  YES   NULL  
  64. mesh_networking varchar(255)  YES   NULL  
  65. wireless_security varchar(255)  YES   NULL  
  66. motorola_impress  int(11) YES   NULL  
  67. motorola_impress_value  varchar(255)  YES   NULL  
  68. satellite_prod_type int(11) YES   NULL  
  69. satellite_prod_type_value varchar(255)  YES   NULL  
  70. battery_amps  varchar(255)  YES   NULL  
  71. battery_volts varchar(255)  YES   NULL  
  72. cordless_type varchar(255)  YES   NULL  
  73. form_factor varchar(255)  YES   NULL  
  74. interfaces_supported  varchar(255)  YES   NULL  
  75. light_source  varchar(255)  YES   NULL  
  76. scan_engine varchar(255)  YES   NULL  
  77. series  varchar(255)  YES   NULL  
  78. applications  varchar(255)  YES   NULL  
  79. audio varchar(255)  YES   NULL  
  80. badge_battery varchar(255)  YES   NULL  
  81. barcode_reader  varchar(255)  YES   NULL  
  82. development_tools varchar(255)  YES   NULL  
  83. dimensions  varchar(255)  YES   NULL  
  84. display varchar(255)  YES   NULL  
  85. drop_specs  varchar(255)  YES   NULL  
  86. front_camera  varchar(255)  YES   NULL  
  87. gps varchar(255)  YES   NULL  
  88. management_tools  varchar(255)  YES   NULL  
  89. memory  varchar(255)  YES   NULL  
  90. motion_sensor varchar(255)  YES   NULL  
  91. notification  varchar(255)  YES   NULL  
  92. operating_system  varchar(255)  YES   NULL  
  93. peripherals varchar(255)  YES   NULL  
  94. rear_camera varchar(255)  YES   NULL  
  95. sealing varchar(255)  YES   NULL  
  96. storage_expansions  varchar(255)  YES   NULL  
  97. tablet_battery  varchar(255)  YES   NULL  
  98. touchpanel  varchar(255)  YES   NULL  
  99. video varchar(255)  YES   NULL  
  100. wlan  varchar(255)  YES   NULL  
  101. wpan  varchar(255)  YES   NULL  
  102. line_of_sight varchar(255)  YES   NULL  
  103. max_data_rate int(11) YES   NULL  
  104. max_data_rate_value varchar(255)  YES   NULL  
  105. sap_sync  smallint(6) YES   NULL  
  106. moto_bc_barcode_dimension varchar(255)  YES   NULL  
  107. moto_bc_connectivity  varchar(255)  YES   NULL  
  108. moto_bc_scan_engine int(11) YES   NULL  
  109. moto_bc_scan_engine_value varchar(255)  YES   NULL  
  110. moto_bc_symbology_supported varchar(255)  YES   NULL  
  111. moto_bc_warranty  varchar(255)  YES   NULL  
  112. moto_kiosk_connection_type  int(11) YES   NULL  
  113. moto_kiosk_connection_type_value  varchar(255)  YES   NULL  
  114. moto_kiosk_flash_memory varchar(255)  YES   NULL  
  115. moto_kiosk_operating_system varchar(255)  YES   NULL  
  116. wlan_ap_ctrl_required int(11) YES   NULL  
  117. wlan_ap_ctrl_required_value varchar(255)  YES   NULL  
  118. wlan_ap_radio_qty int(11) YES   NULL  
  119. wlan_ap_radio_qty_value varchar(255)  YES   NULL  
  120. freeshipping  int(11) YES   NULL  
  121. freeshipping_value  varchar(255)  YES   NULL  
  122. intrinsically_safe  int(11) YES MUL NULL  
  123. intrinsically_safe_value  varchar(255)  YES MUL NULL  
  124. radio_technology  int(11) YES   NULL  
  125. radio_technology_value  varchar(255)  YES   NULL  
  126. body_depth  varchar(255)  YES   NULL  
  127. case_options  varchar(255)  YES   NULL  
  128. internal_dimensions varchar(255)  YES   NULL  
  129. lid_depth varchar(255)  YES   NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement