Tables/categories

Usage:

• Since:

Description:

categories Table (#__categories)

Field	Type	Nullable	Default	Key	Extra	Comments
id int	(11)	NOT NULL		PK	auto_increment	Category identifier.
asset_id	INTEGER UNSIGNED	NOT NULL	0			FK to the #__assets table
parent_id	int(10) unsigned	NOT NULL	0
lft	int(11)	NOT NULL	0
rgt	int(11)	NOT NULL	0
level	int(10) unsigned	NOT NULL	0
path	varchar(255)	NOT NULL
extension	varchar(50)	NOT NULL
title	varchar(255)	NOT NULL
alias	varchar(255)	NOT NULL
note	varchar(255)	NOT NULL
description	varchar(5120)	NOT NULL
published	tinyint(1)	NOT NULL	0
checked_out	int(11) unsigned	NOT NULL	0
checked_out_time	datetime	NOT NULL	'0000-00-00 00:00:00'
access	tinyint(3) unsigned	NOT NULL	0
params	varchar(2048)	NOT NULL
metadesc	varchar(1024)	NOT NULL				The meta description for the page.
metakey	varchar(1024)	NOT NULL				The meta keywords for the page.
metadata	varchar(2048)	NOT NULL				JSON-encoded metadata properties.
created_user_id	int(10) unsigned	NOT NULL	0
created_time	datetime	NOT NULL	'0000-00-00 00:00:00'
modified_user_id	int(10) unsigned	NOT NULL	0
modified_time	datetime	NOT NULL	'0000-00-00 00:00:00'
hits	int(10) unsigned	NOT NULL	0
language	char(7)	NOT NULL

Notes

Indices

Index Name

Column(s)

Unique?

• Default character set: utf8