Revision 8beef6f5
Von Moritz Bunkus vor fast 16 Jahren hinzugefügt
| sql/Pg-upgrade2/acc_trans_without_oid.sql | ||
|---|---|---|
|
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),
|
||
Auch abrufbar als: Unified diff
Die ID sollte 64bit groß sein.