X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/6ff01fdb61880344c2826c86955ef4c1e8f47db4..0bc6b1d1f9b96054d9ae4098930ec186be8d7738:/sql/Pg-upgrade2/acc_trans_without_oid.sql diff --git a/sql/Pg-upgrade2/acc_trans_without_oid.sql b/sql/Pg-upgrade2/acc_trans_without_oid.sql index 04a39fca1..ef2e931b2 100644 --- a/sql/Pg-upgrade2/acc_trans_without_oid.sql +++ b/sql/Pg-upgrade2/acc_trans_without_oid.sql @@ -1,11 +1,11 @@ -- @tag: acc_trans_without_oid --- @description: Einführen einer ID-Spalte in acc_trans +-- @description: Einführen einer ID-Spalte in acc_trans -- @depends: release_2_4_3 cb_ob_transaction CREATE SEQUENCE acc_trans_id_seq; CREATE TABLE new_acc_trans ( - acc_trans_id integer DEFAULT nextval('acc_trans_id_seq'), + acc_trans_id bigint DEFAULT nextval('acc_trans_id_seq'), trans_id integer, chart_id integer, amount numeric(15,5),