· 7 years ago · Sep 18, 2018, 01:44 PM
1-- Adminer 4.6.3 PostgreSQL dump
2
3DROP TABLE IF EXISTS "venues";
4DROP SEQUENCE IF EXISTS venues_id_seq;
5CREATE SEQUENCE venues_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
6
7CREATE TABLE "public"."venues" (
8 "id" integer DEFAULT nextval('venues_id_seq') NOT NULL,
9 "phone_number" text NOT NULL,
10 "name" text NOT NULL,
11 "payment_code" text NOT NULL,
12 "address_street" text DEFAULT '',
13 "gps_latitude" double precision DEFAULT '0.0',
14 "gps_longitude" double precision DEFAULT '0.0',
15 "default_receive_phone" text DEFAULT '',
16 "updated_at" timestamptz DEFAULT now(),
17 "deleted" boolean DEFAULT false,
18 "category" text DEFAULT '',
19 "account_types" integer[] DEFAULT '{}',
20 "bank_account_number" text DEFAULT '',
21 "bank_account_code" text DEFAULT '',
22 "venue_type" integer DEFAULT '0',
23 "address_number" text DEFAULT '',
24 "address_city" text DEFAULT '',
25 "address_psc" text DEFAULT '',
26 "email" text,
27 CONSTRAINT "unique_totoro_code" UNIQUE ("payment_code"),
28 CONSTRAINT "venues_pk" PRIMARY KEY ("id")
29) WITH (oids = false);
30
31
32-- 2018-09-18 12:37:07.748668+00
33INSERT INTO "venues" ("id", "phone_number", "name", "payment_code", "address_street", "gps_latitude", "gps_longitude", "default_receive_phone", "updated_at", "deleted", "category", "account_types", "bank_account_number", "bank_account_code", "venue_type", "address_number", "address_city", "address_psc", "email") VALUES
34(1107, '420000000000', 'StudioArt.cz', 'studioartcz', 'Ulice', 0, 0, '420000000000', '2018-06-03 15:29:32.345+00', 'f', 'PPDIPA', {}, '123', '2010', 0, '3', 'Praha', '17000', 'landsman@studioart.cz');