Skip to content

Instantly share code, notes, and snippets.

@dalizard

dalizard/gist:964598

Created May 10, 2011 14:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dalizard/964598 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dalizard/964598 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sls
mysql> desc items;
+-----------------------------------+-----------------------------------------------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------------+-----------------------------------------------------------+------+-----+-------------------+-----------------------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| parent_id | bigint(20) unsigned | YES | MUL | NULL | |
| sku | varchar(50) | NO | UNI | NULL | |
| store_price | decimal(13,3) | NO | | 0.000 | |
| cost | decimal(12,2) unsigned | NO | | 0.00 | |
| retail_price | decimal(12,2) | NO | | 0.00 | |
| brand | varchar(150) | YES | | NULL | |
| model | varchar(150) | YES | | NULL | |
| reviews_auto_approve | tinyint(1) | YES | | NULL | |
| reviews_require_login | tinyint(1) | YES | | NULL | |
| reviews_votes_require_login | tinyint(1) | YES | | NULL | |
| short_description | text | YES | | NULL | |
| description | longtext | YES | | NULL | |
| store_quantity | int(11) | NO | | NULL | |
| active | tinyint(1) | NO | | 1 | |
| inventory_control | enum('','backorder','in_stock_email','hide','no_control') | NO | | | |
| updated | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| min_quantity | int(11) | YES | | 0 | |
| order_quantity | int(11) | YES | | 0 | |
| default_supplier | bigint(20) unsigned | YES | MUL | NULL | |
| automatic_order | tinyint(4) | YES | | 0 | |
| deleted | tinyint(1) | NO | | 0 | |
| created | datetime | NO | | NULL | |
| flag_type | varchar(20) | YES | | NULL | |
| html_title | text | YES | | NULL | |
| meta_description | text | YES | | NULL | |
| meta_keywords | text | YES | | NULL | |
| keywords | text | YES | | NULL | |
| template | varchar(50) | YES | | NULL | |
| template_header | varchar(50) | YES | | NULL | |
| template_body | varchar(50) | YES | | NULL | |
| template_footer | varchar(50) | YES | | NULL | |
| tax_schedule_id | bigint(20) unsigned | NO | MUL | 1 | |
| no_stock_value | tinyint(4) | YES | | 0 | |
| type | varchar(30) | NO | | fixed | |
| has_product_variants | tinyint(1) | NO | | 0 | |
| item_group_id | bigint(20) unsigned | NO | MUL | 1 | |
| reviews_enabled | tinyint(1) | YES | | NULL | |
| min_order_quantity | int(10) unsigned | NO | | 1 | |
| max_order_quantity | int(10) unsigned | NO | | 0 | |
| sort_order | bigint(20) unsigned | NO | | 1 | |
| popularity | float | NO | | 1 | |
| sale_price | decimal(13,3) unsigned | YES | | NULL | |
| sale_start | datetime | YES | | NULL | |
| sale_end | datetime | YES | | NULL | |
| sale_name | varchar(255) | YES | | NULL | |
| sale_price_type | enum('fixed','percents') | YES | | fixed | |
| sale_note | varchar(255) | YES | | NULL | |
| ebay_quantity | int(11) | NO | | 0 | |
| exclude_from_search | tinyint(1) | NO | | 0 | |
| exclude_from_ws_download | tinyint(1) | NO | | 0 | |
| exclude_from_loose_matches | tinyint(1) | NO | | 0 | |
| exclude_from_recommendations | tinyint(1) | NO | | 0 | |
| exclude_from_frontend | tinyint(1) | NO | | 0 | |
| bundle_auto_disabled | text | YES | | NULL | |
| volume_price_group_children | tinyint(1) | NO | | -1 | |
| reviews_rank | bigint(20) | YES | | NULL | |
| pricing_visibility | enum('visible','email','cart') | NO | | visible | |
| file_alias_item_sku | varchar(50) | YES | | NULL | |
| reviews_rating | float(2,1) | YES | | NULL | |
| reviews_count | bigint(20) | NO | | 0 | |
| image_alt | varchar(255) | YES | | NULL | |
| use_default_image_for_thumb | tinyint(1) | NO | | 0 | |
| coupon_action_exempt | tinyint(4) unsigned | NO | | 0 | |
| coupon_condition_exempt | tinyint(4) unsigned | NO | | 0 | |
| image_path | varchar(255) | YES | | NULL | |
| rss_featured | tinyint(3) unsigned | NO | MUL | 0 | |
| promo_floor_margin_percent | decimal(10,2) | NO | | NULL | |
| promo_discount_percent_override | decimal(10,2) | NO | | NULL | |
| price_prefix | varchar(255) | YES | | NULL | |
| price_suffix | varchar(255) | YES | | NULL | |
| parent_layout | enum('grid','selectable') | YES | | NULL | |
| parent_child_notes | text | YES | | NULL | |
| parent_sort_order | varchar(1000) | YES | | NULL | |
| parent_profile_id | bigint(20) unsigned | YES | MUL | NULL | |
| application | varchar(150) | YES | | NULL | |
| warehouse | varchar(250) | YES | | NULL | |
| location | varchar(250) | YES | | NULL | |
| drop_shipper_id | bigint(20) unsigned | YES | MUL | NULL | |
| file_id | bigint(20) | YES | | NULL | |
| shipping_alone | tinyint(1) unsigned | NO | | 0 | |
| no_free_shipping_coupons | tinyint(1) unsigned | NO | | 0 | |
| no_free_shipping_total | tinyint(1) unsigned | NO | | 0 | |
| shipping_handling | decimal(13,3) | NO | | 0.000 | |
| weight | decimal(13,3) | NO | | 0.000 | |
| needs_shipping | tinyint(1) | NO | | 1 | |
| free_shipping | tinyint(1) | NO | | 0 | |
| free_shipping_at_store_price_only | tinyint(1) | NO | | 0 | |
| free_shipping_available | tinyint(1) | NO | | 0 | |
| color | varchar(100) | YES | | NULL | |
| size | varchar(100) | YES | | NULL | |
| gender | varchar(255) | YES | | NULL | |
| cart_status_message | varchar(255) | YES | | NULL | |
| fabric_and_care | text | YES | | NULL | |
| no_returns | tinyint(1) | NO | | 0 | |
| territory_restrictions | enum('unrestricted','usa_only','custom') | NO | | unrestricted | |
| autoresponder_email_from | varchar(200) | YES | | NULL | |
| autoresponder_email_subject | varchar(250) | YES | | NULL | |
| autoresponder_email_body | longtext | YES | | NULL | |
| autoresponder_enabled | tinyint(4) unsigned | NO | | 0 | |
| site1_store_price | decimal(13,3) | YES | | NULL | |
| site1_cost | decimal(13,3) | YES | | NULL | |
| site1_active | tinyint(1) unsigned | YES | | NULL | |
| site0_store_price | decimal(13,3) | YES | | NULL | |
| site0_cost | decimal(13,3) | YES | | NULL | |
| site0_active | tinyint(1) unsigned | YES | | NULL | |
| site2_store_price | decimal(13,3) | YES | | NULL | |
| site2_cost | decimal(13,3) | YES | | NULL | |
| site2_active | tinyint(1) unsigned | YES | | NULL | |
+-----------------------------------+-----------------------------------------------------------+------+-----+-------------------+-----------------------------+
109 rows in set (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment