Table layout boxes

From Zen Cart(tm) Wiki
Jump to: navigation, search

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

layout_id

Indexed Fields

layout_template
layout_box_name
layout_box_status


Columns

layout_id Primary Key

A unique, auto incremented value, to identify each layout boxes record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


layout_template Index

The template that the layout box is configured in.
Type: varchar(64)
Null: No
Default:


layout_box_name Index

The name of the layout box which matches the filename in the modules/sideboxes folder.
Type: varchar(64)
Null: No
Default:


layout_box_status Index

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