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...)
 
(class="wikitable")
Line 5: Line 5:
 
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"

Revision as of 22:18, 24 September 2011

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