1 |
492 |
vperunova |
create table payments_cards |
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 |
|
|
uid integer not null, |
9 |
|
|
type integer not null, |
10 |
|
|
number text, |
11 |
|
|
name text, |
12 |
|
|
month integer not null, |
13 |
|
|
year integer not null, |
14 |
|
|
cvv_cvc text, |
15 |
|
|
sections integer not null, |
16 |
|
|
data text |
17 |
|
|
); |
18 |
|
|
CREATE INDEX payments_cards_number ON payments_cards USING btree (number); |