Tables/template styles: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
m Remove erroneous character |
Document potential values |
||
| Line 15: | Line 15: | ||
| client_id || tinyint(1) unsigned || NOT NULL || 0 || || || | | client_id || tinyint(1) unsigned || NOT NULL || 0 || || || | ||
|- | |- | ||
| home || | | home || char(7) || NOT NULL || 0 || || || | ||
|- | |- | ||
| title || varchar(255) || NOT NULL || '' || || || | | title || varchar(255) || NOT NULL || '' || || || | ||
| Line 34: | Line 34: | ||
|} | |} | ||
* | * 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> | <noinclude>[[Category:Database]]</noinclude> | ||
Latest revision as of 09:15, 10 July 2019
Usage
- Since:
Description
| 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
| 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)