Line # Revision Author
1 270 ahitrov CREATE TABLE webshop_coupons (
2 id integer DEFAULT nextval(('public.documents_id_seq'::text)::regclass) NOT NULL,
3 ctime timestamp without time zone DEFAULT now() NOT NULL,
4 mtime timestamp without time zone DEFAULT now() NOT NULL,
5 dtime timestamp without time zone DEFAULT now() NOT NULL,
6 etime timestamp without time zone DEFAULT now() NOT NULL,
7 class text DEFAULT 'webshop::Coupon'::text NOT NULL,
8 792 ahitrov created_by integer,
9 edited_by integer,
10 270 ahitrov status smallint default 0 NOT NULL,
11 sections integer,
12 pid integer default 0,
13 uid integer default 0,
14 groups integer[],
15 name text,
16 code text not null,
17 data text
18 );
19
20 CREATE INDEX webshop_coupons_sections ON webshop_coupons USING btree (sections);
21 CREATE INDEX webshop_coupons_uid ON webshop_coupons USING btree (uid);
22 CREATE INDEX webshop_coupons_code ON webshop_coupons USING btree (code);