
31 May
2002
31 May
'02
11 a.m.
in the file "OpenTRS-schema.mysql.sql", the table "user_preferences" is describe like this : CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (100) NOT NULL, preferences_value VARCHAR (250), PRIMARY KEY(user_id) ); it's better to describe like this : CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (100) NOT NULL, preferences_value VARCHAR (250), PRIMARY KEY(user_id,preferences_key) ); else we can't save user preference because there is an "ERROR 1062: Duplicate entry '2' for key 1" in this table