kivitendo/sql/Pg-upgrade2/user_preferences.sql @ 7b1da9c3
| 8d24868f | Sven Schöling | -- @tag: user_preferences
|
|
-- @description: Benutzereinstellungen
|
|||
-- @depends: release_3_4_1
|
|||
CREATE TABLE user_preferences (
|
|||
id SERIAL PRIMARY KEY,
|
|||
login TEXT NOT NULL,
|
|||
namespace TEXT NOT NULL,
|
|||
version NUMERIC(15,5),
|
|||
key TEXT NOT NULL,
|
|||
value TEXT,
|
|||
UNIQUE (login, namespace, version, key)
|
|||
);
|