Actions

Difference between revisions of "Tables/user profiles"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == Simple user profile storage table. {| border="1" |+ '''user_profiles Table (#__user_profiles)''' |- bgcolor="lightgrey" | Field || Type || Nullab...)
 
m (categorisation)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
== Usage: ==
+
== Usage ==
 
* Since:
 
* Since:
  
== Description: ==
+
== Description ==
 
Simple user profile storage table.
 
Simple user profile storage table.
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''user_profiles Table (#__user_profiles)'''
 
|+ '''user_profiles Table (#__user_profiles)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 21: Line 21:
 
== Notes ==
 
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 30: Line 30:
  
 
* Default character set: '''utf8'''
 
* Default character set: '''utf8'''
 +
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 10:39, 16 March 2013

Usage

  • Since:

Description

Simple user profile storage table.

user_profiles Table (#__user_profiles)
Field Type Nullable Default Key Extra Comments
user_id int(11) NOT NULL
profile_key varchar(100) NOT NULL
profile_value varchar(255) NOT NULL
ordering int(11) NOT NULL 0

Notes

Indices
Index Name Column(s) Unique?
idx_user_id_profile_key user_id, profile_key Yes
  • Default character set: utf8