User Tools

Site Tools


podoc:user_preferences_sql_table

Database Table Description of "user_preferences"

Name

user_preferences

Description

Purpose

Schema

CREATE TABLE user_preferences (
        owner INTEGER NOT NULL REFERENCES users(identifier),
        KEY VARCHAR(100) NOT NULL,
        VALUE text
);

References tables

  • owner references users(identifier)

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.34 =

-- key=value user preferences
CREATE TABLE user_preferences (
        owner INTEGER NOT NULL REFERENCES users(identifier),
        KEY VARCHAR(100) NOT NULL,
        VALUE text
);
Data change history
podoc/user_preferences_sql_table.txt · Last modified: 2007/10/19 11:19 by Luud