Line # Revision Author
1 328 ahitrov create table monetaru_transactions
2 (
3 id integer not null primary key default nextval('public.documents_id_seq'::text),
4 class text not null,
5 ctime timestamp not null default now(),
6 mtime timestamp not null default now(),
7 status smallint not null default 0,
8 name text,
9 account_id numeric,
10 order_id integer not null,
11 operation_id numeric not null,
12 currency_code varchar(4),
13 sum float,
14 account_user text,
15 payment_system text,
16 account_corr text,
17 329 ahitrov data text
18 328 ahitrov );
19 CREATE INDEX monetaru_transactions_operations ON monetaru_transactions USING btree (operation_id);
20 CREATE INDEX monetaru_transactions_orders ON monetaru_transactions USING btree (order_id);