From f164578c6049cefc4adc5bbb3000dd8ae65a65ca Mon Sep 17 00:00:00 2001 From: =?utf8?q?Stephan=20K=C3=B6hler?= Date: Mon, 23 Jan 2006 17:05:19 +0000 Subject: [PATCH] Nachtrag r825, Reihenfolge DB-Schemata --- sql/Pg-upgrade-2.1.1-2.1.2.sql | 4 ++-- 1 file changed, 2 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 53b7fe077..694f1e408 100644 --- a/sql/Pg-upgrade-2.1.1-2.1.2.sql +++ b/sql/Pg-upgrade-2.1.1-2.1.2.sql @@ -318,8 +318,8 @@ INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1773'),'0.16','1773 INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.07','1572','18','Steuerpfl. EG-Erwerb 7%'); INSERT INTO tax VALUES ((SELECT id FROM chart WHERE accno = '1572'),'0.16','1573','19','Steuerpfl. EG-Erwerb 16%'); -update defaults set version = '2.1.2'; - -- -- add unqiue constraint to project ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); + +update defaults set version = '2.1.2'; -- 2.20.1