From 2d72b516f1fe724cff4efd8fe23c1629c98f36ac Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Mon, 23 Jan 2006 15:36:31 +0000 Subject: [PATCH] Bugfix 165: Projektnummern muessen jetzt eindeutig sein. --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 4 +++- sql/lx-office.sql | 2 +- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/sql/Pg-upgrade-2.1.1-2.1.2.sql b/sql/Pg-upgrade-2.1.1-2.1.2.sql index 0f6d7f425..53b7fe077 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -320,4 +320,6 @@ INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573 update defaults set version = '2.1.2'; - +-- +-- add unqiue constraint to project +ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); diff --git a/sql/lx-office.sql b/sql/lx-office.sql index ca5b1d35e..76267264b 100644 --- a/sql/lx-office.sql +++ b/sql/lx-office.sql @@ -453,7 +453,7 @@ CREATE TABLE "shipto" ( CREATE TABLE "project" ( "id" integer DEFAULT nextval('id'::text) PRIMARY KEY, - "projectnumber" text, + "projectnumber" text UNIQUE, "description" text, "itime" timestamp DEFAULT now(), "mtime" timestamp -- 2.20.1