Tables/user profiles
From Joomla! Documentation
< Tables(Difference between revisions)
(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.
| 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
| Index Name | Column(s) | Unique? |
| idx_user_id_profile_key | user_id, profile_key | Yes |
- Default character set: utf8
