Repository List / Contenido / utf8 / plugins / money / sql / TOAST / money_checks.sql @ r694

create sequence money_checks_id_seq;
select setval('money_checks_id_seq', 1, true);

create table money_checks
(
	id integer not null primary key default nextval('public.documents_id_seq'::text),
	class text not null,
	ctime timestamp not null default now(),
	mtime timestamp not null default now(),
	dtime timestamp not null default now(),
	status smallint not null default 0,
	provider text,
	session_id text,
	name text,
	order_id integer not null,
	currency_code varchar(4),
	sum float,
	success smallint default 0,
	data text
);
CREATE INDEX money_checks_sessions ON money_checks USING btree (provider, session_id) WHERE session_id is not null;
CREATE INDEX money_checks_orders ON money_checks USING btree (order_id);