From 3d38b57220a6302f34d31b332c1b680569493ab9 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 16 May 2006 09:22:36 +0000 Subject: - Patch #41481 by Zen, Cvbge, sun et al: bugfix: duplicate key error while editing locale strings. --- database/database.pgsql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'database/database.pgsql') diff --git a/database/database.pgsql b/database/database.pgsql index c2449b591..4729a99eb 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -378,9 +378,9 @@ CREATE TABLE locales_target ( translation text DEFAULT '' NOT NULL, locale varchar(12) NOT NULL default '', plid int4 NOT NULL default '0', - plural int4 NOT NULL default '0', - UNIQUE (lid) + plural int4 NOT NULL default '0' ); +CREATE INDEX locales_target_lid_idx ON locales_target(lid); CREATE INDEX locales_target_locale_idx ON locales_target(locale); CREATE INDEX locales_target_plid_idx ON locales_target(plid); CREATE INDEX locales_target_plural_idx ON locales_target(plural); -- cgit v1.2.3