/ - Diff - projekt kivitendo - wissen

« Zurück | Weiter »

Revision ca247333

Von Moritz Bunkus vor fast 5 Jahren hinzugefügt

ID ca247333e470aefad12228a8a17c7d76bc598c74
Vorgänger 16d5a584
Nachfolger 53db54a8

Unterstützung für PostgreSQL 12 Teil 2

PostgreSQL 12 unterstützt OIDs nicht mehr. Daher die letzten Stellen
umgestellt, an denen noch OIDs verwendet wurden.

       assemblies                     => {
         type         => 'one to many',
         class        => 'SL::DB::Assembly',
         manager_args => { sort_by => 'position, oid' },
         manager_args => { sort_by => 'position' },
         column_map   => { id => 'id' },
       },
       prices         => {

           my $sortorder = "";
           if ($form->{groupitems}) {
             $sortorder =
               qq|ORDER BY pg.partsgroup, a.oid|;
               qq|ORDER BY pg.partsgroup, a.id|;
           } else {
             $sortorder = qq|ORDER BY a.oid|;
             $sortorder = qq|ORDER BY a.id|;
+          }
           do_statement($form, $h_pg, $q_pg, conv_i($form->{"id_$i"}));

             my $sortorder = "";
             if ($form->{groupitems}) {
               $sortorder =
                 qq|ORDER BY pg.partsgroup, a.oid|;
                 qq|ORDER BY pg.partsgroup, a.id|;
             } else {
               $sortorder = qq|ORDER BY a.oid|;
               $sortorder = qq|ORDER BY a.id|;
+            }
             my $query =

             # get parts and push them onto the stack
             my $sortorder = "";
             if ($form->{groupitems}) {
               $sortorder = qq|ORDER BY pg.partsgroup, a.oid|;
               $sortorder = qq|ORDER BY pg.partsgroup, a.id|;
             } else {
               $sortorder = qq|ORDER BY a.oid|;
               $sortorder = qq|ORDER BY a.id|;
+            }
             $query = qq|SELECT p.partnumber, p.description, p.unit, a.qty, | .

     -- @description: Einführen einer ID-Spalte in acc_trans
     -- @depends: release_2_4_3 cb_ob_transaction
     -- INFO: Dieses Script hat früher die Spalte acc_trans_id aus der
     -- impliziten OID gesetzt. PostgreSQL 12 unterstützt aber keine OIDs
     -- mehr, daher wurde die OID hier entfernt. Das ist insofern auch kein
     -- Problem, weil dieses Upgrade-Script in Version 2.6.0 benutzt wurde,
     -- und direkte Updates auf die aktuelle kivitendo-Version von vor 3.0
     -- eh nicht mehr unterstützt werden.
     --
     -- Das Script muss aber trotzdem beim Anlegen neuer Datenbanken
     -- abgearbeitet werden und daher funktionieren.
     CREATE SEQUENCE acc_trans_id_seq;
     CREATE TABLE new_acc_trans (
-...
         mtime timestamp without time zone
     );
     INSERT INTO new_acc_trans (acc_trans_id, trans_id, chart_id, amount, transdate, gldate, source, cleared,
     INSERT INTO new_acc_trans (trans_id, chart_id, amount, transdate, gldate, source, cleared,
                                fx_transaction, ob_transaction, cb_transaction, project_id, memo, taxkey, itime, mtime)
       SELECT oid, trans_id, chart_id, amount, transdate, gldate, source, cleared,
       SELECT trans_id, chart_id, amount, transdate, gldate, source, cleared,
         fx_transaction, ob_transaction, cb_transaction, project_id, memo, taxkey, itime, mtime
       FROM acc_trans;
     SELECT setval('acc_trans_id_seq', (SELECT COALESCE((SELECT MAX(oid::integer) FROM acc_trans), 0) + 1));
     DROP TABLE acc_trans;
     ALTER TABLE new_acc_trans RENAME TO acc_trans;

       FOREIGN KEY (parts_id)          REFERENCES parts (id),
       FOREIGN KEY (project_id)        REFERENCES project (id),
       FOREIGN KEY (price_factor_id)   REFERENCES price_factors (id)
     ) WITH OIDS;
     );
     CREATE TRIGGER mtime_delivery_order_items_id BEFORE UPDATE ON delivery_order_items
         FOR EACH ROW EXECUTE PROCEDURE set_mtime();

     --
     --
     -- TOC entry 5 (OID 1981863)
     -- Name: id; Type: SEQUENCE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 7 (OID 1981865)
     -- Name: glid; Type: SEQUENCE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 13 (OID 1981867)
     -- Name: gl; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 14 (OID 1981879)
     -- Name: chart; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 15 (OID 1981890)
     -- Name: datev; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 16 (OID 1981893)
     -- Name: gifi; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 17 (OID 1981898)
     -- Name: parts; Type: TABLE; Schema: public; Owner: postgres
     --
