--
-- A Cybercash stub
--
-- written by Ben Adida (ben@adida.net)

create table cybercash_stub_transactions (
       order_id				 varchar(100) not null primary key,
       card_number			 varchar(20) not null,
       card_exp				 varchar(10) not null,
       currency				 varchar(5),
       amount_auth			 numeric,
       amount_mark			 numeric,
       amount_refund			 numeric,  
       postauth_p			 char(1) default 'f' not null check (postauth_p in ('t','f')),
       return_p				 char(1) default 'f' not null check (return_p in ('t','f')),
       void_p				 char(1) default 'f' not null check (void_p in ('t','f'))
);