Difference between revisions of "Tables/template styles"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''template_styles Table (#__template_styles)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra ...)
 
(Document potential values)
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
+
== Usage ==
== Usage: ==
 
 
* Since:
 
* Since:
  
== Description: ==
+
== Description ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''template_styles Table (#__template_styles)'''
 
|+ '''template_styles Table (#__template_styles)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 16: Line 15:
 
| client_id || tinyint(1) unsigned || NOT NULL || 0  ||  ||  ||
 
| client_id || tinyint(1) unsigned || NOT NULL || 0  ||  ||  ||
 
|-
 
|-
| home      || tinyint(1) unsigned || NOT NULL || 0  ||  ||  ||
+
| home      || char(7) || NOT NULL || 0  ||  ||  ||
 
|-
 
|-
 
| title    || varchar(255)        || NOT NULL || '' ||  ||  ||
 
| title    || varchar(255)        || NOT NULL || '' ||  ||  ||
Line 25: Line 24:
 
== Notes ==
 
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
| Index Name || Column(s) || Unique?
 
| Index Name || Column(s) || Unique?
 
|-
 
|-
| idx_template || template) || No
+
| idx_template || template || No
 
|-
 
|-
 
| idx_home    || home      || No
 
| idx_home    || home      || No
 
|}
 
|}
  
*
+
* Note that the home column takes a value of 0 or 1 depending on if it's a default template. However on multilingual sites when the template is the default template for a language it takes the value of the language (e.g. fr-FR)
 +
 
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 04:15, 10 July 2019

Usage[edit]

  • Since:

Description[edit]

template_styles Table (#__template_styles)
Field Type Nullable Default Key Extra Comments
id integer unsigned NOT NULL PK auto_increment
template varchar(50) NOT NULL
client_id tinyint(1) unsigned NOT NULL 0
home char(7) NOT NULL 0
title varchar(255) NOT NULL
params varchar(2048) NOT NULL

Notes[edit]

Indices
Index Name Column(s) Unique?
idx_template template No
idx_home home No
  • Note that the home column takes a value of 0 or 1 depending on if it's a default template. However on multilingual sites when the template is the default template for a language it takes the value of the language (e.g. fr-FR)