copy of db 'structure' for 'products' showing facebook_add at bottom of list
Browse
Structure
SQL
Search
Insert
Export
Import
Operations
Triggers
# Name Type Collation Attributes Null Default Extra Action
1 products_id int(11) No None AUTO_INCREMENT Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
2 products_type int(11) No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
3 products_quantity float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
4 products_model varchar(32) latin1_general_ci Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
5 products_image varchar(64) latin1_general_ci Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
6 products_price decimal(15,4) No 0.0000 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
7 products_virtual tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
8 products_date_added datetime No 0001-01-01 00:00:00 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
9 products_last_modified datetime Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
10 products_date_available datetime Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
11 products_weight float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
12 products_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
13 products_tax_class_id int(11) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
14 manufacturers_id int(11) Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
15 products_ordered float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
16 products_quantity_order_min float No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
17 products_quantity_order_units float No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
18 products_priced_by_attribute tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
19 product_is_free tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
20 product_is_call tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
21 products_quantity_mixed tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
22 product_is_always_free_shipping tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
23 products_qty_box_status tinyint(1) No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
24 products_quantity_order_max float No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
25 products_sort_order int(11) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
26 products_discount_type tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
27 products_discount_type_from tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
28 products_price_sorter decimal(15,4) No 0.0000 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
29 master_categories_id int(11) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
30 products_mixed_discount_quantity tinyint(1) No 1 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
31 metatags_title_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
32 metatags_products_name_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
33 metatags_model_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
34 metatags_price_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
35 metatags_title_tagline_status tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
36 facebook_add tinyint(1) No 0 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Show more actions More
With selected: Check All / Uncheck All With selected:


Reply With Quote
