Line # Revision Author
1 693 ahitrov create sequence money_movements_id_seq;
2 select setval('money_movements_id_seq', 1, true);
3
4 create table money_movements
5 (
6 id integer not null primary key default nextval('public.documents_id_seq'::text),
7 class text not null,
8 ctime timestamp not null default now(),
9 mtime timestamp not null default now(),
10 dtime timestamp not null default now(),
11 status smallint not null default 0,
12 provider text,
13 session_id text,
14 name text,
15 order_id integer not null,
16 currency_code varchar(4),
17 sum float,
18 success smallint default 0,
19 data text
20 );
21 CREATE INDEX money_movements_sessions ON money_movements USING btree (provider, session_id) WHERE session_id is not null;
22 CREATE INDEX money_movements_orders ON money_movements USING btree (order_id);