projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Klasse für das Kivitendo Logo
[kivitendo-erp.git]
/
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
04a39fc
..
ef2e931
100644
(file)
--- 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
-- @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 (
-- @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),
trans_id integer,
chart_id integer,
amount numeric(15,5),