User Tools

Site Tools


podoc:user_preferences_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

podoc:user_preferences_sql_table [2007/10/19 11:19] (current)
Luud created
Line 1: Line 1:
 +===== Database Table Description of "​user_preferences"​ =====
  
 +=== Name ===
 +
 +user_preferences
 +
 +=== Description ===
 +
 +=== Purpose ===
 +
 +=== Schema ===
 +
 +<code sql>
 +create table user_preferences (
 +        owner integer not null references users(identifier),​
 +        key varchar(100) not null,
 +        value text
 +);
 +</​code>​
 +
 +=== References tables ===
 +
 +  * owner references [[users sql table|users]](identifier)
 +
 +=== Is referenced by tables ===
 +
 +None.
 +
 +=== Related sequences ===
 +
 +None.
 +
 +=== Related indexes ===
 +
 + * [[user_preferences_owner_idx sql index|user_preferences_owner_idx]]
 +
 +=== Related functions ===
 +
 + * [[get_user_pref sql function|get_user_pref]]
 +
 +=== Related views ===
 +
 +None.
 +
 +=== History ===
 +
 +== Used first ==
 +
 +Version 2.5
 +
 +== Used last ==
 +
 +Still in use
 +
 +== Schema change history ==
 +
 += Version 2.34 =
 +
 +<code sql>
 +-- key=value user preferences
 +create table user_preferences (
 +        owner integer not null references users(identifier),​
 +        key varchar(100) not null,
 +        value text
 +);
 +</​code>​
 +
 +== Data change history ==
podoc/user_preferences_sql_table.txt ยท Last modified: 2007/10/19 11:19 by Luud