From 921adf5b31fe273406ef57fc411aa680be4544e7 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Mon, 23 Jan 2006 17:11:55 +0000 Subject: [PATCH] Merge von 825,826 aus unstable: Bugfix 165 -Bugfix 165: Projektnummern muessen jetzt eindeutig sein. -Nachtrag r825, Reihenfolge DB-Schemata --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 4 ++++ sql/lx-office.sql | 2 +- 2 files changed, 5 insertions(+), 1 deletion(-) 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 8a1b97a89..5887b357c 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -253,4 +253,8 @@ alter table invoice add column transdate text; alter table invoice add column cusordnumber text; -- +-- +-- add unqiue constraint to project +ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); + update defaults set version = '2.1.2'; 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