dump.sql

-- Adminer 4.6.3 PostgreSQL dump

DROP TABLE IF EXISTS "venues";
DROP SEQUENCE IF EXISTS venues_id_seq;
CREATE SEQUENCE venues_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;

CREATE TABLE "public"."venues" (
    "id" integer DEFAULT nextval('venues_id_seq') NOT NULL,
    "phone_number" text NOT NULL,
    "name" text NOT NULL,
    "payment_code" text NOT NULL,
    "address_street" text DEFAULT '',
    "gps_latitude" double precision DEFAULT '0.0',
    "gps_longitude" double precision DEFAULT '0.0',
    "default_receive_phone" text DEFAULT '',
    "updated_at" timestamptz DEFAULT now(),
    "deleted" boolean DEFAULT false,
    "category" text DEFAULT '',
    "account_types" integer[] DEFAULT '{}',
    "bank_account_number" text DEFAULT '',
    "bank_account_code" text DEFAULT '',
    "venue_type" integer DEFAULT '0',
    "address_number" text DEFAULT '',
    "address_city" text DEFAULT '',
    "address_psc" text DEFAULT '',
    "email" text,
    CONSTRAINT "unique_totoro_code" UNIQUE ("payment_code"),
    CONSTRAINT "venues_pk" PRIMARY KEY ("id")
) WITH (oids = false);


-- 2018-09-18 12:37:07.748668+00
INSERT 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
(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');