From: Stephan Köhler Date: Mon, 23 Jan 2006 17:05:19 +0000 (+0000) Subject: Nachtrag r825, Reihenfolge DB-Schemata X-Git-Tag: release-2.4.0^2~360 X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/commitdiff_plain/f164578c6049cefc4adc5bbb3000dd8ae65a65ca?ds=inline Nachtrag r825, Reihenfolge DB-Schemata --- 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';