Table layout boxes
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores the settings for all the sidebox locations/switches from Admin > Tools > Layout Boxes Controller.
Table Details
Primary Key
Indexed Fields
Columns
layout_id 
- A unique, auto incremented value, to identify each layout boxes record.
Type: int(11) Null: No Default: Extra: auto_increment
layout_template 
- The template that the layout box is configured in.
Type: varchar(64) Null: No Default:
layout_box_name
- The name of the layout box which matches the filename in the modules/sideboxes folder.
Type: varchar(64) Null: No Default:
layout_box_status
- Determines if this sidebox is enabled or disabled in the specific template. Can be set to 0 (disabled) or 1 (enabled).
Type: tinyint(1) Null: No Default: 0
layout_box_location
- Where is the layout box located? Can be set to 0 (left) or 1 (right).
Type: tinyint(1) Null: No Default: 0
layout_box_sort_order
- What is the sort order of the specific layout box?
Type: int(11) Null: No Default: 0
layout_box_sort_order_single
- What is the sort order of the specific layout box when it is used with the single-column template code. Currently unused.
Type: int(11) Null: No Default: 0
layout_box_status_single
- Status: enabled or disabled within single-column template mode. Can be set to 0 (disabled) or 1 (enabled). Currently unused.
Type: tinyint(4) Null: No Default: 0
Default Entries
layout_id: 1 layout_template: default_template_settings layout_box_name: banner_box_all.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 5 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 2 layout_template: default_template_settings layout_box_name: banner_box.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 300 layout_box_sort_order_single: 1 layout_box_status_single: 127
layout_id: 3 layout_template: default_template_settings layout_box_name: banner_box2.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 15 layout_box_sort_order_single: 1 layout_box_status_single: 15
layout_id: 4 layout_template: default_template_settings layout_box_name: best_sellers.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 30 layout_box_sort_order_single: 70 layout_box_status_single: 1
layout_id: 5 layout_template: default_template_settings layout_box_name: categories.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 10 layout_box_sort_order_single: 10 layout_box_status_single: 1
layout_id: 6 layout_template: default_template_settings layout_box_name: currencies.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 80 layout_box_sort_order_single: 60 layout_box_status_single: 1
layout_id: 7 layout_template: default_template_settings layout_box_name: document_categories.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 8 layout_template: default_template_settings layout_box_name: ezpages.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: -1 layout_box_sort_order_single: 2 layout_box_status_single: 1
layout_id: 9 layout_template: default_template_settings layout_box_name: featured.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 45 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 10 layout_template: default_template_settings layout_box_name: information.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 50 layout_box_sort_order_single: 40 layout_box_status_single: 1
layout_id: 11 layout_template: default_template_settings layout_box_name: languages.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 70 layout_box_sort_order_single: 50 layout_box_status_single: 1
layout_id: 12 layout_template: default_template_settings layout_box_name: manufacturers.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 30 layout_box_sort_order_single: 20 layout_box_status_single: 1
layout_id: 13 layout_template: default_template_settings layout_box_name: manufacturer_info.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 35 layout_box_sort_order_single: 95 layout_box_status_single: 1
layout_id: 14 layout_template: default_template_settings layout_box_name: more_information.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 200 layout_box_sort_order_single: 200 layout_box_status_single: 1
layout_id: 15 layout_template: default_template_settings layout_box_name: music_genres.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 16 layout_template: default_template_settings layout_box_name: order_history.php layout_box_status: 0 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 17 layout_template: default_template_settings layout_box_name: product_notifications.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 55 layout_box_sort_order_single: 85 layout_box_status_single: 1
layout_id: 18 layout_template: default_template_settings layout_box_name: record_companies.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 19 layout_template: default_template_settings layout_box_name: reviews.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 40 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 20 layout_template: default_template_settings layout_box_name: search.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 10 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 21 layout_template: default_template_settings layout_box_name: search_header.php layout_box_status: 0 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 1
layout_id: 22 layout_template: default_template_settings layout_box_name: shopping_cart.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 20 layout_box_sort_order_single: 30 layout_box_status_single: 1
layout_id: 23 layout_template: default_template_settings layout_box_name: specials.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 45 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 24 layout_template: default_template_settings layout_box_name: tell_a_friend.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 65 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 25 layout_template: default_template_settings layout_box_name: whats_new.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 20 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 26 layout_template: default_template_settings layout_box_name: whos_online.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 200 layout_box_sort_order_single: 200 layout_box_status_single: 1
layout_id: 27 layout_template: template_default layout_box_name: banner_box_all.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 5 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 28 layout_template: template_default layout_box_name: banner_box.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 300 layout_box_sort_order_single: 1 layout_box_status_single: 127
layout_id: 29 layout_template: template_default layout_box_name: banner_box2.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 15 layout_box_sort_order_single: 1 layout_box_status_single: 15
layout_id: 30 layout_template: template_default layout_box_name: best_sellers.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 30 layout_box_sort_order_single: 70 layout_box_status_single: 1
layout_id: 31 layout_template: template_default layout_box_name: categories.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 10 layout_box_sort_order_single: 10 layout_box_status_single: 1
layout_id: 32 layout_template: template_default layout_box_name: currencies.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 80 layout_box_sort_order_single: 60 layout_box_status_single: 1
layout_id: 33 layout_template: template_default layout_box_name: ezpages.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: -1 layout_box_sort_order_single: 2 layout_box_status_single: 1
layout_id: 34 layout_template: template_default layout_box_name: featured.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 45 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 35 layout_template: template_default layout_box_name: information.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 50 layout_box_sort_order_single: 40 layout_box_status_single: 1
layout_id: 36 layout_template: template_default layout_box_name: languages.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 70 layout_box_sort_order_single: 50 layout_box_status_single: 1
layout_id: 37 layout_template: template_default layout_box_name: manufacturers.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 30 layout_box_sort_order_single: 20 layout_box_status_single: 1
layout_id: 38 layout_template: template_default layout_box_name: manufacturer_info.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 35 layout_box_sort_order_single: 95 layout_box_status_single: 1
layout_id: 39 layout_template: template_default layout_box_name: more_information.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 200 layout_box_sort_order_single: 200 layout_box_status_single: 1
layout_id: 40 layout_template: template_default layout_box_name: my_broken_box.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 41 layout_template: template_default layout_box_name: order_history.php layout_box_status: 0 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 42 layout_template: template_default layout_box_name: product_notifications.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 55 layout_box_sort_order_single: 85 layout_box_status_single: 1
layout_id: 43 layout_template: template_default layout_box_name: reviews.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 40 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 44 layout_template: template_default layout_box_name: search.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 10 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 45 layout_template: template_default layout_box_name: search_header.php layout_box_status: 0 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 1
layout_id: 46 layout_template: template_default layout_box_name: shopping_cart.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 20 layout_box_sort_order_single: 30 layout_box_status_single: 1
layout_id: 47 layout_template: template_default layout_box_name: specials.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 45 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 48 layout_template: template_default layout_box_name: tell_a_friend.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 65 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 49 layout_template: template_default layout_box_name: whats_new.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 20 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 50 layout_template: template_default layout_box_name: whos_online.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 200 layout_box_sort_order_single: 200 layout_box_status_single: 1
layout_id: 51 layout_template: classic layout_box_name: banner_box.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 300 layout_box_sort_order_single: 1 layout_box_status_single: 127
layout_id: 52 layout_template: classic layout_box_name: banner_box2.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 15 layout_box_sort_order_single: 1 layout_box_status_single: 15
layout_id: 53 layout_template: classic layout_box_name: banner_box_all.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 5 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 54 layout_template: classic layout_box_name: best_sellers.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 30 layout_box_sort_order_single: 70 layout_box_status_single: 1
layout_id: 55 layout_template: classic layout_box_name: categories.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 10 layout_box_sort_order_single: 10 layout_box_status_single: 1
layout_id: 56 layout_template: classic layout_box_name: currencies.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 80 layout_box_sort_order_single: 60 layout_box_status_single: 1
layout_id: 57 layout_template: classic layout_box_name: document_categories.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 58 layout_template: classic layout_box_name: ezpages.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: -1 layout_box_sort_order_single: 2 layout_box_status_single: 1
layout_id: 59 layout_template: classic layout_box_name: featured.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 45 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 60 layout_template: classic layout_box_name: information.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 50 layout_box_sort_order_single: 40 layout_box_status_single: 1
layout_id: 61 layout_template: classic layout_box_name: languages.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 70 layout_box_sort_order_single: 50 layout_box_status_single: 1
layout_id: 62 layout_template: classic layout_box_name: manufacturers.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 30 layout_box_sort_order_single: 20 layout_box_status_single: 1
layout_id: 63 layout_template: classic layout_box_name: manufacturer_info.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 35 layout_box_sort_order_single: 95 layout_box_status_single: 1
layout_id: 64 layout_template: classic layout_box_name: more_information.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 200 layout_box_sort_order_single: 200 layout_box_status_single: 1
layout_id: 65 layout_template: classic layout_box_name: music_genres.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 66 layout_template: classic layout_box_name: order_history.php layout_box_status: 0 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 67 layout_template: classic layout_box_name: product_notifications.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 55 layout_box_sort_order_single: 85 layout_box_status_single: 1
layout_id: 68 layout_template: classic layout_box_name: record_companies.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 69 layout_template: classic layout_box_name: reviews.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 40 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 70 layout_template: classic layout_box_name: search.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 10 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 71 layout_template: classic layout_box_name: search_header.php layout_box_status: 0 layout_box_location: 0 layout_box_sort_order: 0 layout_box_sort_order_single: 0 layout_box_status_single: 1
layout_id: 72 layout_template: classic layout_box_name: shopping_cart.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 20 layout_box_sort_order_single: 30 layout_box_status_single: 1
layout_id: 73 layout_template: classic layout_box_name: specials.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 45 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 74 layout_template: classic layout_box_name: tell_a_friend.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 65 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 75 layout_template: classic layout_box_name: whats_new.php layout_box_status: 1 layout_box_location: 0 layout_box_sort_order: 20 layout_box_sort_order_single: 0 layout_box_status_single: 0
layout_id: 76 layout_template: classic layout_box_name: whos_online.php layout_box_status: 1 layout_box_location: 1 layout_box_sort_order: 200 layout_box_sort_order_single: 200 layout_box_status_single: 1
