Probleme mit Primary Key in orderitems behoben

[mfinanz.git] / sql / lx-office.sql

diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index 240803396ca033465638eeda868ead1eebc7e720..439b119bb8f43d0d22757bdfdbe936234741d476 100644 (file)
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -397,7 +397,7 @@ CREATE TABLE "orderitems" (
        "reqdate" date,
        "ship" real,
        "serialnumber" text,
-       "id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
+       "id" integer DEFAULT nextval('orderitemsid'::text),
         "itime" timestamp DEFAULT now(),
         "mtime" timestamp,
         "pricegroup_id" integer,