Print view - phpMyAdmin 4.8.4

fuel_archives

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
ref_id	int(10)	No
table_name	varchar(50)	No
data	text	No
version	smallint(5)	No
version_timestamp	timestamp	No	CURRENT_TIMESTAMP
archived_user_id	int(10)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	3	A	No

fuel_blocks

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	smallint(5)	No
name	varchar(100)	No
description	varchar(255)	No
view	text	No
language	varchar(30)	No	english
published	enum('yes', 'no')	No	yes
date_added	datetime	Yes	NULL
last_modified	timestamp	Yes	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
name	BTREE	Yes	No	name	0	A	No
name	BTREE	Yes	No	language	0	A	No

fuel_categories

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(11)	No
name	varchar(255)	No
slug	varchar(255)	No
description	text	No
context	varchar(100)	No
language	varchar(30)	No	english
precedence	int(11)	No
parent_id	int(11)	No
published	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
slug	BTREE	Yes	No	slug	0	A	No

fuel_logs

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
entry_date	datetime	No
user_id	int(11)	No
message	text	No
type	varchar(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	5	A	No

fuel_navigation

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
location	varchar(255)	No			The part of the path after the domain name that you want the link to go to (e.g. company/about_us)
group_id	int(5)	No	1
nav_key	varchar(255)	No			The nav key is a friendly ID that you can use for setting the selected state. If left blank, a default value will be set for you.
label	varchar(255)	No			The name you want to appear in the menu
parent_id	int(10)	No	0		Used for creating menu hierarchies. No value means it is a root level menu item
precedence	int(10)	No	0		The higher the number, the greater the precedence and farther up the list the navigational element will appear
attributes	varchar(255)	No			Extra attributes that can be used for navigation implementation
selected	varchar(255)	No			The pattern to match for the active state. Most likely you leave this field blank
hidden	enum('yes', 'no')	No	no		A hidden value can be used in rendering the menu. In some areas, the menu item may not want to be displayed
language	varchar(30)	No	english
published	enum('yes', 'no')	No	yes		Determines whether the item is displayed or not

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1	A	No
group_id_nav_key_language	BTREE	Yes	No	group_id	1	A	No
				nav_key	1	A	No
				language	1	A	No

fuel_navigation_groups

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(3)	No
name	varchar(255)	No
published	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1	A	No
name	BTREE	Yes	No	name	1	A	No

fuel_pages

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
location	varchar(255)	No			Add the part of the url after the root of your site (usually after the domain name). For the homepage, just put the word 'home'
layout	varchar(50)	No			The name of the template to associate with this page
published	enum('yes', 'no')	No	yes		A 'yes' value will display the page and an 'no' value will give a 404 error message
cache	enum('yes', 'no')	No	yes		Cache controls whether the page will pull from the database or from a saved file which is more efficient. If a page has content that is dynamic, it's best to set cache to 'no'
date_added	datetime	Yes	NULL
last_modified	timestamp	Yes	CURRENT_TIMESTAMP
last_modified_by	int(10)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1	A	No
location	BTREE	Yes	No	location	1	A	No
layout	BTREE	No	No	layout	1	A	No

fuel_page_variables

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
page_id	int(10)	No
name	varchar(50)	No
scope	varchar(255)	No
value	longtext	No
type	enum('string', 'int', 'boolean', 'array')	No	string
language	varchar(30)	No	english
active	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	7	A	No
page_id	BTREE	Yes	No	page_id	2	A	No
				name	7	A	No
				language	7	A	No

fuel_permissions

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
description	varchar(255)	No
name	varchar(50)	No			In most cases, this should be the name of the module (e.g. news)
active	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	35	A	No
name	BTREE	Yes	No	name	35	A	No

fuel_relationships

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint(20)	No
candidate_table	varchar(100)	Yes
candidate_key	int(11)	No
foreign_table	varchar(100)	Yes	NULL
foreign_key	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
unique_key	BTREE	Yes	No	candidate_table	0	A	Yes
				candidate_key	0	A	No
				foreign_table	0	A	Yes
				foreign_key	0	A	No
candidate_table	BTREE	No	No	candidate_table	0	A	Yes
candidate_table	BTREE	No	No	candidate_key	0	A	No
foreign_table	BTREE	No	No	foreign_table	0	A	Yes
foreign_table	BTREE	No	No	foreign_key	0	A	No

fuel_settings

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	bigint(20)	No
module	varchar(50)	No
key	varchar(50)	No
value	longtext	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
module	BTREE	Yes	No	module	0	A	No
module	BTREE	Yes	No	key	0	A	No

fuel_site_variables

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
name	varchar(100)	No
value	text	No
scope	varchar(255)	No			leave blank if you want the variable to be available to all pages
active	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
name	BTREE	Yes	No	name	0	A	No

fuel_tags

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
name	varchar(50)	No
category_id	int(10)	No
slug	varchar(255)	No
description	text	No
context	varchar(100)	No
language	varchar(30)	No	english
precedence	int(11)	No
published	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
slug	BTREE	Yes	No	slug	0	A	No

fuel_users

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(10)	No
user_name	varchar(30)	No
password	varchar(64)	No
email	varchar(100)	No
first_name	varchar(30)	No
last_name	varchar(30)	No
language	varchar(30)	No
reset_key	varchar(64)	No
salt	varchar(32)	No
super_admin	enum('yes', 'no')	No	no
active	enum('yes', 'no')	No	yes

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1	A	No
email	BTREE	Yes	No	email	1	A	No

Open new phpMyAdmin window

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.