X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/34e9d819b0e4e99e49523accbb0b08b80788d68b..574c32c009b187782497bf170204dc7a8976b2e0:/sql/Pg-upgrade2/units_id.sql

diff --git a/sql/Pg-upgrade2/units_id.sql b/sql/Pg-upgrade2/units_id.sql
new file mode 100644
index 000000000..0b20ebb67
--- /dev/null
+++ b/sql/Pg-upgrade2/units_id.sql
@@ -0,0 +1,6 @@
+-- @tag: units_id
+-- @description: ID-Spalte für Tabelle "units"
+-- @depends: release_2_6_2
+-- @charset: utf-8
+ALTER TABLE units ADD COLUMN id serial;
+ALTER TABLE units ADD CONSTRAINT units_id_unique UNIQUE (id);