Photo Organizer

user_preferences

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

• owner references users(identifier)

None.

None.

* user_preferences_owner_idx

* get_user_pref

None.

Version 2.5

Still in use

= 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
);