-...
         not_discountable boolean DEFAULT false,
         buchungsgruppen_id integer,
         payment_id integer
     ) WITH OIDS;
     );
     --
     -- TOC entry 18 (OID 1981915)
     -- Name: defaults; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 19 (OID 1981924)
     -- Name: audittrail; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 20 (OID 1981930)
     -- Name: acc_trans; Type: TABLE; Schema: public; Owner: postgres
     --
-...
         taxkey integer,
         itime timestamp without time zone DEFAULT now(),
         mtime timestamp without time zone
     ) WITH OIDS;
     );
     --
     -- TOC entry 21 (OID 1981944)
     -- Name: invoice; Type: TABLE; Schema: public; Owner: postgres
     --
-...
         base_qty real,
         subtotal boolean DEFAULT false,
         longdescription text
     ) WITH OIDS;
     );
     --
     -- TOC entry 22 (OID 1981958)
     -- Name: vendor; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 23 (OID 1981969)
     -- Name: customer; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 24 (OID 1981982)
     -- Name: contacts; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 25 (OID 1981991)
     -- Name: assembly; Type: TABLE; Schema: public; Owner: postgres
     --
-...
         bom boolean,
         itime timestamp without time zone DEFAULT now(),
         mtime timestamp without time zone
     ) WITH OIDS;
     );
     --
     -- TOC entry 26 (OID 1981994)
     -- Name: ar; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 27 (OID 1982012)
     -- Name: ap; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 28 (OID 1982030)
     -- Name: partstax; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 29 (OID 1982033)
     -- Name: tax; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 30 (OID 1982039)
     -- Name: customertax; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 31 (OID 1982042)
     -- Name: vendortax; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 32 (OID 1982045)
     -- Name: oe; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 33 (OID 1982058)
     -- Name: orderitems; Type: TABLE; Schema: public; Owner: postgres
     --
-...
         base_qty real,
         subtotal boolean DEFAULT false,
         longdescription text
     ) WITH OIDS;
     );
     --
     -- TOC entry 34 (OID 1982069)
     -- Name: exchangerate; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 35 (OID 1982072)
     -- Name: employee; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 36 (OID 1982083)
     -- Name: shipto; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 37 (OID 1982089)
     -- Name: project; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 38 (OID 1982100)
     -- Name: partsgroup; Type: TABLE; Schema: public; Owner: postgres
     --
