]> wagnertech.de Git - mfinanz.git/blob - sql/Pg-upgrade2/file_versions_guid_as_primary_key.sql
restart apache2 in postinst
[mfinanz.git] / sql / Pg-upgrade2 / file_versions_guid_as_primary_key.sql
1 -- @tag: file_versions_guid_as_primary_key
2 -- @description: guid-Spalte als Primärschlüssel
3 -- @depends: release_3_6_0 file_version
4
5 ALTER TABLE file_versions
6    DROP CONSTRAINT  file_versions_pkey,
7    ADD  UNIQUE      (guid),
8    ADD  PRIMARY KEY (guid);