b5JnDAEx

1DROP TABLE IF EXISTS "leads";
2CREATE TABLE "public"."leads" (
3    "id" character varying NOT NULL,
4    "date" timestamp NOT NULL,
5    "group_id" integer DEFAULT '0' NOT NULL,
6    "vk_user_id" bigint DEFAULT '0' NOT NULL,
7    "ignore" integer DEFAULT '0' NOT NULL,
8    "first_name" character varying DEFAULT '' NOT NULL,
9    "last_name" character varying DEFAULT '' NOT NULL,
10    "photo" character varying DEFAULT '' NOT NULL,
11    "sex" integer DEFAULT '0' NOT NULL,
12    "domain" character varying DEFAULT '' NOT NULL,
13    "bdate" timestamp NOT NULL,
14    "city_id" integer DEFAULT '0' NOT NULL,
15    "country_id" integer DEFAULT '0' NOT NULL,
16    CONSTRAINT "leads_id" PRIMARY KEY ("id")
17) WITH (oids = false);
18
19CREATE INDEX "leads_vk_user_id" ON "public"."leads" USING btree ("vk_user_id");
20
21DROP TABLE IF EXISTS "vars";
22CREATE TABLE "public"."vars" (
23    "id" character varying NOT NULL,
24    "key" character varying NOT NULL,
25    "value_int" integer NOT NULL,
26    "value_string" character varying NOT NULL
27) WITH (oids = false);
28
29CREATE INDEX "vars_idx" ON "public"."vars" USING hash ("id");
30
31CREATE INDEX "vars_value_int" ON "public"."vars" USING btree ("value_int");
32
33CREATE INDEX "vars_value_string" ON "public"."vars" USING btree ("value_string");