-...
         partsgroup text,
         itime timestamp without time zone DEFAULT now(),
         mtime timestamp without time zone
     ) WITH OIDS;
     );
     --
     -- TOC entry 39 (OID 1982107)
     -- Name: makemodel; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 40 (OID 1982113)
     -- Name: status; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 9 (OID 1982121)
     -- Name: invoiceid; Type: SEQUENCE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 11 (OID 1982123)
     -- Name: orderitemsid; Type: SEQUENCE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 41 (OID 1982125)
     -- Name: warehouse; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 42 (OID 1982134)
     -- Name: inventory; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 43 (OID 1982137)
     -- Name: department; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 44 (OID 1982145)
     -- Name: dpt_trans; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 45 (OID 1982148)
     -- Name: business; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 46 (OID 1982158)
     -- Name: sic; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 47 (OID 1982164)
     -- Name: license; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 48 (OID 1982174)
     -- Name: licenseinvoice; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 49 (OID 1982176)
     -- Name: pricegroup; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 50 (OID 1982184)
     -- Name: prices; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 51 (OID 1982194)
     -- Name: finanzamt; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 157 (OID 1982885)
     -- Name: check_department(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 158 (OID 1982886)
     -- Name: del_department(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 159 (OID 1982887)
     -- Name: del_customer(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 160 (OID 1982888)
     -- Name: del_vendor(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 161 (OID 1982889)
     -- Name: del_exchangerate(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 162 (OID 1982890)
     -- Name: check_inventory(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 163 (OID 1982968)
     -- Name: set_datevexport(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 164 (OID 1982971)
     -- Name: set_mtime(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 52 (OID 1983721)
     -- Name: language; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 53 (OID 1983730)
     -- Name: payment_terms; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 54 (OID 1983739)
     -- Name: translation; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 55 (OID 1983745)
     -- Name: units; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 56 (OID 1983761)
     -- Name: rma; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 57 (OID 1983774)
     -- Name: rmaitems; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 58 (OID 1983785)
     -- Name: printers; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 59 (OID 1983798)
     -- Name: tax_zones; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 60 (OID 1983807)
     -- Name: buchungsgruppen; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 61 (OID 1983825)
     -- Name: dunning_config; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 62 (OID 1983833)
     -- Name: dunning; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 165 (OID 1983838)
     -- Name: set_priceupdate_parts(); Type: FUNCTION; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 63 (OID 1983846)
     -- Name: leads; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 64 (OID 1983849)
     -- Name: taxkeys; Type: TABLE; Schema: public; Owner: postgres
     --
-...
     --
     -- Data for TOC entry 171 (OID 1981915)
     -- Name: defaults; Type: TABLE DATA; Schema: public; Owner: postgres
     --
     INSERT INTO "defaults" ("version", "curr") VALUES ('2.4.0.0', 'EUR:USD');
     --
     -- Data for TOC entry 204 (OID 1982194)
     -- Name: finanzamt; Type: TABLE DATA; Schema: public; Owner: postgres
     --
-...
     --
     -- Data for TOC entry 208 (OID 1983745)
     -- Name: units; Type: TABLE DATA; Schema: public; Owner: postgres
     --
-...
     --
     -- Data for TOC entry 212 (OID 1983798)
     -- Name: tax_zones; Type: TABLE DATA; Schema: public; Owner: postgres
     --
-...
     INSERT INTO tax_zones (id, description) VALUES (3, 'Außerhalb EU');
     --
     -- TOC entry 143 (OID 1982173)
     -- Name: license_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 84 (OID 1982891)
     -- Name: acc_trans_trans_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 82 (OID 1982892)
     -- Name: acc_trans_chart_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 85 (OID 1982893)
     -- Name: acc_trans_transdate_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 83 (OID 1982894)
     -- Name: acc_trans_source_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 110 (OID 1982895)
     -- Name: ap_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 115 (OID 1982896)
     -- Name: ap_transdate_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 111 (OID 1982897)
     -- Name: ap_invnumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 112 (OID 1982898)
     -- Name: ap_ordnumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 116 (OID 1982899)
     -- Name: ap_vendor_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 109 (OID 1982900)
     -- Name: ap_employee_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 103 (OID 1982901)
     -- Name: ar_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 108 (OID 1982902)
     -- Name: ar_transdate_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 104 (OID 1982903)
     -- Name: ar_invnumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 105 (OID 1982904)
     -- Name: ar_ordnumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 101 (OID 1982905)
     -- Name: ar_customer_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 102 (OID 1982906)
     -- Name: ar_employee_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 100 (OID 1982907)
     -- Name: assembly_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 74 (OID 1982908)
     -- Name: chart_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 71 (OID 1982909)
     -- Name: chart_accno_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 72 (OID 1982910)
     -- Name: chart_category_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 75 (OID 1982911)
     -- Name: chart_link_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 73 (OID 1982912)
     -- Name: chart_gifi_accno_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 96 (OID 1982913)
     -- Name: customer_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 118 (OID 1982914)
     -- Name: customer_customer_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 95 (OID 1982915)
     -- Name: customer_customernumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 97 (OID 1982916)
     -- Name: customer_name_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 94 (OID 1982917)
     -- Name: customer_contact_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 128 (OID 1982918)
     -- Name: employee_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 129 (OID 1982919)
     -- Name: employee_login_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 130 (OID 1982920)
     -- Name: employee_name_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 127 (OID 1982921)
     -- Name: exchangerate_ct_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 77 (OID 1982922)
     -- Name: gifi_accno_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 67 (OID 1982923)
     -- Name: gl_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 70 (OID 1982924)
     -- Name: gl_transdate_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 69 (OID 1982925)
     -- Name: gl_reference_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 65 (OID 1982926)
     -- Name: gl_description_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 66 (OID 1982927)
     -- Name: gl_employee_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 86 (OID 1982928)
     -- Name: invoice_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 88 (OID 1982929)
     -- Name: invoice_trans_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 121 (OID 1982930)
     -- Name: oe_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 124 (OID 1982931)
     -- Name: oe_transdate_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 122 (OID 1982932)
     -- Name: oe_ordnumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 120 (OID 1982933)
     -- Name: oe_employee_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 126 (OID 1982934)
     -- Name: orderitems_trans_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 79 (OID 1982935)
     -- Name: parts_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 80 (OID 1982936)
     -- Name: parts_partnumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 78 (OID 1982937)
     -- Name: parts_description_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 117 (OID 1982938)
     -- Name: partstax_parts_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 90 (OID 1982939)
     -- Name: vendor_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 91 (OID 1982940)
     -- Name: vendor_name_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 93 (OID 1982941)
     -- Name: vendor_vendornumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 89 (OID 1982942)
     -- Name: vendor_contact_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 119 (OID 1982943)
     -- Name: vendortax_vendor_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 132 (OID 1982944)
     -- Name: shipto_trans_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 133 (OID 1982945)
     -- Name: project_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 107 (OID 1982946)
     -- Name: ar_quonumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 114 (OID 1982947)
     -- Name: ap_quonumber_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 138 (OID 1982948)
     -- Name: makemodel_parts_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 136 (OID 1982949)
     -- Name: makemodel_make_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 137 (OID 1982950)
     -- Name: makemodel_model_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 139 (OID 1982951)
     -- Name: status_trans_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 141 (OID 1982952)
     -- Name: department_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 125 (OID 1982953)
     -- Name: orderitems_id_key; Type: INDEX; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 68 (OID 1981877)
     -- Name: gl_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 76 (OID 1981888)
     -- Name: chart_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 81 (OID 1981913)
     -- Name: parts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 87 (OID 1981952)
     -- Name: invoice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 92 (OID 1981967)
     -- Name: vendor_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 98 (OID 1981980)
     -- Name: customer_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 99 (OID 1981989)
     -- Name: contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 106 (OID 1982006)
     -- Name: ar_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 113 (OID 1982024)
     -- Name: ap_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 123 (OID 1982056)
     -- Name: oe_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 131 (OID 1982081)
     -- Name: employee_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 134 (OID 1982096)
     -- Name: project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 135 (OID 1982098)
     -- Name: project_projectnumber_key; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 140 (OID 1982132)
     -- Name: warehouse_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 142 (OID 1982156)
     -- Name: business_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 144 (OID 1982171)
     -- Name: license_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 145 (OID 1982182)
     -- Name: pricegroup_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 146 (OID 1983728)
     -- Name: language_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 147 (OID 1983737)
     -- Name: payment_terms_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 148 (OID 1983747)
     -- Name: units_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 149 (OID 1983772)
     -- Name: rma_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 150 (OID 1983791)
     -- Name: printers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 151 (OID 1983813)
     -- Name: buchungsgruppen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 152 (OID 1983831)
     -- Name: dunning_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 153 (OID 1983836)
     -- Name: dunning_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 154 (OID 1983852)
     -- Name: taxkeys_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 219 (OID 1981940)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 220 (OID 1981954)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 221 (OID 1982008)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 222 (OID 1982026)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 223 (OID 1982065)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 224 (OID 1982186)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 225 (OID 1982190)
     -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 226 (OID 1983749)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...
     --
     -- TOC entry 227 (OID 1983781)
     -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
     --
-...

... Dieser Diff wurde abgeschnitten, weil er die maximale Anzahl anzuzeigender Zeilen überschreitet.

Auch abrufbar als: Unified diff

Projekt

Allgemein

Profil

projekt kivitendo

Revision ca247333

Von Moritz Bunkus vor fast 5 Jahren hinzugefügt